DBA Data[Home] [Help]

APPS.HXC_HRP_UPD dependencies on HR_API

Line 96: When hr_api.check_integrity_violated Then

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

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

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

Line 101: When hr_api.parent_integrity_violated Then

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

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

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

Line 106: When hr_api.unique_integrity_violated Then

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

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

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

Line 241: when hr_api.cannot_find_prog_unit then

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

Line 243: hr_api.cannot_find_prog_unit_error

239: exception
240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'HXC_RECURRING_PERIODS'
245: ,p_hook_type => 'AU');
246: --
247: end;

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

304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.name = hr_api.g_varchar2) then
309: p_rec.name :=
310: hxc_hrp_shd.g_old_rec.name;
311: End If;
312: If (p_rec.start_date = hr_api.g_date) then

Line 312: If (p_rec.start_date = hr_api.g_date) then

308: If (p_rec.name = hr_api.g_varchar2) then
309: p_rec.name :=
310: hxc_hrp_shd.g_old_rec.name;
311: End If;
312: If (p_rec.start_date = hr_api.g_date) then
313: p_rec.start_date :=
314: hxc_hrp_shd.g_old_rec.start_date;
315: End If;
316: If (p_rec.end_date = hr_api.g_date) then

Line 316: If (p_rec.end_date = hr_api.g_date) then

312: If (p_rec.start_date = hr_api.g_date) then
313: p_rec.start_date :=
314: hxc_hrp_shd.g_old_rec.start_date;
315: End If;
316: If (p_rec.end_date = hr_api.g_date) then
317: p_rec.end_date :=
318: hxc_hrp_shd.g_old_rec.end_date;
319: End If;
320: If (p_rec.period_type = hr_api.g_varchar2) then

Line 320: If (p_rec.period_type = hr_api.g_varchar2) then

316: If (p_rec.end_date = hr_api.g_date) then
317: p_rec.end_date :=
318: hxc_hrp_shd.g_old_rec.end_date;
319: End If;
320: If (p_rec.period_type = hr_api.g_varchar2) then
321: p_rec.period_type :=
322: hxc_hrp_shd.g_old_rec.period_type;
323: End If;
324: If (p_rec.duration_in_days = hr_api.g_number) then

Line 324: If (p_rec.duration_in_days = hr_api.g_number) then

320: If (p_rec.period_type = hr_api.g_varchar2) then
321: p_rec.period_type :=
322: hxc_hrp_shd.g_old_rec.period_type;
323: End If;
324: If (p_rec.duration_in_days = hr_api.g_number) then
325: p_rec.duration_in_days :=
326: hxc_hrp_shd.g_old_rec.duration_in_days;
327: End If;
328: --

Line 390: ,p_name in varchar2 default hr_api.g_varchar2

386: Procedure upd
387: (p_effective_date in date
388: ,p_recurring_period_id in number
389: ,p_object_version_number in out nocopy number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_start_date in date default hr_api.g_date
392: ,p_end_date in date default hr_api.g_date
393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number

Line 391: ,p_start_date in date default hr_api.g_date

387: (p_effective_date in date
388: ,p_recurring_period_id in number
389: ,p_object_version_number in out nocopy number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_start_date in date default hr_api.g_date
392: ,p_end_date in date default hr_api.g_date
393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number
395: ) is

Line 392: ,p_end_date in date default hr_api.g_date

388: ,p_recurring_period_id in number
389: ,p_object_version_number in out nocopy number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_start_date in date default hr_api.g_date
392: ,p_end_date in date default hr_api.g_date
393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number
395: ) is
396: --

Line 393: ,p_period_type in varchar2 default hr_api.g_varchar2

389: ,p_object_version_number in out nocopy number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_start_date in date default hr_api.g_date
392: ,p_end_date in date default hr_api.g_date
393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number
395: ) is
396: --
397: l_rec hxc_hrp_shd.g_rec_type;

Line 394: ,p_duration_in_days in number default hr_api.g_number

390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_start_date in date default hr_api.g_date
392: ,p_end_date in date default hr_api.g_date
393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number
395: ) is
396: --
397: l_rec hxc_hrp_shd.g_rec_type;
398: l_proc varchar2(72);