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 763: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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