Commit_form not working. Form status not changed [message #600728] |
Mon, 11 November 2013 12:58 |
|
amaravaram
Messages: 4 Registered: November 2013 Location: California
|
Junior Member |
|
|
I am developing a form where there is an item "STATUS" which is not Visible. I am populating a value in this item based on a value in different item which is visible in the canvas.Please see the code below.
STATUS is a databse item and it needs to be updated. Even after populating updated value in STATUS the form status is not changed and the form is not committed.
WHEN_VALIDATE-ITEM-TRIGGER
BEGIN
-- Validate status
if :B_CONTROL_BLOCK.TI_NEW_STATUS is NOT NULL then
if :B_CONTROL_BLOCK.TI_NEW_STATUS = 'Approved' then
:B_CONTROL_BLOCK.STATUS := 'A';
else
emessage('Please enter a valid status');
raise FORM_TRIGGER_FAILURE;
end if;
end if;
EXCEPTION
when FORM_TRIGGER_FAILURE then
raise;
when OTHERS then
raise FORM_TRIGGER_FAILURE;
END;
Please let me know what to do. Your help is much appreciated.
Thanks
|
|
|
|
|
|
|
|
|
|