I have a 6i form with a button that performs a GO_BLOCK statement to navigate to another block. When omitting a required field before pressing the button, Forms detects this but the error message seems incomplete:
'Call to procedure "&P1" failed'
I can circumvent this by preceding the GO_BLOCK statement by:
VALIDATE('RECORD_SCOPE');
IF NOT FORMS_SUCCESS THEN
RAISE FORM_TRIGGER_FAILURE;
END IF;
In that case the correct message 'FRM-40202 Field must be entered' is raised,
however, the cursor is not placed in the omitted required field anymore, which is
confusing for the user.
Questions:
- Why is the &P1 parameter not substituted ?
- In 2nd case, why is the cursor not automatically positioned in the omitted field ?