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 3107: RAISE CZ_ADMIN.IMP_MODEL_NOT_FOUND;

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

Line 3116: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

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

Line 3118: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

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

Line 3125: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

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

Line 3141: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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

Line 3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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

Line 3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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

Line 3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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

Line 3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN

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

Line 3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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

Line 3194: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3222: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

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

Line 3224: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

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

Line 3231: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

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

Line 3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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

Line 3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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

Line 3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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

Line 3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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

Line 3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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

Line 3294: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

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

Line 3296: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

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

Line 3303: RAISE CZ_ADMIN.IMP_LINK_IS_DOWN;

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

Line 3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

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

Line 3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

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

Line 3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN

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

Line 3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN

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

Line 3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN

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

Line 3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

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