DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SITUATIONS_API dependencies on HR_API

Line 120: when hr_api.cannot_find_prog_unit then

116: ,p_max_tot_continuous_duration => p_max_tot_continuous_duration
117: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'CREATE_STATUTORY_SITUATION'
123: ,p_hook_type => 'BP'
124: );

Line 121: hr_api.cannot_find_prog_unit_error

117: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'CREATE_STATUTORY_SITUATION'
123: ,p_hook_type => 'BP'
124: );
125: end;

Line 213: when hr_api.cannot_find_prog_unit then

209: ,p_object_version_number => l_object_version_number
210: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
211: );
212: exception
213: when hr_api.cannot_find_prog_unit then
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'CREATE_STATUTORY_SITUATION'
216: ,p_hook_type => 'AP'
217: );

Line 214: hr_api.cannot_find_prog_unit_error

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

Line 223: raise hr_api.validate_enabled;

219: --
220: -- When in validation only mode raise the Validate_Enabled exception
221: --
222: if p_validate then
223: raise hr_api.validate_enabled;
224: end if;
225: --
226: -- Set all IN OUT and OUT parameters with out values
227: --

Line 238: when hr_api.validate_enabled then

234: --
235: End if;
236:
237: exception
238: when hr_api.validate_enabled then
239: --
240: -- As the Validate_Enabled exception has been raised
241: -- we must rollback to the savepoint
242: --

Line 284: ,p_business_group_id in number default hr_api.g_number

280: ( p_validate in boolean default false
281: ,p_effective_date in date default sysdate
282: ,p_statutory_situation_id in number
283: ,p_object_version_number in out nocopy number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2

Line 285: ,p_situation_name in varchar2 default hr_api.g_varchar2

281: ,p_effective_date in date default sysdate
282: ,p_statutory_situation_id in number
283: ,p_object_version_number in out nocopy number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2

Line 286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

282: ,p_statutory_situation_id in number
283: ,p_object_version_number in out nocopy number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2

Line 287: ,p_situation_type in varchar2 default hr_api.g_varchar2

283: ,p_object_version_number in out nocopy number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2

Line 288: ,p_sub_type in varchar2 default hr_api.g_varchar2

284: ,p_business_group_id in number default hr_api.g_number
285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2

Line 289: ,p_source in varchar2 default hr_api.g_varchar2

285: ,p_situation_name in varchar2 default hr_api.g_varchar2
286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date

Line 290: ,p_location in varchar2 default hr_api.g_varchar2

286: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date

Line 291: ,p_reason in varchar2 default hr_api.g_varchar2

287: ,p_situation_type in varchar2 default hr_api.g_varchar2
288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2

Line 292: ,p_is_default in varchar2 default hr_api.g_varchar2

288: ,p_sub_type in varchar2 default hr_api.g_varchar2
289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

Line 293: ,p_date_from in date default hr_api.g_date

289: ,p_source in varchar2 default hr_api.g_varchar2
290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

Line 294: ,p_date_to in date default hr_api.g_date

290: ,p_location in varchar2 default hr_api.g_varchar2
291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2

Line 295: ,p_request_type in varchar2 default hr_api.g_varchar2

291: ,p_reason in varchar2 default hr_api.g_varchar2
292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2

Line 296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

292: ,p_is_default in varchar2 default hr_api.g_varchar2
293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

Line 297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

293: ,p_date_from in date default hr_api.g_date
294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

Line 298: ,p_print_arrette in varchar2 default hr_api.g_varchar2

294: ,p_date_to in date default hr_api.g_date
295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

Line 299: ,p_reserve_position in varchar2 default hr_api.g_varchar2

295: ,p_request_type in varchar2 default hr_api.g_varchar2
296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number

Line 300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

296: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number

Line 301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

297: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

298: ,p_print_arrette in varchar2 default hr_api.g_varchar2
299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number

Line 303: ,p_pay_share in number default hr_api.g_number

299: ,p_reserve_position in varchar2 default hr_api.g_varchar2
300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number

Line 304: ,p_pay_periods in number default hr_api.g_number

300: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number

Line 305: ,p_frequency in varchar2 default hr_api.g_varchar2

301: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number

Line 306: ,p_first_period_max_duration in number default hr_api.g_number

302: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

Line 307: ,p_min_duration_per_request in number default hr_api.g_number

303: ,p_pay_share in number default hr_api.g_number
304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number

Line 308: ,p_max_duration_per_request in number default hr_api.g_number

304: ,p_pay_periods in number default hr_api.g_number
305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number

Line 309: ,p_max_duration_whole_career in number default hr_api.g_number

305: ,p_frequency in varchar2 default hr_api.g_varchar2
306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number

Line 310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

306: ,p_first_period_max_duration in number default hr_api.g_number
307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number
314: ,p_remunerate_assign_status_id in number default hr_api.g_number

Line 311: ,p_max_no_of_renewals in number default hr_api.g_number

307: ,p_min_duration_per_request in number default hr_api.g_number
308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number
314: ,p_remunerate_assign_status_id in number default hr_api.g_number
315: ) is

Line 312: ,p_max_duration_per_renewal in number default hr_api.g_number

308: ,p_max_duration_per_request in number default hr_api.g_number
309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number
314: ,p_remunerate_assign_status_id in number default hr_api.g_number
315: ) is
316: --

Line 313: ,p_max_tot_continuous_duration in number default hr_api.g_number

309: ,p_max_duration_whole_career in number default hr_api.g_number
310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number
314: ,p_remunerate_assign_status_id in number default hr_api.g_number
315: ) is
316: --
317: -- Declare cursors and local variables

Line 314: ,p_remunerate_assign_status_id in number default hr_api.g_number

310: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
311: ,p_max_no_of_renewals in number default hr_api.g_number
312: ,p_max_duration_per_renewal in number default hr_api.g_number
313: ,p_max_tot_continuous_duration in number default hr_api.g_number
314: ,p_remunerate_assign_status_id in number default hr_api.g_number
315: ) is
316: --
317: -- Declare cursors and local variables
318: --

Line 393: when hr_api.cannot_find_prog_unit then

389: ,p_object_version_number => l_object_version_number
390: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'UPDATE_STATUTORY_SITUATION'
396: ,p_hook_type => 'BP'
397: );

Line 394: hr_api.cannot_find_prog_unit_error

390: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'UPDATE_STATUTORY_SITUATION'
396: ,p_hook_type => 'BP'
397: );
398: end;

Line 484: when hr_api.cannot_find_prog_unit then

480: ,p_object_version_number => l_object_version_number
481: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
482: );
483: exception
484: when hr_api.cannot_find_prog_unit then
485: hr_api.cannot_find_prog_unit_error
486: (p_module_name => 'UPDATE_STATUTORY_SITUATION'
487: ,p_hook_type => 'AP'
488: );

Line 485: hr_api.cannot_find_prog_unit_error

481: ,p_remunerate_assign_status_id => p_remunerate_assign_status_id
482: );
483: exception
484: when hr_api.cannot_find_prog_unit then
485: hr_api.cannot_find_prog_unit_error
486: (p_module_name => 'UPDATE_STATUTORY_SITUATION'
487: ,p_hook_type => 'AP'
488: );
489: end;

Line 494: raise hr_api.validate_enabled;

490: --
491: -- When in validation only mode raise the Validate_Enabled exception
492: --
493: if p_validate then
494: raise hr_api.validate_enabled;
495: end if;
496: --
497: -- Set all IN OUT and OUT parameters with out values
498: --

Line 508: when hr_api.validate_enabled then

504: --
505: End if;
506:
507: exception
508: when hr_api.validate_enabled then
509: --
510: -- As the Validate_Enabled exception has been raised
511: -- we must rollback to the savepoint
512: --

Line 615: when hr_api.cannot_find_prog_unit then

611: ,p_object_version_number => l_object_version_number
612: );
613:
614: exception
615: when hr_api.cannot_find_prog_unit then
616: hr_api.cannot_find_prog_unit_error
617: (p_module_name => 'DELETE_STATUTORY_SITUATION'
618: ,p_hook_type => 'BP'
619: );

Line 616: hr_api.cannot_find_prog_unit_error

612: );
613:
614: exception
615: when hr_api.cannot_find_prog_unit then
616: hr_api.cannot_find_prog_unit_error
617: (p_module_name => 'DELETE_STATUTORY_SITUATION'
618: ,p_hook_type => 'BP'
619: );
620: end;

Line 643: when hr_api.cannot_find_prog_unit then

639: p_statutory_situation_id => p_statutory_situation_id
640: ,p_object_version_number => l_object_version_number
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'DELETE_STATUTORY_SITUATION'
646: ,p_hook_type => 'AP'
647: );

Line 644: hr_api.cannot_find_prog_unit_error

640: ,p_object_version_number => l_object_version_number
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'DELETE_STATUTORY_SITUATION'
646: ,p_hook_type => 'AP'
647: );
648: end;

Line 653: raise hr_api.validate_enabled;

649: --
650: -- When in validation only mode raise the Validate_Enabled exception
651: --
652: if p_validate then
653: raise hr_api.validate_enabled;
654: end if;
655: --
656: -- Set all IN OUT and OUT parameters with out values
657: --

Line 667: when hr_api.validate_enabled then

663: --
664: End if;
665:
666: exception
667: when hr_api.validate_enabled then
668: --
669: -- As the Validate_Enabled exception has been raised
670: -- we must rollback to the savepoint
671: --