GO_ITEM & WHEN-VALIDATE-ITEM
Hello,
We are using Oracle forms 10g.
When an abnormal value is entered into a field in a multi record block, I need to capture the reason for the abnormality.
I have a separate block called "REASON" to capture the actual reason.
Since we can't use the go_block or go_item within when-validate-item, I have set a flag and also created a timer in my when-validate-item, when an abnormal value is entered.
On the when-timer-expired at form level, if the flag = 'Y', I'm using go_item('xxx').
After doing these, I found that navigating to a different block was causing "field must be entered" for all the "Required" column in the current block.
So I made all the "Required" field to 'No'. in the multi-record block.
When the user misses to enter one of the "Required" field, they end up getting "oracle unable to insert" etc. etc.
What's best method to handle this situation ?
Thanks in advance.
Cheers
Hari