APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_UTIL

Line 4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;

1: Package BODY AR_CMGT_DATA_POINTS_PKG AS
2: /* $Header: ARCMGDPB.pls 120.45.12020000.2 2012/07/09 22:03:12 rravikir ship $ */
3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:
6: /* 9560367 */
7: g_intended_limit_currency ar_cmgt_credit_requests.limit_currency%type;
8: g_conversion_type ar_cmgt_setup_options.default_exchange_rate_type%type;

Line 80: -- ar_cmgt_util.wf_debug(p_case_folder_id,

76: l_resultout VARCHAR2(1);
77: BEGIN
78: IF pg_wf_debug = 'Y'
79: THEN
80: -- ar_cmgt_util.wf_debug(p_case_folder_id,
81: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');
82: ar_cmgt_util.wf_debug(p_case_folder_id,
83: 'DP:' || p_data_point_id || ' = ' || p_data_point_value);
84: END IF;

Line 82: ar_cmgt_util.wf_debug(p_case_folder_id,

78: IF pg_wf_debug = 'Y'
79: THEN
80: -- ar_cmgt_util.wf_debug(p_case_folder_id,
81: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');
82: ar_cmgt_util.wf_debug(p_case_folder_id,
83: 'DP:' || p_data_point_id || ' = ' || p_data_point_value);
84: END IF;
85:
86: p_resultout := 0;

Line 132: -- ar_cmgt_util.wf_debug(p_case_folder_id,

128: END IF;
129:
130: -- IF pg_wf_debug = 'Y'
131: -- THEN
132: -- ar_cmgt_util.wf_debug(p_case_folder_id,
133: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()-');
134: -- END IF;
135:
136: EXCEPTION

Line 140: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

136: EXCEPTION
137: WHEN OTHERS THEN
138: p_resultout := 1;
139: p_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
140: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
141: END build_case_folder_details;
142:
143: PROCEDURE build_case_folder_adp_details(
144: p_case_folder_detail_id IN NUMBER,

Line 162: ar_cmgt_util.wf_debug(p_case_folder_id,

158: l_resultout VARCHAR2(1);
159: BEGIN
160: IF pg_wf_debug = 'Y'
161: THEN
162: ar_cmgt_util.wf_debug(p_case_folder_id,
163: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');
164: -- ar_cmgt_util.wf_debug(p_case_folder_id,
165: -- p_data_point_id || '=' || p_data_point_value);
166: END IF;

Line 164: -- ar_cmgt_util.wf_debug(p_case_folder_id,

160: IF pg_wf_debug = 'Y'
161: THEN
162: ar_cmgt_util.wf_debug(p_case_folder_id,
163: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');
164: -- ar_cmgt_util.wf_debug(p_case_folder_id,
165: -- p_data_point_id || '=' || p_data_point_value);
166: END IF;
167:
168: x_resultout := 0;

Line 214: ar_cmgt_util.wf_debug(p_case_folder_id,

210: END IF;
211:
212: IF pg_wf_debug = 'Y'
213: THEN
214: ar_cmgt_util.wf_debug(p_case_folder_id,
215: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');
216: -- ar_cmgt_util.wf_debug(p_case_folder_id,
217: -- p_data_point_id || '=' || p_data_point_value);
218: END IF;

Line 216: -- ar_cmgt_util.wf_debug(p_case_folder_id,

212: IF pg_wf_debug = 'Y'
213: THEN
214: ar_cmgt_util.wf_debug(p_case_folder_id,
215: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');
216: -- ar_cmgt_util.wf_debug(p_case_folder_id,
217: -- p_data_point_id || '=' || p_data_point_value);
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN

Line 223: ar_cmgt_util.wf_debug(p_case_folder_id, x_error_msg);

219: EXCEPTION
220: WHEN OTHERS THEN
221: x_resultout := 1;
222: x_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
223: ar_cmgt_util.wf_debug(p_case_folder_id, x_error_msg);
224: END build_case_folder_adp_details;
225:
226: PROCEDURE GetDeductionDataPoints ( -- bug 3691676
227: p_credit_request_id IN NUMBER,

Line 247: ar_cmgt_util.wf_debug(p_case_folder_id,

243: l_deduction_count NUMBER;
244: BEGIN
245: IF pg_wf_debug = 'Y'
246: THEN
247: ar_cmgt_util.wf_debug(p_case_folder_id,
248: 'ar_cmgt_data_points_pkg.get_deduction_data_points()+');
249: END IF;
250: -- first get the deduction amount
251: p_resultout := 0;

Line 307: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

303: l_deduction_count := null;
304: WHEN OTHERS THEN
305: p_error_msg := 'Error While getting Deduction for Party, SqlError: '||sqlerrm;
306: p_resultout := 1;
307: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
308: return;
309: END;
310: ELSIF p_analysis_level = 'A'
311: THEN

Line 342: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

338: l_deduction_count := null;
339: WHEN OTHERS THEN
340: p_error_msg := 'Error While getting Deduction for Account, SqlError: '||sqlerrm;
341: p_resultout := 1;
342: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
343: return;
344: END;
345: ELSIF p_analysis_level = 'S'
346: THEN

Line 375: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

371: l_deduction_count := null;
372: WHEN OTHERS THEN
373: p_error_msg := 'Error While getting Deduction for Site, SqlError: '||sqlerrm;
374: p_resultout := 1;
375: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
376: return;
377: END;
378: END IF;
379: -- Now call build case folder to insert into case folder details

Line 404: ar_cmgt_util.wf_debug(p_case_folder_id,

400: return;
401: END IF;
402: IF pg_wf_debug = 'Y'
403: THEN
404: ar_cmgt_util.wf_debug(p_case_folder_id,
405: 'ar_cmgt_data_points_pkg.get_deduction_data_points()-');
406: END IF;
407:
408: END;

Line 423: ar_cmgt_util.wf_debug(p_case_folder_id,

419:
420: BEGIN
421: IF pg_wf_debug = 'Y'
422: THEN
423: ar_cmgt_util.wf_debug(p_case_folder_id,
424: 'ar_cmgt_data_points_pkg.getmanualdatapoints()+');
425: END IF;
426:
427: x_resultout := 0;

Line 437: ar_cmgt_util.wf_debug(p_case_folder_id,

433: p_resultout => x_resultout );
434:
435: IF pg_wf_debug = 'Y'
436: THEN
437: ar_cmgt_util.wf_debug(p_case_folder_id,
438: 'ar_cmgt_data_points_pkg.getmanualdatapoints()-');
439: END IF;
440: END GetManualDataPoints;
441:

Line 635: ar_cmgt_util.wf_debug(p_case_folder_id,

631:
632: BEGIN
633: IF pg_wf_debug = 'Y'
634: THEN
635: ar_cmgt_util.wf_debug(p_case_folder_id,
636: 'ar_cmgt_data_points_pkg.getanalyticaldata()+');
637: END IF;
638:
639: p_resultout := 0;

Line 802: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

798: l_final_high_watermark_date := NULL;
799: when others THEN
800: p_errormsg := 'Error While getting High Credit Amount for Party, SqlError: <'||l_result||'>'|| sqlerrm;
801: p_resultout := 1;
802: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
803: return;
804:
805: END;
806: ELSE -- p_analysis_level A or S (both)

Line 841: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

837: l_final_high_watermark_date := NULL;
838: when others then
839: p_errormsg := 'Error While getting High Credit Amount for Account/Site, SqlError: <'||l_result||'>'|| sqlerrm;
840: p_resultout := 1;
841: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
842: return;
843:
844:
845: END;

Line 1010: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1006: l_last_payment_amount := null;
1007: when others then
1008: p_errormsg := 'Error While getting Last payment info., SqlError: '||sqlerrm;
1009: p_resultout := 1;
1010: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1011: return;
1012: END;
1013: BEGIN
1014: -- if everything is ok then create record in case folder tables

Line 1062: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1058: EXCEPTION
1059: when others then
1060: p_errormsg := 'Error While inserting Last payment info., SqlError: '||sqlerrm;
1061: p_resultout := 1;
1062: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1063: return;
1064: END;
1065:
1066: IF pg_wf_debug = 'Y'

Line 1068: ar_cmgt_util.wf_debug(p_case_folder_id,

1064: END;
1065:
1066: IF pg_wf_debug = 'Y'
1067: THEN
1068: ar_cmgt_util.wf_debug(p_case_folder_id,
1069: 'ar_cmgt_data_points_pkg.getanalyticaldata()-');
1070: END IF;
1071:
1072: EXCEPTION

Line 1076: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: p_errormsg := 'Error While getting Largest Invvoice and High Credit Amount, SqlError: '||sqlerrm;
1075: p_resultout := 1;
1076: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1077: END;
1078:
1079:
1080: PROCEDURE GetDunning(

Line 1099: ar_cmgt_util.wf_debug(p_case_folder_id,

1095: l_dunning_count NUMBER;
1096: BEGIN
1097: IF pg_wf_debug = 'Y'
1098: THEN
1099: ar_cmgt_util.wf_debug(p_case_folder_id,
1100: 'ar_cmgt_data_points_pkg.getdunning()+');
1101: END IF;
1102:
1103: p_resultout := 0;

Line 1189: ar_cmgt_util.wf_debug(p_case_folder_id,

1185: END IF;
1186:
1187: IF pg_wf_debug = 'Y'
1188: THEN
1189: ar_cmgt_util.wf_debug(p_case_folder_id,
1190: 'ar_cmgt_data_points_pkg.getdunning()-');
1191: END IF;
1192:
1193: EXCEPTION

Line 1197: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: p_resultout := 1;
1196: p_errormsg := 'Error While getting Dunning Letter Count, Sql Error:'||sqlerrm;
1197: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1198: END;
1199:
1200:
1201: PROCEDURE GetOMDataPoints(

Line 1243: ar_cmgt_util.wf_debug(p_case_folder_id,

1239: AND data_point_id = 34; -- receivable balance
1240: BEGIN
1241: IF pg_wf_debug = 'Y'
1242: THEN
1243: ar_cmgt_util.wf_debug(p_case_folder_id,
1244: 'ar_cmgt_data_points_pkg.getomdatapoints()+');
1245: END IF;
1246:
1247: -- first check if OM is installed, if OM is installed then get oM data points

Line 1273: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1269: l_om_installed_flag := 'N';
1270: WHEN OTHERS THEN
1271: p_resultout := 1;
1272: p_errormsg := 'Error While Checking if ONT is installed or not, Sqlerror '||sqlerrm;
1273: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1274: return;
1275: END;
1276: BEGIN
1277: -- Now if OM is installed get credit_check_rule_id

Line 1293: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1289: l_om_installed_flag := 'N';
1290: WHEN OTHERS THEN
1291: p_resultout := 1;
1292: p_errormsg := 'Error While getting Credit Check rule Id, Sqlerror '||sqlerrm;
1293: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1294: return;
1295: END;
1296: IF l_om_installed_flag = 'N'
1297: THEN

Line 1325: ar_cmgt_util.wf_debug(p_case_folder_id,

1321: oe_debug_pub.debug_on;
1322: oe_debug_pub.initialize;
1323: l_file_val := oe_debug_pub.set_debug_mode('FILE');
1324: oe_debug_pub.setdebuglevel(5);
1325: ar_cmgt_util.wf_debug(p_case_folder_id,
1326: 'OM Output Debug File is stored at : '||OE_DEBUG_PUB.G_DIR||'/'||OE_DEBUG_PUB.G_FILE);
1327: ar_cmgt_util.wf_debug(p_case_folder_id, 'File --> : '||l_file_val);
1328: END IF;
1329:

Line 1327: ar_cmgt_util.wf_debug(p_case_folder_id, 'File --> : '||l_file_val);

1323: l_file_val := oe_debug_pub.set_debug_mode('FILE');
1324: oe_debug_pub.setdebuglevel(5);
1325: ar_cmgt_util.wf_debug(p_case_folder_id,
1326: 'OM Output Debug File is stored at : '||OE_DEBUG_PUB.G_DIR||'/'||OE_DEBUG_PUB.G_FILE);
1327: ar_cmgt_util.wf_debug(p_case_folder_id, 'File --> : '||l_file_val);
1328: END IF;
1329:
1330: IF pg_wf_debug = 'Y'
1331: THEN

Line 1332: ar_cmgt_util.wf_debug(p_case_folder_id, 'p_analysis_level --> : '||p_analysis_level);

1328: END IF;
1329:
1330: IF pg_wf_debug = 'Y'
1331: THEN
1332: ar_cmgt_util.wf_debug(p_case_folder_id, 'p_analysis_level --> : '||p_analysis_level);
1333: END IF;
1334: -- Added for bug 9560367 -- End
1335:
1336: /* 9560367 - OM expects the limit currency to be static based

Line 1351: ar_cmgt_util.wf_debug(p_case_folder_id, 'Overridden limit_currency, using ' || l_limit_currency_code || ' for OM call');

1347: l_limit_currency_code := g_intended_limit_currency;
1348:
1349: IF pg_wf_debug = 'Y'
1350: THEN
1351: ar_cmgt_util.wf_debug(p_case_folder_id, 'Overridden limit_currency, using ' || l_limit_currency_code || ' for OM call');
1352: END IF;
1353: ELSE
1354: /* we have NOT overridden the limit currency. No
1355: conversion required */

Line 1361: ar_cmgt_util.wf_debug(p_case_folder_id, 'No override: using ' || l_limit_currency_code || ' for OM call');

1357: l_limit_currency_code := p_limit_currency_code;
1358:
1359: IF pg_wf_debug = 'Y'
1360: THEN
1361: ar_cmgt_util.wf_debug(p_case_folder_id, 'No override: using ' || l_limit_currency_code || ' for OM call');
1362: END IF;
1363: END IF;
1364:
1365: -- check what is the analysis level

Line 1415: ar_cmgt_util.wf_debug(p_case_folder_id, 'Return Status after OE_Credit_Exposure_PUB.Get_customer_exposure --> : '||l_return_status);

1411:
1412: -- Added for bug 9560367
1413: IF pg_wf_debug = 'Y'
1414: THEN
1415: ar_cmgt_util.wf_debug(p_case_folder_id, 'Return Status after OE_Credit_Exposure_PUB.Get_customer_exposure --> : '||l_return_status);
1416: END IF;
1417:
1418: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1419: THEN

Line 1484: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);

1480: p_resultout => l_resultout);
1481: ELSE
1482: p_resultout := 1;
1483: p_errormsg := 'Error While getting OM Exposure, Sqlerror '||sqlerrm;
1484: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1485: return;
1486: END IF;
1487:
1488: IF pg_wf_debug = 'Y'

Line 1490: ar_cmgt_util.wf_debug(p_case_folder_id,

1486: END IF;
1487:
1488: IF pg_wf_debug = 'Y'
1489: THEN
1490: ar_cmgt_util.wf_debug(p_case_folder_id,
1491: 'ar_cmgt_data_points_pkg.getomdatapoints()-');
1492: END IF;
1493:
1494: END;

Line 1572: ar_cmgt_util.wf_debug(p_case_folder_id,

1568:
1569: BEGIN
1570: IF pg_wf_debug = 'Y'
1571: THEN
1572: ar_cmgt_util.wf_debug(p_case_folder_id,
1573: 'ar_cmgt_data_points_pkg.getfinancialdata()+');
1574: END IF;
1575:
1576: p_resultout := 0;

Line 1596: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);

1592: WHEN OTHERS THEN
1593: p_resultout := 1;
1594: p_errmsg := 'Error while getting party information from ar_cmgt_case_folders'||
1595: ' SqlError '|| sqlerrm;
1596: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1597: return;
1598: END;
1599:
1600:

Line 1633: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);

1629: WHEN OTHERS THEN
1630: p_resultout := 1;
1631: p_errmsg := 'Error while getting max data from ar_cmgt_financial_data '||
1632: ' SqlError '|| sqlerrm;
1633: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1634: return;
1635:
1636: END;
1637:

Line 1715: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);

1711: WHEN OTHERS THEN
1712: p_resultout := 1;
1713: p_errmsg := 'Error while getting records from ar_cmgt_financial_data '||
1714: ' SqlError '|| sqlerrm;
1715: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1716: return;
1717:
1718: END;
1719: build_case_folder_details(

Line 1945: ar_cmgt_util.wf_debug(p_case_folder_id,

1941: p_error_msg => p_errmsg,
1942: p_resultout => p_resultout);
1943: IF pg_wf_debug = 'Y'
1944: THEN
1945: ar_cmgt_util.wf_debug(p_case_folder_id,
1946: 'ar_cmgt_data_points_pkg.getfinancialdata()-');
1947: END IF;
1948:
1949: END;

Line 2019: ar_cmgt_util.wf_debug(p_case_folder_id,

2015:
2016: BEGIN
2017: IF pg_wf_debug = 'Y'
2018: THEN
2019: ar_cmgt_util.wf_debug(p_case_folder_id,
2020: 'ar_cmgt_data_points_pkg.getotherdatapoints()+');
2021: END IF;
2022:
2023: FOR c_hz_cust_prof_amts_rec IN c_hz_cust_prof_amts

Line 2192: ar_cmgt_util.wf_debug(p_case_folder_id,

2188: exit;
2189: END LOOP;
2190: IF pg_wf_debug = 'Y'
2191: THEN
2192: ar_cmgt_util.wf_debug(p_case_folder_id,
2193: 'ar_cmgt_data_points_pkg.getotherdatapoints()-');
2194: END IF;
2195: END;
2196:

Line 2255: ar_cmgt_util.wf_debug(p_case_folder_id,

2251:
2252: BEGIN
2253: IF pg_wf_debug = 'Y'
2254: THEN
2255: ar_cmgt_util.wf_debug(p_case_folder_id,
2256: 'ar_cmgt_data_points_pkg.populate_aging_data()+');
2257: END IF;
2258:
2259: l_check_flag := 'Y';

Line 2713: ar_cmgt_util.wf_debug(p_case_folder_id,

2709: END IF;
2710:
2711: IF pg_wf_debug = 'Y'
2712: THEN
2713: ar_cmgt_util.wf_debug(p_case_folder_id,
2714: 'ar_cmgt_data_points_pkg.populate_aging_data()-');
2715: END IF;
2716: end populate_aging_data;
2717:

Line 2734: ar_cmgt_util.wf_debug(p_case_folder_id,

2730:
2731: BEGIN
2732: IF pg_wf_debug = 'Y'
2733: THEN
2734: ar_cmgt_util.wf_debug(p_case_folder_id,
2735: 'ar_cmgt_data_points_pkg.populate_dnb_data()+');
2736: END IF;
2737:
2738: -- call table handler to insert into ar_cmgt_cf_dnb_dtls.

Line 2785: ar_cmgt_util.wf_debug(p_case_folder_id,

2781:
2782: END IF;
2783: IF pg_wf_debug = 'Y'
2784: THEN
2785: ar_cmgt_util.wf_debug(p_case_folder_id,
2786: 'ar_cmgt_data_points_pkg.populate_dnb_data()-');
2787: END IF;
2788: END;
2789:

Line 2819: ar_cmgt_util.wf_debug(p_case_folder_id,

2815: FROM dual;
2816:
2817: IF pg_wf_debug = 'Y'
2818: THEN
2819: ar_cmgt_util.wf_debug(p_case_folder_id,
2820: 'ar_cmgt_data_points_pkg.build_case_folder()+');
2821: END IF;
2822:
2823: -- check if case folder number is passed by calling program

Line 2924: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

2920: 'party id '|| to_char(p_party_id) ||' Cust Account Id '||
2921: to_char(p_cust_account_id)||' Cust Account Site Use Id '||
2922: to_char(p_cust_acct_site_id) ||'Sql Error '||sqlerrm;
2923: p_resultout := '1';
2924: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
2925: END;
2926:
2927: IF pg_wf_debug = 'Y'
2928: THEN

Line 2929: ar_cmgt_util.wf_debug(p_case_folder_id,

2925: END;
2926:
2927: IF pg_wf_debug = 'Y'
2928: THEN
2929: ar_cmgt_util.wf_debug(p_case_folder_id,
2930: 'CR:' || p_credit_request_id || ' => CF:' ||
2931: p_case_folder_id);
2932: ar_cmgt_util.wf_debug(p_case_folder_id,
2933: 'ar_cmgt_data_points_pkg.build_case_folder()-');

Line 2932: ar_cmgt_util.wf_debug(p_case_folder_id,

2928: THEN
2929: ar_cmgt_util.wf_debug(p_case_folder_id,
2930: 'CR:' || p_credit_request_id || ' => CF:' ||
2931: p_case_folder_id);
2932: ar_cmgt_util.wf_debug(p_case_folder_id,
2933: 'ar_cmgt_data_points_pkg.build_case_folder()-');
2934: END IF;
2935:
2936: END build_case_folder;

Line 2986: ar_cmgt_util.wf_debug(p_case_folder_id,

2982:
2983: BEGIN
2984: IF pg_wf_debug = 'Y'
2985: THEN
2986: ar_cmgt_util.wf_debug(p_case_folder_id,
2987: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()+');
2988: END IF;
2989:
2990: FOR cFinancialReportsRec IN cFinancialReports

Line 3163: ar_cmgt_util.wf_debug(p_case_folder_id,

3159:
3160: END IF;
3161: IF pg_wf_debug = 'Y'
3162: THEN
3163: ar_cmgt_util.wf_debug(p_case_folder_id,
3164: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()-');
3165: END IF;
3166: END;
3167:

Line 3394: ar_cmgt_util.wf_debug(p_case_folder_id,

3390:
3391: BEGIN
3392: IF pg_wf_debug = 'Y'
3393: THEN
3394: ar_cmgt_util.wf_debug(p_case_folder_id,
3395: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()+');
3396: END IF;
3397:
3398: FOR cOrgProfRec IN cOrgProf

Line 4394: ar_cmgt_util.wf_debug(p_case_folder_id,

4390: p_resultout => p_resultout);
4391:
4392: IF pg_wf_debug = 'Y'
4393: THEN
4394: ar_cmgt_util.wf_debug(p_case_folder_id,
4395: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()-');
4396: END IF;
4397: END BUILD_DNB_SCOREABLE_DATA;
4398:

Line 4453: ar_cmgt_util.wf_debug(p_case_folder_id,

4449:
4450: BEGIN
4451: IF pg_wf_debug = 'Y'
4452: THEN
4453: ar_cmgt_util.wf_debug(p_case_folder_id,
4454: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()+');
4455: END IF;
4456: p_resultout := 0;
4457: -- build the case folder details table for DNB data. In case of

Line 4501: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

4497: NULL;
4498: WHEN OTHERS THEN
4499: p_resultout := 1;
4500: p_error_msg := 'SqlError While retrieving Data from HZ_PARTIES '||sqlerrm;
4501: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4502: return;
4503: END;
4504:
4505: -- Get organization profile ID

Line 4527: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

4523: NULL;
4524: WHEN OTHERS THEN
4525: p_resultout := 1;
4526: p_error_msg := 'SqlError While retrieving Data from HZ_ORGANIZATION_PROFILES '||sqlerrm;
4527: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4528: return;
4529: END;
4530: -- Get location id
4531: l_location_id := hz_dnbui_pvt.get_location_id(p_party_id, 'DNB');

Line 4674: ar_cmgt_util.wf_debug(p_case_folder_id,

4670: -- disable the visibility of DNB data
4671: hz_common_pub.enable_cont_source_security;
4672: IF pg_wf_debug = 'Y'
4673: THEN
4674: ar_cmgt_util.wf_debug(p_case_folder_id,
4675: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()-');
4676: END IF;
4677:
4678: EXCEPTION

Line 4682: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

4678: EXCEPTION
4679: WHEN OTHERS THEN
4680: p_resultout := 1;
4681: p_error_msg := 'Error while populating DNB data '||sqlerrm;
4682: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4683: END;
4684:
4685: /* kosrinv ..Changing The procedure to store the data point values in a proper format ..
4686: bug 5525814 ...............*/

Line 5720: ar_cmgt_util.wf_debug(l_tag,

5716: l_tag := 'CR:' || p_credit_request_id;
5717: ELSE
5718: l_tag := 'CF:' || p_case_folder_id;
5719: END IF;
5720: ar_cmgt_util.wf_debug(l_tag,
5721: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5722: ar_cmgt_util.wf_debug(l_tag,
5723: ' p_mode = ' || p_mode);
5724: ar_cmgt_util.wf_debug(l_tag,

Line 5722: ar_cmgt_util.wf_debug(l_tag,

5718: l_tag := 'CF:' || p_case_folder_id;
5719: END IF;
5720: ar_cmgt_util.wf_debug(l_tag,
5721: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5722: ar_cmgt_util.wf_debug(l_tag,
5723: ' p_mode = ' || p_mode);
5724: ar_cmgt_util.wf_debug(l_tag,
5725: ' p_party_id = ' || p_party_id);
5726: ar_cmgt_util.wf_debug(l_tag,

Line 5724: ar_cmgt_util.wf_debug(l_tag,

5720: ar_cmgt_util.wf_debug(l_tag,
5721: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5722: ar_cmgt_util.wf_debug(l_tag,
5723: ' p_mode = ' || p_mode);
5724: ar_cmgt_util.wf_debug(l_tag,
5725: ' p_party_id = ' || p_party_id);
5726: ar_cmgt_util.wf_debug(l_tag,
5727: ' p_cust_account_id = ' || p_cust_account_id);
5728: ar_cmgt_util.wf_debug(l_tag,

Line 5726: ar_cmgt_util.wf_debug(l_tag,

5722: ar_cmgt_util.wf_debug(l_tag,
5723: ' p_mode = ' || p_mode);
5724: ar_cmgt_util.wf_debug(l_tag,
5725: ' p_party_id = ' || p_party_id);
5726: ar_cmgt_util.wf_debug(l_tag,
5727: ' p_cust_account_id = ' || p_cust_account_id);
5728: ar_cmgt_util.wf_debug(l_tag,
5729: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5730: ar_cmgt_util.wf_debug(l_tag,

Line 5728: ar_cmgt_util.wf_debug(l_tag,

5724: ar_cmgt_util.wf_debug(l_tag,
5725: ' p_party_id = ' || p_party_id);
5726: ar_cmgt_util.wf_debug(l_tag,
5727: ' p_cust_account_id = ' || p_cust_account_id);
5728: ar_cmgt_util.wf_debug(l_tag,
5729: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5730: ar_cmgt_util.wf_debug(l_tag,
5731: ' p_trx_currency = ' || p_trx_currency);
5732: ar_cmgt_util.wf_debug(l_tag,

Line 5730: ar_cmgt_util.wf_debug(l_tag,

5726: ar_cmgt_util.wf_debug(l_tag,
5727: ' p_cust_account_id = ' || p_cust_account_id);
5728: ar_cmgt_util.wf_debug(l_tag,
5729: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5730: ar_cmgt_util.wf_debug(l_tag,
5731: ' p_trx_currency = ' || p_trx_currency);
5732: ar_cmgt_util.wf_debug(l_tag,
5733: ' p_org_id = ' || p_org_id);
5734: ar_cmgt_util.wf_debug(l_tag,

Line 5732: ar_cmgt_util.wf_debug(l_tag,

5728: ar_cmgt_util.wf_debug(l_tag,
5729: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5730: ar_cmgt_util.wf_debug(l_tag,
5731: ' p_trx_currency = ' || p_trx_currency);
5732: ar_cmgt_util.wf_debug(l_tag,
5733: ' p_org_id = ' || p_org_id);
5734: ar_cmgt_util.wf_debug(l_tag,
5735: ' p_check_list_id = ' || p_check_list_id);
5736: ar_cmgt_util.wf_debug(l_tag,

Line 5734: ar_cmgt_util.wf_debug(l_tag,

5730: ar_cmgt_util.wf_debug(l_tag,
5731: ' p_trx_currency = ' || p_trx_currency);
5732: ar_cmgt_util.wf_debug(l_tag,
5733: ' p_org_id = ' || p_org_id);
5734: ar_cmgt_util.wf_debug(l_tag,
5735: ' p_check_list_id = ' || p_check_list_id);
5736: ar_cmgt_util.wf_debug(l_tag,
5737: ' p_credit_request_id = ' || p_credit_request_id);
5738: ar_cmgt_util.wf_debug(l_tag,

Line 5736: ar_cmgt_util.wf_debug(l_tag,

5732: ar_cmgt_util.wf_debug(l_tag,
5733: ' p_org_id = ' || p_org_id);
5734: ar_cmgt_util.wf_debug(l_tag,
5735: ' p_check_list_id = ' || p_check_list_id);
5736: ar_cmgt_util.wf_debug(l_tag,
5737: ' p_credit_request_id = ' || p_credit_request_id);
5738: ar_cmgt_util.wf_debug(l_tag,
5739: ' p_score_model_id = ' || p_score_model_id);
5740: ar_cmgt_util.wf_debug(l_tag,

Line 5738: ar_cmgt_util.wf_debug(l_tag,

5734: ar_cmgt_util.wf_debug(l_tag,
5735: ' p_check_list_id = ' || p_check_list_id);
5736: ar_cmgt_util.wf_debug(l_tag,
5737: ' p_credit_request_id = ' || p_credit_request_id);
5738: ar_cmgt_util.wf_debug(l_tag,
5739: ' p_score_model_id = ' || p_score_model_id);
5740: ar_cmgt_util.wf_debug(l_tag,
5741: ' p_credit_classification = ' || p_credit_classification);
5742: ar_cmgt_util.wf_debug(l_tag,

Line 5740: ar_cmgt_util.wf_debug(l_tag,

5736: ar_cmgt_util.wf_debug(l_tag,
5737: ' p_credit_request_id = ' || p_credit_request_id);
5738: ar_cmgt_util.wf_debug(l_tag,
5739: ' p_score_model_id = ' || p_score_model_id);
5740: ar_cmgt_util.wf_debug(l_tag,
5741: ' p_credit_classification = ' || p_credit_classification);
5742: ar_cmgt_util.wf_debug(l_tag,
5743: ' p_review_type = ' || p_review_type);
5744: ar_cmgt_util.wf_debug(l_tag,

Line 5742: ar_cmgt_util.wf_debug(l_tag,

5738: ar_cmgt_util.wf_debug(l_tag,
5739: ' p_score_model_id = ' || p_score_model_id);
5740: ar_cmgt_util.wf_debug(l_tag,
5741: ' p_credit_classification = ' || p_credit_classification);
5742: ar_cmgt_util.wf_debug(l_tag,
5743: ' p_review_type = ' || p_review_type);
5744: ar_cmgt_util.wf_debug(l_tag,
5745: ' p_case_folder_number = ' || p_case_folder_number);
5746: END IF;

Line 5744: ar_cmgt_util.wf_debug(l_tag,

5740: ar_cmgt_util.wf_debug(l_tag,
5741: ' p_credit_classification = ' || p_credit_classification);
5742: ar_cmgt_util.wf_debug(l_tag,
5743: ' p_review_type = ' || p_review_type);
5744: ar_cmgt_util.wf_debug(l_tag,
5745: ' p_case_folder_number = ' || p_case_folder_number);
5746: END IF;
5747:
5748: -- dbms_session.set_sql_trace(true);

Line 5772: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

5768: WHEN OTHERS
5769: THEN
5770: p_resultout := 2;
5771: p_error_msg := 'Please go to the System Options Page and setup system parameters '||sqlerrm;
5772: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
5773: return;
5774:
5775: END;
5776: BEGIN

Line 5787: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);

5783: EXCEPTION
5784: WHEN OTHERS THEN
5785: p_resultout := 2;
5786: p_error_msg := 'Unable to get the credit request record '||sqlerrm;
5787: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
5788: return;
5789: END;
5790:
5791: -- check which level we need to do analysis

Line 5792: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id, p_cust_account_id, p_cust_acct_site_id);

5788: return;
5789: END;
5790:
5791: -- check which level we need to do analysis
5792: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id, p_cust_account_id, p_cust_acct_site_id);
5793:
5794: AR_CMGT_UTIL.get_limit_currency(
5795: p_party_id => p_party_id,
5796: p_cust_account_id => p_cust_account_id,

Line 5794: AR_CMGT_UTIL.get_limit_currency(

5790:
5791: -- check which level we need to do analysis
5792: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id, p_cust_account_id, p_cust_acct_site_id);
5793:
5794: AR_CMGT_UTIL.get_limit_currency(
5795: p_party_id => p_party_id,
5796: p_cust_account_id => p_cust_account_id,
5797: p_cust_acct_site_id => p_cust_acct_site_id,
5798: p_trx_currency_code => p_trx_currency,

Line 5825: ar_cmgt_util.wf_debug(l_tag,

5821:
5822:
5823: IF pg_wf_debug = 'Y'
5824: THEN
5825: ar_cmgt_util.wf_debug(l_tag,
5826: ' l_include_all_flag = ' || l_include_all_flag);
5827: ar_cmgt_util.wf_debug(l_tag,
5828: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5829: ar_cmgt_util.wf_debug(l_tag,

Line 5827: ar_cmgt_util.wf_debug(l_tag,

5823: IF pg_wf_debug = 'Y'
5824: THEN
5825: ar_cmgt_util.wf_debug(l_tag,
5826: ' l_include_all_flag = ' || l_include_all_flag);
5827: ar_cmgt_util.wf_debug(l_tag,
5828: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5829: ar_cmgt_util.wf_debug(l_tag,
5830: ' l_analysis_level = ' || l_analysis_level);
5831: ar_cmgt_util.wf_debug(l_tag,

Line 5829: ar_cmgt_util.wf_debug(l_tag,

5825: ar_cmgt_util.wf_debug(l_tag,
5826: ' l_include_all_flag = ' || l_include_all_flag);
5827: ar_cmgt_util.wf_debug(l_tag,
5828: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5829: ar_cmgt_util.wf_debug(l_tag,
5830: ' l_analysis_level = ' || l_analysis_level);
5831: ar_cmgt_util.wf_debug(l_tag,
5832: ' l_orig_limit_currency = ' || l_orig_limit_currency);
5833: ar_cmgt_util.wf_debug(l_tag,

Line 5831: ar_cmgt_util.wf_debug(l_tag,

5827: ar_cmgt_util.wf_debug(l_tag,
5828: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5829: ar_cmgt_util.wf_debug(l_tag,
5830: ' l_analysis_level = ' || l_analysis_level);
5831: ar_cmgt_util.wf_debug(l_tag,
5832: ' l_orig_limit_currency = ' || l_orig_limit_currency);
5833: ar_cmgt_util.wf_debug(l_tag,
5834: ' l_limit_currency = ' || l_limit_currency);
5835: ar_cmgt_util.wf_debug(l_tag,

Line 5833: ar_cmgt_util.wf_debug(l_tag,

5829: ar_cmgt_util.wf_debug(l_tag,
5830: ' l_analysis_level = ' || l_analysis_level);
5831: ar_cmgt_util.wf_debug(l_tag,
5832: ' l_orig_limit_currency = ' || l_orig_limit_currency);
5833: ar_cmgt_util.wf_debug(l_tag,
5834: ' l_limit_currency = ' || l_limit_currency);
5835: ar_cmgt_util.wf_debug(l_tag,
5836: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5837: ar_cmgt_util.wf_debug(l_tag,

Line 5835: ar_cmgt_util.wf_debug(l_tag,

5831: ar_cmgt_util.wf_debug(l_tag,
5832: ' l_orig_limit_currency = ' || l_orig_limit_currency);
5833: ar_cmgt_util.wf_debug(l_tag,
5834: ' l_limit_currency = ' || l_limit_currency);
5835: ar_cmgt_util.wf_debug(l_tag,
5836: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5837: ar_cmgt_util.wf_debug(l_tag,
5838: ' included currencies:');
5839: END IF;

Line 5837: ar_cmgt_util.wf_debug(l_tag,

5833: ar_cmgt_util.wf_debug(l_tag,
5834: ' l_limit_currency = ' || l_limit_currency);
5835: ar_cmgt_util.wf_debug(l_tag,
5836: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5837: ar_cmgt_util.wf_debug(l_tag,
5838: ' included currencies:');
5839: END IF;
5840:
5841: -- Added by rravikir (Bug 8581475)

Line 5865: ar_cmgt_util.wf_debug(l_tag,

5861: l_curr_tbl(i).usage_curr_code,
5862: sysdate,
5863: g_conversion_type) = 'Y'
5864: THEN
5865: ar_cmgt_util.wf_debug(l_tag,
5866: l_curr_tbl(i).usage_curr_code);
5867: ELSE
5868: ar_cmgt_util.wf_debug(l_tag,
5869: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');

Line 5868: ar_cmgt_util.wf_debug(l_tag,

5864: THEN
5865: ar_cmgt_util.wf_debug(l_tag,
5866: l_curr_tbl(i).usage_curr_code);
5867: ELSE
5868: ar_cmgt_util.wf_debug(l_tag,
5869: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');
5870: END IF;
5871: END IF;
5872:

Line 5889: ar_cmgt_util.wf_debug(l_tag,

5885: -- End (Bug 8581475)
5886:
5887: IF pg_wf_debug = 'Y'
5888: THEN
5889: ar_cmgt_util.wf_debug(l_tag,
5890: ' ALL currencies from ar_trx_bal_summary');
5891: END IF;
5892: END IF;
5893:

Line 5907: ar_cmgt_util.wf_debug(l_tag,

5903: IF l_limit_currency IS NULL
5904: THEN
5905: IF pg_wf_debug = 'Y'
5906: THEN
5907: ar_cmgt_util.wf_debug(l_tag,
5908: 'Credit Usage Rule has not been setup');
5909: END IF;
5910:
5911: p_resultout := 2;

Line 6085: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '1');

6081: WHEN OTHERS THEN
6082: p_error_msg := 'Error While Getting Data from AR_TRX_SUMMARY, Probably exchange rate'||
6083: ' is not set correctly '||'Sql Error:'||sqlerrm;
6084: p_resultout := 1;
6085: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '1');
6086: return;
6087: END;
6088: summary_rec_str := summary_rec_str||'{'; -- adding for instrb call to make life easier
6089: -- Assign the number of columns fetched in the cursor

Line 6210: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '2');

6206: WHEN OTHERS THEN
6207: p_error_msg := 'Error While Getting Data from AR_TRX_BAL_SUMMARY, Probably exchange rate '
6208: ||'is not set correctly '||'Sql Error:'||sqlerrm;
6209: p_resultout := 1;
6210: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '2');
6211: return;
6212: END;
6213: summary_rec_str := summary_rec_str||'{'; -- adding for instrb call to make life easier
6214:

Line 6419: ar_cmgt_util.wf_debug(l_tag,

6415: /* 8661054 - Moved dso and ddso calcs to after IF,
6416: corrected misuse of l_deno_dso in ddso calc */
6417: IF pg_wf_debug = 'Y'
6418: THEN
6419: ar_cmgt_util.wf_debug(l_tag,
6420: 'DSO: numerator = ' || l_numerator_dso || ' denom = ' ||
6421: l_deno_dso);
6422: ar_cmgt_util.wf_debug(l_tag,
6423: 'DDSO: numerator = ' || l_numerator_ddso || ' denom = ' ||

Line 6422: ar_cmgt_util.wf_debug(l_tag,

6418: THEN
6419: ar_cmgt_util.wf_debug(l_tag,
6420: 'DSO: numerator = ' || l_numerator_dso || ' denom = ' ||
6421: l_deno_dso);
6422: ar_cmgt_util.wf_debug(l_tag,
6423: 'DDSO: numerator = ' || l_numerator_ddso || ' denom = ' ||
6424: l_deno_ddso);
6425: END IF;
6426:

Line 6444: ar_cmgt_util.wf_debug(l_tag,

6440: END IF;
6441:
6442: IF pg_wf_debug = 'Y'
6443: THEN
6444: ar_cmgt_util.wf_debug(l_tag,
6445: 'DSO (2) = ' || l_dso);
6446: ar_cmgt_util.wf_debug(l_tag,
6447: 'DDSO (3) = ' || l_ddso);
6448: ar_cmgt_util.wf_debug(l_tag,

Line 6446: ar_cmgt_util.wf_debug(l_tag,

6442: IF pg_wf_debug = 'Y'
6443: THEN
6444: ar_cmgt_util.wf_debug(l_tag,
6445: 'DSO (2) = ' || l_dso);
6446: ar_cmgt_util.wf_debug(l_tag,
6447: 'DDSO (3) = ' || l_ddso);
6448: ar_cmgt_util.wf_debug(l_tag,
6449: 'APD (4) = ' || l_apd);
6450: ar_cmgt_util.wf_debug(l_tag,

Line 6448: ar_cmgt_util.wf_debug(l_tag,

6444: ar_cmgt_util.wf_debug(l_tag,
6445: 'DSO (2) = ' || l_dso);
6446: ar_cmgt_util.wf_debug(l_tag,
6447: 'DDSO (3) = ' || l_ddso);
6448: ar_cmgt_util.wf_debug(l_tag,
6449: 'APD (4) = ' || l_apd);
6450: ar_cmgt_util.wf_debug(l_tag,
6451: 'WADPL (5) = ' || l_wadpl);
6452:

Line 6450: ar_cmgt_util.wf_debug(l_tag,

6446: ar_cmgt_util.wf_debug(l_tag,
6447: 'DDSO (3) = ' || l_ddso);
6448: ar_cmgt_util.wf_debug(l_tag,
6449: 'APD (4) = ' || l_apd);
6450: ar_cmgt_util.wf_debug(l_tag,
6451: 'WADPL (5) = ' || l_wadpl);
6452:
6453: END IF;
6454:

Line 6688: ar_cmgt_util.wf_debug(l_tag,

6684: WHERE check_list_id = p_check_list_id);
6685: END IF;
6686: IF pg_wf_debug = 'Y'
6687: THEN
6688: ar_cmgt_util.wf_debug(l_tag,
6689: 'ar_cmgt_data_points_pkg.gather_data_points()-');
6690: END IF;
6691: END GATHER_DATA_POINTS;
6692: