DBA Data[Home] [Help]

APPS.UMX_REGISTER_USER_PVT dependencies on FND_USER_PKG

Line 674: -- This API is no longer a wrapper for fnd_user_pkg.userExists. It will

670: --
671: -- Function
672: -- userExists
673: -- Description
674: -- This API is no longer a wrapper for fnd_user_pkg.userExists. It will
675: -- query from fnd_user table and it
676: -- will return 'Y' if username is being used and
677: -- 'N' if username is not being used.
678: -- IN

Line 704: -- This API is a wrapper to fnd_user_pkg.TestUserName.

700: --
701: -- Procedure
702: -- TestUserName
703: -- Description
704: -- This API is a wrapper to fnd_user_pkg.TestUserName.
705: -- "This api test whether a username exists in FND and/or in OID."
706: -- IN
707: -- p_user_name - User name to be tested.
708: -- OUT

Line 709: -- x_return_status - The following statuses are defined in fnd_user_pkg:

705: -- "This api test whether a username exists in FND and/or in OID."
706: -- IN
707: -- p_user_name - User name to be tested.
708: -- OUT
709: -- x_return_status - The following statuses are defined in fnd_user_pkg:
710: -- USER_OK_CREATE : User does not exist in either FND or OID
711: -- USER_INVALID_NAME : User name is not valid
712: -- USER_EXISTS_IN_FND : User exists in FND
713: -- USER_SYNCHED : User exists in OID and next time when this user gets created

Line 737: x_return_status := fnd_user_pkg.TestUserName (x_user_name => p_user_name);

733: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXIBURB.TestUserName.begin',
734: 'p_user_name=' || p_user_name);
735: end if;
736:
737: x_return_status := fnd_user_pkg.TestUserName (x_user_name => p_user_name);
738:
739: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
740: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.UMXIBURB.TestUserName',
741: 'After invoking fnd_user_pkg.TestUserName x_return_status=>' || x_return_status);

Line 741: 'After invoking fnd_user_pkg.TestUserName x_return_status=>' || x_return_status);

737: x_return_status := fnd_user_pkg.TestUserName (x_user_name => p_user_name);
738:
739: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
740: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.UMXIBURB.TestUserName',
741: 'After invoking fnd_user_pkg.TestUserName x_return_status=>' || x_return_status);
742: end if;
743:
744: if (x_return_status = fnd_user_pkg.USER_SYNCHED) then
745: x_message_app_name := 'FND';

Line 744: if (x_return_status = fnd_user_pkg.USER_SYNCHED) then

740: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.UMXIBURB.TestUserName',
741: 'After invoking fnd_user_pkg.TestUserName x_return_status=>' || x_return_status);
742: end if;
743:
744: if (x_return_status = fnd_user_pkg.USER_SYNCHED) then
745: x_message_app_name := 'FND';
746: x_message_name := 'UMX_REG_USER_SYNCHED_CONF_MSG';
747: elsif not (x_return_status = fnd_user_pkg.USER_OK_CREATE) then
748: l_encoded_message := fnd_message.get_encoded;

Line 747: elsif not (x_return_status = fnd_user_pkg.USER_OK_CREATE) then

743:
744: if (x_return_status = fnd_user_pkg.USER_SYNCHED) then
745: x_message_app_name := 'FND';
746: x_message_name := 'UMX_REG_USER_SYNCHED_CONF_MSG';
747: elsif not (x_return_status = fnd_user_pkg.USER_OK_CREATE) then
748: l_encoded_message := fnd_message.get_encoded;
749: fnd_message.parse_encoded (encoded_message => l_encoded_message,
750: app_short_name => x_message_app_name,
751: message_name => x_message_name);