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_ADMIN

Line 49: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

45: go(errbuf,retcode);
46: errbuf:='';
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;

Line 54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED 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');
57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
58: RAISE;

Line 100: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

96: errbuf := CZ_ORAAPPS_INTEGRATE.mERRBUF;
97: retcode := CZ_ORAAPPS_INTEGRATE.mRETCODE;
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;

Line 105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED 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');
108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
109: RAISE;

Line 110: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR 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
113: retcode:=2;
114: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 184: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

180: CZ_IMP_SINGLE.ImportSingleBill(orgId(i), topItemId(i), copyChildModel(i), modelId(i), '0', explType(i), SYSDATE, l_run_id); -- sselahi: added l_run_id
181: END LOOP;
182: COMMIT;
183: EXCEPTION
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);

Line 219: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

215: v_section_name VARCHAR2(30);
216:
217: BEGIN
218:
219: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
220: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
221:
222: ----1) Insert new record into XFR_RUN_INFO and get the generated Run_ID for this import
223:

Line 290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

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';
294: v_section_name := 'IMPORT';

Line 305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

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
309: ----- CZ_XFR_TABLES with XFR_GROUP='IMPORT'

Line 322: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

318:
319: populate_table(genRun_ID,sTableName,nCommit_size,nMax_err,'GENERIC', p_rp_folder_id, l_failed);
320:
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);

Line 327: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

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

Line 356: CZ_ADMIN.ENABLE_END_USERS;

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
358: CZ_ADMIN.VALIDATE_END_USERS;
359: END IF;
360:

Line 358: CZ_ADMIN.VALIDATE_END_USERS;

354: END;
355: IF(bAutoCreateUsers='YES' OR bAutoCreateUsers='NAMED_ONLY')THEN
356: CZ_ADMIN.ENABLE_END_USERS;
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:

Line 367: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 371: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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('','');
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

Line 466: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

462: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
463: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));
464: --DBMS_OUTPUT.PUT_LINE('DUPLICATES: '||to_char(Dups));
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);

Line 471: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

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
475: CURSOR C_GET_ID(nPriceGroupID number) IS

Line 715: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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

Line 910: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

906: errbuf := CZ_ORAAPPS_INTEGRATE.mERRBUF;
907: retcode := CZ_ORAAPPS_INTEGRATE.mRETCODE;
908:
909: EXCEPTION
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');

Line 912: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

908:
909: EXCEPTION
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;

Line 917: WHEN CZ_ADMIN.IMP_MAXERR_REACHED 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');
920: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
921: RAISE;

Line 981: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

977: errbuf := CZ_ORAAPPS_INTEGRATE.mERRBUF;
978: retcode := CZ_ORAAPPS_INTEGRATE.mRETCODE;
979:
980: EXCEPTION
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');

Line 983: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

979:
980: EXCEPTION
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;

Line 988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED 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');
991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
992: RAISE;