Tuesday 14 May 2013

How to send message to output or log file FND_FILE.PUT_LINE

This API is used to send messages to output file or log file while we are working with PL/SQL Stored procedures.

For sending messages to output file we use this syntax
Syntax: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,’OUTPUT MESSAGE’);

For sending messages to log file we use this syntax
Syntax: FND_FILE.PUT_LINE(FND_FILE.LOG,’LOG MESSAGE’);

1 comment:

  1. fnd_file.put_line(fnd_file.log, ' Initial DFF Status : '||decode(l_dff_status, 'Y', 'YES', 'N', 'NO', 'NULL' ) );

    IS it possible ?? If not can you pls suggest alternative

    ReplyDelete