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_ETAX_UTIL dependencies on ARP_UTIL

Line 1530: arp_util.debug('arp_etax_util.prorate_accounting()+');

1526:
1527:
1528: BEGIN
1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);

Line 1531: arp_util.debug(' p_mode = ' || p_mode);

1527:
1528: BEGIN
1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);

Line 1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);

1528: BEGIN
1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1536: END IF;

Line 1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);

1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1536: END IF;
1537:

Line 1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);

1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1536: END IF;
1537:
1538:

Line 1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);

1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1535: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1536: END IF;
1537:
1538:
1539: -- Added for Line Level Adjustment

Line 1554: arp_util.debug(' local mode = ' || l_mode);

1550: l_mode := 'UNEDISC';
1551: END IF;
1552:
1553: IF PG_DEBUG in ('Y','C') THEN
1554: arp_util.debug(' local mode = ' || l_mode);
1555: END IF;
1556:
1557: IF NVL(p_gt_id,0) = 0
1558: THEN

Line 1574: arp_util.debug('l_gt_id = ' || l_gt_id);

1570: l_gt_id := p_gt_id;
1571: END IF;
1572:
1573: IF PG_DEBUG in ('Y','C') THEN
1574: arp_util.debug('l_gt_id = ' || l_gt_id);
1575: END IF;
1576:
1577: /* Insert tax lines into _GT table for processing */
1578:

Line 1628: arp_util.debug('tax lines inserted = ' || l_rows_inserted);

1624: AND tl.tax_line_id = zx.adjusted_doc_tax_line_id);
1625:
1626: l_rows_inserted := SQL%ROWCOUNT;
1627:
1628: arp_util.debug('tax lines inserted = ' || l_rows_inserted);
1629:
1630: /* Only insert LINEs if it is not a tax-only adj */
1631: IF p_mode <> 'TAX'
1632: THEN

Line 1675: arp_util.debug('Total line and tax rows inserted = ' ||

1671: GROUP BY zx.trx_id, zx.adjusted_doc_line_id,
1672: il.customer_trx_id, il.customer_trx_line_id);
1673:
1674: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
1675: arp_util.debug('Total line and tax rows inserted = ' ||
1676: l_rows_inserted);
1677:
1678: END IF;
1679:

Line 1702: arp_util.debug(d.customer_trx_id || '~' ||

1698: because the GT table was doing some strange things
1699: in the early days of SLA */
1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: FOR d IN debug_gt LOOP
1702: arp_util.debug(d.customer_trx_id || '~' ||
1703: d.customer_trx_line_id || '~' ||
1704: d.line_type || ' line=' ||
1705: d.line_amount || ' ed_line=' ||
1706: d.ed_line_amount || ' uned_line=' ||

Line 1751: arp_util.debug('Discount accounting skipped');

1747: THEN
1748: /* Call arp_det_dist_pkg later by
1749: calling distribute_recoverable */
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('Discount accounting skipped');
1752: arp_util.debug(' see distribute_recoverable later in log');
1753: END IF;
1754:
1755: ELSE

Line 1752: arp_util.debug(' see distribute_recoverable later in log');

1748: /* Call arp_det_dist_pkg later by
1749: calling distribute_recoverable */
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('Discount accounting skipped');
1752: arp_util.debug(' see distribute_recoverable later in log');
1753: END IF;
1754:
1755: ELSE
1756: arp_util.debug('EXCEPTION: Invalid mode. ' || l_mode);

Line 1756: arp_util.debug('EXCEPTION: Invalid mode. ' || l_mode);

1752: arp_util.debug(' see distribute_recoverable later in log');
1753: END IF;
1754:
1755: ELSE
1756: arp_util.debug('EXCEPTION: Invalid mode. ' || l_mode);
1757: p_gt_id := 0;
1758: RETURN;
1759: END IF;
1760:

Line 1786: arp_util.debug('arp_etax_util.prorate_accounting()-');

1782: END IF;
1783: END IF;
1784:
1785: IF PG_DEBUG in ('Y', 'C') THEN
1786: arp_util.debug('arp_etax_util.prorate_accounting()-');
1787: END IF;
1788:
1789: END prorate_accounting;
1790:

Line 1805: arp_util.debug('arp_etax_util.distribute_recoverable()+');

1801: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1802:
1803: BEGIN
1804: IF PG_DEBUG in ('Y', 'C') THEN
1805: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1806: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1807: END IF;
1808:
1809: SELECT *

Line 1806: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);

1802:
1803: BEGIN
1804: IF PG_DEBUG in ('Y', 'C') THEN
1805: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1806: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1807: END IF;
1808:
1809: SELECT *
1810: INTO l_app_rec

Line 1863: arp_util.debug('arp_etax_util.distribute_recoverable()-');

1859: END IF;
1860: END IF;
1861:
1862: IF PG_DEBUG in ('Y', 'C') THEN
1863: arp_util.debug('arp_etax_util.distribute_recoverable()-');
1864: END IF;
1865:
1866: END distribute_recoverable;
1867:

Line 1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');

1887: l_orig_tax_adj NUMBER := 0;
1888: l_ps_update_needed BOOLEAN := TRUE;
1889: BEGIN
1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1895: END IF;

Line 1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);

1888: l_ps_update_needed BOOLEAN := TRUE;
1889: BEGIN
1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1895: END IF;
1896:

Line 1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);

1889: BEGIN
1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1895: END IF;
1896:
1897: IF p_upd_adj_and_ps in ('Y','A')

Line 1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);

1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1895: END IF;
1896:
1897: IF p_upd_adj_and_ps in ('Y','A')
1898: THEN

Line 1925: arp_util.debug(' orig and prorate amts same, skip update(s)');

1921: PS update */
1922: l_ps_update_needed := FALSE;
1923:
1924: IF PG_DEBUG in ('Y', 'C') THEN
1925: arp_util.debug(' orig and prorate amts same, skip update(s)');
1926: END IF;
1927: END IF;
1928: END IF;
1929:

Line 1944: arp_util.debug('from adj record ');

1940: INTO l_adj_rec
1941: FROM ar_adjustments
1942: WHERE adjustment_id = p_adj_id;
1943:
1944: arp_util.debug('from adj record ');
1945: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1946: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1947:
1948:

Line 1945: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);

1941: FROM ar_adjustments
1942: WHERE adjustment_id = p_adj_id;
1943:
1944: arp_util.debug('from adj record ');
1945: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1946: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1947:
1948:
1949: /* Incorporate the original adj line and tax amounts.

Line 1946: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);

1942: WHERE adjustment_id = p_adj_id;
1943:
1944: arp_util.debug('from adj record ');
1945: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1946: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1947:
1948:
1949: /* Incorporate the original adj line and tax amounts.
1950: These columns are zero if the adjustment was not changed

Line 1972: arp_util.debug('arp_etax_util.update_adj_and_ps()-');

1968:
1969: END IF;
1970:
1971: IF PG_DEBUG in ('Y', 'C') THEN
1972: arp_util.debug('arp_etax_util.update_adj_and_ps()-');
1973: END IF;
1974: END update_adj_and_ps;
1975:
1976: /* 5677984 redirected original prorate_recoverable to the new

Line 2790: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||

2786: /* switch sign of tax_amt (discounts are normally positive
2787: but pos is reflected as negative in etax) */
2788:
2789: IF PG_DEBUG in ('Y', 'C') THEN
2790: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||
2791: ' t_prorated_amt =' || t_prorated_amt(c_tax_lines.adjusted_doc_line_id) ||
2792: ' zx.tax =' || c_tax_lines.tax_amt);
2793: END IF;
2794:

Line 2808: arp_util.debug('before swap: ' || c_tax_lines.adjusted_doc_line_id ||

2804: last_update_date = sysdate
2805: WHERE customer_trx_line_id = c_tax_lines.adjusted_doc_line_id;
2806:
2807: IF PG_DEBUG in ('Y', 'C') THEN
2808: arp_util.debug('before swap: ' || c_tax_lines.adjusted_doc_line_id ||
2809: ' line=' || l_prorated_line ||
2810: ' tax=' || l_prorated_tax);
2811: END IF;
2812:

Line 2829: arp_util.debug('after swap: ' || c_tax_lines.adjusted_doc_line_id ||

2825: p_prorated_tax := p_prorated_tax + l_prorated_tax;
2826: p_prorated_line := p_prorated_line + l_prorated_line;
2827:
2828: IF PG_DEBUG in ('Y', 'C') THEN
2829: arp_util.debug('after swap: ' || c_tax_lines.adjusted_doc_line_id ||
2830: ' line=' || l_prorated_line ||
2831: ' tax=' || l_prorated_tax);
2832: END IF;
2833:

Line 2838: arp_util.debug('initializing prorated_line to adj amt');

2834: END LOOP;
2835:
2836: IF l_lines_processed = FALSE
2837: THEN
2838: arp_util.debug('initializing prorated_line to adj amt');
2839:
2840: /* initalize the outbound parameters as LINE=amt, TAX=0
2841: In a situation where etax does nothing, then we should
2842: act as if there was no tax in our proration logic. */

Line 2873: arp_util.debug(' prorate_recoverable called in quote mode');

2869: p_target_line_id);
2870:
2871: ELSE
2872: IF PG_DEBUG in ('Y', 'C') THEN
2873: arp_util.debug(' prorate_recoverable called in quote mode');
2874: END IF;
2875:
2876: /* p_quote = Y -- so this is quote logic */
2877: FOR c_tax_lines IN est_tax_lines(l_transaction_rec.entity_code,

Line 2889: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||

2885: /* switch sign of tax_amt (discounts are normally positive
2886: but pos is reflected as negative in etax) */
2887:
2888: IF PG_DEBUG in ('Y', 'C') THEN
2889: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||
2890: ' t_prorated_amt =' || t_prorated_amt(c_tax_lines.adjusted_doc_line_id) ||
2891: ' zx.tax =' || c_tax_lines.tax_amt);
2892: END IF;
2893: