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.29 2011/05/10 12:51:54 dgaurab ship $ */
3:
4: pg_number_dummy number;
5: pg_date_dummy date;

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

63: IS
64: l_line_salesrep_flag NUMBER := 0;
65: BEGIN
66:
67: arp_util.debug('arp_process_credit.create_salescredits()+');
68:
69: --Bug 12376682
70: SELECT count(*)
71: INTO l_line_salesrep_flag

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

119: p_currency_code);
120: END IF;
121: END IF;
122:
123: arp_util.debug('arp_process_credit.create_salescredits()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

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

123: arp_util.debug('arp_process_credit.create_salescredits()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

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

188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
189: l_frt_rec ra_customer_trx_lines%rowtype;
190: BEGIN
191:
192: arp_util.debug('arp_process_credit.credit_freight()+');
193:
194: IF ( p_prev_ct_id IS NULL)
195: OR
196: ( p_prev_ct_id IS NOT NULL

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

313: 'FREIGHT');
314: END IF;
315: END IF;
316:
317: arp_util.debug('arp_process_credit.credit_freight()-');
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

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

317: arp_util.debug('arp_process_credit.credit_freight()-');
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

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

367: IS
368: l_cr_txn_rec ra_customer_trx%rowtype;
369: BEGIN
370:
371: arp_util.debug('arp_process_credit.default_credit_header()+');
372:
373: p_new_cm_rec := p_cm_rec;
374: p_new_cm_rec.previous_customer_trx_id := p_prev_customer_trx_id;
375: p_new_cm_rec.complete_flag := 'N';

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

416: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
417:
418: END IF;
419:
420: arp_util.debug('arp_process_credit.default_credit_header()-');
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

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

420: arp_util.debug('arp_process_credit.default_credit_header()-');
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');
425: RAISE;
426: END;
427:
428: /*===========================================================================+

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

450: +===========================================================================*/
451: PROCEDURE validate_insert_header
452: IS
453: BEGIN
454: arp_util.debug('arp_process_credit.validate_insert_header()+');
455:
456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION

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

452: IS
453: BEGIN
454: arp_util.debug('arp_process_credit.validate_insert_header()+');
455:
456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

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

456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');
461: RAISE;
462:
463: END;
464:

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

488: +===========================================================================*/
489: PROCEDURE validate_update_header
490: IS
491: BEGIN
492: arp_util.debug('arp_process_credit.validate_update_header()+');
493:
494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION

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

490: IS
491: BEGIN
492: arp_util.debug('arp_process_credit.validate_update_header()+');
493:
494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

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

494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');
499: RAISE;
500:
501: END;
502:

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

529: PROCEDURE validate_insert_line(
530: p_line_rec IN ra_customer_trx_lines%rowtype)
531: IS
532: BEGIN
533: arp_util.debug('arp_process_credit.validate_insert_line()+');
534:
535: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
536: p_line_rec.customer_trx_id,
537: p_line_rec.customer_trx_line_id);

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

535: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
536: p_line_rec.customer_trx_id,
537: p_line_rec.customer_trx_line_id);
538:
539: arp_util.debug('arp_process_credit.validate_insert_line()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

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

539: arp_util.debug('arp_process_credit.validate_insert_line()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');
544: RAISE;
545:
546: END;
547:

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

570: +===========================================================================*/
571: PROCEDURE validate_update_line
572: IS
573: BEGIN
574: arp_util.debug('arp_process_credit.validate_update_line()+');
575:
576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION

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

572: IS
573: BEGIN
574: arp_util.debug('arp_process_credit.validate_update_line()+');
575:
576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

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

576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');
581: RAISE;
582:
583: END;
584:

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

624: l_trx_rec ra_customer_trx%rowtype;
625: l_calc_unit_price VARCHAR2(1); --2880106
626: BEGIN
627:
628: arp_util.debug('arp_process_credit.default_credit_line()+');
629:
630: p_new_cm_line := p_cm_line;
631: p_new_cm_line.customer_trx_id := p_customer_trx_id;
632: p_new_cm_line.extended_amount := p_line_amount;

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

792: p_new_cm_line.ship_to_contact_id := l_cr_txn_line.ship_to_contact_id;
793:
794: END IF;
795:
796: arp_util.debug('arp_process_credit.default_credit_line()-');
797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

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

796: arp_util.debug('arp_process_credit.default_credit_line()-');
797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');
801: RAISE;
802:
803: END;
804:

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

824: l_freight_line_count number;
825:
826: BEGIN
827:
828: arp_util.debug('arp_process_credit.get_cm_amounts()+');
829:
830: IF (p_customer_trx_id IS NOT NULL)
831: THEN
832:

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

891: END IF;
892:
893: END IF;
894:
895: arp_util.debug('arp_process_credit.get_cm_amounts()-');
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

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

895: arp_util.debug('arp_process_credit.get_cm_amounts()-');
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');
900:
901: RAISE;
902:
903: END;

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

951: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
952:
953: BEGIN
954:
955: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');
956:
957: SELECT sum(nra.net_amount),
958: count(nra.customer_trx_line_id),
959: max(decode(p_prev_ctl_id,

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

1022: p_freight_type := l_freight_type;
1023: p_freight_ctl_id := l_freight_ctl_id;
1024: END IF;
1025:
1026: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

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

1026: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');
1031: RAISE;
1032: END;
1033:
1034:

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

1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN
1080:
1081: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1082:
1083: SELECT sum(decode(
1084: decode(nra.line_type,
1085: 'CB', 'LINE',

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

1159: l_freight_balance_due;
1160: END IF;
1161: END IF;
1162:
1163: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

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

1163: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1168: arp_util.debug('');
1169:
1170: RAISE;
1171:

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

1254: l_tax_status varchar2(30) := 'OK';
1255: l_frt_status varchar2(30) := 'OK';
1256: BEGIN
1257:
1258: arp_util.debug('arp_process_credit.derive_credit_information()+');
1259:
1260: IF (nvl(pg_num_credit_lines, 0) > 0)
1261: THEN
1262:

Line 1292: arp_process_credit.insert_line(

1288: l_tax_amount := -1 * l_total_uncr_tax_amount;
1289:
1290: l_line_status := 'OK';
1291:
1292: arp_process_credit.insert_line(
1293: p_form_name,
1294: p_form_version,
1295: l_line_rec,
1296: -1 * l_total_uncr_line_amount,

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

1464: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
1465: p_status := l_cmm_status;
1466: END IF;
1467:
1468: arp_util.debug('arp_process_credit.derive_credit_information()-');
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: arp_util.debug('EXCEPTION: derive_credit_information');

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

1552: l_ev_rec arp_xla_events.xla_events_type;
1553:
1554: BEGIN
1555:
1556: arp_util.debug('arp_process_credit.insert_header()+');
1557:
1558: /*--------------------------------------------------------------+
1559: | check form version to determine IF it is compatible with the |
1560: | entity handler. |

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

1675: IF l_df_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1676: p_status := 'eTAX_ERROR';
1677: END IF;
1678:
1679: arp_util.debug('arp_process_credit.insert_header()-');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

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

1679: arp_util.debug('arp_process_credit.insert_header()-');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');
1684: RAISE;
1685: END;
1686:
1687: /*===========================================================================+

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

1718: p_trx_number_change_flag IN boolean)
1719: IS
1720: BEGIN
1721:
1722: arp_util.debug('arp_process_credit.delete_cm_records()+');
1723:
1724: /*-----------------------+
1725: | delete sales credits |
1726: +-----------------------*/

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

1751: | delete line records |
1752: +---------------------*/
1753: arp_ctl_pkg.delete_f_ct_id(p_customer_trx_id);
1754:
1755: arp_util.debug('arp_process_credit.delete_cm_records()-');
1756:
1757: EXCEPTION
1758:
1759: WHEN OTHERS THEN

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

1756:
1757: EXCEPTION
1758:
1759: WHEN OTHERS THEN
1760: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1761: arp_util.debug('');
1762: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1763:
1764: RAISE;

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

1780:
1781: l_rec_aa_status varchar2(30) := 'OK';
1782: l_other_aa_status varchar2(30) := 'OK';
1783: BEGIN
1784: arp_util.debug('arp_process_credit.line_rerun_aa()+');
1785:
1786: IF p_customer_trx_line_id IS NULL
1787: THEN
1788: BEGIN

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

1853: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN
1854: p_status := l_other_aa_status;
1855: END IF;
1856:
1857: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

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

1857: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');
1862: RAISE;
1863: END;
1864:
1865: /* Bug 3619804 */

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

1896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1897:
1898: BEGIN
1899:
1900: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');
1901:
1902: arp_ctl_pkg.set_to_dummy( l_line_rec );
1903: l_line_rec.autorule_complete_flag := 'N';
1904: l_line_rec.autorule_duration_processed := NULL;

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

1908: p_customer_trx_id,
1909: 'LINE');
1910: EXCEPTION
1911: WHEN NO_DATA_FOUND THEN
1912: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1913: 'no child lines to update.');
1914: WHEN OTHERS THEN
1915: arp_util.debug('EXCEPTION: '||
1916: 'arp_process_credit.reverse_revrec_effect_cm()');

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

1912: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1913: 'no child lines to update.');
1914: WHEN OTHERS THEN
1915: arp_util.debug('EXCEPTION: '||
1916: 'arp_process_credit.reverse_revrec_effect_cm()');
1917: RAISE;
1918: END;
1919:
1920: BEGIN

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

1927: 'N',
1928: NULL);
1929: EXCEPTION
1930: WHEN NO_DATA_FOUND THEN
1931: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1932: 'no dists to delete.');
1933: WHEN OTHERS THEN
1934: arp_util.debug('EXCEPTION: '||
1935: 'arp_process_credit.reverse_revrec_effect_cm()');

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

1931: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1932: 'no dists to delete.');
1933: WHEN OTHERS THEN
1934: arp_util.debug('EXCEPTION: '||
1935: 'arp_process_credit.reverse_revrec_effect_cm()');
1936: RAISE;
1937: END;
1938:
1939: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

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

1944: 'Y',
1945: 'REC');
1946: EXCEPTION
1947: WHEN NO_DATA_FOUND THEN
1948: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1949: 'no dists to update.');
1950: WHEN OTHERS THEN
1951: arp_util.debug('EXCEPTION: '||
1952: 'arp_process_credit.reverse_revrec_effect_cm()');

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

1948: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1949: 'no dists to update.');
1950: WHEN OTHERS THEN
1951: arp_util.debug('EXCEPTION: '||
1952: 'arp_process_credit.reverse_revrec_effect_cm()');
1953: RAISE;
1954: END;
1955: EXCEPTION
1956: WHEN OTHERS THEN

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

1954: END;
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: arp_util.debug('EXCEPTION: '||
1958: 'arp_process_credit.reverse_revrec_effect_cm()');
1959: RAISE;
1960: END ;
1961:
1962:

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

2001: IS
2002: l_old_trx_rec ra_customer_trx%rowtype;
2003: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2004: BEGIN
2005: arp_util.debug('arp_process_credit.set_header_flags()+');
2006:
2007: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);
2008:
2009: p_old_trx_rec := l_old_trx_rec;

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

2040: ELSE
2041: p_complete_changed_flag := FALSE;
2042: END IF;
2043:
2044: arp_util.debug('arp_process_credit.set_header_flags()-');
2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

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

2044: arp_util.debug('arp_process_credit.set_header_flags()-');
2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2049: arp_util.debug('');
2050: RAISE;
2051: END;
2052:

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

2168: trx.customer_trx_id,
2169: trx.org_id;
2170:
2171: BEGIN
2172: arp_util.debug('arp_process_credit.update_header()+');
2173:
2174: /*--------------------------------------------------------------+
2175: | check form version to determine IF it is compatible with the |
2176: | entity handler. |

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

2468: null);
2469: END IF;
2470: EXCEPTION
2471: WHEN NO_DATA_FOUND THEN
2472: arp_util.debug('arp_process_credit.update_header: '||
2473: 'no distributions to update');
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2476: arp_util.debug(' update gl_date');

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

2471: WHEN NO_DATA_FOUND THEN
2472: arp_util.debug('arp_process_credit.update_header: '||
2473: 'no distributions to update');
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2476: arp_util.debug(' update gl_date');
2477: RAISE;
2478: END;
2479: END IF;

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

2579: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
2580:
2581: END IF;
2582: END IF; --bug 7193337
2583: arp_util.debug('arp_process_credit.update_header()-');
2584:
2585: EXCEPTION
2586:
2587: WHEN OTHERS THEN

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

2584:
2585: EXCEPTION
2586:
2587: WHEN OTHERS THEN
2588: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2589:
2590: RAISE;
2591: END;
2592:

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

2684: l_mode varchar2(30);
2685:
2686: BEGIN
2687:
2688: arp_util.debug('arp_process_credit.insert_line()+');
2689:
2690: /*--------------------------------------------------------------+
2691: | check form version to determine IF it is compatible with the |
2692: | entity handler. |

Line 2776: arp_process_credit.validate_insert_line(l_credit_rec);

2772: l_credit_rec.global_attribute19:=p_credit_rec.global_attribute19;
2773: l_credit_rec.global_attribute20:=p_credit_rec.global_attribute20;
2774: END IF;
2775:
2776: arp_process_credit.validate_insert_line(l_credit_rec);
2777:
2778: -- call the table handler
2779: arp_ctl_pkg.insert_p(l_credit_rec, l_customer_trx_line_id);
2780:

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

2958: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
2959: p_status := l_cmm_status;
2960: END IF;
2961:
2962: arp_util.debug('arp_process_credit.insert_line()-');
2963:
2964: EXCEPTION
2965: when OTHERS THEN
2966: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

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

2962: arp_util.debug('arp_process_credit.insert_line()-');
2963:
2964: EXCEPTION
2965: when OTHERS THEN
2966: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');
2967: arp_ctl_pkg.display_line_rec(l_credit_rec);
2968: RAISE;
2969: END;
2970:

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

3037:
3038:
3039: BEGIN
3040:
3041: arp_util.debug('arp_process_credit.set_line_flags()+');
3042:
3043: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3044:
3045: arp_process_credit.get_cm_amounts(

Line 3045: arp_process_credit.get_cm_amounts(

3041: arp_util.debug('arp_process_credit.set_line_flags()+');
3042:
3043: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3044:
3045: arp_process_credit.get_cm_amounts(
3046: p_customer_trx_id,
3047: p_customer_trx_line_id,
3048: p_prev_ct_id,
3049: p_prev_ctl_id,

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

3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:
3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

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

3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');
3135: RAISE;
3136: END;
3137:
3138: /*===========================================================================+

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

3228: l_frt_status varchar2(30) := 'OK';
3229: l_recalculate_tax_flag BOOLEAN;
3230:
3231: BEGIN
3232: arp_util.debug('arp_process_credit.update_line()+');
3233:
3234: /*--------------------------------------------------------------+
3235: | check form version to determine IF it is compatible with the |
3236: | entity handler. |

Line 3251: arp_process_credit.validate_update_line;

3247: /*--------------------+
3248: | pre-update logic |
3249: +--------------------*/
3250:
3251: arp_process_credit.validate_update_line;
3252:
3253: BEGIN
3254:
3255:

Line 3278: arp_process_credit.set_line_flags(

3274: END;
3275:
3276:
3277:
3278: arp_process_credit.set_line_flags(
3279: p_credit_rec,
3280: p_customer_trx_id,
3281: p_customer_trx_line_id,
3282: p_prev_customer_trx_id,

Line 3312: arp_process_credit.get_uncredit_amounts(

3308: +--------------------*/
3309:
3310: IF (p_prev_customer_trx_id IS NOT NULL)
3311: THEN
3312: arp_process_credit.get_uncredit_amounts(
3313: p_customer_trx_id,
3314: p_customer_trx_line_id,
3315: p_prev_customer_trx_id,
3316: p_prev_customer_trx_line_id,

Line 3347: arp_process_credit.credit_freight(

3343: ELSE
3344: l_net_uncr_frt_amount := l_uncr_frt_amount;
3345: END IF;
3346:
3347: arp_process_credit.credit_freight(
3348: p_form_name,
3349: p_form_version,
3350: p_customer_trx_id,
3351: p_customer_trx_line_id,

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

3395: pg_base_precision,
3396: pg_base_min_acc_unit);
3397: EXCEPTION
3398: WHEN NO_DATA_FOUND THEN
3399: arp_util.debug('arp_process_credit.update_line '||
3400: 'no distributions updated');
3401: WHEN OTHERS THEN
3402: RAISE;
3403: END;

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

3415: ELSIF (NVL(l_rerun_aa_status, 'OK') <> 'OK') THEN
3416: p_status := l_rerun_aa_status;
3417: END IF;
3418:
3419: arp_util.debug('arp_process_credit.update_line()-');
3420:
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

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

3419: arp_util.debug('arp_process_credit.update_line()-');
3420:
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: arp_util.debug('EXCEPTION: arp_process_credit.update_line');
3424: RAISE;
3425: END;
3426: /*===========================================================================+
3427: | PROCEDURE |

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

3461: l_rows_processed number;
3462: l_errorbuf varchar2(200);
3463: l_result number;
3464: BEGIN
3465: arp_util.debug('arp_process_credit.freight_post_update()+');
3466:
3467: -- replace this with the call to the CREDIT MEMO procedure
3468: -- update the distribution record
3469:

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

3494: RAISE;
3495: END;
3496:
3497:
3498: arp_util.debug('arp_process_credit.freight_post_update()-');
3499:
3500: EXCEPTION
3501:
3502: WHEN OTHERS THEN

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

3499:
3500: EXCEPTION
3501:
3502: WHEN OTHERS THEN
3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3504:
3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3507: arp_util.debug('p_gl_date : '||p_gl_date);

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

3526: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
3527:
3528: EXCEPTION
3529: WHEN OTHERS THEN
3530: arp_util.debug('EXCEPTION: arp_process_credit.initialization');
3531: RAISE;
3532: END init;
3533:
3534: BEGIN

Line 3536: END ARP_PROCESS_CREDIT;

3532: END init;
3533:
3534: BEGIN
3535: init;
3536: END ARP_PROCESS_CREDIT;