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 463: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

459: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
460: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));
461: --DBMS_OUTPUT.PUT_LINE('DUPLICATES: '||to_char(Dups));
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);

Line 468: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

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

Line 712: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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

Line 907: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

903: errbuf := CZ_ORAAPPS_INTEGRATE.mERRBUF;
904: retcode := CZ_ORAAPPS_INTEGRATE.mRETCODE;
905:
906: EXCEPTION
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');

Line 909: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

905:
906: EXCEPTION
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;

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