APPS.BEN_XIC_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

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

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

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

Line 94: When hr_api.parent_integrity_violated Then

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

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

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

Line 99: When hr_api.unique_integrity_violated Then

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

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

99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xic_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
106: Raise;
107: End update_dml;

Line 218: when hr_api.cannot_find_prog_unit then

214: );
215: --
216: exception
217: --
218: when hr_api.cannot_find_prog_unit then
219: --
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'ben_ext_incl_chg'
222: ,p_hook_type => 'AU');

Line 220: hr_api.cannot_find_prog_unit_error

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

Line 288: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then

284: -- p_rec plsql record structure
285: -- to see if a system default is being used. If a system default
286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then
289: p_rec.chg_evt_cd :=
290: ben_xic_shd.g_old_rec.chg_evt_cd;
291: End If;
292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then

Line 292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then

288: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then
289: p_rec.chg_evt_cd :=
290: ben_xic_shd.g_old_rec.chg_evt_cd;
291: End If;
292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then
293: p_rec.chg_evt_source :=
294: ben_xic_shd.g_old_rec.chg_evt_source;
295: End If;
296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then

Line 296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then

292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then
293: p_rec.chg_evt_source :=
294: ben_xic_shd.g_old_rec.chg_evt_source;
295: End If;
296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
297: p_rec.ext_rcd_in_file_id :=
298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;
299: End If;
300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then

Line 300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then

296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
297: p_rec.ext_rcd_in_file_id :=
298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;
299: End If;
300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
301: p_rec.ext_data_elmt_in_rcd_id :=
302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;
303: End If;
304: If (p_rec.business_group_id = hr_api.g_number) then

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

300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
301: p_rec.ext_data_elmt_in_rcd_id :=
302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;
303: End If;
304: If (p_rec.business_group_id = hr_api.g_number) then
305: p_rec.business_group_id :=
306: ben_xic_shd.g_old_rec.business_group_id;
307: End If;
308: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

304: If (p_rec.business_group_id = hr_api.g_number) then
305: p_rec.business_group_id :=
306: ben_xic_shd.g_old_rec.business_group_id;
307: End If;
308: If (p_rec.legislation_code = hr_api.g_varchar2) then
309: p_rec.legislation_code :=
310: ben_xic_shd.g_old_rec.legislation_code;
311: End If;
312:

Line 372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,

368: Procedure upd
369: (
370: p_effective_date in date,
371: p_ext_incl_chg_id in number,
372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,

Line 373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,

369: (
370: p_effective_date in date,
371: p_ext_incl_chg_id in number,
372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,

Line 374: p_ext_rcd_in_file_id in number default hr_api.g_number,

370: p_effective_date in date,
371: p_ext_incl_chg_id in number,
372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,

Line 375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,

371: p_ext_incl_chg_id in number,
372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,

Line 376: p_business_group_id in number default hr_api.g_number,

372: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,

Line 377: p_legislation_code in varchar2 default hr_api.g_varchar2,

373: p_chg_evt_source in varchar2 default hr_api.g_varchar2,
374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,

Line 378: p_last_update_date in date default hr_api.g_date,

374: p_ext_rcd_in_file_id in number default hr_api.g_number,
375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,
382: p_created_by in number default hr_api.g_number,

Line 379: p_creation_date in date default hr_api.g_date,

375: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,
382: p_created_by in number default hr_api.g_number,
383: p_object_version_number in out nocopy number

Line 380: p_last_updated_by in number default hr_api.g_number,

376: p_business_group_id in number default hr_api.g_number,
377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,
382: p_created_by in number default hr_api.g_number,
383: p_object_version_number in out nocopy number
384: ) is

Line 381: p_last_update_login in number default hr_api.g_number,

377: p_legislation_code in varchar2 default hr_api.g_varchar2,
378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,
382: p_created_by in number default hr_api.g_number,
383: p_object_version_number in out nocopy number
384: ) is
385: --

Line 382: p_created_by in number default hr_api.g_number,

378: p_last_update_date in date default hr_api.g_date,
379: p_creation_date in date default hr_api.g_date,
380: p_last_updated_by in number default hr_api.g_number,
381: p_last_update_login in number default hr_api.g_number,
382: p_created_by in number default hr_api.g_number,
383: p_object_version_number in out nocopy number
384: ) is
385: --
386: l_rec ben_xic_shd.g_rec_type;