Commit_form not working. Form status not changed [message #600728] |
Mon, 11 November 2013 12:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8548b5b8544d95746a4430508a2b1f94?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|
|