33: AND fu.user_name = p_user_name;
34:
35: begin
36:
37: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
38: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
39: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
40: 'p_user_name: ' || p_user_name);
41: end if;
34:
35: begin
36:
37: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
38: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
39: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
40: 'p_user_name: ' || p_user_name);
41: end if;
42:
66: end if;
67: close get_fnd_email;
68: end if;
69:
70: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
71: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
72: 'fnd.plsql.UMXVUPWB.get_email_address.end',
73: 'x_role_name: ' || x_role_name ||
74: ' | x_email_address: ' || x_email_address ||
67: close get_fnd_email;
68: end if;
69:
70: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
71: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
72: 'fnd.plsql.UMXVUPWB.get_email_address.end',
73: 'x_role_name: ' || x_role_name ||
74: ' | x_email_address: ' || x_email_address ||
75: ' | x_message_name: ' || x_message_name ||
88: l_user_name fnd_user.user_name%type;
89:
90: begin
91:
92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
93: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
94: 'fnd.plsql.UMXVUPWB.get_username_from_userid.begin',
95: 'p_user_id: ' || p_user_id);
96: end if;
89:
90: begin
91:
92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
93: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
94: 'fnd.plsql.UMXVUPWB.get_username_from_userid.begin',
95: 'p_user_id: ' || p_user_id);
96: end if;
97:
98: open get_username_from_userid;
99: fetch get_username_from_userid into l_user_name;
100: if (get_username_from_userid%notfound) then
101: close get_username_from_userid;
102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
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;
99: fetch get_username_from_userid into l_user_name;
100: if (get_username_from_userid%notfound) then
101: close get_username_from_userid;
102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
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:
112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
113: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
114: 'fnd.plsql.UMXVUPWB.get_username_from_userid.end',
115: 'l_user_name: ' || l_user_name);
116: end if;
109: end if;
110: close get_username_from_userid;
111:
112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
113: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
114: 'fnd.plsql.UMXVUPWB.get_username_from_userid.end',
115: 'l_user_name: ' || l_user_name);
116: end if;
117:
139: x_message_data out NOCOPY varchar2) is
140:
141: BEGIN
142:
143: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
144: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
145: 'fnd.plsql.UMXVUPWB.validate_password.begin',
146: 'p_username: ' || p_username ||
147: ' | p_password: ' || p_password);
140:
141: BEGIN
142:
143: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
144: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
145: 'fnd.plsql.UMXVUPWB.validate_password.begin',
146: 'p_username: ' || p_username ||
147: ' | p_password: ' || p_password);
148: end if;
154: else
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: end if;
157:
158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
160: 'fnd.plsql.UMXVUPWB.validate_password.end',
161: 'x_return_status: ' || x_return_status ||
162: ' | x_message_data: ' || x_message_data);
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: end if;
157:
158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
160: 'fnd.plsql.UMXVUPWB.validate_password.end',
161: 'x_return_status: ' || x_return_status ||
162: ' | x_message_data: ' || x_message_data);
163: end if;
185: ascii_offset int := 65;
186:
187: begin
188:
189: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
190: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
191: 'fnd.plsql.UMXVUPWB.generate_password.begin', '');
192: end if;
193:
186:
187: begin
188:
189: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
190: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
191: 'fnd.plsql.UMXVUPWB.generate_password.begin', '');
192: end if;
193:
194: -- initialize the random number generator
199:
200: -- generate a random number to determine where to use an alphabet or a
201: -- numeric character for a given position in the password
202:
203: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
204: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
205: 'fnd.plsql.UMXVUPWB.generate_password',
206: 'l_password_len: ' || l_password_len);
207: end if;
200: -- generate a random number to determine where to use an alphabet or a
201: -- numeric character for a given position in the password
202:
203: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
204: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
205: 'fnd.plsql.UMXVUPWB.generate_password',
206: 'l_password_len: ' || l_password_len);
207: end if;
208:
219:
220: -- terminate the random number generator
221: --dbms_random.terminate;
222:
223: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
224: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
225: 'fnd.plsql.UMXVUPWB.generate_password.end',
226: 'x_password: ' || x_password);
227: end if;
220: -- terminate the random number generator
221: --dbms_random.terminate;
222:
223: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
224: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
225: 'fnd.plsql.UMXVUPWB.generate_password.end',
226: 'x_password: ' || x_password);
227: end if;
228:
237: v_counter BINARY_INTEGER := 1;
238:
239: begin
240:
241: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
242: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
243: 'fnd.plsql.UMXVUPWB.SetPassword.begin',
244: 'p_username: ' || p_username ||
245: ' | x_password: ' || x_password);
238:
239: begin
240:
241: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
242: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
243: 'fnd.plsql.UMXVUPWB.SetPassword.begin',
244: 'p_username: ' || p_username ||
245: ' | x_password: ' || x_password);
246: end if;
260:
261: IF (( v_counter > 100 ) and ( l_result <> 'Y' )) THEN
262: -- Throw exception as even though generated password 100 times, but
263: -- cannot pass validation criteria
264: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
265: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
266: 'fnd.plsql.UMXVUPWB.ForgotPwd',
267: 'Could not generated password automatically which satisfies validation requirements.');
268: end if;
261: IF (( v_counter > 100 ) and ( l_result <> 'Y' )) THEN
262: -- Throw exception as even though generated password 100 times, but
263: -- cannot pass validation criteria
264: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
265: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
266: 'fnd.plsql.UMXVUPWB.ForgotPwd',
267: 'Could not generated password automatically which satisfies validation requirements.');
268: end if;
269: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');
273: -- end of code for validating username
274:
275: end if;
276:
277: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
278: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
279: 'fnd.plsql.UMXVUPWB.SetPassword.end',
280: 'x_password: ' || x_password);
281: end if;
274:
275: end if;
276:
277: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
278: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
279: 'fnd.plsql.UMXVUPWB.SetPassword.end',
280: 'x_password: ' || x_password);
281: end if;
282:
458: p_check_identity in varchar2,
459: x_itemkey out nocopy varchar2) is
460: begin
461:
462: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
463: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
464: 'fnd.plsql.UMXVUPWB.start_workflow.begin',
465: 'p_user_name: ' || p_user_name ||
466: ' | p_email_address: ' || p_email_address ||
459: x_itemkey out nocopy varchar2) is
460: begin
461:
462: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
463: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
464: 'fnd.plsql.UMXVUPWB.start_workflow.begin',
465: 'p_user_name: ' || p_user_name ||
466: ' | p_email_address: ' || p_email_address ||
467: ' | p_role_name: ' || p_role_name ||
534:
535: wf_engine.StartProcess(itemtype => g_itemtype,
536: itemkey => x_itemkey);
537:
538: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
539: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
540: 'fnd.plsql.UMXVUPWB.start_workflow.end',
541: 'x_itemkey: ' || x_itemkey);
542: end if;
535: wf_engine.StartProcess(itemtype => g_itemtype,
536: itemkey => x_itemkey);
537:
538: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
539: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
540: 'fnd.plsql.UMXVUPWB.start_workflow.end',
541: 'x_itemkey: ' || x_itemkey);
542: end if;
543: end start_workflow;
565: l_nonExistentUser boolean := false;
566:
567: begin
568:
569: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
570: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
571: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.begin',
572: 'p_username: ' || p_username ||
573: ' | p_password: ' || p_password ||
566:
567: begin
568:
569: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
570: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
571: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.begin',
572: 'p_username: ' || p_username ||
573: ' | p_password: ' || p_password ||
574: ' | p_user_appr_msg_name: ' || p_user_appr_msg_name ||
648:
649: end if;
650: end if;
651:
652: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
653: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
654: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
655: 'x_return_status: ' || x_return_status ||
656: ' | x_message_name: ' || x_message_name ||
649: end if;
650: end if;
651:
652: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
653: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
654: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
655: 'x_return_status: ' || x_return_status ||
656: ' | x_message_name: ' || x_message_name ||
657: ' | x_message_data: ' || x_message_data);
678: x_message_name varchar2(80);
679:
680: begin
681:
682: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
684: 'fnd.plsql.UMXVUPWB.ResetPwd.begin',
685: 'p_username: ' || p_username ||
686: ' | p_password: ' || p_password ||
679:
680: begin
681:
682: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
684: 'fnd.plsql.UMXVUPWB.ResetPwd.begin',
685: 'p_username: ' || p_username ||
686: ' | p_password: ' || p_password ||
687: ' | p_user_appr_msg_name: ' || p_user_appr_msg_name ||
697: x_return_status => x_return_status,
698: x_message_name => x_message_name,
699: x_message_data => x_message_data);
700:
701: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
702: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
703: 'fnd.plsql.UMXVUPWB.ResetPwd.end',
704: 'x_return_status: ' || x_return_status ||
705: ' | x_message_data: ' || x_message_data);
698: x_message_name => x_message_name,
699: x_message_data => x_message_data);
700:
701: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
702: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
703: 'fnd.plsql.UMXVUPWB.ResetPwd.end',
704: 'x_return_status: ' || x_return_status ||
705: ' | x_message_data: ' || x_message_data);
706: end if;
715: x_message_name out NOCOPY varchar2,
716: x_message_data out NOCOPY varchar2) is
717: begin
718:
719: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
720: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
721: 'fnd.plsql.UMXVUPWB.ForgotPwd.begin',
722: 'p_username: ' || p_username ||
723: ' | p_user_appr_msg_name: ' || p_user_appr_msg_name ||
716: x_message_data out NOCOPY varchar2) is
717: begin
718:
719: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
720: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
721: 'fnd.plsql.UMXVUPWB.ForgotPwd.begin',
722: 'p_username: ' || p_username ||
723: ' | p_user_appr_msg_name: ' || p_user_appr_msg_name ||
724: ' | p_pwd_reset_msg_name: ' || p_pwd_reset_msg_name ||
733: x_return_status => x_return_status,
734: x_message_name => x_message_name,
735: x_message_data => x_message_data);
736:
737: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
738: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
739: 'fnd.plsql.UMXVUPWB.ForgotPwd.end',
740: 'x_return_status: ' || x_return_status ||
741: ' | x_message_name: ' || x_message_name ||
734: x_message_name => x_message_name,
735: x_message_data => x_message_data);
736:
737: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
738: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
739: 'fnd.plsql.UMXVUPWB.ForgotPwd.end',
740: 'x_return_status: ' || x_return_status ||
741: ' | x_message_name: ' || x_message_name ||
742: ' | x_message_data: ' || x_message_data);