Search Results c_warning

Overview

MSD_CONC_LOG_UTIL is a utility package body owned by APPS within the Oracle E-Business Suite environment. Its classification in the ETRM metadata is UTIL, indicating that it provides shared infrastructure services rather than application-specific business logic. The package is designed to standardize logging, message classification, and concurrent program result-code handling. It accepts text messages produced during execution, determines their severity, and writes them to the concurrent manager log file through the FND_FILE API. By centralizing these operations, the package ensures consistent output formatting and result propagation across all concurrent programs that depend on it. The header comment references version 115.4, dated November 2002, which reflects the package's long-standing role in the MSD product family.

Key Procedures and Functions

• Initialize — Resets the package-level state variables, including the last message type, return code, result string, and output destination. An overloaded form accepts an output destination argument, allowing callers to direct messages to either the FNDFILE log or the server output.
• Display_Message — The primary message-writing routine. It accepts message text and a message type, then formats and emits the line. Section, information, and heading types are handled with distinct formatting rules, while error, warning, and fatal conditions trigger result-code calculation.
• Result — Returns the accumulated result value, reflecting the highest-severity condition encountered during the run.
• Retcode — Returns the numeric return code corresponding to the accumulated result, suitable for assignment to the concurrent program completion status.

A privately scoped helper, calc_result, maps message types to return codes: fatal errors yield 4, errors yield 2, and warnings yield 1. The constant C_WARNING is the key value relevant to the user's search, appearing both in the comparison within calc_result and in the severity check at the end of display_message.

Tables Accessed

The documented metadata lists no base tables or APPS synonyms accessed by this package. It operates purely on PL/SQL variables and the FND_FILE logging facility. The absence of table references confirms its role as a stateless-form utility rather than a data-processing unit.

Usage Notes

MSD_CONC_LOG_UTIL is referenced by two other packages and is typically invoked from concurrent program logic. Callers first invoke Initialize, then call Display_Message throughout execution, passing C_WARNING or other severity constants as appropriate. Upon completion, the program reads Result and Retcode to populate its completion status. Warnings raised via C_WARNING increment the return code to 1, allowing the concurrent manager to report partial success. Because the package writes directly to the FND_FILE log, output is visible in the standard concurrent request log, and custom code should not bypass it if consistent formatting and severity tracking are required.