Search Results set_msg

Overview

GL_COA_SEG_VAL_IMP_PKG is a Chart of Accounts (COA) segment value import utility in Oracle EBS Applications (APPS schema). It is classified in ETRM as an OTHER API and forms part of the Flexfields infrastructure that underpins the Accounting Flexfield. Its business purpose is to import GL COA flex values (segment values) and the child ranges that define normal hierarchies for those values. The package is invoked directly by the Chart of Accounts Segment Values API rather than being executed standalone by end users. The header comment records creation by Somnath Mukherjee on 01-AUG-2008 and identifies two sub processes exposed to the calling API: value import and child range import.

Key Procedures and Functions

• CREATE_GL_COA_FLEX_VALUES — Imports GL COA flex values into the FND flexfields value tables. This is the primary process invoked by the Chart of Accounts Segment Values API to load segment values for a specified value set.
• CREATE_GL_COA_FLEX_VALUES_NH — Imports child ranges for the segment values, supporting normal hierarchy (NH) definitions associated with the imported values. It complements the first process by establishing parent-child range relationships.

The package body additionally declares private helper constructs, including a cursor (C_FND_FLEX_VALUES) that validates the supplied value set name against FND_FLEX_VALUE_SETS, a PL/SQL table type (FLEX_VL_SET_ID_TBL_TYPE) used to cache unique flex value set IDs, and a Boolean function ISEXISTS that checks whether a given flex value set ID is already present in that PL/SQL table. Global variables capture the FND user ID, login ID, and system date for audit column population.

Tables Accessed

• FND_FLEX_VALUE_SETS — Read to validate the value set name and to obtain the flex value set ID.
• FND_FLEX_VALUES — The principal target of the import; segment values are inserted here, with CREATED_BY and LAST_UPDATE_LOGIN populated from FND_GLOBAL.
• FND_FLEX_VALUE_NORM_HIERARCHY — Stores the child range definitions loaded by the NH process.
• FND_FLEX_HIERARCHIES — Referenced for hierarchy structures associated with the value set.
• FND_FLEX_VALIDATION_QUALIFIERS — Consulted for validation qualifier metadata applicable to the values being imported.
• PLITBLM — The standard EBS PL/SQL table handling package, used for array/table processing during bulk import.

Usage Notes

The package is application-internal and is invoked indirectly by the Chart of Accounts Segment Values API. It is referenced by one other package within the APPS schema, so direct calls from custom code should be avoided in favour of the supported API entry point, which manages the sequencing of the two processes. Because the procedures write to core flexfield tables, imports should be performed during planned maintenance windows or when flexfield validation is disabled for the affected structure. User attribution is derived from FND_GLOBAL at package initialisation, so the package must be executed within a session that has a valid FND environment (typically an EBS concurrent request or an OLTP responsibility session). The release header indicates maintenance through 2012, and the object is present in both 12.1.1 and 12.2.2. The "set_msg" search term typically maps to FND_MESSAGE.SET_NAME / SET_TOKEN usage for error reporting; this package reports validation failures through FND message conventions when the supplied value set name cannot be resolved.