Search Results validate_login

Overview

GMO_OPER_CERT_UTL is a utility package body owned by the APPS schema that supports the Oracle E-Business Suite Process Manufacturing (OPM) operator certification functionality. Its documented role in ETRM is classified as OTHER, meaning it is an internal helper package rather than a public application programming interface exposed through standard EBS integration points. The package provides a thin server-side wrapper around Oracle EBS user authentication logic, allowing OPM certification and operator-qualification screens to confirm that a supplied user name and password pair represents a valid, active EBS application user.

The package header follows standard EBS coding conventions. A package-level constant, g_pkg_name, stores the package name for diagnostic messages, while g_debug is initialized from the AFLOG_LEVEL profile option, enabling conditional debug output when the site-level logging profile is enabled. These constructs are typical of Release 12.1.1 and 12.2.2 technical components and indicate that the package is intended for operational support and troubleshooting.

Key Procedures and Functions

The ETRM metadata documents a single procedure, VALIDATE_LOGIN. It accepts a user name and password as inputs and returns a status indicator through an OUT parameter. The procedure delegates the actual credential check to FND_USER_PKG.ValidateLogin, the Oracle Application Object Library routine that validates EBS user credentials against the FND_USER repository. Based on the Boolean result returned by FND_USER_PKG, VALIDATE_LOGIN sets its return status to 'T' when the credentials are valid and 'F' when they are not. No other procedures or functions are documented for this package, and the ETRM record confirms one total documented procedure.

Tables Accessed

No base tables are listed in the ETRM metadata as being referenced directly through APPS synonyms. All user data access is indirect: FND_USER_PKG.ValidateLogin reads the FND_USER table, and password verification may also touch FND_USER-related security objects such as the encrypted password columns and password history. Because the package itself contains no SQL against application tables, any table-level dependencies are inherited from the FND_USER_PKG call rather than declared by GMO_OPER_CERT_UTL.

Usage Notes

The package is invoked from custom OPM operator certification code and any form, concurrent program, or PL/SQL routine that must confirm operator identity before recording a certification or authorization transaction. Because it wraps FND_USER_PKG, it is subject to the same password policy, case sensitivity, and failure-lockout rules configured in the EBS instance. The return status is a single-character flag, so callers should treat any value other than 'T' as a failed login and refrain from further processing. The procedure does not raise a NO_DATA_FOUND exception itself and suppresses the Boolean result into a status code, which simplifies error handling in forms and batch code. The referenced-by count of zero indicates that the package is not called from other documented ETRM packages; it is therefore a leaf utility that is safe to modify without cascading impact on certified EBS objects. On 12.2.2 the AFLOG_LEVEL-driven debug behavior remains unchanged from 12.1.1, so migration between these releases does not alter calling conventions.