Logging Message in FND_LOG_MESSAGES

Usage of FND_LOG_MESSAGES table for adding Log messages:

Profiles to be set for the Log messages to be inserted.

FND: Debug Log Enabled       –   Yes

FND: Debug Log Level        -   Statement

FND: Debug Log Module       - <Module name can be provided by you>

In case of Multiple Module if you want to debug then separate the Module name with ,(comma).

Procedure to insert the log message

fnd_log.STRING (log_level   => 1,

                module      => <Module name can be provided by you same as above>,

                MESSAGE     => <Log message>);