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
chalie001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Helena Markováprogrammer-analystCommented:
It is just a tip: maybe it can be done in Validation Rules or Custom Properties of item.
0
chalie001Author Commented:
i have move the form procedure to database and call tham
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chalie001Author Commented:
correct
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.