DBA Data[Home] [Help]

APPS.PAY_PL_SII_API dependencies on HR_API

Line 184: when hr_api.cannot_find_prog_unit then

180: ,p_unemployment_cont_end_reason => p_unemployment_cont_end_reason
181: ,p_effective_date_warning => p_effective_date_warning
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_pl_sii_details'
187: ,p_hook_type => 'BP'
188: );

Line 185: hr_api.cannot_find_prog_unit_error

181: ,p_effective_date_warning => p_effective_date_warning
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_pl_sii_details'
187: ,p_hook_type => 'BP'
188: );
189: end;

Line 256: when hr_api.cannot_find_prog_unit then

252: ,p_effective_end_date => l_effective_end_date
253: ,p_effective_date_warning => p_effective_date_warning);
254:
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'create_pl_sii_details'
259: ,p_hook_type => 'AP'
260: );

Line 257: hr_api.cannot_find_prog_unit_error

253: ,p_effective_date_warning => p_effective_date_warning);
254:
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'create_pl_sii_details'
259: ,p_hook_type => 'AP'
260: );
261: end;

Line 266: raise hr_api.validate_enabled;

262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all IN OUT and OUT parameters with out values
270: --

Line 279: when hr_api.validate_enabled then

275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278: exception
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised
282: -- we must rollback to the savepoint
283: --

Line 733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2

729: ,p_effective_date in date
730: ,p_datetrack_update_mode in varchar2
731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

Line 734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2

730: ,p_datetrack_update_mode in varchar2
731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

Line 735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2

731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2

Line 736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2

732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

Line 737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 739: ,p_health_contribution in varchar2 default hr_api.g_varchar2

735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date

Line 745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date

Line 746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date
750: )

Line 747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date
750: )
751: is

Line 892: when hr_api.cannot_find_prog_unit then

888: ,p_unemployment_cont_end_reason => p_unemployment_cont_end_reason
889: ,p_object_version_number => l_object_version_number
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'update_pl_sii_details'
895: ,p_hook_type => 'BP'
896: );

Line 893: hr_api.cannot_find_prog_unit_error

889: ,p_object_version_number => l_object_version_number
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'update_pl_sii_details'
895: ,p_hook_type => 'BP'
896: );
897: end;

Line 959: when hr_api.cannot_find_prog_unit then

955: ,p_effective_end_date => l_effective_end_date
956: );
957:
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'update_pl_sii_details'
962: ,p_hook_type => 'AP'
963: );

Line 960: hr_api.cannot_find_prog_unit_error

956: );
957:
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'update_pl_sii_details'
962: ,p_hook_type => 'AP'
963: );
964: end;

Line 969: raise hr_api.validate_enabled;

965: --
966: -- When in validation only mode raise the Validate_Enabled exception
967: --
968: if p_validate then
969: raise hr_api.validate_enabled;
970: end if;
971: --
972: -- Set all IN OUT and OUT parameters with out values
973: --

Line 981: when hr_api.validate_enabled then

977:
978: --
979: hr_utility.set_location(' Leaving:'||l_proc, 70);
980: exception
981: when hr_api.validate_enabled then
982: --
983: -- As the Validate_Enabled exception has been raised
984: -- we must rollback to the savepoint
985: --

Line 1073: when hr_api.cannot_find_prog_unit then

1069: ,p_datetrack_delete_mode => p_datetrack_delete_mode
1070: ,p_object_version_number => p_object_version_number
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'delete_pl_sii_details'
1076: ,p_hook_type => 'BP'
1077: );

Line 1074: hr_api.cannot_find_prog_unit_error

1070: ,p_object_version_number => p_object_version_number
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'delete_pl_sii_details'
1076: ,p_hook_type => 'BP'
1077: );
1078: end;

Line 1110: when hr_api.cannot_find_prog_unit then

1106: ,p_effective_end_date => l_effective_end_date
1107: );
1108:
1109: exception
1110: when hr_api.cannot_find_prog_unit then
1111: hr_api.cannot_find_prog_unit_error
1112: (p_module_name => 'delete_pl_sii_details'
1113: ,p_hook_type => 'AP'
1114: );

Line 1111: hr_api.cannot_find_prog_unit_error

1107: );
1108:
1109: exception
1110: when hr_api.cannot_find_prog_unit then
1111: hr_api.cannot_find_prog_unit_error
1112: (p_module_name => 'delete_pl_sii_details'
1113: ,p_hook_type => 'AP'
1114: );
1115: end;

Line 1120: raise hr_api.validate_enabled;

1116: --
1117: -- When in validation only mode raise the Validate_Enabled exception
1118: --
1119: if p_validate then
1120: raise hr_api.validate_enabled;
1121: end if;
1122: --
1123: -- Set all IN OUT and OUT parameters with out values
1124: --

Line 1133: when hr_api.validate_enabled then

1129:
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 70);
1132: exception
1133: when hr_api.validate_enabled then
1134: --
1135: -- As the Validate_Enabled exception has been raised
1136: -- we must rollback to the savepoint
1137: --