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.POS_USER_ADMIN_PKG dependencies on FND_USER

Line 21: CURSOR fnd_user_cur IS

17: l_unencrypted_password VARCHAR2(30);
18: l_enterprise_name VARCHAR2(240);
19: l_resetpass BOOLEAN;
20:
21: CURSOR fnd_user_cur IS
22: SELECT * FROM fnd_user WHERE user_id = p_user_id;
23:
24: l_fnd_user_rec fnd_user_cur%ROWTYPE;
25:

Line 22: SELECT * FROM fnd_user WHERE user_id = p_user_id;

18: l_enterprise_name VARCHAR2(240);
19: l_resetpass BOOLEAN;
20:
21: CURSOR fnd_user_cur IS
22: SELECT * FROM fnd_user WHERE user_id = p_user_id;
23:
24: l_fnd_user_rec fnd_user_cur%ROWTYPE;
25:
26: BEGIN

Line 24: l_fnd_user_rec fnd_user_cur%ROWTYPE;

20:
21: CURSOR fnd_user_cur IS
22: SELECT * FROM fnd_user WHERE user_id = p_user_id;
23:
24: l_fnd_user_rec fnd_user_cur%ROWTYPE;
25:
26: BEGIN
27: OPEN fnd_user_cur;
28: FETCH fnd_user_cur INTO l_fnd_user_rec;

Line 27: OPEN fnd_user_cur;

23:
24: l_fnd_user_rec fnd_user_cur%ROWTYPE;
25:
26: BEGIN
27: OPEN fnd_user_cur;
28: FETCH fnd_user_cur INTO l_fnd_user_rec;
29:
30: IF ( fnd_user_cur%notfound) THEN
31: CLOSE fnd_user_cur;

Line 28: FETCH fnd_user_cur INTO l_fnd_user_rec;

24: l_fnd_user_rec fnd_user_cur%ROWTYPE;
25:
26: BEGIN
27: OPEN fnd_user_cur;
28: FETCH fnd_user_cur INTO l_fnd_user_rec;
29:
30: IF ( fnd_user_cur%notfound) THEN
31: CLOSE fnd_user_cur;
32: raise_application_error(-20001,'POSADMB: reset_password: Invalid user_id');

Line 30: IF ( fnd_user_cur%notfound) THEN

26: BEGIN
27: OPEN fnd_user_cur;
28: FETCH fnd_user_cur INTO l_fnd_user_rec;
29:
30: IF ( fnd_user_cur%notfound) THEN
31: CLOSE fnd_user_cur;
32: raise_application_error(-20001,'POSADMB: reset_password: Invalid user_id');
33:
34: ELSE

Line 31: CLOSE fnd_user_cur;

27: OPEN fnd_user_cur;
28: FETCH fnd_user_cur INTO l_fnd_user_rec;
29:
30: IF ( fnd_user_cur%notfound) THEN
31: CLOSE fnd_user_cur;
32: raise_application_error(-20001,'POSADMB: reset_password: Invalid user_id');
33:
34: ELSE
35: CLOSE fnd_user_cur;

Line 35: CLOSE fnd_user_cur;

31: CLOSE fnd_user_cur;
32: raise_application_error(-20001,'POSADMB: reset_password: Invalid user_id');
33:
34: ELSE
35: CLOSE fnd_user_cur;
36: END IF;
37:
38: l_process := 'POS_BPR_RESET_PASS';
39: l_itemtype := 'POSBPR';

Line 43: l_resetpass := FND_USER_PKG.ChangePassword(l_fnd_user_rec.user_name, l_unencrypted_password);

39: l_itemtype := 'POSBPR';
40: l_itemkey := to_char(p_user_id) || ':' || to_char(sysdate,'RRDDDSSSSS');
41:
42: l_unencrypted_password := POS_PASSWORD_UTIL_PKG.generate_user_pwd();
43: l_resetpass := FND_USER_PKG.ChangePassword(l_fnd_user_rec.user_name, l_unencrypted_password);
44:
45: fnd_user_pkg.updateuser
46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,

Line 45: fnd_user_pkg.updateuser

41:
42: l_unencrypted_password := POS_PASSWORD_UTIL_PKG.generate_user_pwd();
43: l_resetpass := FND_USER_PKG.ChangePassword(l_fnd_user_rec.user_name, l_unencrypted_password);
44:
45: fnd_user_pkg.updateuser
46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,

Line 46: ( x_user_name => l_fnd_user_rec.user_name,

42: l_unencrypted_password := POS_PASSWORD_UTIL_PKG.generate_user_pwd();
43: l_resetpass := FND_USER_PKG.ChangePassword(l_fnd_user_rec.user_name, l_unencrypted_password);
44:
45: fnd_user_pkg.updateuser
46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,

Line 48: x_end_date => l_fnd_user_rec.end_date,

44:
45: fnd_user_pkg.updateuser
46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,

Line 49: x_password_date => fnd_user_pkg.null_date,

45: fnd_user_pkg.updateuser
46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,

Line 50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,

46: ( x_user_name => l_fnd_user_rec.user_name,
47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,

Line 51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,

47: x_owner => NULL,
48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,
55: x_customer_id => l_fnd_user_rec.customer_id

Line 52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,

48: x_end_date => l_fnd_user_rec.end_date,
49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,
55: x_customer_id => l_fnd_user_rec.customer_id
56: );

Line 53: x_email_address => l_fnd_user_rec.email_address,

49: x_password_date => fnd_user_pkg.null_date,
50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,
55: x_customer_id => l_fnd_user_rec.customer_id
56: );
57:

Line 54: x_fax => l_fnd_user_rec.fax,

50: x_password_accesses_left => l_fnd_user_rec.password_accesses_left,
51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,
55: x_customer_id => l_fnd_user_rec.customer_id
56: );
57:
58: pos_enterprise_util_pkg.get_enterprise_party_name

Line 55: x_customer_id => l_fnd_user_rec.customer_id

51: x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
52: x_password_lifespan_days => l_fnd_user_rec.password_lifespan_days,
53: x_email_address => l_fnd_user_rec.email_address,
54: x_fax => l_fnd_user_rec.fax,
55: x_customer_id => l_fnd_user_rec.customer_id
56: );
57:
58: pos_enterprise_util_pkg.get_enterprise_party_name
59: (l_enterprise_name,

Line 70: p_prefix => 'call fnd_user_pkg.update_user',

66: END IF;
67:
68: pos_log.log_call_result
69: (p_module => 'POSADMB',
70: p_prefix => 'call fnd_user_pkg.update_user',
71: p_return_status => x_return_status,
72: p_msg_count => x_msg_count,
73: p_msg_data => x_msg_data
74: );

Line 88: avalue => l_fnd_user_rec.user_name);

84:
85: wf_engine.SetItemAttrText (itemtype => l_itemtype,
86: itemkey => l_itemkey,
87: aname => 'USERNAME',
88: avalue => l_fnd_user_rec.user_name);
89:
90: wf_engine.SetItemAttrText (itemtype => l_itemtype,
91: itemkey => l_itemkey,
92: aname => 'ENTERPRISE_NAME',

Line 119: CURSOR fnd_user_cur IS

115: , x_msg_count OUT NOCOPY NUMBER
116: , x_msg_data OUT NOCOPY VARCHAR2
117: )
118: IS
119: CURSOR fnd_user_cur IS
120: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;
121:
122: l_fnd_user_rec fnd_user_cur%ROWTYPE;
123: l_end_date DATE;

Line 120: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

116: , x_msg_data OUT NOCOPY VARCHAR2
117: )
118: IS
119: CURSOR fnd_user_cur IS
120: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;
121:
122: l_fnd_user_rec fnd_user_cur%ROWTYPE;
123: l_end_date DATE;
124: l_start_date DATE;

Line 122: l_fnd_user_rec fnd_user_cur%ROWTYPE;

118: IS
119: CURSOR fnd_user_cur IS
120: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;
121:
122: l_fnd_user_rec fnd_user_cur%ROWTYPE;
123: l_end_date DATE;
124: l_start_date DATE;
125: l_old_inactive_date date;
126: BEGIN

Line 127: OPEN fnd_user_cur;

123: l_end_date DATE;
124: l_start_date DATE;
125: l_old_inactive_date date;
126: BEGIN
127: OPEN fnd_user_cur;
128: FETCH fnd_user_cur INTO l_fnd_user_rec;
129:
130: IF ( fnd_user_cur%notfound) THEN
131: CLOSE fnd_user_cur;

Line 128: FETCH fnd_user_cur INTO l_fnd_user_rec;

124: l_start_date DATE;
125: l_old_inactive_date date;
126: BEGIN
127: OPEN fnd_user_cur;
128: FETCH fnd_user_cur INTO l_fnd_user_rec;
129:
130: IF ( fnd_user_cur%notfound) THEN
131: CLOSE fnd_user_cur;
132: raise_application_error(-20001,'POSADMB: end_date_user_account: Invalid user_id');

Line 130: IF ( fnd_user_cur%notfound) THEN

126: BEGIN
127: OPEN fnd_user_cur;
128: FETCH fnd_user_cur INTO l_fnd_user_rec;
129:
130: IF ( fnd_user_cur%notfound) THEN
131: CLOSE fnd_user_cur;
132: raise_application_error(-20001,'POSADMB: end_date_user_account: Invalid user_id');
133:
134: ELSE

Line 131: CLOSE fnd_user_cur;

127: OPEN fnd_user_cur;
128: FETCH fnd_user_cur INTO l_fnd_user_rec;
129:
130: IF ( fnd_user_cur%notfound) THEN
131: CLOSE fnd_user_cur;
132: raise_application_error(-20001,'POSADMB: end_date_user_account: Invalid user_id');
133:
134: ELSE
135: CLOSE fnd_user_cur;

Line 135: CLOSE fnd_user_cur;

131: CLOSE fnd_user_cur;
132: raise_application_error(-20001,'POSADMB: end_date_user_account: Invalid user_id');
133:
134: ELSE
135: CLOSE fnd_user_cur;
136: END IF;
137:
138: if p_inactive_date is null then
139: select start_date, end_date

Line 141: from fnd_user

137:
138: if p_inactive_date is null then
139: select start_date, end_date
140: into l_start_date,l_old_inactive_date
141: from fnd_user
142: where user_name = l_fnd_user_rec.user_name;
143:
144: if (l_old_inactive_date is not null) then
145: fnd_user_pkg.enableuser(username => l_fnd_user_rec.user_name,

Line 142: where user_name = l_fnd_user_rec.user_name;

138: if p_inactive_date is null then
139: select start_date, end_date
140: into l_start_date,l_old_inactive_date
141: from fnd_user
142: where user_name = l_fnd_user_rec.user_name;
143:
144: if (l_old_inactive_date is not null) then
145: fnd_user_pkg.enableuser(username => l_fnd_user_rec.user_name,
146: start_date => l_start_date);

Line 145: fnd_user_pkg.enableuser(username => l_fnd_user_rec.user_name,

141: from fnd_user
142: where user_name = l_fnd_user_rec.user_name;
143:
144: if (l_old_inactive_date is not null) then
145: fnd_user_pkg.enableuser(username => l_fnd_user_rec.user_name,
146: start_date => l_start_date);
147: end if;
148: else
149: l_end_date := p_inactive_date;

Line 150: fnd_user_pkg.updateuser

146: start_date => l_start_date);
147: end if;
148: else
149: l_end_date := p_inactive_date;
150: fnd_user_pkg.updateuser
151: ( x_user_name => l_fnd_user_rec.user_name,
152: x_owner => NULL,
153: x_end_date => l_end_date
154: );

Line 151: ( x_user_name => l_fnd_user_rec.user_name,

147: end if;
148: else
149: l_end_date := p_inactive_date;
150: fnd_user_pkg.updateuser
151: ( x_user_name => l_fnd_user_rec.user_name,
152: x_owner => NULL,
153: x_end_date => l_end_date
154: );
155: end if;

Line 177: fnd_user_resp_groups_api.upload_assignment

173: )
174: IS
175: BEGIN
176: x_return_status := fnd_api.g_ret_sts_success;
177: fnd_user_resp_groups_api.upload_assignment
178: ( user_id => p_user_id,
179: responsibility_id => p_resp_id,
180: responsibility_application_id => p_resp_app_id,
181: security_group_id => 0,

Line 270: SELECT start_date FROM fnd_user_resp_groups

266: )
267: IS
268: l_start_date DATE;
269: CURSOR l_cur IS
270: SELECT start_date FROM fnd_user_resp_groups
271: WHERE user_id = p_user_id AND responsibility_id = p_resp_id;
272: BEGIN
273: OPEN l_cur;
274: FETCH l_cur INTO l_start_date;

Line 280: fnd_user_resp_groups_api.upload_assignment

276: CLOSE l_cur;
277: x_return_status := fnd_api.g_ret_sts_success;
278: RETURN;
279: END IF;
280: fnd_user_resp_groups_api.upload_assignment
281: ( user_id => p_user_id,
282: responsibility_id => p_resp_id,
283: responsibility_application_id => p_resp_app_id,
284: security_group_id => 0,

Line 350: FROM fnd_user

346: l_profile_id NUMBER;
347:
348: CURSOR l_user_cur IS
349: SELECT user_name
350: FROM fnd_user
351: WHERE person_party_id = p_party_id;
352:
353: CURSOR l_party_cur IS
354: SELECT object_version_number, last_update_date

Line 458: --set email address in fnd_user as well as TCA.

454: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
455: RETURN;
456: END IF;
457:
458: --set email address in fnd_user as well as TCA.
459:
460: FOR l_user_rec IN l_user_cur LOOP
461: fnd_user_pkg.updateuser
462: ( x_user_name => l_user_rec.user_name,

Line 461: fnd_user_pkg.updateuser

457:
458: --set email address in fnd_user as well as TCA.
459:
460: FOR l_user_rec IN l_user_cur LOOP
461: fnd_user_pkg.updateuser
462: ( x_user_name => l_user_rec.user_name,
463: x_owner => NULL,
464: x_email_address => p_user_email,
465: x_customer_id => p_party_id

Line 737: CURSOR l_fnd_user_cur IS

733: l_party_rec l_party_cur%ROWTYPE;
734:
735: l_count INTEGER;
736:
737: CURSOR l_fnd_user_cur IS
738: SELECT user_id
739: FROM fnd_user
740: WHERE user_name = p_user_name;
741:

Line 739: FROM fnd_user

735: l_count INTEGER;
736:
737: CURSOR l_fnd_user_cur IS
738: SELECT user_id
739: FROM fnd_user
740: WHERE user_name = p_user_name;
741:
742: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;
743: BEGIN

Line 742: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;

738: SELECT user_id
739: FROM fnd_user
740: WHERE user_name = p_user_name;
741:
742: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;
743: BEGIN
744: SAVEPOINT create_supp_user_account_sp;
745:
746: IF p_user_name IS NULL THEN

Line 754: OPEN l_fnd_user_cur;

750: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
751: RETURN;
752: END IF;
753:
754: OPEN l_fnd_user_cur;
755: FETCH l_fnd_user_cur INTO l_fnd_user_rec;
756: IF l_fnd_user_cur%found THEN
757: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;

Line 755: FETCH l_fnd_user_cur INTO l_fnd_user_rec;

751: RETURN;
752: END IF;
753:
754: OPEN l_fnd_user_cur;
755: FETCH l_fnd_user_cur INTO l_fnd_user_rec;
756: IF l_fnd_user_cur%found THEN
757: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;
759: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');

Line 756: IF l_fnd_user_cur%found THEN

752: END IF;
753:
754: OPEN l_fnd_user_cur;
755: FETCH l_fnd_user_cur INTO l_fnd_user_rec;
756: IF l_fnd_user_cur%found THEN
757: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;
759: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');
760: fnd_message.set_token('USER_NAME', p_user_name);

Line 757: CLOSE l_fnd_user_cur;

753:
754: OPEN l_fnd_user_cur;
755: FETCH l_fnd_user_cur INTO l_fnd_user_rec;
756: IF l_fnd_user_cur%found THEN
757: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;
759: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');
760: fnd_message.set_token('USER_NAME', p_user_name);
761: fnd_msg_pub.ADD;

Line 765: CLOSE l_fnd_user_cur;

761: fnd_msg_pub.ADD;
762: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
763: RETURN;
764: END IF;
765: CLOSE l_fnd_user_cur;
766:
767: IF p_user_email IS NULL THEN
768: x_return_status := fnd_api.g_ret_sts_error;
769: fnd_message.set_name('POS', 'POS_CRSUSER_EMAIL_NULL');

Line 822: l_testname := FND_USER_PKG.TestUserName(p_user_name);

818: END IF;
819:
820: --sso integration, if user exists in oid
821: --and synch is allowed, then no need to pass the password
822: l_testname := FND_USER_PKG.TestUserName(p_user_name);
823: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
824: l_unencrypted_password := NULL;
825: END IF;
826:

Line 823: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN

819:
820: --sso integration, if user exists in oid
821: --and synch is allowed, then no need to pass the password
822: l_testname := FND_USER_PKG.TestUserName(p_user_name);
823: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
824: l_unencrypted_password := NULL;
825: END IF;
826:
827: -- Bug: 14292251

Line 849: fnd_user_pkg.createuserid

845: END;
846: END IF;
847:
848: x_user_id :=
849: fnd_user_pkg.createuserid
850: (x_user_name => p_user_name,
851: x_owner => NULL, -- created by current user
852: x_unencrypted_password => l_unencrypted_password,
853: x_description => p_user_name,

Line 858: -- set the person_party_id column in fnd_user

854: x_email_address => p_user_email,
855: x_password_lifespan_days => l_password_lifespan_days
856: );
857:
858: -- set the person_party_id column in fnd_user
859: fnd_user_pkg.updateuserparty
860: (x_user_name => p_user_name,
861: x_owner => NULL,
862: x_person_party_id => p_person_party_id

Line 859: fnd_user_pkg.updateuserparty

855: x_password_lifespan_days => l_password_lifespan_days
856: );
857:
858: -- set the person_party_id column in fnd_user
859: fnd_user_pkg.updateuserparty
860: (x_user_name => p_user_name,
861: x_owner => NULL,
862: x_person_party_id => p_person_party_id
863: );

Line 925: FROM fnd_user

921: FUNCTION get_contact_email RETURN VARCHAR2
922: IS
923: CURSOR l_cur IS
924: SELECT email_address
925: FROM fnd_user
926: WHERE user_id = fnd_global.user_id;
927:
928: l_email fnd_user.email_address%TYPE;
929: BEGIN

Line 928: l_email fnd_user.email_address%TYPE;

924: SELECT email_address
925: FROM fnd_user
926: WHERE user_id = fnd_global.user_id;
927:
928: l_email fnd_user.email_address%TYPE;
929: BEGIN
930: OPEN l_cur;
931: FETCH l_cur INTO l_email;
932: CLOSE l_cur;

Line 969: if (FND_USER_PKG.TestUserName(p_user_name) = FND_USER_PKG.USER_SYNCHED) then

965: l_sec_attr_numbers := po_tbl_number();
966:
967: /* Bug 5680160 Start */
968: l_user_in_oid := 'N';
969: if (FND_USER_PKG.TestUserName(p_user_name) = FND_USER_PKG.USER_SYNCHED) then
970: l_user_in_oid := 'Y';
971: end if;
972: /* Bug 5680160 End */
973: create_supplier_user_account