| 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
