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.19.12020000.2 2012/09/28 17:38:28 smanna 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 2816: 'CZ_ORAAPPS_INTEGRATE.CREATE_LINK_CP',

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

Line 2851: 'CZ_ORAAPPS_INTEGRATE.POPULATE_CZ_SERVER_CP',

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

Line 2955: 'CZ_ORAAPPS_INTEGRATE.ALTER_CZ_SERVER_CP',

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

Line 3059: 'CZ_ORAAPPS_INTEGRATE.SHOW_CZ_SERVERS_CP',

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

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

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

Line 3138: errbuf:=CZ_ORAAPPS_INTEGRATE.mERRBUF;

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

Line 3139: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3239: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

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

Line 3240: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3314: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

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

Line 3315: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3341: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3342: WHEN OTHERS THEN
3343: retcode:=2;
3344: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3345: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3346: END;
3347:
3348: ------------------------------------------------------------------------------------------
3349: -- Bug10011026 This procedure was introduced for Sun implementation where new Concurrent Program

Line 3389: 'BEGIN CZ_IMP_ALL.PopulateSingleModel_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||

3385: v_code:=create_exv_views(v_local_name);
3386: compile_Dependents('CZ_IMP%');
3387:
3388: EXECUTE IMMEDIATE
3389: 'BEGIN CZ_IMP_ALL.PopulateSingleModel_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3390: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3391: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3392: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3393: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3392: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3388: EXECUTE IMMEDIATE
3389: 'BEGIN CZ_IMP_ALL.PopulateSingleModel_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3390: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3391: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3392: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3393: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3394: END IF;
3395: EXCEPTION
3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

Line 3393: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3389: 'BEGIN CZ_IMP_ALL.PopulateSingleModel_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3390: ':sOrg_ID,:dsOrg_ID,:sFrom,:sTo,:COPY_CHILD_MODELS); END;'
3391: USING sOrg_ID,dsOrg_ID,sFrom,sTo,COPY_CHILD_MODELS;
3392: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3393: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3394: END IF;
3395: EXCEPTION
3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3397: retcode:=2;

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

3395: EXCEPTION
3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3397: retcode:=2;
3398: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3423: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3423: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3424: END;
3425:
3426: ------------------------------------------------------------------------------------------
3427:

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

3434: p_MODEL_ID IN NUMBER) IS
3435:
3436: BEGIN
3437: EXECUTE IMMEDIATE
3438: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3439: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3440: USING p_TARGET_INSTANCE,p_MODEL_ID;
3441: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3442: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3441: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3437: EXECUTE IMMEDIATE
3438: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3439: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3440: USING p_TARGET_INSTANCE,p_MODEL_ID;
3441: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3442: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: retcode:=2;

Line 3442: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3438: 'BEGIN CZ_BOM_SYNCH.report_model_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3439: ':p_TARGET_INSTANCE,:p_MODEL_ID); END;'
3440: USING p_TARGET_INSTANCE,p_MODEL_ID;
3441: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3442: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: retcode:=2;
3446: errbuf:=SQLERRM;

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

3455: p_TARGET_INSTANCE IN VARCHAR2) IS
3456:
3457: BEGIN
3458: EXECUTE IMMEDIATE
3459: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3460: ':p_TARGET_INSTANCE); END;'
3461: USING p_TARGET_INSTANCE;
3462: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3463: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3462: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3458: EXECUTE IMMEDIATE
3459: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3460: ':p_TARGET_INSTANCE); END;'
3461: USING p_TARGET_INSTANCE;
3462: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3463: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: retcode:=2;

Line 3463: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3459: 'BEGIN CZ_BOM_SYNCH.report_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3460: ':p_TARGET_INSTANCE); END;'
3461: USING p_TARGET_INSTANCE;
3462: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3463: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: retcode:=2;
3467: errbuf:=SQLERRM;

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

3481: FROM CZ_SERVERS
3482: WHERE import_enabled='1';
3483:
3484: EXECUTE IMMEDIATE
3485: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3486: ':v_TARGET_INSTANCE); END;'
3487: USING v_TARGET_INSTANCE;
3488: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3489: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

Line 3488: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;

3484: EXECUTE IMMEDIATE
3485: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3486: ':v_TARGET_INSTANCE); END;'
3487: USING v_TARGET_INSTANCE;
3488: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3489: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3490: EXCEPTION
3491: WHEN TOO_MANY_ROWS THEN
3492: retcode:=2;

Line 3489: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;

3485: 'BEGIN CZ_BOM_SYNCH.synchronize_all_models_cp(CZ_ORAAPPS_INTEGRATE.mERRBUF,CZ_ORAAPPS_INTEGRATE.mRETCODE,'||
3486: ':v_TARGET_INSTANCE); END;'
3487: USING v_TARGET_INSTANCE;
3488: errbuf :=CZ_ORAAPPS_INTEGRATE.mERRBUF;
3489: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3490: EXCEPTION
3491: WHEN TOO_MANY_ROWS THEN
3492: retcode:=2;
3493: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');