Absence Entry Validation Fast Formula Dependents on Another Leave's Accrual Balance

Requirement :
     Employee is allowed to apply for unpaid leave only when his/her Annual leave balance is 0(Zero).


STEP 1:
      Create Fast Formula as Mentioned Below 

--------------------------------------------------------------------------------------------------------------------
NAME                           : XX_GET_PLAN_BALANCE
TYPE                             : Global Absence Accrual

Legislative Data Group : Choose Your Legislation

Formula Text : 

/*************  Retrieve the accrual balance in the formula *********************/

INPUTS ARE IV_PERSON_ID,IV_TERM_ID,IV_EFF_DT (DATE)

DEFAULT FOR IV_PERSON_ID IS 0
DEFAULT FOR IV_TERM_ID IS 0
DEFAULT FOR IV_EFF_DT IS '2014/01/01' (DATE)

L_Leave_Balance = 0
L_Accrual_Plan_ID = 300000001679015 /* Accrual Plan ID */
L_Term_Id = IV_TERM_ID
L_Person_Id = IV_PERSON_ID
L_Eff_Dt = IV_EFF_DT

CHANGE_CONTEXTS(ACCRUAL_PLAN_ID = L_Accrual_Plan_ID,
HR_ASSIGNMENT_ID = L_Term_Id,
PERSON_ID = L_Person_Id,
EFFECTIVE_DATE =L_Eff_Dt )

(
  L_Leave_Balance = GET_ACCRUAL_BALANCE()
)

return L_Leave_Balance 
/****************************************************************************/

---------------------------------------------------------------------------------------------------------------------





STEP 2:
    Create Fast Formula as Mentioned Below 

---------------------------------------------------------------------------------------------------------------------
NAME                           : XX_VALIDATION_FF
TYPE                             : Global Absence Entry Validation
Legislative Data Group  : Choose Your Legislation 

Formula Text : 
/********************validation formula***********************/

INPUTS ARE IV_START_DATE(DATE),iv_end_date (date)

DEFAULT FOR IV_START_DATE IS '2014/01/01' (DATE)
DEFAULT FOR IV_END_DATE IS '4712/01/01' (DATE)

L_Acrl_Balance = 0
L_Person_Id = GET_CONTEXT(PERSON_ID,0)
L_Term_Id = GET_CONTEXT(HR_TERM_ID,0)
L_Eff_Dt = IV_START_DATE
L_occurence = 0

SET_INPUT('IV_PERSON_ID', L_Person_Id)
SET_INPUT('IV_TERM_ID', L_Term_Id)e
SET_INPUT('IV_EFF_DT', L_Eff_Dt)

EXECUTE('XX_GET_PLAN_BALANCE')

L_Acrl_Balance = GET_OUTPUT('L_Leave_Balance', 0)

IF (L_Acrl_Balance < 1) THEN
(
VALID = 'Y'
)
ELSE
(
VALID = 'N'
ERROR_MESSAGE = 'ERROR -  Current Leave Balance: '+to_text(L_Acrl_Balance)+'  You can take this type of leave only when your annual leave balance is 0(Zero) '
)

return VALID, ERROR_MESSAGE

/****************************************************************************/
---------------------------------------------------------------------------------------------------------------------



STEP 3:
     Attach Validation formula at Absence Type. 
---------------------------------------------------------------------------------------------------------------------
Absence Type > Select 'Validation Formula' 

i.e. 
As per the current requirement 

Go to UNPAID leave > Select 'XX_VALIDATION_FF' formula as validation formula.

Navigation : Absence Administration > Absence Type > Search UNPAID Leave

 NOTE:-  Make sure Absence Type and Formulas must be fall under same Legislation.

---------------------------------------------------------------------------------------------------------------------