217: AND fu.user_name = p_user_name;
218:
219: begin
220:
221: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
222: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
223: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
224: 'p_user_name: ' || p_user_name);
225: end if;
218:
219: begin
220:
221: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
222: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
223: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
224: 'p_user_name: ' || p_user_name);
225: end if;
226:
250: end if;
251: close get_fnd_email;
252: end if;
253:
254: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
255: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
256: 'fnd.plsql.UMXVUPWB.get_email_address.end',
257: 'x_role_name: ' || x_role_name ||
258: ' | x_email_address: ' || x_email_address ||
251: close get_fnd_email;
252: end if;
253:
254: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
255: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
256: 'fnd.plsql.UMXVUPWB.get_email_address.end',
257: 'x_role_name: ' || x_role_name ||
258: ' | x_email_address: ' || x_email_address ||
259: ' | x_message_name: ' || x_message_name);
289:
290:
291: begin
292:
293: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
294: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
295: 'fnd.plsql.UMXVUPWB.find_user_w_email.begin',
296: 'p_email: ' || p_email);
297: end if;
290:
291: begin
292:
293: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
294: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
295: 'fnd.plsql.UMXVUPWB.find_user_w_email.begin',
296: 'p_email: ' || p_email);
297: end if;
298:
325: WF_DIRECTORY.GetRoleInfo (x_user_name, l_role_display_name, l_email_address,
326: x_notification_preference, l_language, l_territory);
327: end if;
328:
329: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
330: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
331: 'fnd.plsql.UMXVUPWB.find_user_w_email.end',
332: 'x_role_name: ' || x_role_name ||
333: ' | x_user_name: ' || x_user_name ||
326: x_notification_preference, l_language, l_territory);
327: end if;
328:
329: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
330: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
331: 'fnd.plsql.UMXVUPWB.find_user_w_email.end',
332: 'x_role_name: ' || x_role_name ||
333: ' | x_user_name: ' || x_user_name ||
334: ' | x_message_name: ' || x_message_name);
363:
364:
365: begin
366:
367: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
368: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
369: 'fnd.plsql.UMXVUPWB.find_users_w_email.begin',
370: 'p_email: ' || p_email);
371: end if;
364:
365: begin
366:
367: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
368: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
369: 'fnd.plsql.UMXVUPWB.find_users_w_email.begin',
370: 'p_email: ' || p_email);
371: end if;
372:
391: i := i + 1;
392: end loop;
393: end if;
394:
395: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
396: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
397: 'fnd.plsql.UMXVUPWB.find_users_w_email.end',
398: ' | l_user_name: ' || l_user_name );
399: end if;
392: end loop;
393: end if;
394:
395: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
396: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
397: 'fnd.plsql.UMXVUPWB.find_users_w_email.end',
398: ' | l_user_name: ' || l_user_name );
399: end if;
400:
410: p_notification_preference in varchar2,
411: x_itemkey out nocopy varchar2) is
412: begin
413:
414: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
416: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',
417: 'p_user_name: ' || p_user_name ||
418: ' | p_email_address: ' || p_email_address ||
411: x_itemkey out nocopy varchar2) is
412: begin
413:
414: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
416: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',
417: 'p_user_name: ' || p_user_name ||
418: ' | p_email_address: ' || p_email_address ||
419: ' | p_role_name: ' || p_role_name );
463:
464: wf_engine.StartProcess(itemtype => g_itemtype,
465: itemkey => x_itemkey);
466:
467: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
468: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
469: 'fnd.plsql.UMXVUPWB.start_workflow.end',
470: 'x_itemkey: ' || x_itemkey);
471: end if;
464: wf_engine.StartProcess(itemtype => g_itemtype,
465: itemkey => x_itemkey);
466:
467: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
468: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
469: 'fnd.plsql.UMXVUPWB.start_workflow.end',
470: 'x_itemkey: ' || x_itemkey);
471: end if;
472:
493:
494:
495: begin
496:
497: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
498: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
499: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
500: 'p_username: ' || p_username );
501: end if;
494:
495: begin
496:
497: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
498: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
499: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
500: 'p_username: ' || p_username );
501: end if;
502:
537: else -- cannot change password for this user
538: x_message_name := 'UMX_LOGIN_HELP_PWD_EXTERNAL';
539: end if;
540:
541: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
542: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
543: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
544: 'x_return_status: ' || x_return_status ||
545: ' | x_message_name: ' || x_message_name);
538: x_message_name := 'UMX_LOGIN_HELP_PWD_EXTERNAL';
539: end if;
540:
541: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
542: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
543: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
544: 'x_return_status: ' || x_return_status ||
545: ' | x_message_name: ' || x_message_name);
546: end if;
557: x_return_status out NOCOPY varchar2,
558: x_message_name out NOCOPY varchar2) is
559: begin
560:
561: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
562: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
563: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
564: 'p_username: ' || p_username
565: );
558: x_message_name out NOCOPY varchar2) is
559: begin
560:
561: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
562: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
563: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
564: 'p_username: ' || p_username
565: );
566: end if;
570: x_return_status => x_return_status,
571: x_message_name => x_message_name);
572:
573:
574: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
575: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
576: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
577: 'x_return_status: ' || x_return_status ||
578: ' | x_message_name: ' || x_message_name);
571: x_message_name => x_message_name);
572:
573:
574: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
575: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
576: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
577: 'x_return_status: ' || x_return_status ||
578: ' | x_message_name: ' || x_message_name);
579: end if;
604: l_too_many_prev_reqs boolean := false;
605:
606: begin
607:
608: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
609: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
610: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
611: 'p_email: ' || p_email );
612: end if;
605:
606: begin
607:
608: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
609: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
610: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
611: 'p_email: ' || p_email );
612: end if;
613:
659: END LOOP; --End of UserList Loop
660: END IF;
661:
662:
663: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
664: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
665: 'fnd.plsql.UMXLHLPB.ForgottenUnamePvt.end',
666: 'x_return_status: ' || x_return_status ||
667: ' | x_message_name: ' || x_message_name);
660: END IF;
661:
662:
663: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
664: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
665: 'fnd.plsql.UMXLHLPB.ForgottenUnamePvt.end',
666: 'x_return_status: ' || x_return_status ||
667: ' | x_message_name: ' || x_message_name);
668: end if;
679: x_return_status out NOCOPY varchar2,
680: x_message_name out NOCOPY varchar2) is
681: begin
682:
683: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
684: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
685: 'fnd.plsql.UMXVUPWB.ForgottenUname.begin',
686: 'p_email: ' || p_email
687: );
680: x_message_name out NOCOPY varchar2) is
681: begin
682:
683: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
684: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
685: 'fnd.plsql.UMXVUPWB.ForgottenUname.begin',
686: 'p_email: ' || p_email
687: );
688: end if;
692: x_return_status => x_return_status,
693: x_message_name => x_message_name);
694:
695:
696: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
697: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
698: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
699: 'x_return_status: ' || x_return_status ||
700: ' | x_message_name: ' || x_message_name);
693: x_message_name => x_message_name);
694:
695:
696: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
697: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
698: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
699: 'x_return_status: ' || x_return_status ||
700: ' | x_message_name: ' || x_message_name);
701: end if;
710: ascii_offset int := 65;
711:
712: begin
713:
714: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
715: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
716: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.begin', '');
717: end if;
718:
711:
712: begin
713:
714: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
715: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
716: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.begin', '');
717: end if;
718:
719:
730:
731: -- terminate the random number generator
732: --dbms_random.terminate;
733:
734: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
735: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
736: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.end',
737: 'x_auth_key: ' || x_auth_key);
738: end if;
731: -- terminate the random number generator
732: --dbms_random.terminate;
733:
734: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
735: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
736: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.end',
737: 'x_auth_key: ' || x_auth_key);
738: end if;
739:
805:
806:
807: begin
808:
809: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
811: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.begin', '');
812: end if;
813:
806:
807: begin
808:
809: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
811: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.begin', '');
812: end if;
813:
814: if (funcmode = 'RUN') then
852: end if;
853:
854: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
855:
856: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
857: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
858: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.end',
859: 'l_url: ' || l_url);
860: end if;
853:
854: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
855:
856: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
857: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
858: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.end',
859: 'l_url: ' || l_url);
860: end if;
861:
876: resultout in out NOCOPY varchar2) is
877: l_url varchar2(32000);
878: begin
879:
880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
882: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.begin', '');
883: end if;
884:
877: l_url varchar2(32000);
878: begin
879:
880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
882: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.begin', '');
883: end if;
884:
885: if (funcmode = 'RUN') then
893:
894: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
895:
896:
897: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
898: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
899: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.end',
900: 'l_url: ' || l_url);
901: end if;
894: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
895:
896:
897: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
898: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
899: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.end',
900: 'l_url: ' || l_url);
901: end if;
902:
910: resultout in out NOCOPY varchar2) is
911: l_user_name fnd_user.user_name%type;
912: begin
913:
914: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
915: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
916: 'fnd.plsql.UMXVUPWB.DisableAccount.begin', '');
917: end if;
918:
911: l_user_name fnd_user.user_name%type;
912: begin
913:
914: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
915: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
916: 'fnd.plsql.UMXVUPWB.DisableAccount.begin', '');
917: end if;
918:
919: if (funcmode = 'RUN') then
929:
930: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
931:
932:
933: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
934: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
935: 'fnd.plsql.UMXVUPWB.DisableAccount.end',
936: 'l_user_name: ' || l_user_name);
937: end if;
930: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
931:
932:
933: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
934: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
935: 'fnd.plsql.UMXVUPWB.DisableAccount.end',
936: 'l_user_name: ' || l_user_name);
937: end if;
938:
953: l_item_status varchar2(8);
954: l_item_result varchar2(30);
955:
956: BEGIN
957: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
958: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
959: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
960: ' | p_authkey: ' || p_authkey ||
961: ' | p_itemkey: ' || p_itemkey );
954: l_item_result varchar2(30);
955:
956: BEGIN
957: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
958: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
959: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
960: ' | p_authkey: ' || p_authkey ||
961: ' | p_itemkey: ' || p_itemkey );
962: end if;
990: return;
991: end if;
992:
993:
994: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
995: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
996: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
997: 'x_return_status: ' || x_return_status ||
998: 'x_message_name: ' || x_message_name );
991: end if;
992:
993:
994: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
995: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
996: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
997: 'x_return_status: ' || x_return_status ||
998: 'x_message_name: ' || x_message_name );
999: end if;
1005: if ( x_message_name is null ) then
1006: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1007: end if;
1008:
1009: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1010: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1011: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1012: 'x_return_status: ' || x_return_status ||
1013: 'x_message_name: ' || x_message_name ||
1006: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1007: end if;
1008:
1009: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1010: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1011: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1012: 'x_return_status: ' || x_return_status ||
1013: 'x_message_name: ' || x_message_name ||
1014: fnd_message.get );
1033: l_item_status varchar2(8);
1034: l_item_result varchar2(30);
1035:
1036: BEGIN
1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1038: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1039: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
1040: 'p_username: ' || p_username ||
1041: ' | p_authkey: ' || p_authkey ||
1034: l_item_result varchar2(30);
1035:
1036: BEGIN
1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1038: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1039: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
1040: 'p_username: ' || p_username ||
1041: ' | p_authkey: ' || p_authkey ||
1042: ' | p_itemkey: ' || p_itemkey );
1072:
1073: if ( l_user_name <> p_username ) then
1074: x_return_status := 'E';
1075: x_message_name := 'UMX_RESET_PWD2_INVALID_UNAME';
1076: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1077: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1078: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1079: 'failed');
1080: end if;
1073: if ( l_user_name <> p_username ) then
1074: x_return_status := 'E';
1075: x_message_name := 'UMX_RESET_PWD2_INVALID_UNAME';
1076: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1077: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1078: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1079: 'failed');
1080: end if;
1081:
1090: x_message_name := 'UMX_LOGIN_HELP_PWD_EXTERNAL';
1091: return;
1092: end if;
1093:
1094: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1095: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1096: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
1097: 'x_return_status: ' || x_return_status ||
1098: 'x_message_name: ' || x_message_name );
1091: return;
1092: end if;
1093:
1094: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1095: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1096: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
1097: 'x_return_status: ' || x_return_status ||
1098: 'x_message_name: ' || x_message_name );
1099: end if;
1105: if ( x_message_name is null ) then
1106: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1107: end if;
1108:
1109: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1110: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1111: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1112: 'x_return_status: ' || x_return_status ||
1113: 'x_message_name: ' || x_message_name ||
1106: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1107: end if;
1108:
1109: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1110: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1111: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1112: 'x_return_status: ' || x_return_status ||
1113: 'x_message_name: ' || x_message_name ||
1114: fnd_message.get );
1125: IS
1126: l_result varchar2(10);
1127: begin
1128:
1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1131: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.begin',
1132: 'p_username: ' || p_username ||' | x_password: ' || x_password);
1133: end if;
1126: l_result varchar2(10);
1127: begin
1128:
1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1131: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.begin',
1132: 'p_username: ' || p_username ||' | x_password: ' || x_password);
1133: end if;
1134:
1137:
1138: IF ( l_result <> 'Y' ) THEN
1139: -- Throw exception as even though generated password 100 times, but
1140: -- cannot pass validation criteria
1141: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1142: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1143: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1144: 'Validate Password failed.');
1145: end if;
1138: IF ( l_result <> 'Y' ) THEN
1139: -- Throw exception as even though generated password 100 times, but
1140: -- cannot pass validation criteria
1141: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1142: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1143: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1144: 'Validate Password failed.');
1145: end if;
1146: x_return_status := 'E';
1146: x_return_status := 'E';
1147: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';
1148: x_message_data := fnd_message.get;
1149: ELSE
1150: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1151: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1152: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1153: 'Validate Password success.');
1154: end if;
1147: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';
1148: x_message_data := fnd_message.get;
1149: ELSE
1150: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1151: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1152: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1153: 'Validate Password success.');
1154: end if;
1155: x_return_status := 'S';
1154: end if;
1155: x_return_status := 'S';
1156: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';
1157: END IF;
1158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1160: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.end',
1161: 'x_password: ' || x_password);
1162: end if;
1155: x_return_status := 'S';
1156: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';
1157: END IF;
1158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1160: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.end',
1161: 'x_password: ' || x_password);
1162: end if;
1163:
1209: l_item_status varchar2(8);
1210: l_item_result varchar2(30);
1211:
1212: begin
1213: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.begin',
1216: 'p_username: ' || p_username || ' | p_password: ' || p_password);
1217: end if;
1210: l_item_result varchar2(30);
1211:
1212: begin
1213: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.begin',
1216: 'p_username: ' || p_username || ' | p_password: ' || p_password);
1217: end if;
1218:
1226: x_return_status => x_return_status,
1227: x_message_name => x_message_name );
1228:
1229: if ( x_return_status <> 'S' ) then
1230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1231: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1232: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1233: 'failed');
1234: end if;
1227: x_message_name => x_message_name );
1228:
1229: if ( x_return_status <> 'S' ) then
1230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1231: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1232: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1233: 'failed');
1234: end if;
1235: return;
1254: EXCEPTION
1255: when others then
1256: x_return_status := 'E';
1257: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1258: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1259: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1261: 'x_no_attempts: ' || x_no_attempts ||
1262: 'x_return_status: ' || x_return_status ||
1255: when others then
1256: x_return_status := 'E';
1257: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1258: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1259: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1261: 'x_no_attempts: ' || x_no_attempts ||
1262: 'x_return_status: ' || x_return_status ||
1263: ' | x_message_name: ' || x_message_name );
1264: end if;
1265: END;
1266: end if;
1267:
1268: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1269: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1270: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.end',
1271: 'x_return_status: ' || x_return_status ||
1272: ' | x_message_name: ' || x_message_name );
1265: END;
1266: end if;
1267:
1268: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1269: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1270: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.end',
1271: 'x_return_status: ' || x_return_status ||
1272: ' | x_message_name: ' || x_message_name );
1273: end if;
1290: x_message_data out NOCOPY varchar2) is
1291:
1292: begin
1293:
1294: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1295: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1296: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.begin',
1297: 'p_username: ' || p_username ||
1298: ' | p_password: ' || p_password);
1291:
1292: begin
1293:
1294: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1295: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1296: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.begin',
1297: 'p_username: ' || p_username ||
1298: ' | p_password: ' || p_password);
1299: end if;
1312: x_return_status => x_return_status,
1313: x_message_name => x_message_name,
1314: x_message_data => x_message_data);
1315:
1316: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1317: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1318: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.end',
1319: 'x_return_status: ' || x_return_status ||
1320: ' | x_message_name: ' || x_message_name);
1313: x_message_name => x_message_name,
1314: x_message_data => x_message_data);
1315:
1316: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1317: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1318: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.end',
1319: 'x_return_status: ' || x_return_status ||
1320: ' | x_message_name: ' || x_message_name);
1321: end if;
1333: l_orig_system_id wf_local_roles.orig_system_id%type;
1334: begin
1335:
1336: x_return_status := 'S';
1337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1339: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.begin',
1340: ' p_itemkey: ' || p_itemKey );
1341: end if;
1334: begin
1335:
1336: x_return_status := 'S';
1337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1339: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.begin',
1340: ' p_itemkey: ' || p_itemKey );
1341: end if;
1342:
1359: cascade => true);
1360:
1361: x_return_status := 'S';
1362:
1363: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1364: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1365: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.end',
1366: 'x_return_status: ' || x_return_status ||
1367: ' | x_message_name: ' || x_message_name);
1360:
1361: x_return_status := 'S';
1362:
1363: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1364: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1365: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.end',
1366: 'x_return_status: ' || x_return_status ||
1367: ' | x_message_name: ' || x_message_name);
1368: end if;