1: PACKAGE BODY ARP_ADDS_MINUS99 AS
2: /* $Header: ARPLXLOC.txt 115.5 2004/03/18 16:28:47 rpalani ship $ */
3:
4: /*-------------------------------------------------------------------------+
5: | |
625: attribute14,
626: attribute15 );
627:
628:
629: if ARP_ADDS_MINUS99.populate_location_rates
630: then
631:
632: /*--------------------------------------------------------------------+
633: | If this flag is set, then new location_value records automatically |
1329: END IF;
1330:
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;
1336: END IF;
1337: end if;
1338: if 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
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
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
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;
1517: END IF;
1518:
1519: if 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
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:
1534:
1535: end if;
1536: if 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
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:
1551:
1552: end if;
1553: if 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;
2270: | trigger, AR_LOCATION_VALUES_BRIU has access to this information for |
2271: | validation purposes. |
2272: *---------------------------------------------------------------------------*/
2273:
2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';
2275: ARP_ADDS_MINUS99.all_segment_qualifiers := 'STATE COUNTY CITY';
2276: ARP_ADDS_MINUS99.last_segment_qualifier := 'CITY';
2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2271: | validation purposes. |
2272: *---------------------------------------------------------------------------*/
2273:
2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';
2275: ARP_ADDS_MINUS99.all_segment_qualifiers := 'STATE COUNTY CITY';
2276: ARP_ADDS_MINUS99.last_segment_qualifier := 'CITY';
2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2279:
2272: *---------------------------------------------------------------------------*/
2273:
2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';
2275: ARP_ADDS_MINUS99.all_segment_qualifiers := 'STATE COUNTY CITY';
2276: ARP_ADDS_MINUS99.last_segment_qualifier := 'CITY';
2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2279:
2280: if arp_standard.sysparm.from_postal_code is null
2284: arp_standard.fnd_message( 'AR_SYSPARM_POSTAL_CODES', 'FROM', arp_standard.sysparm.from_postal_code,
2285: 'TO', arp_standard.sysparm.to_postal_code );
2286: end if;
2287:
2288: END ARP_ADDS_MINUS99;