APPS.HXC_ULA_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
101: hxc_ula_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
101: hxc_ula_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
106: hxc_ula_shd.constraint_error

Line 103: When hr_api.parent_integrity_violated Then

99: -- A check constraint has been violated
100: --
101: hxc_ula_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
106: hxc_ula_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
106: hxc_ula_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: hxc_ula_shd.constraint_error

Line 108: When hr_api.unique_integrity_violated Then

104: -- Parent integrity has been violated
105: --
106: hxc_ula_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: hxc_ula_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: hxc_ula_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: --
115: Raise;
116: End update_dml;

Line 246: when hr_api.cannot_find_prog_unit then

242: );
243: --
244: exception
245: --
246: when hr_api.cannot_find_prog_unit then
247: --
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'HXC_LAYOUTS'
250: ,p_hook_type => 'AU');

Line 248: hr_api.cannot_find_prog_unit_error

244: exception
245: --
246: when hr_api.cannot_find_prog_unit then
247: --
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'HXC_LAYOUTS'
250: ,p_hook_type => 'AU');
251: --
252: end;

Line 313: If (p_rec.layout_name = hr_api.g_varchar2) then

309: -- p_rec plsql record structure
310: -- to see if a system default is being used. If a system default
311: -- is being used then we must set to the 'current' argument value.
312: --
313: If (p_rec.layout_name = hr_api.g_varchar2) then
314: p_rec.layout_name :=
315: hxc_ula_shd.g_old_rec.layout_name;
316: End If;
317: If (p_rec.application_id = hr_api.g_number) then

Line 317: If (p_rec.application_id = hr_api.g_number) then

313: If (p_rec.layout_name = hr_api.g_varchar2) then
314: p_rec.layout_name :=
315: hxc_ula_shd.g_old_rec.layout_name;
316: End If;
317: If (p_rec.application_id = hr_api.g_number) then
318: p_rec.application_id :=
319: hxc_ula_shd.g_old_rec.application_id;
320: End If;
321: If (p_rec.layout_type = hr_api.g_varchar2) then

Line 321: If (p_rec.layout_type = hr_api.g_varchar2) then

317: If (p_rec.application_id = hr_api.g_number) then
318: p_rec.application_id :=
319: hxc_ula_shd.g_old_rec.application_id;
320: End If;
321: If (p_rec.layout_type = hr_api.g_varchar2) then
322: p_rec.layout_type :=
323: hxc_ula_shd.g_old_rec.layout_type;
324: End If;
325: If (p_rec.modifier_level = hr_api.g_varchar2) then

Line 325: If (p_rec.modifier_level = hr_api.g_varchar2) then

321: If (p_rec.layout_type = hr_api.g_varchar2) then
322: p_rec.layout_type :=
323: hxc_ula_shd.g_old_rec.layout_type;
324: End If;
325: If (p_rec.modifier_level = hr_api.g_varchar2) then
326: p_rec.modifier_level :=
327: hxc_ula_shd.g_old_rec.modifier_level;
328: End If;
329: If (p_rec.modifier_value = hr_api.g_varchar2) then

Line 329: If (p_rec.modifier_value = hr_api.g_varchar2) then

325: If (p_rec.modifier_level = hr_api.g_varchar2) then
326: p_rec.modifier_level :=
327: hxc_ula_shd.g_old_rec.modifier_level;
328: End If;
329: If (p_rec.modifier_value = hr_api.g_varchar2) then
330: p_rec.modifier_value :=
331: hxc_ula_shd.g_old_rec.modifier_value;
332: End If;
333: If (p_rec.top_level_region_code = hr_api.g_varchar2) then

Line 333: If (p_rec.top_level_region_code = hr_api.g_varchar2) then

329: If (p_rec.modifier_value = hr_api.g_varchar2) then
330: p_rec.modifier_value :=
331: hxc_ula_shd.g_old_rec.modifier_value;
332: End If;
333: If (p_rec.top_level_region_code = hr_api.g_varchar2) then
334: p_rec.top_level_region_code :=
335: hxc_ula_shd.g_old_rec.top_level_region_code;
336: End If;
337: --

Line 395: ,p_layout_name in varchar2 default hr_api.g_varchar2

391: -- ----------------------------------------------------------------------------
392: Procedure upd
393: (p_layout_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_layout_name in varchar2 default hr_api.g_varchar2
396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2

Line 396: ,p_application_id in number default hr_api.g_number

392: Procedure upd
393: (p_layout_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_layout_name in varchar2 default hr_api.g_varchar2
396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2

Line 397: ,p_layout_type in varchar2 default hr_api.g_varchar2

393: (p_layout_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_layout_name in varchar2 default hr_api.g_varchar2
396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2
401: ) is

Line 398: ,p_modifier_level in varchar2 default hr_api.g_varchar2

394: ,p_object_version_number in out nocopy number
395: ,p_layout_name in varchar2 default hr_api.g_varchar2
396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2
401: ) is
402: --

Line 399: ,p_modifier_value in varchar2 default hr_api.g_varchar2

395: ,p_layout_name in varchar2 default hr_api.g_varchar2
396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2
401: ) is
402: --
403: l_rec hxc_ula_shd.g_rec_type;

Line 400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2

396: ,p_application_id in number default hr_api.g_number
397: ,p_layout_type in varchar2 default hr_api.g_varchar2
398: ,p_modifier_level in varchar2 default hr_api.g_varchar2
399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2
401: ) is
402: --
403: l_rec hxc_ula_shd.g_rec_type;
404: l_proc varchar2(72) ;