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_CALC_LATE_CHARGE dependencies on AR_CALC_LATE_CHARGE

Line 1: PACKAGE BODY AR_CALC_LATE_CHARGE AS

1: PACKAGE BODY AR_CALC_LATE_CHARGE AS
2: /* $Header: ARCALATB.pls 120.12.12010000.2 2008/11/13 14:12:35 rasarasw ship $ */
3:
4: l_debug_flag varchar2(1);
5: pg_last_updated_by number;

Line 140: debug('ar_calc_late_charge.Calculate_Interest()+ ');

136: l_interest number;
137: BEGIN
138:
139: IF l_debug_flag = 'Y' THEN
140: debug('ar_calc_late_charge.Calculate_Interest()+ ');
141: debug('Input Parameters.... ');
142: debug('p_payment_schedule_id : '||p_payment_schedule_id);
143: debug('p_amount : '|| p_amount);
144: debug('p_formula : '||p_formula);

Line 177: l_interest := ar_calc_late_charge.currency_round(l_interest,p_currency);

173: debug('l_interest before currency rounding : '||l_interest);
174: END IF;
175:
176: IF l_interest <> 0 THEN
177: l_interest := ar_calc_late_charge.currency_round(l_interest,p_currency);
178: END IF;
179:
180: IF l_debug_flag = 'Y' THEN
181: debug('l_interest after currency rounding : '||l_interest);

Line 182: debug('ar_calc_late_charge.Calculate_Interest()- ');

178: END IF;
179:
180: IF l_debug_flag = 'Y' THEN
181: debug('l_interest after currency rounding : '||l_interest);
182: debug('ar_calc_late_charge.Calculate_Interest()- ');
183: END IF;
184:
185: return l_interest;
186:

Line 529: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

525: into l_next_date
526: from ar_payment_schedules ps
527: where customer_id = p_customer_id
528: and decode(ps.class,
529: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
530: ps.customer_site_use_id,
531: ps.org_id),
532: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
533: ps.customer_site_use_id,

Line 532: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

528: and decode(ps.class,
529: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
530: ps.customer_site_use_id,
531: ps.org_id),
532: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
533: ps.customer_site_use_id,
534: ps.org_id),
535: ps.customer_site_use_id) = p_site_use_id
536: and ps.invoice_currency_code = p_currency_code

Line 757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

753: select sum(amount_due_original)
754: from ar_payment_schedules ps
755: where ps.customer_id = p_customer_id
756: and decode(ps.class,
757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
758: ps.customer_site_use_id,
759: ps.org_id),
760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
761: ps.customer_site_use_id,

Line 760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

756: and decode(ps.class,
757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
758: ps.customer_site_use_id,
759: ps.org_id),
760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
761: ps.customer_site_use_id,
762: ps.org_id),
763: ps.customer_site_use_id) = p_site_use_id
764: and ps.invoice_currency_code = p_currency_code

Line 829: debug('ar_calc_late_charge.check_adb_eligibility()+');

825: l_cust_threshold NUMBER;
826:
827: BEGIN
828: IF l_debug_flag = 'Y' THEN
829: debug('ar_calc_late_charge.check_adb_eligibility()+');
830: debug('Customer_id : '||p_customer_id);
831: debug('Site Use ID : '||p_site_use_id);
832: debug('Currency_code : '||p_currency_code);
833: debug('Org ID : '||p_org_id);

Line 882: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

878: and ci2.status in ('FINAL', 'ACCEPTED','IMPORTED'))
879: and ci.status in ('FINAL', 'ACCEPTED','IMPORTED')
880: and ps.customer_id = ci.customer_id
881: and decode(ps.class,
882: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
883: ps.customer_site_use_id,
884: ps.org_id),
885: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
886: ps.customer_site_use_id,

Line 885: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

881: and decode(ps.class,
882: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
883: ps.customer_site_use_id,
884: ps.org_id),
885: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
886: ps.customer_site_use_id,
887: ps.org_id),
888: ps.customer_site_use_id) = ci.site_use_id
889: and ps.invoice_currency_code = ci.currency_code

Line 918: debug('ar_calc_late_charge.check_adb_eligibility()-');

914: END IF;
915: return 'N';
916: END IF;
917: IF l_debug_flag = 'Y' THEN
918: debug('ar_calc_late_charge.check_adb_eligibility()-');
919: END IF;
920: EXCEPTION WHEN OTHERS THEN
921: --IF l_debug_flag = 'Y' THEN
922: debug('EXCEPTION : ar_calc_late_charge.check_adb_eligibility()');

Line 922: debug('EXCEPTION : ar_calc_late_charge.check_adb_eligibility()');

918: debug('ar_calc_late_charge.check_adb_eligibility()-');
919: END IF;
920: EXCEPTION WHEN OTHERS THEN
921: --IF l_debug_flag = 'Y' THEN
922: debug('EXCEPTION : ar_calc_late_charge.check_adb_eligibility()');
923: --END IF;
924: return 'N';
925:
926: END check_adb_eligibility;

Line 945: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

941: into l_first_activity_date
942: from ar_payment_schedules ps
943: where ps.customer_id = p_customer_id
944: and decode(ps.class,
945: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
946: ps.customer_site_use_id,
947: ps.org_id),
948: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
949: ps.customer_site_use_id,

Line 948: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

944: and decode(ps.class,
945: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
946: ps.customer_site_use_id,
947: ps.org_id),
948: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
949: ps.customer_site_use_id,
950: ps.org_id),
951: ps.customer_site_use_id) = p_site_use_id
952: and ps.invoice_currency_code = p_currency_code

Line 1021: debug( 'ar_calc_late_charge.get_cust_late_charge_policy()+' );

1017: l_ignore INTEGER;
1018: l_first_rec BOOLEAN;
1019: BEGIN
1020: IF l_debug_flag = 'Y' THEN
1021: debug( 'ar_calc_late_charge.get_cust_late_charge_policy()+' );
1022: END IF;
1023:
1024: l_org_id := p_org_id;
1025: l_customer_name_from := p_customer_name_from;

Line 1182: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1178: from
1179: (select distinct
1180: ps.customer_id,
1181: decode(ps.class,
1182: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1183: ps.customer_site_use_id,
1184: ps.org_id),
1185: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1186: ps.customer_site_use_id,

Line 1185: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1181: decode(ps.class,
1182: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1183: ps.customer_site_use_id,
1184: ps.org_id),
1185: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1186: ps.customer_site_use_id,
1187: ps.org_id),
1188: ps.customer_site_use_id) customer_site_use_id,
1189: ps.invoice_currency_code currency_code,

Line 1256: AND ((ar_calc_late_charge.get_profile_class_site_use_id

1252: AND ps.customer_trx_id = trx.customer_trx_id(+)
1253: AND nvl(ps.last_charge_date,ps.due_date) < :l_fin_charge_date
1254: AND nvl(trx.finance_charges,decode(ps.class,''DEP'',''N'',''Y'')) = ''Y''
1255: AND profiles.cust_account_id = cust_acct.cust_account_id
1256: AND ((ar_calc_late_charge.get_profile_class_site_use_id
1257: (decode(:l_use_late_charge_site ,
1258: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,
1259: ps.org_id),
1260: ''N'',ps.customer_site_use_id)

Line 1258: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,

1254: AND nvl(trx.finance_charges,decode(ps.class,''DEP'',''N'',''Y'')) = ''Y''
1255: AND profiles.cust_account_id = cust_acct.cust_account_id
1256: AND ((ar_calc_late_charge.get_profile_class_site_use_id
1257: (decode(:l_use_late_charge_site ,
1258: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,
1259: ps.org_id),
1260: ''N'',ps.customer_site_use_id)
1261: ,ps.org_id) IS NULL
1262: and profiles.site_use_id is null)

Line 1263: OR profiles.site_use_id = ar_calc_late_charge.get_profile_class_site_use_id

1259: ps.org_id),
1260: ''N'',ps.customer_site_use_id)
1261: ,ps.org_id) IS NULL
1262: and profiles.site_use_id is null)
1263: OR profiles.site_use_id = ar_calc_late_charge.get_profile_class_site_use_id
1264: (decode(:l_use_late_charge_site,
1265: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,
1266: ps.org_id),
1267: ''N'',ps.customer_site_use_id)

Line 1265: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,

1261: ,ps.org_id) IS NULL
1262: and profiles.site_use_id is null)
1263: OR profiles.site_use_id = ar_calc_late_charge.get_profile_class_site_use_id
1264: (decode(:l_use_late_charge_site,
1265: ''Y'',ar_calc_late_charge.get_late_charge_site(ps.customer_id,
1266: ps.org_id),
1267: ''N'',ps.customer_site_use_id)
1268: ,ps.org_id))
1269: AND profiles.interest_charges = ''Y''

Line 1273: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1269: AND profiles.interest_charges = ''Y''
1270: AND profiles.cust_account_profile_id = prof_amts.cust_account_profile_id
1271: AND prof_amts.currency_code = ps.invoice_currency_code
1272: AND site_use.site_use_id (+) = decode(ps.class,
1273: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1274: ps.customer_site_use_id,
1275: ps.org_id),
1276: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1277: ps.customer_site_use_id,

Line 1276: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1272: AND site_use.site_use_id (+) = decode(ps.class,
1273: ''PMT'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1274: ps.customer_site_use_id,
1275: ps.org_id),
1276: ''BR'',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1277: ps.customer_site_use_id,
1278: ps.org_id),
1279: ps.customer_site_use_id)
1280: AND mod(nvl(ps.customer_site_use_id,0),:l_total_workers) =

Line 1384: debug( 'ar_calc_late_charge.get_cust_late_charge_policy()-' );

1380: AND cust_acct.party_id = party.party_id
1381: );
1382:
1383: IF l_debug_flag = 'Y' THEN
1384: debug( 'ar_calc_late_charge.get_cust_late_charge_policy()-' );
1385: END IF;
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN

Line 1391: debug('EXCEPTION: ar_calc_late_charge.get_cust_late_charge_policy' );

1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: --IF l_debug_flag = 'Y' THEN
1390: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
1391: debug('EXCEPTION: ar_calc_late_charge.get_cust_late_charge_policy' );
1392: --END IF;
1393: RAISE;
1394: END get_cust_late_charge_policy;
1395:

Line 1404: debug( 'ar_calc_late_charge.insert_credit_amount()+' );

1400: l_worker_number number;
1401: l_total_workers number;
1402: BEGIN
1403: IF l_debug_flag = 'Y' THEN
1404: debug( 'ar_calc_late_charge.insert_credit_amount()+' );
1405: END IF;
1406:
1407: l_fin_charge_date := p_fin_charge_date;
1408: l_worker_number := p_worker_number;

Line 1437: ar_calc_late_charge.get_bill_to_site_use_id(cr.pay_from_customer,

1433: /* The receipt balance is taken as -1*amount_due_remaining from ar_payment
1434: schedules as receipt date is considered for calculating the balances of
1435: the transaction and not the application date */
1436: from (select cr.pay_from_customer customer_id,
1437: ar_calc_late_charge.get_bill_to_site_use_id(cr.pay_from_customer,
1438: cr.customer_site_use_id,
1439: cr.org_id) customer_site_use_id,
1440: cr.currency_code,
1441: cr.legal_entity_id,

Line 1453: and ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1449: and ps.class ='PMT'
1450: and ps.trx_date <= l_fin_charge_date
1451: and nvl(ps.last_charge_date,l_fin_charge_date-1) < l_fin_charge_date
1452: and ps.customer_id = cust_site.customer_id
1453: and ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1454: ps.customer_site_use_id,
1455: ps.org_id) = cust_site.customer_site_use_id
1456: and ps.invoice_currency_code = cust_site.currency_code
1457: and ps.org_id = cust_site.org_id

Line 1488: -1*ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,

1484: trx.legal_entity_id,
1485: ps.org_id,
1486: /* Always get the true balance of the CM as of the finance charge date. For that,
1487: p_charge_on_finance_charge_flag is passed as Y */
1488: -1*ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,
1489: l_fin_charge_date,
1490: 'CM',
1491: 'Y') balance_due
1492: from ar_payment_schedules ps,

Line 1536: debug( 'ar_calc_late_charge.insert_credit_amount()-' );

1532: currency_code,
1533: legal_entity_id,
1534: org_id);
1535: IF l_debug_flag = 'Y' THEN
1536: debug( 'ar_calc_late_charge.insert_credit_amount()-' );
1537: END IF;
1538: EXCEPTION
1539: WHEN OTHERS THEN
1540: --IF l_debug_flag = 'Y' THEN

Line 1542: debug('EXCEPTION: ar_calc_late_charge.insert_credit_amount' );

1538: EXCEPTION
1539: WHEN OTHERS THEN
1540: --IF l_debug_flag = 'Y' THEN
1541: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
1542: debug('EXCEPTION: ar_calc_late_charge.insert_credit_amount' );
1543: --END IF;
1544: RAISE;
1545:
1546: END insert_credit_amount;

Line 1603: debug( 'ar_calc_late_charge.insert_int_overdue_adj_dm()+' );

1599: l_worker_number number;
1600: l_total_workers number;
1601: BEGIN
1602: IF l_debug_flag = 'Y' THEN
1603: debug( 'ar_calc_late_charge.insert_int_overdue_adj_dm()+' );
1604: END IF;
1605:
1606: l_fin_charge_date := p_fin_charge_date;
1607: l_worker_number := p_worker_number;

Line 1729: ar_calc_late_charge.calculate_interest(

1725: 0,0,
1726: decode(c.interest_type,'FIXED_AMOUNT',c.interest_fixed_amount,
1727: 'CHARGE_PER_TIER', sched_lines.amount, /*Late Charge Charge per tier Enhacement 6469663*/
1728: decode(sched_hdrs.schedule_header_type,'AMOUNT', sched_lines.amount,
1729: ar_calc_late_charge.calculate_interest(
1730: decode(dense_rank()
1731: over(partition by c.customer_id,
1732: c.customer_site_use_id,
1733: c.invoice_currency_code,

Line 1919: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1915: from (
1916: select
1917: ps.customer_id,
1918: decode(ps.class,
1919: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1920: ps.customer_site_use_id,
1921: ps.org_id),
1922: ps.customer_site_use_id) customer_site_use_id ,
1923: ps.invoice_currency_code,

Line 1972: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

1968: ar_lc_cust_sites_t cust_site,
1969: ar_late_charge_cust_balance_gt bal
1970: where ps.customer_id = cust_site.customer_id
1971: and cust_site.customer_site_use_id = decode(ps.class,
1972: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1973: ps.customer_site_use_id,
1974: ps.org_id),
1975: ps.customer_site_use_id)
1976: and ps.invoice_currency_code = cust_site.currency_code

Line 2005: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2001: and adj.status = 'A'
2002: group by
2003: ps.customer_id,
2004: decode(ps.class,
2005: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2006: ps.customer_site_use_id,
2007: ps.org_id),
2008: ps.customer_site_use_id),
2009: ps.invoice_currency_code,

Line 2046: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2042: cust_site.last_accrue_charge_date
2043: union all
2044: select ps.customer_id,
2045: decode(ps.class,
2046: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2047: ps.customer_site_use_id,
2048: ps.org_id),
2049: ps.customer_site_use_id) customer_site_use_id,
2050: ps.invoice_currency_code,

Line 2095: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2091: ar_lc_cust_sites_t cust_site,
2092: ar_late_charge_cust_balance_gt bal
2093: where ps.customer_id = cust_site.customer_id
2094: and cust_site.customer_site_use_id = decode(ps.class,
2095: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2096: ps.customer_site_use_id,
2097: ps.org_id),
2098: ps.customer_site_use_id)
2099: and ps.invoice_currency_code = cust_site.currency_code

Line 2131: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2127: and ps_cm_cr.payment_schedule_id = app.payment_schedule_id
2128: and ps_cm_cr.trx_date > l_fin_charge_date
2129: group by ps.customer_id,
2130: decode(ps.class,
2131: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2132: ps.customer_site_use_id,
2133: ps.org_id),
2134: ps.customer_site_use_id),
2135: ps.invoice_currency_code,

Line 2172: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2168: cust_site.last_accrue_charge_date
2169: UNION ALL
2170: select ps.customer_id,
2171: decode(ps.class,
2172: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2173: ps.customer_site_use_id,
2174: ps.org_id),
2175: ps.customer_site_use_id) customer_site_use_id,
2176: ps.invoice_currency_code,

Line 2218: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2214: ar_lc_cust_sites_t cust_site,
2215: ar_late_charge_cust_balance_gt bal
2216: where ps.customer_id = cust_site.customer_id
2217: and cust_site.customer_site_use_id = decode(ps.class,
2218: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2219: ps.customer_site_use_id,
2220: ps.org_id),
2221: ps.customer_site_use_id)
2222: and ps.invoice_currency_code = cust_site.currency_code

Line 2355: debug( 'ar_calc_late_charge.insert_int_overdue_adj_dm()-' );

2351: and bat.batch_status ='F'
2352: and bat.transferred_status <> 'S'));
2353:
2354: IF l_debug_flag = 'Y' THEN
2355: debug( 'ar_calc_late_charge.insert_int_overdue_adj_dm()-' );
2356: END IF;
2357: --
2358: EXCEPTION
2359: WHEN OTHERS THEN

Line 2362: debug('EXCEPTION: ar_calc_late_charge.insert_int_overdue_adj_dm' );

2358: EXCEPTION
2359: WHEN OTHERS THEN
2360: --IF l_debug_flag = 'Y' THEN
2361: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
2362: debug('EXCEPTION: ar_calc_late_charge.insert_int_overdue_adj_dm' );
2363: --END IF;
2364: RAISE;
2365: END insert_int_overdue_adj_dm;
2366: /*=========================================================================================+

Line 2410: debug( 'ar_calc_late_charge.insert_int_overdue_inv()+' );

2406: l_total_workers number;
2407:
2408: BEGIN
2409: IF l_debug_flag = 'Y' THEN
2410: debug( 'ar_calc_late_charge.insert_int_overdue_inv()+' );
2411: END IF;
2412:
2413: l_fin_charge_date := p_fin_charge_date;
2414: l_worker_number := p_worker_number;

Line 2518: ar_calc_late_charge.calculate_interest(

2514: 'AMOUNT',decode(b.class,
2515: 'PMT',-1* sched_lines.amount,
2516: 'CM', -1* sched_lines.amount,
2517: sched_lines.amount),
2518: ar_calc_late_charge.calculate_interest(
2519: b.overdue_amt,
2520: b.charge_on_finance_charge_flag,
2521: least(decode(b.multiple_interest_rates_flag,
2522: 'Y',decode(sched_hdrs.schedule_header_type,

Line 2614: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2610: from (
2611: select
2612: ps.customer_id,
2613: decode(ps.class,
2614: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2615: ps.customer_site_use_id,
2616: ps.org_id),
2617: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2618: ps.customer_site_use_id,

Line 2617: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2613: decode(ps.class,
2614: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2615: ps.customer_site_use_id,
2616: ps.org_id),
2617: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2618: ps.customer_site_use_id,
2619: ps.org_id),
2620: ps.customer_site_use_id) customer_site_use_id,
2621: ps.invoice_currency_code,

Line 2670: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2666: ar_lc_cust_sites_t cust_site,
2667: ar_late_charge_cust_balance_gt bal
2668: where ps.customer_id = cust_site.customer_id
2669: and cust_site.customer_site_use_id = decode(ps.class,
2670: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2671: ps.customer_site_use_id,
2672: ps.org_id),
2673: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2674: ps.customer_site_use_id,

Line 2673: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2669: and cust_site.customer_site_use_id = decode(ps.class,
2670: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2671: ps.customer_site_use_id,
2672: ps.org_id),
2673: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2674: ps.customer_site_use_id,
2675: ps.org_id),
2676: ps.customer_site_use_id)
2677: and ps.invoice_currency_code = cust_site.currency_code

Line 2713: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2709: and adj.status = 'A'
2710: group by
2711: ps.customer_id,
2712: decode(ps.class,
2713: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2714: ps.customer_site_use_id,
2715: ps.org_id),
2716: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2717: ps.customer_site_use_id,

Line 2716: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2712: decode(ps.class,
2713: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2714: ps.customer_site_use_id,
2715: ps.org_id),
2716: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2717: ps.customer_site_use_id,
2718: ps.org_id),
2719: ps.customer_site_use_id),
2720: ps.invoice_currency_code,

Line 2757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2753: cust_site.last_accrue_charge_date
2754: UNION ALL
2755: select ps.customer_id,
2756: decode(ps.class,
2757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2758: ps.customer_site_use_id,
2759: ps.org_id),
2760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2761: ps.customer_site_use_id,

Line 2760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2756: decode(ps.class,
2757: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2758: ps.customer_site_use_id,
2759: ps.org_id),
2760: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2761: ps.customer_site_use_id,
2762: ps.org_id),
2763: ps.customer_site_use_id) customer_site_use_id,
2764: ps.invoice_currency_code,

Line 2810: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2806: ar_lc_cust_sites_t cust_site,
2807: ar_late_charge_cust_balance_gt bal
2808: where ps.customer_id = cust_site.customer_id
2809: and cust_site.customer_site_use_id = decode(ps.class,
2810: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2811: ps.customer_site_use_id,
2812: ps.org_id),
2813: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2814: ps.customer_site_use_id,

Line 2813: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2809: and cust_site.customer_site_use_id = decode(ps.class,
2810: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2811: ps.customer_site_use_id,
2812: ps.org_id),
2813: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2814: ps.customer_site_use_id,
2815: ps.org_id),
2816: ps.customer_site_use_id)
2817: and ps.invoice_currency_code = cust_site.currency_code

Line 2856: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2852: and ps_cm_cr.payment_schedule_id = app.payment_schedule_id
2853: and ps_cm_cr.trx_date > l_fin_charge_date
2854: group by ps.customer_id,
2855: decode(ps.class,
2856: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2857: ps.customer_site_use_id,
2858: ps.org_id),
2859: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2860: ps.customer_site_use_id,

Line 2859: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

2855: decode(ps.class,
2856: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2857: ps.customer_site_use_id,
2858: ps.org_id),
2859: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2860: ps.customer_site_use_id,
2861: ps.org_id),
2862: ps.customer_site_use_id),
2863: ps.invoice_currency_code,

Line 3017: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3013: cust_site.last_accrue_charge_date
3014: UNION ALL
3015: select ps.customer_id,
3016: decode(ps.class,
3017: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3018: ps.customer_site_use_id,
3019: ps.org_id),
3020: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3021: ps.customer_site_use_id,

Line 3020: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3016: decode(ps.class,
3017: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3018: ps.customer_site_use_id,
3019: ps.org_id),
3020: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3021: ps.customer_site_use_id,
3022: ps.org_id),
3023: ps.customer_site_use_id) customer_site_use_id,
3024: ps.invoice_currency_code,

Line 3066: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3062: ar_lc_cust_sites_t cust_site,
3063: ar_late_charge_cust_balance_gt bal
3064: where ps.customer_id = cust_site.customer_id
3065: and cust_site.customer_site_use_id = decode(ps.class,
3066: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3067: ps.customer_site_use_id,
3068: ps.org_id),
3069: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3070: ps.customer_site_use_id,

Line 3069: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3065: and cust_site.customer_site_use_id = decode(ps.class,
3066: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3067: ps.customer_site_use_id,
3068: ps.org_id),
3069: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3070: ps.customer_site_use_id,
3071: ps.org_id),
3072: ps.customer_site_use_id)
3073: and ps.invoice_currency_code = cust_site.currency_code

Line 3223: debug( 'ar_calc_late_charge.insert_int_overdue_inv()-' );

3219: and bat.batch_status ='F'
3220: and bat.transferred_status <> 'S'));
3221:
3222: IF l_debug_flag = 'Y' THEN
3223: debug( 'ar_calc_late_charge.insert_int_overdue_inv()-' );
3224: END IF;
3225: --
3226: EXCEPTION
3227: WHEN OTHERS THEN

Line 3230: debug('EXCEPTION: ar_calc_late_charge.insert_int_overdue_inv' );

3226: EXCEPTION
3227: WHEN OTHERS THEN
3228: --IF l_debug_flag = 'Y' THEN
3229: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
3230: debug('EXCEPTION: ar_calc_late_charge.insert_int_overdue_inv' );
3231: --END IF;
3232: RAISE;
3233:
3234: END insert_int_overdue_inv;

Line 3287: debug( 'ar_calc_late_charge.insert_int_late_pay()+' );

3283: l_total_workers number;
3284:
3285: BEGIN
3286: IF l_debug_flag = 'Y' THEN
3287: debug( 'ar_calc_late_charge.insert_int_late_pay()+' );
3288: END IF;
3289:
3290: l_fin_charge_date := p_fin_charge_date;
3291: l_worker_number := p_worker_number;

Line 3414: ar_calc_late_charge.calculate_interest(

3410: decode(a.interest_type,
3411: 'FIXED_AMOUNT',a.interest_fixed_amount,
3412: decode(sched_hdrs.schedule_header_type,
3413: 'AMOUNT',sched_lines.amount,
3414: ar_calc_late_charge.calculate_interest(
3415: decode(sign(a.late_pay_amount - a.original_balance),
3416: -1,a.late_pay_amount,
3417: 0,a.late_pay_amount,
3418: a.original_balance),

Line 3453: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3449: from
3450: (
3451: select ps.customer_id,
3452: decode(ps.class,
3453: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3454: ps.customer_site_use_id,
3455: ps.org_id),
3456: ps.customer_site_use_id) customer_site_use_id ,
3457: ps.invoice_currency_code,

Line 3475: ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,

3471: cust_site.min_interest_charge,
3472: cust_site.max_interest_charge,
3473: sum(app.amount_applied + nvl(app.earned_discount_taken,0) +
3474: nvl(app.unearned_discount_taken,0)) late_pay_amount,
3475: ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,
3476: cr.receipt_date-1,
3477: ps.class,
3478: cust_site.charge_on_finance_charge_flag) original_balance,
3479: ps.due_date,

Line 3546: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3542: and adj.adjustment_type = 'A'
3543: group by ps.payment_schedule_id) adj
3544: where ps.customer_id = cust_site.customer_id
3545: and cust_site.customer_site_use_id = decode(ps.class,
3546: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3547: ps.customer_site_use_id,
3548: ps.org_id),
3549: ps.customer_site_use_id)
3550: and ps.invoice_currency_code = cust_site.currency_code

Line 3594: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

3590: and nvl(th.current_record_flag,'Y') = 'Y'
3591: and nvl(th.status,'*') not in ('PROTESTED','MATURED_PEND_RISK_ELIMINATION','CLOSED', 'CANCELLED')
3592: group by ps.customer_id,
3593: decode(ps.class,
3594: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3595: ps.customer_site_use_id,
3596: ps.org_id),
3597: ps.customer_site_use_id),
3598: ps.invoice_currency_code,

Line 3614: ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,

3610: cust_site.last_accrue_charge_date)),
3611: cust_site.exchange_rate_type,
3612: cust_site.min_interest_charge,
3613: cust_site.max_interest_charge,
3614: ar_calc_late_charge.get_balance_as_of(ps.payment_schedule_id,
3615: cr.receipt_date-1,
3616: ps.class,
3617: cust_site.charge_on_finance_charge_flag),
3618: ps.due_date,

Line 3701: debug( 'ar_calc_late_charge.insert_int_late_pay()-' );

3697: and bat.batch_status ='F'
3698: and bat.transferred_status <> 'S'));
3699:
3700: IF l_debug_flag = 'Y' THEN
3701: debug( 'ar_calc_late_charge.insert_int_late_pay()-' );
3702: END IF;
3703: --
3704: EXCEPTION
3705: WHEN OTHERS THEN

Line 3708: debug('EXCEPTION: ar_calc_late_charge.insert_int_late_pay' );

3704: EXCEPTION
3705: WHEN OTHERS THEN
3706: --IF l_debug_flag = 'Y' THEN
3707: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
3708: debug('EXCEPTION: ar_calc_late_charge.insert_int_late_pay' );
3709: --END IF;
3710: RAISE;
3711:
3712: END insert_int_late_pay;

Line 3773: debug( 'ar_calc_late_charge. insert_int_avg_daily_bal()+' );

3769:
3770: BEGIN
3771:
3772: IF l_debug_flag = 'Y' THEN
3773: debug( 'ar_calc_late_charge. insert_int_avg_daily_bal()+' );
3774: END IF;
3775:
3776: l_fin_charge_date := p_fin_charge_date;
3777: l_worker_number := p_worker_number;

Line 3883: ar_calc_late_charge.currency_round(sum(a.balance * (a.date_to - a.date_from+1))

3879: a.last_accrue_charge_date,
3880: a.exchange_rate_type,
3881: a.min_interest_charge,
3882: a.max_interest_charge,
3883: ar_calc_late_charge.currency_round(sum(a.balance * (a.date_to - a.date_from+1))
3884: / sum(a.date_to - a.date_from+1),
3885: a.currency_code) overdue_late_pay_amount,
3886: decode(a.interest_type,
3887: 'FIXED_RATE',a.interest_rate, NULL) interest_rate,

Line 3892: ar_calc_late_charge.currency_round(nvl(

3888: sum(a.date_to - a.date_from+1) interest_days,
3889: decode(a.interest_type,
3890: 'FIXED_AMOUNT', a.interest_fixed_amount,
3891: 'FIXED_RATE',
3892: ar_calc_late_charge.currency_round(nvl(
3893: ((sum(a.balance * (a.date_to - a.date_from+1))/
3894: sum(a.date_to - a.date_from+1))/100
3895: *a.interest_rate
3896: ),

Line 3914: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,

3910: cons_inv.currency_code,
3911: cons_inv.org_id,
3912: cons_inv.billing_date date_from,
3913: decode(sign(l_fin_charge_date -
3914: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,
3915: cons_inv.site_use_id,
3916: cons_inv.currency_code,
3917: cons_inv.org_id,
3918: sysparam.post_billing_item_inclusion,

Line 3922: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,

3918: sysparam.post_billing_item_inclusion,
3919: cons_inv.billing_date,
3920: l_fin_charge_date)),
3921: -1,l_fin_charge_date,
3922: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,
3923: cons_inv.site_use_id,
3924: cons_inv.currency_code,
3925: cons_inv.org_id,
3926: sysparam.post_billing_item_inclusion,

Line 3970: NULL, ar_calc_late_charge.get_first_activity_date(cust_site.customer_id,

3966: cust_site.customer_site_use_id,
3967: cust_site.currency_code,
3968: cust_site.org_id,
3969: decode(cust_site.last_accrue_charge_date,
3970: NULL, ar_calc_late_charge.get_first_activity_date(cust_site.customer_id,
3971: cust_site.customer_site_use_id,
3972: cust_site.currency_code,
3973: cust_site.org_id),
3974: cust_site.last_accrue_charge_date+1) date_from,

Line 3976: ar_calc_late_charge.get_next_activity_date(cust_site.customer_id,

3972: cust_site.currency_code,
3973: cust_site.org_id),
3974: cust_site.last_accrue_charge_date+1) date_from,
3975: decode(sign(l_fin_charge_date -
3976: ar_calc_late_charge.get_next_activity_date(cust_site.customer_id,
3977: cust_site.customer_site_use_id,
3978: cust_site.currency_code,
3979: cust_site.org_id,
3980: sysparam.post_billing_item_inclusion,

Line 3989: ar_calc_late_charge.get_next_activity_date(cust_site.customer_id,

3985: cust_site.org_id),
3986: cust_site.last_accrue_charge_date+1),
3987: l_fin_charge_date)),
3988: -1, l_fin_charge_date,
3989: ar_calc_late_charge.get_next_activity_date(cust_site.customer_id,
3990: cust_site.customer_site_use_id,
3991: cust_site.currency_code,
3992: cust_site.org_id,
3993: sysparam.post_billing_item_inclusion,

Line 4000: ar_calc_late_charge.get_cust_balance(cust_site.customer_id,

3996: cust_site.customer_site_use_id, cust_site.currency_code,
3997: cust_site.org_id),
3998: cust_site.last_accrue_charge_date+1),
3999: l_fin_charge_date)) date_to,
4000: ar_calc_late_charge.get_cust_balance(cust_site.customer_id,
4001: cust_site.customer_site_use_id,
4002: cust_site.currency_code,
4003: cust_site.org_id,
4004: sysparam.post_billing_item_inclusion,

Line 4041: ar_calc_late_charge.get_next_activity_date(ps.customer_id,

4037: cust_sites.currency_code,
4038: cust_sites.org_id,
4039: ps.trx_date,
4040: decode(sign(l_fin_charge_date -
4041: ar_calc_late_charge.get_next_activity_date(ps.customer_id,
4042: ps.customer_site_use_id,
4043: ps.invoice_currency_code,
4044: ps.org_id,
4045: sysparam.post_billing_item_inclusion,

Line 4049: ar_calc_late_charge.get_next_activity_date(ps.customer_id,

4045: sysparam.post_billing_item_inclusion,
4046: ps.trx_date,
4047: l_fin_charge_date)),
4048: -1, l_fin_charge_date,
4049: ar_calc_late_charge.get_next_activity_date(ps.customer_id,
4050: ps.customer_site_use_id,
4051: ps.invoice_currency_code,
4052: ps.org_id,
4053: sysparam.post_billing_item_inclusion,

Line 4056: ar_calc_late_charge.get_cust_balance(ps.customer_id,

4052: ps.org_id,
4053: sysparam.post_billing_item_inclusion,
4054: ps.trx_date,
4055: l_fin_charge_date)) date_to,
4056: ar_calc_late_charge.get_cust_balance(ps.customer_id,
4057: ps.customer_site_use_id,
4058: ps.invoice_currency_code,
4059: ps.org_id,
4060: sysparam.post_billing_item_inclusion,

Line 4081: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4077: ar_lc_cust_sites_t cust_sites,
4078: ar_system_parameters sysparam
4079: where ps.customer_id = cust_sites.customer_id
4080: and decode(ps.class,
4081: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4082: ps.customer_site_use_id,
4083: ps.org_id),
4084: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4085: ps.customer_site_use_id,

Line 4084: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4080: and decode(ps.class,
4081: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4082: ps.customer_site_use_id,
4083: ps.org_id),
4084: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4085: ps.customer_site_use_id,
4086: ps.org_id),
4087: ps.customer_site_use_id) = cust_sites.customer_site_use_id
4088: and ps.invoice_currency_code = cust_sites.currency_code

Line 4146: where ar_calc_late_charge.check_adb_eligibility(b.customer_id,

4142: a.min_fc_balance_overdue_type,
4143: a.min_fc_balance_amount,
4144: a.min_fc_balance_percent)b
4145: /* Apply the customer level tolerance - check for eligibility */
4146: where ar_calc_late_charge.check_adb_eligibility(b.customer_id,
4147: b.site_use_id,
4148: b.currency_code,
4149: b.org_id,
4150: b.payment_grace_days,

Line 4239: ar_calc_late_charge.currency_round(nvl(b.overdue_late_pay_amt_org /100* b.interest_rate,0),

4235: NULL, -- bucket days to
4236: decode(b.interest_type,
4237: 'FIXED_AMOUNT', b.interest_fixed_amount,
4238: 'FIXED_RATE',
4239: ar_calc_late_charge.currency_round(nvl(b.overdue_late_pay_amt_org /100* b.interest_rate,0),
4240: b.currency_code)) late_charge_amount,
4241: 'INV' ,
4242: b.late_charge_term_id,
4243: NULL, -- interest_period_days not applicable

Line 4274: ar_calc_late_charge.currency_round(sum(a.balance * (a.date_to - a.date_from+1)) /

4270: a.payment_grace_days,
4271: a.min_fc_balance_overdue_type,
4272: a.min_fc_balance_amount,
4273: a.min_fc_balance_percent,
4274: ar_calc_late_charge.currency_round(sum(a.balance * (a.date_to - a.date_from+1)) /
4275: sum(a.date_to - a.date_from+1),
4276: a.currency_code) overdue_late_pay_amount,
4277: sum(a.balance * (a.date_to - a.date_from+1)) /
4278: sum(a.date_to - a.date_from+1) overdue_late_pay_amt_org,

Line 4289: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,

4285: cons_inv.currency_code,
4286: cons_inv.org_id,
4287: cons_inv.due_date+1 date_from,
4288: decode(sign(l_fin_charge_date-
4289: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,
4290: cons_inv.site_use_id,
4291: cons_inv.currency_code,
4292: cons_inv.org_id,
4293: sysparam.post_billing_item_inclusion,

Line 4297: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,

4293: sysparam.post_billing_item_inclusion,
4294: cons_inv.due_date+1,
4295: l_fin_charge_date)),
4296: -1,l_fin_charge_date,
4297: ar_calc_late_charge.get_next_activity_date(cons_inv.customer_id,
4298: cons_inv.site_use_id,
4299: cons_inv.currency_code,
4300: cons_inv.org_id,
4301: sysparam.post_billing_item_inclusion,

Line 4304: ar_calc_late_charge.get_cust_balance(cons_inv.customer_id,

4300: cons_inv.org_id,
4301: sysparam.post_billing_item_inclusion,
4302: cons_inv.due_date+1,
4303: l_fin_charge_date)) date_to,
4304: ar_calc_late_charge.get_cust_balance(cons_inv.customer_id,
4305: cons_inv.site_use_id,
4306: cons_inv.currency_code,
4307: cons_inv.org_id,
4308: sysparam.post_billing_item_inclusion,

Line 4353: ar_calc_late_charge.get_next_activity_date(ps.customer_id,

4349: cust_sites.currency_code,
4350: cust_sites.org_id,
4351: ps.trx_date,
4352: decode(sign(l_fin_charge_date -
4353: ar_calc_late_charge.get_next_activity_date(ps.customer_id,
4354: ps.customer_site_use_id,
4355: ps.invoice_currency_code,
4356: ps.org_id,
4357: sysparam.post_billing_item_inclusion,

Line 4361: ar_calc_late_charge.get_next_activity_date(ps.customer_id,

4357: sysparam.post_billing_item_inclusion,
4358: ps.trx_date,
4359: l_fin_charge_date)),
4360: -1, l_fin_charge_date,
4361: ar_calc_late_charge.get_next_activity_date(ps.customer_id,
4362: ps.customer_site_use_id,
4363: ps.invoice_currency_code,
4364: ps.org_id,
4365: sysparam.post_billing_item_inclusion,

Line 4368: ar_calc_late_charge.get_cust_balance(ps.customer_id,

4364: ps.org_id,
4365: sysparam.post_billing_item_inclusion,
4366: ps.trx_date,
4367: l_fin_charge_date)) date_to,
4368: ar_calc_late_charge.get_cust_balance(ps.customer_id,
4369: ps.customer_site_use_id,
4370: ps.invoice_currency_code,
4371: ps.org_id,
4372: sysparam.post_billing_item_inclusion,

Line 4393: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4389: ar_lc_cust_sites_t cust_sites,
4390: ar_system_parameters sysparam
4391: where ps.customer_id = cust_sites.customer_id
4392: and decode(ps.class,
4393: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4394: ps.customer_site_use_id,
4395: ps.org_id),
4396: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4397: ps.customer_site_use_id,

Line 4396: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4392: and decode(ps.class,
4393: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4394: ps.customer_site_use_id,
4395: ps.org_id),
4396: 'PMT',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4397: ps.customer_site_use_id,
4398: ps.org_id),
4399: ps.customer_site_use_id) = cust_sites.customer_site_use_id
4400: and ps.invoice_currency_code = cust_sites.currency_code

Line 4425: and ar_calc_late_charge.check_adb_eligibility(a.customer_id,

4421: and ci2.billing_date < l_fin_charge_date
4422: and ci2.status in ('FINAL', 'ACCEPTED','IMPORTED')))a
4423: where nvl(a.balance,0) <> 0
4424: /* Apply the customer level tolerance - check for eligibility */
4425: and ar_calc_late_charge.check_adb_eligibility(a.customer_id,
4426: a.site_use_id,
4427: a.currency_code,
4428: a.org_id,
4429: a.payment_grace_days,

Line 4465: debug( 'ar_calc_late_charge. insert_int_avg_daily_bal()-' );

4461: and bat.batch_status ='F'
4462: and bat.transferred_status <> 'S'));
4463:
4464: IF l_debug_flag = 'Y' THEN
4465: debug( 'ar_calc_late_charge. insert_int_avg_daily_bal()-' );
4466: END IF;
4467: --
4468: EXCEPTION
4469: WHEN OTHERS THEN

Line 4472: debug('EXCEPTION: ar_calc_late_charge. insert_int_avg_daily_bal' );

4468: EXCEPTION
4469: WHEN OTHERS THEN
4470: --IF l_debug_flag = 'Y' THEN
4471: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
4472: debug('EXCEPTION: ar_calc_late_charge. insert_int_avg_daily_bal' );
4473: --END IF;
4474: RAISE;
4475:
4476: END insert_int_avg_daily_bal;

Line 4483: debug( 'ar_calc_late_charge.insert_cust_balances()+');

4479: p_worker_number IN NUMBER,
4480: p_total_workers IN NUMBER) IS
4481: BEGIN
4482: IF l_debug_flag = 'Y' THEN
4483: debug( 'ar_calc_late_charge.insert_cust_balances()+');
4484: END IF;
4485: INSERT INTO ar_late_charge_cust_balance_gt
4486: (late_charge_cust_sites_id,
4487: customer_id,

Line 4513: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4509: FROM ar_payment_schedules ps,
4510: ar_lc_cust_sites_t cust_site
4511: WHERE ps.customer_id = cust_site.customer_id
4512: AND cust_site.customer_site_use_id = decode(ps.class,
4513: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4514: ps.customer_site_use_id,
4515: ps.org_id),
4516: ps.customer_site_use_id)
4517: AND ps.invoice_currency_code = cust_site.currency_code

Line 4547: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4543: ar_payment_schedules ps_cm_cr,
4544: ar_lc_cust_sites_t cust_site
4545: WHERE ps.customer_id = cust_site.customer_id
4546: AND cust_site.customer_site_use_id = decode(ps.class,
4547: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4548: ps.customer_site_use_id,
4549: ps.org_id),
4550: ps.customer_site_use_id)
4551: AND ps.invoice_currency_code = cust_site.currency_code

Line 4584: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4580: ar_receivable_applications ra,
4581: ar_lc_cust_sites_t cust_site
4582: WHERE ps.customer_id = cust_site.customer_id
4583: AND cust_site.customer_site_use_id = decode(ps.class,
4584: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4585: ps.customer_site_use_id,
4586: ps.org_id),
4587: ps.customer_site_use_id)
4588: AND ps.invoice_currency_code = cust_site.currency_code

Line 4620: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4616: ar_payment_schedules ps,
4617: ar_lc_cust_sites_t cust_site
4618: WHERE ps.customer_id = cust_site.customer_id
4619: AND cust_site.customer_site_use_id = decode(ps.class,
4620: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4621: ps.customer_site_use_id,
4622: ps.org_id),
4623: ps.customer_site_use_id)
4624: AND mod(nvl(cust_site.customer_site_use_id,0),p_total_workers) =

Line 4652: AND cust_site.customer_site_use_id = ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4648: ps.org_id
4649: FROM ar_payment_schedules ps,
4650: ar_lc_cust_sites_t cust_site
4651: WHERE ps.customer_id = cust_site.customer_id
4652: AND cust_site.customer_site_use_id = ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4653: ps.customer_site_use_id,
4654: ps.org_id)
4655: AND ps.invoice_currency_code = cust_site.currency_code
4656: AND mod(nvl(cust_site.customer_site_use_id,0),p_total_workers) =

Line 4687: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,

4683: ra_customer_trx_lines lines,
4684: ar_lc_cust_sites_t cust_site
4685: WHERE ps.customer_id = cust_site.customer_id
4686: AND cust_site.customer_site_use_id = decode(ps.class,
4687: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4688: ps.customer_site_use_id,
4689: ps.org_id),
4690: ps.customer_site_use_id)
4691: AND ps.invoice_currency_code = cust_site.currency_code

Line 4718: debug( 'ar_calc_late_charge.insert_cust_balances()-');

4714: a.currency_code,
4715: a.org_id);
4716:
4717: IF l_debug_flag = 'Y' THEN
4718: debug( 'ar_calc_late_charge.insert_cust_balances()-');
4719: END IF;
4720: EXCEPTION
4721: WHEN OTHERS THEN
4722: --IF l_debug_flag = 'Y' THEN

Line 4724: debug('EXCEPTION: ar_calc_late_charge.insert_cust_balances' );

4720: EXCEPTION
4721: WHEN OTHERS THEN
4722: --IF l_debug_flag = 'Y' THEN
4723: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
4724: debug('EXCEPTION: ar_calc_late_charge.insert_cust_balances' );
4725: --END IF;
4726: RAISE;
4727:
4728: END insert_cust_balances;

Line 4768: debug( 'ar_calc_late_charge.insert_penalty_lines()+' );

4764:
4765: BEGIN
4766:
4767: IF l_debug_flag = 'Y' THEN
4768: debug( 'ar_calc_late_charge.insert_penalty_lines()+' );
4769: END IF;
4770:
4771: insert into ar_late_charge_trx_t
4772: ( late_charge_trx_id,

Line 4848: NVL(a.penalty_amount,ar_calc_late_charge.currency_round(nvl(a.penalty_rate,0) * a.interest/100,

4844: a.rate_start_date,
4845: a.rate_end_date,
4846: a.schedule_days_start,
4847: a.schedule_days_to,
4848: NVL(a.penalty_amount,ar_calc_late_charge.currency_round(nvl(a.penalty_rate,0) * a.interest/100,
4849: a.currency_code)),
4850: a.late_charge_type,
4851: a.late_charge_term_id,
4852: a.interest_period_days,

Line 5037: debug( 'ar_calc_late_charge.insert_penalty_lines()-' );

5033: trx.message_text_id,
5034: cust_site.penalty_type) a);
5035:
5036: IF l_debug_flag = 'Y' THEN
5037: debug( 'ar_calc_late_charge.insert_penalty_lines()-' );
5038: END IF;
5039: --
5040: EXCEPTION
5041: WHEN OTHERS THEN

Line 5044: debug('EXCEPTION: ar_calc_late_charge.insert_penalty_lines' );

5040: EXCEPTION
5041: WHEN OTHERS THEN
5042: --IF l_debug_flag = 'Y' THEN
5043: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5044: debug('EXCEPTION: ar_calc_late_charge.insert_penalty_lines' );
5045: --END IF;
5046: RAISE;
5047: END insert_penalty_lines;
5048:

Line 5055: debug('ar_calc_late_charge.delete_draft_batches()+');

5051:
5052: BEGIN
5053:
5054: IF l_debug_flag = 'Y' THEN
5055: debug('ar_calc_late_charge.delete_draft_batches()+');
5056: debug('p_worker_number : '||p_worker_number);
5057: debug('p_total_workers : '||p_total_workers);
5058: END IF;
5059: /* delete lines first */

Line 5089: debug('ar_calc_late_charge.delete_draft_batches()-');

5085: /* Deleting the empty batches are done later in delete_empty_batches */
5086:
5087:
5088: IF l_debug_flag = 'Y' THEN
5089: debug('ar_calc_late_charge.delete_draft_batches()-');
5090: END IF;
5091:
5092: EXCEPTION WHEN OTHERS THEN
5093: --IF l_debug_flag = 'Y' THEN

Line 5095: debug('EXCEPTION : ar_calc_late_charge.delete_draft_batches()');

5091:
5092: EXCEPTION WHEN OTHERS THEN
5093: --IF l_debug_flag = 'Y' THEN
5094: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5095: debug('EXCEPTION : ar_calc_late_charge.delete_draft_batches()');
5096: --END IF;
5097: RAISE;
5098: END delete_draft_batches;
5099:

Line 5119: debug( 'ar_calc_late_charge.insert_int_batches()+' );

5115:
5116: BEGIN
5117:
5118: IF l_debug_flag = 'Y' THEN
5119: debug( 'ar_calc_late_charge.insert_int_batches()+' );
5120: END IF;
5121:
5122: l_operating_unit_id := p_operating_unit_id;
5123: l_batch_name := p_batch_name;

Line 5174: debug( 'ar_calc_late_charge.insert_int_batches()-' );

5170: from ar_system_parameters sysparam
5171: where nvl(l_operating_unit_id,sysparam.org_id) = sysparam.org_id);
5172:
5173: IF l_debug_flag = 'Y' THEN
5174: debug( 'ar_calc_late_charge.insert_int_batches()-' );
5175: END IF;
5176: --
5177: EXCEPTION
5178: WHEN OTHERS THEN

Line 5181: debug('EXCEPTION: ar_calc_late_charge.insert_int_batches' );

5177: EXCEPTION
5178: WHEN OTHERS THEN
5179: --IF l_debug_flag = 'Y' THEN
5180: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5181: debug('EXCEPTION: ar_calc_late_charge.insert_int_batches' );
5182: --END IF;
5183: RAISE;
5184: END insert_int_batches;
5185:

Line 5193: debug( 'ar_calc_late_charge.insert_int_headers()+' );

5189: p_total_workers IN NUMBER) IS
5190: BEGIN
5191:
5192: IF l_debug_flag = 'Y' THEN
5193: debug( 'ar_calc_late_charge.insert_int_headers()+' );
5194: END IF;
5195:
5196: insert into ar_interest_headers
5197: (interest_header_id,

Line 5356: debug( 'ar_calc_late_charge.insert_int_headers()-' );

5352: and sysparam.org_id = cust_site.org_id
5353: and bat.request_id = l_request_id);
5354:
5355: IF l_debug_flag = 'Y' THEN
5356: debug( 'ar_calc_late_charge.insert_int_headers()-' );
5357: END IF;
5358: --
5359: EXCEPTION
5360: WHEN OTHERS THEN

Line 5363: debug('EXCEPTION: ar_calc_late_charge.insert_int_headers' );

5359: EXCEPTION
5360: WHEN OTHERS THEN
5361: --IF l_debug_flag = 'Y' THEN
5362: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5363: debug('EXCEPTION: ar_calc_late_charge.insert_int_headers' );
5364: --END IF;
5365: RAISE;
5366: END insert_int_headers;
5367:

Line 5417: debug( 'ar_calc_late_charge.insert_int_lines()+' );

5413: PROCEDURE insert_int_lines(p_worker_number IN NUMBER,
5414: p_total_workers IN NUMBER) IS
5415: BEGIN
5416: IF l_debug_flag = 'Y' THEN
5417: debug( 'ar_calc_late_charge.insert_int_lines()+' );
5418: END IF;
5419:
5420: insert into ar_interest_lines
5421: (interest_line_id,

Line 5573: 'PENALTY',ar_calc_late_charge.get_penalty_rec_trx_id(trx.finance_charge_date,

5569: trx.amount_due_remaining,
5570: trx.customer_trx_id original_trx_id,
5571: decode(hdr.late_charge_type,
5572: 'ADJ',decode(trx.charge_line_type,
5573: 'PENALTY',ar_calc_late_charge.get_penalty_rec_trx_id(trx.finance_charge_date,
5574: trx.org_id),
5575: 'INTEREST',ar_calc_late_charge.get_int_rec_trx_id(trx.customer_trx_id,
5576: trx.finance_charge_date,
5577: trx.org_id),

Line 5575: 'INTEREST',ar_calc_late_charge.get_int_rec_trx_id(trx.customer_trx_id,

5571: decode(hdr.late_charge_type,
5572: 'ADJ',decode(trx.charge_line_type,
5573: 'PENALTY',ar_calc_late_charge.get_penalty_rec_trx_id(trx.finance_charge_date,
5574: trx.org_id),
5575: 'INTEREST',ar_calc_late_charge.get_int_rec_trx_id(trx.customer_trx_id,
5576: trx.finance_charge_date,
5577: trx.org_id),
5578: NULL),
5579: NULL) receivables_trx_id,

Line 5591: ar_calc_late_charge.get_next_hdr_id interest_header_id,

5587: trx.schedule_days_to,
5588: trx.org_id
5589: from
5590: (select
5591: ar_calc_late_charge.get_next_hdr_id interest_header_id,
5592: a.customer_id,
5593: a.customer_site_use_id,
5594: a.currency_code,
5595: a.legal_entity_id,

Line 5671: debug( 'ar_calc_late_charge.insert_int_lines()-' );

5667: and trx1.display_flag = 'Y')))
5668: and hdr.payment_schedule_id = decode(trx.late_charge_type,'INV',-99,trx.payment_schedule_id)) a ) b);
5669:
5670: IF l_debug_flag = 'Y' THEN
5671: debug( 'ar_calc_late_charge.insert_int_lines()-' );
5672: END IF;
5673: --
5674: EXCEPTION
5675: WHEN OTHERS THEN

Line 5678: debug('EXCEPTION: ar_calc_late_charge.insert_int_lines');

5674: EXCEPTION
5675: WHEN OTHERS THEN
5676: --IF l_debug_flag = 'Y' THEN
5677: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5678: debug('EXCEPTION: ar_calc_late_charge.insert_int_lines');
5679: --END IF;
5680: RAISE;
5681: END insert_int_lines;
5682:

Line 5690: debug( 'ar_calc_late_charge.insert_int_lines_adb()+' );

5686: PROCEDURE insert_int_lines_adb(p_worker_number IN NUMBER,
5687: p_total_workers IN NUMBER) IS
5688: BEGIN
5689: IF l_debug_flag = 'Y' THEN
5690: debug( 'ar_calc_late_charge.insert_int_lines_adb()+' );
5691: END IF;
5692:
5693: insert into ar_interest_lines
5694: (interest_line_id,

Line 5821: ar_calc_late_charge.get_next_hdr_id interest_header_id,

5817: trx.schedule_days_to,
5818: trx.org_id
5819: from
5820: (select
5821: ar_calc_late_charge.get_next_hdr_id interest_header_id,
5822: a.customer_id,
5823: a.customer_site_use_id,
5824: a.currency_code,
5825: a.legal_entity_id,

Line 5872: debug( 'ar_calc_late_charge.insert_int_lines_adb()-' );

5868: and trx.charge_type = 'AVERAGE_DAILY_BALANCE'
5869: and hdr.payment_schedule_id = decode(trx.late_charge_type,'INV',-99,trx.payment_schedule_id)) a )b);
5870:
5871: IF l_debug_flag = 'Y' THEN
5872: debug( 'ar_calc_late_charge.insert_int_lines_adb()-' );
5873: END IF;
5874: --
5875: EXCEPTION
5876: WHEN OTHERS THEN

Line 5879: debug('EXCEPTION: ar_calc_late_charge.insert_int_lines_adb');

5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: --IF l_debug_flag = 'Y' THEN
5878: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5879: debug('EXCEPTION: ar_calc_late_charge.insert_int_lines_adb');
5880: --END IF;
5881: RAISE;
5882: END insert_int_lines_adb;
5883:

Line 5887: debug('ar_calc_late_charge.delete_empty_batches()+');

5883:
5884: PROCEDURE delete_empty_batches IS
5885: BEGIN
5886: IF l_debug_flag = 'Y' THEN
5887: debug('ar_calc_late_charge.delete_empty_batches()+');
5888: END IF;
5889:
5890: delete from ar_interest_batches bat
5891: where not exists (select interest_header_id

Line 5898: debug('ar_calc_late_charge.delete_empty_batches()-');

5894: and ( request_id = l_request_id
5895: OR batch_status = 'D') ;
5896:
5897: IF l_debug_flag = 'Y' THEN
5898: debug('ar_calc_late_charge.delete_empty_batches()-');
5899: END IF;
5900: EXCEPTION WHEN OTHERS THEN
5901: --IF l_debug_flag = 'Y' THEN
5902: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);

Line 5903: debug('EXCEPTION: ar_calc_late_charge.delete_empty_batches()');

5899: END IF;
5900: EXCEPTION WHEN OTHERS THEN
5901: --IF l_debug_flag = 'Y' THEN
5902: debug('EXCEPTION : '||SQLCODE||' : '||SQLERRM);
5903: debug('EXCEPTION: ar_calc_late_charge.delete_empty_batches()');
5904: --END IF;
5905: END delete_empty_batches;
5906:
5907: PROCEDURE lock_batches IS

Line 5925: debug('ar_calc_late_charge.lock_batches ()+');

5921: l_bulk_fetch_rows number := 1000;
5922: l_last_fetch_rows boolean := FALSE;
5923:
5924: BEGIN
5925: debug('ar_calc_late_charge.lock_batches ()+');
5926:
5927: OPEN c_lock;
5928:
5929: LOOP

Line 5940: debug('ar_calc_late_charge.lock_batches ()-');

5936: END IF;
5937: END LOOP;
5938: CLOSE c_lock;
5939:
5940: debug('ar_calc_late_charge.lock_batches ()-');
5941: EXCEPTION
5942: WHEN OTHERS THEN
5943: debug('EXCEPTION : ar_calc_late_charge.lock_batches ()');
5944: debug('EXCEPTION : '||SQLCODE ||' : '||SQLERRM);

Line 5943: debug('EXCEPTION : ar_calc_late_charge.lock_batches ()');

5939:
5940: debug('ar_calc_late_charge.lock_batches ()-');
5941: EXCEPTION
5942: WHEN OTHERS THEN
5943: debug('EXCEPTION : ar_calc_late_charge.lock_batches ()');
5944: debug('EXCEPTION : '||SQLCODE ||' : '||SQLERRM);
5945: RAISE;
5946: END lock_batches;
5947:

Line 6604: debug('ar_calc_late_charge.create_late_charge_document()+ ');

6600:
6601: l_debug_flag := p_enable_debug;
6602:
6603: IF l_debug_flag = 'Y' THEN
6604: debug('ar_calc_late_charge.create_late_charge_document()+ ');
6605: debug('Global package variables');
6606: debug('pg_last_updated_by : '||pg_last_updated_by);
6607: debug('pg_last_update_login : '||pg_last_update_login);
6608: END IF;

Line 6826: debug('ar_calc_late_charge.create_late_charge_document()- ');

6822:
6823: retcode := 0;
6824:
6825: IF l_debug_flag = 'Y' THEN
6826: debug('ar_calc_late_charge.create_late_charge_document()- ');
6827: END IF;
6828: EXCEPTION WHEN OTHERS THEN
6829: /* delete the data in the interim tables before commit */
6830: delete from ar_lc_cust_sites_t;

Line 7146: END AR_CALC_LATE_CHARGE;

7142: pg_last_updated_by := arp_global.last_updated_by;
7143: pg_last_update_login := arp_global.last_update_login;
7144: -- l_debug_flag := 'Y'; /* Enable Debug now */
7145:
7146: END AR_CALC_LATE_CHARGE;