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_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.31.12010000.2 2008/09/24 15:08:43 mraymond ship $ */
3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:
6: PROCEDURE build_case_folder_details(
7: p_case_folder_id IN NUMBER,
8: p_data_point_id IN NUMBER,

Line 21: -- ar_cmgt_util.wf_debug(p_case_folder_id,

17: l_resultout VARCHAR2(1);
18: BEGIN
19: IF pg_wf_debug = 'Y'
20: THEN
21: -- ar_cmgt_util.wf_debug(p_case_folder_id,
22: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');
23: ar_cmgt_util.wf_debug(p_case_folder_id,
24: 'DP:' || p_data_point_id || ' = ' || p_data_point_value);
25: END IF;

Line 23: ar_cmgt_util.wf_debug(p_case_folder_id,

19: IF pg_wf_debug = 'Y'
20: THEN
21: -- ar_cmgt_util.wf_debug(p_case_folder_id,
22: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');
23: ar_cmgt_util.wf_debug(p_case_folder_id,
24: 'DP:' || p_data_point_id || ' = ' || p_data_point_value);
25: END IF;
26:
27: p_resultout := 0;

Line 73: -- ar_cmgt_util.wf_debug(p_case_folder_id,

69: END IF;
70:
71: -- IF pg_wf_debug = 'Y'
72: -- THEN
73: -- ar_cmgt_util.wf_debug(p_case_folder_id,
74: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()-');
75: -- END IF;
76:
77: EXCEPTION

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

77: EXCEPTION
78: WHEN OTHERS THEN
79: p_resultout := 1;
80: p_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
81: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
82: END build_case_folder_details;
83:
84: PROCEDURE build_case_folder_adp_details(
85: p_case_folder_detail_id IN NUMBER,

Line 103: ar_cmgt_util.wf_debug(p_case_folder_id,

99: l_resultout VARCHAR2(1);
100: BEGIN
101: IF pg_wf_debug = 'Y'
102: THEN
103: ar_cmgt_util.wf_debug(p_case_folder_id,
104: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');
105: -- ar_cmgt_util.wf_debug(p_case_folder_id,
106: -- p_data_point_id || '=' || p_data_point_value);
107: END IF;

Line 105: -- ar_cmgt_util.wf_debug(p_case_folder_id,

101: IF pg_wf_debug = 'Y'
102: THEN
103: ar_cmgt_util.wf_debug(p_case_folder_id,
104: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');
105: -- ar_cmgt_util.wf_debug(p_case_folder_id,
106: -- p_data_point_id || '=' || p_data_point_value);
107: END IF;
108:
109: x_resultout := 0;

Line 155: ar_cmgt_util.wf_debug(p_case_folder_id,

151: END IF;
152:
153: IF pg_wf_debug = 'Y'
154: THEN
155: ar_cmgt_util.wf_debug(p_case_folder_id,
156: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');
157: -- ar_cmgt_util.wf_debug(p_case_folder_id,
158: -- p_data_point_id || '=' || p_data_point_value);
159: END IF;

Line 157: -- ar_cmgt_util.wf_debug(p_case_folder_id,

153: IF pg_wf_debug = 'Y'
154: THEN
155: ar_cmgt_util.wf_debug(p_case_folder_id,
156: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');
157: -- ar_cmgt_util.wf_debug(p_case_folder_id,
158: -- p_data_point_id || '=' || p_data_point_value);
159: END IF;
160: EXCEPTION
161: WHEN OTHERS THEN

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

160: EXCEPTION
161: WHEN OTHERS THEN
162: x_resultout := 1;
163: x_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
164: ar_cmgt_util.wf_debug(p_case_folder_id, x_error_msg);
165: END build_case_folder_adp_details;
166:
167: PROCEDURE GetDeductionDataPoints ( -- bug 3691676
168: p_credit_request_id IN NUMBER,

Line 188: ar_cmgt_util.wf_debug(p_case_folder_id,

184: l_deduction_count NUMBER;
185: BEGIN
186: IF pg_wf_debug = 'Y'
187: THEN
188: ar_cmgt_util.wf_debug(p_case_folder_id,
189: 'ar_cmgt_data_points_pkg.get_deduction_data_points()+');
190: END IF;
191: -- first get the deduction amount
192: p_resultout := 0;

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

244: l_deduction_count := null;
245: WHEN OTHERS THEN
246: p_error_msg := 'Error While getting Deduction for Party, SqlError: '||sqlerrm;
247: p_resultout := 1;
248: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
249: return;
250: END;
251: ELSIF p_analysis_level = 'A'
252: THEN

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

279: l_deduction_count := null;
280: WHEN OTHERS THEN
281: p_error_msg := 'Error While getting Deduction for Account, SqlError: '||sqlerrm;
282: p_resultout := 1;
283: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
284: return;
285: END;
286: ELSIF p_analysis_level = 'S'
287: THEN

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

312: l_deduction_count := null;
313: WHEN OTHERS THEN
314: p_error_msg := 'Error While getting Deduction for Site, SqlError: '||sqlerrm;
315: p_resultout := 1;
316: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
317: return;
318: END;
319: END IF;
320: -- Now call build case folder to insert into case folder details

Line 345: ar_cmgt_util.wf_debug(p_case_folder_id,

341: return;
342: END IF;
343: IF pg_wf_debug = 'Y'
344: THEN
345: ar_cmgt_util.wf_debug(p_case_folder_id,
346: 'ar_cmgt_data_points_pkg.get_deduction_data_points()-');
347: END IF;
348:
349: END;

Line 364: ar_cmgt_util.wf_debug(p_case_folder_id,

360:
361: BEGIN
362: IF pg_wf_debug = 'Y'
363: THEN
364: ar_cmgt_util.wf_debug(p_case_folder_id,
365: 'ar_cmgt_data_points_pkg.getmanualdatapoints()+');
366: END IF;
367:
368: x_resultout := 0;

Line 378: ar_cmgt_util.wf_debug(p_case_folder_id,

374: p_resultout => x_resultout );
375:
376: IF pg_wf_debug = 'Y'
377: THEN
378: ar_cmgt_util.wf_debug(p_case_folder_id,
379: 'ar_cmgt_data_points_pkg.getmanualdatapoints()-');
380: END IF;
381: END GetManualDataPoints;
382:

Line 576: ar_cmgt_util.wf_debug(p_case_folder_id,

572:
573: BEGIN
574: IF pg_wf_debug = 'Y'
575: THEN
576: ar_cmgt_util.wf_debug(p_case_folder_id,
577: 'ar_cmgt_data_points_pkg.getanalyticaldata()+');
578: END IF;
579:
580: p_resultout := 0;

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

739: l_final_high_watermark_date := NULL;
740: when others THEN
741: p_errormsg := 'Error While getting High Credit Amount for Party, SqlError: <'||l_result||'>'|| sqlerrm;
742: p_resultout := 1;
743: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
744: return;
745:
746: END;
747: ELSE -- p_analysis_level A or S (both)

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

778: l_final_high_watermark_date := NULL;
779: when others then
780: p_errormsg := 'Error While getting High Credit Amount for Account/Site, SqlError: <'||l_result||'>'|| sqlerrm;
781: p_resultout := 1;
782: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
783: return;
784:
785:
786: END;

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

947: l_last_payment_amount := null;
948: when others then
949: p_errormsg := 'Error While getting Last payment info., SqlError: '||sqlerrm;
950: p_resultout := 1;
951: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
952: return;
953: END;
954: BEGIN
955: -- if everything is ok then create record in case folder tables

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

999: EXCEPTION
1000: when others then
1001: p_errormsg := 'Error While inserting Last payment info., SqlError: '||sqlerrm;
1002: p_resultout := 1;
1003: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1004: return;
1005: END;
1006:
1007: IF pg_wf_debug = 'Y'

Line 1009: ar_cmgt_util.wf_debug(p_case_folder_id,

1005: END;
1006:
1007: IF pg_wf_debug = 'Y'
1008: THEN
1009: ar_cmgt_util.wf_debug(p_case_folder_id,
1010: 'ar_cmgt_data_points_pkg.getanalyticaldata()-');
1011: END IF;
1012:
1013: EXCEPTION

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

1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: p_errormsg := 'Error While getting Largest Invvoice and High Credit Amount, SqlError: '||sqlerrm;
1016: p_resultout := 1;
1017: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1018: END;
1019:
1020:
1021: PROCEDURE GetDunning(

Line 1040: ar_cmgt_util.wf_debug(p_case_folder_id,

1036: l_dunning_count NUMBER;
1037: BEGIN
1038: IF pg_wf_debug = 'Y'
1039: THEN
1040: ar_cmgt_util.wf_debug(p_case_folder_id,
1041: 'ar_cmgt_data_points_pkg.getdunning()+');
1042: END IF;
1043:
1044: p_resultout := 0;

Line 1130: ar_cmgt_util.wf_debug(p_case_folder_id,

1126: END IF;
1127:
1128: IF pg_wf_debug = 'Y'
1129: THEN
1130: ar_cmgt_util.wf_debug(p_case_folder_id,
1131: 'ar_cmgt_data_points_pkg.getdunning()-');
1132: END IF;
1133:
1134: EXCEPTION

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

1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: p_resultout := 1;
1137: p_errormsg := 'Error While getting Dunning Letter Count, Sql Error:'||sqlerrm;
1138: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1139: END;
1140:
1141:
1142: PROCEDURE GetOMDataPoints(

Line 1180: ar_cmgt_util.wf_debug(p_case_folder_id,

1176: AND data_point_id = 34; -- receivable balance
1177: BEGIN
1178: IF pg_wf_debug = 'Y'
1179: THEN
1180: ar_cmgt_util.wf_debug(p_case_folder_id,
1181: 'ar_cmgt_data_points_pkg.getomdatapoints()+');
1182: END IF;
1183:
1184: -- first check if OM is installed, if OM is installed then get oM data points

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

1206: l_om_installed_flag := 'N';
1207: WHEN OTHERS THEN
1208: p_resultout := 1;
1209: p_errormsg := 'Error While Checking if ONT is installed or not, Sqlerror '||sqlerrm;
1210: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1211: return;
1212: END;
1213: BEGIN
1214: -- Now if OM is installed get credit_check_rule_id

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

1226: l_om_installed_flag := 'N';
1227: WHEN OTHERS THEN
1228: p_resultout := 1;
1229: p_errormsg := 'Error While getting Credit Check rule Id, Sqlerror '||sqlerrm;
1230: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1231: return;
1232: END;
1233: IF l_om_installed_flag = 'N'
1234: THEN

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

1332: p_resultout => l_resultout);
1333: ELSE
1334: p_resultout := 1;
1335: p_errormsg := 'Error While getting OM Exposure, Sqlerror '||sqlerrm;
1336: ar_cmgt_util.wf_debug(p_case_folder_id, p_errormsg);
1337: return;
1338: END IF;
1339:
1340: IF pg_wf_debug = 'Y'

Line 1342: ar_cmgt_util.wf_debug(p_case_folder_id,

1338: END IF;
1339:
1340: IF pg_wf_debug = 'Y'
1341: THEN
1342: ar_cmgt_util.wf_debug(p_case_folder_id,
1343: 'ar_cmgt_data_points_pkg.getomdatapoints()-');
1344: END IF;
1345:
1346: END;

Line 1424: ar_cmgt_util.wf_debug(p_case_folder_id,

1420:
1421: BEGIN
1422: IF pg_wf_debug = 'Y'
1423: THEN
1424: ar_cmgt_util.wf_debug(p_case_folder_id,
1425: 'ar_cmgt_data_points_pkg.getfinancialdata()+');
1426: END IF;
1427:
1428: p_resultout := 0;

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

1444: WHEN OTHERS THEN
1445: p_resultout := 1;
1446: p_errmsg := 'Error while getting party information from ar_cmgt_case_folders'||
1447: ' SqlError '|| sqlerrm;
1448: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1449: return;
1450: END;
1451:
1452:

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

1481: WHEN OTHERS THEN
1482: p_resultout := 1;
1483: p_errmsg := 'Error while getting max data from ar_cmgt_financial_data '||
1484: ' SqlError '|| sqlerrm;
1485: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1486: return;
1487:
1488: END;
1489:

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

1563: WHEN OTHERS THEN
1564: p_resultout := 1;
1565: p_errmsg := 'Error while getting records from ar_cmgt_financial_data '||
1566: ' SqlError '|| sqlerrm;
1567: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1568: return;
1569:
1570: END;
1571: build_case_folder_details(

Line 1797: ar_cmgt_util.wf_debug(p_case_folder_id,

1793: p_error_msg => p_errmsg,
1794: p_resultout => p_resultout);
1795: IF pg_wf_debug = 'Y'
1796: THEN
1797: ar_cmgt_util.wf_debug(p_case_folder_id,
1798: 'ar_cmgt_data_points_pkg.getfinancialdata()-');
1799: END IF;
1800:
1801: END;

Line 1871: ar_cmgt_util.wf_debug(p_case_folder_id,

1867:
1868: BEGIN
1869: IF pg_wf_debug = 'Y'
1870: THEN
1871: ar_cmgt_util.wf_debug(p_case_folder_id,
1872: 'ar_cmgt_data_points_pkg.getotherdatapoints()+');
1873: END IF;
1874:
1875: FOR c_hz_cust_prof_amts_rec IN c_hz_cust_prof_amts

Line 2044: ar_cmgt_util.wf_debug(p_case_folder_id,

2040: exit;
2041: END LOOP;
2042: IF pg_wf_debug = 'Y'
2043: THEN
2044: ar_cmgt_util.wf_debug(p_case_folder_id,
2045: 'ar_cmgt_data_points_pkg.getotherdatapoints()-');
2046: END IF;
2047: END;
2048:

Line 2107: ar_cmgt_util.wf_debug(p_case_folder_id,

2103:
2104: BEGIN
2105: IF pg_wf_debug = 'Y'
2106: THEN
2107: ar_cmgt_util.wf_debug(p_case_folder_id,
2108: 'ar_cmgt_data_points_pkg.populate_aging_data()+');
2109: END IF;
2110:
2111: l_check_flag := 'Y';

Line 2565: ar_cmgt_util.wf_debug(p_case_folder_id,

2561: END IF;
2562:
2563: IF pg_wf_debug = 'Y'
2564: THEN
2565: ar_cmgt_util.wf_debug(p_case_folder_id,
2566: 'ar_cmgt_data_points_pkg.populate_aging_data()-');
2567: END IF;
2568: end populate_aging_data;
2569:

Line 2586: ar_cmgt_util.wf_debug(p_case_folder_id,

2582:
2583: BEGIN
2584: IF pg_wf_debug = 'Y'
2585: THEN
2586: ar_cmgt_util.wf_debug(p_case_folder_id,
2587: 'ar_cmgt_data_points_pkg.populate_dnb_data()+');
2588: END IF;
2589:
2590: -- call table handler to insert into ar_cmgt_cf_dnb_dtls.

Line 2637: ar_cmgt_util.wf_debug(p_case_folder_id,

2633:
2634: END IF;
2635: IF pg_wf_debug = 'Y'
2636: THEN
2637: ar_cmgt_util.wf_debug(p_case_folder_id,
2638: 'ar_cmgt_data_points_pkg.populate_dnb_data()-');
2639: END IF;
2640: END;
2641:

Line 2671: ar_cmgt_util.wf_debug(p_case_folder_id,

2667: FROM dual;
2668:
2669: IF pg_wf_debug = 'Y'
2670: THEN
2671: ar_cmgt_util.wf_debug(p_case_folder_id,
2672: 'ar_cmgt_data_points_pkg.build_case_folder()+');
2673: END IF;
2674:
2675: -- check if case folder number is passed by calling program

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

2771: 'party id '|| to_char(p_party_id) ||' Cust Account Id '||
2772: to_char(p_cust_account_id)||' Cust Account Site Use Id '||
2773: to_char(p_cust_acct_site_id) ||'Sql Error '||sqlerrm;
2774: p_resultout := '1';
2775: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
2776: END;
2777:
2778: IF pg_wf_debug = 'Y'
2779: THEN

Line 2780: ar_cmgt_util.wf_debug(p_case_folder_id,

2776: END;
2777:
2778: IF pg_wf_debug = 'Y'
2779: THEN
2780: ar_cmgt_util.wf_debug(p_case_folder_id,
2781: 'CR:' || p_credit_request_id || ' => CF:' ||
2782: p_case_folder_id);
2783: ar_cmgt_util.wf_debug(p_case_folder_id,
2784: 'ar_cmgt_data_points_pkg.build_case_folder()-');

Line 2783: ar_cmgt_util.wf_debug(p_case_folder_id,

2779: THEN
2780: ar_cmgt_util.wf_debug(p_case_folder_id,
2781: 'CR:' || p_credit_request_id || ' => CF:' ||
2782: p_case_folder_id);
2783: ar_cmgt_util.wf_debug(p_case_folder_id,
2784: 'ar_cmgt_data_points_pkg.build_case_folder()-');
2785: END IF;
2786:
2787: END build_case_folder;

Line 2837: ar_cmgt_util.wf_debug(p_case_folder_id,

2833:
2834: BEGIN
2835: IF pg_wf_debug = 'Y'
2836: THEN
2837: ar_cmgt_util.wf_debug(p_case_folder_id,
2838: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()+');
2839: END IF;
2840:
2841: FOR cFinancialReportsRec IN cFinancialReports

Line 3014: ar_cmgt_util.wf_debug(p_case_folder_id,

3010:
3011: END IF;
3012: IF pg_wf_debug = 'Y'
3013: THEN
3014: ar_cmgt_util.wf_debug(p_case_folder_id,
3015: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()-');
3016: END IF;
3017: END;
3018:

Line 3245: ar_cmgt_util.wf_debug(p_case_folder_id,

3241:
3242: BEGIN
3243: IF pg_wf_debug = 'Y'
3244: THEN
3245: ar_cmgt_util.wf_debug(p_case_folder_id,
3246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()+');
3247: END IF;
3248:
3249: FOR cOrgProfRec IN cOrgProf

Line 4245: ar_cmgt_util.wf_debug(p_case_folder_id,

4241: p_resultout => p_resultout);
4242:
4243: IF pg_wf_debug = 'Y'
4244: THEN
4245: ar_cmgt_util.wf_debug(p_case_folder_id,
4246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()-');
4247: END IF;
4248: END BUILD_DNB_SCOREABLE_DATA;
4249:

Line 4304: ar_cmgt_util.wf_debug(p_case_folder_id,

4300:
4301: BEGIN
4302: IF pg_wf_debug = 'Y'
4303: THEN
4304: ar_cmgt_util.wf_debug(p_case_folder_id,
4305: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()+');
4306: END IF;
4307: p_resultout := 0;
4308: -- build the case folder details table for DNB data. In case of

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

4348: NULL;
4349: WHEN OTHERS THEN
4350: p_resultout := 1;
4351: p_error_msg := 'SqlError While retrieving Data from HZ_PARTIES '||sqlerrm;
4352: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4353: return;
4354: END;
4355:
4356: -- Get organization profile ID

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

4374: NULL;
4375: WHEN OTHERS THEN
4376: p_resultout := 1;
4377: p_error_msg := 'SqlError While retrieving Data from HZ_ORGANIZATION_PROFILES '||sqlerrm;
4378: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4379: return;
4380: END;
4381: -- Get location id
4382: l_location_id := hz_dnbui_pvt.get_location_id(p_party_id, 'DNB');

Line 4525: ar_cmgt_util.wf_debug(p_case_folder_id,

4521: -- disable the visibility of DNB data
4522: hz_common_pub.enable_cont_source_security;
4523: IF pg_wf_debug = 'Y'
4524: THEN
4525: ar_cmgt_util.wf_debug(p_case_folder_id,
4526: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()-');
4527: END IF;
4528:
4529: EXCEPTION

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

4529: EXCEPTION
4530: WHEN OTHERS THEN
4531: p_resultout := 1;
4532: p_error_msg := 'Error while populating DNB data '||sqlerrm;
4533: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4534: END;
4535:
4536:
4537: FUNCTION get_conversion_type( p_credit_request_id IN NUMBER)

Line 5650: ar_cmgt_util.wf_debug(l_tag,

5646: l_tag := 'CR:' || p_credit_request_id;
5647: ELSE
5648: l_tag := 'CF:' || p_case_folder_id;
5649: END IF;
5650: ar_cmgt_util.wf_debug(l_tag,
5651: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5652: ar_cmgt_util.wf_debug(l_tag,
5653: ' p_mode = ' || p_mode);
5654: ar_cmgt_util.wf_debug(l_tag,

Line 5652: ar_cmgt_util.wf_debug(l_tag,

5648: l_tag := 'CF:' || p_case_folder_id;
5649: END IF;
5650: ar_cmgt_util.wf_debug(l_tag,
5651: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5652: ar_cmgt_util.wf_debug(l_tag,
5653: ' p_mode = ' || p_mode);
5654: ar_cmgt_util.wf_debug(l_tag,
5655: ' p_party_id = ' || p_party_id);
5656: ar_cmgt_util.wf_debug(l_tag,

Line 5654: ar_cmgt_util.wf_debug(l_tag,

5650: ar_cmgt_util.wf_debug(l_tag,
5651: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5652: ar_cmgt_util.wf_debug(l_tag,
5653: ' p_mode = ' || p_mode);
5654: ar_cmgt_util.wf_debug(l_tag,
5655: ' p_party_id = ' || p_party_id);
5656: ar_cmgt_util.wf_debug(l_tag,
5657: ' p_cust_account_id = ' || p_cust_account_id);
5658: ar_cmgt_util.wf_debug(l_tag,

Line 5656: ar_cmgt_util.wf_debug(l_tag,

5652: ar_cmgt_util.wf_debug(l_tag,
5653: ' p_mode = ' || p_mode);
5654: ar_cmgt_util.wf_debug(l_tag,
5655: ' p_party_id = ' || p_party_id);
5656: ar_cmgt_util.wf_debug(l_tag,
5657: ' p_cust_account_id = ' || p_cust_account_id);
5658: ar_cmgt_util.wf_debug(l_tag,
5659: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5660: ar_cmgt_util.wf_debug(l_tag,

Line 5658: ar_cmgt_util.wf_debug(l_tag,

5654: ar_cmgt_util.wf_debug(l_tag,
5655: ' p_party_id = ' || p_party_id);
5656: ar_cmgt_util.wf_debug(l_tag,
5657: ' p_cust_account_id = ' || p_cust_account_id);
5658: ar_cmgt_util.wf_debug(l_tag,
5659: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5660: ar_cmgt_util.wf_debug(l_tag,
5661: ' p_trx_currency = ' || p_trx_currency);
5662: ar_cmgt_util.wf_debug(l_tag,

Line 5660: ar_cmgt_util.wf_debug(l_tag,

5656: ar_cmgt_util.wf_debug(l_tag,
5657: ' p_cust_account_id = ' || p_cust_account_id);
5658: ar_cmgt_util.wf_debug(l_tag,
5659: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5660: ar_cmgt_util.wf_debug(l_tag,
5661: ' p_trx_currency = ' || p_trx_currency);
5662: ar_cmgt_util.wf_debug(l_tag,
5663: ' p_org_id = ' || p_org_id);
5664: ar_cmgt_util.wf_debug(l_tag,

Line 5662: ar_cmgt_util.wf_debug(l_tag,

5658: ar_cmgt_util.wf_debug(l_tag,
5659: ' p_cust_acct_site_id = ' || p_cust_acct_site_id);
5660: ar_cmgt_util.wf_debug(l_tag,
5661: ' p_trx_currency = ' || p_trx_currency);
5662: ar_cmgt_util.wf_debug(l_tag,
5663: ' p_org_id = ' || p_org_id);
5664: ar_cmgt_util.wf_debug(l_tag,
5665: ' p_check_list_id = ' || p_check_list_id);
5666: ar_cmgt_util.wf_debug(l_tag,

Line 5664: ar_cmgt_util.wf_debug(l_tag,

5660: ar_cmgt_util.wf_debug(l_tag,
5661: ' p_trx_currency = ' || p_trx_currency);
5662: ar_cmgt_util.wf_debug(l_tag,
5663: ' p_org_id = ' || p_org_id);
5664: ar_cmgt_util.wf_debug(l_tag,
5665: ' p_check_list_id = ' || p_check_list_id);
5666: ar_cmgt_util.wf_debug(l_tag,
5667: ' p_credit_request_id = ' || p_credit_request_id);
5668: ar_cmgt_util.wf_debug(l_tag,

Line 5666: ar_cmgt_util.wf_debug(l_tag,

5662: ar_cmgt_util.wf_debug(l_tag,
5663: ' p_org_id = ' || p_org_id);
5664: ar_cmgt_util.wf_debug(l_tag,
5665: ' p_check_list_id = ' || p_check_list_id);
5666: ar_cmgt_util.wf_debug(l_tag,
5667: ' p_credit_request_id = ' || p_credit_request_id);
5668: ar_cmgt_util.wf_debug(l_tag,
5669: ' p_score_model_id = ' || p_score_model_id);
5670: ar_cmgt_util.wf_debug(l_tag,

Line 5668: ar_cmgt_util.wf_debug(l_tag,

5664: ar_cmgt_util.wf_debug(l_tag,
5665: ' p_check_list_id = ' || p_check_list_id);
5666: ar_cmgt_util.wf_debug(l_tag,
5667: ' p_credit_request_id = ' || p_credit_request_id);
5668: ar_cmgt_util.wf_debug(l_tag,
5669: ' p_score_model_id = ' || p_score_model_id);
5670: ar_cmgt_util.wf_debug(l_tag,
5671: ' p_credit_classification = ' || p_credit_classification);
5672: ar_cmgt_util.wf_debug(l_tag,

Line 5670: ar_cmgt_util.wf_debug(l_tag,

5666: ar_cmgt_util.wf_debug(l_tag,
5667: ' p_credit_request_id = ' || p_credit_request_id);
5668: ar_cmgt_util.wf_debug(l_tag,
5669: ' p_score_model_id = ' || p_score_model_id);
5670: ar_cmgt_util.wf_debug(l_tag,
5671: ' p_credit_classification = ' || p_credit_classification);
5672: ar_cmgt_util.wf_debug(l_tag,
5673: ' p_review_type = ' || p_review_type);
5674: ar_cmgt_util.wf_debug(l_tag,

Line 5672: ar_cmgt_util.wf_debug(l_tag,

5668: ar_cmgt_util.wf_debug(l_tag,
5669: ' p_score_model_id = ' || p_score_model_id);
5670: ar_cmgt_util.wf_debug(l_tag,
5671: ' p_credit_classification = ' || p_credit_classification);
5672: ar_cmgt_util.wf_debug(l_tag,
5673: ' p_review_type = ' || p_review_type);
5674: ar_cmgt_util.wf_debug(l_tag,
5675: ' p_case_folder_number = ' || p_case_folder_number);
5676: END IF;

Line 5674: ar_cmgt_util.wf_debug(l_tag,

5670: ar_cmgt_util.wf_debug(l_tag,
5671: ' p_credit_classification = ' || p_credit_classification);
5672: ar_cmgt_util.wf_debug(l_tag,
5673: ' p_review_type = ' || p_review_type);
5674: ar_cmgt_util.wf_debug(l_tag,
5675: ' p_case_folder_number = ' || p_case_folder_number);
5676: END IF;
5677:
5678: -- dbms_session.set_sql_trace(true);

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

5698: WHEN OTHERS
5699: THEN
5700: p_resultout := 2;
5701: p_error_msg := 'Please go to the System Options Page and setup system parameters '||sqlerrm;
5702: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
5703: return;
5704:
5705: END;
5706: BEGIN

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

5713: EXCEPTION
5714: WHEN OTHERS THEN
5715: p_resultout := 2;
5716: p_error_msg := 'Unable to get the credit request record '||sqlerrm;
5717: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
5718: return;
5719: END;
5720:
5721: -- check which level we need to do analysis

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

5718: return;
5719: END;
5720:
5721: -- check which level we need to do analysis
5722: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id, p_cust_account_id, p_cust_acct_site_id);
5723:
5724: AR_CMGT_UTIL.get_limit_currency(
5725: p_party_id => p_party_id,
5726: p_cust_account_id => p_cust_account_id,

Line 5724: AR_CMGT_UTIL.get_limit_currency(

5720:
5721: -- check which level we need to do analysis
5722: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id, p_cust_account_id, p_cust_acct_site_id);
5723:
5724: AR_CMGT_UTIL.get_limit_currency(
5725: p_party_id => p_party_id,
5726: p_cust_account_id => p_cust_account_id,
5727: p_cust_acct_site_id => p_cust_acct_site_id,
5728: p_trx_currency_code => p_trx_currency,

Line 5751: ar_cmgt_util.wf_debug(l_tag,

5747:
5748:
5749: IF pg_wf_debug = 'Y'
5750: THEN
5751: ar_cmgt_util.wf_debug(l_tag,
5752: ' l_include_all_flag = ' || l_include_all_flag);
5753: ar_cmgt_util.wf_debug(l_tag,
5754: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5755: ar_cmgt_util.wf_debug(l_tag,

Line 5753: ar_cmgt_util.wf_debug(l_tag,

5749: IF pg_wf_debug = 'Y'
5750: THEN
5751: ar_cmgt_util.wf_debug(l_tag,
5752: ' l_include_all_flag = ' || l_include_all_flag);
5753: ar_cmgt_util.wf_debug(l_tag,
5754: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5755: ar_cmgt_util.wf_debug(l_tag,
5756: ' l_analysis_level = ' || l_analysis_level);
5757: ar_cmgt_util.wf_debug(l_tag,

Line 5755: ar_cmgt_util.wf_debug(l_tag,

5751: ar_cmgt_util.wf_debug(l_tag,
5752: ' l_include_all_flag = ' || l_include_all_flag);
5753: ar_cmgt_util.wf_debug(l_tag,
5754: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5755: ar_cmgt_util.wf_debug(l_tag,
5756: ' l_analysis_level = ' || l_analysis_level);
5757: ar_cmgt_util.wf_debug(l_tag,
5758: ' l_limit_currency = ' || l_limit_currency);
5759: ar_cmgt_util.wf_debug(l_tag,

Line 5757: ar_cmgt_util.wf_debug(l_tag,

5753: ar_cmgt_util.wf_debug(l_tag,
5754: ' l_global_exposure_flag = ' || l_global_exposure_flag);
5755: ar_cmgt_util.wf_debug(l_tag,
5756: ' l_analysis_level = ' || l_analysis_level);
5757: ar_cmgt_util.wf_debug(l_tag,
5758: ' l_limit_currency = ' || l_limit_currency);
5759: ar_cmgt_util.wf_debug(l_tag,
5760: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5761: ar_cmgt_util.wf_debug(l_tag,

Line 5759: ar_cmgt_util.wf_debug(l_tag,

5755: ar_cmgt_util.wf_debug(l_tag,
5756: ' l_analysis_level = ' || l_analysis_level);
5757: ar_cmgt_util.wf_debug(l_tag,
5758: ' l_limit_currency = ' || l_limit_currency);
5759: ar_cmgt_util.wf_debug(l_tag,
5760: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5761: ar_cmgt_util.wf_debug(l_tag,
5762: ' included currencies:');
5763: END IF;

Line 5761: ar_cmgt_util.wf_debug(l_tag,

5757: ar_cmgt_util.wf_debug(l_tag,
5758: ' l_limit_currency = ' || l_limit_currency);
5759: ar_cmgt_util.wf_debug(l_tag,
5760: ' l_exchange_rate_type = ' || l_exchange_rate_type);
5761: ar_cmgt_util.wf_debug(l_tag,
5762: ' included currencies:');
5763: END IF;
5764:
5765: IF ( nvl(l_include_all_flag,'N') = 'N' )

Line 5777: ar_cmgt_util.wf_debug(l_tag,

5773: l_curr_tbl(i).usage_curr_code,
5774: sysdate,
5775: l_exchange_rate_type) = 'Y'
5776: THEN
5777: ar_cmgt_util.wf_debug(l_tag,
5778: l_curr_tbl(i).usage_curr_code);
5779: ELSE
5780: ar_cmgt_util.wf_debug(l_tag,
5781: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');

Line 5780: ar_cmgt_util.wf_debug(l_tag,

5776: THEN
5777: ar_cmgt_util.wf_debug(l_tag,
5778: l_curr_tbl(i).usage_curr_code);
5779: ELSE
5780: ar_cmgt_util.wf_debug(l_tag,
5781: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');
5782: END IF;
5783: END IF;
5784:

Line 5795: ar_cmgt_util.wf_debug(l_tag,

5791: INSERT INTO ar_cmgt_curr_usage_gt(currency)
5792: ( select distinct currency from ar_trx_bal_summary);
5793: IF pg_wf_debug = 'Y'
5794: THEN
5795: ar_cmgt_util.wf_debug(l_tag,
5796: ' ALL currencies from ar_trx_bal_summary');
5797: END IF;
5798: END IF;
5799:

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

5979: WHEN OTHERS THEN
5980: p_error_msg := 'Error While Getting Data from AR_TRX_SUMMARY, Probably exchange rate'||
5981: ' is not set correctly '||'Sql Error:'||sqlerrm;
5982: p_resultout := 1;
5983: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '1');
5984: return;
5985: END;
5986: summary_rec_str := summary_rec_str||'{'; -- adding for instrb call to make life easier
5987: -- Assign the number of columns fetched in the cursor

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

6104: WHEN OTHERS THEN
6105: p_error_msg := 'Error While Getting Data from AR_TRX_BAL_SUMMARY, Probably exchange rate '
6106: ||'is not set correctly '||'Sql Error:'||sqlerrm;
6107: p_resultout := 1;
6108: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '2');
6109: return;
6110: END;
6111: summary_rec_str := summary_rec_str||'{'; -- adding for instrb call to make life easier
6112:

Line 6418: ar_cmgt_util.wf_debug(l_tag,

6414: WHERE check_list_id = p_check_list_id);
6415: END IF;
6416: IF pg_wf_debug = 'Y'
6417: THEN
6418: ar_cmgt_util.wf_debug(l_tag,
6419: 'ar_cmgt_data_points_pkg.gather_data_points()-');
6420: END IF;
6421: END GATHER_DATA_POINTS;
6422: