VALIDATION FORMULA ERROR

Summary:

/* Fast Formula: Restrict leave to 1 day per week */

DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_END_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR ANC_PER_ABS_ENTRS_DURATION IS 0

INPUTS ARE IV_START_DATE (DATE), IV_END_DATE (DATE)

START_OF_WEEK = TRUNC(IV_START_DATE, 'IW')END_OF_WEEK = ADD_DAYS(START_OF_WEEK, 6)

TOTAL_ABSENCE_DAYS = 0

CHANGE_CONTEXTS(START_DATE = START_OF_WEEK, END_DATE = END_OF_WEEK)
TOTAL_ABSENCE_DAYS = ANC_PER_ABS_ENTRS_DURATION

NEW_ABSENCE_DAYS = DAYS_BETWEEN(IV_START_DATE, IV_END_DATE) + 1

VALID = 'Y'ERROR_MESSAGE = 'xx'

IF (TOTAL_ABSENCE_DAYS + NEW_ABSENCE_DAYS) > 1 THEN