Hi,
My requirement is to force the user to change the password if last password change is greater then or equal to 90 days.
I am trying to achieve this by doing this in Home page --> on Load - Before Header process in I am trying to pop up a message saying "Password expired Please change it immediately"
Declare
V_days number;
Begin
:P1_No_Of_Days := v_days;
IF v_days >= 60 then
dbms_output.put_line('change');
--APEX_APPLICATION.G_PRINT_SUCCESS_MESSAGE := 'OHNO';
HTP.p ('<script type="text/javascript">');
HTP.p ( 'alert(''Your Password expired Pleae change immidately'
|| '.\n'
-- || 'This is an alert generated by a PL/SQL block \n'
|| 'days'');'
);
HTP.p ('</script>');
owa_util.redirect_url('f?p=&APP_ID.:2:&APP_SESSION.');
apex_application.stop_apex_engine;
end if;
END;
In this coding i can able to navigate to Page 2 but not able to display message "Your Password expired Pleae change immidately" How can i do this.
Please Help me out.
Thanks in advance
Bhushan