APPS.HXC_RTC_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

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

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

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

Line 102: When hr_api.parent_integrity_violated Then

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

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

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

Line 107: When hr_api.unique_integrity_violated Then

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

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

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

Line 238: when hr_api.cannot_find_prog_unit then

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

Line 240: hr_api.cannot_find_prog_unit_error

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

Line 305: If (p_rec.retrieval_rule_id = hr_api.g_number) then

301: -- p_rec plsql record structure
302: -- to see if a system default is being used. If a system default
303: -- is being used then we must set to the 'current' argument value.
304: --
305: If (p_rec.retrieval_rule_id = hr_api.g_number) then
306: p_rec.retrieval_rule_id :=
307: hxc_rtc_shd.g_old_rec.retrieval_rule_id;
308: End If;
309: If (p_rec.status = hr_api.g_varchar2) then

Line 309: If (p_rec.status = hr_api.g_varchar2) then

305: If (p_rec.retrieval_rule_id = hr_api.g_number) then
306: p_rec.retrieval_rule_id :=
307: hxc_rtc_shd.g_old_rec.retrieval_rule_id;
308: End If;
309: If (p_rec.status = hr_api.g_varchar2) then
310: p_rec.status :=
311: hxc_rtc_shd.g_old_rec.status;
312: End If;
313: If (p_rec.time_recipient_id = hr_api.g_number) then

Line 313: If (p_rec.time_recipient_id = hr_api.g_number) then

309: If (p_rec.status = hr_api.g_varchar2) then
310: p_rec.status :=
311: hxc_rtc_shd.g_old_rec.status;
312: End If;
313: If (p_rec.time_recipient_id = hr_api.g_number) then
314: p_rec.time_recipient_id :=
315: hxc_rtc_shd.g_old_rec.time_recipient_id;
316: End If;
317: --

Line 380: ,p_retrieval_rule_id in number default hr_api.g_number

376: Procedure upd
377: (p_effective_date in date
378: ,p_retrieval_rule_comp_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_retrieval_rule_id in number default hr_api.g_number
381: ,p_status in varchar2 default hr_api.g_varchar2
382: ,p_time_recipient_id in number default hr_api.g_number
383: ) is
384: --

Line 381: ,p_status in varchar2 default hr_api.g_varchar2

377: (p_effective_date in date
378: ,p_retrieval_rule_comp_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_retrieval_rule_id in number default hr_api.g_number
381: ,p_status in varchar2 default hr_api.g_varchar2
382: ,p_time_recipient_id in number default hr_api.g_number
383: ) is
384: --
385: l_rec hxc_rtc_shd.g_rec_type;

Line 382: ,p_time_recipient_id in number default hr_api.g_number

378: ,p_retrieval_rule_comp_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_retrieval_rule_id in number default hr_api.g_number
381: ,p_status in varchar2 default hr_api.g_varchar2
382: ,p_time_recipient_id in number default hr_api.g_number
383: ) is
384: --
385: l_rec hxc_rtc_shd.g_rec_type;
386: l_proc varchar2(72);