HR_OBJECTIVES_API.create_Objective() returns with Exception "NO_DATE_FOUND"..
Following is the code that i have used to create an Objective for an Employee (Appraisee). Any one please suggest whats wrong with this code ? I am using EBS r12.1.3
Declare
V_VALIDATE BOOLEAN ;
V_EFFECTIVE_DATE DATE := Trunc(Sysdate) ;
V_BUSINESS_GROUP_ID NUMBER := 5264 ;
V_NAME VARCHAR2(200) := 'Core_Objective_001-API' ;
V_START_DATE DATE := Trunc(Sysdate) ;
V_OWNING_PERSON_ID NUMBER := 6043 ;
V_TARGET_DATE DATE := TO_DATE('31-Jan-2014') ;
V_ACHIEVEMENT_DATE DATE := NULL ;
V_DETAIL VARCHAR2(200) := 'JD Details... JD Details... JD Details... JD Details... ' ;
V_COMMENTS VARCHAR2(200) := 'Entry thru API ..' ;
V_SUCCESS_CRITERIA VARCHAR2(200) := NULL ;