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.AR_CMGT_WF_ENGINE dependencies on WF_CORE

Line 155: wf_core.context ('AR_CMGT_WF_ENGINE','GET_EMPLOYEE_DETAILS',

151: p_display_name);
152: EXCEPTION
153: WHEN OTHERS
154: THEN
155: wf_core.context ('AR_CMGT_WF_ENGINE','GET_EMPLOYEE_DETAILS',
156: sqlerrm);
157: raise;
158: END;
159:

Line 465: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

461: FROM FND_USER
462: WHERE user_name = wf_engine.context_text;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
466: 'Employee Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
467: raise;
468: WHEN OTHERS THEN
469: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

Line 469: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

465: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
466: 'Employee Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
467: raise;
468: WHEN OTHERS THEN
469: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
470: 'Sqlerror while getiing Employee Id '||sqlerrm);
471: raise;
472: END;
473: BEGIN

Line 490: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

486:
487:
488: EXCEPTION
489: WHEN NO_DATA_FOUND THEN
490: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
491: 'Resource Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
492: raise;
493: WHEN OTHERS THEN
494: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

Line 494: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

490: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
491: 'Resource Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
492: raise;
493: WHEN OTHERS THEN
494: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
495: 'Sqlerror while getting Resource Id'||sqlerrm);
496: raise;
497: END;
498: get_employee_details(l_employee_id,l_user_name, l_display_name);

Line 674: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,

670: THEN
671: p_credit_analyst_id := NULL;
672: return;
673: WHEN OTHERS THEN
674: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,
675: 'Error While getting Rules Engine Parameter Details',sqlerrm);
676: raise;
677:
678:

Line 700: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,

696: p_credit_analyst_id := FUN_RULE_PUB.get_number;
697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,
701: 'Error While calling Rules Engine',sqlerrm);
702: raise;
703: END;
704:

Line 750: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,

746: EXCEPTION
747: WHEN NO_DATA_FOUND THEN
748: l_credit_analyst_id := NULL;
749: WHEN OTHERS THEN
750: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
751: 'Error While getting Credit Analyst Id',sqlerrm);
752: raise;
753: END;
754: END IF;

Line 775: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,

771: EXCEPTION
772: WHEN NO_DATA_FOUND THEN
773: l_credit_analyst_id := NULL;
774: WHEN OTHERS THEN
775: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
776: 'Error While validating Credit Analyst Id:'||l_credit_analyst_id,sqlerrm);
777: raise;
778: END;
779:

Line 796: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,

792: AND category = 'EMPLOYEE';
793:
794: EXCEPTION
795: WHEN OTHERS THEN
796: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
797: 'Error While getting Employee Id for Credit Analyst',sqlerrm);
798: raise;
799: END;
800:

Line 988: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_CREDIT_CLASSIFICATION',itemtype, itemkey,

984: END IF;
985:
986: EXCEPTION
987: WHEN others THEN
988: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_CREDIT_CLASSIFICATION',itemtype, itemkey,
989: sqlerrm);
990: raise;
991: END;
992:

Line 1095: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_APPLICATION_STATUS',itemtype, itemkey,

1091:
1092: EXCEPTION
1093: WHEN OTHERS
1094: THEN
1095: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_APPLICATION_STATUS',itemtype, itemkey,
1096: sqlerrm);
1097: raise;
1098: END;
1099:

Line 1137: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',itemtype, itemkey,

1133: THEN
1134: ar_cmgt_hz_cover_api.create_party_profile(p_party_id => l_party_id);
1135: WHEN OTHERS
1136: THEN
1137: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',itemtype, itemkey,
1138: sqlerrm);
1139: raise;
1140: END;
1141:

Line 1284: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1280:
1281: resultout := 'COMPLETE:NOTFOUND';
1282: --return;
1283: WHEN OTHERS THEN
1284: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1285: sqlerrm);
1286: raise;
1287: END;
1288:

Line 1384: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1380: aname => 'REQUESTOR_DISPLAY_NAME',
1381: avalue => l_requestor_user_name );
1382: EXCEPTION
1383: WHEN NO_DATA_FOUND THEN
1384: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1385: 'FND User Not Found'|| sqlerrm);
1386: raise;
1387: WHEN OTHERS THEN
1388: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

Line 1388: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1384: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1385: 'FND User Not Found'|| sqlerrm);
1386: raise;
1387: WHEN OTHERS THEN
1388: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1389: 'Other Error '|| sqlerrm);
1390: raise;
1391: END;
1392: END IF;

Line 1422: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN
1420: l_account_number := null;
1421: WHEN OTHERS THEN
1422: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1423: 'Getting Account Details SqlError: '|| sqlerrm);
1424: raise;
1425:
1426: END;

Line 1448: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1444: EXCEPTION
1445: WHEN NO_DATA_FOUND THEN
1446: -- in case of no_data_found Assign Credit Analyst and send notification
1447: -- to CA.
1448: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1449: 'No Check List found for the combination');
1450: resultout := 'COMPLETE:NOTFOUND';
1451: return;
1452: WHEN OTHERS THEN

Line 1453: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

1449: 'No Check List found for the combination');
1450: resultout := 'COMPLETE:NOTFOUND';
1451: return;
1452: WHEN OTHERS THEN
1453: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1454: sqlerrm);
1455: raise;
1456:
1457: END;

Line 1529: wf_core.context('AR_CMGT_WF_ENGINE','SET_ROUTING_STATUS',itemtype, itemkey,

1525:
1526: END IF;
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: wf_core.context('AR_CMGT_WF_ENGINE','SET_ROUTING_STATUS',itemtype, itemkey,
1530: sqlerrm);
1531: raise;
1532: END;
1533:

Line 1635: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_CURRENCY',itemtype, itemkey,

1631: resultout := 'COMPLETE:FAILURE';
1632: WHEN OTHERS THEN
1633: raise;
1634: resultout := 'COMPLETE:FAILURE';
1635: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_CURRENCY',itemtype, itemkey,
1636: sqlerrm);
1637: END;
1638:
1639: END IF;

Line 1669: wf_core.context('AR_CMGT_WF_ENGINE','UNDO_CASE_FOLDER',itemtype, itemkey,

1665: END IF;
1666: EXCEPTION
1667: WHEN OTHERS
1668: THEN
1669: wf_core.context('AR_CMGT_WF_ENGINE','UNDO_CASE_FOLDER',itemtype, itemkey,
1670: sqlerrm);
1671: raise;
1672: END;
1673:

Line 1717: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,

1713: FROM ar_cmgt_credit_requests
1714: WHERE credit_request_id = itemkey;
1715: EXCEPTION
1716: WHEN OTHERS THEN
1717: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
1718: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
1719: 'Sql Error: '||sqlerrm);
1720: raise;
1721: END;

Line 1773: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,

1769: return;
1770: END IF;
1771: IF l_resultout <> 0
1772: THEN
1773: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
1774: 'Unable to Generate Case Folder',l_error_message);
1775: raise BUILD_FAILURE;
1776: END IF;
1777: WF_ENGINE.setItemAttrNumber

Line 1809: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,

1805: WHEN NO_DATA_FOUND THEN
1806: l_case_folder_number := null;
1807: l_case_folder_date := null;
1808: WHEN OTHERS THEN
1809: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
1810: 'Unable to Get Case Folder Details, SqlError : '||sqlerrm);
1811: END;
1812: resultout := 'COMPLETE:SUCESS';
1813:

Line 1874: wf_core.context('AR_CMGT_WF_ENGINE','CALCULATE_SCORE',itemtype,

1870: END IF;
1871: END IF;
1872: EXCEPTION
1873: WHEN OTHERS THEN
1874: wf_core.context('AR_CMGT_WF_ENGINE','CALCULATE_SCORE',itemtype,
1875: itemkey, l_debug_msg, l_error_msg);
1876: raise;
1877: END;
1878:

Line 1940: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_AUTO_RULES',itemtype,

1936: EXCEPTION
1937: WHEN NO_DATA_FOUND THEN
1938: resultout := 'COMPLETE:NOTEXIST';
1939: WHEN OTHERS THEN
1940: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_AUTO_RULES',itemtype,
1941: itemkey, sqlerrm);
1942: raise;
1943: END;
1944: END IF;

Line 2001: wf_core.context('AR_CMGT_WF_ENGINE','OVERRIDE_CHECKLIST',itemtype,

1997: itemkey => itemkey,
1998: aname => 'SKIP_APPROVAL',
1999: avalue => 'N');
2000: WHEN OTHERS THEN
2001: wf_core.context('AR_CMGT_WF_ENGINE','OVERRIDE_CHECKLIST',itemtype,
2002: itemkey, sqlerrm);
2003: raise;
2004: END;
2005: END IF;

Line 2065: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_REQUIRED_DATA_POINTS',itemtype,

2061: THEN
2062: resultout := 'COMPLETE:FAILURE';
2063: ELSIF l_resultout = 1
2064: THEN
2065: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_REQUIRED_DATA_POINTS',itemtype,
2066: itemkey, l_errmsg);
2067: raise BUILD_FAILURE;
2068: END IF;
2069:

Line 2129: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Scoring Model Not Found '||

2125: WHERE score_model_id = l_score_model_id;
2126:
2127: EXCEPTION
2128: WHEN OTHERS THEN
2129: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Scoring Model Not Found '||
2130: 'Score Model Id : '||l_score_model_id ,itemtype,
2131: itemkey, sqlerrm);
2132: raise;
2133: END;

Line 2154: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Data Point Details Not Available '||

2150: return;
2151: END IF;
2152: EXCEPTION
2153: WHEN OTHERS THEN
2154: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Data Point Details Not Available '||
2155: 'for Data Point Id : '||dp_id_collec_rec.data_point_id ,itemtype,
2156: itemkey, sqlerrm);
2157: raise;
2158: END;

Line 2189: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS',itemtype,

2185: WHEN TOO_MANY_ROWS THEN
2186: resultout := 'COMPLETE:FAILURE';
2187: return;
2188: WHEN OTHERS THEN
2189: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS',itemtype,
2190: itemkey, sqlerrm);
2191: raise;
2192: END;
2193: ELSIF l_null_zero_flag = 'Y' AND

Line 2578: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_RECOMMENDATION',itemtype,

2574:
2575: END IF;
2576: EXCEPTION
2577: WHEN insert_failure THEN
2578: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_RECOMMENDATION',itemtype,
2579: itemkey,
2580: 'Error while inserting into ar_cmgt_cf_recommends',
2581: sqlerrm);
2582: raise;

Line 2626: wf_core.context('AR_CMGT_WF_ENGINE','APPROVAL_PROCESS',itemtype,

2622: ame_api.getadminapprover(adminapproverout => l_admin_approver_rec);
2623: IF l_approver_rec_out.person_id = l_admin_approver_rec.person_id
2624: THEN
2625:
2626: wf_core.context('AR_CMGT_WF_ENGINE','APPROVAL_PROCESS',itemtype,
2627: itemkey, 'Approver is Admin User', null);
2628: --raise;
2629: END IF;
2630:

Line 2829: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,

2825: p_error_msg => l_error_msg,
2826: p_return_status => l_return_status );
2827: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2828: THEN
2829: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,
2830: itemkey,
2831: 'Error while applying Customer Hold for Party : '||l_party_id||' Cust Account Id '||
2832: l_cust_account_id||' Site Use Id '|| l_site_use_id ||' '|| l_error_msg,
2833: sqlerrm);

Line 2848: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,

2844: p_error_msg => l_error_msg,
2845: p_return_status => l_return_status );
2846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2847: THEN
2848: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,
2849: itemkey,
2850: 'Error while applying Removing Hold for Party : '||l_party_id||' Cust Account Id '||
2851: l_cust_account_id||' Site Use Id '|| l_site_use_id ||' '|| l_error_msg,
2852: sqlerrm);

Line 2874: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2870:
2871: EXCEPTION
2872: WHEN NO_DATA_FOUND
2873: THEN
2874: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2875: itemkey,'No data found in recommendations for Appeal',
2876: sqlerrm);
2877: raise;
2878:

Line 2881: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2877: raise;
2878:
2879: WHEN OTHERS
2880: THEN
2881: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2882: itemkey,'Error accessing system options',
2883: sqlerrm);
2884: raise;
2885:

Line 2925: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2921:
2922: EXCEPTION
2923: WHEN NO_DATA_FOUND
2924: THEN
2925: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2926: itemkey,'No data found in customer profiles',
2927: sqlerrm);
2928: raise;
2929:

Line 2932: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2928: raise;
2929:
2930: WHEN OTHERS
2931: THEN
2932: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2933: itemkey,'Error accessing customer profiles',
2934: sqlerrm);
2935: raise;
2936:

Line 2960: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2956:
2957: EXCEPTION
2958: WHEN NO_DATA_FOUND
2959: THEN
2960: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2961: itemkey,'No data found in profile for updation',
2962: sqlerrm);
2963: raise;
2964:

Line 2967: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2963: raise;
2964:
2965: WHEN OTHERS
2966: THEN
2967: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2968: itemkey,'Error accessing customer profiles',
2969: sqlerrm);
2970: raise;
2971:

Line 2995: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2991:
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND
2994: THEN
2995: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
2996: itemkey,'No data found in cust profile for update',
2997: sqlerrm);
2998: raise;
2999:

Line 3002: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

2998: raise;
2999:
3000: WHEN OTHERS
3001: THEN
3002: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3003: itemkey,'Error accessing customer profile',
3004: sqlerrm);
3005: raise;
3006:

Line 3029: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

3025:
3026: EXCEPTION
3027: WHEN NO_DATA_FOUND
3028: THEN
3029: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3030: itemkey,'No data found in profile for updation',
3031: sqlerrm);
3032: raise;
3033:

Line 3036: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

3032: raise;
3033:
3034: WHEN OTHERS
3035: THEN
3036: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3037: itemkey,'Error accessing customer profiles',
3038: sqlerrm);
3039: raise;
3040:

Line 3177: wf_core.context('AR_CMGT_WF_ENGINE','POST_IMPLEMENT_PROCESS',itemtype,

3173: EXCEPTION
3174: WHEN NO_DATA_FOUND THEN
3175: NULL;
3176: WHEN OTHERS THEN
3177: wf_core.context('AR_CMGT_WF_ENGINE','POST_IMPLEMENT_PROCESS',itemtype,
3178: itemkey,
3179: 'Error while Getting Parent Credit Request Id',
3180: sqlerrm);
3181: raise;

Line 3214: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,

3210:
3211: raise_recco_event(l_case_folder_id);
3212: EXCEPTION
3213: WHEN OTHERS THEN
3214: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3215: itemkey,'Error while raise Business Event',
3216: sqlerrm);
3217: raise;
3218:

Line 3348: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_CHILD_REQ_COMPLETED',itemtype,

3344: WHEN TOO_MANY_ROWS THEN
3345: -- mean no credit request exists
3346: resultout := 'COMPLETE:N';
3347: WHEN OTHERS THEN
3348: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_CHILD_REQ_COMPLETED',itemtype,
3349: itemkey,'Error while Checking Child Credit Requests',
3350: sqlerrm);
3351: raise;
3352: END;

Line 3451: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,

3447: WHEN TOO_MANY_ROWS THEN
3448: resultout := 'COMPLETE:FAILURE';
3449: return;
3450: WHEN OTHERS THEN
3451: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,
3452: itemkey,'Error while validating Recommendations for Party',
3453: sqlerrm);
3454: raise;
3455:

Line 3477: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,

3473: END IF;
3474: END IF;
3475: EXCEPTION
3476: WHEN UNEXP_ERROR THEN
3477: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,
3478: itemkey,'Error while populating recommendation ',
3479: sqlerrm);
3480: raise;
3481: END;

Line 3556: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,

3552: FROM ar_cmgt_credit_requests
3553: WHERE credit_request_id = itemkey;
3554: EXCEPTION
3555: WHEN OTHERS THEN
3556: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
3557: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
3558: 'Sql Error: '||sqlerrm);
3559: raise;
3560: END;

Line 3590: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,

3586: WHERE CREDIT_REQUEST_ID = itemkey;
3587:
3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
3591: 'Error while getting parent records from AR_CMGT_CREDIT_REQUESTS',
3592: 'Sql Error: '||sqlerrm);
3593: raise;
3594: END;

Line 3608: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,

3604: and type = 'CASE';
3605:
3606: EXCEPTION
3607: WHEN OTHERS THEN
3608: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
3609: 'Error while getting parent records from AR_CMGT_CASE_FOLDERS',
3610: 'Sql Error: '||sqlerrm);
3611: raise;
3612: END;

Line 3926: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,

3922: hz_parties party
3923: WHERE credit_request_id = itemkey
3924: AND req.party_id = party.party_id;
3925: WHEN OTHERS THEN
3926: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
3927: sqlerrm);
3928: raise;
3929: END;
3930:

Line 4027: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,

4023: aname => 'REQUESTOR_DISPLAY_NAME',
4024: avalue => l_requestor_user_name );
4025: EXCEPTION
4026: WHEN NO_DATA_FOUND THEN
4027: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4028: 'FND User Not Found'|| sqlerrm);
4029: raise;
4030: WHEN OTHERS THEN
4031: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,

Line 4031: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,

4027: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4028: 'FND User Not Found'|| sqlerrm);
4029: raise;
4030: WHEN OTHERS THEN
4031: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4032: 'Other Error '|| sqlerrm);
4033: raise;
4034: END;
4035: END IF;

Line 4048: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,

4044: EXCEPTION
4045: WHEN NO_DATA_FOUND THEN
4046: l_account_number := null;
4047: WHEN OTHERS THEN
4048: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
4049: 'Getting Account Details SqlError: '|| sqlerrm);
4050: raise;
4051:
4052: END;

Line 4109: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,

4105: aname => 'SCORE_MODEL_ID',
4106: avalue => l_score_model_id);
4107: EXCEPTION
4108: WHEN OTHERS THEN
4109: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
4110: 'Error while getting Case Folder Details, SqlError: '|| sqlerrm);
4111: raise;
4112: END;
4113: END IF;

Line 4221: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_EXTRNAL_DATA_POINTS',itemtype,itemkey,

4217: END IF;
4218: END IF;
4219: EXCEPTION
4220: WHEN UNEXP_ERROR THEN
4221: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_EXTRNAL_DATA_POINTS',itemtype,itemkey,
4222: 'Error while submitting Con. Request Id, SqlError: '|| sqlerrm);
4223: raise;
4224: END;
4225: PROCEDURE GET_EXT_SCORE_RECOMMENDATIONS(