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 2964: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 2979: APP_EXCEPTION.RAISE_EXCEPTION;

2975: FALSE
2976: );
2977: end if;
2978: --Diagnostics End
2979: APP_EXCEPTION.RAISE_EXCEPTION;
2980: return EDR_CONSTANTS_GRP.g_error_status;
2981:
2982: when NO_ERES_SUBSCRIPTION THEN
2983: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');

Line 2995: APP_EXCEPTION.RAISE_EXCEPTION;

2991: );
2992: end if;
2993: --Diagnostics End
2994:
2995: APP_EXCEPTION.RAISE_EXCEPTION;
2996: return EDR_CONSTANTS_GRP.g_error_status;
2997:
2998: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2999: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');

Line 3010: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 3028: APP_EXCEPTION.RAISE_EXCEPTION;

3024: FALSE
3025: );
3026: end if;
3027: --Diagnostics End
3028: APP_EXCEPTION.RAISE_EXCEPTION;
3029: return EDR_CONSTANTS_GRP.g_error_status;
3030:
3031: --Bug 3667036: Start
3032: --Catch the XML to XML transformation error.

Line 3045: APP_EXCEPTION.RAISE_EXCEPTION;

3041: FALSE
3042: );
3043: end if;
3044: --Diagnostics End
3045: APP_EXCEPTION.RAISE_EXCEPTION;
3046: return EDR_CONSTANTS_GRP.g_error_status;
3047: --Bug 3667036: End
3048:
3049: --Bug 3893101: Start

Line 3062: APP_EXCEPTION.RAISE_EXCEPTION;

3058: FALSE
3059: );
3060: end if;
3061: --Diagnostics End
3062: APP_EXCEPTION.RAISE_EXCEPTION;
3063: return EDR_CONSTANTS_GRP.g_error_status;
3064: --Bug 3893101: End
3065:
3066: --Bug 4160412: Start

Line 3079: APP_EXCEPTION.RAISE_EXCEPTION;

3075: FALSE
3076: );
3077: end if;
3078: --Diagnostics End
3079: APP_EXCEPTION.RAISE_EXCEPTION;
3080: return EDR_CONSTANTS_GRP.g_error_status;
3081:
3082: WHEN INVALID_APPROVING_USERS THEN
3083: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');

Line 3095: APP_EXCEPTION.RAISE_EXCEPTION;

3091: FALSE
3092: );
3093: end if;
3094: --Diagnostics End
3095: APP_EXCEPTION.RAISE_EXCEPTION;
3096: return EDR_CONSTANTS_GRP.g_error_status;
3097:
3098: WHEN REPEATING_APPROVERS_ERR THEN
3099: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');

Line 3111: APP_EXCEPTION.RAISE_EXCEPTION;

3107: FALSE
3108: );
3109: end if;
3110: --Diagnostics End
3111: APP_EXCEPTION.RAISE_EXCEPTION;
3112: return EDR_CONSTANTS_GRP.g_error_status;
3113:
3114: WHEN INVALID_APPR_COUNT_ERR THEN
3115: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');

Line 3128: APP_EXCEPTION.RAISE_EXCEPTION;

3124: FALSE
3125: );
3126: end if;
3127: --Diagnostics End
3128: APP_EXCEPTION.RAISE_EXCEPTION;
3129: return EDR_CONSTANTS_GRP.g_error_status;
3130:
3131: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3132: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');

Line 3144: APP_EXCEPTION.RAISE_EXCEPTION;

3140: FALSE
3141: );
3142: end if;
3143: --Diagnostics End
3144: APP_EXCEPTION.RAISE_EXCEPTION;
3145: return EDR_CONSTANTS_GRP.g_error_status;
3146: --Bug 4160412: End
3147:
3148: --Bug 3960236: Start

Line 3162: APP_EXCEPTION.RAISE_EXCEPTION;

3158: FALSE
3159: );
3160: end if;
3161: --Diagnostics End
3162: APP_EXCEPTION.RAISE_EXCEPTION;
3163: return EDR_CONSTANTS_GRP.g_error_status;
3164: -- Bug 3960236 : end
3165:
3166:

Line 3180: APP_EXCEPTION.RAISE_EXCEPTION;

3176: FALSE
3177: );
3178: end if;
3179: --Diagnostics End
3180: APP_EXCEPTION.RAISE_EXCEPTION;
3181: return EDR_CONSTANTS_GRP.g_error_status;
3182: -- Bug 3960236 : end
3183:
3184: --Bug 5724159 :start

Line 3199: APP_EXCEPTION.RAISE_EXCEPTION;

3195: FALSE
3196: );
3197: end if;
3198: --Diagnostics End
3199: APP_EXCEPTION.RAISE_EXCEPTION;
3200: return EDR_CONSTANTS_GRP.g_error_status;
3201: --Bug 5724159 :End
3202:
3203: when others then

Line 3219: APP_EXCEPTION.RAISE_EXCEPTION;

3215: );
3216: end if;
3217: --Diagnostics End
3218:
3219: APP_EXCEPTION.RAISE_EXCEPTION;
3220: return EDR_CONSTANTS_GRP.g_error_status;
3221:
3222: end PSIG_RULE;
3223: