| How to update LOG into Concurrent Request [message #449543] |
Tue, 30 March 2010 06:38  |
sanjujob99
Messages: 4
Registered: February 2009
|
Junior Member |
|
|
Hi All,
To Import data, we are using base (seeded) concurrent program (WIP Mass Load) in stored PL/SQL procedure with the help of
FND_REQUEST.SUBMIT_REQUEST . The concurrent request import
records successfully.
Now I want to replace the LOG file ( "View Log" option) with
custom message/errors instead of seeded messages/codes for debug
purpose.
Following is the extracts of my stored procedure.
CREATE OR REPLACE PROCEDURE <PROC-NAME>
BEGIN
<EXECUTABLE STATEMENTS>
BEGIN
FND_GLOBAL.APPS_INITIALIZE (P_USER_ID, 50488, 706);
fnd_file.put_line(FND_FILE.LOG,'Concurrent Request Testing ');
V_CONC_REQ_ID := FND_REQUEST.SUBMIT_REQUEST
( 'WIP' ,'WICMLP','WIP Mass Load',
SYSDATE, FALSE, 1, 0, 2 );
COMMIT;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error while inserting interface :
'||SQLERRM );
END;
END;
Now, anyone can help me that how i update log with custom messages ?
regards
Sanjay 
|
|
|
|
|
|
| Re: How to update LOG into Concurrent Request [message #453145 is a reply to message #449543] |
Tue, 27 April 2010 06:18  |
umar79
Messages: 3
Registered: June 2008
Location: Dubai
|
Junior Member |
|
|
Change your code with below one
CREATE OR REPLACE PROCEDURE <PROC-NAME>
BEGIN
<EXECUTABLE STATEMENTS>
BEGIN
FND_GLOBAL.APPS_INITIALIZE (P_USER_ID, 50488, 706);
fnd_file.put_line(FND_FILE.LOG,'Concurrent Request Testing ');
V_CONC_REQ_ID := FND_REQUEST.SUBMIT_REQUEST
( 'WIP' ,'WICMLP','WIP Mass Load',
SYSDATE, FALSE, 1, 0, 2 );
COMMIT;
EXCEPTION
WHEN OTHERS THEN
fnd_file.put_line(FND_FILE.LOG,'Error while inserting interface :
'||SQLERRM );
END;
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
