eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BCI_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_bci_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bci_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_bci_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bci_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_bci_shd.g_api_dml := false; -- Unset the api dml status
93: ben_bci_shd.constraint_error

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bci_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_bci_shd.g_api_dml := false; -- Unset the api dml status
93: ben_bci_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_bci_shd.g_api_dml := false; -- Unset the api dml status
93: ben_bci_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_bci_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bci_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

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

Line 212: when hr_api.cannot_find_prog_unit then

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

Line 214: hr_api.cannot_find_prog_unit_error

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

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

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

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

282: If (p_rec.benefit_action_id = hr_api.g_number) then
283: p_rec.benefit_action_id :=
284: ben_bci_shd.g_old_rec.benefit_action_id;
285: End If;
286: If (p_rec.person_id = hr_api.g_number) then
287: p_rec.person_id :=
288: ben_bci_shd.g_old_rec.person_id;
289: End If;
290: If (p_rec.actn_typ_id = hr_api.g_number) then

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

286: If (p_rec.person_id = hr_api.g_number) then
287: p_rec.person_id :=
288: ben_bci_shd.g_old_rec.person_id;
289: End If;
290: If (p_rec.actn_typ_id = hr_api.g_number) then
291: p_rec.actn_typ_id :=
292: ben_bci_shd.g_old_rec.actn_typ_id;
293: End If;
294: If (p_rec.typ_cd = hr_api.g_varchar2) then

Line 294: If (p_rec.typ_cd = hr_api.g_varchar2) then

290: If (p_rec.actn_typ_id = hr_api.g_number) then
291: p_rec.actn_typ_id :=
292: ben_bci_shd.g_old_rec.actn_typ_id;
293: End If;
294: If (p_rec.typ_cd = hr_api.g_varchar2) then
295: p_rec.typ_cd :=
296: ben_bci_shd.g_old_rec.typ_cd;
297: End If;
298: If (p_rec.enrt_ctfn_recd_dt = hr_api.g_date) then

Line 298: If (p_rec.enrt_ctfn_recd_dt = hr_api.g_date) then

294: If (p_rec.typ_cd = hr_api.g_varchar2) then
295: p_rec.typ_cd :=
296: ben_bci_shd.g_old_rec.typ_cd;
297: End If;
298: If (p_rec.enrt_ctfn_recd_dt = hr_api.g_date) then
299: p_rec.enrt_ctfn_recd_dt :=
300: ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt;
301: End If;
302:

Line 361: p_benefit_action_id in number default hr_api.g_number,

357: Procedure upd
358: (
359: p_effective_date in date,
360: p_batch_benft_cert_id in number,
361: p_benefit_action_id in number default hr_api.g_number,
362: p_person_id in number default hr_api.g_number,
363: p_actn_typ_id in number default hr_api.g_number,
364: p_typ_cd in varchar2 default hr_api.g_varchar2,
365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,

Line 362: p_person_id in number default hr_api.g_number,

358: (
359: p_effective_date in date,
360: p_batch_benft_cert_id in number,
361: p_benefit_action_id in number default hr_api.g_number,
362: p_person_id in number default hr_api.g_number,
363: p_actn_typ_id in number default hr_api.g_number,
364: p_typ_cd in varchar2 default hr_api.g_varchar2,
365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,
366: p_object_version_number in out nocopy number

Line 363: p_actn_typ_id in number default hr_api.g_number,

359: p_effective_date in date,
360: p_batch_benft_cert_id in number,
361: p_benefit_action_id in number default hr_api.g_number,
362: p_person_id in number default hr_api.g_number,
363: p_actn_typ_id in number default hr_api.g_number,
364: p_typ_cd in varchar2 default hr_api.g_varchar2,
365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,
366: p_object_version_number in out nocopy number
367: ) is

Line 364: p_typ_cd in varchar2 default hr_api.g_varchar2,

360: p_batch_benft_cert_id in number,
361: p_benefit_action_id in number default hr_api.g_number,
362: p_person_id in number default hr_api.g_number,
363: p_actn_typ_id in number default hr_api.g_number,
364: p_typ_cd in varchar2 default hr_api.g_varchar2,
365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,
366: p_object_version_number in out nocopy number
367: ) is
368: --

Line 365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,

361: p_benefit_action_id in number default hr_api.g_number,
362: p_person_id in number default hr_api.g_number,
363: p_actn_typ_id in number default hr_api.g_number,
364: p_typ_cd in varchar2 default hr_api.g_varchar2,
365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,
366: p_object_version_number in out nocopy number
367: ) is
368: --
369: l_rec ben_bci_shd.g_rec_type;