1 Reply Latest reply: Aug 22, 2014 2:33 AM by jariola RSS

    Row remove from tabular form when validation fire (Apex 3.2)

    Vedant

      Hi Friend

       

      i have created validation on Tabular form(Apex 3.2).i ahve mention my validation code below .There is a problem if  v_net and v_amt not equal then validation executed and give error then all lines of tabular form has remove and need to add row again .

      <code>

      DECLARE

         v_net     number:=0;

         v_amt     number:=0;

      BEGIN

      select sum(net_amt) into v_net from AR_INVOICE_DTL where  INVOICE_NO=:P41_INVOICE_NO;

         FOR i IN 1 .. apex_application.g_f05.COUNT

         LOOP

               v_amt:=v_amt+apex_application.g_f05(i);

         end loop;

      if v_net=v_amt then

      return true;

      else

      return false;

      end if;

      exception when others

      then return false;

      end;

      </code>

       

      i need if validation fire then row should not be remove i don't want to add row again.

       

      How to resolve it ?

       

      Thanks