Avoiding messages in forms [message #428349] |
Wed, 28 October 2009 00:55 |
|
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
|
|
|
|
|