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 761: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_API_VERSION_ERR', 'CODE_VERSION', l_api_version, 'IN_VERSION', p_api_version);

757:
758: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

940:
941: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1053:
1054: EXCEPTION
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;

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

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

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

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

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

1125:
1126: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

1214:
1215: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

1298:
1299: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

1379:
1380: EXCEPTION
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;

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

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

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

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

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

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

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

1700: AND deleted_flag = '0';
1701: EXCEPTION
1702: WHEN NO_DATA_FOUND THEN
1703: l_msg_count := 1;
1704: l_msg_data := cz_utils.get_text('CZ_IMPGEN_ENCL_FLDR');
1705: RAISE INVALID_ENCL_FLDR_EXCP;
1706: END;
1707:
1708: l_model_id_tbl.DELETE;

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

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

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

1761:
1762: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2084:
2085: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

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

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

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