Home » Developer & Programmer » Forms » Avoiding messages in forms (Forms 6i)
Avoiding messages in forms [message #428349] Wed, 28 October 2009 00:55 Go to next message
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 Go to previous messageGo to next message
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
Re: Avoiding messages in forms [message #428415 is a reply to message #428392] Wed, 28 October 2009 04:37 Go to previous messageGo to next message
vibhavari
Messages: 20
Registered: October 2009
Junior Member
Use :system.message_level=20;

Re: Avoiding messages in forms [message #431343 is a reply to message #428349] Mon, 16 November 2009 23:21 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Put 'M_COMM_DEL' into a non-database block.

David
Previous Topic: open window media player (merged)
Next Topic: Finding location of directory on c:\ drive
Goto Forum:
  


Current Time: Thu Nov 14 05:49:29 CST 2024