DBA Data[Home] [Help]

APPS.HXC_ATC_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: --
98: hxc_atc_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: --
98: hxc_atc_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: --
103: hxc_atc_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: --
98: hxc_atc_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: --
103: hxc_atc_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: --
103: hxc_atc_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: --
108: hxc_atc_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: --
103: hxc_atc_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: --
108: hxc_atc_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: --
108: hxc_atc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: --
112: Raise;
113: End update_dml;

Line 236: when hr_api.cannot_find_prog_unit then

232: hxc_time_category_utils_pkg.alias_type_comp_ref_int_chk ( p_rec.alias_type_id );
233:
234: exception
235: --
236: when hr_api.cannot_find_prog_unit then
237: --
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'HXC_ALIAS_TYPE_COMPONENTS'
240: ,p_hook_type => 'AU');

Line 238: hr_api.cannot_find_prog_unit_error

234: exception
235: --
236: when hr_api.cannot_find_prog_unit then
237: --
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'HXC_ALIAS_TYPE_COMPONENTS'
240: ,p_hook_type => 'AU');
241: --
242: end;

Line 303: If (p_rec.component_name = hr_api.g_varchar2) then

299: -- p_rec plsql record structure
300: -- to see if a system default is being used. If a system default
301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.component_name = hr_api.g_varchar2) then
304: p_rec.component_name :=
305: hxc_atc_shd.g_old_rec.component_name;
306: End If;
307: If (p_rec.component_type = hr_api.g_varchar2) then

Line 307: If (p_rec.component_type = hr_api.g_varchar2) then

303: If (p_rec.component_name = hr_api.g_varchar2) then
304: p_rec.component_name :=
305: hxc_atc_shd.g_old_rec.component_name;
306: End If;
307: If (p_rec.component_type = hr_api.g_varchar2) then
308: p_rec.component_type :=
309: hxc_atc_shd.g_old_rec.component_type;
310: End If;
311: If (p_rec.mapping_component_id = hr_api.g_number) then

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

307: If (p_rec.component_type = hr_api.g_varchar2) then
308: p_rec.component_type :=
309: hxc_atc_shd.g_old_rec.component_type;
310: End If;
311: If (p_rec.mapping_component_id = hr_api.g_number) then
312: p_rec.mapping_component_id :=
313: hxc_atc_shd.g_old_rec.mapping_component_id;
314: End If;
315: If (p_rec.alias_type_id = hr_api.g_number) then

Line 315: If (p_rec.alias_type_id = hr_api.g_number) then

311: If (p_rec.mapping_component_id = hr_api.g_number) then
312: p_rec.mapping_component_id :=
313: hxc_atc_shd.g_old_rec.mapping_component_id;
314: End If;
315: If (p_rec.alias_type_id = hr_api.g_number) then
316: p_rec.alias_type_id :=
317: hxc_atc_shd.g_old_rec.alias_type_id;
318: End If;
319: --

Line 383: ,p_component_name in varchar2 default hr_api.g_varchar2

379: -- ----------------------------------------------------------------------------
380: Procedure upd
381: (p_alias_type_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_component_name in varchar2 default hr_api.g_varchar2
384: ,p_component_type in varchar2 default hr_api.g_varchar2
385: ,p_mapping_component_id in number default hr_api.g_number
386: ,p_alias_type_id in number default hr_api.g_number
387: ) is

Line 384: ,p_component_type in varchar2 default hr_api.g_varchar2

380: Procedure upd
381: (p_alias_type_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_component_name in varchar2 default hr_api.g_varchar2
384: ,p_component_type in varchar2 default hr_api.g_varchar2
385: ,p_mapping_component_id in number default hr_api.g_number
386: ,p_alias_type_id in number default hr_api.g_number
387: ) is
388: --

Line 385: ,p_mapping_component_id in number default hr_api.g_number

381: (p_alias_type_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_component_name in varchar2 default hr_api.g_varchar2
384: ,p_component_type in varchar2 default hr_api.g_varchar2
385: ,p_mapping_component_id in number default hr_api.g_number
386: ,p_alias_type_id in number default hr_api.g_number
387: ) is
388: --
389: l_rec hxc_atc_shd.g_rec_type;

Line 386: ,p_alias_type_id in number default hr_api.g_number

382: ,p_object_version_number in out nocopy number
383: ,p_component_name in varchar2 default hr_api.g_varchar2
384: ,p_component_type in varchar2 default hr_api.g_varchar2
385: ,p_mapping_component_id in number default hr_api.g_number
386: ,p_alias_type_id in number default hr_api.g_number
387: ) is
388: --
389: l_rec hxc_atc_shd.g_rec_type;
390: l_proc varchar2(72);