51: open get_fnd_email (p_user_name);
52: fetch get_fnd_email into x_email_address;
53: if (get_fnd_email%NOTFOUND) then
54: x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';
55: fnd_message.set_name('FND', x_message_name);
56: x_message_data := fnd_message.get;
57: else
58: if x_email_address is null then
59: -- if email is still null then get it from tca
52: fetch get_fnd_email into x_email_address;
53: if (get_fnd_email%NOTFOUND) then
54: x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';
55: fnd_message.set_name('FND', x_message_name);
56: x_message_data := fnd_message.get;
57: else
58: if x_email_address is null then
59: -- if email is still null then get it from tca
60: -- check if there is a valid party email
103: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
104: 'fnd.plsql.UMXVUPWB.ForgotPwd',
105: 'Username cannot be found with userid (' || p_user_id || ')');
106: end if;
107: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');
108: raise_application_error ('-20000', fnd_message.get);
109: end if;
110: close get_username_from_userid;
111:
104: 'fnd.plsql.UMXVUPWB.ForgotPwd',
105: 'Username cannot be found with userid (' || p_user_id || ')');
106: end if;
107: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');
108: raise_application_error ('-20000', fnd_message.get);
109: end if;
110: close get_username_from_userid;
111:
112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
149:
150: -- Get username from user id if username is null
151: if (fnd_web_sec.validate_password (p_username, p_password) = 'N') then
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: x_message_data := fnd_message.get ();
154: else
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: end if;
157:
272: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
273: 'fnd.plsql.UMXVUPWB.ForgotPwd',
274: 'Could not generated password automatically which satisfies validation requirements.');
275: end if;
276: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');
277: raise_application_error ('-20000', fnd_message.get);
278: END IF;
279:
280: -- end of code for validating username
273: 'fnd.plsql.UMXVUPWB.ForgotPwd',
274: 'Could not generated password automatically which satisfies validation requirements.');
275: end if;
276: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');
277: raise_application_error ('-20000', fnd_message.get);
278: END IF;
279:
280: -- end of code for validating username
281:
600: -- validate required fields
601: -- validate user name
602: if l_user_name is NULL then
603: x_message_name := 'UMX_FORGOT_PWD_NULL_USER';
604: fnd_message.set_name('FND', x_message_name);
605: x_message_data := fnd_message.get;
606: else
607: if FND_SSO_Manager.isPasswordChangeable (l_user_name) THEN
608: get_email_address (l_user_name, l_role_name, l_email_address,
601: -- validate user name
602: if l_user_name is NULL then
603: x_message_name := 'UMX_FORGOT_PWD_NULL_USER';
604: fnd_message.set_name('FND', x_message_name);
605: x_message_data := fnd_message.get;
606: else
607: if FND_SSO_Manager.isPasswordChangeable (l_user_name) THEN
608: get_email_address (l_user_name, l_role_name, l_email_address,
609: l_notification_preference, x_message_name,
624: -- Not error, return notified message.
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626: x_message_name := 'UMX_FORGOT_PWD_NOTIFY';
627: end if;
628: fnd_message.set_name('FND', x_message_name);
629: x_message_data := fnd_message.get;
630: else -- email address is null
631: if (p_report_no_email_error = 'Y') then
632: -- At the moment, only forgot password will require to raise
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626: x_message_name := 'UMX_FORGOT_PWD_NOTIFY';
627: end if;
628: fnd_message.set_name('FND', x_message_name);
629: x_message_data := fnd_message.get;
630: else -- email address is null
631: if (p_report_no_email_error = 'Y') then
632: -- At the moment, only forgot password will require to raise
633: -- error message if email address is missing.
631: if (p_report_no_email_error = 'Y') then
632: -- At the moment, only forgot password will require to raise
633: -- error message if email address is missing.
634: x_message_name := 'UMX_FORGOT_PWD_NULL_EMAIL';
635: fnd_message.set_name ('FND', x_message_name);
636: x_message_data := fnd_message.get;
637: else
638: -- Reset the password without starting a workflow
639: l_password := p_password;
632: -- At the moment, only forgot password will require to raise
633: -- error message if email address is missing.
634: x_message_name := 'UMX_FORGOT_PWD_NULL_EMAIL';
635: fnd_message.set_name ('FND', x_message_name);
636: x_message_data := fnd_message.get;
637: else
638: -- Reset the password without starting a workflow
639: l_password := p_password;
640: SetPassword (p_username => l_user_name,
660: -- owa_util.redirect_url(l_external_password_site);th_mode = 'EXTERNAL' then
661: */
662:
663: x_message_name := 'UMX_FORGOT_PWD_EXTERNAL';
664: fnd_message.set_name('FND', x_message_name);
665: x_message_data := fnd_message.get;
666:
667: end if;
668: end if;
661: */
662:
663: x_message_name := 'UMX_FORGOT_PWD_EXTERNAL';
664: fnd_message.set_name('FND', x_message_name);
665: x_message_data := fnd_message.get;
666:
667: end if;
668: end if;
669:
678: when FND_SSO_MANAGER.userNotFound then
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: --x_message_name := 'UMX_FORGOT_PWD_UNEXP_ERR_MSG';
681: x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';
682: fnd_message.set_name('FND', x_message_name);
683: x_message_data := fnd_message.get;
684:
685: END ResetPwdPvt;
686:
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: --x_message_name := 'UMX_FORGOT_PWD_UNEXP_ERR_MSG';
681: x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';
682: fnd_message.set_name('FND', x_message_name);
683: x_message_data := fnd_message.get;
684:
685: END ResetPwdPvt;
686:
687: