Oracle Forms

Morning folks. Hope all is well.

Have a situation with a When-Validate_item trigger. I am using Forms 6i. I am encountering the When-Validate-Item trigger multiple times (I encounter a message) even though I have issued a Form_Trigger_Failure. Here is some code:

-- When-Validate-Item trigger
get_student_name;
get_student_payment_info;

The message is actually in the get_student_payment_info program unit. However, by putting a dummy message in the When-Validate-Item trigger, I noticed that the WVI trigger is being encountered numerous time and thus the procedure get_student_payment_info is being called numerous times and thus the message.

I need to mention that there is another Item level trigger and its in KEY-NEXT-ITEM which does a series of Go-Block/Execute_Query to other blocks in the form.

So, I commented out the Go_Block/Execute Query lines and of course the Message only shows once. Is there a way to not call the KEY-NEXT-ITEM if there is a Form Trigger Failure in the When-Validate-Item?

Any help is appreciated.

For some bizzare reason, I cannot seem to put the code for the cursor

procedure get_student_payment_info is
  v_chq_status   varchar2(10);
 
  -- Cursor Declaration Here

begin

  open cur_student_info;
  fetch cur_student_info into :blk_chq.chq_date, :blk_chq.chq_amt, v_chq_status;
  if cur_student_info%NOTFOUND then
    display_alert_message('Cheque Info Not Found', 'A');
    close cur_student_info;
    raise form_trigger_failure;
  end if;
  close cur_student_info;

  ....

exception   
    when form_trigger_failure then
      raise form_trigger_failure;
    when others then
      raise form_trigger_failure;
end;

Edited by: RDonASnowyDay on May 3, 2010 9:43 AM

Edited by: RDonASnowyDay on May 3, 2010 9:43 AM

Edited by: RDonASnowyDay on May 3, 2010 9:44 AM

Edited by: RDonASnowyDay on May 3, 2010 9:53 AM

Edited by: RDonASnowyDay on May 3, 2010 10:01 AM