Link to home
Start Free TrialLog in
Avatar of chalie001
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
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;

Open in new window


am in jdeveloper 11.1.1.9.0
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

It is just a tip: maybe it can be done in Validation Rules or Custom Properties of item.
ASKER CERTIFIED SOLUTION
Avatar of chalie001
chalie001

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chalie001
chalie001

ASKER

correct