APPS.BEN_XCC_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

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

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

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

Line 95: When hr_api.parent_integrity_violated Then

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

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

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

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xcc_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xcc_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xcc_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: 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_ext_crit_cmbn'
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_ext_crit_cmbn'
225: ,p_hook_type => 'AU');
226: --
227: end;

Line 291: If (p_rec.crit_typ_cd = hr_api.g_varchar2) 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.crit_typ_cd = hr_api.g_varchar2) then
292: p_rec.crit_typ_cd :=
293: ben_xcc_shd.g_old_rec.crit_typ_cd;
294: End If;
295: If (p_rec.oper_cd = hr_api.g_varchar2) then

Line 295: If (p_rec.oper_cd = hr_api.g_varchar2) then

291: If (p_rec.crit_typ_cd = hr_api.g_varchar2) then
292: p_rec.crit_typ_cd :=
293: ben_xcc_shd.g_old_rec.crit_typ_cd;
294: End If;
295: If (p_rec.oper_cd = hr_api.g_varchar2) then
296: p_rec.oper_cd :=
297: ben_xcc_shd.g_old_rec.oper_cd;
298: End If;
299: If (p_rec.val_1 = hr_api.g_varchar2) then

Line 299: If (p_rec.val_1 = hr_api.g_varchar2) then

295: If (p_rec.oper_cd = hr_api.g_varchar2) then
296: p_rec.oper_cd :=
297: ben_xcc_shd.g_old_rec.oper_cd;
298: End If;
299: If (p_rec.val_1 = hr_api.g_varchar2) then
300: p_rec.val_1 :=
301: ben_xcc_shd.g_old_rec.val_1;
302: End If;
303: If (p_rec.val_2 = hr_api.g_varchar2) then

Line 303: If (p_rec.val_2 = hr_api.g_varchar2) then

299: If (p_rec.val_1 = hr_api.g_varchar2) then
300: p_rec.val_1 :=
301: ben_xcc_shd.g_old_rec.val_1;
302: End If;
303: If (p_rec.val_2 = hr_api.g_varchar2) then
304: p_rec.val_2 :=
305: ben_xcc_shd.g_old_rec.val_2;
306: End If;
307: If (p_rec.ext_crit_val_id = hr_api.g_number) then

Line 307: If (p_rec.ext_crit_val_id = hr_api.g_number) then

303: If (p_rec.val_2 = hr_api.g_varchar2) then
304: p_rec.val_2 :=
305: ben_xcc_shd.g_old_rec.val_2;
306: End If;
307: If (p_rec.ext_crit_val_id = hr_api.g_number) then
308: p_rec.ext_crit_val_id :=
309: ben_xcc_shd.g_old_rec.ext_crit_val_id;
310: End If;
311: If (p_rec.business_group_id = hr_api.g_number) then

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

307: If (p_rec.ext_crit_val_id = hr_api.g_number) then
308: p_rec.ext_crit_val_id :=
309: ben_xcc_shd.g_old_rec.ext_crit_val_id;
310: End If;
311: If (p_rec.business_group_id = hr_api.g_number) then
312: p_rec.business_group_id :=
313: ben_xcc_shd.g_old_rec.business_group_id;
314: End If;
315: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

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

Line 377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,

373: Procedure upd
374: (
375: p_effective_date in date,
376: p_ext_crit_cmbn_id in number,
377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,
378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,

Line 378: p_oper_cd in varchar2 default hr_api.g_varchar2,

374: (
375: p_effective_date in date,
376: p_ext_crit_cmbn_id in number,
377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,
378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,

Line 379: p_val_1 in varchar2 default hr_api.g_varchar2,

375: p_effective_date in date,
376: p_ext_crit_cmbn_id in number,
377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,
378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,

Line 380: p_val_2 in varchar2 default hr_api.g_varchar2,

376: p_ext_crit_cmbn_id in number,
377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,
378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,

Line 381: p_ext_crit_val_id in number default hr_api.g_number,

377: p_crit_typ_cd in varchar2 default hr_api.g_varchar2,
378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,

Line 382: p_business_group_id in number default hr_api.g_number,

378: p_oper_cd in varchar2 default hr_api.g_varchar2,
379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,

Line 383: p_legislation_code in varchar2 default hr_api.g_varchar2,

379: p_val_1 in varchar2 default hr_api.g_varchar2,
380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,

Line 384: p_last_update_date in date default hr_api.g_date,

380: p_val_2 in varchar2 default hr_api.g_varchar2,
381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,
388: p_created_by in number default hr_api.g_number,

Line 385: p_creation_date in date default hr_api.g_date,

381: p_ext_crit_val_id in number default hr_api.g_number,
382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,
388: p_created_by in number default hr_api.g_number,
389: p_object_version_number in out nocopy number

Line 386: p_last_updated_by in number default hr_api.g_number,

382: p_business_group_id in number default hr_api.g_number,
383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,
388: p_created_by in number default hr_api.g_number,
389: p_object_version_number in out nocopy number
390: ) is

Line 387: p_last_update_login in number default hr_api.g_number,

383: p_legislation_code in varchar2 default hr_api.g_varchar2,
384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,
388: p_created_by in number default hr_api.g_number,
389: p_object_version_number in out nocopy number
390: ) is
391: --

Line 388: p_created_by in number default hr_api.g_number,

384: p_last_update_date in date default hr_api.g_date,
385: p_creation_date in date default hr_api.g_date,
386: p_last_updated_by in number default hr_api.g_number,
387: p_last_update_login in number default hr_api.g_number,
388: p_created_by in number default hr_api.g_number,
389: p_object_version_number in out nocopy number
390: ) is
391: --
392: l_rec ben_xcc_shd.g_rec_type;