Problem while using the Post Record Trigger at the block level [message #306734] |
Sun, 16 March 2008 06:45 |
chandra babu
Messages: 4 Registered: August 2007
|
Junior Member |
|
|
Hi,
I am facing a problem while using the "POST RECORD" Trigger at the block level.
Purpose: I am developing a custom form for PO Receiving. It is a multiple record block. One has to select some lines in the block and press the button called "RECEIVE".
If in this lines, if it is a LOT CONTROLED Item, one has to enter lot information. With out entering, one could not even check the other lines.
I have written the below code in the POST Trigger.
IF ( :DETAIL_BLOCK.lot_control_code = 2) THEN
if(:detail_block.line_chkbox = 'Y') then
declare
t_quantity number;
begin
select quantity into t_quantity from XXCAVIUM_PO_RECEIPT_LOTS
where line_location_id = :detail_block.line_location_id;
if (t_quantity != :detail_block.qtytoreceive) then
fnd_message.set_string('Lot Information missing');
fnd_message.show;
end if;
exception
when no_data_found then
fnd_message.set_string('3Lot Information missing');
fnd_message.show;
raise form_trigger_failure;
end;
--null;
end if;
end if;
Problem:
--------
It is not allowing even to press the "LOT Button". If the this button another window will open and i have to enter the information there.
Can any one please suggest me a relavant trigger that i have to use.
Please suggest me if i have to use anyother trigger.
Thanks,
Chandra
|
|
|
|
|
|