APPS.BEN_XRE_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_xre_shd.g_api_dml := false; -- Unset the api dml status
93: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
93: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xre_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
93: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xre_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xre_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_xre_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xre_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End update_dml;

Line 227: when hr_api.cannot_find_prog_unit then

223: );
224: --
225: exception
226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'ben_ext_rslt_err'
231: ,p_hook_type => 'AU');

Line 229: hr_api.cannot_find_prog_unit_error

225: exception
226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'ben_ext_rslt_err'
231: ,p_hook_type => 'AU');
232: --
233: end;

Line 297: If (p_rec.err_num = hr_api.g_number) then

293: -- p_rec plsql record structure
294: -- to see if a system default is being used. If a system default
295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.err_num = hr_api.g_number) then
298: p_rec.err_num :=
299: ben_xre_shd.g_old_rec.err_num;
300: End If;
301: If (p_rec.err_txt = hr_api.g_varchar2) then

Line 301: If (p_rec.err_txt = hr_api.g_varchar2) then

297: If (p_rec.err_num = hr_api.g_number) then
298: p_rec.err_num :=
299: ben_xre_shd.g_old_rec.err_num;
300: End If;
301: If (p_rec.err_txt = hr_api.g_varchar2) then
302: p_rec.err_txt :=
303: ben_xre_shd.g_old_rec.err_txt;
304: End If;
305: If (p_rec.typ_cd = hr_api.g_varchar2) then

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

301: If (p_rec.err_txt = hr_api.g_varchar2) then
302: p_rec.err_txt :=
303: ben_xre_shd.g_old_rec.err_txt;
304: End If;
305: If (p_rec.typ_cd = hr_api.g_varchar2) then
306: p_rec.typ_cd :=
307: ben_xre_shd.g_old_rec.typ_cd;
308: End If;
309: If (p_rec.person_id = hr_api.g_number) then

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

305: If (p_rec.typ_cd = hr_api.g_varchar2) then
306: p_rec.typ_cd :=
307: ben_xre_shd.g_old_rec.typ_cd;
308: End If;
309: If (p_rec.person_id = hr_api.g_number) then
310: p_rec.person_id :=
311: ben_xre_shd.g_old_rec.person_id;
312: End If;
313: If (p_rec.business_group_id = hr_api.g_number) then

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

309: If (p_rec.person_id = hr_api.g_number) then
310: p_rec.person_id :=
311: ben_xre_shd.g_old_rec.person_id;
312: End If;
313: If (p_rec.business_group_id = hr_api.g_number) then
314: p_rec.business_group_id :=
315: ben_xre_shd.g_old_rec.business_group_id;
316: End If;
317: If (p_rec.request_id = hr_api.g_number) then

Line 317: If (p_rec.request_id = hr_api.g_number) then

313: If (p_rec.business_group_id = hr_api.g_number) then
314: p_rec.business_group_id :=
315: ben_xre_shd.g_old_rec.business_group_id;
316: End If;
317: If (p_rec.request_id = hr_api.g_number) then
318: p_rec.request_id :=
319: ben_xre_shd.g_old_rec.request_id;
320: End If;
321: If (p_rec.program_application_id = hr_api.g_number) then

Line 321: If (p_rec.program_application_id = hr_api.g_number) then

317: If (p_rec.request_id = hr_api.g_number) then
318: p_rec.request_id :=
319: ben_xre_shd.g_old_rec.request_id;
320: End If;
321: If (p_rec.program_application_id = hr_api.g_number) then
322: p_rec.program_application_id :=
323: ben_xre_shd.g_old_rec.program_application_id;
324: End If;
325: If (p_rec.program_id = hr_api.g_number) then

Line 325: If (p_rec.program_id = hr_api.g_number) then

321: If (p_rec.program_application_id = hr_api.g_number) then
322: p_rec.program_application_id :=
323: ben_xre_shd.g_old_rec.program_application_id;
324: End If;
325: If (p_rec.program_id = hr_api.g_number) then
326: p_rec.program_id :=
327: ben_xre_shd.g_old_rec.program_id;
328: End If;
329: If (p_rec.program_update_date = hr_api.g_date) then

Line 329: If (p_rec.program_update_date = hr_api.g_date) then

325: If (p_rec.program_id = hr_api.g_number) then
326: p_rec.program_id :=
327: ben_xre_shd.g_old_rec.program_id;
328: End If;
329: If (p_rec.program_update_date = hr_api.g_date) then
330: p_rec.program_update_date :=
331: ben_xre_shd.g_old_rec.program_update_date;
332: End If;
333: If (p_rec.ext_rslt_id = hr_api.g_number) then

Line 333: If (p_rec.ext_rslt_id = hr_api.g_number) then

329: If (p_rec.program_update_date = hr_api.g_date) then
330: p_rec.program_update_date :=
331: ben_xre_shd.g_old_rec.program_update_date;
332: End If;
333: If (p_rec.ext_rslt_id = hr_api.g_number) then
334: p_rec.ext_rslt_id :=
335: ben_xre_shd.g_old_rec.ext_rslt_id;
336: End If;
337: --

Line 395: p_err_num in number default hr_api.g_number,

391: Procedure upd
392: (
393: p_effective_date in date,
394: p_ext_rslt_err_id in number,
395: p_err_num in number default hr_api.g_number,
396: p_err_txt in varchar2 default hr_api.g_varchar2,
397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,

Line 396: p_err_txt in varchar2 default hr_api.g_varchar2,

392: (
393: p_effective_date in date,
394: p_ext_rslt_err_id in number,
395: p_err_num in number default hr_api.g_number,
396: p_err_txt in varchar2 default hr_api.g_varchar2,
397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,

Line 397: p_typ_cd in varchar2 default hr_api.g_varchar2,

393: p_effective_date in date,
394: p_ext_rslt_err_id in number,
395: p_err_num in number default hr_api.g_number,
396: p_err_txt in varchar2 default hr_api.g_varchar2,
397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,

Line 398: p_person_id in number default hr_api.g_number,

394: p_ext_rslt_err_id in number,
395: p_err_num in number default hr_api.g_number,
396: p_err_txt in varchar2 default hr_api.g_varchar2,
397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,

Line 399: p_business_group_id in number default hr_api.g_number,

395: p_err_num in number default hr_api.g_number,
396: p_err_txt in varchar2 default hr_api.g_varchar2,
397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,

Line 401: p_request_id in number default hr_api.g_number,

397: p_typ_cd in varchar2 default hr_api.g_varchar2,
398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,
404: p_program_update_date in date default hr_api.g_date,
405: p_ext_rslt_id in number default hr_api.g_number

Line 402: p_program_application_id in number default hr_api.g_number,

398: p_person_id in number default hr_api.g_number,
399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,
404: p_program_update_date in date default hr_api.g_date,
405: p_ext_rslt_id in number default hr_api.g_number
406: ) is

Line 403: p_program_id in number default hr_api.g_number,

399: p_business_group_id in number default hr_api.g_number,
400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,
404: p_program_update_date in date default hr_api.g_date,
405: p_ext_rslt_id in number default hr_api.g_number
406: ) is
407: --

Line 404: p_program_update_date in date default hr_api.g_date,

400: p_object_version_number in out nocopy number,
401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,
404: p_program_update_date in date default hr_api.g_date,
405: p_ext_rslt_id in number default hr_api.g_number
406: ) is
407: --
408: l_rec ben_xre_shd.g_rec_type;

Line 405: p_ext_rslt_id in number default hr_api.g_number

401: p_request_id in number default hr_api.g_number,
402: p_program_application_id in number default hr_api.g_number,
403: p_program_id in number default hr_api.g_number,
404: p_program_update_date in date default hr_api.g_date,
405: p_ext_rslt_id in number default hr_api.g_number
406: ) is
407: --
408: l_rec ben_xre_shd.g_rec_type;
409: l_proc varchar2(72) := g_package||'upd';