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.ARP_PROCESS_CREDIT dependencies on ARP_PROCESS_CREDIT

Line 1: PACKAGE BODY ARP_PROCESS_CREDIT AS

1: PACKAGE BODY ARP_PROCESS_CREDIT AS
2: /* $Header: ARTECMRB.pls 120.17.12010000.4 2008/11/19 09:47:50 ankuagar ship $ */
3:
4: pg_number_dummy number;
5: pg_date_dummy date;

Line 66: arp_util.debug('arp_process_credit.create_salescredits()+');

62: p_currency_code IN fnd_currencies.currency_code%type)
63: IS
64: BEGIN
65:
66: arp_util.debug('arp_process_credit.create_salescredits()+');
67:
68: IF (p_customer_trx_line_id IS NULL)
69: THEN
70:

Line 104: arp_util.debug('arp_process_credit.create_salescredits()-');

100: p_currency_code);
101: END IF;
102: END IF;
103:
104: arp_util.debug('arp_process_credit.create_salescredits()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

Line 108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

104: arp_util.debug('arp_process_credit.create_salescredits()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

Line 173: arp_util.debug('arp_process_credit.credit_freight()+');

169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN
172:
173: arp_util.debug('arp_process_credit.credit_freight()+');
174:
175: IF ( p_prev_ct_id IS NULL)
176: OR
177: ( p_prev_ct_id IS NOT NULL

Line 298: arp_util.debug('arp_process_credit.credit_freight()-');

294: 'FREIGHT');
295: END IF;
296: END IF;
297:
298: arp_util.debug('arp_process_credit.credit_freight()-');
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

Line 302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

298: arp_util.debug('arp_process_credit.credit_freight()-');
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

Line 352: arp_util.debug('arp_process_credit.default_credit_header()+');

348: IS
349: l_cr_txn_rec ra_customer_trx%rowtype;
350: BEGIN
351:
352: arp_util.debug('arp_process_credit.default_credit_header()+');
353:
354: p_new_cm_rec := p_cm_rec;
355: p_new_cm_rec.previous_customer_trx_id := p_prev_customer_trx_id;
356: p_new_cm_rec.complete_flag := 'N';

Line 401: arp_util.debug('arp_process_credit.default_credit_header()-');

397: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
398:
399: END IF;
400:
401: arp_util.debug('arp_process_credit.default_credit_header()-');
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

Line 405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

401: arp_util.debug('arp_process_credit.default_credit_header()-');
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');
406: RAISE;
407: END;
408:
409: /*===========================================================================+

Line 435: arp_util.debug('arp_process_credit.validate_insert_header()+');

431: +===========================================================================*/
432: PROCEDURE validate_insert_header
433: IS
434: BEGIN
435: arp_util.debug('arp_process_credit.validate_insert_header()+');
436:
437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION

Line 437: arp_util.debug('arp_process_credit.validate_insert_header()-');

433: IS
434: BEGIN
435: arp_util.debug('arp_process_credit.validate_insert_header()+');
436:
437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

Line 441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');
442: RAISE;
443:
444: END;
445:

Line 473: arp_util.debug('arp_process_credit.validate_update_header()+');

469: +===========================================================================*/
470: PROCEDURE validate_update_header
471: IS
472: BEGIN
473: arp_util.debug('arp_process_credit.validate_update_header()+');
474:
475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION

Line 475: arp_util.debug('arp_process_credit.validate_update_header()-');

471: IS
472: BEGIN
473: arp_util.debug('arp_process_credit.validate_update_header()+');
474:
475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

Line 479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');
480: RAISE;
481:
482: END;
483:

Line 514: arp_util.debug('arp_process_credit.validate_insert_line()+');

510: PROCEDURE validate_insert_line(
511: p_line_rec IN ra_customer_trx_lines%rowtype)
512: IS
513: BEGIN
514: arp_util.debug('arp_process_credit.validate_insert_line()+');
515:
516: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
517: p_line_rec.customer_trx_id,
518: p_line_rec.customer_trx_line_id);

Line 520: arp_util.debug('arp_process_credit.validate_insert_line()-');

516: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
517: p_line_rec.customer_trx_id,
518: p_line_rec.customer_trx_line_id);
519:
520: arp_util.debug('arp_process_credit.validate_insert_line()-');
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

Line 524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

520: arp_util.debug('arp_process_credit.validate_insert_line()-');
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');
525: RAISE;
526:
527: END;
528:

Line 555: arp_util.debug('arp_process_credit.validate_update_line()+');

551: +===========================================================================*/
552: PROCEDURE validate_update_line
553: IS
554: BEGIN
555: arp_util.debug('arp_process_credit.validate_update_line()+');
556:
557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION

Line 557: arp_util.debug('arp_process_credit.validate_update_line()-');

553: IS
554: BEGIN
555: arp_util.debug('arp_process_credit.validate_update_line()+');
556:
557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

Line 561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');
562: RAISE;
563:
564: END;
565:

Line 609: arp_util.debug('arp_process_credit.default_credit_line()+');

605: l_trx_rec ra_customer_trx%rowtype;
606: l_calc_unit_price VARCHAR2(1); --2880106
607: BEGIN
608:
609: arp_util.debug('arp_process_credit.default_credit_line()+');
610:
611: p_new_cm_line := p_cm_line;
612: p_new_cm_line.customer_trx_id := p_customer_trx_id;
613: p_new_cm_line.extended_amount := p_line_amount;

Line 766: arp_util.debug('arp_process_credit.default_credit_line()-');

762: p_new_cm_line.ship_to_contact_id := l_cr_txn_line.ship_to_contact_id;
763:
764: END IF;
765:
766: arp_util.debug('arp_process_credit.default_credit_line()-');
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

Line 770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

766: arp_util.debug('arp_process_credit.default_credit_line()-');
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');
771: RAISE;
772:
773: END;
774:

Line 798: arp_util.debug('arp_process_credit.get_cm_amounts()+');

794: l_freight_line_count number;
795:
796: BEGIN
797:
798: arp_util.debug('arp_process_credit.get_cm_amounts()+');
799:
800: IF (p_customer_trx_id IS NOT NULL)
801: THEN
802:

Line 865: arp_util.debug('arp_process_credit.get_cm_amounts()-');

861: END IF;
862:
863: END IF;
864:
865: arp_util.debug('arp_process_credit.get_cm_amounts()-');
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

Line 869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

865: arp_util.debug('arp_process_credit.get_cm_amounts()-');
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');
870:
871: RAISE;
872:
873: END;

Line 925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');

921: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
922:
923: BEGIN
924:
925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');
926:
927: SELECT sum(nra.net_amount),
928: count(nra.customer_trx_line_id),
929: max(decode(p_prev_ctl_id,

Line 996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');

992: p_freight_type := l_freight_type;
993: p_freight_ctl_id := l_freight_ctl_id;
994: END IF;
995:
996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

Line 1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');
1001: RAISE;
1002: END;
1003:
1004:

Line 1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');

1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN
1050:
1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1052:
1053: SELECT sum(decode(
1054: decode(nra.line_type,
1055: 'CB', 'LINE',

Line 1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');

1129: l_freight_balance_due;
1130: END IF;
1131: END IF;
1132:
1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

Line 1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1138: arp_util.debug('');
1139:
1140: RAISE;
1141:

Line 1228: arp_util.debug('arp_process_credit.derive_credit_information()+');

1224: l_tax_status varchar2(30) := 'OK';
1225: l_frt_status varchar2(30) := 'OK';
1226: BEGIN
1227:
1228: arp_util.debug('arp_process_credit.derive_credit_information()+');
1229:
1230: IF (nvl(pg_num_credit_lines, 0) > 0)
1231: THEN
1232:

Line 1262: arp_process_credit.insert_line(

1258: l_tax_amount := -1 * l_total_uncr_tax_amount;
1259:
1260: l_line_status := 'OK';
1261:
1262: arp_process_credit.insert_line(
1263: p_form_name,
1264: p_form_version,
1265: l_line_rec,
1266: -1 * l_total_uncr_line_amount,

Line 1438: arp_util.debug('arp_process_credit.derive_credit_information()-');

1434: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
1435: p_status := l_cmm_status;
1436: END IF;
1437:
1438: arp_util.debug('arp_process_credit.derive_credit_information()-');
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: derive_credit_information');

Line 1526: arp_util.debug('arp_process_credit.insert_header()+');

1522: l_ev_rec arp_xla_events.xla_events_type;
1523:
1524: BEGIN
1525:
1526: arp_util.debug('arp_process_credit.insert_header()+');
1527:
1528: /*--------------------------------------------------------------+
1529: | check form version to determine IF it is compatible with the |
1530: | entity handler. |

Line 1649: arp_util.debug('arp_process_credit.insert_header()-');

1645: IF l_df_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1646: p_status := 'eTAX_ERROR';
1647: END IF;
1648:
1649: arp_util.debug('arp_process_credit.insert_header()-');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

Line 1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

1649: arp_util.debug('arp_process_credit.insert_header()-');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');
1654: RAISE;
1655: END;
1656:
1657: /*===========================================================================+

Line 1692: arp_util.debug('arp_process_credit.delete_cm_records()+');

1688: p_trx_number_change_flag IN boolean)
1689: IS
1690: BEGIN
1691:
1692: arp_util.debug('arp_process_credit.delete_cm_records()+');
1693:
1694: /*-----------------------+
1695: | delete sales credits |
1696: +-----------------------*/

Line 1725: arp_util.debug('arp_process_credit.delete_cm_records()-');

1721: | delete line records |
1722: +---------------------*/
1723: arp_ctl_pkg.delete_f_ct_id(p_customer_trx_id);
1724:
1725: arp_util.debug('arp_process_credit.delete_cm_records()-');
1726:
1727: EXCEPTION
1728:
1729: WHEN OTHERS THEN

Line 1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');

1726:
1727: EXCEPTION
1728:
1729: WHEN OTHERS THEN
1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1731: arp_util.debug('');
1732: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1733:
1734: RAISE;

Line 1754: arp_util.debug('arp_process_credit.line_rerun_aa()+');

1750:
1751: l_rec_aa_status varchar2(30) := 'OK';
1752: l_other_aa_status varchar2(30) := 'OK';
1753: BEGIN
1754: arp_util.debug('arp_process_credit.line_rerun_aa()+');
1755:
1756: IF p_customer_trx_line_id IS NULL
1757: THEN
1758: BEGIN

Line 1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');

1823: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN
1824: p_status := l_other_aa_status;
1825: END IF;
1826:
1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

Line 1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');
1832: RAISE;
1833: END;
1834:
1835: /* Bug 3619804 */

Line 1870: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');

1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1867:
1868: BEGIN
1869:
1870: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');
1871:
1872: arp_ctl_pkg.set_to_dummy( l_line_rec );
1873: l_line_rec.autorule_complete_flag := 'N';
1874: l_line_rec.autorule_duration_processed := NULL;

Line 1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||

1878: p_customer_trx_id,
1879: 'LINE');
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN
1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1883: 'no child lines to update.');
1884: WHEN OTHERS THEN
1885: arp_util.debug('EXCEPTION: '||
1886: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1886: 'arp_process_credit.reverse_revrec_effect_cm()');

1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1883: 'no child lines to update.');
1884: WHEN OTHERS THEN
1885: arp_util.debug('EXCEPTION: '||
1886: 'arp_process_credit.reverse_revrec_effect_cm()');
1887: RAISE;
1888: END;
1889:
1890: BEGIN

Line 1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1897: 'N',
1898: NULL);
1899: EXCEPTION
1900: WHEN NO_DATA_FOUND THEN
1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1902: 'no dists to delete.');
1903: WHEN OTHERS THEN
1904: arp_util.debug('EXCEPTION: '||
1905: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1905: 'arp_process_credit.reverse_revrec_effect_cm()');

1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1902: 'no dists to delete.');
1903: WHEN OTHERS THEN
1904: arp_util.debug('EXCEPTION: '||
1905: 'arp_process_credit.reverse_revrec_effect_cm()');
1906: RAISE;
1907: END;
1908:
1909: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

Line 1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1914: 'Y',
1915: 'REC');
1916: EXCEPTION
1917: WHEN NO_DATA_FOUND THEN
1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1919: 'no dists to update.');
1920: WHEN OTHERS THEN
1921: arp_util.debug('EXCEPTION: '||
1922: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1922: 'arp_process_credit.reverse_revrec_effect_cm()');

1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1919: 'no dists to update.');
1920: WHEN OTHERS THEN
1921: arp_util.debug('EXCEPTION: '||
1922: 'arp_process_credit.reverse_revrec_effect_cm()');
1923: RAISE;
1924: END;
1925: EXCEPTION
1926: WHEN OTHERS THEN

Line 1928: 'arp_process_credit.reverse_revrec_effect_cm()');

1924: END;
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: arp_util.debug('EXCEPTION: '||
1928: 'arp_process_credit.reverse_revrec_effect_cm()');
1929: RAISE;
1930: END ;
1931:
1932:

Line 1975: arp_util.debug('arp_process_credit.set_header_flags()+');

1971: IS
1972: l_old_trx_rec ra_customer_trx%rowtype;
1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1974: BEGIN
1975: arp_util.debug('arp_process_credit.set_header_flags()+');
1976:
1977: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);
1978:
1979: p_old_trx_rec := l_old_trx_rec;

Line 2014: arp_util.debug('arp_process_credit.set_header_flags()-');

2010: ELSE
2011: p_complete_changed_flag := FALSE;
2012: END IF;
2013:
2014: arp_util.debug('arp_process_credit.set_header_flags()-');
2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

Line 2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

2014: arp_util.debug('arp_process_credit.set_header_flags()-');
2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2019: arp_util.debug('');
2020: RAISE;
2021: END;
2022:

Line 2142: arp_util.debug('arp_process_credit.update_header()+');

2138: trx.customer_trx_id,
2139: trx.org_id;
2140:
2141: BEGIN
2142: arp_util.debug('arp_process_credit.update_header()+');
2143:
2144: /*--------------------------------------------------------------+
2145: | check form version to determine IF it is compatible with the |
2146: | entity handler. |

Line 2442: arp_util.debug('arp_process_credit.update_header: '||

2438: null);
2439: END IF;
2440: EXCEPTION
2441: WHEN NO_DATA_FOUND THEN
2442: arp_util.debug('arp_process_credit.update_header: '||
2443: 'no distributions to update');
2444: WHEN OTHERS THEN
2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2446: arp_util.debug(' update gl_date');

Line 2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2441: WHEN NO_DATA_FOUND THEN
2442: arp_util.debug('arp_process_credit.update_header: '||
2443: 'no distributions to update');
2444: WHEN OTHERS THEN
2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2446: arp_util.debug(' update gl_date');
2447: RAISE;
2448: END;
2449: END IF;

Line 2553: arp_util.debug('arp_process_credit.update_header()-');

2549: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
2550:
2551: END IF;
2552: END IF; --bug 7193337
2553: arp_util.debug('arp_process_credit.update_header()-');
2554:
2555: EXCEPTION
2556:
2557: WHEN OTHERS THEN

Line 2558: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2554:
2555: EXCEPTION
2556:
2557: WHEN OTHERS THEN
2558: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2559:
2560: RAISE;
2561: END;
2562:

Line 2658: arp_util.debug('arp_process_credit.insert_line()+');

2654: l_mode varchar2(30);
2655:
2656: BEGIN
2657:
2658: arp_util.debug('arp_process_credit.insert_line()+');
2659:
2660: /*--------------------------------------------------------------+
2661: | check form version to determine IF it is compatible with the |
2662: | entity handler. |

Line 2746: arp_process_credit.validate_insert_line(l_credit_rec);

2742: l_credit_rec.global_attribute19:=p_credit_rec.global_attribute19;
2743: l_credit_rec.global_attribute20:=p_credit_rec.global_attribute20;
2744: END IF;
2745:
2746: arp_process_credit.validate_insert_line(l_credit_rec);
2747:
2748: -- call the table handler
2749: arp_ctl_pkg.insert_p(l_credit_rec, l_customer_trx_line_id);
2750:

Line 2922: arp_util.debug('arp_process_credit.insert_line()-');

2918: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
2919: p_status := l_cmm_status;
2920: END IF;
2921:
2922: arp_util.debug('arp_process_credit.insert_line()-');
2923:
2924: EXCEPTION
2925: when OTHERS THEN
2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

Line 2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

2922: arp_util.debug('arp_process_credit.insert_line()-');
2923:
2924: EXCEPTION
2925: when OTHERS THEN
2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');
2927: arp_ctl_pkg.display_line_rec(l_credit_rec);
2928: RAISE;
2929: END;
2930:

Line 3001: arp_util.debug('arp_process_credit.set_line_flags()+');

2997:
2998:
2999: BEGIN
3000:
3001: arp_util.debug('arp_process_credit.set_line_flags()+');
3002:
3003: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3004:
3005: arp_process_credit.get_cm_amounts(

Line 3005: arp_process_credit.get_cm_amounts(

3001: arp_util.debug('arp_process_credit.set_line_flags()+');
3002:
3003: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3004:
3005: arp_process_credit.get_cm_amounts(
3006: p_customer_trx_id,
3007: p_customer_trx_line_id,
3008: p_prev_ct_id,
3009: p_prev_ctl_id,

Line 3090: arp_util.debug('arp_process_credit.set_line_flags()-');

3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:
3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:
3092: EXCEPTION
3093: WHEN OTHERS THEN
3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

Line 3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:
3092: EXCEPTION
3093: WHEN OTHERS THEN
3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');
3095: RAISE;
3096: END;
3097:
3098: /*===========================================================================+

Line 3192: arp_util.debug('arp_process_credit.update_line()+');

3188: l_frt_status varchar2(30) := 'OK';
3189: l_recalculate_tax_flag BOOLEAN;
3190:
3191: BEGIN
3192: arp_util.debug('arp_process_credit.update_line()+');
3193:
3194: /*--------------------------------------------------------------+
3195: | check form version to determine IF it is compatible with the |
3196: | entity handler. |

Line 3211: arp_process_credit.validate_update_line;

3207: /*--------------------+
3208: | pre-update logic |
3209: +--------------------*/
3210:
3211: arp_process_credit.validate_update_line;
3212:
3213: BEGIN
3214:
3215:

Line 3238: arp_process_credit.set_line_flags(

3234: END;
3235:
3236:
3237:
3238: arp_process_credit.set_line_flags(
3239: p_credit_rec,
3240: p_customer_trx_id,
3241: p_customer_trx_line_id,
3242: p_prev_customer_trx_id,

Line 3272: arp_process_credit.get_uncredit_amounts(

3268: +--------------------*/
3269:
3270: IF (p_prev_customer_trx_id IS NOT NULL)
3271: THEN
3272: arp_process_credit.get_uncredit_amounts(
3273: p_customer_trx_id,
3274: p_customer_trx_line_id,
3275: p_prev_customer_trx_id,
3276: p_prev_customer_trx_line_id,

Line 3307: arp_process_credit.credit_freight(

3303: ELSE
3304: l_net_uncr_frt_amount := l_uncr_frt_amount;
3305: END IF;
3306:
3307: arp_process_credit.credit_freight(
3308: p_form_name,
3309: p_form_version,
3310: p_customer_trx_id,
3311: p_customer_trx_line_id,

Line 3359: arp_util.debug('arp_process_credit.update_line '||

3355: pg_base_precision,
3356: pg_base_min_acc_unit);
3357: EXCEPTION
3358: WHEN NO_DATA_FOUND THEN
3359: arp_util.debug('arp_process_credit.update_line '||
3360: 'no distributions updated');
3361: WHEN OTHERS THEN
3362: RAISE;
3363: END;

Line 3379: arp_util.debug('arp_process_credit.update_line()-');

3375: ELSIF (NVL(l_rerun_aa_status, 'OK') <> 'OK') THEN
3376: p_status := l_rerun_aa_status;
3377: END IF;
3378:
3379: arp_util.debug('arp_process_credit.update_line()-');
3380:
3381: EXCEPTION
3382: WHEN OTHERS THEN
3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

Line 3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

3379: arp_util.debug('arp_process_credit.update_line()-');
3380:
3381: EXCEPTION
3382: WHEN OTHERS THEN
3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');
3384: RAISE;
3385: END;
3386: /*===========================================================================+
3387: | PROCEDURE |

Line 3425: arp_util.debug('arp_process_credit.freight_post_update()+');

3421: l_rows_processed number;
3422: l_errorbuf varchar2(200);
3423: l_result number;
3424: BEGIN
3425: arp_util.debug('arp_process_credit.freight_post_update()+');
3426:
3427: -- replace this with the call to the CREDIT MEMO procedure
3428: -- update the distribution record
3429:

Line 3458: arp_util.debug('arp_process_credit.freight_post_update()-');

3454: RAISE;
3455: END;
3456:
3457:
3458: arp_util.debug('arp_process_credit.freight_post_update()-');
3459:
3460: EXCEPTION
3461:
3462: WHEN OTHERS THEN

Line 3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');

3459:
3460: EXCEPTION
3461:
3462: WHEN OTHERS THEN
3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3464:
3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3467: arp_util.debug('p_gl_date : '||p_gl_date);

Line 3490: arp_util.debug('EXCEPTION: arp_process_credit.initialization');

3486: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
3487:
3488: EXCEPTION
3489: WHEN OTHERS THEN
3490: arp_util.debug('EXCEPTION: arp_process_credit.initialization');
3491: RAISE;
3492: END init;
3493:
3494: BEGIN

Line 3496: END ARP_PROCESS_CREDIT;

3492: END init;
3493:
3494: BEGIN
3495: init;
3496: END ARP_PROCESS_CREDIT;