63: x_return_status varchar2 (4000);
64: x_message_data varchar2 (4000);
65: begin
66:
67: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
68: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXPRRSB.assignRole.begin', '');
69: end if;
70:
71: UMX_PUB.assign_role (p_registration_data, x_return_status, x_message_data);
64: x_message_data varchar2 (4000);
65: begin
66:
67: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
68: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXPRRSB.assignRole.begin', '');
69: end if;
70:
71: UMX_PUB.assign_role (p_registration_data, x_return_status, x_message_data);
72:
69: end if;
70:
71: UMX_PUB.assign_role (p_registration_data, x_return_status, x_message_data);
72:
73: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
74: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXPRRSB.assignRole.end', '');
75: end if;
76: end assign_role;
77:
70:
71: UMX_PUB.assign_role (p_registration_data, x_return_status, x_message_data);
72:
73: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
74: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXPRRSB.assignRole.end', '');
75: end if;
76: end assign_role;
77:
78:
80: , x_return_status out NOCOPY varchar2
81: , x_message_data out NOCOPY varchar2) IS
82: begin
83:
84: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
85: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
86: 'fnd.plsql.UMXPRRSB.assignRole.begin', '');
87: end if;
88:
81: , x_message_data out NOCOPY varchar2) IS
82: begin
83:
84: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
85: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
86: 'fnd.plsql.UMXPRRSB.assignRole.begin', '');
87: end if;
88:
89: UMX_REGISTRATION_PVT.assign_role (p_registration_data, x_return_status, x_message_data);
87: end if;
88:
89: UMX_REGISTRATION_PVT.assign_role (p_registration_data, x_return_status, x_message_data);
90:
91: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
92: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
93: 'fnd.plsql.UMXPRRSB.assignRole.end', '');
94: end if;
95: end assign_role;
88:
89: UMX_REGISTRATION_PVT.assign_role (p_registration_data, x_return_status, x_message_data);
90:
91: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
92: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
93: 'fnd.plsql.UMXPRRSB.assignRole.end', '');
94: end if;
95: end assign_role;
96:
175: procedure get_suggested_username (p_person_party_id in HZ_PARTIES.PARTY_ID%TYPE default null,
176: x_suggested_username out nocopy FND_USER.USER_NAME%TYPE) is
177: begin
178:
179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXPRRSB.get_suggested_username.begin',
182: 'p_person_party_id: ' || p_person_party_id);
183: end if;
176: x_suggested_username out nocopy FND_USER.USER_NAME%TYPE) is
177: begin
178:
179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXPRRSB.get_suggested_username.begin',
182: 'p_person_party_id: ' || p_person_party_id);
183: end if;
184:
184:
185: UMX_USERNAME_POLICY_PVT.get_suggested_username (p_person_party_id => p_person_party_id,
186: x_suggested_username => x_suggested_username);
187:
188: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
189: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
190: 'fnd.plsql.UMXPRRSB.get_suggested_username.end',
191: 'x_suggested_username: ' || x_suggested_username);
192: end if;
185: UMX_USERNAME_POLICY_PVT.get_suggested_username (p_person_party_id => p_person_party_id,
186: x_suggested_username => x_suggested_username);
187:
188: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
189: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
190: 'fnd.plsql.UMXPRRSB.get_suggested_username.end',
191: 'x_suggested_username: ' || x_suggested_username);
192: end if;
193:
264: x_hint out nocopy FND_LOOKUP_VALUES.MEANING%TYPE) is
265:
266: begin
267:
268: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
269: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
270: 'fnd.plsql.UMXPRRSB.get_username_policy_desc.begin', '');
271: end if;
272:
265:
266: begin
267:
268: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
269: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
270: 'fnd.plsql.UMXPRRSB.get_username_policy_desc.begin', '');
271: end if;
272:
273: UMX_USERNAME_POLICY_PVT.get_username_policy_desc (x_policy_code => x_policy_code,
275: x_prompt => x_prompt,
276: x_hint => x_hint);
277:
278:
279: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
280: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
281: 'fnd.plsql.UMXPRRSB.get_username_policy_desc.end',
282: 'x_policy_code: ' || x_policy_code ||
283: ' | x_description: ' || x_description ||
276: x_hint => x_hint);
277:
278:
279: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
280: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
281: 'fnd.plsql.UMXPRRSB.get_username_policy_desc.end',
282: 'x_policy_code: ' || x_policy_code ||
283: ' | x_description: ' || x_description ||
284: ' | x_prompt: ' || x_prompt ||