Employee should not apply holiday for the same day

Create Message
Setup and Maintenance
Tasks
Search
Manage Messages
Message Name: ABC_RESTR_SAME_DAY_LEAVE_MSG
Application: Absence Management
Module: Global Human Resources
Short Text: You cannot apply for Holiday leave on the same day
Click on Save and Close
Create Fast Formula
My Client Groups
Fast Formulas
Formula Name: ABC_RESTRICT_SAME_DAY_LEAVE_FF
Type: Global Absence Entry Validation
Legislative Data Group: GB Legislative Data Group

/******************************************************************************FORMULA NAME: APC_RESTRICT_SAME_DAY_LEAVE_FFFORMULA TYPE: Global Absence Entry ValidationDESCRIPTION: This formula returns restrict applying the same-day Holiday leaveChange History:Name Date Comments----------------------------------------------*******************************************************************************/DEFAULT FOR GLOBAL_PAY_INTERFACE_EXTRACTION_DATE is ' '/*================ FORMULA SECTION BEGIN =======================*//*==============INPUTS SECTION BEGIN================*/INPUTS ARE iv_start_date (date),iv_end_date (date),IV_TOTALDURATIONVALID = 'Y'ERROR_MESSAGE = ' 'CUR_SYS_DATE = GLOBAL_PAY_INTERFACE_EXTRACTION_DATEsys_date= to_date(CUR_SYS_DATE,'YYYYMMDD')/*==============INPUTS SECTION BEGIN================*/IF(trunc(iv_start_date) = trunc(sys_date))THEN  (VALID = 'N' ERROR_MESSAGE = 'ABC_RESTR_SAME_DAY_LEAVE_MSG' /* Restrict applying same day Holiday leave*/RETURN VALID,ERROR_MESSAGE)
/*================ FORMULA SECTION END =======================*/return VALID,ERROR_MESSAGE 

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.