DBA Data[Home] [Help]

APPS.EDR_PSIG_RULE dependencies on WF_CORE

Line 458: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);

454: when BAD_RULE then
455:
456: /* Update workflow threshold to saved value */
457: WF_ENGINE.THRESHOLD := l_cur_threshold;
458: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
459: wf_event.setErrorInfo(p_eventP,'ERROR');
460: ROLLBACK;
461: p_err_code:=l_error;
462: p_err_msg:=l_error_msg;

Line 482: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);

478:
479: when DEFAULT_RULE_ERROR then
480: /* Update workflow threshold to saved value */
481: WF_ENGINE.THRESHOLD := l_cur_threshold;
482: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
483: wf_event.setErrorInfo(p_eventP,'ERROR');
484: ROLLBACK;
485: p_err_code:=l_error;
486: p_err_msg:= l_error_msg;

Line 505: Wf_Core.get_ERROR(l_error,l_error_msg,l_error_stack);

501: return 'ERROR';
502:
503: when others then
504: /* Udate workflow threshold to saved value */
505: Wf_Core.get_ERROR(l_error,l_error_msg,l_error_stack);
506: wf_log_pkg.string(6,'in when others of create_pageflow'||l_error,l_error_msg||substr(l_error_stack,1,100));
507: WF_ENGINE.THRESHOLD := l_cur_threshold;
508: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
509: wf_event.setErrorInfo(p_eventP,'ERROR');

Line 508: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);

504: /* Udate workflow threshold to saved value */
505: Wf_Core.get_ERROR(l_error,l_error_msg,l_error_stack);
506: wf_log_pkg.string(6,'in when others of create_pageflow'||l_error,l_error_msg||substr(l_error_stack,1,100));
507: WF_ENGINE.THRESHOLD := l_cur_threshold;
508: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
509: wf_event.setErrorInfo(p_eventP,'ERROR');
510: ROLLBACK;
511: p_err_code:=l_error;
512: p_err_msg:=l_error_msg;

Line 1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);

1227:
1228: EXCEPTION
1229: when ERECORD_GENERATION_ERROR then
1230: ROLLBACK;
1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);

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');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);

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');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

1285:
1286: -- Bug 3170251 : Start - Added following new exceptions for error handling
1287: when ERECORD_GEN_XSLFOMISS_ERR then
1288: ROLLBACK;
1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');
1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');
1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

Line 1306: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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);
1307: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1308:
1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');
1310:

Line 1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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');
1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');
1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

Line 1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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);
1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');
1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

Line 1384: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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);
1385: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP MISSING');
1386: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSP_MISSING_ERR');
1387:
1388: --Diagnostics Start

Line 1400: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

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');
1402: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSPREQFAIL_ERR');
1403:
1404: --Diagnostics Start

Line 1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

1415:
1416: -- Bug 3390571 : Start
1417: when ERECORD_GEN_XSLT_ERR then
1418: ROLLBACK;
1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');
1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');
1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

Line 1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);

1449:
1450:
1451: when OTHERS then
1452: ROLLBACK;
1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1849: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

1845: and a.name = l_parent_event
1846: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1847: --Bug No 4912782- Start
1848: and b.source_type = 'LOCAL'
1849: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
1850: --Bug No 4912782- End
1851:
1852: IF l_no_enabled_eres_sub > 1 then
1853:

Line 1868: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

1864: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1865: and b.STATUS = 'ENABLED'
1866: --Bug No 4912782- Start
1867: and b.source_type = 'LOCAL'
1868: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
1869: --Bug No 4912782- End
1870:
1871: IF l_no_enabled_eres_sub > 1 THEN
1872: l_error_event := l_parent_event;

Line 1925: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

1921: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1922: and b.STATUS = 'ENABLED'
1923: --Bug No 4912782- Start
1924: and b.source_type = 'LOCAL'
1925: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
1926: --Bug No 4912782- End
1927:
1928: IF l_no_enabled_eres_sub > 1 THEN
1929: l_error_event := p_event.event_name;

Line 3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);

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);
3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);

3196: return EDR_CONSTANTS_GRP.g_error_status;
3197: --Bug 5724159 :End
3198:
3199: when others then
3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3201: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');