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

Line 339: arp_util_tax.debug('TOO MANY PARENTS FOR THE GIVEN POSTAL CODE');

335: *--------------------------------------------------------------------*/
336: THEN arp_standard.fnd_message( 'AR_PP_ADDS_TOO_MANY_PARENTS', 'CHILD', rtrim(p_value, ' ') );
337:
338: IF PG_DEBUG = 'Y' THEN
339: arp_util_tax.debug('TOO MANY PARENTS FOR THE GIVEN POSTAL CODE');
340: END IF;
341:
342: END;
343:

Line 484: arp_util_tax.debug( '>> FIND_LOCATION_SEGMENT_ID( ' ||

480: override number;
481:
482: BEGIN
483: IF PG_DEBUG = 'Y' THEN
484: arp_util_tax.debug( '>> FIND_LOCATION_SEGMENT_ID( ' ||
485: location_segment_qualifier || ', ' ||
486: segment_value || ', ' ||
487: segment_description || ', ' ||
488: parent_segment_id || ' ) ' );

Line 530: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: EXISTING ROW '

526: END IF;
527: CLOSE location_value_given_parent_c;
528: END IF;
529: IF PG_DEBUG = 'Y' THEN
530: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: EXISTING ROW '
531: || to_char(location_segment_id) );
532: END IF;
533:
534: return( location_segment_id );

Line 591: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: EXISTING ROW(PRECISSION) '

587: goto insert_new_location;
588: END IF;
589: CLOSE location_value_max_width_c;
590: IF PG_DEBUG = 'Y' THEN
591: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: EXISTING ROW(PRECISSION) '
592: || to_char(location_segment_id) );
593: END IF;
594: return( location_segment_id );
595:

Line 676: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: NEW ROW ' || to_char(location_segment_id) );

672: );
673: end if;
674:
675: IF PG_DEBUG = 'Y' THEN
676: arp_util_tax.debug( '<< FIND_LOCATION_SEGMENT_ID: NEW ROW ' || to_char(location_segment_id) );
677: END IF;
678:
679: return( location_segment_id );
680:

Line 912: arp_util_tax.debug( '>> INS_LOCATION_VALUES( ' ||

908: location_segment_description ar_location_values.location_segment_description%TYPE;
909:
910: BEGIN
911: IF PG_DEBUG = 'Y' THEN
912: arp_util_tax.debug( '>> INS_LOCATION_VALUES( ' ||
913: location_segment_qualifier || ', ' ||
914: segment_value || ', ' ||
915: segment_description || ', ' ||
916: parent_segment_id || ' ) ' );

Line 998: arp_util_tax.debug( '<< INS_LOCATION_VALUES: ' || to_char(location_id) );

994: ins_location_accounts
995: ( location_id,
996: location_segment_qualifier);
997: IF PG_DEBUG = 'Y' THEN
998: arp_util_tax.debug( '<< INS_LOCATION_VALUES: ' || to_char(location_id) );
999: END IF;
1000: return( location_id );
1001:
1002: END ins_location_values;

Line 1076: arp_util_tax.debug( '>> INS_LOCATION_ACCOUNTS( ' ||

1072: organization_id_tab num_tab;
1073:
1074: BEGIN
1075: IF PG_DEBUG = 'Y' THEN
1076: arp_util_tax.debug( '>> INS_LOCATION_ACCOUNTS( ' ||
1077: location_segment_qualifier ||', '||
1078: to_char(Location_segment_id)||' ) ');
1079: END IF;
1080: -- Records will be inserted into AR_LOCATION_ACCOUNTS_ALL only if

Line 1233: arp_util_tax.debug( '<< INS_LOCATION_ACCOUNTS: ' ||

1229: organization_id_tab(i) );
1230:
1231: end if; -- location_segment_qualifier = 'AR_TAX_ACCOUNT_SEGMENT'
1232: IF PG_DEBUG = 'Y' THEN
1233: arp_util_tax.debug( '<< INS_LOCATION_ACCOUNTS: ' ||
1234: to_char(l_location_value_account_id) );
1235: END IF;
1236:
1237: Exception

Line 1240: arp_util_tax.debug(' Exception in ARP_ADDS.ins_location_Accounts '||

1236:
1237: Exception
1238: when others then
1239: IF PG_DEBUG = 'Y' THEN
1240: arp_util_tax.debug(' Exception in ARP_ADDS.ins_location_Accounts '||
1241: SQLCODE||' ; '||SQLERRM );
1242: END IF;
1243:
1244: if organization_id_c%isopen then

Line 1322: arp_util_tax.debug( '>> INS_LOCATION_RATES( ' ||

1318:
1319: BEGIN
1320:
1321: IF PG_DEBUG = 'Y' THEN
1322: arp_util_tax.debug( '>> INS_LOCATION_RATES( ' ||
1323: location_segment_id || ', ' ||
1324: from_postal_code || ', ' ||
1325: to_postal_code || ', ' ||
1326: start_date || ', ' ||

Line 1335: arp_util_tax.debug('Location segment id is null');

1331: if location_segment_id is null
1332: then
1333: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'LOCATION_SEGMENT_ID' );
1334: IF PG_DEBUG = 'Y' THEN
1335: arp_util_tax.debug('Location segment id is null');
1336: END IF;
1337: end if;
1338: if from_postal_code is null
1339: then

Line 1343: arp_util_tax.debug('From postal code is null');

1339: then
1340: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'FROM_POSTAL_CODE' );
1341:
1342: IF PG_DEBUG = 'Y' THEN
1343: arp_util_tax.debug('From postal code is null');
1344: END IF;
1345:
1346: end if;
1347: if to_postal_code is null

Line 1352: arp_util_tax.debug('To postal code is null');

1348: then
1349: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'TO_POSTAL_CODE' );
1350:
1351: IF PG_DEBUG = 'Y' THEN
1352: arp_util_tax.debug('To postal code is null');
1353: END IF;
1354:
1355: end if;
1356: if start_date is null

Line 1361: arp_util_tax.debug('start date is null');

1357: then
1358: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'START_DATE' );
1359:
1360: IF PG_DEBUG = 'Y' THEN
1361: arp_util_tax.debug('start date is null');
1362: END IF;
1363:
1364: end if;
1365: if end_date is null

Line 1370: arp_util_tax.debug('End date is null');

1366: then
1367: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'END_DATE' );
1368:
1369: IF PG_DEBUG = 'Y' THEN
1370: arp_util_tax.debug('End date is null');
1371: END IF;
1372:
1373: end if;
1374:

Line 1467: arp_util_tax.debug( '<< INS_LOCATION_RATES: ' || to_char(location_rate_id) );

1463: override_rate9,
1464: override_rate10 );
1465:
1466: IF PG_DEBUG = 'Y' THEN
1467: arp_util_tax.debug( '<< INS_LOCATION_RATES: ' || to_char(location_rate_id) );
1468: END IF;
1469:
1470: return( location_rate_id );
1471:

Line 1510: arp_util_tax.debug( '>> INS_LOCATION_RATES( ' ||

1506: OVERRIDE_RATE10 in NUMBER default null) is
1507:
1508: BEGIN
1509: IF PG_DEBUG = 'Y' THEN
1510: arp_util_tax.debug( '>> INS_LOCATION_RATES( ' ||
1511: location_segment_id || ', ' ||
1512: from_postal_code || ', ' ||
1513: to_postal_code || ', ' ||
1514: start_date || ', ' ||

Line 1524: arp_util_tax.debug('Location segment id is null');

1520: then
1521: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'LOCATION_SEGMENT_ID' );
1522:
1523: IF PG_DEBUG = 'Y' THEN
1524: arp_util_tax.debug('Location segment id is null');
1525: END IF;
1526:
1527: end if;
1528: if from_postal_code is null

Line 1532: arp_util_tax.debug('From postal code is null');

1528: if from_postal_code is null
1529: then
1530: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'FROM_POSTAL_CODE' );
1531: IF PG_DEBUG = 'Y' THEN
1532: arp_util_tax.debug('From postal code is null');
1533: END IF;
1534:
1535: end if;
1536: if to_postal_code is null

Line 1541: arp_util_tax.debug('To postal code is null');

1537: then
1538: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'TO_POSTAL_CODE' );
1539:
1540: IF PG_DEBUG = 'Y' THEN
1541: arp_util_tax.debug('To postal code is null');
1542: END IF;
1543:
1544: end if;
1545: if start_date is null

Line 1549: arp_util_tax.debug('start date is null');

1545: if start_date is null
1546: then
1547: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'START_DATE' );
1548: IF PG_DEBUG = 'Y' THEN
1549: arp_util_tax.debug('start date is null');
1550: END IF;
1551:
1552: end if;
1553: if end_date is null

Line 1558: arp_util_tax.debug('End date is null');

1554: then
1555: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'END_DATE' );
1556:
1557: IF PG_DEBUG = 'Y' THEN
1558: arp_util_tax.debug('End date is null');
1559: END IF;
1560: end if;
1561:
1562: insert into ar_location_rates( location_rate_id,

Line 1649: arp_util_tax.debug( '<< INS_LOCATION_RATES' );

1645: override_rate8,
1646: override_rate9,
1647: override_rate10 );
1648: IF PG_DEBUG = 'Y' THEN
1649: arp_util_tax.debug( '<< INS_LOCATION_RATES' );
1650: END IF;
1651: END ins_location_rates; /* Procedure */
1652:
1653:

Line 1713: arp_util_tax.debug( '>> INS_LOCATION_COMBINATIONS' );

1709: location_id number;
1710:
1711: BEGIN
1712: IF PG_DEBUG = 'Y' THEN
1713: arp_util_tax.debug( '>> INS_LOCATION_COMBINATIONS' );
1714: END IF;
1715:
1716: OPEN ar_location_combinations_s_c;
1717: FETCH ar_location_combinations_s_c into location_id;

Line 1773: arp_util_tax.debug( '<< INS_LOCATION_COMBINATIONS: ' || to_char(location_id) );

1769: sysdate );
1770:
1771: location_combination_inserted := TRUE;
1772: IF PG_DEBUG = 'Y' THEN
1773: arp_util_tax.debug( '<< INS_LOCATION_COMBINATIONS: ' || to_char(location_id) );
1774: END IF;
1775: return( location_id );
1776:
1777: END ins_location_combinations;

Line 1921: arp_util_tax.debug( '>> FIND_LOCATION_CCID' );

1917:
1918:
1919: BEGIN
1920: IF PG_DEBUG = 'Y' THEN
1921: arp_util_tax.debug( '>> FIND_LOCATION_CCID' );
1922: END IF;
1923:
1924: OPEN ra_addresses_c( param );
1925: FETCH ra_addresses_c into loc_id_1 ,

Line 1955: arp_util_tax.debug( '<< FIND_LOCATION_CCID: NO_DATA_FOUND' );

1951: CLOSE loc_ccid_c;
1952: ELSE
1953: CLOSE ra_addresses_c;
1954: IF PG_DEBUG = 'Y' THEN
1955: arp_util_tax.debug( '<< FIND_LOCATION_CCID: NO_DATA_FOUND' );
1956: END IF;
1957: RETURN(NULL);
1958: END IF;
1959: CLOSE ra_addresses_c;

Line 1962: arp_util_tax.debug( '<< FIND_LOCATION_CCID: ' || to_char(location_id) );

1958: END IF;
1959: CLOSE ra_addresses_c;
1960:
1961: IF PG_DEBUG = 'Y' THEN
1962: arp_util_tax.debug( '<< FIND_LOCATION_CCID: ' || to_char(location_id) );
1963: END IF;
1964: RETURN( location_id );
1965: END find_location_ccid;
1966:

Line 2003: arp_util_tax.debug( '>> TERRITORY_SHORT_NAME( ' || territory_code || ' ) ' );

1999: short_name VARCHAR2(80);
2000:
2001: begin
2002: IF PG_DEBUG = 'Y' THEN
2003: arp_util_tax.debug( '>> TERRITORY_SHORT_NAME( ' || territory_code || ' ) ' );
2004: END IF;
2005:
2006: if territory_code = previous_territory_code
2007: then return( previous_territory_short_name );

Line 2016: arp_util_tax.debug( '<< TERRITORY_SHORT_NAME: ' || short_name );

2012:
2013: previous_territory_code := territory_code;
2014: previous_territory_short_name := short_name;
2015: IF PG_DEBUG = 'Y' THEN
2016: arp_util_tax.debug( '<< TERRITORY_SHORT_NAME: ' || short_name );
2017: END IF;
2018: return( short_name );
2019:
2020: end if;

Line 2029: arp_util_tax.debug( 'Territory not available' );

2025: p_message_name => 'AR_BAD_TERRITORY',
2026: p_app_short_name => 'AR'),
2027: 'TERRITORY', territory_code);
2028: IF PG_DEBUG = 'Y' THEN
2029: arp_util_tax.debug( 'Territory not available' );
2030: END IF;
2031:
2032: end terr_short_name;
2033:

Line 2106: arp_util_tax.debug( '>> SET_LOCATION_CCID( ' || Country || ', ' ||

2102:
2103:
2104: BEGIN
2105: IF PG_DEBUG = 'Y' THEN
2106: arp_util_tax.debug( '>> SET_LOCATION_CCID( ' || Country || ', ' ||
2107: City || ', ' ||
2108: State || ', ' ||
2109: County || ', ' ||
2110: Province || ', ' ||

Line 2211: arp_util_tax.debug( '<< SET_LOCATION_CCID: ' || to_char(location_ccid) );

2207: END;
2208: ELSE location_ccid := null;
2209: END IF;
2210: IF PG_DEBUG = 'Y' THEN
2211: arp_util_tax.debug( '<< SET_LOCATION_CCID: ' || to_char(location_ccid) );
2212: END IF;
2213: EXCEPTION
2214:
2215: /*---------------------------------------------------------------------------+