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_UTILS

Line 56: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

52:
53: EXCEPTION
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;

Line 57: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

53: EXCEPTION
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

Line 63: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);

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;
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;

Line 64: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

60: COMMIT;
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

Line 71: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

67: COMMIT;
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;

Line 191: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

187:
188: EXCEPTION
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;

Line 192: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

188: EXCEPTION
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

Line 198: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);

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;
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;

Line 199: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

195: COMMIT;
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

Line 205: l_errbuf := CZ_UTILS.GET_TEXT('CZ_UI_STYLE_ERR');

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;
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;

Line 206: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

202: COMMIT;
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

Line 212: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_FRAME_ALLCN_ERR');

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;
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;

Line 213: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

209: COMMIT;
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

Line 219: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_WIDTH_ERR');

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;
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;

Line 220: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

216: COMMIT;
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

Line 226: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_HEIGHT_ERR');

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;
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;

Line 227: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

223: COMMIT;
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

Line 233: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_SHOW_ALL_NODES_ERR');

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;
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;

Line 234: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

230: COMMIT;
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

Line 240: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_USE_LABELS_ERR');

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;
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;

Line 241: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

237: COMMIT;
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

Line 247: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_LOOK_AND_FEEL_ERR');

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;
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;

Line 248: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

244: COMMIT;
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

Line 254: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_MAX_BOM_PER_PAGE_ERR');

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;
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;

Line 255: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

251: COMMIT;
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

Line 261: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_WIZARD_STYLE_ERR');

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;
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;

Line 262: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

258: COMMIT;
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

Line 270: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

266: WHEN OTHERS THEN
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;

Line 403: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_SHOW_ALL_NODES_ERR');

399: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
400: p_data => x_msg_data);
401: WHEN WRONG_SHOW_NODES THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_SHOW_ALL_NODES_ERR');
404:
405:
406: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_SHOW_ALL_NODES_ERR');
407: FND_MSG_PUB.ADD;

Line 511: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

507: COMMIT WORK;
508: EXCEPTION
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;

Line 512: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

508: EXCEPTION
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

Line 518: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_UI_DEF_ID_ERR');

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;
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;

Line 519: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

515: COMMIT;
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

Line 525: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_UI_PRJ_ERR', 'UIDEF', p_ui_def_id);

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;
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;

Line 526: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

522: COMMIT;
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

Line 534: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

530: WHEN OTHERS THEN
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;

Line 765: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

761:
762: EXCEPTION
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;

Line 766: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

762: EXCEPTION
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

Line 772: l_errbuf := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');

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;
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;

Line 773: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

769: COMMIT;
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

Line 779: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

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;
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;

Line 780: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

776: COMMIT;
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

Line 786: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

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;
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;

Line 787: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

783: COMMIT;
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

Line 794: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

790: COMMIT;
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

Line 800: l_errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',l_db_link);

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;
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;

Line 801: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

797: COMMIT;
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

Line 807: l_errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

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;
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

Line 820: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

816: COMMIT;
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;

Line 948: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

944:
945: EXCEPTION
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;

Line 949: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

945: EXCEPTION
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

Line 955: l_errbuf := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');

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;
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;

Line 956: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

952: COMMIT;
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

Line 962: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

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;
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;

Line 963: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

959: COMMIT;
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

Line 969: l_errbuf := CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

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;
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;

Line 970: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

966: COMMIT;
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

Line 977: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

973: COMMIT;
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

Line 983: l_errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',l_db_link);

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;
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;

Line 984: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

980: COMMIT;
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

Line 990: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);

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;
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;

Line 991: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

987: COMMIT;
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

Line 997: l_errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

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;
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

Line 1010: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1006: COMMIT;
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;

Line 1061: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1057:
1058: EXCEPTION
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;

Line 1062: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1058: EXCEPTION
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

Line 1069: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1065: COMMIT;
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: ------------------------------------------------------------------------------------------------

Line 1133: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1129:
1130: EXCEPTION
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;

Line 1134: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1130: EXCEPTION
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

Line 1140: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);

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;
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;

Line 1141: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1137: COMMIT;
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

Line 1148: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1144: COMMIT;
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;

Line 1222: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1218:
1219: EXCEPTION
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;

Line 1223: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1219: EXCEPTION
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

Line 1229: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_POPULATOR_ID_ERR');

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;
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;

Line 1230: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1226: COMMIT;
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

Line 1238: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1234: WHEN OTHERS THEN
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;

Line 1306: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1302:
1303: EXCEPTION
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;

Line 1307: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1303: EXCEPTION
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

Line 1313: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_DEV_PRJ_ID_ERR', 'PROJID', p_devl_project_id);

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;
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;

Line 1314: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1310: COMMIT;
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

Line 1322: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1318: WHEN OTHERS THEN
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;

Line 1387: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1383:
1384: EXCEPTION
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;

Line 1388: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

1384: EXCEPTION
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

Line 1395: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

1391: COMMIT;
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: ---------------------------------------------------------

Line 1553: x_msg_data := CZ_UTILS.GET_TEXT('CZ_RP_FLDR_NO_ENCL_FLDR');

1549: AND object_type = 'FLD'
1550: AND deleted_flag = '0';
1551: EXCEPTION
1552: WHEN NO_DATA_FOUND THEN
1553: x_msg_data := CZ_UTILS.GET_TEXT('CZ_RP_FLDR_NO_ENCL_FLDR');
1554: RAISE FND_API.G_EXC_ERROR;
1555: END;
1556:
1557: BEGIN -- check if folder already exists, if so return its id

Line 1708: l_msg_data := cz_utils.get_text('CZ_IMPGEN_ENCL_FLDR');

1704: AND deleted_flag = '0';
1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: l_msg_count := 1;
1708: l_msg_data := cz_utils.get_text('CZ_IMPGEN_ENCL_FLDR');
1709: RAISE INVALID_ENCL_FLDR_EXCP;
1710: END;
1711:
1712: l_model_id_tbl.DELETE;

Line 1737: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_MODELOPERATIONS_PUB.IMPORT_GENERIC',20001,p_run_id);

1733: x_msg_data => l_msg_data);
1734: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1735: FOR k IN 1..l_msg_count LOOP
1736: l_msg_data := fnd_msg_pub.get(k,fnd_api.g_false);
1737: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_MODELOPERATIONS_PUB.IMPORT_GENERIC',20001,p_run_id);
1738: COMMIT;
1739: END LOOP;
1740: RAISE FAILED_TO_LOCK_MODEL_EXCP;
1741: END IF;

Line 1769: l_msg_data := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

1765:
1766: EXCEPTION
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;

Line 1770: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

1766: EXCEPTION
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

Line 1776: l_msg_data := CZ_UTILS.GET_TEXT('CZ_SESS_NOT_INITIALIZED');

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;
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;

Line 1777: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

1773: COMMIT;
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

Line 1783: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

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;
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

Line 1789: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

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;
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

Line 1795: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

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;
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

Line 1801: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

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;
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

Line 1807: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_ERROR);

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;
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

Line 1814: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_msg_data, fnd_log.LEVEL_UNEXPECTED);

1810: COMMIT;
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

Line 2092: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

2088:
2089: EXCEPTION
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;

Line 2093: -- cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_ERROR);

2089: EXCEPTION
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;

Line 2109: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin

2105: p_server_id IN NUMBER,
2106: p_appl_id_tbl IN CZ_PB_MGR.t_ref,
2107: p_usg_id_tbl IN CZ_PB_MGR.t_ref, -- DEFAULT -1 (ie., 'Any Usage')
2108: p_lang_tbl IN CZ_PB_MGR.t_lang_code, -- DEFAULT 'US'
2109: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin
2110: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end
2111: x_publication_id OUT NOCOPY NUMBER,
2112: x_return_status OUT NOCOPY VARCHAR2,
2113: x_msg_count OUT NOCOPY NUMBER,

Line 2110: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end

2106: p_appl_id_tbl IN CZ_PB_MGR.t_ref,
2107: p_usg_id_tbl IN CZ_PB_MGR.t_ref, -- DEFAULT -1 (ie., 'Any Usage')
2108: p_lang_tbl IN CZ_PB_MGR.t_lang_code, -- DEFAULT 'US'
2109: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin
2110: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end
2111: x_publication_id OUT NOCOPY NUMBER,
2112: x_return_status OUT NOCOPY VARCHAR2,
2113: x_msg_count OUT NOCOPY NUMBER,
2114: x_msg_data OUT NOCOPY VARCHAR2

Line 2149: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

2145: END IF;
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

Line 2171: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin

2167: p_server_id IN NUMBER,
2168: p_appl_id_tbl IN CZ_PB_MGR.t_ref,
2169: p_usg_id_tbl IN CZ_PB_MGR.t_ref, -- DEFAULT -1 (ie., 'Any Usage')
2170: p_lang_tbl IN CZ_PB_MGR.t_lang_code, -- DEFAULT 'US'
2171: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin
2172: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end
2173: p_user_id IN NUMBER,
2174: p_resp_id IN NUMBER,
2175: p_appl_id IN NUMBER,

Line 2172: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end

2168: p_appl_id_tbl IN CZ_PB_MGR.t_ref,
2169: p_usg_id_tbl IN CZ_PB_MGR.t_ref, -- DEFAULT -1 (ie., 'Any Usage')
2170: p_lang_tbl IN CZ_PB_MGR.t_lang_code, -- DEFAULT 'US'
2171: p_start_date IN DATE, -- DEFAULT CZ_UTILS.epoch_begin
2172: p_end_date IN DATE, -- DEFAULT CZ_UTILS.CZ_UTILS.epoch_end
2173: p_user_id IN NUMBER,
2174: p_resp_id IN NUMBER,
2175: p_appl_id IN NUMBER,
2176: x_publication_id OUT NOCOPY NUMBER,