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);
Profile Option Name User Specified Name Sample Value
AFLOG_ENABLED FND: Debug Log Enabled "Y"
AFLOG_MODULE FND: Debug Log Module "%"
AFLOG_LEVEL FND: Debug Log Level "ERROR"
-- Use the following values:
-- 1 - STATEMENT
-- 2 - PROCEDURE
-- 3 - EVENT
-- 4 - EXCEPTION
-- 5 - ERROR
-- 6 - UNEXPECTED
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.
written by Praveen , April 18, 2008
written by Praveen , April 21, 2008
written by Praveen , April 22, 2008
written by kishor nagbhire , December 09, 2008