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_IMP_ALL dependencies on CZ_UTILS

Line 51: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');

47: retcode:=0;
48: EXCEPTION
49: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
50: retcode:=2;
51: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;

Line 52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

48: EXCEPTION
49: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
50: retcode:=2;
51: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;
56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;
56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;

Line 57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;
56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;
61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

Line 61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;
61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
62: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
63: RAISE;
64: END go_cp;
65:

Line 62: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;
61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
62: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
63: RAISE;
64: END go_cp;
65:
66: ------------------------------------------------------------------------------------------

Line 102: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');

98:
99: EXCEPTION
100: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
101: retcode:=2;
102: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;

Line 103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

99: EXCEPTION
100: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
101: retcode:=2;
102: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;
107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;
107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
109: RAISE;
110: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
111: RAISE;

Line 108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;
107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
109: RAISE;
110: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
111: RAISE;
112: WHEN OTHERS THEN

Line 114: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

110: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
111: RAISE;
112: WHEN OTHERS THEN
113: retcode:=2;
114: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
115: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
116: RAISE;
117: END goSingleBill_cp;
118: ------------------------------------------------------------------------------------------

Line 115: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

111: RAISE;
112: WHEN OTHERS THEN
113: retcode:=2;
114: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
115: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
116: RAISE;
117: END goSingleBill_cp;
118: ------------------------------------------------------------------------------------------
119: PROCEDURE go(errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER) IS

Line 152: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

148: WHERE import_enabled = v_enabled;
149: EXCEPTION
150: WHEN TOO_MANY_ROWS THEN
151: retcode:=2;
152: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;

Line 153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);

149: EXCEPTION
150: WHEN TOO_MANY_ROWS THEN
151: retcode:=2;
152: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;
157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;
157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
158: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
159: RAISE;
160: END;
161:

Line 158: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);

154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;
157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
158: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
159: RAISE;
160: END;
161:
162: SELECT organization_id, top_item_id, explosion_type, NVL(copy_addl_child_models, '0'), model_ps_node_id

Line 171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMPORTED_MODELS');

167: AND source_server = nServerId;
168:
169: IF(orgId.COUNT = 0)THEN
170: retcode:=2;
171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMPORTED_MODELS');
172: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
173: RETURN;
174: END IF;
175:

Line 172: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);

168:
169: IF(orgId.COUNT = 0)THEN
170: retcode:=2;
171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMPORTED_MODELS');
172: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
173: RETURN;
174: END IF;
175:
176: FOR i IN orgId.FIRST .. orgId.LAST

Line 188: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

184: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
185: RAISE;
186: WHEN OTHERS THEN
187: retcode:=2;
188: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
189: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
190: RAISE;
191: END go;
192: ------------------------------------------------------------------------------------------

Line 189: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);

185: RAISE;
186: WHEN OTHERS THEN
187: retcode:=2;
188: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
189: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
190: RAISE;
191: END go;
192: ------------------------------------------------------------------------------------------
193: PROCEDURE go_generic(outRun_ID IN OUT NOCOPY PLS_INTEGER,

Line 242: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

238: EXIT WHEN C_IMPORT_ORDER%NOTFOUND;
239: setRecStatus(genRun_ID,sSrcTableName);
240: EXCEPTION
241: WHEN OTHERS THEN
242: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
243: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRECSTATUS',11276,genRun_ID);
244: RAISE;
245: END;
246: END LOOP;

Line 243: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRECSTATUS',11276,genRun_ID);

239: setRecStatus(genRun_ID,sSrcTableName);
240: EXCEPTION
241: WHEN OTHERS THEN
242: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
243: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRECSTATUS',11276,genRun_ID);
244: RAISE;
245: END;
246: END LOOP;
247: CLOSE C_IMPORT_ORDER;

Line 266: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

262: EXIT WHEN C_IMPORT_ORDER%NOTFOUND;
263: setRunID(genRun_ID,sSrcTableName);
264: EXCEPTION
265: WHEN OTHERS THEN
266: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
267: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRUNID',11276,genRun_ID);
268: RAISE;
269: END;
270: END LOOP;

Line 267: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRUNID',11276,genRun_ID);

263: setRunID(genRun_ID,sSrcTableName);
264: EXCEPTION
265: WHEN OTHERS THEN
266: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
267: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.SETRUNID',11276,genRun_ID);
268: RAISE;
269: END;
270: END LOOP;
271: CLOSE C_IMPORT_ORDER;

Line 286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');

282: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS
283: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');
287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
288: WHEN OTHERS THEN
289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);
290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);

283: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');
287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
288: WHEN OTHERS THEN
289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);
290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
291: END;

Line 289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);

285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');
287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
288: WHEN OTHERS THEN
289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);
290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
291: END;
292:
293: v_settings_id := 'MaximumErrors';

Line 301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');

297: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS
298: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');
302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
303: WHEN OTHERS THEN
304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);

298: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');
302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
303: WHEN OTHERS THEN
304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
306: END;

Line 304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);

300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');
302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
303: WHEN OTHERS THEN
304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
306: END;
307:
308: ----3) Call all the import procedures in the order specified by ORDER_SEQ field of

Line 325: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

321: EXCEPTION
322: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
323: RAISE;
324: WHEN OTHERS THEN
325: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
326: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.IMPORT',11276,NULL);
327: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
328: END;
329: END LOOP;

Line 326: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.IMPORT',11276,NULL);

322: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
323: RAISE;
324: WHEN OTHERS THEN
325: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
326: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.IMPORT',11276,NULL);
327: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
328: END;
329: END LOOP;
330: CLOSE C_IMPORT_ORDER;

Line 353: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_AUTOCREATE_SETTING'),1,'GO_GENERIC',11276,genRun_ID);

349: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
350: EXCEPTION
351: WHEN OTHERS THEN
352: bAutoCreateUsers:='NO';
353: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_AUTOCREATE_SETTING'),1,'GO_GENERIC',11276,genRun_ID);
354: END;
355: IF(bAutoCreateUsers='YES' OR bAutoCreateUsers='NAMED_ONLY')THEN
356: CZ_ADMIN.ENABLE_END_USERS;
357: ELSE

Line 361: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));

357: ELSE
358: CZ_ADMIN.VALIDATE_END_USERS;
359: END IF;
360:
361: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
362:
363: COMMIT;
364: DBMS_APPLICATION_INFO.SET_MODULE('','');
365:

Line 368: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'GO_GENERIC',11276,genRun_ID);

364: DBMS_APPLICATION_INFO.SET_MODULE('','');
365:
366: EXCEPTION
367: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
368: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'GO_GENERIC',11276,genRun_ID);
369: DBMS_APPLICATION_INFO.SET_MODULE('','');
370: RAISE;
371: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
372: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

371: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
372: DBMS_APPLICATION_INFO.SET_MODULE('','');
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);
377: DBMS_APPLICATION_INFO.SET_MODULE('','');
378: RAISE;
379: END go_generic;

Line 376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);

372: DBMS_APPLICATION_INFO.SET_MODULE('','');
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);
377: DBMS_APPLICATION_INFO.SET_MODULE('','');
378: RAISE;
379: END go_generic;
380: ------------------------------------------------------------------------------------------

Line 455: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));

451: ELSIF(lower_table_name='cz_user_groups') THEN
452: CZ_IMP_AC_MAIN.MAIN_USER_GROUP(inRun_ID, commit_size, max_err,
453: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
454: ELSE
455: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
456: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
457: END IF;
458: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
459: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));

Line 456: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);

452: CZ_IMP_AC_MAIN.MAIN_USER_GROUP(inRun_ID, commit_size, max_err,
453: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
454: ELSE
455: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
456: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
457: END IF;
458: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
459: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
460: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));

Line 466: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

462: EXCEPTION
463: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
464: RAISE;
465: WHEN OTHERS THEN
466: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
467: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
468: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
469: END populate_table;
470: ------------------------------------------------------------------------------------------

Line 467: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);

463: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
464: RAISE;
465: WHEN OTHERS THEN
466: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
467: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
468: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
469: END populate_table;
470: ------------------------------------------------------------------------------------------
471: PROCEDURE import_before_start IS

Line 502: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);

498: BEGIN
499: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;
500: EXCEPTION
501: WHEN OTHERS THEN
502: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);
503: END;
504: END IF;
505:
506: END LOOP;

Line 584: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

580: price_list_id=nPriceListId;
581: end if;
582: exception
583: when others then
584: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
585: end;
586: close c_pricegroup;
587: end loop;
588: close c_listcontrol;

Line 642: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

638: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
639: WHERE CURRENT OF C_GET_HOST;
640: EXCEPTION
641: WHEN OTHERS THEN
642: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
643: END;
644: ELSE
645: BEGIN
646: nAllocateCounter:=nAllocateCounter+1;

Line 671: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

667: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
668: WHERE CURRENT OF C_GET_HOST;
669: EXCEPTION
670: WHEN OTHERS THEN
671: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
672: END;
673: END IF;
674:
675: END LOOP;

Line 709: xERROR:=cz_utils.log_report(d_str,1,'IMPORT',11299,NULL);

705: CZ_IMP_SINGLE.ImportSingleBill(nOrg_ID,nTop_ID,COPY_CHILD_MODELS,REFRESH_MODEL_ID,'0', 'OPTIONAL', sysdate, x_run_id); -- sselahi:added x_run_id
706: if (get_time) then
707: imp_end := dbms_utility.get_time();
708: d_str := 'Import (' || nTop_Id || ') :' || (imp_end-imp_st)/100.00;
709: xERROR:=cz_utils.log_report(d_str,1,'IMPORT',11299,NULL);
710: end if;
711: EXCEPTION
712: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
713: RAISE;

Line 715: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

711: EXCEPTION
712: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
713: RAISE;
714: WHEN OTHERS THEN
715: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
716: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.goSingleBill',11276,NULL);
717: RAISE;
718: END goSingleBill;
719: ------------------------------------------------------------------------------------------

Line 716: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.goSingleBill',11276,NULL);

712: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
713: RAISE;
714: WHEN OTHERS THEN
715: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
716: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.goSingleBill',11276,NULL);
717: RAISE;
718: END goSingleBill;
719: ------------------------------------------------------------------------------------------
720: PROCEDURE AddBillToImport(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,

Line 737: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

733: WHERE import_enabled = v_enabled;
734: EXCEPTION
735: WHEN TOO_MANY_ROWS THEN
736: retcode:=2;
737: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
738: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
739: RAISE;
740: WHEN NO_DATA_FOUND THEN
741: retcode:=2;

Line 738: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

734: EXCEPTION
735: WHEN TOO_MANY_ROWS THEN
736: retcode:=2;
737: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
738: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
739: RAISE;
740: WHEN NO_DATA_FOUND THEN
741: retcode:=2;
742: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 742: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

738: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
739: RAISE;
740: WHEN NO_DATA_FOUND THEN
741: retcode:=2;
742: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
743: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
744: RAISE;
745: END;
746:

Line 743: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

739: RAISE;
740: WHEN NO_DATA_FOUND THEN
741: retcode:=2;
742: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
743: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
744: RAISE;
745: END;
746:
747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,

Line 760: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

756: COMMIT;
757: EXCEPTION
758: WHEN OTHERS THEN
759: retcode:=2;
760: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
761: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
762: RAISE;
763: END;
764: ------------------------------------------------------------------------------------------

Line 761: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

757: EXCEPTION
758: WHEN OTHERS THEN
759: retcode:=2;
760: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
761: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
762: RAISE;
763: END;
764: ------------------------------------------------------------------------------------------
765: PROCEDURE SetSingleBillState(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,sState IN VARCHAR2) IS

Line 781: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

777: WHERE import_enabled = v_enabled;
778: EXCEPTION
779: WHEN TOO_MANY_ROWS THEN
780: retcode:=2;
781: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
782: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
783: RAISE;
784: WHEN NO_DATA_FOUND THEN
785: retcode:=2;

Line 782: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

778: EXCEPTION
779: WHEN TOO_MANY_ROWS THEN
780: retcode:=2;
781: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
782: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
783: RAISE;
784: WHEN NO_DATA_FOUND THEN
785: retcode:=2;
786: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

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

782: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
783: RAISE;
784: WHEN NO_DATA_FOUND THEN
785: retcode:=2;
786: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
787: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
788: RAISE;
789: END;
790:

Line 787: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

783: RAISE;
784: WHEN NO_DATA_FOUND THEN
785: retcode:=2;
786: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
787: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
788: RAISE;
789: END;
790:
791: update cz_xfr_project_bills set

Line 800: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

796: COMMIT;
797: EXCEPTION
798: WHEN OTHERS THEN
799: retcode:=2;
800: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
801: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
802: END;
803: ------------------------------------------------------------------------------------------
804: PROCEDURE RemoveModel(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,sOrg_ID IN VARCHAR2,

Line 801: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

797: EXCEPTION
798: WHEN OTHERS THEN
799: retcode:=2;
800: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
801: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
802: END;
803: ------------------------------------------------------------------------------------------
804: PROCEDURE RemoveModel(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,sOrg_ID IN VARCHAR2,
805: dsOrg_ID IN VARCHAR2,sTop_ID IN VARCHAR2) IS

Line 824: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

820: WHERE import_enabled = v_enabled;
821: EXCEPTION
822: WHEN TOO_MANY_ROWS THEN
823: retcode:=2;
824: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
825: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
826: RAISE;
827: WHEN NO_DATA_FOUND THEN
828: retcode:=2;

Line 825: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

821: EXCEPTION
822: WHEN TOO_MANY_ROWS THEN
823: retcode:=2;
824: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
825: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
826: RAISE;
827: WHEN NO_DATA_FOUND THEN
828: retcode:=2;
829: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 829: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

825: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
826: RAISE;
827: WHEN NO_DATA_FOUND THEN
828: retcode:=2;
829: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
830: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
831: RAISE;
832: END;
833:

Line 830: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

826: RAISE;
827: WHEN NO_DATA_FOUND THEN
828: retcode:=2;
829: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
830: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
831: RAISE;
832: END;
833:
834: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

Line 853: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

849: COMMIT;
850: EXCEPTION
851: WHEN OTHERS THEN
852: retcode:=2;
853: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
854: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
855: END;
856: ------------------------------------------------------------------------------------------
857: PROCEDURE PopulateModels_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,

Line 854: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

850: EXCEPTION
851: WHEN OTHERS THEN
852: retcode:=2;
853: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
854: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
855: END;
856: ------------------------------------------------------------------------------------------
857: PROCEDURE PopulateModels_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
858: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,

Line 911: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');

907: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
908: RAISE;
909: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
910: retcode:=2;
911: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
912: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
913: RAISE;
914: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
915: retcode:=2;

Line 912: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

908: RAISE;
909: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
910: retcode:=2;
911: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
912: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
913: RAISE;
914: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
915: retcode:=2;
916: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 916: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

912: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
913: RAISE;
914: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
915: retcode:=2;
916: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
917: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
918: RAISE;
919: WHEN OTHERS THEN
920: retcode:=2;

Line 917: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

913: RAISE;
914: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
915: retcode:=2;
916: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
917: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
918: RAISE;
919: WHEN OTHERS THEN
920: retcode:=2;
921: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 921: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

917: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
918: RAISE;
919: WHEN OTHERS THEN
920: retcode:=2;
921: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
922: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
923: RAISE;
924: END;
925: ------------------------------------------------------------------------------------------

Line 922: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

918: RAISE;
919: WHEN OTHERS THEN
920: retcode:=2;
921: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
922: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
923: RAISE;
924: END;
925: ------------------------------------------------------------------------------------------
926: PROCEDURE RefreshModels(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER) IS

Line 983: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);

979: WHERE ORGANIZATION_ID = nOrg_ID
980: AND ASSEMBLY_ITEM_ID = nTop_ID);
981: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
982: retcode := 1;
983: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);
984: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
985: END IF;
986: EXCEPTION
987: WHEN NO_DATA_FOUND THEN

Line 984: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);

980: AND ASSEMBLY_ITEM_ID = nTop_ID);
981: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
982: retcode := 1;
983: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);
984: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
985: END IF;
986: EXCEPTION
987: WHEN NO_DATA_FOUND THEN
988: retcode := 2;

Line 989: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');

985: END IF;
986: EXCEPTION
987: WHEN NO_DATA_FOUND THEN
988: retcode := 2;
989: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
990: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
991: WHEN OTHERS THEN
992: retcode := 2;
993: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;

Line 990: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);

986: EXCEPTION
987: WHEN NO_DATA_FOUND THEN
988: retcode := 2;
989: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
990: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
991: WHEN OTHERS THEN
992: retcode := 2;
993: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
994: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);

Line 994: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);

990: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
991: WHEN OTHERS THEN
992: retcode := 2;
993: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
994: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);
995: RAISE;
996: END check_for_common_bill;
997:
998: ------------------------------------------------------------------------------------------

Line 1005: xError := cz_utils.log_report(Msg, urgency, ByCaller, StatusCode);

1001: xError Boolean;
1002: l_msg VARCHAR2(2000);
1003: BEGIN
1004: -- log msg to both fnd and cz tables
1005: xError := cz_utils.log_report(Msg, urgency, ByCaller, StatusCode);
1006: IF (xError) THEN
1007: commit;
1008: ELSE
1009: rollback;

Line 1030: l_success_msg:=CZ_UTILS.get_text('CZ_IMP_GENIMP_SUCCESS_RUNID', 'OUT_RUN_ID', outRun_ID);

1026: l_success_msg VARCHAR2(255);
1027:
1028: BEGIN
1029: go_generic(outRun_ID,inRun_ID, p_rp_folder_id);
1030: l_success_msg:=CZ_UTILS.get_text('CZ_IMP_GENIMP_SUCCESS_RUNID', 'OUT_RUN_ID', outRun_ID);
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: retcode:=2;
1034: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1034: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

1030: l_success_msg:=CZ_UTILS.get_text('CZ_IMP_GENIMP_SUCCESS_RUNID', 'OUT_RUN_ID', outRun_ID);
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: retcode:=2;
1034: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1035: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1036: END go_generic_cp;
1037: ------------------------------------------------------------------------------------------
1038: END CZ_IMP_ALL;

Line 1035: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);

1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: retcode:=2;
1034: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1035: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1036: END go_generic_cp;
1037: ------------------------------------------------------------------------------------------
1038: END CZ_IMP_ALL;