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.PER_PCL_BUS dependencies on HR_API

Line 272: hr_api.mandatory_arg_error

268: hr_utility.set_location('Entering:'|| l_proc, 10);
269: --
270: -- Ensure that all the mandatory parameter are not null
271: --
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc
274: ,p_argument => 'cagr_entitlement_line_id'
275: ,p_argument_value => p_cagr_entitlement_line_id
276: );

Line 295: hr_api.set_security_group_id

291: close csr_sec_grp;
292: --
293: -- Set the security_group_id in CLIENT_INFO
294: --
295: hr_api.set_security_group_id
296: (p_security_group_id => l_security_group_id
297: );
298: --
299: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 340: hr_api.mandatory_arg_error

336: hr_utility.set_location('Entering:'|| l_proc, 10);
337: --
338: -- Ensure that all the mandatory parameter are not null
339: --
340: hr_api.mandatory_arg_error
341: (p_api_name => l_proc
342: ,p_argument => 'cagr_entitlement_line_id'
343: ,p_argument_value => p_cagr_entitlement_line_id
344: );

Line 346: if ( nvl(per_pcl_bus.g_cagr_entitlement_line_id, hr_api.g_number)

342: ,p_argument => 'cagr_entitlement_line_id'
343: ,p_argument_value => p_cagr_entitlement_line_id
344: );
345: --
346: if ( nvl(per_pcl_bus.g_cagr_entitlement_line_id, hr_api.g_number)
347: = p_cagr_entitlement_line_id) then
348: --
349: -- The legislation code has already been found with a previous
350: -- call to this function. Just return the value in the global

Line 437: IF nvl(p_rec.cagr_entitlement_id, hr_api.g_number) <>

433: fnd_message.raise_error;
434: END IF;
435:
436:
437: IF nvl(p_rec.cagr_entitlement_id, hr_api.g_number) <>
438: nvl(per_pcl_shd.g_old_rec.cagr_entitlement_id,hr_api.g_number) THEN
439: --
440: l_argument := 'cagr_entitlement_id';
441: RAISE l_error;

Line 438: nvl(per_pcl_shd.g_old_rec.cagr_entitlement_id,hr_api.g_number) THEN

434: END IF;
435:
436:
437: IF nvl(p_rec.cagr_entitlement_id, hr_api.g_number) <>
438: nvl(per_pcl_shd.g_old_rec.cagr_entitlement_id,hr_api.g_number) THEN
439: --
440: l_argument := 'cagr_entitlement_id';
441: RAISE l_error;
442: --

Line 447: hr_api.argument_changed_error

443: END IF;
444:
445: EXCEPTION
446: WHEN l_error THEN
447: hr_api.argument_changed_error
448: (p_api_name => l_proc
449: ,p_argument => l_argument);
450: WHEN OTHERS THEN
451: RAISE;

Line 524: IF hr_api.not_exists_in_dt_hr_lookups

520: hr_utility.set_location(l_proc, 20);
521: --
522: -- Check that the type exists in HR_LOOKUPS
523: --
524: IF hr_api.not_exists_in_dt_hr_lookups
525: (p_effective_date => p_effective_date
526: ,p_lookup_type => 'YES_NO'
527: ,p_lookup_code => p_mandatory
528: ,p_validation_start_date => p_validation_start_date

Line 611: hr_api.mandatory_arg_error

607: hr_utility.set_location('Entering:'||l_proc, 10);
608: --
609: -- Check mandatory parameters has been set
610: --
611: hr_api.mandatory_arg_error
612: (p_api_name => l_proc
613: ,p_argument => 'CAGR_ENTITLEMENT_ITEM_ID'
614: ,p_argument_value => p_cagr_entitlement_item_id);
615: --

Line 641: hr_api.mandatory_arg_error

637: --
638: -- Check value has been populated as it should
639: -- now contain a value.
640: --
641: hr_api.mandatory_arg_error
642: (p_api_name => l_proc
643: ,p_argument => 'VALUE'
644: ,p_argument_value => p_value);
645: --

Line 783: hr_api.mandatory_arg_error

779: hr_utility.set_location('Entering:'||l_proc, 10);
780: --
781: -- Check mandatory parameters has been set
782: --
783: hr_api.mandatory_arg_error
784: (p_api_name => l_proc
785: ,p_argument => 'CAGR_ENTITLEMENT_ITEM_ID'
786: ,p_argument_value => p_cagr_entitlement_item_id);
787: --

Line 947: hr_api.mandatory_arg_error

943: hr_utility.set_location('Entering:'||l_proc, 10);
944: --
945: -- Check mandatory parameters has been set
946: --
947: hr_api.mandatory_arg_error
948: (p_api_name => l_proc
949: ,p_argument => 'CAGR_ENTITLEMENT_ITEM_ID'
950: ,p_argument_value => p_cagr_entitlement_item_id);
951: --

Line 1138: hr_api.mandatory_arg_error

1134: IF (l_cat = 'PYS') then
1135:
1136: -- Check if parent_spine_id is not null
1137:
1138: hr_api.mandatory_arg_error
1139: (p_api_name => l_proc
1140: ,p_argument => 'grade_spine_id'
1141: ,p_argument_value => p_grade_spine_id);
1142:

Line 1265: hr_api.mandatory_arg_error

1261: IF (l_cat = 'PYS') then
1262:
1263: -- Check if parent_spine_id is not null
1264:
1265: hr_api.mandatory_arg_error
1266: (p_api_name => l_proc
1267: ,p_argument => 'parent_spine_id'
1268: ,p_argument_value => p_parent_spine_id);
1269:

Line 1373: IF hr_api.not_exists_in_dt_hr_lookups

1369: --
1370: -- Check that the type exists in HR_LOOKUPS
1371: --
1372:
1373: IF hr_api.not_exists_in_dt_hr_lookups
1374: (p_effective_date => p_effective_date
1375: ,p_lookup_type => 'CAGR_STATUS'
1376: ,p_lookup_code => p_status
1377: ,p_validation_start_date => p_validation_start_date

Line 1637: hr_api.mandatory_arg_error

1633: hr_utility.set_location('Entering:'||l_proc, 10);
1634: --
1635: -- Check mandatory parameters has been set
1636: --
1637: hr_api.mandatory_arg_error
1638: (p_api_name => l_proc
1639: ,p_argument => 'ELIGY_PRFL_ID'
1640: ,p_argument_value => p_eligy_prfl_id);
1641: --

Line 1642: hr_api.mandatory_arg_error

1638: (p_api_name => l_proc
1639: ,p_argument => 'ELIGY_PRFL_ID'
1640: ,p_argument_value => p_eligy_prfl_id);
1641: --
1642: hr_api.mandatory_arg_error
1643: (p_api_name => l_proc
1644: ,p_argument => 'CATEGORY_NAME'
1645: ,p_argument_value => p_category_name);
1646: --

Line 1813: hr_api.mandatory_arg_error

1809:
1810: IF (l_cat = 'PYS') then
1811:
1812: -- Check if step_id is not null
1813: hr_api.mandatory_arg_error
1814: (p_api_name => l_proc
1815: ,p_argument => 'step_id'
1816: ,p_argument_value => p_step_id);
1817:

Line 1911: hr_api.mandatory_arg_error

1907: hr_utility.set_location('Entering:'||l_proc, 1);
1908: --
1909: -- Check mandatory parameters have been set
1910: --
1911: hr_api.mandatory_arg_error
1912: (p_api_name => l_proc
1913: ,p_argument => 'object_version_number'
1914: ,p_argument_value => p_object_version_number
1915: );

Line 1954: (p_grade_spine_id in number default hr_api.g_number

1950: --
1951: -- {End Of Comments}
1952: -- ----------------------------------------------------------------------------
1953: Procedure dt_update_validate
1954: (p_grade_spine_id in number default hr_api.g_number
1955: ,p_step_id in number default hr_api.g_number
1956: ,p_from_step_id in number default hr_api.g_number
1957: ,p_to_step_id in number default hr_api.g_number
1958: ,p_datetrack_mode in varchar2

Line 1955: ,p_step_id in number default hr_api.g_number

1951: -- {End Of Comments}
1952: -- ----------------------------------------------------------------------------
1953: Procedure dt_update_validate
1954: (p_grade_spine_id in number default hr_api.g_number
1955: ,p_step_id in number default hr_api.g_number
1956: ,p_from_step_id in number default hr_api.g_number
1957: ,p_to_step_id in number default hr_api.g_number
1958: ,p_datetrack_mode in varchar2
1959: ,p_validation_start_date in date

Line 1956: ,p_from_step_id in number default hr_api.g_number

1952: -- ----------------------------------------------------------------------------
1953: Procedure dt_update_validate
1954: (p_grade_spine_id in number default hr_api.g_number
1955: ,p_step_id in number default hr_api.g_number
1956: ,p_from_step_id in number default hr_api.g_number
1957: ,p_to_step_id in number default hr_api.g_number
1958: ,p_datetrack_mode in varchar2
1959: ,p_validation_start_date in date
1960: ,p_validation_end_date in date

Line 1957: ,p_to_step_id in number default hr_api.g_number

1953: Procedure dt_update_validate
1954: (p_grade_spine_id in number default hr_api.g_number
1955: ,p_step_id in number default hr_api.g_number
1956: ,p_from_step_id in number default hr_api.g_number
1957: ,p_to_step_id in number default hr_api.g_number
1958: ,p_datetrack_mode in varchar2
1959: ,p_validation_start_date in date
1960: ,p_validation_end_date in date
1961: ) Is

Line 1971: hr_api.mandatory_arg_error

1967: Begin
1968: --
1969: -- Ensure that the p_datetrack_mode argument is not null
1970: --
1971: hr_api.mandatory_arg_error
1972: (p_api_name => l_proc
1973: ,p_argument => 'datetrack_mode'
1974: ,p_argument_value => p_datetrack_mode
1975: );

Line 1981: hr_api.mandatory_arg_error

1977: -- Mode will be valid, as this is checked at the start of the upd.
1978: --
1979: -- Ensure the arguments are not null
1980: --
1981: hr_api.mandatory_arg_error
1982: (p_api_name => l_proc
1983: ,p_argument => 'validation_start_date'
1984: ,p_argument_value => p_validation_start_date
1985: );

Line 1987: hr_api.mandatory_arg_error

1983: ,p_argument => 'validation_start_date'
1984: ,p_argument_value => p_validation_start_date
1985: );
1986: --
1987: hr_api.mandatory_arg_error
1988: (p_api_name => l_proc
1989: ,p_argument => 'validation_end_date'
1990: ,p_argument_value => p_validation_end_date
1991: );

Line 1993: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and

1989: ,p_argument => 'validation_end_date'
1990: ,p_argument_value => p_validation_end_date
1991: );
1992: --
1993: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and
1994: NOT (dt_api.check_min_max_dates
1995: (p_base_table_name => 'per_grade_spines_f'
1996: ,p_base_key_column => 'GRADE_SPINE_ID'
1997: ,p_base_key_value => p_grade_spine_id

Line 2003: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and

1999: ,p_to_date => p_validation_end_date))) Then
2000: l_table_name := 'grade spines';
2001: raise l_integrity_error;
2002: End If;
2003: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and
2004: NOT (dt_api.check_min_max_dates
2005: (p_base_table_name => 'per_spinal_point_steps_f'
2006: ,p_base_key_column => 'STEP_ID'
2007: ,p_base_key_value => p_step_id

Line 2013: If ((nvl(p_from_step_id, hr_api.g_number) <> hr_api.g_number) and

2009: ,p_to_date => p_validation_end_date))) Then
2010: l_table_name := 'spinal point steps';
2011: raise l_integrity_error;
2012: End If;
2013: If ((nvl(p_from_step_id, hr_api.g_number) <> hr_api.g_number) and
2014: NOT (dt_api.check_min_max_dates
2015: (p_base_table_name => 'per_spinal_point_steps_f'
2016: ,p_base_key_column => 'STEP_ID'
2017: ,p_base_key_value => p_from_step_id

Line 2023: If ((nvl(p_to_step_id, hr_api.g_number) <> hr_api.g_number) and

2019: ,p_to_date => p_validation_end_date))) Then
2020: l_table_name := 'spinal point steps';
2021: raise l_integrity_error;
2022: End If;
2023: If ((nvl(p_to_step_id, hr_api.g_number) <> hr_api.g_number) and
2024: NOT (dt_api.check_min_max_dates
2025: (p_base_table_name => 'per_spinal_point_steps_f'
2026: ,p_base_key_column => 'STEP_ID'
2027: ,p_base_key_value => p_to_step_id

Line 2104: hr_api.mandatory_arg_error

2100: Begin
2101: --
2102: -- Ensure that the p_datetrack_mode argument is not null
2103: --
2104: hr_api.mandatory_arg_error
2105: (p_api_name => l_proc
2106: ,p_argument => 'datetrack_mode'
2107: ,p_argument_value => p_datetrack_mode
2108: );

Line 2113: If (p_datetrack_mode = hr_api.g_delete or

2109: --
2110: -- Only perform the validation if the datetrack mode is either
2111: -- DELETE or ZAP
2112: --
2113: If (p_datetrack_mode = hr_api.g_delete or
2114: p_datetrack_mode = hr_api.g_zap) then
2115: --
2116: --
2117: -- Ensure the arguments are not null

Line 2114: p_datetrack_mode = hr_api.g_zap) then

2110: -- Only perform the validation if the datetrack mode is either
2111: -- DELETE or ZAP
2112: --
2113: If (p_datetrack_mode = hr_api.g_delete or
2114: p_datetrack_mode = hr_api.g_zap) then
2115: --
2116: --
2117: -- Ensure the arguments are not null
2118: --

Line 2119: hr_api.mandatory_arg_error

2115: --
2116: --
2117: -- Ensure the arguments are not null
2118: --
2119: hr_api.mandatory_arg_error
2120: (p_api_name => l_proc
2121: ,p_argument => 'validation_start_date'
2122: ,p_argument_value => p_validation_start_date
2123: );

Line 2125: hr_api.mandatory_arg_error

2121: ,p_argument => 'validation_start_date'
2122: ,p_argument_value => p_validation_start_date
2123: );
2124: --
2125: hr_api.mandatory_arg_error
2126: (p_api_name => l_proc
2127: ,p_argument => 'validation_end_date'
2128: ,p_argument_value => p_validation_end_date
2129: );

Line 2131: hr_api.mandatory_arg_error

2127: ,p_argument => 'validation_end_date'
2128: ,p_argument_value => p_validation_end_date
2129: );
2130: --
2131: hr_api.mandatory_arg_error
2132: (p_api_name => l_proc
2133: ,p_argument => 'cagr_entitlement_line_id'
2134: ,p_argument_value => p_cagr_entitlement_line_id
2135: );