181: --
182: hr_utility.set_location('Leaving:'||l_proc,10);
183: --
184: exception
185: when app_exception.application_exception then
186: if hr_multi_message.exception_add
187: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
188: ,p_associated_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'
189: ) then
403: --
404: p_date_end := l_date_end;
405: --
406: exception
407: when app_exception.application_exception then
408: if hr_multi_message.exception_add
409: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
410: ,p_associated_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'
411: ,p_associated_column3 => 'PER_ABSENCE_ATTENDANCE_TYPES.INPUT_VALUE_ID'
483: end if;
484: hr_utility.set_location(l_proc, 20);
485:
486: exception
487: when app_exception.application_exception then
488: if hr_multi_message.exception_add
489: (p_same_associated_columns => 'Y'
490: ) then
491: hr_utility.set_location('Leaving:'||l_proc, 50);
585: end if;
586: hr_utility.set_location('Leaving:'||l_proc,70);
587: --
588: exception
589: when app_exception.application_exception then
590: if hr_multi_message.exception_add
591: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.INCREASING_OR_DECREASING_FLAG'
592: ) then
593: hr_utility.set_location(' Leaving:'||l_proc, 80);
697: end if; --no_all_inclusive_error
698: hr_utility.set_location('Leaving:'||l_proc,70);
699: --
700: exception
701: when app_exception.application_exception then
702: if hr_multi_message.exception_add
703: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.HOURS_OR_DAYS'
704: ) then
705: hr_utility.set_location(' Leaving:'||l_proc, 80);
812: --
813: hr_utility.set_location('Leaving:'||l_proc,70);
814: --
815: exception
816: when app_exception.application_exception then
817: if hr_multi_message.exception_add
818: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_CATEGORY'
819: ) then
820: hr_utility.set_location(' Leaving:'||l_proc, 80);