DBA Data[Home] [Help]

APPS.BEN_PEI_UPD dependencies on HR_API

Line 115: When hr_api.check_integrity_violated Then

111: End If;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 15);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error

Line 120: When hr_api.unique_integrity_violated Then

116: -- A check constraint has been violated
117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End dt_update_dml;

Line 427: when hr_api.cannot_find_prog_unit then

423: );
424: --
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_pl_extract_identifier_f'
431: ,p_hook_type => 'AU');

Line 429: hr_api.cannot_find_prog_unit_error

425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_pl_extract_identifier_f'
431: ,p_hook_type => 'AU');
432: --
433: end;

Line 522: p_pl_id in number default hr_api.g_number,

518: (
519: p_pl_extract_identifier_id in number,
520: p_effective_start_date out nocopy date,
521: p_effective_end_date out nocopy date,
522: p_pl_id in number default hr_api.g_number,
523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,

Line 523: p_plip_id in number default hr_api.g_number,

519: p_pl_extract_identifier_id in number,
520: p_effective_start_date out nocopy date,
521: p_effective_end_date out nocopy date,
522: p_pl_id in number default hr_api.g_number,
523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,

Line 524: p_oipl_id in number default hr_api.g_number,

520: p_effective_start_date out nocopy date,
521: p_effective_end_date out nocopy date,
522: p_pl_id in number default hr_api.g_number,
523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,

Line 525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,

521: p_effective_end_date out nocopy date,
522: p_pl_id in number default hr_api.g_number,
523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,

Line 526: p_organization_id in number default hr_api.g_number,

522: p_pl_id in number default hr_api.g_number,
523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,

Line 527: p_job_id in number default hr_api.g_number,

523: p_plip_id in number default hr_api.g_number,
524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,

Line 528: p_position_id in number default hr_api.g_number,

524: p_oipl_id in number default hr_api.g_number,
525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,

Line 529: p_people_group_id in number default hr_api.g_number,

525: p_third_party_identifier in varchar2 default hr_api.g_varchar2,
526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,

Line 530: p_grade_id in number default hr_api.g_number,

526: p_organization_id in number default hr_api.g_number,
527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,
534: p_business_group_id in number default hr_api.g_number,

Line 531: p_payroll_id in number default hr_api.g_number,

527: p_job_id in number default hr_api.g_number,
528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,
534: p_business_group_id in number default hr_api.g_number,
535: p_object_version_number in out nocopy number,

Line 532: p_home_state in varchar2 default hr_api.g_varchar2,

528: p_position_id in number default hr_api.g_number,
529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,
534: p_business_group_id in number default hr_api.g_number,
535: p_object_version_number in out nocopy number,
536: p_effective_date in date,

Line 533: p_home_zip in varchar2 default hr_api.g_varchar2,

529: p_people_group_id in number default hr_api.g_number,
530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,
534: p_business_group_id in number default hr_api.g_number,
535: p_object_version_number in out nocopy number,
536: p_effective_date in date,
537: p_datetrack_mode in varchar2

Line 534: p_business_group_id in number default hr_api.g_number,

530: p_grade_id in number default hr_api.g_number,
531: p_payroll_id in number default hr_api.g_number,
532: p_home_state in varchar2 default hr_api.g_varchar2,
533: p_home_zip in varchar2 default hr_api.g_varchar2,
534: p_business_group_id in number default hr_api.g_number,
535: p_object_version_number in out nocopy number,
536: p_effective_date in date,
537: p_datetrack_mode in varchar2
538: ) is