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 PNP_UTIL_FUNC

Line 124: | in call to pnp_util_func.get_allocated_area

120: | 3079433. Changed 'IF' condition for calling
121: | validate_gross_area in 'COrrect' and 'Update'
122: | mode.
123: | 07-JAN-04 Daniel Thota o Added OUT param l_total_allocated_area_pct
124: | in call to pnp_util_func.get_allocated_area
125: | bug # 3354278
126: | 01-APR-05 piagrawa o Modified the signature to include org_id,
127: | Modified the select statements to retrieve values
128: | from _ALL tables and in INSERT_ROW call passed

Line 236: if (NOT PNP_UTIL_FUNC.valid_lookup_code(

232: put_log('Validate Location Type Lookup_Code');
233: --------------------------------------
234: -- Validate Location Type Lookup_Code
235: --------------------------------------
236: if (NOT PNP_UTIL_FUNC.valid_lookup_code(
237: 'PN_LOCATION_TYPE', loc.LOCATION_TYPE_LOOKUP_CODE)) then
238: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_TYPE');
239: fnd_message.set_token('LOCATION_ID', loc.location_id);
240: l_error_message := fnd_message.get;

Line 291: NOT PNP_UTIL_FUNC.valid_lookup_code(

287: -- Validate Space Type Lookup_Code
288: --------------------------------------
289: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('OFFICE','FLOOR' )) THEN
290: if (loc.SPACE_TYPE_LOOKUP_CODE is NOT NULL and
291: NOT PNP_UTIL_FUNC.valid_lookup_code(
292: 'PN_SPACE_TYPE', loc.SPACE_TYPE_LOOKUP_CODE)) then
293: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TYPE');
294: fnd_message.set_token('LOCATION_ID', loc.location_id);
295: l_error_message := fnd_message.get;

Line 306: NOT PNP_UTIL_FUNC.valid_lookup_code(

302: -- Validate Parcel Type Lookup_Code
303: --------------------------------------
304: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION' )) THEN
305: if (loc.SPACE_TYPE_LOOKUP_CODE is NOT NULL and
306: NOT PNP_UTIL_FUNC.valid_lookup_code(
307: 'PN_PARCEL_TYPE', loc.SPACE_TYPE_LOOKUP_CODE)) then
308: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TYPE');
309: fnd_message.set_token('LOCATION_ID', loc.location_id);
310: l_error_message := fnd_message.get;

Line 321: NOT PNP_UTIL_FUNC.valid_lookup_code(

317: -- Validate Function Type Lookup_Code
318: --------------------------------------
319: IF (loc.LOCATION_TYPE_LOOKUP_CODE IN ('PARCEL','SECTION','FLOOR','OFFICE' )) THEN
320: if (loc.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL and
321: NOT PNP_UTIL_FUNC.valid_lookup_code(
322: 'PN_FUNCTION_TYPE', loc.FUNCTION_TYPE_LOOKUP_CODE)) then
323: fnd_message.set_name('PN', 'PN_CAFM_FUNCTION_TYPE');
324: fnd_message.set_token('LOCATION_ID', loc.location_id);
325: l_error_message := fnd_message.get;

Line 336: NOT PNP_UTIL_FUNC.valid_lookup_code(

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);
340: l_error_message := fnd_message.get;

Line 473: if (NOT PNP_UTIL_FUNC.valid_lookup_code(

469: if (loc.ENTRY_TYPE IN ('A', 'U')) then
470: loc.LEASE_OR_OWNED := 'L';
471: end if;
472: else
473: if (NOT PNP_UTIL_FUNC.valid_lookup_code(
474: 'PN_LEASED_OR_OWNED', loc.LEASE_OR_OWNED)) then
475: fnd_message.set_name('PN', 'PN_CAFM_LEASE_OR_OWNED');
476: fnd_message.set_token('LOCATION_ID', loc.location_id);
477: l_error_message := fnd_message.get;

Line 491: if (NOT PNP_UTIL_FUNC.valid_country_code(loc.COUNTRY)) then

487: if (loc.ENTRY_TYPE IN ('A', 'U')) then
488: loc.COUNTRY := fnd_profile.value('DEFAULT_COUNTRY');
489: end if;
490: else
491: if (NOT PNP_UTIL_FUNC.valid_country_code(loc.COUNTRY)) then
492: fnd_message.set_name('PN', 'PN_CAFM_COUNTRY');
493: fnd_message.set_token('LOCATION_ID', loc.location_id);
494: l_error_message := fnd_message.get;
495: raise INVALID_RECORD;

Line 594: if (NOT PNP_UTIL_FUNC.valid_lookup_code(

590: put_log('Validate SOURCE');
591: --------------------------------------
592: -- Validate SOURCE
593: --------------------------------------
594: if (NOT PNP_UTIL_FUNC.valid_lookup_code(
595: 'PN_SOURCE', loc.SOURCE)) then
596: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SOURCE');
597: fnd_message.set_token('LOCATION_ID', loc.location_id);
598: l_error_message := fnd_message.get;

Line 906: PNP_UTIL_FUNC.exist_tenancy_for_start_date

902: ------------------------------------------------------------
903: IF loc.new_active_start_date IS NOT NULL THEN
904: --Used trunc() :Bug 6009957
905: IF (trunc(loc.new_active_start_date) > trunc(v_loc_rec.active_start_date)) AND
906: PNP_UTIL_FUNC.exist_tenancy_for_start_date
907: (loc.location_id,
908: trunc(loc.new_active_start_date)) THEN
909: -- set msg based on loc type
910: IF loc.location_type_lookup_code IN ('OFFICE', 'SECTION') THEN

Line 923: PNP_UTIL_FUNC.exist_tenancy_for_end_date

919:
920: IF loc.new_active_end_date IS NOT NULL THEN
921: --Used trunc() :Bug 6009957
922: IF (trunc(loc.new_active_end_date) < trunc(v_loc_rec.active_end_date)) AND
923: PNP_UTIL_FUNC.exist_tenancy_for_end_date
924: (loc.location_id,
925: trunc(loc.new_active_end_date)) THEN
926: -- set msg based on loc type
927: IF loc.location_type_lookup_code IN ('OFFICE', 'SECTION') THEN

Line 1020: PNP_UTIL_FUNC.get_space_assigned_status(

1016: -- Validating if Assignments exist for making Assignable area Common
1017: --------------------------------------------------------------------
1018: IF ( NVL(loc.common_area_flag,'N') = 'Y' AND
1019: NVL(v_loc_rec.common_area_flag,'N') = 'N' AND
1020: PNP_UTIL_FUNC.get_space_assigned_status(
1021: v_loc_rec.location_id,
1022: l_active_start_date))
1023: THEN
1024: fnd_message.set_name('PN', 'PN_ASSIGNMENTS_EXIST');

Line 1659: | 01-DEC-05 pikhar o passed org_id in pnp_util_func.get_cc_code and

1655: | Procedure PN_SPACE_ASSIGN_EMP.INSERT_ROW and
1656: | Procedure PN_SPACE_ASSIGN_EMP.UPDATE_ROW
1657: | 23-NOV-05 Hareesha o Modified get_profile_value to include org_id as
1658: | parameter.
1659: | 01-DEC-05 pikhar o passed org_id in pnp_util_func.get_cc_code and
1660: | o pnp_util_func.valid_cost_center
1661: | 31-Aug-06 Prabhakaro Bug #5449595 Validated project_id and task_id
1662: | and if valid,Added project_id and task_id
1663: | in insert_row and upate_row

Line 1660: | o pnp_util_func.valid_cost_center

1656: | Procedure PN_SPACE_ASSIGN_EMP.UPDATE_ROW
1657: | 23-NOV-05 Hareesha o Modified get_profile_value to include org_id as
1658: | parameter.
1659: | 01-DEC-05 pikhar o passed org_id in pnp_util_func.get_cc_code and
1660: | o pnp_util_func.valid_cost_center
1661: | 31-Aug-06 Prabhakaro Bug #5449595 Validated project_id and task_id
1662: | and if valid,Added project_id and task_id
1663: | in insert_row and upate_row
1664: | 11-OCT-06 acprakas o Bug#5587012. Passed location_id to procedure

Line 1665: | PNP_UTIL_FUNC.Validate_date_for_assignments instead

1661: | 31-Aug-06 Prabhakaro Bug #5449595 Validated project_id and task_id
1662: | and if valid,Added project_id and task_id
1663: | in insert_row and upate_row
1664: | 11-OCT-06 acprakas o Bug#5587012. Passed location_id to procedure
1665: | PNP_UTIL_FUNC.Validate_date_for_assignments instead
1666: | of EMP_SPACE_ASSIGN_ID.
1667: | 08-NOV-06 lbala o Bug#5636783.Added Commit prior to END LOOP and
1668: | SAVEPOINT S2.Added code in exception block for WHEN
1669: | OTHERS to update errored record count.

Line 1795: if (NOT PNP_UTIL_FUNC.valid_lookup_code( 'PN_SOURCE', space.SOURCE)) then

1791: put_log('Validate Source');
1792: --------------------------------------
1793: -- Validate SOURCE
1794: --------------------------------------
1795: if (NOT PNP_UTIL_FUNC.valid_lookup_code( 'PN_SOURCE', space.SOURCE)) then
1796: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SOURCE');
1797: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);
1798: l_error_message := fnd_message.get;
1799: raise INVALID_RECORD;

Line 1806: if (NOT PNP_UTIL_FUNC.valid_location(space.LOCATION_ID)) then

1802: put_log('Validate Location_Id');
1803: --------------------------------------
1804: -- Validate LOCATION_ID
1805: --------------------------------------
1806: if (NOT PNP_UTIL_FUNC.valid_location(space.LOCATION_ID)) then
1807: fnd_message.set_name('PN', 'PN_CAFM_SPACE_INVALID_LOCATION');
1808: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);
1809: l_error_message := fnd_message.get;
1810: raise INVALID_RECORD;

Line 1848: if (NOT PNP_UTIL_FUNC.valid_employee(space.employee_id)) then

1844: --------------------------------------
1845: if (space.employee_id is NOT NULL) and
1846: (space.COST_CENTER_CODE is NOT NULL) then
1847:
1848: if (NOT PNP_UTIL_FUNC.valid_employee(space.employee_id)) then
1849: fnd_message.set_name('PN', 'PN_CAFM_SPACE_EMP_ID_CC_CODE3B');
1850: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);
1851: fnd_message.set_token('PERSON_ID', space.employee_id);
1852: l_error_message := fnd_message.get;

Line 1855: if (NOT PNP_UTIL_FUNC.valid_cost_center(space.COST_CENTER_CODE,l_org_id)) then

1851: fnd_message.set_token('PERSON_ID', space.employee_id);
1852: l_error_message := fnd_message.get;
1853: end if;
1854:
1855: if (NOT PNP_UTIL_FUNC.valid_cost_center(space.COST_CENTER_CODE,l_org_id)) then
1856: fnd_message.set_name('PN', 'PN_CAFM_SPACE_EMP_ID_CC_CODE_4');
1857: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);
1858: fnd_message.set_token('COST_CENTER_CODE', space.cost_center_code);
1859: l_error_message := fnd_message.get;

Line 1872: if (PNP_UTIL_FUNC.valid_employee(space.employee_id)) then

1868: -- Situation (3) above.
1869: --------------------------------------
1870: if (space.employee_id is NOT NULL) and
1871: (space.COST_CENTER_CODE is NULL) then
1872: if (PNP_UTIL_FUNC.valid_employee(space.employee_id)) then
1873: space.COST_CENTER_CODE := PNP_UTIL_FUNC.get_cc_code(space.employee_id,l_org_id);
1874: Put_Log('Cost_Center_Code of Employee: ' || space.COST_CENTER_CODE);
1875: if (space.COST_CENTER_CODE is NULL) then
1876: fnd_message.set_name('PN', 'PN_CAFM_SPACE_EMP_ID_CC_CODE3A');

Line 1873: space.COST_CENTER_CODE := PNP_UTIL_FUNC.get_cc_code(space.employee_id,l_org_id);

1869: --------------------------------------
1870: if (space.employee_id is NOT NULL) and
1871: (space.COST_CENTER_CODE is NULL) then
1872: if (PNP_UTIL_FUNC.valid_employee(space.employee_id)) then
1873: space.COST_CENTER_CODE := PNP_UTIL_FUNC.get_cc_code(space.employee_id,l_org_id);
1874: Put_Log('Cost_Center_Code of Employee: ' || space.COST_CENTER_CODE);
1875: if (space.COST_CENTER_CODE is NULL) then
1876: fnd_message.set_name('PN', 'PN_CAFM_SPACE_EMP_ID_CC_CODE3A');
1877: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);

Line 1897: if (NOT PNP_UTIL_FUNC.valid_cost_center(space.COST_CENTER_CODE,l_org_id)) then

1893: -- Situation (4) above.
1894: --------------------------------------
1895: if (space.employee_id is NULL) and
1896: ( space.COST_CENTER_CODE is NOT NULL) then
1897: if (NOT PNP_UTIL_FUNC.valid_cost_center(space.COST_CENTER_CODE,l_org_id)) then
1898: fnd_message.set_name('PN', 'PN_CAFM_SPACE_EMP_ID_CC_CODE_4');
1899: fnd_message.set_token('SPACE_ALLOCATION_ID', space.EMP_SPACE_ASSIGN_ID);
1900: fnd_message.set_token('COST_CENTER_CODE', space.cost_center_code);
1901: l_error_message := fnd_message.get;

Line 1951: pnp_util_func.get_location_type_lookup_code(

1947: -- Check if Allocated_Area is NULL for manual space distribution
1948: ----------------------------------------------------------------
1949: If (space.allocated_area is NULL) AND
1950: (space.entry_type IN ('A','U')) AND
1951: pnp_util_func.get_location_type_lookup_code(
1952: p_location_id => space.location_id,
1953: p_as_of_date => space.emp_assign_start_date) IN ('OFFICE','SECTION')
1954: Then
1955: fnd_message.set_name('PN', 'PN_CAFM_SPACE_NULL_AREA');

Line 1962: pnp_util_func.get_location_type_lookup_code(

1958: raise INVALID_RECORD;
1959:
1960: Elsif (space.allocated_area IS NOT NULL) AND
1961: (space.entry_type IN ('A','U')) AND
1962: pnp_util_func.get_location_type_lookup_code(
1963: p_location_id => space.location_id,
1964: p_as_of_date => space.emp_assign_start_date) NOT IN ('OFFICE','SECTION')
1965: Then
1966: fnd_message.set_name('PN', 'PN_CAFM_SPACE_NOT_NULL_AREA');

Line 1988: put_log('* Calling PNP_UTIL_FUNC.validate_vacant_area *');

1984: l_emp_assign_start_date := NVL(space.emp_assign_start_date, NVL( space.change_date, SYSDATE ));
1985: end if;
1986:
1987:
1988: put_log('*** Calling PNP_UTIL_FUNC.validate_vacant_area ***');
1989: PNP_UTIL_FUNC.validate_vacant_area( p_location_id => space.Location_Id,
1990: p_st_date => l_emp_assign_start_date,
1991: p_end_dt => space.emp_assign_end_date,
1992: p_assignable_area => l_assignable_area,

Line 1989: PNP_UTIL_FUNC.validate_vacant_area( p_location_id => space.Location_Id,

1985: end if;
1986:
1987:
1988: put_log('*** Calling PNP_UTIL_FUNC.validate_vacant_area ***');
1989: PNP_UTIL_FUNC.validate_vacant_area( p_location_id => space.Location_Id,
1990: p_st_date => l_emp_assign_start_date,
1991: p_end_dt => space.emp_assign_end_date,
1992: p_assignable_area => l_assignable_area,
1993: p_old_allocated_area => l_old_allocated_area,

Line 2000: put_log('* DONE PNP_UTIL_FUNC.validate_vacant_area *');

1996: p_new_allocated_area_pct => NULL,
1997: p_display_message => 'Y',
1998: p_future => l_future,
1999: p_available_vacant_area => l_available_vacant_area );
2000: put_log('*** DONE PNP_UTIL_FUNC.validate_vacant_area ***');
2001:
2002: IF (l_assignable_area = -99) THEN
2003: l_error_message := fnd_message.get;
2004: raise INVALID_RECORD;

Line 2085: PNP_UTIL_FUNC.Validate_date_for_assignments (

2081: put_log('Additional entry type');
2082:
2083: space.EMP_SPACE_ASSIGN_ID := NULL;
2084:
2085: PNP_UTIL_FUNC.Validate_date_for_assignments (
2086: p_location_id => space.LOCATION_ID, --Bug#5587012
2087: p_start_date => space.emp_assign_start_date,
2088: p_end_date => space.emp_assign_end_date,
2089: x_return_status => l_return_status,

Line 2169: PNP_UTIL_FUNC.Validate_date_for_assignments (

2165: End if;
2166:
2167: If (space.ENTRY_TYPE = 'U' ) Then
2168:
2169: PNP_UTIL_FUNC.Validate_date_for_assignments (
2170: p_location_id => space.LOCATION_ID, --Bug#5587012
2171: p_start_date => space.emp_assign_start_date,
2172: p_end_date => space.emp_assign_end_date,
2173: x_return_status => l_return_status,

Line 2232: PNP_UTIL_FUNC.Validate_date_for_assignments (

2228: -- Replace Data in PN_SPACE_ALLOCATIONS
2229: --------------------------------------
2230: if (space.ENTRY_TYPE = 'R') then
2231:
2232: PNP_UTIL_FUNC.Validate_date_for_assignments (
2233: p_location_id =>NVL(space.LOCATION_ID,tlempinfo.LOCATION_ID), --Bug#5587012
2234: p_start_date =>NVL(space.EMP_ASSIGN_START_DATE,tlempinfo.EMP_ASSIGN_START_DATE),
2235: p_end_date =>NVL(space.EMP_ASSIGN_START_DATE,tlempinfo.EMP_ASSIGN_START_DATE),
2236: x_return_status => l_return_status,