APPS.BEN_RAN_UPD dependencies on HR_API

Line 84: When hr_api.check_integrity_violated Then

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

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

84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
87: ben_ran_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
92: ben_ran_shd.constraint_error

Line 89: When hr_api.parent_integrity_violated Then

85: -- A check constraint has been violated
86: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
87: ben_ran_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
92: ben_ran_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.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
92: ben_ran_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
97: ben_ran_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

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

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

241: -- p_rec plsql record structure
242: -- to see if a system default is being used. If a system default
243: -- is being used then we must set to the 'current' argument value.
244: --
245: If (p_rec.benefit_action_id = hr_api.g_number) then
246: p_rec.benefit_action_id :=
247: ben_ran_shd.g_old_rec.benefit_action_id;
248: End If;
249: If (p_rec.range_status_cd = hr_api.g_varchar2) then

Line 249: If (p_rec.range_status_cd = hr_api.g_varchar2) then

245: If (p_rec.benefit_action_id = hr_api.g_number) then
246: p_rec.benefit_action_id :=
247: ben_ran_shd.g_old_rec.benefit_action_id;
248: End If;
249: If (p_rec.range_status_cd = hr_api.g_varchar2) then
250: p_rec.range_status_cd :=
251: ben_ran_shd.g_old_rec.range_status_cd;
252: End If;
253: If (p_rec.starting_person_action_id = hr_api.g_number) then

Line 253: If (p_rec.starting_person_action_id = hr_api.g_number) then

249: If (p_rec.range_status_cd = hr_api.g_varchar2) then
250: p_rec.range_status_cd :=
251: ben_ran_shd.g_old_rec.range_status_cd;
252: End If;
253: If (p_rec.starting_person_action_id = hr_api.g_number) then
254: p_rec.starting_person_action_id :=
255: ben_ran_shd.g_old_rec.starting_person_action_id;
256: End If;
257: If (p_rec.ending_person_action_id = hr_api.g_number) then

Line 257: If (p_rec.ending_person_action_id = hr_api.g_number) then

253: If (p_rec.starting_person_action_id = hr_api.g_number) then
254: p_rec.starting_person_action_id :=
255: ben_ran_shd.g_old_rec.starting_person_action_id;
256: End If;
257: If (p_rec.ending_person_action_id = hr_api.g_number) then
258: p_rec.ending_person_action_id :=
259: ben_ran_shd.g_old_rec.ending_person_action_id;
260: End If;
261:

Line 320: p_benefit_action_id in number default hr_api.g_number,

316: Procedure upd
317: (
318: p_effective_date in date,
319: p_range_id in number,
320: p_benefit_action_id in number default hr_api.g_number,
321: p_range_status_cd in varchar2 default hr_api.g_varchar2,
322: p_starting_person_action_id in number default hr_api.g_number,
323: p_ending_person_action_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number

Line 321: p_range_status_cd in varchar2 default hr_api.g_varchar2,

317: (
318: p_effective_date in date,
319: p_range_id in number,
320: p_benefit_action_id in number default hr_api.g_number,
321: p_range_status_cd in varchar2 default hr_api.g_varchar2,
322: p_starting_person_action_id in number default hr_api.g_number,
323: p_ending_person_action_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is

Line 322: p_starting_person_action_id in number default hr_api.g_number,

318: p_effective_date in date,
319: p_range_id in number,
320: p_benefit_action_id in number default hr_api.g_number,
321: p_range_status_cd in varchar2 default hr_api.g_varchar2,
322: p_starting_person_action_id in number default hr_api.g_number,
323: p_ending_person_action_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --

Line 323: p_ending_person_action_id in number default hr_api.g_number,

319: p_range_id in number,
320: p_benefit_action_id in number default hr_api.g_number,
321: p_range_status_cd in varchar2 default hr_api.g_varchar2,
322: p_starting_person_action_id in number default hr_api.g_number,
323: p_ending_person_action_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --
327: l_rec ben_ran_shd.g_rec_type;