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 PNT_LOCATIONS_PKG

Line 117: | before passing it to PNT_LOCATIONS_PKG.

113: | 3. Added validations for a valid combination of
114: | Id and Code for Locations.
115: | 4. Changed several messages
116: | 07-AUG-03 Kiran o Populated the Addresses %ROWTYPE variable
117: | before passing it to PNT_LOCATIONS_PKG.
118: | correct_update_row. Removd explicit update
119: | statements to update pn_addresses_all. Bug #
120: | 3079433. Changed 'IF' condition for calling
121: | validate_gross_area in 'COrrect' and 'Update'

Line 133: | PNT_LOCATIONS_PKG.check_location_gaps for Bug#4503407

129: | the value of p_org_id in place of
130: | fnd_profile.value('ORG_ID')
131: | 14-JUL-05 piagrawa o passed org id in call to Is_Id_Code_Valid
132: | 27-JUL-05 SatyaDeep o Added a check for office/section in the call to
133: | PNT_LOCATIONS_PKG.check_location_gaps for Bug#4503407
134: | 27-JUL-05 SatyaDeep o Added validation for NEW_ACTIVE_START_DATE
135: | and NEW_ACTIVE_END_DATE for Bug#4503407
136: | 23-NOV-05 Hareesha o Fetched org_id using cursor
137: | 01-DEC-05 Pikhar o Passed org_id in

Line 138: | PNT_LOCATIONS_PKG.check_unique_building_alias

134: | 27-JUL-05 SatyaDeep o Added validation for NEW_ACTIVE_START_DATE
135: | and NEW_ACTIVE_END_DATE for Bug#4503407
136: | 23-NOV-05 Hareesha o Fetched org_id using cursor
137: | 01-DEC-05 Pikhar o Passed org_id in
138: | PNT_LOCATIONS_PKG.check_unique_building_alias
139: | 26-Nov-08 rthumma o Bug 6670882 : Modified to do a commit after the
140: | processing loop.
141: | 27-Nov-08 rthumma o Bug 6861678 : Selected the occupancy_status_code
142: | of the parent_location in cursor loccur to

Line 404: TRUNC(NVL(loc.active_end_date,PNT_LOCATIONS_PKG.G_END_OF_TIME)) then

400: l_error_message := fnd_message.get;
401: raise INVALID_RECORD;
402: end if;
403: if TRUNC(loc.ACTIVE_START_DATE) >
404: TRUNC(NVL(loc.active_end_date,PNT_LOCATIONS_PKG.G_END_OF_TIME)) then
405: fnd_message.set_name('PN', 'PN_LOCN_STDT_VALID_MSG');
406: fnd_message.set_token('LOCATION_ID', loc.location_id);
407: l_error_message := fnd_message.get;
408: raise INVALID_RECORD;

Line 416: select min(active_start_date), nvl(max(active_end_date),PNT_LOCATIONS_PKG.G_END_OF_TIME)

412: -------------------------------------------------------------------------
413: -- Validate Active_Start_Date and Active_End_Date wrt the parent Location
414: -------------------------------------------------------------------------
415: if loc.LOCATION_TYPE_LOOKUP_CODE in ('FLOOR', 'OFFICE', 'PARCEL', 'SECTION') then
416: select min(active_start_date), nvl(max(active_end_date),PNT_LOCATIONS_PKG.G_END_OF_TIME)
417: into l_active_start_date, l_active_end_date
418: from pn_locations_all where location_id = loc.PARENT_LOCATION_ID
419: group by location_id;
420:

Line 427: elsif trunc(nvl(loc.active_end_date,PNT_LOCATIONS_PKG.G_END_OF_TIME))

423: fnd_message.set_token('LOCATION_ID', loc.location_id);
424: fnd_message.set_token('P_LOCATION_ID', loc.parent_location_id);
425: l_error_message := fnd_message.get;
426: raise INVALID_RECORD;
427: elsif trunc(nvl(loc.active_end_date,PNT_LOCATIONS_PKG.G_END_OF_TIME))
428: > trunc(l_active_end_date) then
429: fnd_message.set_name('PN', 'PN_CAFM_LOC_CHILD_END_DT');
430: fnd_message.set_token('LOCATION_ID', loc.location_id);
431: fnd_message.set_token('P_LOCATION_ID', loc.parent_location_id);

Line 453: if not(PNT_LOCATIONS_PKG.check_unique_building_alias(loc.LOCATION_ID,

449: --------------------------------------------
450: -- Validate for Duplicate Building/Land Code
451: --------------------------------------------
452: if loc.LOCATION_TYPE_LOOKUP_CODE in ('BUILDING', 'LAND') then
453: if not(PNT_LOCATIONS_PKG.check_unique_building_alias(loc.LOCATION_ID,
454: loc.LOCATION_CODE,
455: loc.LOCATION_TYPE_LOOKUP_CODE,
456: l_org_id))
457: then

Line 627: if NOT pnt_locations_pkg.validate_gross_area

623: --------------------------------------------
624: -- Validate for Rentable area v/s Gross Area
625: --------------------------------------------
626: if loc.LOCATION_TYPE_LOOKUP_CODE in ('OFFICE', 'SECTION') then
627: if NOT pnt_locations_pkg.validate_gross_area
628: (p_loc_id => loc.PARENT_LOCATION_ID,
629: p_area => nvl(loc.RENTABLE_AREA,0),
630: p_lkp_code => loc.LOCATION_TYPE_LOOKUP_CODE,
631: p_act_str_dt => trunc(loc.ACTIVE_START_DATE),

Line 633: PNT_LOCATIONS_PKG.G_END_OF_TIME))) --Used trunc() :Bug 6009957

629: p_area => nvl(loc.RENTABLE_AREA,0),
630: p_lkp_code => loc.LOCATION_TYPE_LOOKUP_CODE,
631: p_act_str_dt => trunc(loc.ACTIVE_START_DATE),
632: p_act_end_dt => trunc(nvl(loc.ACTIVE_END_DATE,
633: PNT_LOCATIONS_PKG.G_END_OF_TIME))) --Used trunc() :Bug 6009957
634: then
635: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');
636: fnd_message.set_token('LOCATION_ID', loc.location_id);
637: l_error_message := fnd_message.get;

Line 650: PNT_LOCATIONS_PKG.INSERT_ROW (

646:
647: BEGIN
648:
649: l_address_id := NULL;
650: PNT_LOCATIONS_PKG.INSERT_ROW (
651: x_rowid => l_rowid
652: ,x_org_id => l_org_id
653: ,x_LOCATION_ID => loc.location_id
654: ,x_LAST_UPDATE_DATE => sysdate

Line 741: ,x_ACTIVE_START_DATE => trunc(nvl(loc.active_start_date,PNT_LOCATIONS_PKG.G_START_OF_TIME))--Used trunc() :Bug 6009957

737: ,x_addr_attribute13 => loc.addr_attribute13
738: ,x_addr_attribute14 => loc.addr_attribute14
739: ,x_addr_attribute15 => loc.addr_attribute15
740: ,x_COMMON_AREA_FLAG => loc.common_area_flag
741: ,x_ACTIVE_START_DATE => trunc(nvl(loc.active_start_date,PNT_LOCATIONS_PKG.G_START_OF_TIME))--Used trunc() :Bug 6009957
742: ,x_ACTIVE_END_DATE => trunc(nvl(loc.active_end_date ,PNT_LOCATIONS_PKG.G_END_OF_TIME))--Used trunc() :Bug 6009957
743: ,x_occupancy_status_code => l_occ_status /* Bug 6861678 */
744: ,x_change_mode => nvl(loc.change_mode,'INSERT')
745: ,x_return_status => l_returnstatus

Line 742: ,x_ACTIVE_END_DATE => trunc(nvl(loc.active_end_date ,PNT_LOCATIONS_PKG.G_END_OF_TIME))--Used trunc() :Bug 6009957

738: ,x_addr_attribute14 => loc.addr_attribute14
739: ,x_addr_attribute15 => loc.addr_attribute15
740: ,x_COMMON_AREA_FLAG => loc.common_area_flag
741: ,x_ACTIVE_START_DATE => trunc(nvl(loc.active_start_date,PNT_LOCATIONS_PKG.G_START_OF_TIME))--Used trunc() :Bug 6009957
742: ,x_ACTIVE_END_DATE => trunc(nvl(loc.active_end_date ,PNT_LOCATIONS_PKG.G_END_OF_TIME))--Used trunc() :Bug 6009957
743: ,x_occupancy_status_code => l_occ_status /* Bug 6861678 */
744: ,x_change_mode => nvl(loc.change_mode,'INSERT')
745: ,x_return_status => l_returnstatus
746: ,x_return_message => l_return_message

Line 783: and active_End_date = trunc(nvl(loc.active_end_date, PNT_LOCATIONS_PKG.G_END_OF_TIME));

779: from PN_LOCATIONS_ALL
780: where LOCATION_ID = loc.location_id
781: and location_code = loc.location_code
782: and active_Start_date = trunc(loc.active_start_date)
783: and active_End_date = trunc(nvl(loc.active_end_date, PNT_LOCATIONS_PKG.G_END_OF_TIME));
784: --Used trunc() :Bug 6009957
785:
786: EXCEPTION
787: WHEN no_data_found THEN

Line 840: PNT_LOCATIONS_PKG.SET_ROWID(

836: loc.new_active_end_date IS NOT NULL THEN
837: -------------------------
838: -- set the ROWID first --
839: -------------------------
840: PNT_LOCATIONS_PKG.SET_ROWID(
841: p_location_id => v_loc_rec.location_id,
842: p_active_start_date => trunc(v_loc_rec.active_start_date), --Used trunc() :Bug 6009957
843: p_active_end_date => trunc(v_loc_rec.active_end_date), --Used trunc() :Bug 6009957
844: x_return_status => l_returnstatus,

Line 851: PNT_LOCATIONS_PKG.check_location_overlap (

847: put_log('Check for location overlaps');
848: ---------------------------------
849: -- check for location overlaps --
850: ---------------------------------
851: PNT_LOCATIONS_PKG.check_location_overlap (
852: p_org_id => v_loc_rec.org_id,
853: p_location_id => v_loc_rec.location_id,
854: p_location_code => v_loc_rec.location_code,
855: p_location_type_lookup_code => v_loc_rec.location_type_lookup_code,

Line 877: PNT_LOCATIONS_PKG.check_location_gaps (

873: -----------------------------
874: -- check for location gaps --
875: -----------------------------
876: IF v_loc_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
877: PNT_LOCATIONS_PKG.check_location_gaps (
878: p_org_id => v_loc_rec.org_id,
879: p_location_id => v_loc_rec.location_id,
880: p_location_code => v_loc_rec.location_code,
881: p_location_type_lookup_code => v_loc_rec.location_type_lookup_code,

Line 982: IF NOT pnt_locations_pkg.validate_gross_area

978:
979: IF loc.LOCATION_TYPE_LOOKUP_CODE IN ('OFFICE', 'SECTION') AND
980: loc.RENTABLE_AREA IS NOT NULL THEN
981:
982: IF NOT pnt_locations_pkg.validate_gross_area
983: (p_loc_id => loc.PARENT_LOCATION_ID,
984: p_area => (NVL(v_loc_rec.RENTABLE_AREA,0)
985: - NVL(loc.RENTABLE_AREA,0)),
986: p_lkp_code => loc.LOCATION_TYPE_LOOKUP_CODE,

Line 999: IF NOT pnt_locations_pkg.validate_gross_area

995:
996: ELSIF loc.LOCATION_TYPE_LOOKUP_CODE in ('BUILDING', 'LAND') AND
997: loc.GROSS_AREA IS NOT NULL THEN
998:
999: IF NOT pnt_locations_pkg.validate_gross_area
1000: (p_loc_id => loc.LOCATION_ID,
1001: p_area => nvl(loc.GROSS_AREA,0),
1002: p_lkp_code => loc.LOCATION_TYPE_LOOKUP_CODE,
1003: p_act_str_dt => l_active_start_date,

Line 1139: PNT_LOCATIONS_PKG.correct_update_row

1135:
1136: put_log( 'U: Just before Correct/Update');
1137:
1138: --Used trunc() :Bug 6009957
1139: PNT_LOCATIONS_PKG.correct_update_row
1140: ( p_pn_locations_rec => l_pn_locations_rec,
1141: p_pn_addresses_rec => l_pn_addresses_rec,
1142: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1143: p_as_of_date => loc.change_date,

Line 1315: PNT_LOCATIONS_PKG.correct_update_row

1311: end if;
1312: end if;
1313:
1314: put_log( 'R: Just before Correct/Update');
1315: PNT_LOCATIONS_PKG.correct_update_row
1316: ( p_pn_locations_rec => l_pn_locations_rec,
1317: p_pn_addresses_rec => l_pn_addresses_rec,
1318: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1319: p_as_of_date => loc.change_date,