Search Results g_msg_level

Overview

LNS_DEFAULT_HOOKS_PVT is a private PL/SQL package body in the APPS schema that supplies defaulting logic for the Oracle Loans (LNS) module. In Oracle EBS 12.1.1 and 12.2.2, the Loans application uses hook packages to allow customers to override or extend standard defaulting behavior without modifying seeded code. LNS_DEFAULT_HOOKS_PVT provides the baseline, out-of-the-box implementation of these hooks. It is classified as a PVT package, meaning it is intended for internal invocation by the Loans application and attached public APIs rather than direct end-user or third-party calls.

The package header comment records its version as 120.0.12010000.1, dated 02-JUL-2009. The creation history attributes the package to author scherkas on 04-02-2008, with the package globals G_PKG_NAME, G_LOG_ENABLED, and G_MSG_LEVEL declared at the top of the body.

Key Procedures and Functions

Two routines are documented in the excerpt: one private and one public.

• LogMessage (private procedure) — Writes debug and diagnostic messages. It accepts a message level and the message text. When the supplied level meets or exceeds the package global G_MSG_LEVEL, the message is forwarded to FND_LOG.STRING and, if a concurrent request context exists (FND_GLOBAL.Conc_Request_Id is not null), also written to the concurrent manager log via fnd_file.put_line and FND_FILE.LOG. The procedure traps WHEN OTHERS and recursively logs unexpected errors at FND_LOG.LEVEL_UNEXPECTED. No corresponding function is exposed.
• SHIFT_PAY_START_DATES (public procedure) — Implements the default algorithm for shifting the first interest payment date and the first principal payment date on a full disbursement payment in Oracle Payables (AP). The recalculated dates are returned to the calling program. This hook allows the standard Loans disbursement flow to adjust amortization schedules when AP processes a full disbursement.

Tables Accessed

The ETRM metadata does not document any direct table references through APPS synonyms for this package. The routines shown operate on in-memory parameters and return values rather than issuing DML against Loans or Payables base tables. Diagnostic output is written through the FND logging infrastructure (FND_LOG and FND_FILE), which are the only underlying database objects exercised by the excerpted code. Any table access performed by the public SHIFT_PAY_START_DATES routine is not enumerated in the available documentation and should be confirmed by reviewing the full package source in the target environment.

Usage Notes

LNS_DEFAULT_HOOKS_PVT is not a standalone entry point. It is referenced by the Loans application code path during Payables full-disbursement processing, where the SHIFT_PAY_START_DATES guideline is consulted to derive default payment start dates. Because the package is classified PVT and the metadata records zero packages referencing it, customers should not call it directly; instead, customization should be implemented by cloning or extending the hook in an approved extension schema, leaving LNS_DEFAULT_HOOKS_PVT as the fallback when no custom hook exists.

The presence of G_MSG_LEVEL and the LogMessage routine means debugging can be elevated dynamically by initializing the global before invocation — relevant to the reported search term "g_msg_level." In Oracle EBS 12.1.1 and 12.2.2, diagnostics surface either in the FND log tables or in the concurrent request log, depending on whether a concurrent request identifier is bound at runtime.