Search Results c_sdebug

Overview

RLM_REPLACE_SV is a server-side PL/SQL package body owned by APPS within the Oracle E-Business Suite Release Management (RLM) module. Its principal business function is schedule replacement validation for return/repair order flows. Specifically, the package compares a newly received schedule against a previously eligible schedule to determine whether the new schedule supersedes or replaces the prior one. When replacement logic applies, the package records dropped line items and populates a global in-memory list used by downstream processing. This logic supports the RLM "Replace" feature set, which governs whether an existing repair or return schedule should be replaced in whole or in part by an incoming schedule transmitted through the interface tables.

The package is classified as OTHER in the ETRM metadata, indicating it is not a public open-interface API but rather an internal service package invoked by other RLM components. It is referenced by two other packages, confirming its role as a shared utility within the RLM dependency chain.

Key Procedures and Functions

Five procedures or functions are documented under the NAME classification. Based on the package body excerpt, the primary entry point is CompareReplaceSched. This procedure receives an interface header record and a warning-dropped-items indicator, then orchestrates the comparison flow: it establishes the current header and schedule header identifiers, conditionally emits debug output, determines whether a warning is required, locates a previous eligible schedule, and populates the global replacement list. It returns a status flag to the calling wrapper.

• IsWarningNeeded — Evaluates the incoming schedule record and dropped-items indicator to decide whether replacement comparison and warning logic should proceed.
• FindEligibleSched — Locates the previously existing eligible schedule header that may be replaced, returning its header identifier.
• PopulateList — Builds the global list of replacement relationships, correlating the previous header, current header, and current schedule header identifiers (the latter added under Bugfix 8844817).
• Additional procedure/function — A fifth routine is documented but not detailed in the excerpt; it supports the replacement workflow.

Debug instrumentation uses the global l_DEBUG flag and the constant C_SDEBUG, routing trace messages through rlm_core_sv.dpush and rlm_core_sv.dlog. This is the object of the user's search term c_sdebug.

Tables Accessed

The package reads and writes the RLM interface and schedule tables. RLM_INTERFACE_HEADERS and RLM_INTERFACE_LINES (with the _ALL variant) supply incoming schedule data. RLM_SCHEDULE_HEADERS and RLM_SCHEDULE_LINES (_ALL) hold the persisted, previously eligible schedules against which comparison occurs. OE_ORDER_HEADERS and OE_ORDER_LINES_ALL are referenced to link schedules to the underlying order entities. PLITBLM is accessed as the PL/SQL table storage mechanism supporting the global list populated by PopulateList, enabling in-memory accumulation of replacement records for subsequent processing.

Usage Notes

RLM_REPLACE_SV is not invoked directly by end users. It is called from wrapper programs within the RLM schedule replacement flow, typically triggered during interface import or concurrent processing when incoming repair/return schedules are validated against existing schedules. Debugging is controlled via the RLM_DEBUG_MODE profile option; when set, the package emits named trace points through rlm_core_sv. Developers troubleshooting replacement behavior should enable this profile and search logs for C_SDEBUG markers. Because the package is referenced by two other packages, changes to its internal logic can propagate across the RLM replacement chain, warranting regression testing of dependent wrappers.