APPS.BEN_BAI_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bai_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bai_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_shd.constraint_error

Line 93: When hr_api.parent_integrity_violated Then

89: -- A check constraint has been violated
90: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bai_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_shd.constraint_error

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_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.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End update_dml;

Line 221: when hr_api.cannot_find_prog_unit then

217: );
218: --
219: exception
220: --
221: when hr_api.cannot_find_prog_unit then
222: --
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'ben_batch_actn_item_info'
225: ,p_hook_type => 'AU');

Line 223: hr_api.cannot_find_prog_unit_error

219: exception
220: --
221: when hr_api.cannot_find_prog_unit then
222: --
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'ben_batch_actn_item_info'
225: ,p_hook_type => 'AU');
226: --
227: end;

Line 291: If (p_rec.benefit_action_id = hr_api.g_number) then

287: -- p_rec plsql record structure
288: -- to see if a system default is being used. If a system default
289: -- is being used then we must set to the 'current' argument value.
290: --
291: If (p_rec.benefit_action_id = hr_api.g_number) then
292: p_rec.benefit_action_id :=
293: ben_bai_shd.g_old_rec.benefit_action_id;
294: End If;
295: If (p_rec.person_id = hr_api.g_number) then

Line 295: If (p_rec.person_id = hr_api.g_number) then

291: If (p_rec.benefit_action_id = hr_api.g_number) then
292: p_rec.benefit_action_id :=
293: ben_bai_shd.g_old_rec.benefit_action_id;
294: End If;
295: If (p_rec.person_id = hr_api.g_number) then
296: p_rec.person_id :=
297: ben_bai_shd.g_old_rec.person_id;
298: End If;
299: If (p_rec.actn_typ_id = hr_api.g_number) then

Line 299: If (p_rec.actn_typ_id = hr_api.g_number) then

295: If (p_rec.person_id = hr_api.g_number) then
296: p_rec.person_id :=
297: ben_bai_shd.g_old_rec.person_id;
298: End If;
299: If (p_rec.actn_typ_id = hr_api.g_number) then
300: p_rec.actn_typ_id :=
301: ben_bai_shd.g_old_rec.actn_typ_id;
302: End If;
303: If (p_rec.cmpltd_dt = hr_api.g_date) then

Line 303: If (p_rec.cmpltd_dt = hr_api.g_date) then

299: If (p_rec.actn_typ_id = hr_api.g_number) then
300: p_rec.actn_typ_id :=
301: ben_bai_shd.g_old_rec.actn_typ_id;
302: End If;
303: If (p_rec.cmpltd_dt = hr_api.g_date) then
304: p_rec.cmpltd_dt :=
305: ben_bai_shd.g_old_rec.cmpltd_dt;
306: End If;
307: If (p_rec.due_dt = hr_api.g_date) then

Line 307: If (p_rec.due_dt = hr_api.g_date) then

303: If (p_rec.cmpltd_dt = hr_api.g_date) then
304: p_rec.cmpltd_dt :=
305: ben_bai_shd.g_old_rec.cmpltd_dt;
306: End If;
307: If (p_rec.due_dt = hr_api.g_date) then
308: p_rec.due_dt :=
309: ben_bai_shd.g_old_rec.due_dt;
310: End If;
311: If (p_rec.rqd_flag = hr_api.g_varchar2) then

Line 311: If (p_rec.rqd_flag = hr_api.g_varchar2) then

307: If (p_rec.due_dt = hr_api.g_date) then
308: p_rec.due_dt :=
309: ben_bai_shd.g_old_rec.due_dt;
310: End If;
311: If (p_rec.rqd_flag = hr_api.g_varchar2) then
312: p_rec.rqd_flag :=
313: ben_bai_shd.g_old_rec.rqd_flag;
314: End If;
315: If (p_rec.actn_cd = hr_api.g_varchar2) then

Line 315: If (p_rec.actn_cd = hr_api.g_varchar2) then

311: If (p_rec.rqd_flag = hr_api.g_varchar2) then
312: p_rec.rqd_flag :=
313: ben_bai_shd.g_old_rec.rqd_flag;
314: End If;
315: If (p_rec.actn_cd = hr_api.g_varchar2) then
316: p_rec.actn_cd :=
317: ben_bai_shd.g_old_rec.actn_cd;
318: End If;
319: If (p_rec.business_group_id = hr_api.g_number) then

Line 319: If (p_rec.business_group_id = hr_api.g_number) then

315: If (p_rec.actn_cd = hr_api.g_varchar2) then
316: p_rec.actn_cd :=
317: ben_bai_shd.g_old_rec.actn_cd;
318: End If;
319: If (p_rec.business_group_id = hr_api.g_number) then
320: p_rec.business_group_id :=
321: ben_bai_shd.g_old_rec.business_group_id;
322: End If;
323:

Line 382: p_benefit_action_id in number default hr_api.g_number,

378: Procedure upd
379: (
380: p_effective_date in date,
381: p_batch_actn_item_id in number,
382: p_benefit_action_id in number default hr_api.g_number,
383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,

Line 383: p_person_id in number default hr_api.g_number,

379: (
380: p_effective_date in date,
381: p_batch_actn_item_id in number,
382: p_benefit_action_id in number default hr_api.g_number,
383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,

Line 384: p_actn_typ_id in number default hr_api.g_number,

380: p_effective_date in date,
381: p_batch_actn_item_id in number,
382: p_benefit_action_id in number default hr_api.g_number,
383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,

Line 385: p_cmpltd_dt in date default hr_api.g_date,

381: p_batch_actn_item_id in number,
382: p_benefit_action_id in number default hr_api.g_number,
383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,
389: p_business_group_id in number default hr_api.g_number,

Line 386: p_due_dt in date default hr_api.g_date,

382: p_benefit_action_id in number default hr_api.g_number,
383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,
389: p_business_group_id in number default hr_api.g_number,
390: p_object_version_number in out nocopy number

Line 387: p_rqd_flag in varchar2 default hr_api.g_varchar2,

383: p_person_id in number default hr_api.g_number,
384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,
389: p_business_group_id in number default hr_api.g_number,
390: p_object_version_number in out nocopy number
391: ) is

Line 388: p_actn_cd in varchar2 default hr_api.g_varchar2,

384: p_actn_typ_id in number default hr_api.g_number,
385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,
389: p_business_group_id in number default hr_api.g_number,
390: p_object_version_number in out nocopy number
391: ) is
392: --

Line 389: p_business_group_id in number default hr_api.g_number,

385: p_cmpltd_dt in date default hr_api.g_date,
386: p_due_dt in date default hr_api.g_date,
387: p_rqd_flag in varchar2 default hr_api.g_varchar2,
388: p_actn_cd in varchar2 default hr_api.g_varchar2,
389: p_business_group_id in number default hr_api.g_number,
390: p_object_version_number in out nocopy number
391: ) is
392: --
393: l_rec ben_bai_shd.g_rec_type;