DBA Data[Home] [Help]

APPS.EDR_PSIG_RULE dependencies on APP_EXCEPTION

Line 1247: APP_EXCEPTION.RAISE_EXCEPTION;

1243: );
1244: end if;
1245: --Diagnostics End
1246:
1247: APP_EXCEPTION.RAISE_EXCEPTION;
1248: when ERECORD_CREATION_ERROR then
1249: ROLLBACK;
1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

Line 1266: APP_EXCEPTION.RAISE_EXCEPTION;

1262: );
1263: end if;
1264: --Diagnostics End
1265:
1266: APP_EXCEPTION.RAISE_EXCEPTION;
1267: when ERECORD_PARAM_ERROR then
1268: ROLLBACK;
1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

Line 1284: APP_EXCEPTION.RAISE_EXCEPTION;

1280: );
1281: end if;
1282: --Diagnostics End
1283:
1284: APP_EXCEPTION.RAISE_EXCEPTION;
1285:
1286: -- Bug 3170251 : Start - Added following new exceptions for error handling
1287: when ERECORD_GEN_XSLFOMISS_ERR then
1288: ROLLBACK;

Line 1302: APP_EXCEPTION.RAISE_EXCEPTION;

1298: FALSE
1299: );
1300: end if;
1301: --Diagnostics End
1302: APP_EXCEPTION.RAISE_EXCEPTION;
1303:
1304: when ERECORD_GEN_FATALERR then
1305: ROLLBACK;
1306: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

Line 1325: APP_EXCEPTION.RAISE_EXCEPTION;

1321: );
1322: end if;
1323: --Diagnostics End
1324:
1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: when ERECORD_GEN_UNKNWN_ERR then
1327: ROLLBACK;
1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

Line 1344: APP_EXCEPTION.RAISE_EXCEPTION;

1340: );
1341: end if;
1342: --Diagnostics End
1343:
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345: when ERECORD_GEN_XDOERR then
1346: ROLLBACK;
1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');

Line 1362: APP_EXCEPTION.RAISE_EXCEPTION;

1358: );
1359: end if;
1360: --Diagnostics End
1361:
1362: APP_EXCEPTION.RAISE_EXCEPTION;
1363: when ERECORD_UNKWN_TMPL_TYPE then
1364: ROLLBACK;
1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);

Line 1380: APP_EXCEPTION.RAISE_EXCEPTION;

1376: );
1377: end if;
1378: --Diagnostics End
1379:
1380: APP_EXCEPTION.RAISE_EXCEPTION;
1381:
1382: when ERECORD_GEN_JSPMSNG_ERR then
1383: ROLLBACK;
1384: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

Line 1397: APP_EXCEPTION.RAISE_EXCEPTION;

1393: );
1394: end if;
1395: --Diagnostics End
1396:
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: when ERECORD_GEN_JSPRQFAIL_ERR then
1399: ROLLBACK;
1400: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1401: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP UTL_HTTP REQUEST FAILED');

Line 1413: APP_EXCEPTION.RAISE_EXCEPTION;

1409: );
1410: end if;
1411: --Diagnostics End
1412:
1413: APP_EXCEPTION.RAISE_EXCEPTION;
1414: -- Bug 3170251 : End
1415:
1416: -- Bug 3390571 : Start
1417: when ERECORD_GEN_XSLT_ERR then

Line 1432: APP_EXCEPTION.RAISE_EXCEPTION;

1428: FALSE
1429: );
1430: end if;
1431: --Diagnostics End
1432: APP_EXCEPTION.RAISE_EXCEPTION;
1433:
1434: --Bug 3390571: End
1435:
1436: --Bug 2637353: Start

Line 1446: APP_EXCEPTION.RAISE_EXCEPTION;

1442: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1443: FALSE
1444: );
1445: end if;
1446: APP_EXCEPTION.RAISE_EXCEPTION;
1447: --Diagnostics End
1448: --Bug 2637353: End
1449:
1450:

Line 1469: APP_EXCEPTION.RAISE_EXCEPTION;

1465: end if;
1466: --Diagnostics End
1467:
1468:
1469: APP_EXCEPTION.RAISE_EXCEPTION;
1470: END STORE_ERECORD;
1471:
1472: -------------------------------------------------------------------------------------------------------------------------------------
1473:

Line 2960: APP_EXCEPTION.RAISE_EXCEPTION;

2956: --Bug 4577122: Start
2957: when INVALID_FIRST_VOTER_WINS_SETUP then
2958: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');
2959: fnd_message.set_token( 'EVENT', l_error_event);
2960: APP_EXCEPTION.RAISE_EXCEPTION;
2961: return EDR_CONSTANTS_GRP.g_error_status;
2962: --Bug 4577122: End
2963:
2964: when NO_ENABLED_ERES_SUBSCRIPTION THEN

Line 2975: APP_EXCEPTION.RAISE_EXCEPTION;

2971: FALSE
2972: );
2973: end if;
2974: --Diagnostics End
2975: APP_EXCEPTION.RAISE_EXCEPTION;
2976: return EDR_CONSTANTS_GRP.g_error_status;
2977:
2978: when NO_ERES_SUBSCRIPTION THEN
2979: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');

Line 2991: APP_EXCEPTION.RAISE_EXCEPTION;

2987: );
2988: end if;
2989: --Diagnostics End
2990:
2991: APP_EXCEPTION.RAISE_EXCEPTION;
2992: return EDR_CONSTANTS_GRP.g_error_status;
2993:
2994: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2995: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');

Line 3006: APP_EXCEPTION.RAISE_EXCEPTION;

3002: );
3003: end if;
3004: --Diagnostics End
3005:
3006: APP_EXCEPTION.RAISE_EXCEPTION;
3007: return EDR_CONSTANTS_GRP.g_error_status;
3008:
3009: when PAGE_FLOW_FAILED then
3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);

Line 3024: APP_EXCEPTION.RAISE_EXCEPTION;

3020: FALSE
3021: );
3022: end if;
3023: --Diagnostics End
3024: APP_EXCEPTION.RAISE_EXCEPTION;
3025: return EDR_CONSTANTS_GRP.g_error_status;
3026:
3027: --Bug 3667036: Start
3028: --Catch the XML to XML transformation error.

Line 3041: APP_EXCEPTION.RAISE_EXCEPTION;

3037: FALSE
3038: );
3039: end if;
3040: --Diagnostics End
3041: APP_EXCEPTION.RAISE_EXCEPTION;
3042: return EDR_CONSTANTS_GRP.g_error_status;
3043: --Bug 3667036: End
3044:
3045: --Bug 3893101: Start

Line 3058: APP_EXCEPTION.RAISE_EXCEPTION;

3054: FALSE
3055: );
3056: end if;
3057: --Diagnostics End
3058: APP_EXCEPTION.RAISE_EXCEPTION;
3059: return EDR_CONSTANTS_GRP.g_error_status;
3060: --Bug 3893101: End
3061:
3062: --Bug 4160412: Start

Line 3075: APP_EXCEPTION.RAISE_EXCEPTION;

3071: FALSE
3072: );
3073: end if;
3074: --Diagnostics End
3075: APP_EXCEPTION.RAISE_EXCEPTION;
3076: return EDR_CONSTANTS_GRP.g_error_status;
3077:
3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');

Line 3091: APP_EXCEPTION.RAISE_EXCEPTION;

3087: FALSE
3088: );
3089: end if;
3090: --Diagnostics End
3091: APP_EXCEPTION.RAISE_EXCEPTION;
3092: return EDR_CONSTANTS_GRP.g_error_status;
3093:
3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');

Line 3107: APP_EXCEPTION.RAISE_EXCEPTION;

3103: FALSE
3104: );
3105: end if;
3106: --Diagnostics End
3107: APP_EXCEPTION.RAISE_EXCEPTION;
3108: return EDR_CONSTANTS_GRP.g_error_status;
3109:
3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');

Line 3124: APP_EXCEPTION.RAISE_EXCEPTION;

3120: FALSE
3121: );
3122: end if;
3123: --Diagnostics End
3124: APP_EXCEPTION.RAISE_EXCEPTION;
3125: return EDR_CONSTANTS_GRP.g_error_status;
3126:
3127: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');

Line 3140: APP_EXCEPTION.RAISE_EXCEPTION;

3136: FALSE
3137: );
3138: end if;
3139: --Diagnostics End
3140: APP_EXCEPTION.RAISE_EXCEPTION;
3141: return EDR_CONSTANTS_GRP.g_error_status;
3142: --Bug 4160412: End
3143:
3144: --Bug 3960236: Start

Line 3158: APP_EXCEPTION.RAISE_EXCEPTION;

3154: FALSE
3155: );
3156: end if;
3157: --Diagnostics End
3158: APP_EXCEPTION.RAISE_EXCEPTION;
3159: return EDR_CONSTANTS_GRP.g_error_status;
3160: -- Bug 3960236 : end
3161:
3162:

Line 3176: APP_EXCEPTION.RAISE_EXCEPTION;

3172: FALSE
3173: );
3174: end if;
3175: --Diagnostics End
3176: APP_EXCEPTION.RAISE_EXCEPTION;
3177: return EDR_CONSTANTS_GRP.g_error_status;
3178: -- Bug 3960236 : end
3179:
3180: --Bug 5724159 :start

Line 3195: APP_EXCEPTION.RAISE_EXCEPTION;

3191: FALSE
3192: );
3193: end if;
3194: --Diagnostics End
3195: APP_EXCEPTION.RAISE_EXCEPTION;
3196: return EDR_CONSTANTS_GRP.g_error_status;
3197: --Bug 5724159 :End
3198:
3199: when others then

Line 3215: APP_EXCEPTION.RAISE_EXCEPTION;

3211: );
3212: end if;
3213: --Diagnostics End
3214:
3215: APP_EXCEPTION.RAISE_EXCEPTION;
3216: return EDR_CONSTANTS_GRP.g_error_status;
3217:
3218: end PSIG_RULE;
3219: