2 Replies Latest reply: May 8, 2013 4:56 PM by ayadsufyan RSS

    can not delete record from the master block ,frm-40202 field must be entere

    ayadsufyan
      hi ,
      i have built a form which contain master and details blocks
      the problem is
      when i try to delete a record from the master block it gives me new serial for the transaction and when i try to save it, it says
      >frm-40202 field must be entered
      where this field is required and i cant save it
      although in another form when i delete from the master it gives me the previous record and it works properly

      if any one has any ideas pls help me


      thank u



      ------- the master block has a trigger when-create-recoder
      Declare
      >v_dummy number;
      Begin
      Select nvl(max(ERNT_NO),0) + 1
      >Into v_dummy
      From LM_RENT_EXPNMST
      >Where cmp_no = :LM_RENT_EXPNMST.cmp_no
      And brn_no = :LM_RENT_EXPNMST.brn_no
      >and fiscal_yr = :LM_RENT_EXPNMST.fiscal_yr;
      >:LM_RENT_EXPNMST.ERNT_NO := v_dummy;
      END;
      IF :PARAMETER.RNT_NO IS NOT NULL THEN
           :LM_RENT_EXPNMST.RNT_NO:=:PARAMETER.RNT_NO;
                :LM_RENT_EXPNMST.RNT_YR:=:PARAMETER.RNT_YR;
           :LM_RENT_EXPNMST.CUST_DESC:=:PARAMETER.RNT_ADESC;
      END IF;
      Edited by: ayadsufyan on May 8, 2013 2:03 PM