Update on PLSQL validation


At the flexfields presentation at UKOUG, I promised an update on the PLSQL validation.

It turns out, that the only problem was a missing ” at the end of the function. Here is the code for the function: 


FND PLSQL ” declare

v_value varchar2(10) := :!value ;

v_num number;



  if mod(v_num,2)!=0 then


  end if;


   when others then


     fnd_message.set_token(‘MESSAGE’,’This is not a valid number’);


end; “


So, use only the validate event:


And the parameter will validate correctly:

Good luck on your own experiments!


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.