DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE_UTILS dependencies on CZ_DB_LOGS

Line 217: l_fit_message CZ_DB_LOGS.MESSAGE%TYPE := NULL;

213: , p_message_id IN VARCHAR2 DEFAULT NULL
214: ) IS
215: PRAGMA AUTONOMOUS_TRANSACTION;
216:
217: l_fit_message CZ_DB_LOGS.MESSAGE%TYPE := NULL;
218: l_fit_error_stack CZ_DB_LOGS.ERROR_STACK%TYPE := NULL;
219:
220: BEGIN
221:

Line 218: l_fit_error_stack CZ_DB_LOGS.ERROR_STACK%TYPE := NULL;

214: ) IS
215: PRAGMA AUTONOMOUS_TRANSACTION;
216:
217: l_fit_message CZ_DB_LOGS.MESSAGE%TYPE := NULL;
218: l_fit_error_stack CZ_DB_LOGS.ERROR_STACK%TYPE := NULL;
219:
220: BEGIN
221:
222: -- Truncate the message if it is more than 4000 characters

Line 235: List of all columns in CZ_DB_LOGS. Not all columns are populated because some

231: l_fit_error_stack := SUBSTR( p_error_stack, 1, 4000 );
232: END IF;
233:
234: /*
235: List of all columns in CZ_DB_LOGS. Not all columns are populated because some
236: of them are not relavent for FCE_COMPILE case.
237: LOGTIME
238: LOGUSER
239: URGENCY

Line 261: INSERT INTO CZ_DB_LOGS (

257: stack traces associated with the message. In FCE we are inserting urgency
258: code in place of status code.
259: */
260:
261: INSERT INTO CZ_DB_LOGS (
262: LOGTIME, LOGUSER, URGENCY, CALLER, MESSAGE,
263: RUN_ID, MODEL_ID, PS_NODE_ID, RULE_ID, ERROR_STACK, STATUSCODE, message_id )
264: VALUES (
265: SYSDATE, USER, p_urgency, 'CZ_FCE_COMPILE', l_fit_message,