Need to display Frm-40400 Message [message #457143] |
Fri, 21 May 2010 04:57 |
dhanasurya
Messages: 33 Registered: May 2010
|
Member |
|
|
Hi All,
I developed one form.i.e based on a view.Here i am inserting records into one custom table.So i have written code in the KEY-COMMIT trigger for inserting records into the custom table.
I have written following code in the KEY-COMMIT trigger:
----------------------------------------------
insert into xxmz_custom_tbl
(adjustment_id ,
header_id ,
line_id ,
trip_code ,
completion_date ,
inventory_item_id ,
organization_id ,
qty_estimated ,
qty_actual ,
truck_number ,)
values(LV_ADJ_ID,:xxmz_summary.sales_order_id,
:xxmz_detail.line_id,
:xxmz_summary.trip_code ,
:xxmz_summary.schedule_date ,
:xxmz_detail.inventory_item_id ,
:xxmz_summary.organization_id ,
:xxmz_detail.qty_estimated ,
:xxmz_detail.qty_actual ,
:xxmz_summary.truck_code );
STANDARD.COMMIT;
-------------------------------------------------
When i click on save it is saving records.But it does't showing
the message (frm-40400: one records applied and Saved) once the record is saved.
How can i display message(frm-40400)?
|
|
|
|
|
Re: Need to display Frm-40400 Message [message #457160 is a reply to message #457149] |
Fri, 21 May 2010 06:47 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You can't do it without message.
frm-40400 applies to forms default processing which you have overridden.
If you use custom insert code you have to have custom messages to go with it (or no message at all).
|
|
|