Search Results error_segment

Overview

FND_FLEX_KEYVAL is the low-level server validation API for Oracle E-Business Suite key flexfields. Declared with AUTHID CURRENT_USER, it exposes the complete key flexfield validation engine, allowing callers to look up or create flexfield combinations and to interrogate the outcome of that operation through a set of package globals. The package is the foundation on which the higher-level FND_FLEX_EXT routines are built; the header explicitly recommends FND_FLEX_EXT where possible, noting that FND_FLEX_KEYVAL's generality makes it harder to use. Its central entry points are VALIDATE_SEGS and VALIDATE_CCID, which accept segment values or a combination identifier respectively, perform the lookup or creation of the combination, and return TRUE on success or FALSE on error. Results, including error messages, are not passed back directly but are written to package globals that the remaining functions expose; those globals are reset on each validation call, so a caller must retrieve every needed value before submitting the next combination. The package is classified as OTHER and is referenced by 106 other packages, confirming its role as shared infrastructure across the EBS schema. The IS_SECURED function is among the status accessors queried after validation.

Key Procedures and Functions

• VALIDATE_SEGS and VALIDATE_CCID — the primary validation routines, invoked with segment values or a combination ID. They look up or create the desired combination, return TRUE when successful and FALSE on error, and populate the package globals.
• IS_VALID, IS_SECURED, VALUE_ERROR, UNSUPPORTED_ERROR, SERIOUS_ERROR — the status functions, always set after each validation call. IS_SECURED reports whether the resulting combination is subject to flexfield security rules; IS_VALID reports overall validity, and the remaining three classify the severity or nature of a failure.
• ERROR_SEGMENT, ERROR_MESSAGE, ENCODED_ERROR_MESSAGE — the error message functions, used to identify the offending segment and to retrieve human-readable or encoded diagnostic text.
• NEW_COMBINATION — indicates whether validation caused a new combination to be created.
• COMBINATION_ID, SEGMENT_DELIMITER, CONCATENATED_VALUES, CONCATENATED_IDS, CONCATENATED_DESCRIPTIONS — combination information functions returning the resolved combination identifier and its concatenated representations.
• ENABLED_FLAG, SUMMARY_FLAG, START_DATE, END_DATE — attribute accessors describing the state and effective dating of the validated combination.

Tables Accessed

The ETRM metadata for this object does not enumerate the underlying tables reached through APPS synonyms. Functionally, the package reads and writes the key flexfields definition and combination tables that store segment structures, valid combinations, concatenated descriptions, enabled and summary flags, and effective dates, and it consults the flexfield security rule definitions that determine the outcome reported by IS_SECURED. It may also insert into the combinations table when VALIDATE_SEGS or VALIDATE_CCID is permitted to create a new combination.

Usage Notes

FND_FLEX_KEYVAL is normally invoked from PL/SQL — custom forms logic, concurrent programs, interfaces, and other server-side code — rather than directly by end users. A caller executes VALIDATE_SEGS or VALIDATE_CCID, inspects IS_VALID and the other status functions, then immediately reads any needed error messages and combination attributes, because the globals are overwritten on the next validation. The presence of IS_SECURED allows callers to respect flexfield security independent of general validity, and the error functions support precise diagnostics against the failing segment. Oracle recommends FND_FLEX_EXT for most development; direct use of FND_FLEX_KEYVAL is appropriate when its finer-grained control over results is required.