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 815: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);

811:
812: IF (l_trace_tbl.COUNT > 0) THEN
813: FOR I IN l_trace_tbl.FIRST..l_trace_tbl.LAST
814: LOOP
815: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
816: END LOOP;
817: l_trace_tbl.DELETE;
818: END IF;
819: END IF;

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

908:
909: IF (l_trace_tbl.COUNT > 0) THEN
910: FOR I IN l_trace_tbl.FIRST..l_trace_tbl.LAST
911: LOOP
912: insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
913: END LOOP;
914: l_trace_tbl.DELETE;
915: END IF;
916: END IF;

Line 1110: INSERT INTO cz_db_logs (message,caller,logtime)

1106: v_config_hdr_id := 0;
1107: v_config_rev_nbr := 0;
1108:
1109: -- debug
1110: INSERT INTO cz_db_logs (message,caller,logtime)
1111: VALUES ('copy Config Called :' || l_main_config_hdr_id || '>>'|| l_main_config_rev_nbr ,'CZNETAPI',sysdate);
1112:
1113: CZ_CONFIG_API_PVT.copy_configuration(1.0,
1114: l_main_config_hdr_id,