Re: FORMS 4.5: WHEN-VALIDATE-ITEM TRIGGER

Not sure what is causing this error but you may want to try this to accomplish your task.

   select cust_id into local_cust_id

     from my_table
     where cust_id = :my_block.cust_id;


   -- if I found an existing customer then output message


     MESSAGE ('Customer already exists');
     RAISE form_trigger_failure;
   EXCEPTION
     When no_data_found THEN NULL;

• THIS IS THE CONDITION YOU REALLY WANT!