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 458: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));

454: ELSIF(lower_table_name='cz_user_groups') THEN
455: CZ_IMP_AC_MAIN.MAIN_USER_GROUP(inRun_ID, commit_size, max_err,
456: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
457: ELSE
458: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
459: 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);
460: END IF;
461: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
462: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));

Line 459: 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);

455: CZ_IMP_AC_MAIN.MAIN_USER_GROUP(inRun_ID, commit_size, max_err,
456: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
457: ELSE
458: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
459: 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);
460: END IF;
461: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
462: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
463: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));

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

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

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

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

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

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

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

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

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

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

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

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

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

708: 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
709: if (get_time) then
710: imp_end := dbms_utility.get_time();
711: d_str := 'Import (' || nTop_Id || ') :' || (imp_end-imp_st)/100.00;
712: xERROR:=cz_utils.log_report(d_str,1,'IMPORT',11299,NULL);
713: end if;
714: EXCEPTION
715: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
716: RAISE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

981: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
982: RAISE;
983: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
984: retcode:=2;
985: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
986: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;

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

982: RAISE;
983: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
984: retcode:=2;
985: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
986: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;
990: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

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

986: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;
990: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;

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

987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;
990: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;
995: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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

991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;
995: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
996: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
997: RAISE;
998: END;
999: ------------------------------------------------------------------------------------------

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

992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;
995: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
996: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
997: RAISE;
998: END;
999: ------------------------------------------------------------------------------------------
1000:

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

1054: WHERE ORGANIZATION_ID = nOrg_ID
1055: AND ASSEMBLY_ITEM_ID = nTop_ID);
1056: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
1057: retcode := 1;
1058: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);
1059: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1060: END IF;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN

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

1055: AND ASSEMBLY_ITEM_ID = nTop_ID);
1056: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
1057: retcode := 1;
1058: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);
1059: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1060: END IF;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: retcode := 2;

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

1060: END IF;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: retcode := 2;
1064: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;

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

1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: retcode := 2;
1064: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);

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

1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);
1070: RAISE;
1071: END check_for_common_bill;
1072:
1073: ------------------------------------------------------------------------------------------

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

1076: xError Boolean;
1077: l_msg VARCHAR2(2000);
1078: BEGIN
1079: -- log msg to both fnd and cz tables
1080: xError := cz_utils.log_report(Msg, urgency, ByCaller, StatusCode);
1081: IF (xError) THEN
1082: commit;
1083: ELSE
1084: rollback;

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

1101: l_success_msg VARCHAR2(255);
1102:
1103: BEGIN
1104: go_generic(outRun_ID,inRun_ID, p_rp_folder_id);
1105: l_success_msg:=CZ_UTILS.get_text('CZ_IMP_GENIMP_SUCCESS_RUNID', 'OUT_RUN_ID', outRun_ID);
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: retcode:=2;
1109: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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

1105: l_success_msg:=CZ_UTILS.get_text('CZ_IMP_GENIMP_SUCCESS_RUNID', 'OUT_RUN_ID', outRun_ID);
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: retcode:=2;
1109: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1110: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1111: END go_generic_cp;
1112: ------------------------------------------------------------------------------------------
1113: END CZ_IMP_ALL;

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

1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: retcode:=2;
1109: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1110: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1111: END go_generic_cp;
1112: ------------------------------------------------------------------------------------------
1113: END CZ_IMP_ALL;