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 STANDARD

Line 76: select ar_location_combinations_s.nextval + arp_standard.sequence_offset

72:
73:
74:
75: CURSOR ar_location_combinations_s_c is
76: select ar_location_combinations_s.nextval + arp_standard.sequence_offset
77: from dual;
78:
79:
80:

Line 104: select ar_location_values_s.nextval + arp_standard.sequence_offset

100: +-------------------------------------------------------------------------*/
101:
102:
103: CURSOR ar_location_values_s_c IS
104: select ar_location_values_s.nextval + arp_standard.sequence_offset
105: from dual;
106:
107:
108:

Line 171: select ar_location_accounts_s.nextval + arp_standard.sequence_offset

167: | |
168: +-------------------------------------------------------------------------*/
169:
170: CURSOR ar_location_accounts_s_c IS
171: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
172: from dual;
173:
174:
175:

Line 231: select ar_location_rates_s.nextval + arp_standard.sequence_offset

227: +-------------------------------------------------------------------------*/
228:
229:
230: CURSOR ar_location_rates_s_c IS
231: select ar_location_rates_s.nextval + arp_standard.sequence_offset
232: from dual;
233:
234:
235: /*-------------------------------------------------------------------------+

Line 291: and v1.location_structure_id = arp_standard.sysparm.location_structure_id

287: ar_location_values v1
288: WHERE v1.location_segment_id = v2.parent_segment_id
289: and v2.location_segment_value = rtrim(ltrim(upper(p_value)))
290: and v2.location_segment_qualifier = p_location_segment_qualifier
291: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
292: and v2.location_structure_id = arp_standard.sysparm.location_structure_id;
293:
294: RETURN( parent_value );
295:

Line 292: and v2.location_structure_id = arp_standard.sysparm.location_structure_id;

288: WHERE v1.location_segment_id = v2.parent_segment_id
289: and v2.location_segment_value = rtrim(ltrim(upper(p_value)))
290: and v2.location_segment_qualifier = p_location_segment_qualifier
291: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
292: and v2.location_structure_id = arp_standard.sysparm.location_structure_id;
293:
294: RETURN( parent_value );
295:
296: EXCEPTION

Line 320: and v1.location_structure_id = arp_standard.sysparm.location_structure_id

316: WHERE v1.location_segment_id = v2.parent_segment_id
317: and v2.location_segment_value = ltrim(rtrim(upper(p_value)))
318: and v2.location_segment_qualifier = p_location_segment_qualifier
319: and v2.location_segment_id = r1.location_segment_id
320: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
321: and v2.location_structure_id = arp_standard.sysparm.location_structure_id
322: and p_postal_code between r1.from_postal_code and r1.to_postal_code
323: and sysdate between r1.start_date and r1.end_date;
324:

Line 321: and v2.location_structure_id = arp_standard.sysparm.location_structure_id

317: and v2.location_segment_value = ltrim(rtrim(upper(p_value)))
318: and v2.location_segment_qualifier = p_location_segment_qualifier
319: and v2.location_segment_id = r1.location_segment_id
320: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
321: and v2.location_structure_id = arp_standard.sysparm.location_structure_id
322: and p_postal_code between r1.from_postal_code and r1.to_postal_code
323: and sysdate between r1.start_date and r1.end_date;
324:
325: else RAISE NO_DATA_FOUND;

Line 336: THEN arp_standard.fnd_message( 'AR_PP_ADDS_TOO_MANY_PARENTS', 'CHILD', rtrim(p_value, ' ') );

332: /*--------------------------------------------------------------------+
333: | Postal Codes cannot help us resolve the name conflict, report the |
334: | error back to the user |
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;

Line 451: and location_structure_id = arp_standard.sysparm.location_structure_id

447: p_parent_segment_id in number) is
448: select location_segment_id
449: from ar_location_values
450: where location_segment_qualifier = p_location_segment_qualifier
451: and location_structure_id = arp_standard.sysparm.location_structure_id
452: and parent_segment_id = p_parent_segment_id
453: and location_segment_value = rtrim(upper(p_segment_value), ' ');
454:
455:

Line 463: and location_structure_id = arp_standard.sysparm.location_structure_id

459: p_search_precission in number) is
460: select location_segment_id
461: from ar_location_values
462: where location_segment_qualifier = p_location_segment_qualifier
463: and location_structure_id = arp_standard.sysparm.location_structure_id
464: and parent_segment_id = p_parent_segment_id
465: and substr(location_segment_value,1,p_search_precission)
466: = substr(rtrim(upper(p_segment_value), ' '),1,p_search_precission);
467: /*** MB skip for above substr, because the idea is to compare ***/

Line 476: and location_structure_id = arp_standard.sysparm.location_structure_id

472: p_segment_value in varchar2 ) IS
473: select location_segment_id
474: from ar_location_values
475: where location_segment_qualifier = p_location_segment_qualifier
476: and location_structure_id = arp_standard.sysparm.location_structure_id
477: and location_segment_value = rtrim(upper(p_segment_value), ' ' );
478:
479: location_segment_id number;
480: override number;

Line 644: override := arp_standard.sysparm.location_structure_id;

640: +--------------------------------------------------*/
641:
642: if location_segment_qualifier = 'CITY'
643: then
644: override := arp_standard.sysparm.location_structure_id;
645: else
646: override := null;
647: end if;
648:

Line 650: arp_standard.sysparm.from_postal_code,

646: override := null;
647: end if;
648:
649: ins_location_rates( location_segment_id,
650: arp_standard.sysparm.from_postal_code,
651: arp_standard.sysparm.to_postal_code,
652: arp_standard.min_start_date,
653: arp_standard.max_end_date,
654: 0,

Line 651: arp_standard.sysparm.to_postal_code,

647: end if;
648:
649: ins_location_rates( location_segment_id,
650: arp_standard.sysparm.from_postal_code,
651: arp_standard.sysparm.to_postal_code,
652: arp_standard.min_start_date,
653: arp_standard.max_end_date,
654: 0,
655: 'TRIGGER',

Line 652: arp_standard.min_start_date,

648:
649: ins_location_rates( location_segment_id,
650: arp_standard.sysparm.from_postal_code,
651: arp_standard.sysparm.to_postal_code,
652: arp_standard.min_start_date,
653: arp_standard.max_end_date,
654: 0,
655: 'TRIGGER',
656: attribute1,

Line 653: arp_standard.max_end_date,

649: ins_location_rates( location_segment_id,
650: arp_standard.sysparm.from_postal_code,
651: arp_standard.sysparm.to_postal_code,
652: arp_standard.min_start_date,
653: arp_standard.max_end_date,
654: 0,
655: 'TRIGGER',
656: attribute1,
657: attribute2,

Line 756: and v1.location_structure_id = arp_standard.sysparm.location_structure_id;

752: parent_segment_id
753: from ar_location_values v1
754: where v1.location_segment_qualifier = location_information.location_segment_qualifier
755: and v1.location_segment_value = ltrim(rtrim(upper(location_information.location_segment_value)))
756: and v1.location_structure_id = arp_standard.sysparm.location_structure_id;
757:
758: EXCEPTION
759: WHEN NO_DATA_FOUND
760: THEN

Line 766: and v1.location_structure_id = arp_standard.sysparm.location_structure_id

762: select max(location_segment_description), max(parent_segment_id)
763: into location_segment_description, parent_segment_id
764: from ar_location_values v1
765: where v1.location_segment_qualifier = location_information.location_segment_qualifier
766: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
767: and v1.location_segment_value = ltrim(rtrim(location_information.location_segment_value));
768: END;
769:
770: end;

Line 958: VALUES ( arp_standard.sysparm.location_structure_id,

954: attribute12,
955: attribute13,
956: attribute14,
957: attribute15 )
958: VALUES ( arp_standard.sysparm.location_structure_id,
959: location_segment_qualifier,
960: location_id,
961: location_segment_value,
962: location_segment_user_value,

Line 965: arp_standard.PROFILE.request_id,

961: location_segment_value,
962: location_segment_user_value,
963: location_segment_description,
964: parent_segment_id,
965: arp_standard.PROFILE.request_id,
966: arp_standard.PROFILE.program_application_id,
967: arp_standard.PROFILE.program_id,
968: sysdate,
969: arp_standard.profile.user_id,

Line 966: arp_standard.PROFILE.program_application_id,

962: location_segment_user_value,
963: location_segment_description,
964: parent_segment_id,
965: arp_standard.PROFILE.request_id,
966: arp_standard.PROFILE.program_application_id,
967: arp_standard.PROFILE.program_id,
968: sysdate,
969: arp_standard.profile.user_id,
970: sysdate,

Line 967: arp_standard.PROFILE.program_id,

963: location_segment_description,
964: parent_segment_id,
965: arp_standard.PROFILE.request_id,
966: arp_standard.PROFILE.program_application_id,
967: arp_standard.PROFILE.program_id,
968: sysdate,
969: arp_standard.profile.user_id,
970: sysdate,
971: arp_standard.profile.user_id,

Line 969: arp_standard.profile.user_id,

965: arp_standard.PROFILE.request_id,
966: arp_standard.PROFILE.program_application_id,
967: arp_standard.PROFILE.program_id,
968: sysdate,
969: arp_standard.profile.user_id,
970: sysdate,
971: arp_standard.profile.user_id,
972: sysdate,
973: arp_standard.PROFILE.last_update_login,

Line 971: arp_standard.profile.user_id,

967: arp_standard.PROFILE.program_id,
968: sysdate,
969: arp_standard.profile.user_id,
970: sysdate,
971: arp_standard.profile.user_id,
972: sysdate,
973: arp_standard.PROFILE.last_update_login,
974: attribute_category,
975: attribute1,

Line 973: arp_standard.PROFILE.last_update_login,

969: arp_standard.profile.user_id,
970: sysdate,
971: arp_standard.profile.user_id,
972: sysdate,
973: arp_standard.PROFILE.last_update_login,
974: attribute_category,
975: attribute1,
976: attribute2,
977: attribute3,

Line 1147: location_tax_account:=arp_standard.sysparm.location_tax_account;

1143: l_FINCHRG_NON_REC_TAX_CCID;
1144:
1145: if ar_location_tax_account_c%NOTFOUND
1146: then
1147: location_tax_account:=arp_standard.sysparm.location_tax_account;
1148: end if;
1149: CLOSE ar_location_tax_account_c;
1150:
1151:

Line 1169: created_by_tab(i) := arp_standard.profile.user_id;

1165: adj_non_rec_tax_ccid_tab(i) := l_ADJ_NON_REC_TAX_CCID;
1166: edisc_non_rec_tax_ccid_tab(i) := l_EDISC_NON_REC_TAX_CCID;
1167: unedisc_non_rec_tax_ccid_tab(i) := l_UNEDISC_NON_REC_TAX_CCID;
1168: finchrg_non_rec_tax_ccid_tab(i) := l_FINCHRG_NON_REC_TAX_CCID;
1169: created_by_tab(i) := arp_standard.profile.user_id;
1170: creation_date_tab(i) := sysdate;
1171: last_updated_by_tab(i) := arp_standard.profile.user_id;
1172: last_update_date_tab(i) := sysdate;
1173: request_id_tab(i) := arp_standard.PROFILE.request_id;

Line 1171: last_updated_by_tab(i) := arp_standard.profile.user_id;

1167: unedisc_non_rec_tax_ccid_tab(i) := l_UNEDISC_NON_REC_TAX_CCID;
1168: finchrg_non_rec_tax_ccid_tab(i) := l_FINCHRG_NON_REC_TAX_CCID;
1169: created_by_tab(i) := arp_standard.profile.user_id;
1170: creation_date_tab(i) := sysdate;
1171: last_updated_by_tab(i) := arp_standard.profile.user_id;
1172: last_update_date_tab(i) := sysdate;
1173: request_id_tab(i) := arp_standard.PROFILE.request_id;
1174: program_application_id_tab(i) :=
1175: arp_standard.PROFILE.program_application_id;

Line 1173: request_id_tab(i) := arp_standard.PROFILE.request_id;

1169: created_by_tab(i) := arp_standard.profile.user_id;
1170: creation_date_tab(i) := sysdate;
1171: last_updated_by_tab(i) := arp_standard.profile.user_id;
1172: last_update_date_tab(i) := sysdate;
1173: request_id_tab(i) := arp_standard.PROFILE.request_id;
1174: program_application_id_tab(i) :=
1175: arp_standard.PROFILE.program_application_id;
1176: program_id_tab(i) := arp_standard.PROFILE.program_id;
1177: program_update_date_tab(i) := sysdate;

Line 1175: arp_standard.PROFILE.program_application_id;

1171: last_updated_by_tab(i) := arp_standard.profile.user_id;
1172: last_update_date_tab(i) := sysdate;
1173: request_id_tab(i) := arp_standard.PROFILE.request_id;
1174: program_application_id_tab(i) :=
1175: arp_standard.PROFILE.program_application_id;
1176: program_id_tab(i) := arp_standard.PROFILE.program_id;
1177: program_update_date_tab(i) := sysdate;
1178: last_update_login_tab(i) := arp_standard.PROFILE.last_update_login;
1179: organization_id_tab(i) := org_id_tab(I);

Line 1176: program_id_tab(i) := arp_standard.PROFILE.program_id;

1172: last_update_date_tab(i) := sysdate;
1173: request_id_tab(i) := arp_standard.PROFILE.request_id;
1174: program_application_id_tab(i) :=
1175: arp_standard.PROFILE.program_application_id;
1176: program_id_tab(i) := arp_standard.PROFILE.program_id;
1177: program_update_date_tab(i) := sysdate;
1178: last_update_login_tab(i) := arp_standard.PROFILE.last_update_login;
1179: organization_id_tab(i) := org_id_tab(I);
1180:

Line 1178: last_update_login_tab(i) := arp_standard.PROFILE.last_update_login;

1174: program_application_id_tab(i) :=
1175: arp_standard.PROFILE.program_application_id;
1176: program_id_tab(i) := arp_standard.PROFILE.program_id;
1177: program_update_date_tab(i) := sysdate;
1178: last_update_login_tab(i) := arp_standard.PROFILE.last_update_login;
1179: organization_id_tab(i) := org_id_tab(I);
1180:
1181: end loop;
1182:

Line 1333: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'LOCATION_SEGMENT_ID' );

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;

Line 1340: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'FROM_POSTAL_CODE' );

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;

Line 1349: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'TO_POSTAL_CODE' );

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;

Line 1358: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'START_DATE' );

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;

Line 1367: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'END_DATE' );

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;

Line 1429: arp_standard.PROFILE.request_id,

1425: to_postal_code,
1426: start_date,
1427: end_date,
1428: tax_rate,
1429: arp_standard.PROFILE.request_id,
1430: arp_standard.PROFILE.program_application_id,
1431: arp_standard.PROFILE.program_id,
1432: sysdate,
1433: arp_standard.profile.user_id,

Line 1430: arp_standard.PROFILE.program_application_id,

1426: start_date,
1427: end_date,
1428: tax_rate,
1429: arp_standard.PROFILE.request_id,
1430: arp_standard.PROFILE.program_application_id,
1431: arp_standard.PROFILE.program_id,
1432: sysdate,
1433: arp_standard.profile.user_id,
1434: sysdate,

Line 1431: arp_standard.PROFILE.program_id,

1427: end_date,
1428: tax_rate,
1429: arp_standard.PROFILE.request_id,
1430: arp_standard.PROFILE.program_application_id,
1431: arp_standard.PROFILE.program_id,
1432: sysdate,
1433: arp_standard.profile.user_id,
1434: sysdate,
1435: arp_standard.profile.user_id,

Line 1433: arp_standard.profile.user_id,

1429: arp_standard.PROFILE.request_id,
1430: arp_standard.PROFILE.program_application_id,
1431: arp_standard.PROFILE.program_id,
1432: sysdate,
1433: arp_standard.profile.user_id,
1434: sysdate,
1435: arp_standard.profile.user_id,
1436: sysdate,
1437: arp_standard.PROFILE.last_update_login,

Line 1435: arp_standard.profile.user_id,

1431: arp_standard.PROFILE.program_id,
1432: sysdate,
1433: arp_standard.profile.user_id,
1434: sysdate,
1435: arp_standard.profile.user_id,
1436: sysdate,
1437: arp_standard.PROFILE.last_update_login,
1438: attribute_category,
1439: attribute1,

Line 1437: arp_standard.PROFILE.last_update_login,

1433: arp_standard.profile.user_id,
1434: sysdate,
1435: arp_standard.profile.user_id,
1436: sysdate,
1437: arp_standard.PROFILE.last_update_login,
1438: attribute_category,
1439: attribute1,
1440: attribute2,
1441: attribute3,

Line 1521: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'LOCATION_SEGMENT_ID' );

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;

Line 1530: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'FROM_POSTAL_CODE' );

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:

Line 1538: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'TO_POSTAL_CODE' );

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;

Line 1547: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'START_DATE' );

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:

Line 1555: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER', 'OBJECT', 'ARP_ADDS_MINUS99INS_LOCATION_RATES', 'PARAMETER', 'END_DATE' );

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;

Line 1605: VALUES ( ar_location_rates_s.nextval + arp_standard.sequence_offset,

1601: override_rate7,
1602: override_rate8,
1603: override_rate9,
1604: override_rate10 )
1605: VALUES ( ar_location_rates_s.nextval + arp_standard.sequence_offset,
1606: location_segment_id,
1607: from_postal_code,
1608: to_postal_code,
1609: start_date,

Line 1612: arp_standard.PROFILE.request_id,

1608: to_postal_code,
1609: start_date,
1610: end_date,
1611: tax_rate,
1612: arp_standard.PROFILE.request_id,
1613: arp_standard.PROFILE.program_application_id,
1614: arp_standard.PROFILE.program_id,
1615: sysdate,
1616: arp_standard.profile.user_id,

Line 1613: arp_standard.PROFILE.program_application_id,

1609: start_date,
1610: end_date,
1611: tax_rate,
1612: arp_standard.PROFILE.request_id,
1613: arp_standard.PROFILE.program_application_id,
1614: arp_standard.PROFILE.program_id,
1615: sysdate,
1616: arp_standard.profile.user_id,
1617: sysdate,

Line 1614: arp_standard.PROFILE.program_id,

1610: end_date,
1611: tax_rate,
1612: arp_standard.PROFILE.request_id,
1613: arp_standard.PROFILE.program_application_id,
1614: arp_standard.PROFILE.program_id,
1615: sysdate,
1616: arp_standard.profile.user_id,
1617: sysdate,
1618: arp_standard.profile.user_id,

Line 1616: arp_standard.profile.user_id,

1612: arp_standard.PROFILE.request_id,
1613: arp_standard.PROFILE.program_application_id,
1614: arp_standard.PROFILE.program_id,
1615: sysdate,
1616: arp_standard.profile.user_id,
1617: sysdate,
1618: arp_standard.profile.user_id,
1619: sysdate,
1620: arp_standard.PROFILE.last_update_login,

Line 1618: arp_standard.profile.user_id,

1614: arp_standard.PROFILE.program_id,
1615: sysdate,
1616: arp_standard.profile.user_id,
1617: sysdate,
1618: arp_standard.profile.user_id,
1619: sysdate,
1620: arp_standard.PROFILE.last_update_login,
1621: attribute_category,
1622: attribute1,

Line 1620: arp_standard.PROFILE.last_update_login,

1616: arp_standard.profile.user_id,
1617: sysdate,
1618: arp_standard.profile.user_id,
1619: sysdate,
1620: arp_standard.PROFILE.last_update_login,
1621: attribute_category,
1622: attribute1,
1623: attribute2,
1624: attribute3,

Line 1749: arp_standard.PROFILE.USER_ID,

1745: (
1746: LOCATION_ID,
1747: LOCATION_STRUCTURE_ID,
1748: ENABLED_FLAG,
1749: arp_standard.PROFILE.USER_ID,
1750: sysdate,
1751: 'N',
1752: arp_standard.PROFILE.PROGRAM_APPLICATION_ID,
1753: arp_standard.PROFILE.PROGRAM_ID,

Line 1752: arp_standard.PROFILE.PROGRAM_APPLICATION_ID,

1748: ENABLED_FLAG,
1749: arp_standard.PROFILE.USER_ID,
1750: sysdate,
1751: 'N',
1752: arp_standard.PROFILE.PROGRAM_APPLICATION_ID,
1753: arp_standard.PROFILE.PROGRAM_ID,
1754: sysdate,
1755: arp_standard.PROFILE.REQUEST_ID,
1756: START_DATE_ACTIVE,

Line 1753: arp_standard.PROFILE.PROGRAM_ID,

1749: arp_standard.PROFILE.USER_ID,
1750: sysdate,
1751: 'N',
1752: arp_standard.PROFILE.PROGRAM_APPLICATION_ID,
1753: arp_standard.PROFILE.PROGRAM_ID,
1754: sysdate,
1755: arp_standard.PROFILE.REQUEST_ID,
1756: START_DATE_ACTIVE,
1757: END_DATE_ACTIVE,

Line 1755: arp_standard.PROFILE.REQUEST_ID,

1751: 'N',
1752: arp_standard.PROFILE.PROGRAM_APPLICATION_ID,
1753: arp_standard.PROFILE.PROGRAM_ID,
1754: sysdate,
1755: arp_standard.PROFILE.REQUEST_ID,
1756: START_DATE_ACTIVE,
1757: END_DATE_ACTIVE,
1758: LOCATION_ID_SEGMENT_1,
1759: LOCATION_ID_SEGMENT_2,

Line 1768: arp_standard.PROFILE.USER_ID,

1764: LOCATION_ID_SEGMENT_7,
1765: LOCATION_ID_SEGMENT_8,
1766: LOCATION_ID_SEGMENT_9,
1767: LOCATION_ID_SEGMENT_10,
1768: arp_standard.PROFILE.USER_ID,
1769: sysdate );
1770:
1771: location_combination_inserted := TRUE;
1772: IF PG_DEBUG = 'Y' THEN

Line 1830: and v1.location_structure_id = arp_standard.sysparm.location_structure_id and

1826: and v2.location_segment_value = upper(param.COUNTY)
1827: and v3.location_segment_value = upper(param.CITY)
1828: and v2.parent_segment_id = v1.location_segment_id
1829: and v3.parent_segment_id = v2.location_segment_id
1830: and v1.location_structure_id = arp_standard.sysparm.location_structure_id and
1831: v2.location_structure_id = arp_standard.sysparm.location_structure_id and
1832: v3.location_structure_id = arp_standard.sysparm.location_structure_id
1833: and v1.location_segment_qualifier = 'STATE'
1834: and v2.location_segment_qualifier = 'COUNTY'

Line 1831: v2.location_structure_id = arp_standard.sysparm.location_structure_id and

1827: and v3.location_segment_value = upper(param.CITY)
1828: and v2.parent_segment_id = v1.location_segment_id
1829: and v3.parent_segment_id = v2.location_segment_id
1830: and v1.location_structure_id = arp_standard.sysparm.location_structure_id and
1831: v2.location_structure_id = arp_standard.sysparm.location_structure_id and
1832: v3.location_structure_id = arp_standard.sysparm.location_structure_id
1833: and v1.location_segment_qualifier = 'STATE'
1834: and v2.location_segment_qualifier = 'COUNTY'
1835: and v3.location_segment_qualifier = 'CITY' ;

Line 1832: v3.location_structure_id = arp_standard.sysparm.location_structure_id

1828: and v2.parent_segment_id = v1.location_segment_id
1829: and v3.parent_segment_id = v2.location_segment_id
1830: and v1.location_structure_id = arp_standard.sysparm.location_structure_id and
1831: v2.location_structure_id = arp_standard.sysparm.location_structure_id and
1832: v3.location_structure_id = arp_standard.sysparm.location_structure_id
1833: and v1.location_segment_qualifier = 'STATE'
1834: and v2.location_segment_qualifier = 'COUNTY'
1835: and v3.location_segment_qualifier = 'CITY' ;
1836:

Line 1899: where location_structure_id = arp_standard.sysparm.location_structure_id

1895: p_location_id_segment_9 in number,
1896: p_location_id_segment_10 in number ) IS
1897: select location_id
1898: from ar_location_combinations cc
1899: where location_structure_id = arp_standard.sysparm.location_structure_id
1900: and cc.LOCATION_ID_SEGMENT_1 = p_LOCATION_ID_SEGMENT_1
1901: and cc.LOCATION_ID_SEGMENT_2 = p_LOCATION_ID_SEGMENT_2
1902: and cc.LOCATION_ID_SEGMENT_3 = p_LOCATION_ID_SEGMENT_3;
1903:

Line 1936: arp_standard.sysparm.location_structure_id,

1932: if loc_ccid_c%NOTFOUND
1933: THEN
1934:
1935: location_id := ins_location_combinations(
1936: arp_standard.sysparm.location_structure_id,
1937: null,
1938: null,
1939: loc_id_1,
1940: loc_id_2,

Line 2024: THEN arp_standard.fnd_message(gl_public_sector.get_message_name(

2020: end if;
2021:
2022: EXCEPTION
2023: WHEN NO_DATA_FOUND
2024: THEN arp_standard.fnd_message(gl_public_sector.get_message_name(
2025: p_message_name => 'AR_BAD_TERRITORY',
2026: p_app_short_name => 'AR'),
2027: 'TERRITORY', territory_code);
2028: IF PG_DEBUG = 'Y' THEN

Line 2127: IF country = nvl(arp_standard.sysparm.default_country, country )

2123: END IF;
2124: location_combination_inserted := FALSE;
2125: location_segment_inserted := FALSE;
2126:
2127: IF country = nvl(arp_standard.sysparm.default_country, country )
2128: THEN
2129: BEGIN
2130: BEGIN
2131:

Line 2162: IF arp_standard.sysparm.address_validation = 'ERR'

2158: if location_ccid is null
2159: THEN /* One or more of the address componets is missing from the values table */
2160: BEGIN
2161:
2162: IF arp_standard.sysparm.address_validation = 'ERR'
2163: THEN
2164:
2165: loc_struct := 'STATE COUNTY CITY';
2166:

Line 2168: -- arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', STATE || ' ' ||COUNTY || ' ' ||CITY );

2164:
2165: loc_struct := 'STATE COUNTY CITY';
2166:
2167: /* Report The Error back to the user */
2168: -- arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', STATE || ' ' ||COUNTY || ' ' ||CITY );
2169: -- Bug 3179554
2170: arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', loc_struct || ' ' || STATE || ' ' ||COUNTY || ' ' ||CITY );
2171:
2172:

Line 2170: arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', loc_struct || ' ' || STATE || ' ' ||COUNTY || ' ' ||CITY );

2166:
2167: /* Report The Error back to the user */
2168: -- arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', STATE || ' ' ||COUNTY || ' ' ||CITY );
2169: -- Bug 3179554
2170: arp_standard.fnd_message( 'AR_PP_ADDS_NO_ADDRESS', 'LOCATION', loc_struct || ' ' || STATE || ' ' ||COUNTY || ' ' ||CITY );
2171:
2172:
2173: ELSE
2174:

Line 2189: arp_standard.sysparm.location_structure_id,

2185: location_id(2) := find_location_segment_id( 'COUNTY', COUNTY, initcap( COUNTY ), location_id( 1 ), attribute1 => to_char(address_id) );
2186: location_id(3) := find_location_segment_id( 'CITY', CITY, initcap( CITY ), location_id( 2 ), attribute1 => to_char(address_id) );
2187:
2188: location_ccid := ins_location_combinations(
2189: arp_standard.sysparm.location_structure_id,
2190: NULL,
2191: NULL,
2192: location_id(1),
2193: location_id(2),

Line 2222: THEN arp_standard.fnd_message( 'AR_PP_ADDS_LOC_NULL_VALUE', 'SEGMENT', NULL_SEGMENT_QUALIFIER );

2218: | location combination when one of the segments is null. |
2219: +---------------------------------------------------------------------------*/
2220:
2221: WHEN LOCATION_SEGMENT_NULL_VALUE
2222: THEN arp_standard.fnd_message( 'AR_PP_ADDS_LOC_NULL_VALUE', 'SEGMENT', NULL_SEGMENT_QUALIFIER );
2223:
2224: END Set_Location_CCID ;
2225:
2226:

Line 2259: from_postal_code := arp_standard.sysparm.from_postal_code;

2255: min_start_date out NOCOPY date,
2256: max_end_date out NOCOPY date ) is
2257: begin
2258:
2259: from_postal_code := arp_standard.sysparm.from_postal_code;
2260: to_postal_code := arp_standard.sysparm.to_postal_code;
2261: min_start_date := arp_standard.min_start_date;
2262: max_end_date := arp_standard.max_end_date;
2263:

Line 2260: to_postal_code := arp_standard.sysparm.to_postal_code;

2256: max_end_date out NOCOPY date ) is
2257: begin
2258:
2259: from_postal_code := arp_standard.sysparm.from_postal_code;
2260: to_postal_code := arp_standard.sysparm.to_postal_code;
2261: min_start_date := arp_standard.min_start_date;
2262: max_end_date := arp_standard.max_end_date;
2263:
2264: end;

Line 2261: min_start_date := arp_standard.min_start_date;

2257: begin
2258:
2259: from_postal_code := arp_standard.sysparm.from_postal_code;
2260: to_postal_code := arp_standard.sysparm.to_postal_code;
2261: min_start_date := arp_standard.min_start_date;
2262: max_end_date := arp_standard.max_end_date;
2263:
2264: end;
2265:

Line 2262: max_end_date := arp_standard.max_end_date;

2258:
2259: from_postal_code := arp_standard.sysparm.from_postal_code;
2260: to_postal_code := arp_standard.sysparm.to_postal_code;
2261: min_start_date := arp_standard.min_start_date;
2262: max_end_date := arp_standard.max_end_date;
2263:
2264: end;
2265:
2266: BEGIN

Line 2280: if arp_standard.sysparm.from_postal_code is null

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
2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code
2283: then
2284: arp_standard.fnd_message( 'AR_SYSPARM_POSTAL_CODES', 'FROM', arp_standard.sysparm.from_postal_code,

Line 2281: or arp_standard.sysparm.to_postal_code is null

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
2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code
2283: then
2284: arp_standard.fnd_message( 'AR_SYSPARM_POSTAL_CODES', 'FROM', arp_standard.sysparm.from_postal_code,
2285: 'TO', arp_standard.sysparm.to_postal_code );

Line 2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code

2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2279:
2280: if arp_standard.sysparm.from_postal_code is null
2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code
2283: then
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;

Line 2284: arp_standard.fnd_message( 'AR_SYSPARM_POSTAL_CODES', 'FROM', arp_standard.sysparm.from_postal_code,

2280: if arp_standard.sysparm.from_postal_code is null
2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code
2283: then
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;

Line 2285: 'TO', arp_standard.sysparm.to_postal_code );

2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code
2283: then
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;