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_STAX_MINUS99 dependencies on ARP_UTIL_TAX

Line 113: arp_util_tax.debug( '>> INS_SALES_TAX' );

109: BEGIN
110: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
111: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
112: IF PG_DEBUG = 'Y' THEN
113: arp_util_tax.debug( '>> INS_SALES_TAX' );
114: END IF;
115:
116: OPEN ar_sales_tax_s_c;
117: FETCH ar_sales_tax_s_c into sales_tax_id;

Line 155: arp_util_tax.debug( '<< INS_SALES_TAX:' || sales_tax_id );

151: start_date,
152: end_date,
153: 'Y');
154: IF PG_DEBUG = 'Y' THEN
155: arp_util_tax.debug( '<< INS_SALES_TAX:' || sales_tax_id );
156: END IF;
157: return(sales_tax_id);
158: END ins_sales_tax;
159:

Line 252: arp_util_tax.debug( '>> IMPLEMENT_TRANSFER_RATES' );

248: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
249: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
250:
251: IF PG_DEBUG = 'Y' THEN
252: arp_util_tax.debug( '>> IMPLEMENT_TRANSFER_RATES' );
253: END IF;
254:
255: if not transfer_rates_initialised
256: then

Line 260: arp_util_tax.debug( '>> AR TRIGGER LOCATION RATES NOT INITIALIZED' );

256: then
257: arp_standard.fnd_message( 'AR_TRIG_NOT_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );
258:
259: IF PG_DEBUG = 'Y' THEN
260: arp_util_tax.debug( '>> AR TRIGGER LOCATION RATES NOT INITIALIZED' );
261: END IF;
262:
263: end if;
264: transfer_rates_initialised := FALSE;

Line 340: arp_util_tax.debug( '<< IMPLEMENT_TRANSFER_RATES: ' || ccids );

336: location_segment_id(i) := NULL; /* Once this is used, clear it down */
337: END LOOP;
338:
339: IF PG_DEBUG = 'Y' THEN
340: arp_util_tax.debug( '<< IMPLEMENT_TRANSFER_RATES: ' || ccids );
341: END IF;
342:
343: END Implement_Transfer_Rates;
344:

Line 439: arp_util_tax.debug( '>> SITE_USE_SALES_TAX( ' || address_id || ' )' );

435: BEGIN
436: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
437: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
438: IF PG_DEBUG = 'Y' THEN
439: arp_util_tax.debug( '>> SITE_USE_SALES_TAX( ' || address_id || ' )' );
440: END IF;
441:
442: OPEN sel_cc( address_id );
443: FETCH sel_cc into cc;

Line 460: arp_util_tax.debug( '<< SITE_USE_SALES_TAX' );

456: cc.location_id_segment_9 ,
457: cc.location_id_segment_10 ) ;
458:
459: IF PG_DEBUG = 'Y' THEN
460: arp_util_tax.debug( '<< SITE_USE_SALES_TAX' );
461: END IF;
462:
463: END;
464:

Line 507: arp_util_tax.debug('AR_TRIGGER LOCATION RATES ALREADY EXIST');

503: then
504: arp_standard.fnd_message( 'AR_TRIG_ALREADY_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );
505:
506: IF PG_DEBUG = 'Y' THEN
507: arp_util_tax.debug('AR_TRIGGER LOCATION RATES ALREADY EXIST');
508: END IF;
509:
510: end if;
511:

Line 703: arp_util_tax.debug( '>> POPULATE_SALES_TAX ( ' || statement_type || ', '

699: BEGIN
700: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
701: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
702: IF PG_DEBUG = 'Y' THEN
703: arp_util_tax.debug( '>> POPULATE_SALES_TAX ( ' || statement_type || ', '
704: || location_ccid || ' )' );
705: END IF;
706:
707: /*------------------------------------------------------------------------+

Line 769: arp_util_tax.debug( 'I: Populate_sales_tax: ' || p_location_id_segment_1 || ' ' ||

765: | table are inserted. |
766: +-----------------------------------------------------------------------*/
767:
768: IF PG_DEBUG = 'Y' THEN
769: arp_util_tax.debug( 'I: Populate_sales_tax: ' || p_location_id_segment_1 || ' ' ||
770: p_location_id_segment_2 || ' ' ||
771: p_location_id_segment_3 || ' ' ||
772: p_location_id_segment_4 );
773: END IF;

Line 928: arp_util_tax.debug( '<< POPULATE_SALES_TAX' );

924:
925: END IF; /* Dont call if in delete mode */
926:
927: IF PG_DEBUG = 'Y' THEN
928: arp_util_tax.debug( '<< POPULATE_SALES_TAX' );
929: END IF;
930:
931: END Populate_Sales_Tax;
932:

Line 940: arp_util_tax.debug( '>> PROPOGATE_SALES_TAX' );

936: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
937: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
938:
939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug( '>> PROPOGATE_SALES_TAX' );
941: END IF;
942:
943: update ar_location_combinations
944: set last_update_date = sysdate ,

Line 964: arp_util_tax.debug( '<< PROPOGATE_SALES_TAX' );

960: and nvl(acct_site.org_id,-99) =
961: nvl(loc_assign.org_id,-99)
962: and site_uses.site_use_code = 'SHIP_TO' );
963: IF PG_DEBUG = 'Y' THEN
964: arp_util_tax.debug( '<< PROPOGATE_SALES_TAX' );
965: END IF;
966:
967: END;
968:

Line 987: ARP_UTIL_TAX.DEBUG( '>> PURGE_SALES_TAX' );

983: --
984: BEGIN
985: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
986: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
987: ARP_UTIL_TAX.DEBUG( '>> PURGE_SALES_TAX' );
988:
989: FOR tax in sel_rates_c
990: LOOP
991: BEGIN

Line 1023: ARP_UTIL_TAX.DEBUG( '<< PURGE_SALES_TAX' );

1019: CLOSE PurgeRateUsed;
1020: END ;
1021: END LOOP;
1022:
1023: ARP_UTIL_TAX.DEBUG( '<< PURGE_SALES_TAX' );
1024:
1025: END Purge_Sales_Tax;
1026:
1027: /*-------------------------------------------------------------------------+

Line 1133: arp_util_tax.debug('period_date_range ( '||to_char(trx_date)||')');

1129: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1130:
1131:
1132: IF PG_DEBUG = 'Y' THEN
1133: arp_util_tax.debug('period_date_range ( '||to_char(trx_date)||')');
1134: END IF;
1135:
1136: open sel_date( trx_date );
1137: fetch sel_date into start_date, end_date;

Line 1144: arp_util_tax.debug('AR ACCOUNTING PERIOD IS NOT DEFINED');

1140: then
1141: close sel_date;
1142: arp_standard.fnd_message( 'AR_TW_NO_PERIOD_DEFINED','DATE',to_char(trx_date));
1143: IF PG_DEBUG = 'Y' THEN
1144: arp_util_tax.debug('AR ACCOUNTING PERIOD IS NOT DEFINED');
1145: END IF;
1146:
1147: end if;
1148: if sel_date%isopen then

Line 1421: ARP_UTIL_TAX.DEBUG( '>> FIND_TAX_EXEMPTION_ID: ' || bill_to_customer_id || ', ' ||

1417: BEGIN
1418: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1419: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1420:
1421: ARP_UTIL_TAX.DEBUG( '>> FIND_TAX_EXEMPTION_ID: ' || bill_to_customer_id || ', ' ||
1422: ship_to_site_id || ', ' || tax_code || ', ' ||
1423: inventory_item_id || ', ' || to_char(trx_date, 'DD-MON-YYYY') || ', ' ||
1424: tax_exempt_flag || ', ' || reason_code || ', ' || certificate );
1425:

Line 1447: arp_util_tax.debug('NO REASON FOR EXEMPTION ');

1443: if l_tax_exempt_reason_code is null and tax_exempt_flag = 'E'
1444: then
1445: arp_standard.fnd_message( 'AR_NO_REASON_FOR_EXEMPTION' );
1446: IF PG_DEBUG = 'Y' THEN
1447: arp_util_tax.debug('NO REASON FOR EXEMPTION ');
1448: END IF;
1449:
1450: end if;
1451:

Line 1466: arp_util_tax.debug( 'I: A Customer Exemption Exists (chk1)' );

1462:
1463: l_find_customer_exemption := TRUE;
1464:
1465: IF PG_DEBUG = 'Y' THEN
1466: arp_util_tax.debug( 'I: A Customer Exemption Exists (chk1)' );
1467: END IF;
1468:
1469: else
1470:

Line 1474: arp_util_tax.debug( 'I: No Customer Exemption found (chk1)' );

1470:
1471: l_find_customer_exemption := FALSE;
1472:
1473: IF PG_DEBUG = 'Y' THEN
1474: arp_util_tax.debug( 'I: No Customer Exemption found (chk1)' );
1475: END IF;
1476:
1477: end if;
1478:

Line 1522: arp_util_tax.debug('INSIDE OF LOOP:Found exemption in cache('||to_char(j)||')');

1518: l_tax_exempt_number := tax_exempt_info_tbl(j).tax_exempt_number;
1519: l_status_code := tax_exempt_info_tbl(j).status_code;
1520:
1521: IF PG_DEBUG = 'Y' THEN
1522: arp_util_tax.debug('INSIDE OF LOOP:Found exemption in cache('||to_char(j)||')');
1523: END IF;
1524:
1525: EXIT;
1526:

Line 1534: arp_util_tax.debug('No matching record in cache.');

1530:
1531: if l_bill_to_customer_id is null then
1532:
1533: IF PG_DEBUG = 'Y' THEN
1534: arp_util_tax.debug('No matching record in cache.');
1535: END IF;
1536:
1537: OPEN sel_customer_exemption( bill_to_customer_id, ship_to_site_id,
1538: trx_date, tax_code, tax_exempt_flag,

Line 1568: arp_util_tax.debug( 'I: Location Qualifiers');

1564: /* that must be populated in ra_tax_exemptions.location_id_segment_n */
1565: /*********************************************************************/
1566:
1567: IF PG_DEBUG = 'Y' THEN
1568: arp_util_tax.debug( 'I: Location Qualifiers');
1569: arp_util_tax.debug( 'EXEMPT_LEVEL STATE TAX_ACCOUNT, COUNTY, CITY' );
1570: END IF;
1571:
1572: /*** MB skip, hardcode search for EXEMPT_LEVEL ***/

Line 1569: arp_util_tax.debug( 'EXEMPT_LEVEL STATE TAX_ACCOUNT, COUNTY, CITY' );

1565: /*********************************************************************/
1566:
1567: IF PG_DEBUG = 'Y' THEN
1568: arp_util_tax.debug( 'I: Location Qualifiers');
1569: arp_util_tax.debug( 'EXEMPT_LEVEL STATE TAX_ACCOUNT, COUNTY, CITY' );
1570: END IF;
1571:
1572: /*** MB skip, hardcode search for EXEMPT_LEVEL ***/
1573: if instr( 'EXEMPT_LEVEL STATE TAX_ACCOUNT, COUNTY, CITY', 'EXEMPT_LEVEL' ) <> 0 then

Line 1576: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: USING EXEMT_LEVEL SEGMENT QUALIFIER FOR NEW EXEMPTION');

1572: /*** MB skip, hardcode search for EXEMPT_LEVEL ***/
1573: if instr( 'EXEMPT_LEVEL STATE TAX_ACCOUNT, COUNTY, CITY', 'EXEMPT_LEVEL' ) <> 0 then
1574:
1575: IF PG_DEBUG = 'Y' THEN
1576: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: USING EXEMT_LEVEL SEGMENT QUALIFIER FOR NEW EXEMPTION');
1577: END IF;
1578:
1579: OPEN sel_location_ids( ship_to_site_id );
1580:

Line 1597: arp_util_tax.debug('AR STAX NO LOCATION ID');

1593: if sel_location_ids%NOTFOUND then
1594: CLOSE sel_location_ids;
1595: arp_standard.fnd_message( 'AR_STAX_NO_LOCATION_ID', 'SITE_USE_ID', ship_to_site_id );
1596: IF PG_DEBUG = 'Y' THEN
1597: arp_util_tax.debug('AR STAX NO LOCATION ID');
1598: END IF;
1599: end if;
1600: CLOSE sel_location_ids;
1601:

Line 1620: arp_util_tax.debug('STAX NOT INSTALLED');

1616: /*********************************************************************************/
1617: WHEN OTHERS THEN
1618: arp_standard.fnd_message( 'AR_STAX_NOT_INSTALLED' );
1619: IF PG_DEBUG = 'Y' THEN
1620: arp_util_tax.debug('STAX NOT INSTALLED');
1621: END IF;
1622:
1623: END;
1624:

Line 1711: arp_util_tax.debug('Inserting into cache after inserting into ra_tax_exemptions');

1707: l_exemption_type := 'CUSTOMER';
1708: l_inserted := TRUE;
1709:
1710: IF PG_DEBUG = 'Y' THEN
1711: arp_util_tax.debug('Inserting into cache after inserting into ra_tax_exemptions');
1712: END IF;
1713:
1714: pg_max_index := pg_max_index + 1;
1715: tax_exempt_info_tbl(pg_max_index).percent_exempt := 100.00;

Line 1729: arp_util_tax.debug('Inserting into cache. Exemption is not found.');

1725:
1726: else
1727:
1728: IF PG_DEBUG = 'Y' THEN
1729: arp_util_tax.debug('Inserting into cache. Exemption is not found.');
1730: END IF;
1731: pg_max_index := pg_max_index + 1;
1732: tax_exempt_info_tbl(pg_max_index).percent_exempt := l_percent_exempt;
1733: tax_exempt_info_tbl(pg_max_index).tax_exemption_id := l_exemption_id;

Line 1752: arp_util_tax.debug('Inserting into cache. Exemption is found by query. ');

1748: l_exemption_type := 'CUSTOMER';
1749: l_inserted := FALSE;
1750:
1751: IF PG_DEBUG = 'Y' THEN
1752: arp_util_tax.debug('Inserting into cache. Exemption is found by query. ');
1753: END IF;
1754: pg_max_index := pg_max_index + 1;
1755: tax_exempt_info_tbl(pg_max_index).percent_exempt := l_percent_exempt;
1756: tax_exempt_info_tbl(pg_max_index).tax_exemption_id := l_exemption_id;

Line 1774: arp_util_tax.debug('Found Exemption in cache.');

1770: elsif l_status_code is not null then
1771:
1772: /* Exemption is found in cache */
1773: IF PG_DEBUG = 'Y' THEN
1774: arp_util_tax.debug('Found Exemption in cache.');
1775: END IF;
1776:
1777: l_exemption_type := 'CUSTOMER';
1778: l_inserted := FALSE;

Line 1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||

1783:
1784:
1785: else
1786: IF PG_DEBUG = 'Y' THEN
1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||
1788: arp_standard.sysparm.tax_use_customer_exempt_flag );
1789: END IF;
1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag
1791:

Line 1826: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.TAX_USE_PRODUCT_EXEMPT_FLAG = ' ||

1822: --
1823: -- Product Exmeptions must be turned off in the system parameters form
1824: --
1825: IF PG_DEBUG = 'Y' THEN
1826: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.TAX_USE_PRODUCT_EXEMPT_FLAG = ' ||
1827: arp_standard.sysparm.TAX_USE_PRODUCT_EXEMPT_FLAG );
1828: END IF;
1829: END IF;
1830:

Line 1852: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( INSERTED, ' || l_exemption_type || ' ' || l_exemption_id

1848: then
1849: if l_inserted
1850: then
1851: IF PG_DEBUG = 'Y' THEN
1852: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( INSERTED, ' || l_exemption_type || ' ' || l_exemption_id
1853: || ', ' || l_percent_exempt ||' )' );
1854: END IF;
1855: else
1856: inserted_flag := 'N';

Line 1858: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( FOUND, ' || l_exemption_type || ', '

1854: END IF;
1855: else
1856: inserted_flag := 'N';
1857: IF PG_DEBUG = 'Y' THEN
1858: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( FOUND, ' || l_exemption_type || ', '
1859: || l_exemption_id || ', ' || l_percent_exempt ||' )' );
1860: arp_util_tax.debug( ' Updating In_Use_Flag in ra_tax_exemptions' ) ;
1861: END IF;
1862: -- Bug 3159438: To Update In_Use_Flag in Exemptions

Line 1860: arp_util_tax.debug( ' Updating In_Use_Flag in ra_tax_exemptions' ) ;

1856: inserted_flag := 'N';
1857: IF PG_DEBUG = 'Y' THEN
1858: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( FOUND, ' || l_exemption_type || ', '
1859: || l_exemption_id || ', ' || l_percent_exempt ||' )' );
1860: arp_util_tax.debug( ' Updating In_Use_Flag in ra_tax_exemptions' ) ;
1861: END IF;
1862: -- Bug 3159438: To Update In_Use_Flag in Exemptions
1863: Update ra_tax_exemptions_all
1864: set in_use_flag = 'Y'

Line 1871: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( NO EXEMPTION )' );

1867:
1868: else
1869:
1870: IF PG_DEBUG = 'Y' THEN
1871: arp_util_tax.debug( '<< FIND_TAX_EXEMPTION_ID( NO EXEMPTION )' );
1872: END IF;
1873:
1874: end if;
1875: