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_ADMIN

Line 3109: RAISE CZ_ADMIN.IMP_MODEL_NOT_FOUND;

3105: select decode(copy_child_models,'Y',0,'N',1,0) into lCopy_Child_Models from dual;
3106:
3107: EXCEPTION
3108: WHEN NO_DATA_FOUND THEN
3109: RAISE CZ_ADMIN.IMP_MODEL_NOT_FOUND;
3110: END;
3111:
3112: BEGIN
3113: SELECT local_name,fndnam_link_name,import_enabled

Line 3118: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3114: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3115: WHERE import_enabled='1';
3116: EXCEPTION
3117: WHEN TOO_MANY_ROWS THEN
3118: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3119: WHEN NO_DATA_FOUND THEN
3120: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3121: END;
3122:

Line 3120: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3116: EXCEPTION
3117: WHEN TOO_MANY_ROWS THEN
3118: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3119: WHEN NO_DATA_FOUND THEN
3120: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3121: END;
3122:
3123: ---- check DB Link ----
3124: v_link_status:=isLinkAlive(v_db_link);

Line 3127: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

3123: ---- check DB Link ----
3124: v_link_status:=isLinkAlive(v_db_link);
3125:
3126: IF v_link_status=LINK_IS_DOWN THEN
3127: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;
3128: ELSE
3129: ---- recreate views based on remote tables ----
3130: v_code:=create_exv_views(v_local_name);
3131: compile_Dependents('CZ_IMP%');

Line 3143: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

3139: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3140: END IF;
3141:
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

Line 3147: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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);
3151: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

Line 3151: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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);
3155: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

Line 3155: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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);
3159: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 3159: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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);
3163: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN

Line 3163: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN

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);
3167: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 3167: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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);
3171: WHEN OTHERS THEN

Line 3196: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

3192:
3193: COMMIT;
3194:
3195: EXCEPTION
3196: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3197: retcode:=2;
3198: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3199: log_report('REMOVEMODEL_CP: ' || errbuf);
3200: WHEN OTHERS THEN

Line 3224: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3220: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3221: WHERE import_enabled='1';
3222: EXCEPTION
3223: WHEN TOO_MANY_ROWS THEN
3224: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3225: WHEN NO_DATA_FOUND THEN
3226: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3227: END;
3228:

Line 3226: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3222: EXCEPTION
3223: WHEN TOO_MANY_ROWS THEN
3224: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3225: WHEN NO_DATA_FOUND THEN
3226: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3227: END;
3228:
3229: ---- check DB Link ----
3230: v_link_status:=isLinkAlive(v_db_link);

Line 3233: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

3229: ---- check DB Link ----
3230: v_link_status:=isLinkAlive(v_db_link);
3231:
3232: IF v_link_status=LINK_IS_DOWN THEN
3233: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;
3234: ELSE
3235: v_code:=create_exv_views(v_local_name);
3236: compile_Dependents('CZ_IMP%');
3237: EXECUTE IMMEDIATE

Line 3243: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3247: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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);
3251: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

Line 3251: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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);
3255: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

Line 3255: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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);
3259: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

Line 3259: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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);
3263: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 3263: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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);
3267: WHEN OTHERS THEN

Line 3296: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3292: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3293: WHERE import_enabled='1';
3294: EXCEPTION
3295: WHEN TOO_MANY_ROWS THEN
3296: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3297: WHEN NO_DATA_FOUND THEN
3298: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3299: END;
3300:

Line 3298: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3294: EXCEPTION
3295: WHEN TOO_MANY_ROWS THEN
3296: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3297: WHEN NO_DATA_FOUND THEN
3298: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3299: END;
3300:
3301: ---- check DB Link ----
3302: v_link_status:=isLinkAlive(v_db_link);

Line 3305: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

3301: ---- check DB Link ----
3302: v_link_status:=isLinkAlive(v_db_link);
3303:
3304: IF v_link_status=LINK_IS_DOWN THEN
3305: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;
3306: ELSE
3307: v_code:=create_exv_views(v_local_name);
3308: compile_Dependents('CZ_IMP%');
3309:

Line 3318: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3322: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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);
3326: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

Line 3326: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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);
3330: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

Line 3330: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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);
3334: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

Line 3334: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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);
3338: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 3338: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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);
3342: WHEN OTHERS THEN

Line 3374: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3370: INTO v_local_name,v_db_link,v_import_enabled FROM CZ_SERVERS
3371: WHERE import_enabled='1';
3372: EXCEPTION
3373: WHEN TOO_MANY_ROWS THEN
3374: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3375: WHEN NO_DATA_FOUND THEN
3376: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3377: END;
3378:

Line 3376: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3372: EXCEPTION
3373: WHEN TOO_MANY_ROWS THEN
3374: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3375: WHEN NO_DATA_FOUND THEN
3376: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3377: END;
3378:
3379: ---- check DB Link ----
3380: v_link_status:=isLinkAlive(v_db_link);

Line 3383: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

3379: ---- check DB Link ----
3380: v_link_status:=isLinkAlive(v_db_link);
3381:
3382: IF v_link_status=LINK_IS_DOWN THEN
3383: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;
3384: ELSE
3385: v_code:=create_exv_views(v_local_name);
3386: compile_Dependents('CZ_IMP%');
3387:

Line 3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

Line 3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

Line 3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

Line 3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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);
3420: WHEN OTHERS THEN

Line 3564: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

3560: log_report('UpdateImportFlag_cp: ' || errbuf);
3561: END IF;
3562:
3563: EXCEPTION
3564: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3565: retcode:=2;
3566: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3567: log_report('UpdateImportFlag_cp: ' || errbuf);
3568: WHEN OTHERS THEN