eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_DB_LOGS

Line 41: FROM cz_db_logs

37: CZ_LOGIC_GEN.GENERATE_LOGIC(p_devl_project_id, x_run_id);
38:
39: SELECT MIN(urgency)
40: INTO l_urgency
41: FROM cz_db_logs
42: WHERE run_id = x_run_id;
43:
44: IF l_urgency = 0 THEN
45: x_status := G_STATUS_ERROR;

Line 58: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

54: WHEN G_INCOMPATIBLE_API THEN
55: x_status := G_STATUS_ERROR;
56: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
57: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
58: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
59: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
60: COMMIT;
61: WHEN NOT_VALID_PROJECT_ID THEN
62: x_status := G_STATUS_ERROR;

Line 65: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

61: WHEN NOT_VALID_PROJECT_ID THEN
62: x_status := G_STATUS_ERROR;
63: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);
64: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
65: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
66: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
67: COMMIT;
68: WHEN OTHERS THEN
69: x_status := G_STATUS_ERROR;

Line 72: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

68: WHEN OTHERS THEN
69: x_status := G_STATUS_ERROR;
70: l_errbuf := SQLERRM;
71: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
72: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
73: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
74: COMMIT;
75: END generate_logic;
76: ------------------------------------------------------------------------------------------------

Line 193: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

189: WHEN G_INCOMPATIBLE_API THEN
190: x_status := G_STATUS_ERROR;
191: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
192: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
193: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
194: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
195: COMMIT;
196: WHEN NOT_VALID_PROJECT_ID THEN
197: x_status := G_STATUS_ERROR;

Line 200: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

196: WHEN NOT_VALID_PROJECT_ID THEN
197: x_status := G_STATUS_ERROR;
198: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);
199: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
200: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
201: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
202: COMMIT;
203: WHEN WRONG_UI_STYLE THEN
204: x_status := G_STATUS_ERROR;

Line 207: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

203: WHEN WRONG_UI_STYLE THEN
204: x_status := G_STATUS_ERROR;
205: l_errbuf := CZ_UTILS.GET_TEXT('CZ_UI_STYLE_ERR');
206: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
207: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
208: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
209: COMMIT;
210: WHEN WRONG_FRAME_ALLCN THEN
211: x_status := G_STATUS_ERROR;

Line 214: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

210: WHEN WRONG_FRAME_ALLCN THEN
211: x_status := G_STATUS_ERROR;
212: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_FRAME_ALLCN_ERR');
213: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
214: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
215: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
216: COMMIT;
217: WHEN WRONG_WIDTH THEN
218: x_status := G_STATUS_ERROR;

Line 221: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

217: WHEN WRONG_WIDTH THEN
218: x_status := G_STATUS_ERROR;
219: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_WIDTH_ERR');
220: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
221: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
222: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
223: COMMIT;
224: WHEN WRONG_HEIGHT THEN
225: x_status := G_STATUS_ERROR;

Line 228: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

224: WHEN WRONG_HEIGHT THEN
225: x_status := G_STATUS_ERROR;
226: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_HEIGHT_ERR');
227: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
228: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
229: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
230: COMMIT;
231: WHEN WRONG_SHOW_NODES THEN
232: x_status := G_STATUS_ERROR;

Line 235: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

231: WHEN WRONG_SHOW_NODES THEN
232: x_status := G_STATUS_ERROR;
233: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_SHOW_ALL_NODES_ERR');
234: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
235: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
236: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
237: COMMIT;
238: WHEN WRONG_USE_LABELS THEN
239: x_status := G_STATUS_ERROR;

Line 242: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

238: WHEN WRONG_USE_LABELS THEN
239: x_status := G_STATUS_ERROR;
240: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_USE_LABELS_ERR');
241: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
242: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
243: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
244: COMMIT;
245: WHEN WRONG_LOOK_AND_FEEL THEN
246: x_status := G_STATUS_ERROR;

Line 249: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

245: WHEN WRONG_LOOK_AND_FEEL THEN
246: x_status := G_STATUS_ERROR;
247: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_LOOK_AND_FEEL_ERR');
248: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
249: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
250: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
251: COMMIT;
252: WHEN WRONG_MAX_BOM THEN
253: x_status := G_STATUS_ERROR;

Line 256: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

252: WHEN WRONG_MAX_BOM THEN
253: x_status := G_STATUS_ERROR;
254: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_MAX_BOM_PER_PAGE_ERR');
255: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
256: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
257: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
258: COMMIT;
259: WHEN WRONG_WIZARD_STYLE THEN
260: x_status := G_STATUS_ERROR;

Line 263: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

259: WHEN WRONG_WIZARD_STYLE THEN
260: x_status := G_STATUS_ERROR;
261: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_WIZARD_STYLE_ERR');
262: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
263: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
264: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
265: COMMIT;
266: WHEN OTHERS THEN
267: x_status := G_STATUS_ERROR;

Line 271: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

267: x_status := G_STATUS_ERROR;
268: ROLLBACK TO create_ui_PUB;
269: l_errbuf := SQLERRM;
270: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
271: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
272: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
273: COMMIT;
274: END create_ui;
275:

Line 496: FROM cz_db_logs

492: x_status := G_STATUS_SUCCESS;
493: ELSE
494: SELECT max(urgency)
495: INTO l_urgency
496: FROM cz_db_logs
497: WHERE run_id = x_run_id;
498:
499: IF l_urgency = 1 THEN
500: x_status := G_STATUS_ERROR;

Line 513: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

509: WHEN G_INCOMPATIBLE_API THEN
510: x_status := G_STATUS_ERROR;
511: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
512: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
513: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
514: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
515: COMMIT;
516: WHEN NOT_VALID_UI_DEF_ID THEN
517: x_status := G_STATUS_ERROR;

Line 520: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

516: WHEN NOT_VALID_UI_DEF_ID THEN
517: x_status := G_STATUS_ERROR;
518: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_UI_DEF_ID_ERR');
519: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
520: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
521: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
522: COMMIT;
523: WHEN NOT_VALID_PROJECT_ID THEN
524: x_status := G_STATUS_ERROR;

Line 527: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

523: WHEN NOT_VALID_PROJECT_ID THEN
524: x_status := G_STATUS_ERROR;
525: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_UI_PRJ_ERR', 'UIDEF', p_ui_def_id);
526: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
527: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
528: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
529: COMMIT;
530: WHEN OTHERS THEN
531: x_status := G_STATUS_ERROR;

Line 535: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

531: x_status := G_STATUS_ERROR;
532: ROLLBACK TO refresh_ui_PUB;
533: l_errbuf := SQLERRM;
534: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
535: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
536: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
537: COMMIT;
538: END refresh_ui;
539: ------------------------------------------------------------------------------------------------

Line 767: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

763: WHEN G_INCOMPATIBLE_API THEN
764: x_status := G_STATUS_ERROR;
765: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
766: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
767: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
768: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
769: COMMIT;
770: WHEN SESS_NOT_INITIALIZED THEN
771: x_status := G_STATUS_ERROR;

Line 774: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

770: WHEN SESS_NOT_INITIALIZED THEN
771: x_status := G_STATUS_ERROR;
772: l_errbuf := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');
773: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
774: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
775: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
776: COMMIT;
777: WHEN TOO_MANY_IMP_SERVERS THEN
778: x_status := G_STATUS_ERROR;

Line 781: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

777: WHEN TOO_MANY_IMP_SERVERS THEN
778: x_status := G_STATUS_ERROR;
779: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
780: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
781: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
782: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
783: COMMIT;
784: WHEN NO_IMP_SERVERS THEN
785: x_status := G_STATUS_ERROR;

Line 788: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

784: WHEN NO_IMP_SERVERS THEN
785: x_status := G_STATUS_ERROR;
786: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
787: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
788: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
789: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
790: COMMIT;
791: WHEN WRONG_EXV_VIEWS THEN
792: x_status := G_STATUS_ERROR;

Line 795: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

791: WHEN WRONG_EXV_VIEWS THEN
792: x_status := G_STATUS_ERROR;
793: l_errbuf := 'Error : not all EXV views have been recreated successfully';
794: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
795: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
796: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
797: COMMIT;
798: WHEN DB_LINK_IS_DOWN THEN
799: x_status := G_STATUS_ERROR;

Line 802: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

798: WHEN DB_LINK_IS_DOWN THEN
799: x_status := G_STATUS_ERROR;
800: l_errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',l_db_link);
801: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
802: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
803: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
804: COMMIT;
805: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
806: x_status := G_STATUS_ERROR;

Line 808: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

804: COMMIT;
805: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
806: x_status := G_STATUS_ERROR;
807: l_errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
808: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
809: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
810: COMMIT;
811: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
812: x_status := G_STATUS_ERROR;

Line 814: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

810: COMMIT;
811: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
812: x_status := G_STATUS_ERROR;
813: l_errbuf := SQLERRM;
814: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
815: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
816: COMMIT;
817: WHEN OTHERS THEN
818: x_status := G_STATUS_ERROR;

Line 821: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

817: WHEN OTHERS THEN
818: x_status := G_STATUS_ERROR;
819: l_errbuf := SQLERRM;
820: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
821: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
822: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
823: COMMIT;
824: END import_single_bill;
825: ------------------------------------------------------------------------------------------------

Line 950: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

946: WHEN G_INCOMPATIBLE_API THEN
947: x_status := G_STATUS_ERROR;
948: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
949: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
950: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
951: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
952: COMMIT;
953: WHEN SESS_NOT_INITIALIZED THEN
954: x_status := G_STATUS_ERROR;

Line 957: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

953: WHEN SESS_NOT_INITIALIZED THEN
954: x_status := G_STATUS_ERROR;
955: l_errbuf := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');
956: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
957: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
958: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
959: COMMIT;
960: WHEN TOO_MANY_IMP_SERVERS THEN
961: x_status := G_STATUS_ERROR;

Line 964: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

960: WHEN TOO_MANY_IMP_SERVERS THEN
961: x_status := G_STATUS_ERROR;
962: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
963: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
964: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
965: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
966: COMMIT;
967: WHEN NO_IMP_SERVERS THEN
968: x_status := G_STATUS_ERROR;

Line 971: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

967: WHEN NO_IMP_SERVERS THEN
968: x_status := G_STATUS_ERROR;
969: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
970: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
971: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
972: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
973: COMMIT;
974: WHEN WRONG_EXV_VIEWS THEN
975: x_status := G_STATUS_ERROR;

Line 978: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

974: WHEN WRONG_EXV_VIEWS THEN
975: x_status := G_STATUS_ERROR;
976: l_errbuf := 'Error : not all EXV views have been recreated successfully';
977: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
978: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
979: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
980: COMMIT;
981: WHEN DB_LINK_IS_DOWN THEN
982: x_status := G_STATUS_ERROR;

Line 985: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

981: WHEN DB_LINK_IS_DOWN THEN
982: x_status := G_STATUS_ERROR;
983: l_errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',l_db_link);
984: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
985: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
986: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
987: COMMIT;
988: WHEN PROJECT_ID_NOT_EXITS THEN
989: x_status := G_STATUS_ERROR;

Line 992: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

988: WHEN PROJECT_ID_NOT_EXITS THEN
989: x_status := G_STATUS_ERROR;
990: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);
991: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
992: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
993: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
994: COMMIT;
995: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
996: x_status := G_STATUS_ERROR;

Line 998: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

994: COMMIT;
995: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
996: x_status := G_STATUS_ERROR;
997: l_errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
998: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
999: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1000: COMMIT;
1001: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1002: x_status := G_STATUS_ERROR;

Line 1004: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1000: COMMIT;
1001: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1002: x_status := G_STATUS_ERROR;
1003: l_errbuf := SQLERRM;
1004: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1005: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1006: COMMIT;
1007: WHEN OTHERS THEN
1008: x_status := G_STATUS_ERROR;

Line 1011: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1007: WHEN OTHERS THEN
1008: x_status := G_STATUS_ERROR;
1009: l_errbuf := SQLERRM;
1010: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1011: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1012: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1013: COMMIT;
1014: end refresh_single_model;
1015: ------------------------------------------------------------------------------------------------

Line 1063: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1059: WHEN G_INCOMPATIBLE_API THEN
1060: x_status := G_STATUS_ERROR;
1061: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1062: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1063: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1064: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1065: COMMIT;
1066: WHEN OTHERS THEN
1067: x_status := G_STATUS_ERROR;

Line 1070: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1066: WHEN OTHERS THEN
1067: x_status := G_STATUS_ERROR;
1068: l_errbuf := SQLERRM;
1069: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1070: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1071: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1072: END publish_model;
1073: ------------------------------------------------------------------------------------------------
1074: PROCEDURE publish_model(p_api_version IN NUMBER,

Line 1135: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1131: WHEN G_INCOMPATIBLE_API THEN
1132: x_status := G_STATUS_ERROR;
1133: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1134: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1135: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1136: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1137: COMMIT;
1138: WHEN NOT_VALID_PROJECT_ID THEN
1139: x_status := G_STATUS_ERROR;

Line 1142: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1138: WHEN NOT_VALID_PROJECT_ID THEN
1139: x_status := G_STATUS_ERROR;
1140: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);
1141: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1142: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1143: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1144: COMMIT;
1145: WHEN OTHERS THEN
1146: x_status := G_STATUS_ERROR;

Line 1149: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1145: WHEN OTHERS THEN
1146: x_status := G_STATUS_ERROR;
1147: l_errbuf := SQLERRM;
1148: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1149: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1150: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1151: COMMIT;
1152: END deep_model_copy;
1153: ------------------------------------------------------------------------------------------------

Line 1224: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1220: WHEN G_INCOMPATIBLE_API THEN
1221: x_status := G_STATUS_ERROR;
1222: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1223: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1224: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1225: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1226: COMMIT;
1227: WHEN NOT_VALID_POPULATOR_ID THEN
1228: x_status := G_STATUS_ERROR;

Line 1231: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1227: WHEN NOT_VALID_POPULATOR_ID THEN
1228: x_status := G_STATUS_ERROR;
1229: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_POPULATOR_ID_ERR');
1230: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1231: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1232: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1233: COMMIT;
1234: WHEN OTHERS THEN
1235: x_status := G_STATUS_ERROR;

Line 1239: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1235: x_status := G_STATUS_ERROR;
1236: ROLLBACK TO execute_populator_PUB;
1237: l_errbuf := SQLERRM;
1238: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1239: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1240: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1241: COMMIT;
1242: END execute_populator;
1243:

Line 1308: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1304: WHEN G_INCOMPATIBLE_API THEN
1305: x_status := G_STATUS_ERROR;
1306: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1307: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1308: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1309: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1310: COMMIT;
1311: WHEN NOT_VALID_PROJECT_ID THEN
1312: x_status := G_STATUS_ERROR;

Line 1315: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1311: WHEN NOT_VALID_PROJECT_ID THEN
1312: x_status := G_STATUS_ERROR;
1313: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);
1314: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1315: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1316: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1317: COMMIT;
1318: WHEN OTHERS THEN
1319: x_status := G_STATUS_ERROR;

Line 1323: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1319: x_status := G_STATUS_ERROR;
1320: ROLLBACK TO repopulate_PUB;
1321: l_errbuf := SQLERRM;
1322: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1323: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1324: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1325: COMMIT;
1326: END repopulate;
1327: ------------------------------------------------------------------------------------------------

Line 1389: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1385: WHEN G_INCOMPATIBLE_API THEN
1386: x_status := G_STATUS_ERROR;
1387: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1388: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
1389: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1390: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1391: COMMIT;
1392: WHEN OTHERS THEN
1393: x_status := G_STATUS_ERROR;

Line 1396: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1392: WHEN OTHERS THEN
1393: x_status := G_STATUS_ERROR;
1394: l_errbuf := SQLERRM;
1395: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
1396: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1397: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
1398: END republish_model;
1399: ---------------------------------------------------------
1400: PROCEDURE republish_model(p_api_version IN NUMBER,

Line 1771: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1767: WHEN G_INCOMPATIBLE_API THEN
1768: x_status := G_STATUS_ERROR;
1769: l_msg_data := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
1770: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1771: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1772: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1773: COMMIT;
1774: WHEN SESS_NOT_INITIALIZED_EXCP THEN
1775: x_status := G_STATUS_ERROR;

Line 1778: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1774: WHEN SESS_NOT_INITIALIZED_EXCP THEN
1775: x_status := G_STATUS_ERROR;
1776: l_msg_data := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');
1777: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1778: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1779: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1780: COMMIT;
1781: WHEN INVALID_ENCL_FLDR_EXCP THEN
1782: x_status := G_STATUS_ERROR;

Line 1784: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1780: COMMIT;
1781: WHEN INVALID_ENCL_FLDR_EXCP THEN
1782: x_status := G_STATUS_ERROR;
1783: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1784: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1785: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1786: COMMIT;
1787: WHEN NO_PRIV_EXCP THEN
1788: x_status := G_STATUS_ERROR;

Line 1790: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1786: COMMIT;
1787: WHEN NO_PRIV_EXCP THEN
1788: x_status := G_STATUS_ERROR;
1789: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1790: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1791: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1792: COMMIT;
1793: WHEN MODEL_LOCKED_EXCP THEN
1794: x_status := G_STATUS_ERROR;

Line 1796: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1792: COMMIT;
1793: WHEN MODEL_LOCKED_EXCP THEN
1794: x_status := G_STATUS_ERROR;
1795: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1796: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1797: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1798: COMMIT;
1799: WHEN FAILED_TO_LOCK_MODEL_EXCP THEN
1800: x_status := G_STATUS_ERROR;

Line 1802: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1798: COMMIT;
1799: WHEN FAILED_TO_LOCK_MODEL_EXCP THEN
1800: x_status := G_STATUS_ERROR;
1801: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1802: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1803: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1804: COMMIT;
1805: WHEN MODEL_UNLOCK_EXCP THEN
1806: x_status := G_STATUS_ERROR;

Line 1808: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1804: COMMIT;
1805: WHEN MODEL_UNLOCK_EXCP THEN
1806: x_status := G_STATUS_ERROR;
1807: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);
1808: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1809: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1810: COMMIT;
1811: WHEN OTHERS THEN
1812: x_status := G_STATUS_ERROR;

Line 1815: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

1811: WHEN OTHERS THEN
1812: x_status := G_STATUS_ERROR;
1813: l_msg_data := SQLERRM;
1814: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_UNEXPECTED);
1815: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1816: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1817: COMMIT;
1818: IF (l_all_locked_models_tbl.COUNT > 0) THEN
1819: cz_security_pvt.unlock_model(

Line 2094: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

2090: WHEN G_INCOMPATIBLE_API THEN
2091: x_status := G_STATUS_ERROR;
2092: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
2093: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);
2094: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
2095: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);
2096: COMMIT;
2097: END;
2098: ---------------------------------------------------------------------------------------

Line 2150: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)

2146: EXCEPTION
2147: WHEN G_INCOMPATIBLE_API THEN
2148: x_return_status := G_STATUS_ERROR;
2149: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);
2150: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)
2151: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, SYSDATE);
2152: COMMIT;
2153: WHEN OTHERS THEN
2154: x_return_status := G_STATUS_ERROR;

Line 2156: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)

2152: COMMIT;
2153: WHEN OTHERS THEN
2154: x_return_status := G_STATUS_ERROR;
2155: l_errbuf := SQLERRM;
2156: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)
2157: VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, SYSDATE);
2158: COMMIT;
2159: END create_publication_request;
2160: