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_REGISTER_USER_PVT dependencies on FND_USER

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 675: -- query from fnd_user table and it

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
679: -- p_user_name - User name

Line 683: function userExists (p_user_name in fnd_user.user_name%type) return varchar2 is

679: -- p_user_name - User name
680: -- OUT
681: -- 'Y' - User name is being used.
682: -- 'N' - User name is not being used.
683: function userExists (p_user_name in fnd_user.user_name%type) return varchar2 is
684: retString varchar2 (1);
685:
686: cursor get_fnd_user is
687: select 'Y' from fnd_user where user_name = p_user_name;

Line 686: cursor get_fnd_user is

682: -- 'N' - User name is not being used.
683: function userExists (p_user_name in fnd_user.user_name%type) return varchar2 is
684: retString varchar2 (1);
685:
686: cursor get_fnd_user is
687: select 'Y' from fnd_user where user_name = p_user_name;
688:
689: begin
690: open get_fnd_user;

Line 687: select 'Y' from fnd_user where user_name = p_user_name;

683: function userExists (p_user_name in fnd_user.user_name%type) return varchar2 is
684: retString varchar2 (1);
685:
686: cursor get_fnd_user is
687: select 'Y' from fnd_user where user_name = p_user_name;
688:
689: begin
690: open get_fnd_user;
691: fetch get_fnd_user into retString;

Line 690: open get_fnd_user;

686: cursor get_fnd_user is
687: select 'Y' from fnd_user where user_name = p_user_name;
688:
689: begin
690: open get_fnd_user;
691: fetch get_fnd_user into retString;
692: if (get_fnd_user%notfound) then
693: retString := 'N';
694: end if;

Line 691: fetch get_fnd_user into retString;

687: select 'Y' from fnd_user where user_name = p_user_name;
688:
689: begin
690: open get_fnd_user;
691: fetch get_fnd_user into retString;
692: if (get_fnd_user%notfound) then
693: retString := 'N';
694: end if;
695: close get_fnd_user;

Line 692: if (get_fnd_user%notfound) then

688:
689: begin
690: open get_fnd_user;
691: fetch get_fnd_user into retString;
692: if (get_fnd_user%notfound) then
693: retString := 'N';
694: end if;
695: close get_fnd_user;
696:

Line 695: close get_fnd_user;

691: fetch get_fnd_user into retString;
692: if (get_fnd_user%notfound) then
693: retString := 'N';
694: end if;
695: close get_fnd_user;
696:
697: return retString;
698: end userExists;
699:

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 722: Procedure TestUserName (p_user_name in fnd_user.user_name%type,

718: -- x_message_name - The message name of the message in the FND message stack that
719: -- contents the detail message.
720: -- x_message_text - The detail message in the FND message stack.
721: ----------------------------------------------------------------------------
722: Procedure TestUserName (p_user_name in fnd_user.user_name%type,
723: x_return_status out nocopy pls_integer,
724: x_message_app_name out nocopy fnd_application.application_short_name%type,
725: x_message_name out nocopy fnd_new_messages.message_name%type,
726: x_message_text out nocopy fnd_new_messages.message_text%type) is

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);