Oracle Aps Technical

The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code. The SQLERRM function returns the error message associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code. You could use the SQLCODE & SQLERRM  function to raise an error as follows: EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'Error - '||SQLCODE||' -ERROR- '||SQLERRM); END; Or you could log the error to a table using the SQLCODE & SQLERRM function as follows: EXCEPTION WHEN OTHERS THEN ERR_CODE := SQLCODE; ERR_MSG := SUBSTR(SQLERRM, 1, 200); INSERT INTO XXERROR_TABLE (ERROR_CODE, ERROR_MSG) VALUES (ERR_CODE, ERR_MSG); END;

Through the Application front end, we cannot delete a concurrent program, You can either enable or disable a concurrent program. But from the backend, we can delete it using fnd_program. begin fnd_program.delete_program('PROGRAM_SHORT_NAME','Application Name'); fnd_program.delete_executable('EXECUTABLE_SHORT_NAME','Application Name'); end;

Print debug messages in log / Output of a concurrent program Output file, in PLSQL: apps.fnd_file.put_line (fnd_file.output, 'Message'); Log file, in PLSQL: apps.fnd_file.put_line (fnd_file.log, 'Message'); Log file, in Report: srw.message(1001,'Message');