OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Writing In Log file through procedure called from Report

Home » Applications » Oracle Fusion Apps & E-Business Suite » Writing In Log file through procedure called from Report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Writing In Log file through procedure called from Report [message #121515]

Mon, 30 May 2005 07:21

urchin556
Messages: 42
Registered: March 2005
Location: India

Member

HI Guys,

I have a report which calls a stored procedure in AFTER PARAMETER FORM.
I want to write some messages in the concurrent program log file.
I had tried fnd_file.put_line and dbms_output.put_line but neither of them worked.
Does anyone has solution for the problem.

Regards,
Urchin Cool

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #121544 is a reply to message #121515]

Mon, 30 May 2005 09:19

SHEKHARNIKAM
Messages: 2
Registered: May 2005
Location: Pune

Junior Member

Hi

you can use fnd_log.put_line for putting the text in log.

Regards,
Shekhar Nikam

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #122141 is a reply to message #121544]

Fri, 03 June 2005 05:26

urchin556
Messages: 42
Registered: March 2005
Location: India

Member

HI,

There is no such procedure or function in fnd_log package.
Have u implemented this thing.Please let me know if u have solution.

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #122262 is a reply to message #121515]

Sat, 04 June 2005 08:28

SHEKHARNIKAM
Messages: 2
Registered: May 2005
Location: Pune

Junior Member

Hi ,

you can use following packaged procedure,
I am enclosing example also

fnd_file.put_line(fnd_file.log,'This log is created by shekhar Nikam');

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #122334 is a reply to message #122262]

Mon, 06 June 2005 00:17

urchin556
Messages: 42
Registered: March 2005
Location: India

Member

I had already try this .Its not working .

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #123180 is a reply to message #122262]

Fri, 10 June 2005 07:29

sachinghadmode
Messages: 5
Registered: April 2005
Location: India

Junior Member

hi
Try this
srw.message (number,context)
Regards
Sachin

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #124482 is a reply to message #121515]

Sun, 19 June 2005 06:11

urchin556
Messages: 42
Registered: March 2005
Location: India

Member

I am using report which calls a procedure. I want the log messages from the procedure not from the report.

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #124574 is a reply to message #124482]

Mon, 20 June 2005 05:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Then why don't you log by using a log table and an autonomous transaction?

MHE

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #124626 is a reply to message #121515]

Mon, 20 June 2005 09:41

urchin556
Messages: 42
Registered: March 2005
Location: India

Member

I need to put the log data in the log report not in the log table.

Report message to a moderator

Re: Writing In Log file through procedure called from Report [message #125928 is a reply to message #124626]

Thu, 30 June 2005 00:37

rakeshapps
Messages: 11
Registered: June 2005
Location: India

Junior Member

Hi,

You can use FND_FILE.PUT_LINE to get messages displayed to your Concurrent Log/Output if you're having a PL/SQL stored procedure as the executable of your concurrent request.

If you're triggering a stored procedure through AFTER PARAMETER FORM from your request (which purports to be a Oracle Reports executable), there is no way to display the messages in the Concurrent Request log, as you're no way directly triggering the PL/SQL procedure. Its the report which is triggered, which in turn calls the stored proc.

Regards,
Rakesh Tripathi

Report message to a moderator

Previous Topic:	AP Invoice Interface
Next Topic:	Help with using APPS.AP_INVOICES_PKG

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 08:21:52 CST 2025