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_ORAAPPS_INTEGRATE dependencies on CZ_ORAAPPS_INTEGRATE

Line 1: PACKAGE BODY CZ_ORAAPPS_INTEGRATE AS

1: PACKAGE BODY CZ_ORAAPPS_INTEGRATE AS
2: /* $Header: czcaintb.pls 120.16 2008/01/31 16:14:08 lamrute ship $ */
3:
4: PROCEDURE get_App_Info(p_app_short_name IN VARCHAR2,
5: p_link_name IN VARCHAR2,

Line 308: 'CZ_ORAAPPS_INTEGRATE.GO_CP',

304: register_spx_process('Refresh All Imported Configuration Models',
305: 'CZAPPIMP',
306: application_name,
307: 'Import Apps Data into Configurator',
308: 'CZ_ORAAPPS_INTEGRATE.GO_CP',
309: request_group,
310: cz_schema);
311: EXCEPTION
312: WHEN OTHERS THEN

Line 320: 'CZ_ORAAPPS_INTEGRATE.POPULATEMODELS_CP',

316: register_spx_process('Import Model Bills',
317: 'CZAPPIMPPCM',
318: application_name,
319: 'Populate Configuration Models',
320: 'CZ_ORAAPPS_INTEGRATE.POPULATEMODELS_CP',
321: request_group,
322: cz_schema);
323: fnd_program.parameter(program_short_name=>'CZAPPIMPPCM',
324: application=>application_name,

Line 389: 'CZ_ORAAPPS_INTEGRATE.REFRESHSINGLEMODEL_CP',

385: register_spx_process('Refresh a Single Configuration Model',
386: 'CZAPPIMPRFCM',
387: application_name,
388: 'Refresh a Configuration Model',
389: 'CZ_ORAAPPS_INTEGRATE.REFRESHSINGLEMODEL_CP',
390: request_group,
391: cz_schema);
392:
393: fnd_program.parameter(program_short_name=>'CZAPPIMPRFCM',

Line 439: 'CZ_ORAAPPS_INTEGRATE.REMOVEMODEL_CP',

435: register_spx_process('Disable/Enable Refresh of a Configuration Model',
436: 'CZAPPIMPRMCM',
437: application_name,
438: 'Change Import Parameters for a Configuration Model',
439: 'CZ_ORAAPPS_INTEGRATE.REMOVEMODEL_CP',
440: request_group,
441: cz_schema);
442:
443: fnd_program.parameter(program_short_name=>'CZAPPIMPRMCM',

Line 513: 'CZ_ORAAPPS_INTEGRATE.check_model_similarity_cp',

509: register_spx_process('Check model(s)/bill(s) similarity',
510: 'CZBOMSIM',
511: application_name,
512: 'Check model(s)/bill(s) similarity',
513: 'CZ_ORAAPPS_INTEGRATE.check_model_similarity_cp',
514: request_group,
515: cz_schema);
516:
517: fnd_program.parameter(program_short_name=>'CZBOMSIM',

Line 563: 'CZ_ORAAPPS_INTEGRATE.check_all_models_similarity_cp',

559: register_spx_process('Check all models/bills similarity',
560: 'CZALLBOMSIM',
561: application_name,
562: 'Check all models/bills similarity',
563: 'CZ_ORAAPPS_INTEGRATE.check_all_models_similarity_cp',
564: request_group,
565: cz_schema);
566:
567: fnd_program.parameter(program_short_name=>'CZALLBOMSIM',

Line 588: 'CZ_ORAAPPS_INTEGRATE.sync_all_models_cp',

584: register_spx_process('Synchronize all models',
585: 'CZALLBOMSYNC',
586: application_name,
587: 'Synchronize all models',
588: 'CZ_ORAAPPS_INTEGRATE.sync_all_models_cp',
589: request_group,
590: cz_schema);
591:
592: EXCEPTION

Line 652: 'CZ_ORAAPPS_INTEGRATE.Repopulate_cp',

648: register_spx_process('Repopulate',
649: 'CZREPOP',
650: application_name,
651: 'Repopulate',
652: 'CZ_ORAAPPS_INTEGRATE.Repopulate_cp',
653: request_group,
654: cz_schema);
655:
656: fnd_program.parameter(program_short_name=>'CZREPOP',

Line 689: 'CZ_ORAAPPS_INTEGRATE.GETSETTING',

685: register_spx_process('Show Configurator Application Settings',
686: 'CZREPGS',
687: application_name,
688: 'Show Configurator Application Settings',
689: 'CZ_ORAAPPS_INTEGRATE.GETSETTING',
690: request_group,
691: cz_schema);
692:
693: fnd_program.parameter(program_short_name=>'CZREPGS',

Line 727: 'CZ_ORAAPPS_INTEGRATE.ASSIGNSETTING',

723: register_spx_process('Change Configurator Application Settings',
724: 'CZREPIN',
725: application_name,
726: 'Change Configurator Application Settings',
727: 'CZ_ORAAPPS_INTEGRATE.ASSIGNSETTING',
728: request_group,
729: cz_schema);
730:
731: fnd_program.parameter(program_short_name=>'CZREPIN',

Line 792: 'CZ_ORAAPPS_INTEGRATE.GETTABLEIMPORT',

788: register_spx_process('Show tables to be Imported',
789: 'CZREPGIMP',
790: application_name,
791: 'Show tables to be Imported',
792: 'CZ_ORAAPPS_INTEGRATE.GETTABLEIMPORT',
793: request_group,
794: cz_schema);
795:
796: fnd_program.parameter(program_short_name=>'CZREPGIMP',

Line 830: 'CZ_ORAAPPS_INTEGRATE.SETTABLEIMPORT',

826: register_spx_process('Select Tables to Be Imported',
827: 'CZREPSIMP',
828: application_name,
829: 'Select Tables to Be Imported',
830: 'CZ_ORAAPPS_INTEGRATE.SETTABLEIMPORT',
831: request_group,
832: cz_schema);
833:
834: fnd_program.parameter(program_short_name=>'CZREPSIMP',

Line 1238: cz_utils.log_report('CZ_ORAAPPS_INTEGRATE', null, null,

1234: PROCEDURE LOG_REPORT
1235: (inStr IN VARCHAR2) AS
1236:
1237: BEGIN
1238: cz_utils.log_report('CZ_ORAAPPS_INTEGRATE', null, null,
1239: instr, fnd_log.LEVEL_ERROR);
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: ROLLBACK;

Line 2814: 'CZ_ORAAPPS_INTEGRATE.CREATE_LINK_CP',

2810: register_spx_process('Enable Remote Server',
2811: 'CZCREATELNK',
2812: application_name,
2813: 'Enable Remote Server for Configurator',
2814: 'CZ_ORAAPPS_INTEGRATE.CREATE_LINK_CP',
2815: request_group,
2816: cz_schema);
2817: fnd_program.parameter(program_short_name=>'CZCREATELNK',
2818: application=>application_name,

Line 2849: 'CZ_ORAAPPS_INTEGRATE.POPULATE_CZ_SERVER_CP',

2845: register_spx_process('Define Remote Server',
2846: 'CZPOPULATESRV',
2847: application_name,
2848: 'Define Remote Server',
2849: 'CZ_ORAAPPS_INTEGRATE.POPULATE_CZ_SERVER_CP',
2850: request_group,
2851: cz_schema);
2852: fnd_program.parameter(program_short_name=>'CZPOPULATESRV',
2853: application=>application_name,

Line 2953: 'CZ_ORAAPPS_INTEGRATE.ALTER_CZ_SERVER_CP',

2949: register_spx_process('Modify Server Definition',
2950: 'CZALTERSERVER',
2951: application_name,
2952: 'Modify Remote Server',
2953: 'CZ_ORAAPPS_INTEGRATE.ALTER_CZ_SERVER_CP',
2954: request_group,
2955: cz_schema);
2956:
2957: fnd_program.parameter(program_short_name=>'CZALTERSERVER',

Line 3057: 'CZ_ORAAPPS_INTEGRATE.SHOW_CZ_SERVERS_CP',

3053: register_spx_process('View Servers',
3054: 'CZSHOWSERVERS',
3055: application_name,
3056: 'Show Remote Servers',
3057: 'CZ_ORAAPPS_INTEGRATE.SHOW_CZ_SERVERS_CP',
3058: request_group,
3059: cz_schema);
3060: EXCEPTION
3061: WHEN OTHERS THEN

Line 3132: 'BEGIN cz_imp_all.goSingleBill_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE'||

3128: v_code:=create_exv_views(v_local_name);
3129: compile_Dependents('CZ_IMP%');
3130:
3131: EXECUTE IMMEDIATE
3132: 'BEGIN cz_imp_all.goSingleBill_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE'||
3133: ',:lORG_ID,:lTOP_ID,:lCOPY_CHILD_MODELS,:iMODEL_ID); END;'
3134: USING lORG_ID,lTOP_ID,lCOPY_CHILD_MODELS,iMODEL_ID;
3135:
3136: errbuf:=CZ_ORAAPPS_INTEGRATE.mERRBUF;

Line 3136: errbuf:=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3132: 'BEGIN cz_imp_all.goSingleBill_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE'||
3133: ',:lORG_ID,:lTOP_ID,:lCOPY_CHILD_MODELS,:iMODEL_ID); END;'
3134: USING lORG_ID,lTOP_ID,lCOPY_CHILD_MODELS,iMODEL_ID;
3135:
3136: errbuf:=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3137: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3138: END IF;
3139:
3140: EXCEPTION

Line 3137: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3133: ',:lORG_ID,:lTOP_ID,:lCOPY_CHILD_MODELS,:iMODEL_ID); END;'
3134: USING lORG_ID,lTOP_ID,lCOPY_CHILD_MODELS,iMODEL_ID;
3135:
3136: errbuf:=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3137: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3138: END IF;
3139:
3140: EXCEPTION
3141: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

Line 3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3140: EXCEPTION
3141: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3142: retcode:=2;
3143: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3173: END RefreshSingleModel_cp;
3174:
3175: ------------------------------------------------------------------------------------------
3176: PROCEDURE RemoveModel_cp

Line 3236: 'BEGIN CZ_IMP_ALL.GO_CP(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE); END;';

3232: ELSE
3233: v_code:=create_exv_views(v_local_name);
3234: compile_Dependents('CZ_IMP%');
3235: EXECUTE IMMEDIATE
3236: 'BEGIN CZ_IMP_ALL.GO_CP(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE); END;';
3237: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3238: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3239: END IF;
3240: EXCEPTION

Line 3237: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3233: v_code:=create_exv_views(v_local_name);
3234: compile_Dependents('CZ_IMP%');
3235: EXECUTE IMMEDIATE
3236: 'BEGIN CZ_IMP_ALL.GO_CP(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE); END;';
3237: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3238: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3239: END IF;
3240: EXCEPTION
3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

Line 3238: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3234: compile_Dependents('CZ_IMP%');
3235: EXECUTE IMMEDIATE
3236: 'BEGIN CZ_IMP_ALL.GO_CP(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE); END;';
3237: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3238: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3239: END IF;
3240: EXCEPTION
3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3242: retcode:=2;

Line 3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3240: EXCEPTION
3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3242: retcode:=2;
3243: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3269: END;
3270:
3271: ------------------------------------------------------------------------------------------
3272:

Line 3309: 'BEGIN CZ_IMP_ALL.PopulateModels_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||

3305: v_code:=create_exv_views(v_local_name);
3306: compile_Dependents('CZ_IMP%');
3307:
3308: EXECUTE IMMEDIATE
3309: 'BEGIN CZ_IMP_ALL.PopulateModels_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3310: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3311: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3312: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3313: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3312: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3308: EXECUTE IMMEDIATE
3309: 'BEGIN CZ_IMP_ALL.PopulateModels_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3310: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3311: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3312: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3313: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3314: END IF;
3315: EXCEPTION
3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

Line 3313: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3309: 'BEGIN CZ_IMP_ALL.PopulateModels_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3310: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3311: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3312: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3313: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3314: END IF;
3315: EXCEPTION
3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3317: retcode:=2;

Line 3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3315: EXCEPTION
3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3317: retcode:=2;
3318: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3344: END;
3345:
3346: ------------------------------------------------------------------------------------------
3347:

Line 3357: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||

3353: p_MODEL_ID IN NUMBER) IS
3354:
3355: BEGIN
3356: EXECUTE IMMEDIATE
3357: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3358: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3359: USING p_TARGET_INSTANCE,p_MODEL_ID;
3360: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3361: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3360: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3356: EXECUTE IMMEDIATE
3357: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3358: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3359: USING p_TARGET_INSTANCE,p_MODEL_ID;
3360: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3361: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: retcode:=2;

Line 3361: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3357: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3358: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3359: USING p_TARGET_INSTANCE,p_MODEL_ID;
3360: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3361: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: retcode:=2;
3365: errbuf:=SQLERRM;

Line 3378: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||

3374: p_TARGET_INSTANCE IN VARCHAR2) IS
3375:
3376: BEGIN
3377: EXECUTE IMMEDIATE
3378: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3379: ':p_TARGET_INSTANCE); END;'
3380: USING p_TARGET_INSTANCE;
3381: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3382: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3381: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3377: EXECUTE IMMEDIATE
3378: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3379: ':p_TARGET_INSTANCE); END;'
3380: USING p_TARGET_INSTANCE;
3381: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3382: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: retcode:=2;

Line 3382: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3378: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3379: ':p_TARGET_INSTANCE); END;'
3380: USING p_TARGET_INSTANCE;
3381: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3382: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: retcode:=2;
3386: errbuf:=SQLERRM;

Line 3404: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||

3400: FROM CZ_SERVERS
3401: WHERE import_enabled='1';
3402:
3403: EXECUTE IMMEDIATE
3404: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3405: ':v_TARGET_INSTANCE); END;'
3406: USING v_TARGET_INSTANCE;
3407: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3408: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3407: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3403: EXECUTE IMMEDIATE
3404: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3405: ':v_TARGET_INSTANCE); END;'
3406: USING v_TARGET_INSTANCE;
3407: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3408: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3409: EXCEPTION
3410: WHEN TOO_MANY_ROWS THEN
3411: retcode:=2;

Line 3408: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3404: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3405: ':v_TARGET_INSTANCE); END;'
3406: USING v_TARGET_INSTANCE;
3407: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3408: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3409: EXCEPTION
3410: WHEN TOO_MANY_ROWS THEN
3411: retcode:=2;
3412: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');