Code:
Select username,password from user_password_table into uname,pwd;
if upper(uname)=upper(:txt_username) and upper(pwd)=upper(:txt_password) then
   call_form (your_other_form_name)
else
   raise form_trigger_failure;
end if;