Search Results psb_message_s




Overview
Explore in AI Chat

Overview

The APPS.PSB_MESSAGE_S package body is a supporting PL/SQL utility within the Oracle E-Business Suite (EBS) Public Sector / Budgeting (PSB) product family. Its documented status is VALID, and its API classification is OTHER, indicating that it is an internal infrastructure package rather than a public application programming interface intended for external invocation. The package provides a centralized mechanism for storing, retrieving, and presenting error and success messages generated during batch processing and concurrent program execution. It abstracts the standard Oracle Application Object Library (AOL) messaging stack — namely FND_MESSAGE, FND_MSG_PUB, FND_API, FND_FILE, and FND_GLOBAL — into a form that is convenient for batch-oriented PSB processes. By consolidating message handling in one place, it enforces consistent message formatting and logging behavior across the modules that consume it. The metadata notes that the package is referenced by twenty other packages, confirming its role as a shared dependency in the PSB codebase.

Key Procedures and Functions

Eight documented procedures and functions comprise the public surface of this package body. The GET function serves as the general-purpose retrieval routine for obtaining message content from the message repository. GET_ERROR_MESSAGE and GET_SUCCESS_MESSAGE return the formatted text for error and success conditions respectively, allowing callers to construct user-facing or log-facing output. GET_ERROR_STACK retrieves the accumulated stack of error messages from the FND message stack, which is essential when multiple validation failures must be reported together. For persistence, INSERT_ERROR records a single error message into the message table, while BATCH_INSERT_ERROR performs the same operation for multiple messages in a single call, improving efficiency during high-volume processing. Finally, PRINT_ERROR and PRINT_SUCCESS direct error and success output to the appropriate destinations, typically the concurrent program log or output file through FND_FILE. Parameter lists are not documented in the available metadata and should be confirmed against the live package specification in the target environment.

Tables Accessed

The package reads from and writes to the PSB_ERROR_MESSAGES table via its APPS synonym. This table stores the message definitions or message instances that the insertion routines populate and the retrieval routines read. It is the only application table documented as a dependency. All remaining dependencies are Oracle AOL and PL/SQL infrastructure components: FND_API, FND_FILE, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and the SYS.STANDARD package. The package body additionally refers to itself (PSB_MESSAGE_S), indicating internal call patterns between its own routines.

Usage Notes

PSB_MESSAGE_S is typically invoked indirectly by other PSB packages rather than called directly from Oracle Forms or custom code. Because it is not referenced by any database object, it functions as a leaf-level utility in the dependency graph and is safe to invoke from PL/SQL batch logic. Its message-printing routines are most relevant to concurrent programs, where output must be written to the log and report files using FND_FILE conventions. When an error occurs during batch validation or data loading, callers use INSERT_ERROR or BATCH_INSERT_ERROR to persist the failure, then GET_ERROR_STACK and PRINT_ERROR to surface it. Because the package is classified as OTHER and is undocumented as a formal API, customizations should mirror the established patterns in the twenty dependent packages rather than relying on undocumented signatures, and any direct use should be validated against the specific EBS 12.1.1 or 12.2.2 instance.