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));
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
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));
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;
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');
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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