DBA Data[Home] [Help]

APPS.CZ_NETWORK_API_PUB dependencies on CZ_DB_LOGS

Line 76: l_caller cz_db_logs.caller%TYPE;

72: PROCEDURE populate_debug_message(p_msg IN VARCHAR2,
73: p_caller IN VARCHAR2,
74: p_sqlcode IN NUMBER)
75: IS
76: l_caller cz_db_logs.caller%TYPE;
77:
78: BEGIN
79: IF (p_caller IS NULL) THEN
80: l_caller := 'CZ_NETWORK_API';

Line 788: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);

784:
785: IF (l_trace_tbl.COUNT > 0) THEN
786: FOR I IN l_trace_tbl.FIRST..l_trace_tbl.LAST
787: LOOP
788: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
789: END LOOP;
790: l_trace_tbl.DELETE;
791: END IF;
792: END IF;

Line 885: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);

881:
882: IF (l_trace_tbl.COUNT > 0) THEN
883: FOR I IN l_trace_tbl.FIRST..l_trace_tbl.LAST
884: LOOP
885: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
886: END LOOP;
887: l_trace_tbl.DELETE;
888: END IF;
889: END IF;