[Home] [Help]
1031: * requester_user_name and email is null
1032: * requester_user_name is not a valid user
1033: * requester_email does not correspond to a valid user
1034: * Other Comments :
1035: * FND_USER update : The update of fnd_user table is done using fnd_user_pkg
1036: * procedure as recommended by fnd (bug 1713101)
1037: * DEFAULTING LOGIC
1038: * If only the user name is passed then the email is defaulted using the following logic
1039: * 1. Email address from fnd_users where user_name = p_requester_user_name
1199: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: end if;
1202:
1203: if not fnd_user_pkg.changePassword(username => l_requester_user_name,
1204: newpassword => l_password) then
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: end if;
1207:
1206: end if;
1207:
1208: -- update the password date to null to force user to change psswd upon
1209: -- first login
1210: fnd_user_pkg.UpdateUser (
1211: x_user_name => l_requester_user_name,
1212: x_owner => 'CUST',
1213: x_unencrypted_password => l_password,
1214: x_password_date => null);