214: hr_utility.set_location(' Entering:' || l_proc,5);
215:
216: -- Call the actual API.
217: hr_person_absence_api.create_person_absence
218: (p_validate => hr_java_conv_util_ss.get_boolean (
219: p_number => p_validate
220: )
221: ,p_effective_date => p_effective_date
222: ,p_person_id => p_person_id
310: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
311: );
312: hr_utility.set_location( l_proc,10);
313:
314: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
311: );
312: hr_utility.set_location( l_proc,10);
313:
314: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
312: hr_utility.set_location( l_proc,10);
313:
314: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
320: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
313:
314: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
320: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
321:
314: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
320: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
321:
322: hr_utility.set_location(' Leaving:' || l_proc,15);
315: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
320: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
321:
322: hr_utility.set_location(' Leaving:' || l_proc,15);
323:
316: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
317: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
318: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
319: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
320: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
321:
322: hr_utility.set_location(' Leaving:' || l_proc,15);
323:
324: EXCEPTION
1239:
1240:
1241: -- Call the actual API.
1242: hr_person_absence_api.update_person_absence
1243: (p_validate => hr_java_conv_util_ss.get_boolean (
1244: p_number => p_validate
1245: )
1246: ,p_effective_date => p_effective_date
1247: -- ,p_business_group_id => p_business_group_id
1332: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
1333: ,p_del_element_entry_warning => lb_del_element_entry_warning
1334: );
1335:
1336: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning );
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1333: ,p_del_element_entry_warning => lb_del_element_entry_warning
1334: );
1335:
1336: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning );
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1334: );
1335:
1336: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning );
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1335:
1336: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning );
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1343: p_del_element_entry_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_del_element_entry_warning);
1336: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning );
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1343: p_del_element_entry_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_del_element_entry_warning);
1344:
1337: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1343: p_del_element_entry_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_del_element_entry_warning);
1344:
1345: hr_utility.set_location(' Leaving:' || l_proc,10);
1338: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1343: p_del_element_entry_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_del_element_entry_warning);
1344:
1345: hr_utility.set_location(' Leaving:' || l_proc,10);
1346:
1339: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
1340: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
1341: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
1342: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
1343: p_del_element_entry_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_del_element_entry_warning);
1344:
1345: hr_utility.set_location(' Leaving:' || l_proc,10);
1346:
1347: EXCEPTION
3641: ,p_abs_day_after_warning => lb_abs_day_after_warning
3642: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
3643: );
3644:
3645: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3642: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
3643: );
3644:
3645: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3643: );
3644:
3645: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3651: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3644:
3645: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3651: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3652:
3645: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3651: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3652:
3653: hr_utility.set_location(' Leaving:' || l_proc,10);
3646: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3651: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3652:
3653: hr_utility.set_location(' Leaving:' || l_proc,10);
3654:
3647: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3648: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3649: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3650: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3651: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3652:
3653: hr_utility.set_location(' Leaving:' || l_proc,10);
3654:
3655: EXCEPTION
3941: ,p_abs_day_after_warning => lb_abs_day_after_warning
3942: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
3943: );
3944:
3945: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3942: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
3943: );
3944:
3945: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3943: );
3944:
3945: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3951: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3944:
3945: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3951: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3952:
3945: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3951: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3952:
3953: -- 2713296 changes start
3946: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3951: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3952:
3953: -- 2713296 changes start
3954: if (lb_abs_day_after_warning OR
3947: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
3948: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
3949: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
3950: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
3951: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
3952:
3953: -- 2713296 changes start
3954: if (lb_abs_day_after_warning OR
3955: lb_abs_overlap_warning OR
3964: lb_abs_overlap_warning := chk_overlap(p_person_id,p_business_group_id,p_date_start,p_date_end,p_time_start,p_time_end);
3965:
3966: if lb_abs_overlap_warning AND p_return_on_warning = 'true' then
3967: hr_utility.set_location(l_proc, 50);
3968: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
3969: return;
3970: end if;
3971: end if;
3972: -- 2713296 changes ends
4955: ,p_del_element_entry_warning => lb_del_element_entry_warning
4956: );
4957: end if;
4958:
4959: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
4960: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
4961:
4962: -- When validate mode is 'TRUE', API always returns null for p_object_version_number
4963: -- p_object_version_number := l_object_version_number; -- WWBUG 2411426
4956: );
4957: end if;
4958:
4959: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
4960: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
4961:
4962: -- When validate mode is 'TRUE', API always returns null for p_object_version_number
4963: -- p_object_version_number := l_object_version_number; -- WWBUG 2411426
4964:
4963: -- p_object_version_number := l_object_version_number; -- WWBUG 2411426
4964:
4965: hr_utility.trace(l_proc || ':p_object_version_number =>'|| to_char(l_object_version_number));
4966:
4967: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
4968: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
4969: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
4970: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
4971: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
4964:
4965: hr_utility.trace(l_proc || ':p_object_version_number =>'|| to_char(l_object_version_number));
4966:
4967: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
4968: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
4969: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
4970: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
4971: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
4972:
4965: hr_utility.trace(l_proc || ':p_object_version_number =>'|| to_char(l_object_version_number));
4966:
4967: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
4968: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
4969: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
4970: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
4971: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
4972:
4973: --2713296 change starts
4966:
4967: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
4968: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
4969: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
4970: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
4971: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
4972:
4973: --2713296 change starts
4974: if (lb_abs_day_after_warning OR
4967: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
4968: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
4969: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
4970: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
4971: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
4972:
4973: --2713296 change starts
4974: if (lb_abs_day_after_warning OR
4975: lb_abs_overlap_warning OR
4985:
4986:
4987: if lb_abs_overlap_warning AND p_return_on_warning = 'true' then
4988: hr_utility.set_location(l_proc, 55);
4989: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
4990: return;
4991: end if;
4992: --2713296 change ends
4993: end if;
5842: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
5843: ,p_del_element_entry_warning => lb_del_element_entry_warning
5844: );
5845:
5846: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5843: ,p_del_element_entry_warning => lb_del_element_entry_warning
5844: );
5845:
5846: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5844: );
5845:
5846: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5852: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
5845:
5846: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5852: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
5853:
5846: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5852: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
5853:
5854: if (lb_abs_day_after_warning OR
5847: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5852: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
5853:
5854: if (lb_abs_day_after_warning OR
5855: lb_abs_overlap_warning OR
5848: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
5849: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
5850: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
5851: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
5852: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
5853:
5854: if (lb_abs_day_after_warning OR
5855: lb_abs_overlap_warning OR
5856: lb_exceeds_pto_entit_warning OR --2848345
5883: END IF; --Dates Not Null
5884:
5885: if lb_abs_overlap_warning and p_return_on_warning = 'true' then --2713296
5886: hr_utility.set_location(l_proc, 40);
5887: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
5888: return;
5889: end if;
5890:
5891: end if; --WARNING CHECK
6680: ,p_dur_overwritten_warning => lb_dur_overwritten_warning
6681: );
6682:
6683:
6684: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6681: );
6682:
6683:
6684: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6682:
6683:
6684: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6690: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
6683:
6684: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6690: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
6691:
6684: p_abs_day_after_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_day_after_warning);
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6690: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
6691:
6692: if (lb_abs_day_after_warning OR
6685: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6690: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
6691:
6692: if (lb_abs_day_after_warning OR
6693: lb_abs_overlap_warning OR
6686: p_dur_dys_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_dys_less_warning);
6687: p_dur_hrs_less_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_hrs_less_warning);
6688: p_exceeds_pto_entit_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_pto_entit_warning);
6689: p_exceeds_run_total_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_exceeds_run_total_warning);
6690: p_dur_overwritten_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_dur_overwritten_warning);
6691:
6692: if (lb_abs_day_after_warning OR
6693: lb_abs_overlap_warning OR
6694: lb_exceeds_pto_entit_warning OR --2848345
6724: -- Fix 2666959 End
6725:
6726: if lb_abs_overlap_warning and p_return_on_warning = 'true' then --2713296
6727: hr_utility.set_location(l_proc, 40);
6728: p_abs_overlap_warning := hr_java_conv_util_ss.get_number(p_boolean => lb_abs_overlap_warning);
6729: return;
6730: end if;
6731: end if;
6732: end if; -- Support Save For Later
9490: --
9491: IF l_sch_based_dur = 'Y' THEN
9492: --
9493: hr_utility.set_location(l_proc, 16);
9494: p_use_formula := hr_java_conv_util_ss.get_number(p_boolean => TRUE);
9495: --
9496: calc_sch_based_dur (p_days_or_hours => l_hours_or_days,
9497: p_date_start => p_date_start,
9498: p_date_end => p_date_end,
9923: hr_utility.set_warning;
9924: end if;
9925:
9926: */
9927: p_use_formula := hr_java_conv_util_ss.get_number(p_boolean => l_use_formula);
9928:
9929: --
9930: -- Bug 4534572 START
9931: --