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 AR_CMGT_WF_ENGINE

Line 1: Package BODY AR_CMGT_WF_ENGINE AS

1: Package BODY AR_CMGT_WF_ENGINE AS
2: /* $Header: ARCMGWFB.pls 120.67 2011/08/02 14:39:47 mraymond ship $ */
3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:

Line 9: ar_cmgt_util.wf_debug ('AR_CMGT_WF_ENGINE',p_message_name );

5:
6: PROCEDURE debug (
7: p_message_name IN VARCHAR2 ) IS
8: BEGIN
9: ar_cmgt_util.wf_debug ('AR_CMGT_WF_ENGINE',p_message_name );
10: END;
11:
12:
13: PROCEDURE raise_recco_event (p_case_folder_id IN NUMBER) AS

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 312: p_errmsg := 'Error in ar_cmgt_wf_engine.validate_reference_data_points '|| sqlerrm;

308: END IF;
309: END LOOP;
310: EXCEPTION
311: WHEN OTHERS THEN
312: p_errmsg := 'Error in ar_cmgt_wf_engine.validate_reference_data_points '|| sqlerrm;
313: p_resultout := 1;
314: return;
315: END;
316: PROCEDURE VALIDATE_REQUIRED_DATA_POINTS (

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

482: FROM FND_USER
483: WHERE user_name = wf_engine.context_text;
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
487: 'Employee Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
488: raise;
489: WHEN OTHERS THEN
490: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

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

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

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

507:
508:
509: EXCEPTION
510: WHEN NO_DATA_FOUND THEN
511: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
512: 'Resource Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
513: raise;
514: WHEN OTHERS THEN
515: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

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

511: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
512: 'Resource Id Not found for User:'||wf_engine.context_text ||' '||'Sqlerror '||sqlerrm);
513: raise;
514: WHEN OTHERS THEN
515: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,
516: 'Sqlerror while getting Resource Id'||sqlerrm);
517: raise;
518: END;
519: get_employee_details(l_employee_id,l_user_name, l_display_name);

Line 704: debug('ar_cmgt_wf_engine.getCAfromrulesengine()+');

700:
701: BEGIN
702: IF pg_wf_debug = 'Y'
703: THEN
704: debug('ar_cmgt_wf_engine.getCAfromrulesengine()+');
705: debug(' p_credit_request_id = ' || p_credit_request_id);
706: END IF;
707: /* 7113063 Make sure guarantor CR/CF are assigned to the same
708: analyst as the parent CR/CF. We'll do that by using the

Line 735: debug('ar_cmgt_wf_engine.getCAfromrulesengine()-');

731: IF pg_wf_debug = 'Y'
732: THEN
733: debug(' Using parent analyst directly');
734: debug(' returning p_analyst_id = ' || l_parent_analyst_id);
735: debug('ar_cmgt_wf_engine.getCAfromrulesengine()-');
736: END IF;
737:
738: p_credit_analyst_id := l_parent_analyst_id;
739: RETURN;

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

787: THEN
788: p_credit_analyst_id := NULL;
789: return;
790: WHEN OTHERS THEN
791: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,
792: 'Error While getting Rules Engine Parameter Details',sqlerrm);
793: raise;
794:
795:

Line 860: debug('ar_cmgt_wf_engine.getCAfromrulesengine()-');

856:
857: IF pg_wf_debug = 'Y'
858: THEN
859: debug(' returning credit_analyst_id = ' || p_credit_analyst_id);
860: debug('ar_cmgt_wf_engine.getCAfromrulesengine()-');
861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN

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

861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,
866: 'Error While calling Rules Engine',sqlerrm);
867: raise;
868: END;
869:

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

911: EXCEPTION
912: WHEN NO_DATA_FOUND THEN
913: l_credit_analyst_id := NULL;
914: WHEN OTHERS THEN
915: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
916: 'Error While getting Credit Analyst Id',sqlerrm);
917: raise;
918: END;
919: END IF;

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

936: EXCEPTION
937: WHEN NO_DATA_FOUND THEN
938: l_credit_analyst_id := NULL;
939: WHEN OTHERS THEN
940: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
941: 'Error While validating Credit Analyst Id:'||l_credit_analyst_id,sqlerrm);
942: raise;
943: END;
944:

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

957: AND category = 'EMPLOYEE';
958:
959: EXCEPTION
960: WHEN OTHERS THEN
961: wf_core.context('AR_CMGT_WF_ENGINE','ASSIGN_CREDIT_ANALYST',itemtype, itemkey,
962: 'Error While getting Employee Id for Credit Analyst',sqlerrm);
963: raise;
964: END;
965:

Line 1037: debug('ar_cmgt_wf_engine.start_workflow()+');

1033:
1034: BEGIN
1035:
1036: IF pg_wf_debug = 'Y' THEN
1037: debug('ar_cmgt_wf_engine.start_workflow()+');
1038: debug(' p_credit_request_id = ' || p_credit_request_id);
1039: debug(' p_application_status = ' || p_application_status);
1040: END IF;
1041:

Line 1125: debug('ar_cmgt_wf_engine.start_workflow()-');

1121:
1122: WF_ENGINE.threshold := l_save_threshold;
1123:
1124: IF pg_wf_debug = 'Y' THEN
1125: debug('ar_cmgt_wf_engine.start_workflow()-');
1126: END IF;
1127: END;
1128:
1129: PROCEDURE GENERATE_CREDIT_CLASSIFICATION (

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

1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN others THEN
1170: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_CREDIT_CLASSIFICATION',itemtype, itemkey,
1171: sqlerrm);
1172: raise;
1173: END;
1174:

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

1273:
1274: EXCEPTION
1275: WHEN OTHERS
1276: THEN
1277: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_APPLICATION_STATUS',itemtype, itemkey,
1278: sqlerrm);
1279: raise;
1280: END;
1281:

Line 1297: debug('ar_cmgt_wf_engine.create_party_profile()+');

1293: l_return_status VARCHAR2(1);
1294: BEGIN
1295: IF pg_wf_debug = 'Y'
1296: THEN
1297: debug('ar_cmgt_wf_engine.create_party_profile()+');
1298: END IF;
1299:
1300: -- need to check and if not exists then craeet party profile(ARCMHZCB.pls AR_CMGT_HZ_COVER_API)
1301: IF funcmode = 'RUN'

Line 1360: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',

1356: IF pg_wf_debug = 'Y'
1357: THEN
1358: debug(' TCA API failed to create party profile');
1359: END IF;
1360: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',
1361: itemtype, itemkey, 'TCA API failure');
1362: raise;
1363: END IF;
1364:

Line 1367: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',

1363: END IF;
1364:
1365: WHEN OTHERS
1366: THEN
1367: wf_core.context('AR_CMGT_WF_ENGINE','CREATE_PARTY_PROFILE',
1368: itemtype, itemkey,sqlerrm);
1369: raise;
1370: END;
1371:

Line 1385: debug('ar_cmgt_wf_engine.create_party_profile()-');

1381: END IF;
1382:
1383: IF pg_wf_debug = 'Y'
1384: THEN
1385: debug('ar_cmgt_wf_engine.create_party_profile()-');
1386: END IF;
1387: END;
1388:
1389: PROCEDURE CHECK_CREDIT_POLICY (

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

1524:
1525: resultout := 'COMPLETE:NOTFOUND';
1526: --return;
1527: WHEN OTHERS THEN
1528: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1529: sqlerrm);
1530: raise;
1531: END;
1532:

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

1624: aname => 'REQUESTOR_DISPLAY_NAME',
1625: avalue => l_requestor_user_name );
1626: EXCEPTION
1627: WHEN NO_DATA_FOUND THEN
1628: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1629: 'FND User Not Found'|| sqlerrm);
1630: raise;
1631: WHEN OTHERS THEN
1632: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,

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

1628: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1629: 'FND User Not Found'|| sqlerrm);
1630: raise;
1631: WHEN OTHERS THEN
1632: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1633: 'Other Error '|| sqlerrm);
1634: raise;
1635: END;
1636: END IF;

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

1662: EXCEPTION
1663: WHEN NO_DATA_FOUND THEN
1664: l_account_number := null;
1665: WHEN OTHERS THEN
1666: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1667: 'Getting Account Details SqlError: '|| sqlerrm);
1668: raise;
1669:
1670: END;

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

1688: EXCEPTION
1689: WHEN NO_DATA_FOUND THEN
1690: -- in case of no_data_found Assign Credit Analyst and send notification
1691: -- to CA.
1692: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1693: 'No Check List found for the combination');
1694: resultout := 'COMPLETE:NOTFOUND';
1695: return;
1696: WHEN OTHERS THEN

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

1693: 'No Check List found for the combination');
1694: resultout := 'COMPLETE:NOTFOUND';
1695: return;
1696: WHEN OTHERS THEN
1697: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1698: sqlerrm);
1699: raise;
1700:
1701: END;

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

1814:
1815: END IF;
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: wf_core.context('AR_CMGT_WF_ENGINE','SET_ROUTING_STATUS',itemtype, itemkey,
1819: sqlerrm);
1820: raise;
1821: END;
1822:

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

1943: resultout := 'COMPLETE:FAILURE';
1944: WHEN OTHERS THEN
1945: raise;
1946: resultout := 'COMPLETE:FAILURE';
1947: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_CURRENCY',itemtype, itemkey,
1948: sqlerrm);
1949: END;
1950:
1951: END IF;

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

1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS
1980: THEN
1981: wf_core.context('AR_CMGT_WF_ENGINE','UNDO_CASE_FOLDER',itemtype, itemkey,
1982: sqlerrm);
1983: raise;
1984: END;
1985:

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

2025: FROM ar_cmgt_credit_requests
2026: WHERE credit_request_id = itemkey;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
2030: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
2031: 'Sql Error: '||sqlerrm);
2032: raise;
2033: END;

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

2081: return;
2082: END IF;
2083: IF l_resultout <> 0
2084: THEN
2085: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
2086: 'Unable to Generate Case Folder',l_error_message);
2087: raise BUILD_FAILURE;
2088: END IF;
2089: WF_ENGINE.setItemAttrNumber

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

2117: WHEN NO_DATA_FOUND THEN
2118: l_case_folder_number := null;
2119: l_case_folder_date := null;
2120: WHEN OTHERS THEN
2121: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
2122: 'Unable to Get Case Folder Details, SqlError : '||sqlerrm);
2123: END;
2124: resultout := 'COMPLETE:SUCESS';
2125:

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

2182: END IF;
2183: END IF;
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: wf_core.context('AR_CMGT_WF_ENGINE','CALCULATE_SCORE',itemtype,
2187: itemkey, l_debug_msg, l_error_msg);
2188: raise;
2189: END;
2190:

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

2248: EXCEPTION
2249: WHEN NO_DATA_FOUND THEN
2250: resultout := 'COMPLETE:NOTEXIST';
2251: WHEN OTHERS THEN
2252: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_AUTO_RULES',itemtype,
2253: itemkey, sqlerrm);
2254: raise;
2255: END;
2256: END IF;

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

2326: itemkey => itemkey,
2327: aname => 'SKIP_APPROVAL',
2328: avalue => 'N');
2329: WHEN OTHERS THEN
2330: wf_core.context('AR_CMGT_WF_ENGINE','OVERRIDE_CHECKLIST',itemtype,
2331: itemkey, sqlerrm);
2332: raise;
2333: END;
2334: END IF;

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

2390: THEN
2391: resultout := 'COMPLETE:FAILURE';
2392: ELSIF l_resultout = 1
2393: THEN
2394: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_REQUIRED_DATA_POINTS',itemtype,
2395: itemkey, l_errmsg);
2396: raise BUILD_FAILURE;
2397: END IF;
2398:

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

2454: WHERE score_model_id = l_score_model_id;
2455:
2456: EXCEPTION
2457: WHEN OTHERS THEN
2458: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Scoring Model Not Found '||
2459: 'Score Model Id : '||l_score_model_id ,itemtype,
2460: itemkey, sqlerrm);
2461: raise;
2462: END;

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

2479: return;
2480: END IF;
2481: EXCEPTION
2482: WHEN OTHERS THEN
2483: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS, Data Point Details Not Available '||
2484: 'for Data Point Id : '||dp_id_collec_rec.data_point_id ,itemtype,
2485: itemkey, sqlerrm);
2486: raise;
2487: END;

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

2514: WHEN TOO_MANY_ROWS THEN
2515: resultout := 'COMPLETE:FAILURE';
2516: return;
2517: WHEN OTHERS THEN
2518: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_SCORING_DATA_POINTS',itemtype,
2519: itemkey, sqlerrm);
2520: raise;
2521: END;
2522: ELSIF l_null_zero_flag = 'Y' AND

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

2948:
2949: END IF;
2950: EXCEPTION
2951: WHEN insert_failure THEN
2952: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_RECOMMENDATION',itemtype,
2953: itemkey,
2954: 'Error while inserting into ar_cmgt_cf_recommends',
2955: sqlerrm);
2956: raise;

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

2996: ame_api.getadminapprover(adminapproverout => l_admin_approver_rec);
2997: IF l_approver_rec_out.person_id = l_admin_approver_rec.person_id
2998: THEN
2999:
3000: wf_core.context('AR_CMGT_WF_ENGINE','APPROVAL_PROCESS',itemtype,
3001: itemkey, 'Approver is Admin User', null);
3002: --raise;
3003: END IF;
3004:

Line 3203: debug('ar_cmgt_wf_engine.implement_recommendation()+');

3199: l_amount ar_cmgt_cf_recommends.RECOMMENDATION_VALUE2%TYPE;
3200: BEGIN
3201: IF pg_wf_debug = 'Y'
3202: THEN
3203: debug('ar_cmgt_wf_engine.implement_recommendation()+');
3204: END IF;
3205:
3206: IF funcmode = 'RUN'
3207: THEN

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

3294: x_msg_data => l_error_msg);
3295:
3296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3297: THEN
3298: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,
3299: itemkey,
3300: 'Error while applying Customer Hold for Party : '||l_party_id||' Cust Account Id '||
3301: l_cust_account_id||' Site Use Id '|| l_site_use_id ||' '|| l_error_msg,
3302: sqlerrm);

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

3329: x_msg_data => l_error_msg);
3330:
3331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3332: THEN
3333: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_RECOMMENDATION',itemtype,
3334: itemkey,
3335: 'Error while applying Removing Hold for Party : '||l_party_id||' Cust Account Id '||
3336: l_cust_account_id||' Site Use Id '|| l_site_use_id ||' '|| l_error_msg,
3337: sqlerrm);

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

3355:
3356: EXCEPTION
3357: WHEN NO_DATA_FOUND
3358: THEN
3359: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3360: itemkey,'No data found in recommendations for Appeal',
3361: sqlerrm);
3362: raise;
3363:

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

3362: raise;
3363:
3364: WHEN OTHERS
3365: THEN
3366: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3367: itemkey,'Error accessing system options',
3368: sqlerrm);
3369: raise;
3370:

Line 3456: debug('ar_cmgt_wf_engine.implement_recommendation()-');

3452: END IF;
3453:
3454: IF pg_wf_debug = 'Y'
3455: THEN
3456: debug('ar_cmgt_wf_engine.implement_recommendation()-');
3457: END IF;
3458:
3459: EXCEPTION
3460: WHEN HOLD_ERROR THEN

Line 3599: ar_cmgt_wf_engine.start_workflow (

3595: AND a.parent_credit_request_id = b.credit_request_id
3596: AND b.status <> 'PROCESSED';
3597:
3598: -- rows exist, so start workflow
3599: ar_cmgt_wf_engine.start_workflow (
3600: p_credit_request_id => l_parent_credit_request_id,
3601: p_application_status => 'SUBMIT' );
3602:
3603: EXCEPTION

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

3603: EXCEPTION
3604: WHEN NO_DATA_FOUND THEN
3605: NULL;
3606: WHEN OTHERS THEN
3607: wf_core.context('AR_CMGT_WF_ENGINE','POST_IMPLEMENT_PROCESS',itemtype,
3608: itemkey,
3609: 'Error while Getting Parent Credit Request Id',
3610: sqlerrm);
3611: raise;

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

3640:
3641: raise_recco_event(l_case_folder_id);
3642: EXCEPTION
3643: WHEN OTHERS THEN
3644: wf_core.context('AR_CMGT_WF_ENGINE','IMPLEMENT_CUSTOM_RECO',itemtype,
3645: itemkey,'Error while raise Business Event',
3646: sqlerrm);
3647: raise;
3648:

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

3852: WHEN TOO_MANY_ROWS THEN
3853: -- mean no credit request exists
3854: resultout := 'COMPLETE:N';
3855: WHEN OTHERS THEN
3856: wf_core.context('AR_CMGT_WF_ENGINE','CHECK_CHILD_REQ_COMPLETED',itemtype,
3857: itemkey,'Error while Checking Child Credit Requests',
3858: sqlerrm);
3859: raise;
3860: END;

Line 3925: AR_CMGT_WF_ENGINE.GET_EXT_SCORE_RECOMMENDATIONS(

3921: IF l_reco_exist = 'N' and nvl(l_credit_request_type,'CREDIT_APP') <> 'GUARANTOR'
3922: THEN
3923: --call the program for populating the recommendations
3924: --before validating.
3925: AR_CMGT_WF_ENGINE.GET_EXT_SCORE_RECOMMENDATIONS(
3926: itemtype => itemtype,
3927: itemkey => itemkey,
3928: p_cf_id => l_case_folder_id,
3929: resultout=> resultout);

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

3955: WHEN TOO_MANY_ROWS THEN
3956: resultout := 'COMPLETE:FAILURE';
3957: return;
3958: WHEN OTHERS THEN
3959: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,
3960: itemkey,'Error while validating Recommendations for Party',
3961: sqlerrm);
3962: raise;
3963:

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

3981: END IF;
3982: END IF;
3983: EXCEPTION
3984: WHEN UNEXP_ERROR THEN
3985: wf_core.context('AR_CMGT_WF_ENGINE','VALIDATE_RECOMMENDATIONS',itemtype,
3986: itemkey,'Error while populating recommendation ',
3987: sqlerrm);
3988: raise;
3989: END;

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

4060: FROM ar_cmgt_credit_requests
4061: WHERE credit_request_id = itemkey;
4062: EXCEPTION
4063: WHEN OTHERS THEN
4064: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4065: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
4066: 'Sql Error: '||sqlerrm);
4067: raise;
4068: END;

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

4094: WHERE CREDIT_REQUEST_ID = itemkey;
4095:
4096: EXCEPTION
4097: WHEN OTHERS THEN
4098: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4099: 'Error while getting parent records from AR_CMGT_CREDIT_REQUESTS',
4100: 'Sql Error: '||sqlerrm);
4101: raise;
4102: END;

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

4112: and type = 'CASE';
4113:
4114: EXCEPTION
4115: WHEN OTHERS THEN
4116: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4117: 'Error while getting parent records from AR_CMGT_CASE_FOLDERS',
4118: 'Sql Error: '||sqlerrm);
4119: raise;
4120: END;

Line 4184: AR_CMGT_WF_ENGINE.POPULATE_WF_ATTRIBUTES(

4180: raise l_dnb_data;
4181: END IF;
4182:
4183: --call the routine to populate all the wf_attributes
4184: AR_CMGT_WF_ENGINE.POPULATE_WF_ATTRIBUTES(
4185: itemtype => itemtype,
4186: itemkey => itemkey,
4187: actid => actid,
4188: funcmode => funcmode,

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

4431: hz_parties party
4432: WHERE credit_request_id = itemkey
4433: AND req.party_id = party.party_id;
4434: WHEN OTHERS THEN
4435: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
4436: sqlerrm);
4437: raise;
4438: END;
4439:

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

4532: aname => 'REQUESTOR_DISPLAY_NAME',
4533: avalue => l_requestor_user_name );
4534: EXCEPTION
4535: WHEN NO_DATA_FOUND THEN
4536: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4537: 'FND User Not Found'|| sqlerrm);
4538: raise;
4539: WHEN OTHERS THEN
4540: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,

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

4536: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4537: 'FND User Not Found'|| sqlerrm);
4538: raise;
4539: WHEN OTHERS THEN
4540: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4541: 'Other Error '|| sqlerrm);
4542: raise;
4543: END;
4544: END IF;

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

4553: EXCEPTION
4554: WHEN NO_DATA_FOUND THEN
4555: l_account_number := null;
4556: WHEN OTHERS THEN
4557: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
4558: 'Getting Account Details SqlError: '|| sqlerrm);
4559: raise;
4560:
4561: END;

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

4614: aname => 'SCORE_MODEL_ID',
4615: avalue => l_score_model_id);
4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,
4619: 'Error while getting Case Folder Details, SqlError: '|| sqlerrm);
4620: raise;
4621: END;
4622: END IF;

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

4727: END IF;
4728: END IF;
4729: EXCEPTION
4730: WHEN UNEXP_ERROR THEN
4731: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_EXTRNAL_DATA_POINTS',itemtype,itemkey,
4732: 'Error while submitting Con. Request Id, SqlError: '|| sqlerrm);
4733: raise;
4734: END;
4735: PROCEDURE GET_EXT_SCORE_RECOMMENDATIONS(

Line 4872: END AR_CMGT_WF_ENGINE;

4868: raise;
4869: END;
4870:
4871:
4872: END AR_CMGT_WF_ENGINE;