APPS.HR_PERSON_ABSENCE_API dependencies on HR_UTILITY

Line 111: hr_utility.set_location('Entering: '|| l_proc, 10);

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

Line 203: hr_utility.set_location('Leaving: '|| l_proc, 15);

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 >---------------------------|

Line 343: hr_utility.set_location('Entering:'|| l_proc, 10);

339: l_dur_overwritten_warning boolean;
340: --
341:
342: begin
343: hr_utility.set_location('Entering:'|| l_proc, 10);
344:
345: --
346: -- Pipe the main IN / IN OUT parameters for ease of debugging.
347: --

Line 348: hr_utility.trace(' ');

344:
345: --
346: -- Pipe the main IN / IN OUT parameters for ease of debugging.
347: --
348: hr_utility.trace(' ');
349: hr_utility.trace(' --------------------------------'||
350: '---------------------------------');
351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
352: ' VALUE');

Line 349: hr_utility.trace(' --------------------------------'||

345: --
346: -- Pipe the main IN / IN OUT parameters for ease of debugging.
347: --
348: hr_utility.trace(' ');
349: hr_utility.trace(' --------------------------------'||
350: '---------------------------------');
351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
352: ' VALUE');
353: hr_utility.trace(' --------------------------------'||

Line 351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||

347: --
348: hr_utility.trace(' ');
349: hr_utility.trace(' --------------------------------'||
350: '---------------------------------');
351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
352: ' VALUE');
353: hr_utility.trace(' --------------------------------'||
354: '+--------------------------------');
355: hr_utility.trace(' p_effective_date '||

Line 353: hr_utility.trace(' --------------------------------'||

349: hr_utility.trace(' --------------------------------'||
350: '---------------------------------');
351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
352: ' VALUE');
353: hr_utility.trace(' --------------------------------'||
354: '+--------------------------------');
355: hr_utility.trace(' p_effective_date '||
356: to_char(p_effective_date));
357: hr_utility.trace(' p_person_id '||

Line 355: hr_utility.trace(' p_effective_date '||

351: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
352: ' VALUE');
353: hr_utility.trace(' --------------------------------'||
354: '+--------------------------------');
355: hr_utility.trace(' p_effective_date '||
356: to_char(p_effective_date));
357: hr_utility.trace(' p_person_id '||
358: to_char(p_person_id));
359: hr_utility.trace(' p_business_group_id '||

Line 357: hr_utility.trace(' p_person_id '||

353: hr_utility.trace(' --------------------------------'||
354: '+--------------------------------');
355: hr_utility.trace(' p_effective_date '||
356: to_char(p_effective_date));
357: hr_utility.trace(' p_person_id '||
358: to_char(p_person_id));
359: hr_utility.trace(' p_business_group_id '||
360: to_char(p_business_group_id));
361: hr_utility.trace(' p_absence_attendance_type_id '||

Line 359: hr_utility.trace(' p_business_group_id '||

355: hr_utility.trace(' p_effective_date '||
356: to_char(p_effective_date));
357: hr_utility.trace(' p_person_id '||
358: to_char(p_person_id));
359: hr_utility.trace(' p_business_group_id '||
360: to_char(p_business_group_id));
361: hr_utility.trace(' p_absence_attendance_type_id '||
362: to_char(p_absence_attendance_type_id));
363: hr_utility.trace(' p_abs_attendance_reason_id '||

Line 361: hr_utility.trace(' p_absence_attendance_type_id '||

357: hr_utility.trace(' p_person_id '||
358: to_char(p_person_id));
359: hr_utility.trace(' p_business_group_id '||
360: to_char(p_business_group_id));
361: hr_utility.trace(' p_absence_attendance_type_id '||
362: to_char(p_absence_attendance_type_id));
363: hr_utility.trace(' p_abs_attendance_reason_id '||
364: to_char(p_abs_attendance_reason_id));
365: hr_utility.trace(' p_date_notification '||

Line 363: hr_utility.trace(' p_abs_attendance_reason_id '||

359: hr_utility.trace(' p_business_group_id '||
360: to_char(p_business_group_id));
361: hr_utility.trace(' p_absence_attendance_type_id '||
362: to_char(p_absence_attendance_type_id));
363: hr_utility.trace(' p_abs_attendance_reason_id '||
364: to_char(p_abs_attendance_reason_id));
365: hr_utility.trace(' p_date_notification '||
366: to_char(p_date_notification));
367: hr_utility.trace(' p_date_projected_start '||

Line 365: hr_utility.trace(' p_date_notification '||

361: hr_utility.trace(' p_absence_attendance_type_id '||
362: to_char(p_absence_attendance_type_id));
363: hr_utility.trace(' p_abs_attendance_reason_id '||
364: to_char(p_abs_attendance_reason_id));
365: hr_utility.trace(' p_date_notification '||
366: to_char(p_date_notification));
367: hr_utility.trace(' p_date_projected_start '||
368: to_char(p_date_projected_start));
369: hr_utility.trace(' p_time_projected_start '||

Line 367: hr_utility.trace(' p_date_projected_start '||

363: hr_utility.trace(' p_abs_attendance_reason_id '||
364: to_char(p_abs_attendance_reason_id));
365: hr_utility.trace(' p_date_notification '||
366: to_char(p_date_notification));
367: hr_utility.trace(' p_date_projected_start '||
368: to_char(p_date_projected_start));
369: hr_utility.trace(' p_time_projected_start '||
370: p_time_projected_start);
371: hr_utility.trace(' p_date_projected_end '||

Line 369: hr_utility.trace(' p_time_projected_start '||

365: hr_utility.trace(' p_date_notification '||
366: to_char(p_date_notification));
367: hr_utility.trace(' p_date_projected_start '||
368: to_char(p_date_projected_start));
369: hr_utility.trace(' p_time_projected_start '||
370: p_time_projected_start);
371: hr_utility.trace(' p_date_projected_end '||
372: to_char(p_date_projected_end));
373: hr_utility.trace(' p_time_projected_end '||

Line 371: hr_utility.trace(' p_date_projected_end '||

367: hr_utility.trace(' p_date_projected_start '||
368: to_char(p_date_projected_start));
369: hr_utility.trace(' p_time_projected_start '||
370: p_time_projected_start);
371: hr_utility.trace(' p_date_projected_end '||
372: to_char(p_date_projected_end));
373: hr_utility.trace(' p_time_projected_end '||
374: p_time_projected_end);
375: hr_utility.trace(' p_date_start '||

Line 373: hr_utility.trace(' p_time_projected_end '||

369: hr_utility.trace(' p_time_projected_start '||
370: p_time_projected_start);
371: hr_utility.trace(' p_date_projected_end '||
372: to_char(p_date_projected_end));
373: hr_utility.trace(' p_time_projected_end '||
374: p_time_projected_end);
375: hr_utility.trace(' p_date_start '||
376: to_char(p_date_start));
377: hr_utility.trace(' p_time_start '||

Line 375: hr_utility.trace(' p_date_start '||

371: hr_utility.trace(' p_date_projected_end '||
372: to_char(p_date_projected_end));
373: hr_utility.trace(' p_time_projected_end '||
374: p_time_projected_end);
375: hr_utility.trace(' p_date_start '||
376: to_char(p_date_start));
377: hr_utility.trace(' p_time_start '||
378: p_time_start);
379: hr_utility.trace(' p_date_end '||

Line 377: hr_utility.trace(' p_time_start '||

373: hr_utility.trace(' p_time_projected_end '||
374: p_time_projected_end);
375: hr_utility.trace(' p_date_start '||
376: to_char(p_date_start));
377: hr_utility.trace(' p_time_start '||
378: p_time_start);
379: hr_utility.trace(' p_date_end '||
380: to_char(p_date_end));
381: hr_utility.trace(' p_time_end '||

Line 379: hr_utility.trace(' p_date_end '||

375: hr_utility.trace(' p_date_start '||
376: to_char(p_date_start));
377: hr_utility.trace(' p_time_start '||
378: p_time_start);
379: hr_utility.trace(' p_date_end '||
380: to_char(p_date_end));
381: hr_utility.trace(' p_time_end '||
382: p_time_end);
383: hr_utility.trace(' p_absence_days '||

Line 381: hr_utility.trace(' p_time_end '||

377: hr_utility.trace(' p_time_start '||
378: p_time_start);
379: hr_utility.trace(' p_date_end '||
380: to_char(p_date_end));
381: hr_utility.trace(' p_time_end '||
382: p_time_end);
383: hr_utility.trace(' p_absence_days '||
384: to_char(p_absence_days));
385: hr_utility.trace(' p_absence_hours '||

Line 383: hr_utility.trace(' p_absence_days '||

379: hr_utility.trace(' p_date_end '||
380: to_char(p_date_end));
381: hr_utility.trace(' p_time_end '||
382: p_time_end);
383: hr_utility.trace(' p_absence_days '||
384: to_char(p_absence_days));
385: hr_utility.trace(' p_absence_hours '||
386: to_char(p_absence_hours));
387: hr_utility.trace(' p_authorising_person_id '||

Line 385: hr_utility.trace(' p_absence_hours '||

381: hr_utility.trace(' p_time_end '||
382: p_time_end);
383: hr_utility.trace(' p_absence_days '||
384: to_char(p_absence_days));
385: hr_utility.trace(' p_absence_hours '||
386: to_char(p_absence_hours));
387: hr_utility.trace(' p_authorising_person_id '||
388: to_char(p_authorising_person_id));
389: hr_utility.trace(' p_batch_id '||

Line 387: hr_utility.trace(' p_authorising_person_id '||

383: hr_utility.trace(' p_absence_days '||
384: to_char(p_absence_days));
385: hr_utility.trace(' p_absence_hours '||
386: to_char(p_absence_hours));
387: hr_utility.trace(' p_authorising_person_id '||
388: to_char(p_authorising_person_id));
389: hr_utility.trace(' p_batch_id '||
390: to_char(p_batch_id));
391: if p_create_element_entry then

Line 389: hr_utility.trace(' p_batch_id '||

385: hr_utility.trace(' p_absence_hours '||
386: to_char(p_absence_hours));
387: hr_utility.trace(' p_authorising_person_id '||
388: to_char(p_authorising_person_id));
389: hr_utility.trace(' p_batch_id '||
390: to_char(p_batch_id));
391: if p_create_element_entry then
392: hr_utility.trace(' p_create_element_entry '||
393: 'TRUE');

Line 392: hr_utility.trace(' p_create_element_entry '||

388: to_char(p_authorising_person_id));
389: hr_utility.trace(' p_batch_id '||
390: to_char(p_batch_id));
391: if p_create_element_entry then
392: hr_utility.trace(' p_create_element_entry '||
393: 'TRUE');
394: else
395: hr_utility.trace(' p_create_element_entry '||
396: 'FALSE');

Line 395: hr_utility.trace(' p_create_element_entry '||

391: if p_create_element_entry then
392: hr_utility.trace(' p_create_element_entry '||
393: 'TRUE');
394: else
395: hr_utility.trace(' p_create_element_entry '||
396: 'FALSE');
397: end if;
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');

Line 398: hr_utility.trace(' --------------------------------'||

394: else
395: hr_utility.trace(' p_create_element_entry '||
396: 'FALSE');
397: end if;
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' ');
401:
402: --

Line 400: hr_utility.trace(' ');

396: 'FALSE');
397: end if;
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' ');
401:
402: --
403: -- Create a savepoint.
404: --

Line 515: hr_utility.set_location(l_proc, 30);

511: ,p_hook_type => 'BP'
512: );
513: end;
514:
515: hr_utility.set_location(l_proc, 30);
516: --
517: -- Insert Person Absence
518: per_abs_ins.ins
519: (p_effective_date => l_effective_date

Line 621: hr_utility.set_location('Start of absence element entry section', 40);

617: p_abs_overlap_warning := l_abs_overlap_warning;
618: p_abs_day_after_warning := l_abs_day_after_warning;
619: p_dur_overwritten_warning := l_dur_overwritten_warning;
620:
621: hr_utility.set_location('Start of absence element entry section', 40);
622:
623: /* Start of Absence Element Entry Section */
624:
625: if p_create_element_entry then

Line 681: hr_utility.set_location('End of absence element entry section', 50);

677:
678: end if;
679: /* End of Absence Element Entry Section */
680:
681: hr_utility.set_location('End of absence element entry section', 50);
682:
683: populate_ben_absence_rec
684: (p_absence_attendance_id => l_absence_attendance_id,
685: p_rec_type => 'N',

Line 691: hr_utility.set_location('Start of BEN call', 52);

687:
688: --
689: -- Start of BEN call.
690: --
691: hr_utility.set_location('Start of BEN call', 52);
692:
693: ben_abs_ler.ler_chk
694: (p_old => l_old
695: ,p_new => l_new

Line 698: hr_utility.set_location('End of BEN call', 54);

694: (p_old => l_old
695: ,p_new => l_new
696: ,p_effective_date => l_effective_date);
697:
698: hr_utility.set_location('End of BEN call', 54);
699:
700: --
701: -- Call After Process User Hook
702: --

Line 826: hr_utility.trace(' ');

822:
823: --
824: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
825: --
826: hr_utility.trace(' ');
827: hr_utility.trace(' --------------------------------'||
828: '---------------------------------');
829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
830: ' VALUE');

Line 827: hr_utility.trace(' --------------------------------'||

823: --
824: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
825: --
826: hr_utility.trace(' ');
827: hr_utility.trace(' --------------------------------'||
828: '---------------------------------');
829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
830: ' VALUE');
831: hr_utility.trace(' --------------------------------'||

Line 829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||

825: --
826: hr_utility.trace(' ');
827: hr_utility.trace(' --------------------------------'||
828: '---------------------------------');
829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
830: ' VALUE');
831: hr_utility.trace(' --------------------------------'||
832: '+--------------------------------');
833: hr_utility.trace(' p_absence_days '||

Line 831: hr_utility.trace(' --------------------------------'||

827: hr_utility.trace(' --------------------------------'||
828: '---------------------------------');
829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
830: ' VALUE');
831: hr_utility.trace(' --------------------------------'||
832: '+--------------------------------');
833: hr_utility.trace(' p_absence_days '||
834: to_char(p_absence_days));
835: hr_utility.trace(' p_absence_hours '||

Line 833: hr_utility.trace(' p_absence_days '||

829: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
830: ' VALUE');
831: hr_utility.trace(' --------------------------------'||
832: '+--------------------------------');
833: hr_utility.trace(' p_absence_days '||
834: to_char(p_absence_days));
835: hr_utility.trace(' p_absence_hours '||
836: to_char(p_absence_hours));
837: hr_utility.trace(' p_absence_attendance_id '||

Line 835: hr_utility.trace(' p_absence_hours '||

831: hr_utility.trace(' --------------------------------'||
832: '+--------------------------------');
833: hr_utility.trace(' p_absence_days '||
834: to_char(p_absence_days));
835: hr_utility.trace(' p_absence_hours '||
836: to_char(p_absence_hours));
837: hr_utility.trace(' p_absence_attendance_id '||
838: to_char(p_absence_attendance_id));
839: hr_utility.trace(' p_object_version_number '||

Line 837: hr_utility.trace(' p_absence_attendance_id '||

833: hr_utility.trace(' p_absence_days '||
834: to_char(p_absence_days));
835: hr_utility.trace(' p_absence_hours '||
836: to_char(p_absence_hours));
837: hr_utility.trace(' p_absence_attendance_id '||
838: to_char(p_absence_attendance_id));
839: hr_utility.trace(' p_object_version_number '||
840: to_char(p_object_version_number));
841: hr_utility.trace(' p_occurrence '||

Line 839: hr_utility.trace(' p_object_version_number '||

835: hr_utility.trace(' p_absence_hours '||
836: to_char(p_absence_hours));
837: hr_utility.trace(' p_absence_attendance_id '||
838: to_char(p_absence_attendance_id));
839: hr_utility.trace(' p_object_version_number '||
840: to_char(p_object_version_number));
841: hr_utility.trace(' p_occurrence '||
842: to_char(p_occurrence));
843: hr_utility.trace(' --------------------------------'||

Line 841: hr_utility.trace(' p_occurrence '||

837: hr_utility.trace(' p_absence_attendance_id '||
838: to_char(p_absence_attendance_id));
839: hr_utility.trace(' p_object_version_number '||
840: to_char(p_object_version_number));
841: hr_utility.trace(' p_occurrence '||
842: to_char(p_occurrence));
843: hr_utility.trace(' --------------------------------'||
844: '---------------------------------');
845: hr_utility.trace(' ');

Line 843: hr_utility.trace(' --------------------------------'||

839: hr_utility.trace(' p_object_version_number '||
840: to_char(p_object_version_number));
841: hr_utility.trace(' p_occurrence '||
842: to_char(p_occurrence));
843: hr_utility.trace(' --------------------------------'||
844: '---------------------------------');
845: hr_utility.trace(' ');
846:
847: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 845: hr_utility.trace(' ');

841: hr_utility.trace(' p_occurrence '||
842: to_char(p_occurrence));
843: hr_utility.trace(' --------------------------------'||
844: '---------------------------------');
845: hr_utility.trace(' ');
846:
847: hr_utility.set_location(' Leaving:'||l_proc, 70);
848:
849: exception

Line 847: hr_utility.set_location(' Leaving:'||l_proc, 70);

843: hr_utility.trace(' --------------------------------'||
844: '---------------------------------');
845: hr_utility.trace(' ');
846:
847: hr_utility.set_location(' Leaving:'||l_proc, 70);
848:
849: exception
850: when hr_api.validate_enabled then
851: --

Line 863: hr_utility.set_location(l_proc, 80);

859: -- when validation only mode is being used.)
860: --
861: p_absence_attendance_id := null;
862: p_object_version_number := null;
863: hr_utility.set_location(l_proc, 80);
864: when others then
865: --
866: -- A validation or unexpected error has occured
867: --

Line 880: hr_utility.set_location(' Leaving:'||l_proc, 90);

876: p_abs_day_after_warning := null;
877: p_dur_overwritten_warning := null;
878:
879: rollback to create_person_absence;
880: hr_utility.set_location(' Leaving:'||l_proc, 90);
881: raise;
882: end create_person_absence;
883: --
884: -- ----------------------------------------------------------------------------

Line 1041: hr_utility.set_location('Entering:'|| l_proc, 10);

1037: --
1038:
1039: begin
1040:
1041: hr_utility.set_location('Entering:'|| l_proc, 10);
1042: --
1043: lv_object_version_number := p_object_version_number ;
1044: lv_absence_days := p_absence_days ;
1045: lv_absence_hours := p_absence_hours ;

Line 1054: hr_utility.trace(' ');

1050:
1051: --
1052: -- Pipe the main IN / IN OUT parameters for ease of debugging.
1053: --
1054: hr_utility.trace(' ');
1055: hr_utility.trace(' --------------------------------'||
1056: '---------------------------------');
1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1058: ' VALUE');

Line 1055: hr_utility.trace(' --------------------------------'||

1051: --
1052: -- Pipe the main IN / IN OUT parameters for ease of debugging.
1053: --
1054: hr_utility.trace(' ');
1055: hr_utility.trace(' --------------------------------'||
1056: '---------------------------------');
1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1058: ' VALUE');
1059: hr_utility.trace(' --------------------------------'||

Line 1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||

1053: --
1054: hr_utility.trace(' ');
1055: hr_utility.trace(' --------------------------------'||
1056: '---------------------------------');
1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1058: ' VALUE');
1059: hr_utility.trace(' --------------------------------'||
1060: '+--------------------------------');
1061: hr_utility.trace(' p_effective_date '||

Line 1059: hr_utility.trace(' --------------------------------'||

1055: hr_utility.trace(' --------------------------------'||
1056: '---------------------------------');
1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1058: ' VALUE');
1059: hr_utility.trace(' --------------------------------'||
1060: '+--------------------------------');
1061: hr_utility.trace(' p_effective_date '||
1062: to_char(p_effective_date));
1063: hr_utility.trace(' p_absence_attendance_id '||

Line 1061: hr_utility.trace(' p_effective_date '||

1057: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
1058: ' VALUE');
1059: hr_utility.trace(' --------------------------------'||
1060: '+--------------------------------');
1061: hr_utility.trace(' p_effective_date '||
1062: to_char(p_effective_date));
1063: hr_utility.trace(' p_absence_attendance_id '||
1064: to_char(p_absence_attendance_id));
1065: hr_utility.trace(' p_abs_attendance_reason_id '||

Line 1063: hr_utility.trace(' p_absence_attendance_id '||

1059: hr_utility.trace(' --------------------------------'||
1060: '+--------------------------------');
1061: hr_utility.trace(' p_effective_date '||
1062: to_char(p_effective_date));
1063: hr_utility.trace(' p_absence_attendance_id '||
1064: to_char(p_absence_attendance_id));
1065: hr_utility.trace(' p_abs_attendance_reason_id '||
1066: to_char(p_abs_attendance_reason_id));
1067: hr_utility.trace(' p_date_notification '||

Line 1065: hr_utility.trace(' p_abs_attendance_reason_id '||

1061: hr_utility.trace(' p_effective_date '||
1062: to_char(p_effective_date));
1063: hr_utility.trace(' p_absence_attendance_id '||
1064: to_char(p_absence_attendance_id));
1065: hr_utility.trace(' p_abs_attendance_reason_id '||
1066: to_char(p_abs_attendance_reason_id));
1067: hr_utility.trace(' p_date_notification '||
1068: to_char(p_date_notification));
1069: hr_utility.trace(' p_date_projected_start '||

Line 1067: hr_utility.trace(' p_date_notification '||

1063: hr_utility.trace(' p_absence_attendance_id '||
1064: to_char(p_absence_attendance_id));
1065: hr_utility.trace(' p_abs_attendance_reason_id '||
1066: to_char(p_abs_attendance_reason_id));
1067: hr_utility.trace(' p_date_notification '||
1068: to_char(p_date_notification));
1069: hr_utility.trace(' p_date_projected_start '||
1070: to_char(p_date_projected_start));
1071: hr_utility.trace(' p_time_projected_start '||

Line 1069: hr_utility.trace(' p_date_projected_start '||

1065: hr_utility.trace(' p_abs_attendance_reason_id '||
1066: to_char(p_abs_attendance_reason_id));
1067: hr_utility.trace(' p_date_notification '||
1068: to_char(p_date_notification));
1069: hr_utility.trace(' p_date_projected_start '||
1070: to_char(p_date_projected_start));
1071: hr_utility.trace(' p_time_projected_start '||
1072: p_time_projected_start);
1073: hr_utility.trace(' p_date_projected_end '||

Line 1071: hr_utility.trace(' p_time_projected_start '||

1067: hr_utility.trace(' p_date_notification '||
1068: to_char(p_date_notification));
1069: hr_utility.trace(' p_date_projected_start '||
1070: to_char(p_date_projected_start));
1071: hr_utility.trace(' p_time_projected_start '||
1072: p_time_projected_start);
1073: hr_utility.trace(' p_date_projected_end '||
1074: to_char(p_date_projected_end));
1075: hr_utility.trace(' p_time_projected_end '||

Line 1073: hr_utility.trace(' p_date_projected_end '||

1069: hr_utility.trace(' p_date_projected_start '||
1070: to_char(p_date_projected_start));
1071: hr_utility.trace(' p_time_projected_start '||
1072: p_time_projected_start);
1073: hr_utility.trace(' p_date_projected_end '||
1074: to_char(p_date_projected_end));
1075: hr_utility.trace(' p_time_projected_end '||
1076: p_time_projected_end);
1077: hr_utility.trace(' p_date_start '||

Line 1075: hr_utility.trace(' p_time_projected_end '||

1071: hr_utility.trace(' p_time_projected_start '||
1072: p_time_projected_start);
1073: hr_utility.trace(' p_date_projected_end '||
1074: to_char(p_date_projected_end));
1075: hr_utility.trace(' p_time_projected_end '||
1076: p_time_projected_end);
1077: hr_utility.trace(' p_date_start '||
1078: to_char(p_date_start));
1079: hr_utility.trace(' p_time_start '||

Line 1077: hr_utility.trace(' p_date_start '||

1073: hr_utility.trace(' p_date_projected_end '||
1074: to_char(p_date_projected_end));
1075: hr_utility.trace(' p_time_projected_end '||
1076: p_time_projected_end);
1077: hr_utility.trace(' p_date_start '||
1078: to_char(p_date_start));
1079: hr_utility.trace(' p_time_start '||
1080: p_time_start);
1081: hr_utility.trace(' p_date_end '||

Line 1079: hr_utility.trace(' p_time_start '||

1075: hr_utility.trace(' p_time_projected_end '||
1076: p_time_projected_end);
1077: hr_utility.trace(' p_date_start '||
1078: to_char(p_date_start));
1079: hr_utility.trace(' p_time_start '||
1080: p_time_start);
1081: hr_utility.trace(' p_date_end '||
1082: to_char(p_date_end));
1083: hr_utility.trace(' p_time_end '||

Line 1081: hr_utility.trace(' p_date_end '||

1077: hr_utility.trace(' p_date_start '||
1078: to_char(p_date_start));
1079: hr_utility.trace(' p_time_start '||
1080: p_time_start);
1081: hr_utility.trace(' p_date_end '||
1082: to_char(p_date_end));
1083: hr_utility.trace(' p_time_end '||
1084: p_time_end);
1085: hr_utility.trace(' p_absence_days '||

Line 1083: hr_utility.trace(' p_time_end '||

1079: hr_utility.trace(' p_time_start '||
1080: p_time_start);
1081: hr_utility.trace(' p_date_end '||
1082: to_char(p_date_end));
1083: hr_utility.trace(' p_time_end '||
1084: p_time_end);
1085: hr_utility.trace(' p_absence_days '||
1086: to_char(p_absence_days));
1087: hr_utility.trace(' p_absence_hours '||

Line 1085: hr_utility.trace(' p_absence_days '||

1081: hr_utility.trace(' p_date_end '||
1082: to_char(p_date_end));
1083: hr_utility.trace(' p_time_end '||
1084: p_time_end);
1085: hr_utility.trace(' p_absence_days '||
1086: to_char(p_absence_days));
1087: hr_utility.trace(' p_absence_hours '||
1088: to_char(p_absence_hours));
1089: hr_utility.trace(' p_authorising_person_id '||

Line 1087: hr_utility.trace(' p_absence_hours '||

1083: hr_utility.trace(' p_time_end '||
1084: p_time_end);
1085: hr_utility.trace(' p_absence_days '||
1086: to_char(p_absence_days));
1087: hr_utility.trace(' p_absence_hours '||
1088: to_char(p_absence_hours));
1089: hr_utility.trace(' p_authorising_person_id '||
1090: to_char(p_authorising_person_id));
1091: hr_utility.trace(' p_batch_id '||

Line 1089: hr_utility.trace(' p_authorising_person_id '||

1085: hr_utility.trace(' p_absence_days '||
1086: to_char(p_absence_days));
1087: hr_utility.trace(' p_absence_hours '||
1088: to_char(p_absence_hours));
1089: hr_utility.trace(' p_authorising_person_id '||
1090: to_char(p_authorising_person_id));
1091: hr_utility.trace(' p_batch_id '||
1092: to_char(p_batch_id));
1093: hr_utility.trace(' p_object_version_number '||

Line 1091: hr_utility.trace(' p_batch_id '||

1087: hr_utility.trace(' p_absence_hours '||
1088: to_char(p_absence_hours));
1089: hr_utility.trace(' p_authorising_person_id '||
1090: to_char(p_authorising_person_id));
1091: hr_utility.trace(' p_batch_id '||
1092: to_char(p_batch_id));
1093: hr_utility.trace(' p_object_version_number '||
1094: to_char(p_object_version_number));
1095: hr_utility.trace(' --------------------------------'||

Line 1093: hr_utility.trace(' p_object_version_number '||

1089: hr_utility.trace(' p_authorising_person_id '||
1090: to_char(p_authorising_person_id));
1091: hr_utility.trace(' p_batch_id '||
1092: to_char(p_batch_id));
1093: hr_utility.trace(' p_object_version_number '||
1094: to_char(p_object_version_number));
1095: hr_utility.trace(' --------------------------------'||
1096: '---------------------------------');
1097: hr_utility.trace(' ');

Line 1095: hr_utility.trace(' --------------------------------'||

1091: hr_utility.trace(' p_batch_id '||
1092: to_char(p_batch_id));
1093: hr_utility.trace(' p_object_version_number '||
1094: to_char(p_object_version_number));
1095: hr_utility.trace(' --------------------------------'||
1096: '---------------------------------');
1097: hr_utility.trace(' ');
1098:
1099: --

Line 1097: hr_utility.trace(' ');

1093: hr_utility.trace(' p_object_version_number '||
1094: to_char(p_object_version_number));
1095: hr_utility.trace(' --------------------------------'||
1096: '---------------------------------');
1097: hr_utility.trace(' ');
1098:
1099: --
1100: -- Truncate the time portion from all IN date parameters
1101: --

Line 1112: hr_utility.trace('Old Dur Dys: '||to_char(l_absence_days));

1108:
1109: l_absence_days := p_absence_days;
1110: l_absence_hours := p_absence_hours;
1111:
1112: hr_utility.trace('Old Dur Dys: '||to_char(l_absence_days));
1113: hr_utility.trace('Old Dur Hrs: '||to_char(l_absence_hours));
1114:
1115: --
1116: -- Call Before Process User Hook

Line 1113: hr_utility.trace('Old Dur Hrs: '||to_char(l_absence_hours));

1109: l_absence_days := p_absence_days;
1110: l_absence_hours := p_absence_hours;
1111:
1112: hr_utility.trace('Old Dur Dys: '||to_char(l_absence_days));
1113: hr_utility.trace('Old Dur Hrs: '||to_char(l_absence_hours));
1114:
1115: --
1116: -- Call Before Process User Hook
1117: --

Line 1211: hr_utility.set_location(l_proc, 30);

1207: );
1208: end;
1209:
1210: --
1211: hr_utility.set_location(l_proc, 30);
1212: --
1213: l_object_version_number := p_object_version_number;
1214: --
1215: -- Update Person Absence

Line 1322: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));

1318: p_del_element_entry_warning := l_del_element_entry_warning;
1319: p_absence_days := l_absence_days;
1320: p_absence_hours := l_absence_hours;
1321:
1322: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1323: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1324:
1325:
1326: hr_utility.set_location('Start of absence element entry section', 40);

Line 1323: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));

1319: p_absence_days := l_absence_days;
1320: p_absence_hours := l_absence_hours;
1321:
1322: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1323: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1324:
1325:
1326: hr_utility.set_location('Start of absence element entry section', 40);
1327:

Line 1326: hr_utility.set_location('Start of absence element entry section', 40);

1322: hr_utility.trace('New Dur Dys: '||to_char(l_absence_days));
1323: hr_utility.trace('New Dur Hrs: '||to_char(l_absence_hours));
1324:
1325:
1326: hr_utility.set_location('Start of absence element entry section', 40);
1327:
1328: /* Start of Absence Element Entry Section */
1329: --
1330: -- Update or insert the absence element element. First we

Line 1398: hr_utility.set_location('Scenario 1', 45);

1394: -- Scenario 1.
1395: -- An entry does not already exist. Insert if we have
1396: -- the appropriate dates.
1397: --
1398: hr_utility.set_location('Scenario 1', 45);
1399:
1400: if (l_processing_type = 'N'
1401: and l_date_start_for_absence is not null
1402: and l_date_end_for_absence is not null)

Line 1421: hr_utility.set_location('Scenario 2', 50);

1417: -- absence end date, we date effectively delete the
1418: -- element immediately, otherwise it remains open until
1419: -- the end of time.
1420: --
1421: hr_utility.set_location('Scenario 2', 50);
1422:
1423: delete_absence_element
1424: (p_dt_delete_mode => 'DELETE'
1425: ,p_session_date => l_date_end_for_absence

Line 1444: hr_utility.set_location('Scenario 3', 55);

1440: -- Scenario 3.
1441: -- The element entry should be purged because the
1442: -- actual dates have been removed.
1443: --
1444: hr_utility.set_location('Scenario 3', 55);
1445:
1446: --
1447: -- Warn the user before deleting.
1448: --

Line 1463: hr_utility.set_location('Scenario 4', 60);

1459: -- Scenario 4.
1460: -- The start date cannot be moved outside the entry's
1461: -- current period for non-recurring entries.
1462: --
1463: hr_utility.set_location('Scenario 4', 60);
1464:
1465: fnd_message.set_name ('PAY', 'HR_6744_ABS_DET_ENTRY_PERIOD');
1466: fnd_message.set_token ('PERIOD_FROM',
1467: fnd_date.date_to_chardate(l_effective_start_date));

Line 1479: hr_utility.set_location('Scenario 5', 65);

1475: -- Update the existing entry with the new input values.
1476: -- For simplicity, we make the update even if the value
1477: -- has not changed.
1478: --
1479: hr_utility.set_location('Scenario 5', 65);
1480:
1481: update_absence_element
1482: (p_dt_update_mode => 'CORRECTION'
1483: ,p_session_date => l_effective_start_date

Line 1495: hr_utility.set_location('Scenario 6', 70);

1491: -- Scenario 6.
1492: -- The start date has been moved. As this is part of the
1493: -- primary key we must delete the entry and re-insert it.
1494: --
1495: hr_utility.set_location('Scenario 6', 70);
1496:
1497: delete_absence_element
1498: (p_dt_delete_mode => 'ZAP'
1499: ,p_session_date => l_effective_start_date

Line 1532: hr_utility.set_location('Scenario 7', 75);

1528: -- . been removed
1529: -- . entered for the first time
1530: -- . still not been entered.
1531: --
1532: hr_utility.set_location('Scenario 7', 75);
1533:
1534: if l_effective_end_date <> hr_api.g_eot then
1535: --
1536: -- End date has been changed or removed so we

Line 1540: hr_utility.set_location(l_proc, 76);

1536: -- End date has been changed or removed so we
1537: -- remove the end date so it continues through
1538: -- until the end of time.
1539: --
1540: hr_utility.set_location(l_proc, 76);
1541:
1542: delete_absence_element
1543: (p_dt_delete_mode => 'DELETE_NEXT_CHANGE'
1544: ,p_session_date => l_effective_end_date

Line 1554: hr_utility.set_location(l_proc, 78);

1550: -- End date has been changed or entered for
1551: -- the first time. We end the element entry
1552: -- at the end date.
1553: --
1554: hr_utility.set_location(l_proc, 78);
1555:
1556: delete_absence_element
1557: (p_dt_delete_mode => 'DELETE'
1558: ,p_session_date => l_date_end_for_absence

Line 1574: hr_utility.set_location('End of absence element entry section', 80);

1570:
1571:
1572: /* End of Absence Element Entry Section */
1573:
1574: hr_utility.set_location('End of absence element entry section', 80);
1575:
1576: populate_ben_absence_rec
1577: (p_absence_attendance_id => p_absence_attendance_id,
1578: p_rec_type => 'O',

Line 1589: hr_utility.set_location('Start of BEN call', 82);

1585:
1586: --
1587: -- Start of BEN call.
1588: --
1589: hr_utility.set_location('Start of BEN call', 82);
1590:
1591: ben_abs_ler.ler_chk
1592: (p_old => l_old
1593: ,p_new => l_new

Line 1596: hr_utility.set_location('End of BEN call', 84);

1592: (p_old => l_old
1593: ,p_new => l_new
1594: ,p_effective_date => l_effective_date);
1595:
1596: hr_utility.set_location('End of BEN call', 84);
1597:
1598: --
1599: -- Call After Process User Hook
1600: --

Line 1704: hr_utility.trace(' ');

1700:
1701: --
1702: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1703: --
1704: hr_utility.trace(' ');
1705: hr_utility.trace(' --------------------------------'||
1706: '---------------------------------');
1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
1708: ' VALUE');

Line 1705: hr_utility.trace(' --------------------------------'||

1701: --
1702: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1703: --
1704: hr_utility.trace(' ');
1705: hr_utility.trace(' --------------------------------'||
1706: '---------------------------------');
1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
1708: ' VALUE');
1709: hr_utility.trace(' --------------------------------'||

Line 1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||

1703: --
1704: hr_utility.trace(' ');
1705: hr_utility.trace(' --------------------------------'||
1706: '---------------------------------');
1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
1708: ' VALUE');
1709: hr_utility.trace(' --------------------------------'||
1710: '+--------------------------------');
1711: hr_utility.trace(' p_absence_days '||

Line 1709: hr_utility.trace(' --------------------------------'||

1705: hr_utility.trace(' --------------------------------'||
1706: '---------------------------------');
1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
1708: ' VALUE');
1709: hr_utility.trace(' --------------------------------'||
1710: '+--------------------------------');
1711: hr_utility.trace(' p_absence_days '||
1712: to_char(p_absence_days));
1713: hr_utility.trace(' p_absence_hours '||

Line 1711: hr_utility.trace(' p_absence_days '||

1707: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
1708: ' VALUE');
1709: hr_utility.trace(' --------------------------------'||
1710: '+--------------------------------');
1711: hr_utility.trace(' p_absence_days '||
1712: to_char(p_absence_days));
1713: hr_utility.trace(' p_absence_hours '||
1714: to_char(p_absence_hours));
1715: hr_utility.trace(' p_object_version_number '||

Line 1713: hr_utility.trace(' p_absence_hours '||

1709: hr_utility.trace(' --------------------------------'||
1710: '+--------------------------------');
1711: hr_utility.trace(' p_absence_days '||
1712: to_char(p_absence_days));
1713: hr_utility.trace(' p_absence_hours '||
1714: to_char(p_absence_hours));
1715: hr_utility.trace(' p_object_version_number '||
1716: to_char(p_object_version_number));
1717: hr_utility.trace(' --------------------------------'||

Line 1715: hr_utility.trace(' p_object_version_number '||

1711: hr_utility.trace(' p_absence_days '||
1712: to_char(p_absence_days));
1713: hr_utility.trace(' p_absence_hours '||
1714: to_char(p_absence_hours));
1715: hr_utility.trace(' p_object_version_number '||
1716: to_char(p_object_version_number));
1717: hr_utility.trace(' --------------------------------'||
1718: '---------------------------------');
1719: hr_utility.trace(' ');

Line 1717: hr_utility.trace(' --------------------------------'||

1713: hr_utility.trace(' p_absence_hours '||
1714: to_char(p_absence_hours));
1715: hr_utility.trace(' p_object_version_number '||
1716: to_char(p_object_version_number));
1717: hr_utility.trace(' --------------------------------'||
1718: '---------------------------------');
1719: hr_utility.trace(' ');
1720:
1721: --

Line 1719: hr_utility.trace(' ');

1715: hr_utility.trace(' p_object_version_number '||
1716: to_char(p_object_version_number));
1717: hr_utility.trace(' --------------------------------'||
1718: '---------------------------------');
1719: hr_utility.trace(' ');
1720:
1721: --
1722: -- When in validation only mode raise the Validate_Enabled exception
1723: --

Line 1728: hr_utility.set_location(' Leaving:'||l_proc, 90);

1724: if p_validate then
1725: raise hr_api.validate_enabled;
1726: end if;
1727: --
1728: hr_utility.set_location(' Leaving:'||l_proc, 90);
1729: exception
1730: when hr_api.validate_enabled then
1731: --
1732: -- As the Validate_Enabled exception has been raised

Line 1742: hr_utility.set_location(' Leaving:'||l_proc, 100);

1738: -- (Any key or derived arguments must be set to null
1739: -- when validation only mode is being used.)
1740: --
1741: p_object_version_number := null;
1742: hr_utility.set_location(' Leaving:'||l_proc, 100);
1743: when others then
1744: --
1745: -- A validation or unexpected error has occured
1746: --

Line 1761: hr_utility.set_location(' Leaving:'||l_proc, 110);

1757: p_dur_overwritten_warning := null;
1758: p_del_element_entry_warning := null;
1759:
1760: rollback to update_person_absence;
1761: hr_utility.set_location(' Leaving:'||l_proc, 110);
1762: raise;
1763: end update_person_absence;
1764: --
1765: -- ----------------------------------------------------------------------------

Line 1788: hr_utility.set_location('Entering:'|| l_proc, 10);

1784: l_effective_start_date date;
1785: l_effective_end_date date;
1786:
1787: begin
1788: hr_utility.set_location('Entering:'|| l_proc, 10);
1789: --
1790: -- Issue a savepoint
1791: --
1792: savepoint delete_person_absence;

Line 1811: hr_utility.set_location('Start of absence element deletion section', 30);

1807: );
1808: end;
1809:
1810: --
1811: hr_utility.set_location('Start of absence element deletion section', 30);
1812: --
1813: /* Start of Absence Element Deletion Section */
1814:
1815: --

Line 1841: hr_utility.set_location('End of absence element deletion section', 40);

1837: end if;
1838: End loop;
1839: /* End of Absence Element Deletion Section */
1840:
1841: hr_utility.set_location('End of absence element deletion section', 40);
1842: --
1843: -- Delete Person Absence
1844:
1845: per_abs_del.del

Line 1850: hr_utility.set_location(l_proc, 50);

1846: (p_absence_attendance_id => p_absence_attendance_id
1847: ,p_object_version_number => p_object_version_number
1848: );
1849:
1850: hr_utility.set_location(l_proc, 50);
1851:
1852: populate_ben_absence_rec
1853: (p_absence_attendance_id => p_absence_attendance_id,
1854: p_rec_type => 'O',

Line 1885: hr_utility.set_location(' Leaving:'||l_proc, 70);

1881: raise hr_api.validate_enabled;
1882: end if;
1883:
1884: --
1885: hr_utility.set_location(' Leaving:'||l_proc, 70);
1886: exception
1887: when hr_api.validate_enabled then
1888: --
1889: -- As the Validate_Enabled exception has been raised

Line 1898: hr_utility.set_location(' Leaving:'||l_proc, 80);

1894: -- Only set output warning arguments
1895: -- (Any key or derived arguments must be set to null
1896: -- when validation only mode is being used.)
1897: --
1898: hr_utility.set_location(' Leaving:'||l_proc, 80);
1899: when others then
1900: --
1901: -- A validation or unexpected error has occured
1902: --

Line 1904: hr_utility.set_location(' Leaving:'||l_proc, 90);

1900: --
1901: -- A validation or unexpected error has occured
1902: --
1903: rollback to delete_person_absence;
1904: hr_utility.set_location(' Leaving:'||l_proc, 90);
1905: raise;
1906: --
1907: end delete_person_absence;
1908:

Line 1939: hr_utility.set_location('Entering:'|| l_proc, 10);

1935:
1936:
1937: begin
1938:
1939: hr_utility.set_location('Entering:'|| l_proc, 10);
1940:
1941: open c_get_primary_assignment;
1942: fetch c_get_primary_assignment into l_assignment_id;
1943: close c_get_primary_assignment;

Line 1946: hr_utility.set_location('Leaving:'|| l_proc, 20);

1942: fetch c_get_primary_assignment into l_assignment_id;
1943: close c_get_primary_assignment;
1944:
1945:
1946: hr_utility.set_location('Leaving:'|| l_proc, 20);
1947:
1948: return l_assignment_id;
1949:
1950: end get_primary_assignment;

Line 1975: hr_utility.set_location('Entering:'|| l_proc, 10);

1971:
1972:
1973: begin
1974:
1975: hr_utility.set_location('Entering:'|| l_proc, 10);
1976:
1977: open c_linked_to_element;
1978: fetch c_linked_to_element into l_input_value_id;
1979: close c_linked_to_element;

Line 1989: hr_utility.set_location('Leaving:'|| l_proc, 20);

1985: l_linked_to_element := FALSE;
1986: end if;
1987:
1988:
1989: hr_utility.set_location('Leaving:'|| l_proc, 20);
1990:
1991: return l_linked_to_element;
1992:
1993: end linked_to_element;

Line 2036: hr_utility.set_location('Entering:'|| l_proc, 10);

2032: l_proc varchar2(72) := g_package||'get_absence_element';
2033:
2034: begin
2035:
2036: hr_utility.set_location('Entering:'|| l_proc, 10);
2037:
2038: open c_get_absence_element;
2039: fetch c_get_absence_element into p_element_entry_id,
2040: p_effective_start_date,

Line 2045: hr_utility.set_location('Leaving:'|| l_proc, 20);

2041: p_effective_end_date;
2042: close c_get_absence_element;
2043:
2044:
2045: hr_utility.set_location('Leaving:'|| l_proc, 20);
2046: exception
2047: when others then
2048: p_element_entry_id := null;
2049: p_effective_start_date := null;

Line 2077: hr_utility.set_location('Entering:'|| l_proc, 10);

2073:
2074:
2075: begin
2076:
2077: hr_utility.set_location('Entering:'|| l_proc, 10);
2078:
2079: --
2080: -- Fetch the processing type. If no records are found, the absence type
2081: -- does not have an associated element so null is returned.

Line 2087: hr_utility.set_location('Leaving:'|| l_proc, 20);

2083: open c_get_processing_type;
2084: fetch c_get_processing_type into l_processing_type;
2085: close c_get_processing_type;
2086:
2087: hr_utility.set_location('Leaving:'|| l_proc, 20);
2088:
2089: return l_processing_type;
2090:
2091: end get_processing_type;

Line 2134: hr_utility.set_location('Entering:'|| l_proc, 10);

2130:
2131:
2132: begin
2133:
2134: hr_utility.set_location('Entering:'|| l_proc, 10);
2135:
2136:
2137: -- This should always return a row because this procedure is only
2138: -- called when the absence type has an associated element type.

Line 2151: hr_utility.set_location('Setting entry value', 20);

2147: l_processing_type;
2148: close c_get_element_details;
2149:
2150:
2151: hr_utility.set_location('Setting entry value', 20);
2152:
2153: if upper(l_processing_type) = 'N' then
2154: --
2155: -- p_entry_value is only set when the element type is

Line 2164: hr_utility.set_location(l_proc, 30);

2160: if l_inc_or_dec_flag = 'D' then
2161: --
2162: -- Invert the absence duration for decreasing balances.
2163: --
2164: hr_utility.set_location(l_proc, 30);
2165: p_entry_value := l_absence_hours * -1;
2166:
2167: else
2168:

Line 2169: hr_utility.set_location(l_proc, 40);

2165: p_entry_value := l_absence_hours * -1;
2166:
2167: else
2168:
2169: hr_utility.set_location(l_proc, 40);
2170: p_entry_value := l_absence_hours;
2171:
2172: end if;
2173:

Line 2180: hr_utility.set_location(l_proc, 50);

2176: if l_inc_or_dec_flag = 'D' then
2177: --
2178: -- Invert the absence duration for decreasing balances.
2179: --
2180: hr_utility.set_location(l_proc, 50);
2181: p_entry_value := l_absence_days * -1;
2182:
2183: else
2184:

Line 2185: hr_utility.set_location(l_proc, 60);

2181: p_entry_value := l_absence_days * -1;
2182:
2183: else
2184:
2185: hr_utility.set_location(l_proc, 60);
2186: p_entry_value := l_absence_days;
2187:
2188: end if;
2189:

Line 2194: hr_utility.set_location('Leaving:'|| l_proc, 70);

2190: end if;
2191:
2192: end if;
2193:
2194: hr_utility.set_location('Leaving:'|| l_proc, 70);
2195:
2196: exception
2197: when others then
2198: p_element_type_id := null ;

Line 2230: hr_utility.set_location('Entering:'|| l_proc, 10);

2226:
2227: begin
2228:
2229:
2230: hr_utility.set_location('Entering:'|| l_proc, 10);
2231:
2232: get_element_details
2233: (p_absence_attendance_id => p_absence_attendance_id
2234: ,p_element_type_id => l_element_type_id

Line 2239: hr_utility.set_location('Checking element link', 20);

2235: ,p_input_value_id => l_input_value_id
2236: ,p_entry_value => l_entry_value);
2237:
2238:
2239: hr_utility.set_location('Checking element link', 20);
2240:
2241: l_element_link_id := hr_entry_api.get_link
2242: (p_assignment_id => p_assignment_id
2243: ,p_element_type_id => l_element_type_id

Line 2250: hr_utility.raise_error;

2246: If l_element_link_id is null then
2247: -- Assignment is not eligible for the element type
2248: -- associated with this absence.
2249: fnd_message.set_name ('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');
2250: hr_utility.raise_error;
2251: end if;
2252:
2253:
2254: hr_utility.set_location('Inserting element', 30);

Line 2254: hr_utility.set_location('Inserting element', 30);

2250: hr_utility.raise_error;
2251: end if;
2252:
2253:
2254: hr_utility.set_location('Inserting element', 30);
2255:
2256: -- We know the assignment is eligible for this element because
2257: -- we have the element_link_id. The entries API will handle
2258: -- all other validation (e.g., non-recurring entries must

Line 2274: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);

2270: ,p_input_value_id1 => l_input_value_id
2271: ,p_entry_value1 => l_entry_value);
2272:
2273:
2274: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
2275: hr_utility.set_location('Leaving:'|| l_proc, 50);
2276:
2277: exception
2278: when others then

Line 2275: hr_utility.set_location('Leaving:'|| l_proc, 50);

2271: ,p_entry_value1 => l_entry_value);
2272:
2273:
2274: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
2275: hr_utility.set_location('Leaving:'|| l_proc, 50);
2276:
2277: exception
2278: when others then
2279: p_element_entry_id := null ;

Line 2304: hr_utility.set_location('Entering:'|| l_proc, 10);

2300:
2301: begin
2302:
2303:
2304: hr_utility.set_location('Entering:'|| l_proc, 10);
2305:
2306: get_element_details
2307: (p_absence_attendance_id => p_absence_attendance_id
2308: ,p_element_type_id => l_element_type_id

Line 2313: hr_utility.set_location('Updating element', 20);

2309: ,p_input_value_id => l_input_value_id
2310: ,p_entry_value => l_entry_value);
2311:
2312:
2313: hr_utility.set_location('Updating element', 20);
2314:
2315: -- We know the assignment is eligible for this element because
2316: -- we have the element_link_id. The entries API will handle
2317: -- all other validation (e.g., non-recurring entries must

Line 2330: hr_utility.set_location('Leaving:'|| l_proc, 30);

2326: ,p_input_value_id1 => l_input_value_id
2327: ,p_entry_value1 => l_entry_value);
2328:
2329:
2330: hr_utility.set_location('Leaving:'|| l_proc, 30);
2331:
2332: end update_absence_element;
2333: --
2334: -- ----------------------------------------------------------------------------

Line 2352: hr_utility.set_location('Entering:'|| l_proc, 10);

2348:
2349: begin
2350:
2351:
2352: hr_utility.set_location('Entering:'|| l_proc, 10);
2353:
2354: hr_entry_api.delete_element_entry
2355: (p_dt_delete_mode => p_dt_delete_mode
2356: ,p_session_date => p_session_date

Line 2360: hr_utility.set_location('Leaving:'|| l_proc, 20);

2356: ,p_session_date => p_session_date
2357: ,p_element_entry_id => p_element_entry_id);
2358:
2359:
2360: hr_utility.set_location('Leaving:'|| l_proc, 20);
2361:
2362: end delete_absence_element;
2363: --
2364: end hr_person_absence_api;