[Home] [Help]
107: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';
108:
109: begin
110:
111: hr_utility.set_location('Entering: '|| l_proc, 10);
112:
113: if (p_rec_type = 'O') then
114: l_absence_rec := per_abs_shd.g_old_rec;
115: else
199: p_ben_rec.abs_information28 := l_absence_rec.abs_information28;
200: p_ben_rec.abs_information29 := l_absence_rec.abs_information29;
201: p_ben_rec.abs_information30 := l_absence_rec.abs_information30;
202:
203: hr_utility.set_location('Leaving: '|| l_proc, 15);
204: end;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |----------------------< create_person_absence >---------------------------|
353: l_enty_efsd date;
354: l_entry_efed date;
355:
356: begin
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358:
359: --
360: -- Pipe the main IN / IN OUT parameters for ease of debugging.
361: --
358:
359: --
360: -- Pipe the main IN / IN OUT parameters for ease of debugging.
361: --
362: hr_utility.trace(' ');
363: hr_utility.trace(' --------------------------------'||
364: '---------------------------------');
365: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
366: ' VALUE');
359: --
360: -- Pipe the main IN / IN OUT parameters for ease of debugging.
361: --
362: hr_utility.trace(' ');
363: hr_utility.trace(' --------------------------------'||
364: '---------------------------------');
365: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
366: ' VALUE');
367: hr_utility.trace(' --------------------------------'||
361: --
362: hr_utility.trace(' ');
363: hr_utility.trace(' --------------------------------'||
364: '---------------------------------');
365: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
366: ' VALUE');
367: hr_utility.trace(' --------------------------------'||
368: '+--------------------------------');
369: hr_utility.trace(' p_effective_date '||
363: hr_utility.trace(' --------------------------------'||
364: '---------------------------------');
365: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
366: ' VALUE');
367: hr_utility.trace(' --------------------------------'||
368: '+--------------------------------');
369: hr_utility.trace(' p_effective_date '||
370: to_char(p_effective_date));
371: hr_utility.trace(' p_person_id '||
365: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
366: ' VALUE');
367: hr_utility.trace(' --------------------------------'||
368: '+--------------------------------');
369: hr_utility.trace(' p_effective_date '||
370: to_char(p_effective_date));
371: hr_utility.trace(' p_person_id '||
372: to_char(p_person_id));
373: hr_utility.trace(' p_business_group_id '||
367: hr_utility.trace(' --------------------------------'||
368: '+--------------------------------');
369: hr_utility.trace(' p_effective_date '||
370: to_char(p_effective_date));
371: hr_utility.trace(' p_person_id '||
372: to_char(p_person_id));
373: hr_utility.trace(' p_business_group_id '||
374: to_char(p_business_group_id));
375: hr_utility.trace(' p_absence_attendance_type_id '||
369: hr_utility.trace(' p_effective_date '||
370: to_char(p_effective_date));
371: hr_utility.trace(' p_person_id '||
372: to_char(p_person_id));
373: hr_utility.trace(' p_business_group_id '||
374: to_char(p_business_group_id));
375: hr_utility.trace(' p_absence_attendance_type_id '||
376: to_char(p_absence_attendance_type_id));
377: hr_utility.trace(' p_abs_attendance_reason_id '||
371: hr_utility.trace(' p_person_id '||
372: to_char(p_person_id));
373: hr_utility.trace(' p_business_group_id '||
374: to_char(p_business_group_id));
375: hr_utility.trace(' p_absence_attendance_type_id '||
376: to_char(p_absence_attendance_type_id));
377: hr_utility.trace(' p_abs_attendance_reason_id '||
378: to_char(p_abs_attendance_reason_id));
379: hr_utility.trace(' p_date_notification '||
373: hr_utility.trace(' p_business_group_id '||
374: to_char(p_business_group_id));
375: hr_utility.trace(' p_absence_attendance_type_id '||
376: to_char(p_absence_attendance_type_id));
377: hr_utility.trace(' p_abs_attendance_reason_id '||
378: to_char(p_abs_attendance_reason_id));
379: hr_utility.trace(' p_date_notification '||
380: to_char(p_date_notification));
381: hr_utility.trace(' p_date_projected_start '||
375: hr_utility.trace(' p_absence_attendance_type_id '||
376: to_char(p_absence_attendance_type_id));
377: hr_utility.trace(' p_abs_attendance_reason_id '||
378: to_char(p_abs_attendance_reason_id));
379: hr_utility.trace(' p_date_notification '||
380: to_char(p_date_notification));
381: hr_utility.trace(' p_date_projected_start '||
382: to_char(p_date_projected_start));
383: hr_utility.trace(' p_time_projected_start '||
377: hr_utility.trace(' p_abs_attendance_reason_id '||
378: to_char(p_abs_attendance_reason_id));
379: hr_utility.trace(' p_date_notification '||
380: to_char(p_date_notification));
381: hr_utility.trace(' p_date_projected_start '||
382: to_char(p_date_projected_start));
383: hr_utility.trace(' p_time_projected_start '||
384: p_time_projected_start);
385: hr_utility.trace(' p_date_projected_end '||
379: hr_utility.trace(' p_date_notification '||
380: to_char(p_date_notification));
381: hr_utility.trace(' p_date_projected_start '||
382: to_char(p_date_projected_start));
383: hr_utility.trace(' p_time_projected_start '||
384: p_time_projected_start);
385: hr_utility.trace(' p_date_projected_end '||
386: to_char(p_date_projected_end));
387: hr_utility.trace(' p_time_projected_end '||
381: hr_utility.trace(' p_date_projected_start '||
382: to_char(p_date_projected_start));
383: hr_utility.trace(' p_time_projected_start '||
384: p_time_projected_start);
385: hr_utility.trace(' p_date_projected_end '||
386: to_char(p_date_projected_end));
387: hr_utility.trace(' p_time_projected_end '||
388: p_time_projected_end);
389: hr_utility.trace(' p_date_start '||
383: hr_utility.trace(' p_time_projected_start '||
384: p_time_projected_start);
385: hr_utility.trace(' p_date_projected_end '||
386: to_char(p_date_projected_end));
387: hr_utility.trace(' p_time_projected_end '||
388: p_time_projected_end);
389: hr_utility.trace(' p_date_start '||
390: to_char(p_date_start));
391: hr_utility.trace(' p_time_start '||
385: hr_utility.trace(' p_date_projected_end '||
386: to_char(p_date_projected_end));
387: hr_utility.trace(' p_time_projected_end '||
388: p_time_projected_end);
389: hr_utility.trace(' p_date_start '||
390: to_char(p_date_start));
391: hr_utility.trace(' p_time_start '||
392: p_time_start);
393: hr_utility.trace(' p_date_end '||
387: hr_utility.trace(' p_time_projected_end '||
388: p_time_projected_end);
389: hr_utility.trace(' p_date_start '||
390: to_char(p_date_start));
391: hr_utility.trace(' p_time_start '||
392: p_time_start);
393: hr_utility.trace(' p_date_end '||
394: to_char(p_date_end));
395: hr_utility.trace(' p_time_end '||
389: hr_utility.trace(' p_date_start '||
390: to_char(p_date_start));
391: hr_utility.trace(' p_time_start '||
392: p_time_start);
393: hr_utility.trace(' p_date_end '||
394: to_char(p_date_end));
395: hr_utility.trace(' p_time_end '||
396: p_time_end);
397: hr_utility.trace(' p_absence_days '||
391: hr_utility.trace(' p_time_start '||
392: p_time_start);
393: hr_utility.trace(' p_date_end '||
394: to_char(p_date_end));
395: hr_utility.trace(' p_time_end '||
396: p_time_end);
397: hr_utility.trace(' p_absence_days '||
398: to_char(p_absence_days));
399: hr_utility.trace(' p_absence_hours '||
393: hr_utility.trace(' p_date_end '||
394: to_char(p_date_end));
395: hr_utility.trace(' p_time_end '||
396: p_time_end);
397: hr_utility.trace(' p_absence_days '||
398: to_char(p_absence_days));
399: hr_utility.trace(' p_absence_hours '||
400: to_char(p_absence_hours));
401: hr_utility.trace(' p_authorising_person_id '||
395: hr_utility.trace(' p_time_end '||
396: p_time_end);
397: hr_utility.trace(' p_absence_days '||
398: to_char(p_absence_days));
399: hr_utility.trace(' p_absence_hours '||
400: to_char(p_absence_hours));
401: hr_utility.trace(' p_authorising_person_id '||
402: to_char(p_authorising_person_id));
403: hr_utility.trace(' p_batch_id '||
397: hr_utility.trace(' p_absence_days '||
398: to_char(p_absence_days));
399: hr_utility.trace(' p_absence_hours '||
400: to_char(p_absence_hours));
401: hr_utility.trace(' p_authorising_person_id '||
402: to_char(p_authorising_person_id));
403: hr_utility.trace(' p_batch_id '||
404: to_char(p_batch_id));
405: if p_create_element_entry then
399: hr_utility.trace(' p_absence_hours '||
400: to_char(p_absence_hours));
401: hr_utility.trace(' p_authorising_person_id '||
402: to_char(p_authorising_person_id));
403: hr_utility.trace(' p_batch_id '||
404: to_char(p_batch_id));
405: if p_create_element_entry then
406: hr_utility.trace(' p_create_element_entry '||
407: 'TRUE');
402: to_char(p_authorising_person_id));
403: hr_utility.trace(' p_batch_id '||
404: to_char(p_batch_id));
405: if p_create_element_entry then
406: hr_utility.trace(' p_create_element_entry '||
407: 'TRUE');
408: else
409: hr_utility.trace(' p_create_element_entry '||
410: 'FALSE');
405: if p_create_element_entry then
406: hr_utility.trace(' p_create_element_entry '||
407: 'TRUE');
408: else
409: hr_utility.trace(' p_create_element_entry '||
410: 'FALSE');
411: end if;
412: hr_utility.trace(' --------------------------------'||
413: '---------------------------------');
408: else
409: hr_utility.trace(' p_create_element_entry '||
410: 'FALSE');
411: end if;
412: hr_utility.trace(' --------------------------------'||
413: '---------------------------------');
414: hr_utility.trace(' ');
415:
416: --
410: 'FALSE');
411: end if;
412: hr_utility.trace(' --------------------------------'||
413: '---------------------------------');
414: hr_utility.trace(' ');
415:
416: --
417: -- Create a savepoint.
418: --
421: -- Truncate the time portion from all IN date parameters
422: --
423:
424: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
425: hr_utility.set_location(' OTL ABS integration on ',10);
426:
427: open csr_get_abstype;
428: fetch csr_get_abstype into l_hours_or_days,l_elm_entry_id;
429: close csr_get_abstype;
427: open csr_get_abstype;
428: fetch csr_get_abstype into l_hours_or_days,l_elm_entry_id;
429: close csr_get_abstype;
430:
431: hr_utility.set_location(' l_inputvalue_id : '|| l_elm_entry_id,10);
432:
433: if l_elm_entry_id is not null then
434:
435:
432:
433: if l_elm_entry_id is not null then
434:
435:
436: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,10);
437: if l_hours_or_days ='H' then
438: -- when the UOM attached to the element is Hours
439:
440: if p_date_start is null then
439:
440: if p_date_start is null then
441:
442: if p_date_projected_start is null then
443: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
444: hr_utility.raise_error;
445: end if;
446:
447: if p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null then
440: if p_date_start is null then
441:
442: if p_date_projected_start is null then
443: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
444: hr_utility.raise_error;
445: end if;
446:
447: if p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null then
448: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
444: hr_utility.raise_error;
445: end if;
446:
447: if p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null then
448: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
449: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
450: hr_utility.raise_error;
451: end if;
452:
445: end if;
446:
447: if p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null then
448: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
449: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
450: hr_utility.raise_error;
451: end if;
452:
453: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
446:
447: if p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null then
448: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
449: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
450: hr_utility.raise_error;
451: end if;
452:
453: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
454:
449: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
450: hr_utility.raise_error;
451: end if;
452:
453: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
454:
455: else
456: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,40);
457:
452:
453: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
454:
455: else
456: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,40);
457:
458: if p_date_projected_start is not null and
459: (p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null ) then
460:
457:
458: if p_date_projected_start is not null and
459: (p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null ) then
460:
461: hr_utility.set_message (800,'HR_449866_START_END_DATES3');
462: hr_utility.raise_error;
463: end if;
464:
465: if p_date_end is null or p_time_end is null or p_time_start is null then
458: if p_date_projected_start is not null and
459: (p_time_projected_start is null or p_date_projected_end is null or p_time_projected_end is null ) then
460:
461: hr_utility.set_message (800,'HR_449866_START_END_DATES3');
462: hr_utility.raise_error;
463: end if;
464:
465: if p_date_end is null or p_time_end is null or p_time_start is null then
466:
463: end if;
464:
465: if p_date_end is null or p_time_end is null or p_time_start is null then
466:
467: hr_utility.set_message (800,'HR_449867_START_END_DATES4');
468: hr_utility.raise_error;
469: end if;
470: end if;
471:
464:
465: if p_date_end is null or p_time_end is null or p_time_start is null then
466:
467: hr_utility.set_message (800,'HR_449867_START_END_DATES4');
468: hr_utility.raise_error;
469: end if;
470: end if;
471:
472: else
473: -- when the UOM is Days
474: if p_date_start is null then
475:
476: if p_date_projected_start is null then
477: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
478: hr_utility.raise_error;
479:
480: elsif p_date_projected_end is null then
481:
474: if p_date_start is null then
475:
476: if p_date_projected_start is null then
477: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
478: hr_utility.raise_error;
479:
480: elsif p_date_projected_end is null then
481:
482: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
478: hr_utility.raise_error;
479:
480: elsif p_date_projected_end is null then
481:
482: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
483: hr_utility.raise_error;
484: end if;
485:
486: else
479:
480: elsif p_date_projected_end is null then
481:
482: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
483: hr_utility.raise_error;
484: end if;
485:
486: else
487:
486: else
487:
488: if p_date_projected_start is not null and p_date_projected_end is null then
489:
490: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
491: hr_utility.raise_error;
492: end if;
493:
494: if p_date_end is null then
487:
488: if p_date_projected_start is not null and p_date_projected_end is null then
489:
490: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
491: hr_utility.raise_error;
492: end if;
493:
494: if p_date_end is null then
495:
492: end if;
493:
494: if p_date_end is null then
495:
496: hr_utility.set_message (800,'HR_449865_START_END_DATES2');
497: hr_utility.raise_error;
498: end if;
499:
500: end if;
493:
494: if p_date_end is null then
495:
496: hr_utility.set_message (800,'HR_449865_START_END_DATES2');
497: hr_utility.raise_error;
498: end if;
499:
500: end if;
501:
505: l_chk_dateend := nvl(p_date_end,p_date_projected_end);
506:
507: if p_called_from <> 809 and l_chk_datestart is not null and l_chk_dateend is not null
508: then
509: hr_utility.set_location('inside otl hr check ', 10);
510:
511: otl_hr_check
512: (
513: p_person_id => p_person_id,
515: p_date_end => l_chk_dateend,
516: p_scope => 'CREATE',
517: p_ret_value => l_retvalue );
518:
519: hr_utility.set_location('after otl hr check ', 10);
520: end if;
521:
522: end if;
523: end if;
631: ,p_hook_type => 'BP'
632: );
633: end;
634:
635: hr_utility.set_location(l_proc, 30);
636: --
637: -- Insert Person Absence
638: per_abs_ins.ins
639: (p_effective_date => l_effective_date
738: p_abs_overlap_warning := l_abs_overlap_warning;
739: p_abs_day_after_warning := l_abs_day_after_warning;
740: p_dur_overwritten_warning := l_dur_overwritten_warning;
741:
742: hr_utility.set_location('Start of absence element entry section', 40);
743:
744: /* Start of Absence Element Entry Section */
745:
746: if p_create_element_entry then
798:
799: end if;
800: /* End of Absence Element Entry Section */
801:
802: hr_utility.set_location('End of absence element entry section', 50);
803:
804: populate_ben_absence_rec
805: (p_absence_attendance_id => l_absence_attendance_id,
806: p_rec_type => 'N',
808:
809: --
810: -- Start of BEN call.
811: --
812: hr_utility.set_location('Start of BEN call', 52);
813:
814: ben_abs_ler.ler_chk
815: (p_old => l_old
816: ,p_new => l_new
815: (p_old => l_old
816: ,p_new => l_new
817: ,p_effective_date => l_effective_date);
818:
819: hr_utility.set_location('End of BEN call', 54);
820:
821: --
822: -- Call After Process User Hook
823: --
943:
944: --
945: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
946: --
947: hr_utility.trace(' ');
948: hr_utility.trace(' --------------------------------'||
949: '---------------------------------');
950: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
951: ' VALUE');
944: --
945: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
946: --
947: hr_utility.trace(' ');
948: hr_utility.trace(' --------------------------------'||
949: '---------------------------------');
950: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
951: ' VALUE');
952: hr_utility.trace(' --------------------------------'||
946: --
947: hr_utility.trace(' ');
948: hr_utility.trace(' --------------------------------'||
949: '---------------------------------');
950: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
951: ' VALUE');
952: hr_utility.trace(' --------------------------------'||
953: '+--------------------------------');
954: hr_utility.trace(' p_absence_days '||
948: hr_utility.trace(' --------------------------------'||
949: '---------------------------------');
950: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
951: ' VALUE');
952: hr_utility.trace(' --------------------------------'||
953: '+--------------------------------');
954: hr_utility.trace(' p_absence_days '||
955: to_char(p_absence_days));
956: hr_utility.trace(' p_absence_hours '||
950: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
951: ' VALUE');
952: hr_utility.trace(' --------------------------------'||
953: '+--------------------------------');
954: hr_utility.trace(' p_absence_days '||
955: to_char(p_absence_days));
956: hr_utility.trace(' p_absence_hours '||
957: to_char(p_absence_hours));
958: hr_utility.trace(' p_absence_attendance_id '||
952: hr_utility.trace(' --------------------------------'||
953: '+--------------------------------');
954: hr_utility.trace(' p_absence_days '||
955: to_char(p_absence_days));
956: hr_utility.trace(' p_absence_hours '||
957: to_char(p_absence_hours));
958: hr_utility.trace(' p_absence_attendance_id '||
959: to_char(p_absence_attendance_id));
960: hr_utility.trace(' p_object_version_number '||
954: hr_utility.trace(' p_absence_days '||
955: to_char(p_absence_days));
956: hr_utility.trace(' p_absence_hours '||
957: to_char(p_absence_hours));
958: hr_utility.trace(' p_absence_attendance_id '||
959: to_char(p_absence_attendance_id));
960: hr_utility.trace(' p_object_version_number '||
961: to_char(p_object_version_number));
962: hr_utility.trace(' p_occurrence '||
956: hr_utility.trace(' p_absence_hours '||
957: to_char(p_absence_hours));
958: hr_utility.trace(' p_absence_attendance_id '||
959: to_char(p_absence_attendance_id));
960: hr_utility.trace(' p_object_version_number '||
961: to_char(p_object_version_number));
962: hr_utility.trace(' p_occurrence '||
963: to_char(p_occurrence));
964: hr_utility.trace(' --------------------------------'||
958: hr_utility.trace(' p_absence_attendance_id '||
959: to_char(p_absence_attendance_id));
960: hr_utility.trace(' p_object_version_number '||
961: to_char(p_object_version_number));
962: hr_utility.trace(' p_occurrence '||
963: to_char(p_occurrence));
964: hr_utility.trace(' --------------------------------'||
965: '---------------------------------');
966: hr_utility.trace(' ');
960: hr_utility.trace(' p_object_version_number '||
961: to_char(p_object_version_number));
962: hr_utility.trace(' p_occurrence '||
963: to_char(p_occurrence));
964: hr_utility.trace(' --------------------------------'||
965: '---------------------------------');
966: hr_utility.trace(' ');
967:
968: hr_utility.set_location(' Leaving:'||l_proc, 70);
962: hr_utility.trace(' p_occurrence '||
963: to_char(p_occurrence));
964: hr_utility.trace(' --------------------------------'||
965: '---------------------------------');
966: hr_utility.trace(' ');
967:
968: hr_utility.set_location(' Leaving:'||l_proc, 70);
969:
970: exception
964: hr_utility.trace(' --------------------------------'||
965: '---------------------------------');
966: hr_utility.trace(' ');
967:
968: hr_utility.set_location(' Leaving:'||l_proc, 70);
969:
970: exception
971: when hr_api.validate_enabled then
972: --
980: -- when validation only mode is being used.)
981: --
982: p_absence_attendance_id := null;
983: p_object_version_number := null;
984: hr_utility.set_location(l_proc, 80);
985: when others then
986: --
987: -- A validation or unexpected error has occured
988: --
997: p_abs_day_after_warning := null;
998: p_dur_overwritten_warning := null;
999:
1000: rollback to create_person_absence;
1001: hr_utility.set_location(' Leaving:'||l_proc, 90);
1002: raise;
1003: end create_person_absence;
1004: --
1005: -- ----------------------------------------------------------------------------
1217: --
1218:
1219: begin
1220:
1221: hr_utility.set_location('Entering:'|| l_proc, 10);
1222: --
1223: lv_object_version_number := p_object_version_number ;
1224: lv_absence_days := p_absence_days ;
1225: lv_absence_hours := p_absence_hours ;
1230:
1231: --
1232: -- Pipe the main IN / IN OUT parameters for ease of debugging.
1233: --
1234: hr_utility.trace(' ');
1235: hr_utility.trace(' --------------------------------'||
1236: '---------------------------------');
1237: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1238: ' VALUE');
1231: --
1232: -- Pipe the main IN / IN OUT parameters for ease of debugging.
1233: --
1234: hr_utility.trace(' ');
1235: hr_utility.trace(' --------------------------------'||
1236: '---------------------------------');
1237: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1238: ' VALUE');
1239: hr_utility.trace(' --------------------------------'||
1233: --
1234: hr_utility.trace(' ');
1235: hr_utility.trace(' --------------------------------'||
1236: '---------------------------------');
1237: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1238: ' VALUE');
1239: hr_utility.trace(' --------------------------------'||
1240: '+--------------------------------');
1241: hr_utility.trace(' p_effective_date '||
1235: hr_utility.trace(' --------------------------------'||
1236: '---------------------------------');
1237: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1238: ' VALUE');
1239: hr_utility.trace(' --------------------------------'||
1240: '+--------------------------------');
1241: hr_utility.trace(' p_effective_date '||
1242: to_char(p_effective_date));
1243: hr_utility.trace(' p_absence_attendance_id '||
1237: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1238: ' VALUE');
1239: hr_utility.trace(' --------------------------------'||
1240: '+--------------------------------');
1241: hr_utility.trace(' p_effective_date '||
1242: to_char(p_effective_date));
1243: hr_utility.trace(' p_absence_attendance_id '||
1244: to_char(p_absence_attendance_id));
1245: hr_utility.trace(' p_abs_attendance_reason_id '||
1239: hr_utility.trace(' --------------------------------'||
1240: '+--------------------------------');
1241: hr_utility.trace(' p_effective_date '||
1242: to_char(p_effective_date));
1243: hr_utility.trace(' p_absence_attendance_id '||
1244: to_char(p_absence_attendance_id));
1245: hr_utility.trace(' p_abs_attendance_reason_id '||
1246: to_char(p_abs_attendance_reason_id));
1247: hr_utility.trace(' p_date_notification '||
1241: hr_utility.trace(' p_effective_date '||
1242: to_char(p_effective_date));
1243: hr_utility.trace(' p_absence_attendance_id '||
1244: to_char(p_absence_attendance_id));
1245: hr_utility.trace(' p_abs_attendance_reason_id '||
1246: to_char(p_abs_attendance_reason_id));
1247: hr_utility.trace(' p_date_notification '||
1248: to_char(p_date_notification));
1249: hr_utility.trace(' p_date_projected_start '||
1243: hr_utility.trace(' p_absence_attendance_id '||
1244: to_char(p_absence_attendance_id));
1245: hr_utility.trace(' p_abs_attendance_reason_id '||
1246: to_char(p_abs_attendance_reason_id));
1247: hr_utility.trace(' p_date_notification '||
1248: to_char(p_date_notification));
1249: hr_utility.trace(' p_date_projected_start '||
1250: to_char(p_date_projected_start));
1251: hr_utility.trace(' p_time_projected_start '||
1245: hr_utility.trace(' p_abs_attendance_reason_id '||
1246: to_char(p_abs_attendance_reason_id));
1247: hr_utility.trace(' p_date_notification '||
1248: to_char(p_date_notification));
1249: hr_utility.trace(' p_date_projected_start '||
1250: to_char(p_date_projected_start));
1251: hr_utility.trace(' p_time_projected_start '||
1252: p_time_projected_start);
1253: hr_utility.trace(' p_date_projected_end '||
1247: hr_utility.trace(' p_date_notification '||
1248: to_char(p_date_notification));
1249: hr_utility.trace(' p_date_projected_start '||
1250: to_char(p_date_projected_start));
1251: hr_utility.trace(' p_time_projected_start '||
1252: p_time_projected_start);
1253: hr_utility.trace(' p_date_projected_end '||
1254: to_char(p_date_projected_end));
1255: hr_utility.trace(' p_time_projected_end '||
1249: hr_utility.trace(' p_date_projected_start '||
1250: to_char(p_date_projected_start));
1251: hr_utility.trace(' p_time_projected_start '||
1252: p_time_projected_start);
1253: hr_utility.trace(' p_date_projected_end '||
1254: to_char(p_date_projected_end));
1255: hr_utility.trace(' p_time_projected_end '||
1256: p_time_projected_end);
1257: hr_utility.trace(' p_date_start '||
1251: hr_utility.trace(' p_time_projected_start '||
1252: p_time_projected_start);
1253: hr_utility.trace(' p_date_projected_end '||
1254: to_char(p_date_projected_end));
1255: hr_utility.trace(' p_time_projected_end '||
1256: p_time_projected_end);
1257: hr_utility.trace(' p_date_start '||
1258: to_char(p_date_start));
1259: hr_utility.trace(' p_time_start '||
1253: hr_utility.trace(' p_date_projected_end '||
1254: to_char(p_date_projected_end));
1255: hr_utility.trace(' p_time_projected_end '||
1256: p_time_projected_end);
1257: hr_utility.trace(' p_date_start '||
1258: to_char(p_date_start));
1259: hr_utility.trace(' p_time_start '||
1260: p_time_start);
1261: hr_utility.trace(' p_date_end '||
1255: hr_utility.trace(' p_time_projected_end '||
1256: p_time_projected_end);
1257: hr_utility.trace(' p_date_start '||
1258: to_char(p_date_start));
1259: hr_utility.trace(' p_time_start '||
1260: p_time_start);
1261: hr_utility.trace(' p_date_end '||
1262: to_char(p_date_end));
1263: hr_utility.trace(' p_time_end '||
1257: hr_utility.trace(' p_date_start '||
1258: to_char(p_date_start));
1259: hr_utility.trace(' p_time_start '||
1260: p_time_start);
1261: hr_utility.trace(' p_date_end '||
1262: to_char(p_date_end));
1263: hr_utility.trace(' p_time_end '||
1264: p_time_end);
1265: hr_utility.trace(' p_absence_days '||
1259: hr_utility.trace(' p_time_start '||
1260: p_time_start);
1261: hr_utility.trace(' p_date_end '||
1262: to_char(p_date_end));
1263: hr_utility.trace(' p_time_end '||
1264: p_time_end);
1265: hr_utility.trace(' p_absence_days '||
1266: to_char(p_absence_days));
1267: hr_utility.trace(' p_absence_hours '||
1261: hr_utility.trace(' p_date_end '||
1262: to_char(p_date_end));
1263: hr_utility.trace(' p_time_end '||
1264: p_time_end);
1265: hr_utility.trace(' p_absence_days '||
1266: to_char(p_absence_days));
1267: hr_utility.trace(' p_absence_hours '||
1268: to_char(p_absence_hours));
1269: hr_utility.trace(' p_authorising_person_id '||
1263: hr_utility.trace(' p_time_end '||
1264: p_time_end);
1265: hr_utility.trace(' p_absence_days '||
1266: to_char(p_absence_days));
1267: hr_utility.trace(' p_absence_hours '||
1268: to_char(p_absence_hours));
1269: hr_utility.trace(' p_authorising_person_id '||
1270: to_char(p_authorising_person_id));
1271: hr_utility.trace(' p_batch_id '||
1265: hr_utility.trace(' p_absence_days '||
1266: to_char(p_absence_days));
1267: hr_utility.trace(' p_absence_hours '||
1268: to_char(p_absence_hours));
1269: hr_utility.trace(' p_authorising_person_id '||
1270: to_char(p_authorising_person_id));
1271: hr_utility.trace(' p_batch_id '||
1272: to_char(p_batch_id));
1273: hr_utility.trace(' p_object_version_number '||
1267: hr_utility.trace(' p_absence_hours '||
1268: to_char(p_absence_hours));
1269: hr_utility.trace(' p_authorising_person_id '||
1270: to_char(p_authorising_person_id));
1271: hr_utility.trace(' p_batch_id '||
1272: to_char(p_batch_id));
1273: hr_utility.trace(' p_object_version_number '||
1274: to_char(p_object_version_number));
1275: hr_utility.trace(' --------------------------------'||
1269: hr_utility.trace(' p_authorising_person_id '||
1270: to_char(p_authorising_person_id));
1271: hr_utility.trace(' p_batch_id '||
1272: to_char(p_batch_id));
1273: hr_utility.trace(' p_object_version_number '||
1274: to_char(p_object_version_number));
1275: hr_utility.trace(' --------------------------------'||
1276: '---------------------------------');
1277: hr_utility.trace(' ');
1271: hr_utility.trace(' p_batch_id '||
1272: to_char(p_batch_id));
1273: hr_utility.trace(' p_object_version_number '||
1274: to_char(p_object_version_number));
1275: hr_utility.trace(' --------------------------------'||
1276: '---------------------------------');
1277: hr_utility.trace(' ');
1278:
1279: --
1273: hr_utility.trace(' p_object_version_number '||
1274: to_char(p_object_version_number));
1275: hr_utility.trace(' --------------------------------'||
1276: '---------------------------------');
1277: hr_utility.trace(' ');
1278:
1279: --
1280: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
1281:
1299: l_prjtimestart:=p_time_projected_start;
1300: l_prjtimeend :=p_time_projected_end;
1301:
1302:
1303: hr_utility.set_location(' l_date_start ' ||l_datestart,20);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1300: l_prjtimeend :=p_time_projected_end;
1301:
1302:
1303: hr_utility.set_location(' l_date_start ' ||l_datestart,20);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1301:
1302:
1303: hr_utility.set_location(' l_date_start ' ||l_datestart,20);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1302:
1303: hr_utility.set_location(' l_date_start ' ||l_datestart,20);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1303: hr_utility.set_location(' l_date_start ' ||l_datestart,20);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1304: hr_utility.set_location(' p_date_start ' ||p_date_start,22);
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1305: hr_utility.set_location(' l_dateend '|| l_dateend,22);
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1306: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,22);
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1307: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,22);
1308: hr_utility.set_location(' l_timestart ' || l_timestart,22);
1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2
1318: open c_get_absence_dates;
1319: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,
1320: l_prjdateend,l_timestart,l_timeend,l_prjtimestart,l_prjtimeend;
1321: close c_get_absence_dates;
1322: hr_utility.set_location(' l_date_start ' ||l_date_start,20);
1323: if p_date_start <> hr_api.g_date and l_datestart is not null then
1324: l_datestart :=p_date_start;
1325: end if;
1326:
1356:
1357:
1358: end if;
1359:
1360: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,250);
1361: hr_utility.set_location(' l_datestart ' ||l_datestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1357:
1358: end if;
1359:
1360: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,250);
1361: hr_utility.set_location(' l_datestart ' ||l_datestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1359:
1360: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,250);
1361: hr_utility.set_location(' l_datestart ' ||l_datestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1360: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,250);
1361: hr_utility.set_location(' l_datestart ' ||l_datestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1361: hr_utility.set_location(' l_datestart ' ||l_datestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1362:
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1370: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,30);
1363: hr_utility.set_location(' p_date_start ' ||p_date_start,30);
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1370: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,30);
1371:
1364: hr_utility.set_location(' l_dateend '|| l_dateend,30);
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1370: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,30);
1371:
1372: if l_hours_or_days ='H' then
1365: hr_utility.set_location(' l_prjdatestart ' || l_prjdatestart,30);
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1370: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,30);
1371:
1372: if l_hours_or_days ='H' then
1373: -- when the UOM attached to the element is Hours
1366: hr_utility.set_location(' l_prjdateend ' || l_prjdateend,30);
1367: hr_utility.set_location(' l_timestart ' || l_timestart,30);
1368: hr_utility.set_location(' l_timeend ' || l_timeend,30);
1369: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,30);
1370: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,30);
1371:
1372: if l_hours_or_days ='H' then
1373: -- when the UOM attached to the element is Hours
1374:
1374:
1375: if ( l_datestart is null ) then
1376:
1377: if ( l_prjdatestart is null ) then
1378: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
1379: hr_utility.raise_error;
1380: end if;
1381:
1382: --if p_time_projected_start is null or p_date_projected_end = hr_api.g_date or p_time_projected_end is null then
1375: if ( l_datestart is null ) then
1376:
1377: if ( l_prjdatestart is null ) then
1378: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
1379: hr_utility.raise_error;
1380: end if;
1381:
1382: --if p_time_projected_start is null or p_date_projected_end = hr_api.g_date or p_time_projected_end is null then
1383:
1382: --if p_time_projected_start is null or p_date_projected_end = hr_api.g_date or p_time_projected_end is null then
1383:
1384: if (l_prjtimestart is null) or (l_prjdateend is null ) or (l_prjtimeend is null ) then
1385:
1386: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
1387: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
1388: hr_utility.raise_error;
1389: end if;
1390:
1383:
1384: if (l_prjtimestart is null) or (l_prjdateend is null ) or (l_prjtimeend is null ) then
1385:
1386: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
1387: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
1388: hr_utility.raise_error;
1389: end if;
1390:
1391: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
1384: if (l_prjtimestart is null) or (l_prjdateend is null ) or (l_prjtimeend is null ) then
1385:
1386: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);
1387: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
1388: hr_utility.raise_error;
1389: end if;
1390:
1391: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
1392: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,40);
1387: hr_utility.set_message(800, 'HR_449866_START_END_DATES3');
1388: hr_utility.raise_error;
1389: end if;
1390:
1391: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
1392: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,40);
1393:
1394: else
1395:
1388: hr_utility.raise_error;
1389: end if;
1390:
1391: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,20);
1392: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,40);
1393:
1394: else
1395:
1396: if (l_dateend is null ) or ( l_timeend is null) or(l_timestart is null ) then
1393:
1394: else
1395:
1396: if (l_dateend is null ) or ( l_timeend is null) or(l_timestart is null ) then
1397: hr_utility.set_message (800,'HR_449867_START_END_DATES4');
1398: hr_utility.raise_error;
1399: end if;
1400:
1401: end if;
1394: else
1395:
1396: if (l_dateend is null ) or ( l_timeend is null) or(l_timestart is null ) then
1397: hr_utility.set_message (800,'HR_449867_START_END_DATES4');
1398: hr_utility.raise_error;
1399: end if;
1400:
1401: end if;
1402:
1403: else
1404:
1405: -- when the UOM is Days
1406:
1407: hr_utility.set_location(' l_hours_or_days ' ||l_hours_or_days,25);
1408:
1409:
1410: if l_datestart is null then
1411:
1410: if l_datestart is null then
1411:
1412:
1413: if l_prjdatestart is null then
1414: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
1415: hr_utility.raise_error;
1416:
1417: elsif l_prjdateend is null then
1418:
1411:
1412:
1413: if l_prjdatestart is null then
1414: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
1415: hr_utility.raise_error;
1416:
1417: elsif l_prjdateend is null then
1418:
1419: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1415: hr_utility.raise_error;
1416:
1417: elsif l_prjdateend is null then
1418:
1419: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1420: hr_utility.raise_error;
1421: end if;
1422:
1423: else
1416:
1417: elsif l_prjdateend is null then
1418:
1419: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1420: hr_utility.raise_error;
1421: end if;
1422:
1423: else
1424:
1424:
1425: /* if (p_date_projected_start is null or p_date_projected_start= hr_api.g_date)
1426: and ( p_date_projected_end is null or p_date_projected_end = hr_api.g_date) then
1427:
1428: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1429: hr_utility.raise_error;
1430: end if;
1431: */
1432:
1425: /* if (p_date_projected_start is null or p_date_projected_start= hr_api.g_date)
1426: and ( p_date_projected_end is null or p_date_projected_end = hr_api.g_date) then
1427:
1428: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1429: hr_utility.raise_error;
1430: end if;
1431: */
1432:
1433: if l_dateend is null then
1431: */
1432:
1433: if l_dateend is null then
1434:
1435: hr_utility.set_message (800,'HR_449865_START_END_DATES2');
1436: hr_utility.raise_error;
1437: end if;
1438:
1439: end if;
1432:
1433: if l_dateend is null then
1434:
1435: hr_utility.set_message (800,'HR_449865_START_END_DATES2');
1436: hr_utility.raise_error;
1437: end if;
1438:
1439: end if;
1440:
1444: l_chk_dateend := nvl(l_dateend,l_prjdateend);
1445:
1446: if p_called_from <> 809 and l_chk_datestart is not null and l_chk_dateend is not null
1447: then
1448: hr_utility.set_location('inside otl hr check ', 10);
1449:
1450: otl_hr_check
1451: (
1452: p_person_id => l_csrperson_id,
1455: p_scope => 'UPDATE',
1456: p_ret_value => l_retvalue );
1457:
1458:
1459: hr_utility.set_location('after otl hr check ', 10);
1460:
1461: end if;
1462:
1463: -- to allow the projected leaves to get confirmed
1462:
1463: -- to allow the projected leaves to get confirmed
1464: -- when elementry id is null
1465:
1466: hr_utility.set_location('l_retvalue'||l_retvalue, 10);
1467:
1468: if l_retvalue ='RESTRICT' THEN
1469:
1470:
1467:
1468: if l_retvalue ='RESTRICT' THEN
1469:
1470:
1471: hr_utility.set_location(' p_date_projected_start'||p_date_projected_start, 10);
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1468: if l_retvalue ='RESTRICT' THEN
1469:
1470:
1471: hr_utility.set_location(' p_date_projected_start'||p_date_projected_start, 10);
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1469:
1470:
1471: hr_utility.set_location(' p_date_projected_start'||p_date_projected_start, 10);
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1470:
1471: hr_utility.set_location(' p_date_projected_start'||p_date_projected_start, 10);
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1478: hr_utility.set_location('p_time_end'||p_time_end, 10);
1471: hr_utility.set_location(' p_date_projected_start'||p_date_projected_start, 10);
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1478: hr_utility.set_location('p_time_end'||p_time_end, 10);
1479:
1472: hr_utility.set_location('p_time_projected_start'||p_time_projected_start, 10);
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1478: hr_utility.set_location('p_time_end'||p_time_end, 10);
1479:
1480: open c_get_absence_dates;
1473: hr_utility.set_location('p_date_projected_end'||p_date_projected_end, 10);
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1478: hr_utility.set_location('p_time_end'||p_time_end, 10);
1479:
1480: open c_get_absence_dates;
1481: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,
1474: hr_utility.set_location('p_time_projected_end'||p_time_projected_end, 10);
1475: hr_utility.set_location('p_date_start'||p_date_start, 10);
1476: hr_utility.set_location('p_date_end'||p_date_end, 10);
1477: hr_utility.set_location('p_time_start'||p_time_start, 10);
1478: hr_utility.set_location('p_time_end'||p_time_end, 10);
1479:
1480: open c_get_absence_dates;
1481: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,
1482: l_prjdateend,l_timestart,l_timeend,l_prjtimestart,l_prjtimeend;
1532: end if;
1533:
1534:
1535:
1536: hr_utility.set_location(' l_datestart'|| l_datestart, 10);
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1533:
1534:
1535:
1536: hr_utility.set_location(' l_datestart'|| l_datestart, 10);
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1534:
1535:
1536: hr_utility.set_location(' l_datestart'|| l_datestart, 10);
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1535:
1536: hr_utility.set_location(' l_datestart'|| l_datestart, 10);
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1536: hr_utility.set_location(' l_datestart'|| l_datestart, 10);
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1537: hr_utility.set_location(' l_dateend'|| l_dateend , 10);
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1545:
1538: hr_utility.set_location(' l_prjdatestart'|| l_prjdatestart , 10);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1539: hr_utility.set_location(' l_prjdateend'|| l_prjdateend , 10);
1540: hr_utility.set_location(' l_timestart'|| l_timestart , 10);
1541: hr_utility.set_location(' l_timeend'|| l_timeend , 10);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1542: hr_utility.set_location(' l_prjtimestart'|| l_prjtimestart , 10);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1543: hr_utility.set_location(' l_prjtimeend'|| l_prjtimeend , 10);
1544:
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1544:
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1545:
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1546: hr_utility.set_location(' ls_prjdatestart'|| ls_prjdatestart,20);
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1554:
1547: hr_utility.set_location(' ls_prjdateend'|| ls_prjdateend , 20);
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1554:
1555: if l_datestart is null and p_date_start is not null then
1548: hr_utility.set_location(' ls_prjtimestart'|| ls_prjtimestart , 20);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1554:
1555: if l_datestart is null and p_date_start is not null then
1556: hr_utility.set_location('before comparing dates', 5);
1549: hr_utility.set_location(' ls_prjtimeend'|| ls_prjtimeend ,20);
1550: hr_utility.set_location(' ls_datestart'|| ls_datestart , 20);
1551: hr_utility.set_location(' ls_dateend'|| ls_dateend , 20);
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1554:
1555: if l_datestart is null and p_date_start is not null then
1556: hr_utility.set_location('before comparing dates', 5);
1557:
1552: hr_utility.set_location(' ls_timestart'|| ls_timestart , 20);
1553: hr_utility.set_location(' ls_timeend'|| ls_timeend ,20);
1554:
1555: if l_datestart is null and p_date_start is not null then
1556: hr_utility.set_location('before comparing dates', 5);
1557:
1558: IF nvl(ls_prjdatestart,l_glb_date) <> nvl(l_prjdatestart,l_glb_date)
1559: or nvl(ls_prjdateend,l_glb_date) <> nvl(l_prjdateend,l_glb_date)
1560: or nvl(ls_prjtimestart,l_glb_var)<> nvl(l_prjtimestart,l_glb_var)
1570:
1571:
1572: then
1573:
1574: hr_utility.set_location('While confirming dates should not be changed', 10);
1575:
1576: hr_utility.set_location('otl hr UPDATE check ', 60);
1577: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
1578: hr_utility.raise_error;
1572: then
1573:
1574: hr_utility.set_location('While confirming dates should not be changed', 10);
1575:
1576: hr_utility.set_location('otl hr UPDATE check ', 60);
1577: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
1578: hr_utility.raise_error;
1579: END IF;
1580: end if;
1573:
1574: hr_utility.set_location('While confirming dates should not be changed', 10);
1575:
1576: hr_utility.set_location('otl hr UPDATE check ', 60);
1577: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
1578: hr_utility.raise_error;
1579: END IF;
1580: end if;
1581: END IF;
1574: hr_utility.set_location('While confirming dates should not be changed', 10);
1575:
1576: hr_utility.set_location('otl hr UPDATE check ', 60);
1577: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
1578: hr_utility.raise_error;
1579: END IF;
1580: end if;
1581: END IF;
1582:
1598:
1599: l_absence_days := p_absence_days;
1600: l_absence_hours := p_absence_hours;
1601:
1602: hr_utility.trace('Old Dur Dys: '||to_char(l_absence_days));
1603: hr_utility.trace('Old Dur Hrs: '||to_char(l_absence_hours));
1604:
1605: --
1606: -- Call Before Process User Hook
1599: l_absence_days := p_absence_days;
1600: l_absence_hours := p_absence_hours;
1601:
1602: hr_utility.trace('Old Dur Dys: '||to_char(l_absence_days));
1603: hr_utility.trace('Old Dur Hrs: '||to_char(l_absence_hours));
1604:
1605: --
1606: -- Call Before Process User Hook
1607: --
1697: );
1698: end;
1699:
1700: --
1701: hr_utility.set_location(l_proc, 30);
1702: --
1703: l_object_version_number := p_object_version_number;
1704: --
1705: -- Update Person Absence
1809: p_del_element_entry_warning := l_del_element_entry_warning;
1810: p_absence_days := l_absence_days;
1811: p_absence_hours := l_absence_hours;
1812:
1813: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1814: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1815:
1816:
1817: hr_utility.set_location('Start of absence element entry section', 40);
1810: p_absence_days := l_absence_days;
1811: p_absence_hours := l_absence_hours;
1812:
1813: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1814: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1815:
1816:
1817: hr_utility.set_location('Start of absence element entry section', 40);
1818:
1813: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1814: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1815:
1816:
1817: hr_utility.set_location('Start of absence element entry section', 40);
1818:
1819: /* Start of Absence Element Entry Section */
1820: --
1821: -- Update or insert the absence element element. First we
1885: -- Scenario 1.
1886: -- An entry does not already exist. Insert if we have
1887: -- the appropriate dates.
1888: --
1889: hr_utility.set_location('Scenario 1', 45);
1890:
1891: if (l_processing_type = 'N'
1892: and l_date_start_for_absence is not null
1893: and l_date_end_for_absence is not null)
1908: -- absence end date, we date effectively delete the
1909: -- element immediately, otherwise it remains open until
1910: -- the end of time.
1911: --
1912: hr_utility.set_location('Scenario 2', 50);
1913:
1914: delete_absence_element
1915: (p_dt_delete_mode => 'DELETE'
1916: ,p_session_date => l_date_end_for_absence
1931: -- Scenario 3.
1932: -- The element entry should be purged because the
1933: -- actual dates have been removed.
1934: --
1935: hr_utility.set_location('Scenario 3', 55);
1936:
1937: --
1938: -- Warn the user before deleting.
1939: --
1950: -- Scenario 4.
1951: -- The start date cannot be moved outside the entry's
1952: -- current period for non-recurring entries.
1953: --
1954: hr_utility.set_location('Scenario 4', 60);
1955:
1956: fnd_message.set_name ('PAY', 'HR_6744_ABS_DET_ENTRY_PERIOD');
1957: /* Commented and added as a part of Bug#10239011 Starts
1958: fnd_message.set_token ('PERIOD_FROM',
1972: -- Update the existing entry with the new input values.
1973: -- For simplicity, we make the update even if the value
1974: -- has not changed.
1975: --
1976: hr_utility.set_location('Scenario 5', 65);
1977:
1978: update_absence_element
1979: (p_dt_update_mode => 'CORRECTION'
1980: ,p_session_date => l_effective_start_date
1988: -- Scenario 6.
1989: -- The start date has been moved. As this is part of the
1990: -- primary key we must delete the entry and re-insert it.
1991: --
1992: hr_utility.set_location('Scenario 6', 70);
1993:
1994: delete_absence_element
1995: (p_dt_delete_mode => 'ZAP'
1996: ,p_session_date => l_effective_start_date
2025: -- . been removed
2026: -- . entered for the first time
2027: -- . still not been entered.
2028: --
2029: hr_utility.set_location('Scenario 7', 75);
2030:
2031: if l_effective_end_date <> hr_api.g_eot then
2032: --
2033: -- End date has been changed or removed so we
2033: -- End date has been changed or removed so we
2034: -- remove the end date so it continues through
2035: -- until the end of time.
2036: --
2037: hr_utility.set_location(l_proc, 76);
2038:
2039: delete_absence_element
2040: (p_dt_delete_mode => 'DELETE_NEXT_CHANGE'
2041: ,p_session_date => l_effective_end_date
2047: -- End date has been changed or entered for
2048: -- the first time. We end the element entry
2049: -- at the end date.
2050: --
2051: hr_utility.set_location(l_proc, 78);
2052:
2053: delete_absence_element
2054: (p_dt_delete_mode => 'DELETE'
2055: ,p_session_date => l_date_end_for_absence
2067:
2068:
2069: /* End of Absence Element Entry Section */
2070:
2071: hr_utility.set_location('End of absence element entry section', 80);
2072:
2073: populate_ben_absence_rec
2074: (p_absence_attendance_id => p_absence_attendance_id,
2075: p_rec_type => 'O',
2082:
2083: --
2084: -- Start of BEN call.
2085: --
2086: hr_utility.set_location('Start of BEN call', 82);
2087:
2088: ben_abs_ler.ler_chk
2089: (p_old => l_old
2090: ,p_new => l_new
2089: (p_old => l_old
2090: ,p_new => l_new
2091: ,p_effective_date => l_effective_date);
2092:
2093: hr_utility.set_location('End of BEN call', 84);
2094:
2095: --
2096: -- Call After Process User Hook
2097: --
2197:
2198: --
2199: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
2200: --
2201: hr_utility.trace(' ');
2202: hr_utility.trace(' --------------------------------'||
2203: '---------------------------------');
2204: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
2205: ' VALUE');
2198: --
2199: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
2200: --
2201: hr_utility.trace(' ');
2202: hr_utility.trace(' --------------------------------'||
2203: '---------------------------------');
2204: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
2205: ' VALUE');
2206: hr_utility.trace(' --------------------------------'||
2200: --
2201: hr_utility.trace(' ');
2202: hr_utility.trace(' --------------------------------'||
2203: '---------------------------------');
2204: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
2205: ' VALUE');
2206: hr_utility.trace(' --------------------------------'||
2207: '+--------------------------------');
2208: hr_utility.trace(' p_absence_days '||
2202: hr_utility.trace(' --------------------------------'||
2203: '---------------------------------');
2204: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
2205: ' VALUE');
2206: hr_utility.trace(' --------------------------------'||
2207: '+--------------------------------');
2208: hr_utility.trace(' p_absence_days '||
2209: to_char(p_absence_days));
2210: hr_utility.trace(' p_absence_hours '||
2204: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
2205: ' VALUE');
2206: hr_utility.trace(' --------------------------------'||
2207: '+--------------------------------');
2208: hr_utility.trace(' p_absence_days '||
2209: to_char(p_absence_days));
2210: hr_utility.trace(' p_absence_hours '||
2211: to_char(p_absence_hours));
2212: hr_utility.trace(' p_object_version_number '||
2206: hr_utility.trace(' --------------------------------'||
2207: '+--------------------------------');
2208: hr_utility.trace(' p_absence_days '||
2209: to_char(p_absence_days));
2210: hr_utility.trace(' p_absence_hours '||
2211: to_char(p_absence_hours));
2212: hr_utility.trace(' p_object_version_number '||
2213: to_char(p_object_version_number));
2214: hr_utility.trace(' --------------------------------'||
2208: hr_utility.trace(' p_absence_days '||
2209: to_char(p_absence_days));
2210: hr_utility.trace(' p_absence_hours '||
2211: to_char(p_absence_hours));
2212: hr_utility.trace(' p_object_version_number '||
2213: to_char(p_object_version_number));
2214: hr_utility.trace(' --------------------------------'||
2215: '---------------------------------');
2216: hr_utility.trace(' ');
2210: hr_utility.trace(' p_absence_hours '||
2211: to_char(p_absence_hours));
2212: hr_utility.trace(' p_object_version_number '||
2213: to_char(p_object_version_number));
2214: hr_utility.trace(' --------------------------------'||
2215: '---------------------------------');
2216: hr_utility.trace(' ');
2217:
2218: --
2212: hr_utility.trace(' p_object_version_number '||
2213: to_char(p_object_version_number));
2214: hr_utility.trace(' --------------------------------'||
2215: '---------------------------------');
2216: hr_utility.trace(' ');
2217:
2218: --
2219: -- When in validation only mode raise the Validate_Enabled exception
2220: --
2221: if p_validate then
2222: raise hr_api.validate_enabled;
2223: end if;
2224: --
2225: hr_utility.set_location(' Leaving:'||l_proc, 90);
2226: exception
2227: when hr_api.validate_enabled then
2228: --
2229: -- As the Validate_Enabled exception has been raised
2235: -- (Any key or derived arguments must be set to null
2236: -- when validation only mode is being used.)
2237: --
2238: p_object_version_number := null;
2239: hr_utility.set_location(' Leaving:'||l_proc, 100);
2240: when others then
2241: --
2242: -- A validation or unexpected error has occured
2243: --
2254: p_dur_overwritten_warning := null;
2255: p_del_element_entry_warning := null;
2256:
2257: rollback to update_person_absence;
2258: hr_utility.set_location(' Leaving:'||l_proc, 110);
2259: raise;
2260: end update_person_absence;
2261: --
2262: --
2318: l_retvalue varchar2(10);
2319: --
2320:
2321: begin
2322: hr_utility.set_location('Entering:'|| l_proc, 10);
2323:
2324: -- Issue a savepoint
2325: savepoint delete_person_absence;
2326:
2328: FETCH get_person_info INTO l_person_id;
2329: CLOSE get_person_info;
2330:
2331: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
2332: hr_utility.set_location(' OTL ABS integration on ',10);
2333:
2334: open csr_get_absdates;
2335: fetch csr_get_absdates into l_chk_datestart,l_chk_dateend ;
2336: close csr_get_absdates;
2338: if p_called_from <> 809 and l_chk_datestart is not null and l_chk_dateend is not null
2339:
2340: then
2341:
2342: hr_utility.set_location('inside otl hr check ', 10);
2343:
2344: otl_hr_check
2345: (
2346: p_person_id => l_person_id,
2349: p_scope => 'DELETE',
2350: p_ret_value => l_retvalue );
2351:
2352:
2353: hr_utility.set_location('after otl hr check ', 10);
2354:
2355: end if;
2356: END IF;
2357:
2376: open c_occurrence;
2377: fetch c_occurrence into l_business_group_id,l_absence_attendance_type_id,l_person_id,l_occurrence;
2378: close c_occurrence;
2379: --
2380: hr_utility.set_location('Start of absence element deletion section', 30);
2381: --
2382: /* Start of Absence Element Deletion Section */
2383:
2384: --
2406: end if;
2407: End loop;
2408: /* End of Absence Element Deletion Section */
2409:
2410: hr_utility.set_location('End of absence element deletion section', 40);
2411: --
2412: -- Delete Person Absence
2413:
2414: per_abs_del.del
2415: (p_absence_attendance_id => p_absence_attendance_id
2416: ,p_object_version_number => p_object_version_number
2417: );
2418:
2419: hr_utility.set_location(l_proc, 50);
2420:
2421: populate_ben_absence_rec
2422: (p_absence_attendance_id => p_absence_attendance_id,
2423: p_rec_type => 'O',
2428: p_effective_date => l_effective_start_date);
2429:
2430:
2431: /*Fix for Bug # 13922178. Adjust the occurrence after the delete*/
2432: hr_utility.set_location(l_proc, 52);
2433: update per_absence_attendances set occurrence = occurrence - 1
2434: where business_group_id = l_business_group_id
2435: and absence_attendance_type_id = l_absence_attendance_type_id
2436: and person_id = l_person_id
2434: where business_group_id = l_business_group_id
2435: and absence_attendance_type_id = l_absence_attendance_type_id
2436: and person_id = l_person_id
2437: and occurrence > l_occurrence;
2438: hr_utility.set_location(l_proc, 53);
2439:
2440: --
2441: -- Call After Process User Hook
2442: --
2457: --
2458: -- to delete all the pending for approval transactions data requested for OTL-HRAbsence.
2459: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
2460:
2461: hr_utility.set_location('OTL HR ABS integration is ON ', 10);
2462: hr_absutil_ss.remove_absence_transaction(p_absence_attendance_id);
2463:
2464: end if;
2465:
2469: raise hr_api.validate_enabled;
2470: end if;
2471:
2472: --
2473: hr_utility.set_location(' Leaving:'||l_proc, 70);
2474: exception
2475: when hr_api.validate_enabled then
2476: --
2477: -- As the Validate_Enabled exception has been raised
2482: -- Only set output warning arguments
2483: -- (Any key or derived arguments must be set to null
2484: -- when validation only mode is being used.)
2485: --
2486: hr_utility.set_location(' Leaving:'||l_proc, 80);
2487: when others then
2488: --
2489: -- A validation or unexpected error has occured
2490: --
2488: --
2489: -- A validation or unexpected error has occured
2490: --
2491: rollback to delete_person_absence;
2492: hr_utility.set_location(' Leaving:'||l_proc, 90);
2493: raise;
2494: --
2495: end delete_person_absence;
2496:
2523:
2524:
2525: begin
2526:
2527: hr_utility.set_location('Entering:'|| l_proc, 10);
2528:
2529: open c_get_primary_assignment;
2530: fetch c_get_primary_assignment into l_assignment_id;
2531: close c_get_primary_assignment;
2530: fetch c_get_primary_assignment into l_assignment_id;
2531: close c_get_primary_assignment;
2532:
2533:
2534: hr_utility.set_location('Leaving:'|| l_proc, 20);
2535:
2536: return l_assignment_id;
2537:
2538: end get_primary_assignment;
2559:
2560:
2561: begin
2562:
2563: hr_utility.set_location('Entering:'|| l_proc, 10);
2564:
2565: open c_linked_to_element;
2566: fetch c_linked_to_element into l_input_value_id;
2567: close c_linked_to_element;
2573: l_linked_to_element := FALSE;
2574: end if;
2575:
2576:
2577: hr_utility.set_location('Leaving:'|| l_proc, 20);
2578:
2579: return l_linked_to_element;
2580:
2581: end linked_to_element;
2620: l_proc varchar2(72) := g_package||'get_absence_element';
2621:
2622: begin
2623:
2624: hr_utility.set_location('Entering:'|| l_proc, 10);
2625:
2626: open c_get_absence_element;
2627: fetch c_get_absence_element into p_element_entry_id,
2628: p_effective_start_date,
2629: p_effective_end_date;
2630: close c_get_absence_element;
2631:
2632:
2633: hr_utility.set_location('Leaving:'|| l_proc, 20);
2634: exception
2635: when others then
2636: p_element_entry_id := null;
2637: p_effective_start_date := null;
2661:
2662:
2663: begin
2664:
2665: hr_utility.set_location('Entering:'|| l_proc, 10);
2666:
2667: --
2668: -- Fetch the processing type. If no records are found, the absence type
2669: -- does not have an associated element so null is returned.
2671: open c_get_processing_type;
2672: fetch c_get_processing_type into l_processing_type;
2673: close c_get_processing_type;
2674:
2675: hr_utility.set_location('Leaving:'|| l_proc, 20);
2676:
2677: return l_processing_type;
2678:
2679: end get_processing_type;
2718:
2719:
2720: begin
2721:
2722: hr_utility.set_location('Entering:'|| l_proc, 10);
2723:
2724:
2725: -- This should always return a row because this procedure is only
2726: -- called when the absence type has an associated element type.
2735: l_processing_type;
2736: close c_get_element_details;
2737:
2738:
2739: hr_utility.set_location('Setting entry value', 20);
2740:
2741: if upper(l_processing_type) = 'N' then
2742: --
2743: -- p_entry_value is only set when the element type is
2748: if l_inc_or_dec_flag = 'D' then
2749: --
2750: -- Invert the absence duration for decreasing balances.
2751: --
2752: hr_utility.set_location(l_proc, 30);
2753: p_entry_value := l_absence_hours * -1;
2754:
2755: else
2756:
2753: p_entry_value := l_absence_hours * -1;
2754:
2755: else
2756:
2757: hr_utility.set_location(l_proc, 40);
2758: p_entry_value := l_absence_hours;
2759:
2760: end if;
2761:
2764: if l_inc_or_dec_flag = 'D' then
2765: --
2766: -- Invert the absence duration for decreasing balances.
2767: --
2768: hr_utility.set_location(l_proc, 50);
2769: p_entry_value := l_absence_days * -1;
2770:
2771: else
2772:
2769: p_entry_value := l_absence_days * -1;
2770:
2771: else
2772:
2773: hr_utility.set_location(l_proc, 60);
2774: p_entry_value := l_absence_days;
2775:
2776: end if;
2777:
2778: end if;
2779:
2780: end if;
2781:
2782: hr_utility.set_location('Leaving:'|| l_proc, 70);
2783:
2784: exception
2785: when others then
2786: p_element_type_id := null ;
2814:
2815: begin
2816:
2817:
2818: hr_utility.set_location('Entering:'|| l_proc, 10);
2819:
2820: get_element_details
2821: (p_absence_attendance_id => p_absence_attendance_id
2822: ,p_element_type_id => l_element_type_id
2823: ,p_input_value_id => l_input_value_id
2824: ,p_entry_value => l_entry_value);
2825:
2826:
2827: hr_utility.set_location('Checking element link', 20);
2828:
2829: l_element_link_id := hr_entry_api.get_link
2830: (p_assignment_id => p_assignment_id
2831: ,p_element_type_id => l_element_type_id
2834: If l_element_link_id is null then
2835: -- Assignment is not eligible for the element type
2836: -- associated with this absence.
2837: fnd_message.set_name ('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');
2838: hr_utility.raise_error;
2839: end if;
2840:
2841:
2842: hr_utility.set_location('Inserting element', 30);
2838: hr_utility.raise_error;
2839: end if;
2840:
2841:
2842: hr_utility.set_location('Inserting element', 30);
2843:
2844: -- We know the assignment is eligible for this element because
2845: -- we have the element_link_id. The entries API will handle
2846: -- all other validation (e.g., non-recurring entries must
2858: ,p_input_value_id1 => l_input_value_id
2859: ,p_entry_value1 => l_entry_value);
2860:
2861:
2862: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
2863: hr_utility.set_location('Leaving:'|| l_proc, 50);
2864:
2865: exception
2866: when others then
2859: ,p_entry_value1 => l_entry_value);
2860:
2861:
2862: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
2863: hr_utility.set_location('Leaving:'|| l_proc, 50);
2864:
2865: exception
2866: when others then
2867: p_element_entry_id := null ;
2888:
2889: begin
2890:
2891:
2892: hr_utility.set_location('Entering:'|| l_proc, 10);
2893:
2894: get_element_details
2895: (p_absence_attendance_id => p_absence_attendance_id
2896: ,p_element_type_id => l_element_type_id
2897: ,p_input_value_id => l_input_value_id
2898: ,p_entry_value => l_entry_value);
2899:
2900:
2901: hr_utility.set_location('Updating element', 20);
2902:
2903: -- We know the assignment is eligible for this element because
2904: -- we have the element_link_id. The entries API will handle
2905: -- all other validation (e.g., non-recurring entries must
2914: ,p_input_value_id1 => l_input_value_id
2915: ,p_entry_value1 => l_entry_value);
2916:
2917:
2918: hr_utility.set_location('Leaving:'|| l_proc, 30);
2919:
2920: end update_absence_element;
2921: --
2922: -- ----------------------------------------------------------------------------
2936:
2937: begin
2938:
2939:
2940: hr_utility.set_location('Entering:'|| l_proc, 10);
2941:
2942: hr_entry_api.delete_element_entry
2943: (p_dt_delete_mode => p_dt_delete_mode
2944: ,p_session_date => p_session_date
2944: ,p_session_date => p_session_date
2945: ,p_element_entry_id => p_element_entry_id);
2946:
2947:
2948: hr_utility.set_location('Leaving:'|| l_proc, 20);
2949:
2950: end delete_absence_element;
2951: --
2952: --
2965: is
2966: l_error_level NUMBER;
2967: l_error_code VARCHAR2(50);
2968: l_profile varchar2(1);
2969: g_debug boolean := hr_utility.debug_enabled;
2970:
2971: begin
2972: p_ret_value :='NO';
2973: l_profile :='N';
2972: p_ret_value :='NO';
2973: l_profile :='N';
2974:
2975:
2976: hr_utility.set_location('p_person_id : '|| p_person_id, 20);
2977: hr_utility.set_location('p_date_start :'|| p_date_start, 20);
2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2973: l_profile :='N';
2974:
2975:
2976: hr_utility.set_location('p_person_id : '|| p_person_id, 20);
2977: hr_utility.set_location('p_date_start :'|| p_date_start, 20);
2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND
2974:
2975:
2976: hr_utility.set_location('p_person_id : '|| p_person_id, 20);
2977: hr_utility.set_location('p_date_start :'|| p_date_start, 20);
2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND
2982: NVL(FND_PROFILE.Value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'N')='Y')
2975:
2976: hr_utility.set_location('p_person_id : '|| p_person_id, 20);
2977: hr_utility.set_location('p_date_start :'|| p_date_start, 20);
2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND
2982: NVL(FND_PROFILE.Value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'N')='Y')
2983:
2985:
2986: l_profile :='Y';
2987:
2988: if g_debug then
2989: hr_utility.set_location('CAC installed', 10);
2990: end if;
2991:
2992: end if;
2993:
2993:
2994:
2995:
2996: if p_person_id is not null and p_date_start is not null and p_date_end is not null then
2997: hr_utility.set_location('passed parameter are not null :', 10);
2998:
2999: --if l_profile = 'Y' and nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3000: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3001:
2999: --if l_profile = 'Y' and nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3000: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3001:
3002: if g_debug then
3003: hr_utility.set_location('OTL HR ABS integration is ON ', 10);
3004: end if;
3005: -- bug 8916489
3006: if not per_abs_bus.per_valid_for_absence
3007: (p_person_id => p_person_id
3023: p_error_code => l_error_code,
3024: p_error_level => l_error_level);
3025:
3026: if g_debug then
3027: hr_utility.set_location('out of OTL call ', 10);
3028: hr_utility.set_location(' l_error_level ' ||l_error_level, 10);
3029: end if;
3030:
3031: if p_scope IN ('CREATE','DELETE') THEN
3024: p_error_level => l_error_level);
3025:
3026: if g_debug then
3027: hr_utility.set_location('out of OTL call ', 10);
3028: hr_utility.set_location(' l_error_level ' ||l_error_level, 10);
3029: end if;
3030:
3031: if p_scope IN ('CREATE','DELETE') THEN
3032: IF l_error_level = 0 THEN
3032: IF l_error_level = 0 THEN
3033: p_ret_value :='ALL';
3034:
3035: if g_debug then
3036: hr_utility.set_location('otl hr Insert check - CREATE', 10);
3037: end if;
3038:
3039: elsif l_error_level in (1,2) then
3040: -- raise
3037: end if;
3038:
3039: elsif l_error_level in (1,2) then
3040: -- raise
3041: hr_utility.set_location('OTL Check failed. Raise Error', 20);
3042: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3043: hr_utility.raise_error;
3044:
3045: else
3038:
3039: elsif l_error_level in (1,2) then
3040: -- raise
3041: hr_utility.set_location('OTL Check failed. Raise Error', 20);
3042: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3043: hr_utility.raise_error;
3044:
3045: else
3046: -- raise
3039: elsif l_error_level in (1,2) then
3040: -- raise
3041: hr_utility.set_location('OTL Check failed. Raise Error', 20);
3042: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3043: hr_utility.raise_error;
3044:
3045: else
3046: -- raise
3047: hr_utility.set_location('Unknown Exception raised from OTL. Raise Error', 30);
3043: hr_utility.raise_error;
3044:
3045: else
3046: -- raise
3047: hr_utility.set_location('Unknown Exception raised from OTL. Raise Error', 30);
3048: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3049: hr_utility.raise_error;
3050: end if;
3051:
3044:
3045: else
3046: -- raise
3047: hr_utility.set_location('Unknown Exception raised from OTL. Raise Error', 30);
3048: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3049: hr_utility.raise_error;
3050: end if;
3051:
3052: end if;
3045: else
3046: -- raise
3047: hr_utility.set_location('Unknown Exception raised from OTL. Raise Error', 30);
3048: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3049: hr_utility.raise_error;
3050: end if;
3051:
3052: end if;
3053:
3053:
3054: if p_scope ='UPDATE' THEN
3055:
3056: if g_debug then
3057: hr_utility.set_location('otl hr Insert check - UPDATE', 10);
3058: end if;
3059:
3060: IF l_error_level =0 THEN
3061: p_ret_value :='ALL';
3058: end if;
3059:
3060: IF l_error_level =0 THEN
3061: p_ret_value :='ALL';
3062: hr_utility.set_location('otl hr UPDATE check', 40);
3063: elsif l_error_level =1 then
3064: p_ret_value:='RESTRICT';
3065: hr_utility.set_location('otl hr UPDATE check', 50);
3066: elsif l_error_level =2 then
3061: p_ret_value :='ALL';
3062: hr_utility.set_location('otl hr UPDATE check', 40);
3063: elsif l_error_level =1 then
3064: p_ret_value:='RESTRICT';
3065: hr_utility.set_location('otl hr UPDATE check', 50);
3066: elsif l_error_level =2 then
3067: -- raise
3068: hr_utility.set_location('otl hr UPDATE check ', 60);
3069: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3064: p_ret_value:='RESTRICT';
3065: hr_utility.set_location('otl hr UPDATE check', 50);
3066: elsif l_error_level =2 then
3067: -- raise
3068: hr_utility.set_location('otl hr UPDATE check ', 60);
3069: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3070: hr_utility.raise_error;
3071: else
3072: --raise;
3065: hr_utility.set_location('otl hr UPDATE check', 50);
3066: elsif l_error_level =2 then
3067: -- raise
3068: hr_utility.set_location('otl hr UPDATE check ', 60);
3069: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3070: hr_utility.raise_error;
3071: else
3072: --raise;
3073: hr_utility.set_location('otl hr UPDATE check', 70);
3066: elsif l_error_level =2 then
3067: -- raise
3068: hr_utility.set_location('otl hr UPDATE check ', 60);
3069: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3070: hr_utility.raise_error;
3071: else
3072: --raise;
3073: hr_utility.set_location('otl hr UPDATE check', 70);
3074: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3069: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3070: hr_utility.raise_error;
3071: else
3072: --raise;
3073: hr_utility.set_location('otl hr UPDATE check', 70);
3074: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3075: hr_utility.raise_error;
3076:
3077: end if;
3070: hr_utility.raise_error;
3071: else
3072: --raise;
3073: hr_utility.set_location('otl hr UPDATE check', 70);
3074: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3075: hr_utility.raise_error;
3076:
3077: end if;
3078: end if;
3071: else
3072: --raise;
3073: hr_utility.set_location('otl hr UPDATE check', 70);
3074: hr_utility.set_message(800,'HR_50433_OTL_CARD_EXISTS');
3075: hr_utility.raise_error;
3076:
3077: end if;
3078: end if;
3079:
3080: /* Code added for Query and then Disable of some fields in PUI screen */
3081: IF p_scope = 'QUERY' THEN
3082: IF l_error_level = 0 THEN
3083: p_ret_value :='ALL';
3084: hr_utility.set_location('Query for the period done. No disable', 40);
3085: elsif l_error_level =1 then
3086: p_ret_value:='RESTRICT';
3087: hr_utility.set_location('Query for the period done. Disable the fields', 50);
3088: end if;
3083: p_ret_value :='ALL';
3084: hr_utility.set_location('Query for the period done. No disable', 40);
3085: elsif l_error_level =1 then
3086: p_ret_value:='RESTRICT';
3087: hr_utility.set_location('Query for the period done. Disable the fields', 50);
3088: end if;
3089: END IF ;
3090:
3091: else
3092: p_ret_value :='ALL';
3093: end if;
3094:
3095: else
3096: hr_utility.set_location('CAC check call ', 100);
3097: p_ret_value :='YES'; -- Profile for cac is set
3098: end if;
3099:
3100:
3277: l_rec_start_date date;
3278: l_rec_end_date date;
3279: l_duration number(9,4);
3280:
3281: g_debug boolean := hr_utility.debug_enabled;
3282:
3283:
3284: begin
3285:
3283:
3284: begin
3285:
3286: if g_debug then
3287: hr_utility.set_location('Entering .get_absence_data ',10);
3288: end if;
3289:
3290: l_assignment_id := hr_person_absence_api.get_primary_assignment
3291: (p_person_id => p_person_id
3294: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');
3295:
3296: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' THEN
3297: if g_debug then
3298: hr_utility.set_location(' Profile HR OTL Integ in ON ',10);
3299: end if;
3300:
3301: --- BLOCK 1 will provide the data from SSHR Transaction tables
3302: -- which are in Create Mode and in Pending for approval status
3330: IF l_sch_based_dur = 'Y' THEN
3331:
3332: open csr_sshr_abs_records('CreateMode');
3333: if g_debug then
3334: hr_utility.set_location('Block 1 -Create Mode',110);
3335: end if;
3336: loop
3337: -- fetch csr_sshr_abs_records bulk collect into l_start_date,l_end_date,l_transactionid,l_transactiondocument,l_abs_type,l_ele_type,l_hours_or_days;
3338:
3339: fetch csr_sshr_abs_records into l_start_date,l_end_date,l_time_start ,l_time_end,l_transactionid,l_transactiondocument,
3340: l_ss_ovn,l_abs_type,l_absence_attendance_id,l_ele_type,l_hours_or_days,l_confirmed_flag;
3341:
3342: if g_debug then
3343: hr_utility.set_location('Entering .get_absence_data ',120);
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3340: l_ss_ovn,l_abs_type,l_absence_attendance_id,l_ele_type,l_hours_or_days,l_confirmed_flag;
3341:
3342: if g_debug then
3343: hr_utility.set_location('Entering .get_absence_data ',120);
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3341:
3342: if g_debug then
3343: hr_utility.set_location('Entering .get_absence_data ',120);
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3349: hr_utility.set_location(' l_abs_type '||l_abs_type,120);
3342: if g_debug then
3343: hr_utility.set_location('Entering .get_absence_data ',120);
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3349: hr_utility.set_location(' l_abs_type '||l_abs_type,120);
3350: end if;
3343: hr_utility.set_location('Entering .get_absence_data ',120);
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3349: hr_utility.set_location(' l_abs_type '||l_abs_type,120);
3350: end if;
3351:
3344: hr_utility.set_location(' l_start_date '||l_start_date,120);
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3349: hr_utility.set_location(' l_abs_type '||l_abs_type,120);
3350: end if;
3351:
3352:
3345: hr_utility.set_location(' l_end_date '|| l_end_date,120);
3346: hr_utility.set_location(' l_transactionid '||l_transactionid,120);
3347: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,120);
3348: hr_utility.set_location(' l_ele_type '||l_ele_type,120);
3349: hr_utility.set_location(' l_abs_type '||l_abs_type,120);
3350: end if;
3351:
3352:
3353: exit when csr_sshr_abs_records%notfound;
3391:
3392: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3393: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3394: if g_debug then
3395: hr_utility.set_location('v_start_date: '||v_start_date,130);
3396: hr_utility.set_location('v_end_date: '||v_end_date,130);
3397: end if;
3398:
3399: IF l_hours_or_days = 'D' THEN
3392: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3393: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3394: if g_debug then
3395: hr_utility.set_location('v_start_date: '||v_start_date,130);
3396: hr_utility.set_location('v_end_date: '||v_end_date,130);
3397: end if;
3398:
3399: IF l_hours_or_days = 'D' THEN
3400: v_end_date := l_end_date + 1;
3400: v_end_date := l_end_date + 1;
3401: END IF;
3402:
3403: if g_debug then
3404: hr_utility.set_location('before cac .get_absence_data ',140);
3405: end if;
3406:
3407: hr_wrk_sch_pkg.get_per_asg_schedule
3408: ( p_person_assignment_id => l_assignment_id
3417: , x_return_message => l_return_message
3418: );
3419:
3420: if g_debug then
3421: hr_utility.set_location('after cac .get_absence_data ',150);
3422: end if;
3423:
3424: IF l_return_status = '0' THEN
3425:
3423:
3424: IF l_return_status = '0' THEN
3425:
3426: if g_debug then
3427: hr_utility.set_location('Entering sch found ',151);
3428: end if;
3429:
3430: l_idx := l_schedule.first;
3431: IF l_hours_or_days = 'D' THEN
3430: l_idx := l_schedule.first;
3431: IF l_hours_or_days = 'D' THEN
3432:
3433: if g_debug then
3434: hr_utility.set_location('get_absence_data SS',152);
3435: end if;
3436:
3437: l_first_band := TRUE;
3438: l_ref_date := NULL;
3440: WHILE l_idx IS NOT NULL
3441: LOOP
3442:
3443: if g_debug then
3444: hr_utility.set_location('get_absence_data SS',153);
3445: end if;
3446:
3447: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3448: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3474:
3475: -- for hours
3476: else
3477: if g_debug then
3478: hr_utility.set_location(' indexloop FOR Hours get_absence_data ',160);
3479: end if;
3480:
3481:
3482: l_day_start_time := '00:00';
3520:
3521: close csr_sshr_abs_records;
3522:
3523: if g_debug then
3524: hr_utility.set_location('Block 1 -Create Mode',170);
3525: end if;
3526:
3527: else
3528: -- when cac is not in use then we will provide absences on day basis as we do not know the schedule of the person
3527: else
3528: -- when cac is not in use then we will provide absences on day basis as we do not know the schedule of the person
3529:
3530: if g_debug then
3531: hr_utility.set_location('Block 1 -CAC is not used',180);
3532: end if;
3533:
3534: open csr_sshr_abs_records('CreateMode');
3535: if g_debug then
3532: end if;
3533:
3534: open csr_sshr_abs_records('CreateMode');
3535: if g_debug then
3536: hr_utility.set_location('Entering .get_absence_data',190);
3537: end if;
3538: loop
3539:
3540:
3541: fetch csr_sshr_abs_records into l_start_date,l_end_date,l_time_start ,l_time_end,l_transactionid,l_transactiondocument,
3542: l_ss_ovn,l_abs_type,l_absence_attendance_id,l_ele_type,l_hours_or_days,l_confirmed_flag;
3543:
3544: if g_debug then
3545: hr_utility.set_location('Entering .get_absence_data ',190);
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3542: l_ss_ovn,l_abs_type,l_absence_attendance_id,l_ele_type,l_hours_or_days,l_confirmed_flag;
3543:
3544: if g_debug then
3545: hr_utility.set_location('Entering .get_absence_data ',190);
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3543:
3544: if g_debug then
3545: hr_utility.set_location('Entering .get_absence_data ',190);
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3551: hr_utility.set_location(' l_abs_type '||l_abs_type,190);
3544: if g_debug then
3545: hr_utility.set_location('Entering .get_absence_data ',190);
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3551: hr_utility.set_location(' l_abs_type '||l_abs_type,190);
3552: end if;
3545: hr_utility.set_location('Entering .get_absence_data ',190);
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3551: hr_utility.set_location(' l_abs_type '||l_abs_type,190);
3552: end if;
3553:
3546: hr_utility.set_location(' l_start_date '||l_start_date,190);
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3551: hr_utility.set_location(' l_abs_type '||l_abs_type,190);
3552: end if;
3553:
3554: exit when csr_sshr_abs_records%notfound;
3547: hr_utility.set_location(' l_end_date '|| l_end_date,190);
3548: hr_utility.set_location(' l_transactionid '||l_transactionid,190);
3549: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,190);
3550: hr_utility.set_location(' l_ele_type '||l_ele_type,190);
3551: hr_utility.set_location(' l_abs_type '||l_abs_type,190);
3552: end if;
3553:
3554: exit when csr_sshr_abs_records%notfound;
3555:
3555:
3556: l_rec_start_date :=l_start_date;
3557: l_rec_end_date :=l_end_date;
3558: if g_debug then
3559: hr_utility.set_location('Entering .get_absence_data ',200);
3560: end if;
3561:
3562: IF l_time_start IS NULL THEN
3563: l_time_start := '00:00';
3680: close csr_sshr_abs_records;
3681: end if; -- CAC Check
3682:
3683: if g_debug then
3684: hr_utility.set_location('End of Create Mode Blk1 ',200);
3685: end if;
3686:
3687: -----END OF BLOCK 1-----
3688:
3705:
3706: open csr_sshr_abs_records(p_ssmode);
3707:
3708: if g_debug then
3709: hr_utility.set_location('Start of BLock 2',210);
3710: hr_utility.set_location('Entering .get_absence_data',210);
3711:
3712: end if;
3713: loop
3706: open csr_sshr_abs_records(p_ssmode);
3707:
3708: if g_debug then
3709: hr_utility.set_location('Start of BLock 2',210);
3710: hr_utility.set_location('Entering .get_absence_data',210);
3711:
3712: end if;
3713: loop
3714: fetch csr_sshr_abs_records into l_start_date,l_end_date,l_time_start ,l_time_end,l_transactionid,l_transactiondocument,
3714: fetch csr_sshr_abs_records into l_start_date,l_end_date,l_time_start ,l_time_end,l_transactionid,l_transactiondocument,
3715: l_ss_ovn,l_abs_type,l_absence_attendance_id,l_ele_type,l_hours_or_days,l_confirmed_flag;
3716:
3717: exit when csr_sshr_abs_records%notfound;
3718: hr_utility.set_location('Before sql stmt',220);
3719:
3720: BEGIN
3721: l_core_ovn :=null;
3722: select nvl(date_start,DATE_PROJECTED_START) datestart,
3728: INTO l_core_dstart ,l_core_dend, l_core_tstart, l_core_tend, l_core_abs_attendance_id , l_core_ovn
3729: from per_absence_attendances
3730: where ABSENCE_ATTENDANCE_ID = l_absence_attendance_id;
3731: if g_debug then
3732: hr_utility.set_location('after sql stmt',220);
3733: end if;
3734:
3735: exception
3736: when no_data_found then
3735: exception
3736: when no_data_found then
3737:
3738: if g_debug then
3739: hr_utility.set_location('in the exception',220);
3740: end if;
3741:
3742: j:=j+1;
3743: absence_records_inv(j).transactionid := l_transactionid;
3749:
3750: if l_core_ovn > l_ss_ovn then
3751: -- ss data is invalid hence insert core data in to pl sql table
3752: if g_debug then
3753: hr_utility.set_location('Core Data modified when SS is pending',220);
3754: end if;
3755:
3756: j:=j+1;
3757: absence_records_inv(j).transactionid := l_transactionid;
3768: --
3769:
3770: IF l_sch_based_dur = 'Y' THEN
3771:
3772: hr_utility.set_location('CAC profile set to Yes Block2',230);
3773: IF l_time_start IS NULL THEN
3774: l_time_start := '00:00';
3775: ELSE
3776: null;
3793: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
3794: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3795:
3796: if g_debug then
3797: hr_utility.set_location('v_start_date: '||v_start_date,10);
3798: hr_utility.set_location('v_end_date: '||v_end_date,10);
3799: end if;
3800:
3801: IF l_hours_or_days = 'D' THEN
3794: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
3795:
3796: if g_debug then
3797: hr_utility.set_location('v_start_date: '||v_start_date,10);
3798: hr_utility.set_location('v_end_date: '||v_end_date,10);
3799: end if;
3800:
3801: IF l_hours_or_days = 'D' THEN
3802: v_end_date := l_end_date + 1;
3813: , x_schedule => l_schedule
3814: , x_return_status => l_return_status
3815: , x_return_message => l_return_message
3816: );
3817: hr_utility.set_location('after cac .get_absence_data ',230);
3818:
3819:
3820: IF l_return_status = '0' THEN
3821:
3819:
3820: IF l_return_status = '0' THEN
3821:
3822: if g_debug then
3823: hr_utility.set_location('Entering sch found ',240);
3824: end if;
3825:
3826: l_idx := l_schedule.first;
3827:
3827:
3828: IF l_hours_or_days = 'D' THEN
3829:
3830: if g_debug then
3831: hr_utility.set_location('.get_absence_data ',250);
3832: end if;
3833:
3834: l_first_band := TRUE;
3835: l_ref_date := NULL;
3837: WHILE l_idx IS NOT NULL
3838: LOOP
3839:
3840: if g_debug then
3841: hr_utility.set_location('.get_absence_data',270);
3842: end if;
3843:
3844: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
3845: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
3870: -- for hours
3871: else
3872:
3873: if g_debug then
3874: hr_utility.set_location(' indexloop hours .get_absence_data block2 ',280);
3875: end if;
3876:
3877:
3878: l_day_start_time := '00:00';
3913: else
3914: -- when cac is not in use then we will provide absences on day basis as we do not know the schedule of the person
3915:
3916: if g_debug then
3917: hr_utility.set_location('CAC is not used -block2 ',290);
3918: end if;
3919: l_rec_start_date :=l_start_date;
3920: l_rec_end_date :=l_end_date;
3921:
4057: ---------------
4058: -- " SSHR DATA is valid and insert into pl sql table. "
4059: ---------------
4060: if g_debug then
4061: hr_utility.set_location('SS Tran data is valid- block2 ',280);
4062: end if;
4063:
4064:
4065: if l_hours_or_days ='H' then
4081:
4082: IF l_sch_based_dur = 'Y' THEN
4083:
4084: if g_debug then
4085: hr_utility.set_location(' CAC profile set to Yes block2 ',280);
4086: end if;
4087:
4088: -- as this is in update mode so hours may not be present in ss tran tables hence getting from core tables
4089:
4110:
4111: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
4112: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
4113: if g_debug then
4114: hr_utility.set_location('v_start_date: '||v_start_date,290);
4115: hr_utility.set_location('v_end_date: '||v_end_date,290);
4116: end if;
4117:
4118: IF l_hours_or_days = 'D' THEN
4111: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
4112: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
4113: if g_debug then
4114: hr_utility.set_location('v_start_date: '||v_start_date,290);
4115: hr_utility.set_location('v_end_date: '||v_end_date,290);
4116: end if;
4117:
4118: IF l_hours_or_days = 'D' THEN
4119: v_end_date := l_end_date + 1;
4119: v_end_date := l_end_date + 1;
4120: END IF;
4121:
4122: if g_debug then
4123: hr_utility.set_location('before cac .get_absence_data ',300);
4124: end if;
4125: hr_wrk_sch_pkg.get_per_asg_schedule
4126: ( p_person_assignment_id => l_assignment_id
4127: , p_period_start_date => v_start_date
4134: , x_return_status => l_return_status
4135: , x_return_message => l_return_message
4136: );
4137: if g_debug then
4138: hr_utility.set_location('after cac .get_absence_data ',310);
4139: end if;
4140:
4141: IF l_return_status = '0' THEN
4142:
4140:
4141: IF l_return_status = '0' THEN
4142:
4143: if g_debug then
4144: hr_utility.set_location('Entering sch found ',310);
4145: end if;
4146:
4147: l_idx := l_schedule.first;
4148: IF l_hours_or_days = 'D' THEN
4147: l_idx := l_schedule.first;
4148: IF l_hours_or_days = 'D' THEN
4149:
4150: if g_debug then
4151: hr_utility.set_location('.get_absence_data ',320);
4152: end if;
4153:
4154: l_first_band := TRUE;
4155: l_ref_date := NULL;
4157: WHILE l_idx IS NOT NULL
4158: LOOP
4159:
4160: if g_debug then
4161: hr_utility.set_location('.get_absence_data ',330);
4162: end if;
4163:
4164: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
4165: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
4191:
4192: -- for hours
4193: else
4194: if g_debug then
4195: hr_utility.set_location(' indexloop hours .get_absence_data blk2',340);
4196: end if;
4197:
4198:
4199: l_day_start_time := '00:00';
4238:
4239: -- when cac is not in use then we will provide absences on day basis as we do not know the schedule of the person
4240:
4241: if g_debug then
4242: hr_utility.set_location('CAC is not used -block2 ',290);
4243: end if;
4244: l_rec_start_date :=l_start_date;
4245: l_rec_end_date :=l_end_date;
4246:
4390: end if; -- core_ovn > ss_ovn if condition
4391: end loop;
4392: close csr_sshr_abs_records;
4393: if g_debug then
4394: hr_utility.set_location(' End of Blk2',340);
4395: end if;
4396: ssmodes :=ssmodes+1;
4397: end loop; -- new while loop to cover for "COnfirm mode" as well
4398: -----------------------
4410: l_abs_type,l_ele_type,l_absence_attendance_id,l_hours_or_days,l_program_application_id,l_duration,l_confirmed_flag;
4411:
4412:
4413: if g_debug then
4414: hr_utility.set_location(' Ony Core Data Blk3',400);
4415: end if;
4416:
4417: if g_debug then
4418: hr_utility.set_location('Entering .get_absence_data',400);
4414: hr_utility.set_location(' Ony Core Data Blk3',400);
4415: end if;
4416:
4417: if g_debug then
4418: hr_utility.set_location('Entering .get_absence_data',400);
4419: hr_utility.set_location(' l_start_date '||l_start_date,400);
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4415: end if;
4416:
4417: if g_debug then
4418: hr_utility.set_location('Entering .get_absence_data',400);
4419: hr_utility.set_location(' l_start_date '||l_start_date,400);
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4423: hr_utility.set_location(' l_ele_type '||l_ele_type,400);
4416:
4417: if g_debug then
4418: hr_utility.set_location('Entering .get_absence_data',400);
4419: hr_utility.set_location(' l_start_date '||l_start_date,400);
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4423: hr_utility.set_location(' l_ele_type '||l_ele_type,400);
4424: hr_utility.set_location(' l_abs_type '||l_abs_type,400);
4418: hr_utility.set_location('Entering .get_absence_data',400);
4419: hr_utility.set_location(' l_start_date '||l_start_date,400);
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4423: hr_utility.set_location(' l_ele_type '||l_ele_type,400);
4424: hr_utility.set_location(' l_abs_type '||l_abs_type,400);
4425: end if;
4426:
4419: hr_utility.set_location(' l_start_date '||l_start_date,400);
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4423: hr_utility.set_location(' l_ele_type '||l_ele_type,400);
4424: hr_utility.set_location(' l_abs_type '||l_abs_type,400);
4425: end if;
4426:
4427: exit when csr_core_absences%notfound;
4420: hr_utility.set_location(' l_end_date '|| l_end_date,400);
4421:
4422: hr_utility.set_location(' l_hours_or_days '||l_hours_or_days,400);
4423: hr_utility.set_location(' l_ele_type '||l_ele_type,400);
4424: hr_utility.set_location(' l_abs_type '||l_abs_type,400);
4425: end if;
4426:
4427: exit when csr_core_absences%notfound;
4428:
4428:
4429: IF l_sch_based_dur = 'Y' THEN
4430:
4431: if g_debug then
4432: hr_utility.set_location(' CAC Profile set yes Blk3',410);
4433: end if;
4434:
4435:
4436: IF l_time_start IS NULL THEN
4455:
4456: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
4457: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
4458: if g_debug then
4459: hr_utility.set_location('v_start_date: '||v_start_date,410);
4460: hr_utility.set_location('v_end_date: '||v_end_date,410);
4461: end if;
4462:
4463: IF l_hours_or_days = 'D' THEN
4456: v_start_date := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
4457: v_end_date := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
4458: if g_debug then
4459: hr_utility.set_location('v_start_date: '||v_start_date,410);
4460: hr_utility.set_location('v_end_date: '||v_end_date,410);
4461: end if;
4462:
4463: IF l_hours_or_days = 'D' THEN
4464: v_end_date := l_end_date + 1;
4464: v_end_date := l_end_date + 1;
4465: END IF;
4466:
4467: if g_debug then
4468: hr_utility.set_location('before cac .get_absence_data SS',420);
4469: end if;
4470: hr_wrk_sch_pkg.get_per_asg_schedule
4471: ( p_person_assignment_id => l_assignment_id
4472: , p_period_start_date => v_start_date
4479: , x_return_status => l_return_status
4480: , x_return_message => l_return_message
4481: );
4482: if g_debug then
4483: hr_utility.set_location('after cac .get_absence_data ',430);
4484: end if;
4485:
4486: IF l_return_status = '0' THEN
4487:
4485:
4486: IF l_return_status = '0' THEN
4487:
4488: if g_debug then
4489: hr_utility.set_location('Entering sch found ',430);
4490: end if;
4491:
4492: l_idx := l_schedule.first;
4493: IF l_hours_or_days = 'D' THEN
4492: l_idx := l_schedule.first;
4493: IF l_hours_or_days = 'D' THEN
4494:
4495: if g_debug then
4496: hr_utility.set_location('.get_absence_data',440);
4497: end if;
4498:
4499: l_first_band := TRUE;
4500: l_ref_date := NULL;
4502: WHILE l_idx IS NOT NULL
4503: LOOP
4504:
4505: if g_debug then
4506: hr_utility.set_location('.get_absence_data',450);
4507: end if;
4508:
4509: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
4510: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
4535:
4536: -- for hours
4537: else
4538: if g_debug then
4539: hr_utility.set_location(' indexloop hours .get_absence_data blk3',460);
4540: end if;
4541:
4542:
4543: l_day_start_time := '00:00';
4584: -- when cac is not in use then we will provide absences on day basis as we do not know the schedule of the person
4585:
4586:
4587: if g_debug then
4588: hr_utility.set_location('CAC not is use Blk3',490);
4589: end if;
4590:
4591: l_rec_start_date :=l_start_date;
4592: l_rec_end_date :=l_end_date;
4737:
4738: end loop; -- csr_core_absences loop
4739: close csr_core_absences;
4740: if g_debug then
4741: hr_utility.set_location('End of Blk3 ',500);
4742: end if;
4743:
4744: end if; -- for Delete mode check
4745:
4745:
4746: else
4747:
4748: if g_debug then
4749: hr_utility.set_location(' Profile HR OTL Integ setto OFF ',10);
4750: end if;
4751:
4752: end if; -- OTL Integration Check
4753:
4752: end if; -- OTL Integration Check
4753:
4754: EXCEPTION
4755: WHEN e_bad_time_format THEN
4756: hr_utility.set_location('Leaving coz exception '||'.get_absence_data',30);
4757: hr_utility.set_location(SQLERRM,35);
4758: RAISE;
4759: /*
4760: WHEN OTHERS THEN
4753:
4754: EXCEPTION
4755: WHEN e_bad_time_format THEN
4756: hr_utility.set_location('Leaving coz exception '||'.get_absence_data',30);
4757: hr_utility.set_location(SQLERRM,35);
4758: RAISE;
4759: /*
4760: WHEN OTHERS THEN
4761: hr_utility.set_location('Leaving coz exception '||'.get_absence_data',40);
4757: hr_utility.set_location(SQLERRM,35);
4758: RAISE;
4759: /*
4760: WHEN OTHERS THEN
4761: hr_utility.set_location('Leaving coz exception '||'.get_absence_data',40);
4762: hr_utility.set_location(SQLERRM,45);
4763: RAISE;
4764: */
4765:
4758: RAISE;
4759: /*
4760: WHEN OTHERS THEN
4761: hr_utility.set_location('Leaving coz exception '||'.get_absence_data',40);
4762: hr_utility.set_location(SQLERRM,45);
4763: RAISE;
4764: */
4765:
4766: