0 Replies Latest reply on Sep 21, 2015 7:28 AM by user9371478

    Special Value set validation for Date parameters

    user9371478

      Hi All,

       

      I have 2 date parameters in one of my concurrent program- Start Date and End Date. Need to add validation that End Date should not less than Start Date, I know this can be done by setting Range as low-High but this gives standard message as "Please choose a low value that is lower than the high value" which needs to be changed to "End Date should be greater than Start Date.".

       

      For this I have created one Special Value set for End Date and added below code in Validation Type

       

      FND PLSQL " DECLARE

      l_value date := :!value ;

      l_from   date := ':$FLEX$.FND_STANDARD_DATE_REQUIRED';

        BEGIN

      IF l_value < l_from THEN

      fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;

      fnd_message.set_token( 'MESSAGE', 'End Date should be greater than Start Date.' );

      fnd_message.raise_error ;

      END IF;

      END;"

       

      This gives below error when I add any date in this parameter

      "APP-FND-00006: User exit# is not defined

      Please correct the user exit in your form, or create the indicated user exit"

       

      Can anyone let me know how to solve this issue.

       

      Thanks