DBA Data[Home] [Help]

APPS.HXC_MCU_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: end if;
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
98: hxc_mcu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
98: hxc_mcu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
103: hxc_mcu_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
98: hxc_mcu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
103: hxc_mcu_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
103: hxc_mcu_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
108: hxc_mcu_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
103: hxc_mcu_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
108: hxc_mcu_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
108: hxc_mcu_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;

Line 230: when hr_api.cannot_find_prog_unit then

226: );
227: --
228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'HXC_MAPPING_COMP_USAGES'
234: ,p_hook_type => 'AU');

Line 232: hr_api.cannot_find_prog_unit_error

228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'HXC_MAPPING_COMP_USAGES'
234: ,p_hook_type => 'AU');
235: --
236: end;

Line 297: If (p_rec.mapping_component_id = hr_api.g_number) then

293: -- p_rec plsql record structure
294: -- to see if a system default is being used. If a system default
295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.mapping_component_id = hr_api.g_number) then
298: p_rec.mapping_component_id :=
299: hxc_mcu_shd.g_old_rec.mapping_component_id;
300: End If;
301: If (p_rec.mapping_id = hr_api.g_number) then

Line 301: If (p_rec.mapping_id = hr_api.g_number) then

297: If (p_rec.mapping_component_id = hr_api.g_number) then
298: p_rec.mapping_component_id :=
299: hxc_mcu_shd.g_old_rec.mapping_component_id;
300: End If;
301: If (p_rec.mapping_id = hr_api.g_number) then
302: p_rec.mapping_id :=
303: hxc_mcu_shd.g_old_rec.mapping_id;
304: End If;
305: --

Line 364: ,p_mapping_component_id in number default hr_api.g_number

360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_mapping_comp_usage_id in number
363: ,p_object_version_number in out nocopy number
364: ,p_mapping_component_id in number default hr_api.g_number
365: ,p_mapping_id in number default hr_api.g_number
366: ) is
367: --
368: l_rec hxc_mcu_shd.g_rec_type;

Line 365: ,p_mapping_id in number default hr_api.g_number

361: Procedure upd
362: (p_mapping_comp_usage_id in number
363: ,p_object_version_number in out nocopy number
364: ,p_mapping_component_id in number default hr_api.g_number
365: ,p_mapping_id in number default hr_api.g_number
366: ) is
367: --
368: l_rec hxc_mcu_shd.g_rec_type;
369: l_proc varchar2(72);