In some rare circumstances, for example, if you are debugging an
issue, you may need to manually initialize the PL/SQL layer logging for
the current session. From the SQL*Prompt, you could do this by calling: FND_GLOBAL.APPS_INITIALIZE(fnd_user_id, fnd_resp_id, fnd_appl_id); fnd_profile.put('AFLOG_ENABLED', 'Y'); fnd_profile.put('AFLOG_MODULE', '%'); fnd_profile.put('AFLOG_LEVEL','1'); fnd_log_repository.init;
If you want to enable the FND Logging for a given procedure or function. Do the following:
1. Set the user profile options for FND:Debug Log enabled to "N". This ensures that apps itself would not do any sort of logging. 2. Go ahead and put the code above in the procedure that you want to log(ideally at the beginning of the procedure). 3. After the procedure call the same code while setting the profile option AFLOG_ENABLED to "N".
This way you can get specific log for just one procedure and saves you the effort of going through tons of log messages. |