eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.UMX_PASSWORD_PVT dependencies on FND_USER

Line 7: -- 2) FND User

3:
4: g_itemtype wf_item_types.name%type := 'UMXUPWD';
5: -- Private function to get the email address of the active user from
6: -- 1) WF local roles
7: -- 2) FND User
8: -- 3) The first TCA party
9: procedure get_email_address (p_user_name in fnd_user.user_name%type,
10: x_role_name out nocopy varchar2,
11: x_email_address out nocopy varchar2,

Line 9: procedure get_email_address (p_user_name in fnd_user.user_name%type,

5: -- Private function to get the email address of the active user from
6: -- 1) WF local roles
7: -- 2) FND User
8: -- 3) The first TCA party
9: procedure get_email_address (p_user_name in fnd_user.user_name%type,
10: x_role_name out nocopy varchar2,
11: x_email_address out nocopy varchar2,
12: x_notification_preference out nocopy varchar2,
13: x_message_name out nocopy varchar2,

Line 22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is

18: l_role_display_name wf_local_roles.display_name%type;
19: l_language wf_local_roles.language%type;
20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address
24: FROM fnd_user
25: WHERE user_name = p_user_name
26: AND start_date <= sysdate

Line 24: FROM fnd_user

20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address
24: FROM fnd_user
25: WHERE user_name = p_user_name
26: AND start_date <= sysdate
27: AND nvl(end_date, sysdate + 1) > sysdate;
28:

Line 29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is

25: WHERE user_name = p_user_name
26: AND start_date <= sysdate
27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address
31: FROM hz_parties hzp, fnd_user fu
32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;

Line 31: FROM hz_parties hzp, fnd_user fu

27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address
31: FROM hz_parties hzp, fnd_user fu
32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;
34:
35: begin

Line 50: -- Try to get the email from fnd_user

46:
47: if x_email_address is not null then
48: x_role_name := p_user_name;
49: else
50: -- Try to get the email from fnd_user
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';

Line 81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is

77: end if;
78:
79: end get_email_address;
80:
81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is
82:
83: cursor get_username_from_userid is
84: select user_name
85: from fnd_user

Line 85: from fnd_user

81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is
82:
83: cursor get_username_from_userid is
84: select user_name
85: from fnd_user
86: where user_id = p_user_id;
87:
88: l_user_name fnd_user.user_name%type;
89:

Line 88: l_user_name fnd_user.user_name%type;

84: select user_name
85: from fnd_user
86: where user_id = p_user_id;
87:
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

Line 136: Procedure validate_password (p_username in fnd_user.user_name%type,

132: -- - Returns FND_API.G_RET_STS_ERROR if failed
133: -- x_message_data - Reason why it is failed.
134: -- Errors :
135: -- Other Comments :
136: Procedure validate_password (p_username in fnd_user.user_name%type,
137: p_password in varchar2,
138: x_return_status out NOCOPY varchar2,
139: x_message_data out NOCOPY varchar2) is
140:

Line 181: function generate_password(p_username in fnd_user.user_name%type) return varchar2 is

177: * Errors :
178: * Other Comments :
179: */
180:
181: function generate_password(p_username in fnd_user.user_name%type) return varchar2 is
182:
183: l_password_len int := 6;
184: x_password varchar2(40);
185: ascii_offset int := 65;

Line 200: select USER_ID into USER_ID from FND_USER where USER_NAME= P_USERNAME;

196: --dbms_random.initialize(dbms_utility.get_time);
197:
198: -- using the profile, determine the length of the random number
199: begin
200: select USER_ID into USER_ID from FND_USER where USER_NAME= P_USERNAME;
201: EXCEPTION
202: when NO_DATA_FOUND then
203: USER_ID := -1;
204: end;

Line 240: Procedure SetPassword (p_username in fnd_user.user_name%type,

236: return x_password;
237:
238: end generate_password;
239:
240: Procedure SetPassword (p_username in fnd_user.user_name%type,
241: x_password in out NOCOPY varchar2) is
242:
243: l_result varchar2(10);
244: v_counter BINARY_INTEGER := 1;

Line 299: l_user_name fnd_user.user_name%type;

295: funcmode in varchar2,
296: resultout in out NOCOPY varchar2) is
297:
298: l_password varchar2(40);
299: l_user_name fnd_user.user_name%type;
300:
301: begin
302: if (funcmode = 'RUN') then
303: -- Check if the password is already set.

Line 340: -- Description: Calls FND_USER_PKG.UpdateUserParty

336: end;
337:
338: -------------------------------------------------------------------
339: -- Name: UpdatePassword_WF
340: -- Description: Calls FND_USER_PKG.UpdateUserParty
341: -------------------------------------------------------------------
342: Procedure UpdatePassword_WF(itemtype in varchar2,
343: itemkey in varchar2,
344: actid in number,

Line 352: FND_USER_PKG.UpdateUserParty (

348: begin
349:
350: if (funcmode = 'RUN') then
351:
352: FND_USER_PKG.UpdateUserParty (
353: x_user_name =>
354: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
355: 'USER_NAME', TRUE),
356: x_owner => null,

Line 360: x_password_date => fnd_user_pkg.null_date);

356: x_owner => null,
357: x_unencrypted_password =>
358: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
359: 'PASSWORD', TRUE),
360: x_password_date => fnd_user_pkg.null_date);
361:
362: end if;
363:
364: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

Line 379: FROM fnd_user

375: /* this method returns a formatted name to be used for display name*/
376: function getDisplayName(username in varchar2) return varchar2 is
377: cursor C_party_id is
378: SELECT person_party_id
379: FROM fnd_user
380: where user_name = username;
381:
382: x_return_status varchar2(40);
383: x_msg_count NUMBER;

Line 414: -- is set to FND-username

410: -- Name: CreateRole
411: -- Description: Creates an adhoc role with notification preference always set
412: -- to 'MAIL'. This would ensure that the user would get an email
413: -- for all password related notifications. The name of the role
414: -- is set to FND-username
415: -------------------------------------------------------------------
416: Procedure CreateRole(itemtype in varchar2,
417: itemkey in varchar2,
418: actid in number,

Line 424: l_username fnd_user.user_name%type;

420: resultout in out NOCOPY varchar2) is
421:
422: l_role_name wf_local_roles.name%type;
423: l_notification_preference wf_local_roles.notification_preference%type;
424: l_username fnd_user.user_name%type;
425: l_display_name varchar2(4000);
426: begin
427:
428: if (funcmode = 'RUN') then

Line 562: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,

558: end if;
559: end start_workflow;
560:
561: -- Private Method
562: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
563: p_password in varchar2 default null,
564: p_user_appr_msg_name in varchar2 default null,
565: p_pwd_reset_msg_name in varchar2 default null,
566: p_check_identity in varchar2 default 'Y',

Line 573: l_user_name fnd_user.user_name%type := upper(p_username);

569: x_return_status out NOCOPY varchar2,
570: x_message_name out NOCOPY varchar2,
571: x_message_data out NOCOPY varchar2) is
572:
573: l_user_name fnd_user.user_name%type := upper(p_username);
574: l_email_address varchar2(2000);
575: l_role_name wf_local_roles.name%type;
576: l_password varchar2(40);
577: l_notification_preference wf_local_roles.notification_preference%type;

Line 642: FND_USER_PKG.UpdateUserParty (

638: -- Reset the password without starting a workflow
639: l_password := p_password;
640: SetPassword (p_username => l_user_name,
641: x_password => l_password);
642: FND_USER_PKG.UpdateUserParty (
643: x_user_name => l_user_name,
644: x_owner => null,
645: x_unencrypted_password => l_password,
646: x_password_date => fnd_user_pkg.null_date);

Line 646: x_password_date => fnd_user_pkg.null_date);

642: FND_USER_PKG.UpdateUserParty (
643: x_user_name => l_user_name,
644: x_owner => null,
645: x_unencrypted_password => l_password,
646: x_password_date => fnd_user_pkg.null_date);
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: end if;
649: end if;
650: end if;

Line 688: procedure ResetPwd (p_username in fnd_user.user_name%type,

684:
685: END ResetPwdPvt;
686:
687:
688: procedure ResetPwd (p_username in fnd_user.user_name%type,
689: p_password in varchar2 default null,
690: p_user_appr_msg_name in varchar2 default null,
691: p_pwd_reset_msg_name in varchar2 default null,
692: p_check_identity in varchar2 default 'Y',

Line 731: procedure ForgotPwd(p_username in fnd_user.user_name%type,

727: end if;
728:
729: end ResetPwd;
730:
731: procedure ForgotPwd(p_username in fnd_user.user_name%type,
732: p_user_appr_msg_name in varchar2 default null,
733: p_pwd_reset_msg_name in varchar2 default null,
734: p_check_identity in varchar2 default 'Y',
735: p_htmlagent in varchar2 default null,