DBA Data[Home] [Help]

APPS.CZ_IB_TRANSACTIONS dependencies on CZ_DB_LOGS

Line 9: -- this method add log message to both CZ_DB_LOGS and FND LOG tables

5:
6: TYPE cv_cursor_type IS REF CURSOR;
7:
8: --
9: -- this method add log message to both CZ_DB_LOGS and FND LOG tables
10: --
11: PROCEDURE LOG_REPORT
12: (p_run_id IN VARCHAR2,
13: p_error_message IN VARCHAR2,

Line 19: INSERT INTO CZ_DB_LOGS

15: PRAGMA AUTONOMOUS_TRANSACTION;
16: BEGIN
17: IF (p_count IS NULL OR p_count<2) THEN
18: m_COUNTER:=m_COUNTER+1;
19: INSERT INTO CZ_DB_LOGS
20: (RUN_ID,
21: LOGTIME,
22: LOGUSER,
23: URGENCY,

Line 45: INSERT INTO CZ_DB_LOGS

41: ELSE
42: FOR i IN 1..p_count
43: LOOP
44: m_COUNTER:=m_COUNTER+1;
45: INSERT INTO CZ_DB_LOGS
46: (RUN_ID,
47: LOGTIME,
48: LOGUSER,
49: URGENCY,