713: end loop;
714: close g_absence_dates ;
715: hr_utility.trace('In: ' || l_procedure_name) ;
716: if l_absence_start_date is not null and l_absence_end_date is not null then
717: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
719: hr_utility.raise_error;
720: end if;
721: end if;
747: end loop;
748: close g_absence_dates ;
749: hr_utility.trace('In: ' || l_procedure_name) ;
750: if l_absence_start_date is not null and l_absence_end_date is not null then
751: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
753: hr_utility.raise_error;
754: end if;
755: end if;