OraFAQ Forum: Forms » Avoiding messages in forms

Home » Developer & Programmer » Forms » Avoiding messages in forms (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Avoiding messages in forms [message #428349]

Wed, 28 October 2009 00:55

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I am inserting records using a procedure in forms while inserting every time i am getting record saved messages how to avoid it...the code is below and is written on when button pressed.

IF :COMP_LOCN = 'L' THEN
  OPEN CS_LOCN;
  LOOP
    FETCH CS_LOCN
       INTO L_RO_LOCN_CODE,
      L_RO_ITEM_CODE      ,
      L_RO_UOM_CODE       ,
      L_RO_ITEM_RORD_LVL  ,
      L_RO_ITEM_RORD_QTY  ,
      L_RO_STK_QTY;
    EXIT
  WHEN CS_LOCN%NOTFOUND;
     INSERT
       INTO AIC_TEM_REORDER_QTY
      (
        RO_LOCN_CODE    ,
        RO_ITEM_CODE    ,
        RO_UOM_CODE     ,
        RO_ITEM_RORD_LVL,
        RO_ITEM_RORD_QTY,
        RO_STK_QTY      ,
        RO_USER_ID
      )
      VALUES
      (
        L_RO_LOCN_CODE    ,
        L_RO_ITEM_CODE    ,
        L_RO_UOM_CODE     ,
        L_RO_ITEM_RORD_LVL,
        L_RO_ITEM_RORD_QTY,
        L_RO_STK_QTY      ,
        :GLOBAL.M_USER_ID
      );
  END LOOP;
  :M_COMM_DEL := 'C';
  COMMIT;
  :M_COMM_DEL := '';
  CLOSE CS_LOCN;

[Updated on: Wed, 28 October 2009 02:04] by Moderator

Report message to a moderator

Re: Avoiding messages in forms [message #428392 is a reply to message #428349]

Wed, 28 October 2009 03:39

beginnerHere
Messages: 55
Registered: October 2009

Member

use the on_message trigger, and suppress the message code that you are getting

raise your message level and ignore

don't know exactly but try that, and put:
if message_code = (your message code) then
NULL;
( or message('Your message text here'); ) (or something like that)
end if;

hope it helps

Report message to a moderator