DBA Data[Home] [Help]

APPS.BEN_ACT_UPD dependencies on HR_API

Line 85: When hr_api.check_integrity_violated Then

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

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

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

Line 90: When hr_api.parent_integrity_violated Then

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

Line 95: When hr_api.unique_integrity_violated Then

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

Line 210: when hr_api.cannot_find_prog_unit then

206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);
207: --
208: exception
209: --
210: when hr_api.cannot_find_prog_unit then
211: --
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'ben_person_actions'
214: ,p_hook_type => 'AU');

Line 212: hr_api.cannot_find_prog_unit_error

208: exception
209: --
210: when hr_api.cannot_find_prog_unit then
211: --
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'ben_person_actions'
214: ,p_hook_type => 'AU');
215: --
216: end;

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

276: -- p_rec plsql record structure
277: -- to see if a system default is being used. If a system default
278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.person_id = hr_api.g_number) then
281: p_rec.person_id :=
282: ben_act_shd.g_old_rec.person_id;
283: End If;
284: If (p_rec.ler_id = hr_api.g_number) then

Line 284: If (p_rec.ler_id = hr_api.g_number) then

280: If (p_rec.person_id = hr_api.g_number) then
281: p_rec.person_id :=
282: ben_act_shd.g_old_rec.person_id;
283: End If;
284: If (p_rec.ler_id = hr_api.g_number) then
285: p_rec.ler_id :=
286: ben_act_shd.g_old_rec.ler_id;
287: End If;
288: If (p_rec.benefit_action_id = hr_api.g_number) then

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

284: If (p_rec.ler_id = hr_api.g_number) then
285: p_rec.ler_id :=
286: ben_act_shd.g_old_rec.ler_id;
287: End If;
288: If (p_rec.benefit_action_id = hr_api.g_number) then
289: p_rec.benefit_action_id :=
290: ben_act_shd.g_old_rec.benefit_action_id;
291: End If;
292: If (p_rec.action_status_cd = hr_api.g_varchar2) then

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

288: If (p_rec.benefit_action_id = hr_api.g_number) then
289: p_rec.benefit_action_id :=
290: ben_act_shd.g_old_rec.benefit_action_id;
291: End If;
292: If (p_rec.action_status_cd = hr_api.g_varchar2) then
293: p_rec.action_status_cd :=
294: ben_act_shd.g_old_rec.action_status_cd;
295: End If;
296: If (p_rec.chunk_number = hr_api.g_number) then

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

292: If (p_rec.action_status_cd = hr_api.g_varchar2) then
293: p_rec.action_status_cd :=
294: ben_act_shd.g_old_rec.action_status_cd;
295: End If;
296: If (p_rec.chunk_number = hr_api.g_number) then
297: p_rec.chunk_number :=
298: ben_act_shd.g_old_rec.chunk_number;
299: End If;
300:

Line 358: p_person_id in number default hr_api.g_number,

354: Procedure upd
355: (
356: p_effective_date in date,
357: p_person_action_id in number,
358: p_person_id in number default hr_api.g_number,
359: p_ler_id in number default hr_api.g_number,
360: p_benefit_action_id in number default hr_api.g_number,
361: p_action_status_cd in varchar2 default hr_api.g_varchar2,
362: p_chunk_number in number default hr_api.g_number,

Line 359: p_ler_id in number default hr_api.g_number,

355: (
356: p_effective_date in date,
357: p_person_action_id in number,
358: p_person_id in number default hr_api.g_number,
359: p_ler_id in number default hr_api.g_number,
360: p_benefit_action_id in number default hr_api.g_number,
361: p_action_status_cd in varchar2 default hr_api.g_varchar2,
362: p_chunk_number in number default hr_api.g_number,
363: p_object_version_number in out nocopy number

Line 360: p_benefit_action_id in number default hr_api.g_number,

356: p_effective_date in date,
357: p_person_action_id in number,
358: p_person_id in number default hr_api.g_number,
359: p_ler_id in number default hr_api.g_number,
360: p_benefit_action_id in number default hr_api.g_number,
361: p_action_status_cd in varchar2 default hr_api.g_varchar2,
362: p_chunk_number in number default hr_api.g_number,
363: p_object_version_number in out nocopy number
364: ) is

Line 361: p_action_status_cd in varchar2 default hr_api.g_varchar2,

357: p_person_action_id in number,
358: p_person_id in number default hr_api.g_number,
359: p_ler_id in number default hr_api.g_number,
360: p_benefit_action_id in number default hr_api.g_number,
361: p_action_status_cd in varchar2 default hr_api.g_varchar2,
362: p_chunk_number in number default hr_api.g_number,
363: p_object_version_number in out nocopy number
364: ) is
365: --

Line 362: p_chunk_number in number default hr_api.g_number,

358: p_person_id in number default hr_api.g_number,
359: p_ler_id in number default hr_api.g_number,
360: p_benefit_action_id in number default hr_api.g_number,
361: p_action_status_cd in varchar2 default hr_api.g_varchar2,
362: p_chunk_number in number default hr_api.g_number,
363: p_object_version_number in out nocopy number
364: ) is
365: --
366: l_rec ben_act_shd.g_rec_type;