Search Results std_exc_handler

Overview

OE_GENERATE is a code-generation utility package in the Oracle E-Business Suite Order Management (OE) module. Rather than implementing order-entry business logic directly, this package functions as an internal generator that produces PL/SQL source code, most notably the API and validation scaffolding used by the Trading Community and Order Management attribute frameworks. The package is owned by APPS and is classified as OTHER under the ETRM API classification, indicating that it is a supporting or infrastructure package rather than a public application programming interface.

The package centers on a metadata-driven model. It declares a rich Attribute_Rec_Type record that captures the name, column, code, value, value type, data type, length, context flag, category, database attribute flag, primary-key flag and three generic text columns for each attribute. A corresponding Entity_Rec_Type record describes entities via name, plural name, table, read view, parent, multiplicity and code. Both record types are collected into associative-array table types (g_attr_tbl and g_entity_tbl), and the package defines missing constants plus global type and category constants. The variable referenced in the user search, g_cat_desc_flex, is the descriptive flexfield category constant (G_CAT_DESC_FLEX NUMBER := 2), one of three category markers alongside regular (1) and key flexfield (3). These constants let callers classify attributes so that the generator emits the correct validation and storage code for descriptive flexfield segments.

Key Procedures and Functions

The 64 documented routines form a small code-generation and diagnostic toolkit:

• API_PARAMETERS, API_HEADER, PKG_HEADER, PKG_END, PARAMETER, ELEMENT: emit the structural skeleton of a generated package, including headers, parameter lists and individual elements.
• VARIABLE, ASSIGN, TEXT, COMMENT: generate declarations, assignments, literal text and comments within the produced source.
• CHECK_STATUS, CALL_PARAM, END_CALL: build status checks and procedure-call argument sequences in generated code.
• GET_MSG, MSG, ERROR_MSG, EXC_MSG: retrieve and emit standard and error messages, plus exception-message text.
• LOG_COMPILE, STD_EXC_HANDLER, OTHERS_EXC: log compilation activity and provide standard and catch-all exception handlers.

Tables Accessed

The package references three database objects through APPS synonyms: UTL_FILE, DBMS_SQL and PLITBLM. UTL_FILE is used to write generated source to the file system, DBMS_SQL supports dynamic SQL execution or introspection during generation, and PLITBLM (the PL/SQL integer table body) supports the associative-array collections declared for attributes and entities. The metadata does not identify any application base tables, consistent with the package acting on in-memory metadata records rather than order data.

Usage Notes

OE_GENERATE is not normally invoked by end users or standard Forms. It is a developer and installation-time utility, called during patching, setup or when generating API and flexfield-handling code for the attribute model. Its emitted code and the G_CAT_DESC_FLEX constant are consumed by custom or Oracle-supplied generation routines. Because it is a generator with limited documentation, customizations should avoid modifying it and should rely on the documented procedures. Fifteen other packages reference it, confirming its role as a shared infrastructure component that must remain backward compatible across EBS 12.1.1 and 12.2.2.