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;

begin

  v_num:=to_number(v_value);

  if mod(v_num,2)!=0 then

     fnd_message.raise_error;

  end if;

exception

   when others then

     fnd_message.set_name(‘FND’,’FND_GENERIC_MESSAGE’);

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

     fnd_message.raise_error;

end; “

 

So, use only the validate event:

 

And the parameter will validate correctly:

Good luck on your own experiments!