chalie001
asked on
key-next-trigger in adf
hi in my form I have this key-next-trigger validation how can I do this in adf
key-next-trigger in adf
key-next-trigger in adf
am in jdeveloper 11.1.1.9.0
key-next-trigger in adf
key-next-trigger in adf
DECLARE
passwd varchar2(30);
wrk_err_ind varchar2(1);
wrk_err_msg varchar2(80);
ws_user_stat varchar2(32) := Null;
BEGIN
SELECT account_status
INTO :work.scr_accnt_stat
FROM dba_users
WHERE username = :work.scr_user;
EXCEPTION
when no_data_found THEN
message('Invalid sign-on id/password; logon denied..');
raise form_trigger_failure;
END;
IF :work.scr_accnt_stat = 'OPEN' and
:work.scr_password is null then
message('Field must be entered');
raise form_trigger_failure;
END IF;
IF :work.scr_accnt_stat = 'OPEN' then
validate_pswd('G',
'dbusername',
null,
null,
passwd,
wrk_err_ind,
wrk_err_msg);
IF nvl(wrk_err_ind,'N') = 'Y' THEN
message(wrk_err_msg);
raise form_trigger_failure;
END IF;
end;
am in jdeveloper 11.1.1.9.0
It is just a tip: maybe it can be done in Validation Rules or Custom Properties of item.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
correct