Home » Developer & Programmer » Forms » Problem while using the Post Record Trigger at the block level (orale apps 11.5.10.2)
Problem while using the Post Record Trigger at the block level [message #306734] Sun, 16 March 2008 06:45 Go to next message
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
Re: Problem while using the Post Record Trigger at the block level [message #307460 is a reply to message #306734] Tue, 18 March 2008 23:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Problem while using the Post Record Trigger at the block level [message #307963 is a reply to message #307460] Thu, 20 March 2008 10:29 Go to previous messageGo to next message
chandra babu
Messages: 4
Registered: August 2007
Junior Member

hi David,

i could not solve the problem... Some how i am not able to understand which trigger i have to use.

my doubt..
------
1.whether i have to use some trigger for this problem at the block level or item level..

Could you help me in this..

Thanks,
Chandra
Re: Problem while using the Post Record Trigger at the block level [message #308910 is a reply to message #307963] Tue, 25 March 2008 22:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is this a homegrown application or are you using Oracle's "Fusion Apps & E-Business Suite"?

Have you tried placing the code in a 'when-button-pressed' trigger?

David
Previous Topic: Get Data thru Serial Port
Next Topic: array on forms
Goto Forum:
  


Current Time: Thu Nov 14 06:05:05 CST 2024