Fnd_File.Put_Line Error Issue.
546215Feb 2 2007 — edited Feb 2 2007Hi,
I am using sql developer version 5.1.3.704 connecting to oracle 8i database.I have developed a procedure which would take unix path as i/p parameter(should be registered in ult_file_dir) to write the files. when an invalid path is given by the user,it goes in to the error handling block as shown below.. p_filedir is the i/p path to be given.
BEGIN
po_recon_sd1 := UTL_FILE.FOPEN(P_FILEDIR, 'po_recon_sd1', 'w');
....
....
EXCEPTION
WHEN UTL_FILE.INVALID_PATH THEN
Fnd_File.Put_Line(Fnd_File.Log, 'Invalid Output Path');
/*DBMS_OUTPUT.PUT_LINE('Invalid Output Path ' || p_filedir);*/
END;
but when invalid path is given it will enter the exception block and in case of DBMS_OUTPUT.PUT_LINE it would give the error message when run from backend.when this procedure is registered as a concurrent program in APPS it should give the error message in log file.But Fnd_File.Put_Line is throwing 'ORA-06510 PL/SQL undefined user defined exception' even the syntax for Fnd_File.Put_Line looks fine what could be the reason.. kinly help me out on this one
Thanks & regards