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 1466: arp_util.debug('arp_etax_util.prorate_accounting()+');

1462:
1463:
1464: BEGIN
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);

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

1463:
1464: BEGIN
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1471: arp_util.debug(' p_target_line_id = ' || p_target_line_id);

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

1464: BEGIN
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1471: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1472: END IF;

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

1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1471: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1472: END IF;
1473:

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

1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1471: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1472: END IF;
1473:
1474:

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

1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);
1471: arp_util.debug(' p_target_line_id = ' || p_target_line_id);
1472: END IF;
1473:
1474:
1475: -- Added for Line Level Adjustment

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

1486: l_mode := 'UNEDISC';
1487: END IF;
1488:
1489: IF PG_DEBUG in ('Y','C') THEN
1490: arp_util.debug(' local mode = ' || l_mode);
1491: END IF;
1492:
1493: IF NVL(p_gt_id,0) = 0
1494: THEN

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

1506: l_gt_id := p_gt_id;
1507: END IF;
1508:
1509: IF PG_DEBUG in ('Y','C') THEN
1510: arp_util.debug('l_gt_id = ' || l_gt_id);
1511: END IF;
1512:
1513: /* Insert tax lines into _GT table for processing */
1514:

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

1560: AND tl.tax_line_id = zx.adjusted_doc_tax_line_id);
1561:
1562: l_rows_inserted := SQL%ROWCOUNT;
1563:
1564: arp_util.debug('tax lines inserted = ' || l_rows_inserted);
1565:
1566: /* Only insert LINEs if it is not a tax-only adj */
1567: IF p_mode <> 'TAX'
1568: THEN

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

1607: GROUP BY zx.trx_id, zx.adjusted_doc_line_id,
1608: il.customer_trx_id, il.customer_trx_line_id);
1609:
1610: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
1611: arp_util.debug('Total line and tax rows inserted = ' ||
1612: l_rows_inserted);
1613:
1614: END IF;
1615:

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

1634: because the GT table was doing some strange things
1635: in the early days of SLA */
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: FOR d IN debug_gt LOOP
1638: arp_util.debug(d.customer_trx_id || '~' ||
1639: d.customer_trx_line_id || '~' ||
1640: d.line_type || ' line=' ||
1641: d.line_amount || ' ed_line=' ||
1642: d.ed_line_amount || ' uned_line=' ||

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

1683: THEN
1684: /* Call arp_det_dist_pkg later by
1685: calling distribute_recoverable */
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('Discount accounting skipped');
1688: arp_util.debug(' see distribute_recoverable later in log');
1689: END IF;
1690:
1691: ELSE

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

1684: /* Call arp_det_dist_pkg later by
1685: calling distribute_recoverable */
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('Discount accounting skipped');
1688: arp_util.debug(' see distribute_recoverable later in log');
1689: END IF;
1690:
1691: ELSE
1692: arp_util.debug('EXCEPTION: Invalid mode. ' || l_mode);

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

1688: arp_util.debug(' see distribute_recoverable later in log');
1689: END IF;
1690:
1691: ELSE
1692: arp_util.debug('EXCEPTION: Invalid mode. ' || l_mode);
1693: p_gt_id := 0;
1694: RETURN;
1695: END IF;
1696:

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

1718: END IF;
1719: END IF;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_util.debug('arp_etax_util.prorate_accounting()-');
1723: END IF;
1724:
1725: END prorate_accounting;
1726:

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

1737: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1738:
1739: BEGIN
1740: IF PG_DEBUG in ('Y', 'C') THEN
1741: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1742: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1743: END IF;
1744:
1745: SELECT *

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

1738:
1739: BEGIN
1740: IF PG_DEBUG in ('Y', 'C') THEN
1741: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1742: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1743: END IF;
1744:
1745: SELECT *
1746: INTO l_app_rec

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

1795: END IF;
1796: END IF;
1797:
1798: IF PG_DEBUG in ('Y', 'C') THEN
1799: arp_util.debug('arp_etax_util.distribute_recoverable()-');
1800: END IF;
1801:
1802: END distribute_recoverable;
1803:

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

1823: l_orig_tax_adj NUMBER := 0;
1824: l_ps_update_needed BOOLEAN := TRUE;
1825: BEGIN
1826: IF PG_DEBUG in ('Y', 'C') THEN
1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1828: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1829: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1830: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1831: END IF;

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

1824: l_ps_update_needed BOOLEAN := TRUE;
1825: BEGIN
1826: IF PG_DEBUG in ('Y', 'C') THEN
1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1828: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1829: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1830: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1831: END IF;
1832:

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

1825: BEGIN
1826: IF PG_DEBUG in ('Y', 'C') THEN
1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1828: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1829: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1830: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1831: END IF;
1832:
1833: IF p_upd_adj_and_ps in ('Y','A')

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

1826: IF PG_DEBUG in ('Y', 'C') THEN
1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1828: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1829: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1830: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1831: END IF;
1832:
1833: IF p_upd_adj_and_ps in ('Y','A')
1834: THEN

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

1857: PS update */
1858: l_ps_update_needed := FALSE;
1859:
1860: IF PG_DEBUG in ('Y', 'C') THEN
1861: arp_util.debug(' orig and prorate amts same, skip update(s)');
1862: END IF;
1863: END IF;
1864: END IF;
1865:

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

1876: INTO l_adj_rec
1877: FROM ar_adjustments
1878: WHERE adjustment_id = p_adj_id;
1879:
1880: arp_util.debug('from adj record ');
1881: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1882: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1883:
1884:

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

1877: FROM ar_adjustments
1878: WHERE adjustment_id = p_adj_id;
1879:
1880: arp_util.debug('from adj record ');
1881: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1882: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1883:
1884:
1885: /* Incorporate the original adj line and tax amounts.

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

1878: WHERE adjustment_id = p_adj_id;
1879:
1880: arp_util.debug('from adj record ');
1881: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);
1882: arp_util.debug(' tax adjusted = ' || l_adj_rec.tax_adjusted);
1883:
1884:
1885: /* Incorporate the original adj line and tax amounts.
1886: These columns are zero if the adjustment was not changed

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

1904:
1905: END IF;
1906:
1907: IF PG_DEBUG in ('Y', 'C') THEN
1908: arp_util.debug('arp_etax_util.update_adj_and_ps()-');
1909: END IF;
1910: END update_adj_and_ps;
1911:
1912: /* 5677984 redirected original prorate_recoverable to the new

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

2729: /* switch sign of tax_amt (discounts are normally positive
2730: but pos is reflected as negative in etax) */
2731:
2732: IF PG_DEBUG in ('Y', 'C') THEN
2733: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||
2734: ' t_prorated_amt =' || t_prorated_amt(c_tax_lines.adjusted_doc_line_id) ||
2735: ' zx.tax =' || c_tax_lines.tax_amt);
2736: END IF;
2737:

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

2747: last_update_date = sysdate
2748: WHERE customer_trx_line_id = c_tax_lines.adjusted_doc_line_id;
2749:
2750: IF PG_DEBUG in ('Y', 'C') THEN
2751: arp_util.debug('before swap: ' || c_tax_lines.adjusted_doc_line_id ||
2752: ' line=' || l_prorated_line ||
2753: ' tax=' || l_prorated_tax);
2754: END IF;
2755:

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

2768: p_prorated_tax := p_prorated_tax + l_prorated_tax;
2769: p_prorated_line := p_prorated_line + l_prorated_line;
2770:
2771: IF PG_DEBUG in ('Y', 'C') THEN
2772: arp_util.debug('after swap: ' || c_tax_lines.adjusted_doc_line_id ||
2773: ' line=' || l_prorated_line ||
2774: ' tax=' || l_prorated_tax);
2775: END IF;
2776:

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

2777: END LOOP;
2778:
2779: IF l_lines_processed = FALSE
2780: THEN
2781: arp_util.debug('initializing prorated_line to adj amt');
2782:
2783: /* initalize the outbound parameters as LINE=amt, TAX=0
2784: In a situation where etax does nothing, then we should
2785: act as if there was no tax in our proration logic. */

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

2812: p_target_line_id);
2813:
2814: ELSE
2815: IF PG_DEBUG in ('Y', 'C') THEN
2816: arp_util.debug(' prorate_recoverable called in quote mode');
2817: END IF;
2818:
2819: /* p_quote = Y -- so this is quote logic */
2820: FOR c_tax_lines IN est_tax_lines(l_transaction_rec.entity_code,

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

2828: /* switch sign of tax_amt (discounts are normally positive
2829: but pos is reflected as negative in etax) */
2830:
2831: IF PG_DEBUG in ('Y', 'C') THEN
2832: arp_util.debug(c_tax_lines.adjusted_doc_line_id ||
2833: ' t_prorated_amt =' || t_prorated_amt(c_tax_lines.adjusted_doc_line_id) ||
2834: ' zx.tax =' || c_tax_lines.tax_amt);
2835: END IF;
2836: