Search Results edw_message_s

Overview

EDW_MESSAGE_S is a shared utility package in the APPS schema of Oracle E-Business Suite, part of the EDW (Enterprise Data Warehouse / E-Business Data Warehouse) common services layer. Its header identifies it as an AUTHID CURRENT_USER package, meaning its SQL statements execute under the privileges of the calling user rather than the package owner. Unlike functional APIs such as order or invoice processing packages, EDW_MESSAGE_S provides standardized error-handling and message-resolution services used across the EDW modules. It centralizes two distinct concerns: raising application-level errors in a consistent, translatable fashion, and surfacing SQL-level errors with enough context (routine name, location, error code) to support diagnosis and logging. In EBS 12.1.1 and 12.2.2 the APPS.EDW_MESSAGE_S package remains available as part of the APPS schema object set, and its API classification is recorded as OTHER rather than a public or private functional API, reinforcing its role as an internal infrastructure component rather than a business transaction endpoint.

Key Procedures and Functions

• SQL_ERROR — Raises a database error condition. It accepts the calling routine name, a location identifier, and an Oracle error code, allowing the caller to report a native SQL failure with traceable context.
• APP_ERROR — Overloaded application error procedure that raises a user-facing error message. Multiple overloads exist: one accepting only an error name, and additional variants that accept up to four token/value pairs. This token substitution mechanism allows dynamic runtime values (such as an order number, customer name, or identifier) to be merged into a predefined, translatable message template.
• SQL_SHOW_ERROR — Displays or retrieves the most recently raised SQL error. It is typically used in exception handlers to present the stored error message to the user or to a calling program.
• APP_SET_NAME — Establishes the name of the application (or message source) used for subsequent message lookups, so that APP_ERROR resolves message names against the correct application message repository.
• CLEAR — Resets the package's internal state, including the global routine (g_routine) and location (g_location) variables used to track context across a call sequence.

Tables Accessed

The documented metadata does not list any tables directly referenced through APPS synonyms within this package's own body. The package instead relies on the standard EBS message infrastructure (Oracle Forms / FND message facilities) to resolve the error names passed to APP_ERROR and APP_SET_NAME, and on the Oracle RDBMS error stack for the SQL_ERROR path. Because the package is compiled AUTHID CURRENT_USER, any message or lookup access it performs is subject to the invoking user's privileges rather than the APPS owner's.

Usage Notes

EDW_MESSAGE_S is intended to be invoked from PL/SQL code executing in the EDW application context — typically from stored procedures, EDW-specific concurrent programs, or custom extensions that need to raise errors in a consistent, translatable manner. The metadata records that it is referenced by zero other packages, indicating it is not a dependency of the standard EBS package tree and must be called explicitly. The typical pattern is: a caller sets the message source with APP_SET_NAME, performs its processing, and on failure invokes APP_ERROR (with token/value pairs for dynamic content) for application-level problems, or SQL_ERROR for database-level exceptions. SQL_SHOW_ERROR and CLEAR are used in exception handlers and cleanup paths to surface and reset error state. In 12.1.1 and 12.2.2, customizations that reference this package should confirm the APPS.EDW_MESSAGE_S synonym is valid, since the package is an internal EDW utility and its presence depends on the EDW product tier installed.