Search Results g_msg_low

Overview

XLE_ASSOCIATIONS_INFO is a public PL/SQL package belonging to the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It resides within the Financials/Subledger Accounting product family, specifically the "XLE" module that underpins the E-Business Tax and Subledger Accounting legal entity infrastructure. The package exposes a single documented procedure, GET_ASSOCIATIONS_INFO, whose stated purpose in the package header is to retrieve Legal Association information.

The body opens with a standard block of global constants that are customary in Oracle's published APIs. These include G_PKG_NAME plus the conventional message-level constants declared against FND_MSG_PUB: G_MSG_UERROR, G_MSG_ERROR, G_MSG_SUCCESS, G_MSG_HIGH, G_MSG_MEDIUM, and G_MSG_LOW. The occurrence the user searched for, g_msg_success, is defined here as the constant assigned to FND_MSG_PUB.G_MSG_LVL_SUCCESS. It is used for consistency when APIs place informational messages on the FND message stack; it does not represent a data value or a business rule on its own.

Key Procedures and Functions

The package documents one procedure: GET_ASSOCIATIONS_INFO. As reflected by the ETRM metadata, it follows the standard Oracle API contract, accepting p_init_msg_list and p_commit parameters and returning x_return_status, x_msg_count, and x_msg_data. In addition, the procedure accepts context parameters that identify which legal association to retrieve: p_context, p_object_type, p_subject_type, p_legal_entity_id, p_object_id, and p_subject_id, with an output collection p_assocs returning the associated records.

The procedure therefore serves as a read-only query interface. A caller supplies the identifying keys for a legal association and receives one or more association records along with the standard API return status and message information. The message-level constants in the package body, including g_msg_success, are used by the procedure when populating the FND message stack according to the severity of the outcome.

Tables Accessed

The package reads from three documented tables, all of which are accessed through APPS synonyms:

• XLE_ASSOCIATIONS — the primary association records, including the subject identity and subject parent identifier referenced by the procedure parameters. This is the main table queried when locating a legal association.
• XLE_ASSOCIATION_TYPES — the type or context definitions that determine how a given association record should be interpreted.
• XLE_ASSOC_OBJECT_TYPES — the object type and subject type registry, used to validate and resolve the p_object_type and p_subject_type inputs.

All three are read-only in the context of this API. The package does not perform inserts or updates to these tables, consistent with its role as an information-access layer.

Usage Notes

Because GET_ASSOCIATIONS_INFO belongs to the XLE legal entity infrastructure, it is typically invoked indirectly by higher-level E-Business Tax and Subledger Accounting processes rather than being called directly by end users. The ETRM metadata records that the package is referenced by zero other packages, meaning it is not a shared dependency of other PL/SQL units and callers reach it through direct or embedded invocation.

Typical invocation scenarios include:

• Forms-based or OAF UI pages that display legal association details for a selected legal entity.
• Concurrent programs that extract or reconcile association data for reporting and tax determination.
• Custom code or extensions that need to resolve which associations apply to a given object and subject, using the standard p_init_msg_list and p_commit API conventions and checking x_return_status before reading p_assocs.

Callers should always inspect x_msg_count and call the standard FND_MSG_PUB retrieval routines when x_return_status indicates anything other than success. The presence of g_msg_success in the body simply confirms that the package adheres to the standard Oracle message-level convention; it should not be interpreted as guaranteeing success for any given invocation.