1. In the System Profile Options screen, query all FND: Debug Log profile options and set the following at user-level:

FND: Debug Log Enabled = ‘Yes’
FND: Debug Log Level = ‘Statement’
FND: Debug Log Module = ‘%’   (or limit the string to your conc program name, for example)

2. Save these changes and run your process in Oracle Applications.

3. When the process completes, interrogate the log messages table:

SELECT log_sequence
,      module
,      message_text
FROM   fnd_log_messages
WHERE  user_id = 13334
ORDER BY log_sequence ASC

4. In order to write to the log messages table from a PL/SQL program, use:

fnd_log.STRING (fnd_log.level_statement,MODULE NAME,MESSAGE TEXT);