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.PN_CAD_IMPORT dependencies on STANDARD

Line 99: | Standard_Type_Lookup_Code to PN_LOCATIONS_ITF.

95: | Inserts and Updates. Added function
96: | Exists_Property_Id for validating Property_id.
97: | Added validations for Locations_Alias.
98: | 08-MAY-02 Kiran Hegde o Fixed Bug#2341761. Added column
99: | Standard_Type_Lookup_Code to PN_LOCATIONS_ITF.
100: | Modified inserts and updates appropriately.
101: | Changed the validations of Usable, Rentable,
102: | Assignable to match the validations in the form
103: | 14-MAY-02 Kiran Hegde o Added validations to Locations_Itf to behave

Line 330: put_log('Validate Standard Type Lookup_Code');

326: raise INVALID_RECORD;
327: end if;
328: END IF;
329:
330: put_log('Validate Standard Type Lookup_Code');
331: --------------------------------------
332: -- Validate Standard Type Lookup_Code
333: --------------------------------------
334: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN

Line 332: -- Validate Standard Type Lookup_Code

328: END IF;
329:
330: put_log('Validate Standard Type Lookup_Code');
331: --------------------------------------
332: -- Validate Standard Type Lookup_Code
333: --------------------------------------
334: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN
335: if (loc.STANDARD_TYPE_LOOKUP_CODE is NOT NULL and
336: NOT PNP_UTIL_FUNC.valid_lookup_code(

Line 335: if (loc.STANDARD_TYPE_LOOKUP_CODE is NOT NULL and

331: --------------------------------------
332: -- Validate Standard Type Lookup_Code
333: --------------------------------------
334: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN
335: if (loc.STANDARD_TYPE_LOOKUP_CODE is NOT NULL and
336: NOT PNP_UTIL_FUNC.valid_lookup_code(
337: 'PN_STANDARD_TYPE', loc.STANDARD_TYPE_LOOKUP_CODE)) then
338: fnd_message.set_name('PN', 'PN_CAFM_STANDARD_TYPE');
339: fnd_message.set_token('LOCATION_ID', loc.location_id);

Line 337: 'PN_STANDARD_TYPE', loc.STANDARD_TYPE_LOOKUP_CODE)) then

333: --------------------------------------
334: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN
335: if (loc.STANDARD_TYPE_LOOKUP_CODE is NOT NULL and
336: NOT PNP_UTIL_FUNC.valid_lookup_code(
337: 'PN_STANDARD_TYPE', loc.STANDARD_TYPE_LOOKUP_CODE)) then
338: fnd_message.set_name('PN', 'PN_CAFM_STANDARD_TYPE');
339: fnd_message.set_token('LOCATION_ID', loc.location_id);
340: l_error_message := fnd_message.get;
341: raise INVALID_RECORD;

Line 338: fnd_message.set_name('PN', 'PN_CAFM_STANDARD_TYPE');

334: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN
335: if (loc.STANDARD_TYPE_LOOKUP_CODE is NOT NULL and
336: NOT PNP_UTIL_FUNC.valid_lookup_code(
337: 'PN_STANDARD_TYPE', loc.STANDARD_TYPE_LOOKUP_CODE)) then
338: fnd_message.set_name('PN', 'PN_CAFM_STANDARD_TYPE');
339: fnd_message.set_token('LOCATION_ID', loc.location_id);
340: l_error_message := fnd_message.get;
341: raise INVALID_RECORD;
342: end if;

Line 663: ,x_STANDARD_TYPE_LOOKUP_CODE => loc.standard_type_lookup_code

659: ,x_LOCATION_PARK_ID => NULL
660: ,x_LOCATION_TYPE_LOOKUP_CODE => loc.location_type_lookup_code
661: ,x_SPACE_TYPE_LOOKUP_CODE => loc.space_type_lookup_code
662: ,x_FUNCTION_TYPE_LOOKUP_CODE => loc.function_type_lookup_code
663: ,x_STANDARD_TYPE_LOOKUP_CODE => loc.standard_type_lookup_code
664: ,x_LOCATION_ALIAS => loc.location_alias
665: ,x_LOCATION_CODE => loc.location_code
666: ,x_BUILDING => loc.building
667: ,x_LEASE_OR_OWNED => loc.lease_or_owned

Line 1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;

1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));

Line 1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=

1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=

Line 1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);

1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957