APPS.HXC_HTR_UPD dependencies on HR_API

Line 103: When hr_api.check_integrity_violated Then

99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: end if;
101: --
102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htr_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.check_integrity_violated Then
104: -- A check constraint has been violated
105: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htr_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htr_shd.constraint_error

Line 108: When hr_api.parent_integrity_violated Then

104: -- A check constraint has been violated
105: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htr_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htr_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.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htr_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_htr_shd.constraint_error

Line 113: When hr_api.unique_integrity_violated Then

109: -- Parent integrity has been violated
110: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htr_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_htr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_htr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;
121: End update_dml;

Line 270: when hr_api.cannot_find_prog_unit then

266: );
267: --
268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'HXC_TIME_RECIPIENTS'
274: ,p_hook_type => 'AU');

Line 272: hr_api.cannot_find_prog_unit_error

268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'HXC_TIME_RECIPIENTS'
274: ,p_hook_type => 'AU');
275: --
276: end;

Line 337: If (p_rec.name = hr_api.g_varchar2) then

333: -- p_rec plsql record structure
334: -- to see if a system default is being used. If a system default
335: -- is being used then we must set to the 'current' argument value.
336: --
337: If (p_rec.name = hr_api.g_varchar2) then
338: p_rec.name :=
339: hxc_htr_shd.g_old_rec.name;
340: End If;
341: If (p_rec.application_id = hr_api.g_number) then

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

337: If (p_rec.name = hr_api.g_varchar2) then
338: p_rec.name :=
339: hxc_htr_shd.g_old_rec.name;
340: End If;
341: If (p_rec.application_id = hr_api.g_number) then
342: p_rec.application_id :=
343: hxc_htr_shd.g_old_rec.application_id;
344: End If;
345: --

Line 415: ,p_name in varchar2 default hr_api.g_varchar2

411: ,p_appl_dyn_template_process in varchar2 default NULL
412: ,p_extension_function1 in varchar2 default NULL
413: ,p_extension_function2 in varchar2 default NULL
414: ,p_object_version_number in out nocopy number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_application_id in number default hr_api.g_number
417: ) is
418: --
419: l_rec hxc_htr_shd.g_rec_type;

Line 416: ,p_application_id in number default hr_api.g_number

412: ,p_extension_function1 in varchar2 default NULL
413: ,p_extension_function2 in varchar2 default NULL
414: ,p_object_version_number in out nocopy number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_application_id in number default hr_api.g_number
417: ) is
418: --
419: l_rec hxc_htr_shd.g_rec_type;
420: l_proc varchar2(72);