Search Results g_error_flg

Overview

MSC_CL_PRE_PROCESS is an internal PL/SQL package body in the Oracle EBS Advanced Supply Chain Planning (ASCP) schema MSC. It belongs to the collection (data refresh) layer of the planning engine and performs the pre-processing work that must complete before a planning collection can be launched or before the planning engine consumes collected data. The package body is dominated by global parameters rather than public interfaces, covering collection identifiers, sourcing instances, organization and instance context, refresh mode flags (complete versus incremental, for both general and sourcing/order data), exchange mode settings, and a large family of profile-driven feature switches such as reservation, material, resource, routing, BOM, sourcing, item, UOM, project, and calendar enablement.

In the context of the user search term g_error_flg, this package participates in the error handling and diagnostics conventions used across the MSC collection packages. Global error flags of this style, together with the v_error_no_begin and v_error_no_end range variables declared in this body, are used by the collection utilities to bracket processing phases and record failures into the MSC error tables. The package therefore contributes to both the orchestration of a collection run and the capture of its exceptions.

Key Procedures and Functions

• LAUNCH_MONITOR — Initiates or supervises the monitoring phase of the pre-processing cycle, tracking the progress of a collection request through its initial validation and parameter resolution stages.
• LAUNCH_WORKER — Performs the worker portion of the pre-process, executing the actual collection preparation logic against the parameter set built by the monitor stage.

The remainder of the body is composed of private helper logic and package-level globals, including the configuration and enablement flags listed above, which are initialized from profile options such as MSC_X_CONFIGURATION and from the MSC_ST_UTIL and MSC_UTIL utilities.

Tables Accessed

• MSC_COLLECTION_S / MSC_COLL_PARAMETERS / MSC_CL_REFRESH_S — collection definitions and runtime parameters that drive the pre-process.
• MSC_APPS_INSTANCES / MSC_ITEM_ID_LID / MSC_GROUPS / MSC_GROUP_COMPANIES / MSC_COMPANIES — instance, organization, and grouping context used to scope the data set.
• MSC_BOMS / MSC_ITEM_SUBSTITUTES / MSC_LOCAL_ID_DEMAND / MSC_CALENDAR_MONTHS — the item, structure, demand, and calendar entities pre-processed for the planning run.
• MSC_ERRORS / MSC_ERRORS_S — error capture, which is where conditions signalled through the g_error_flg convention are persisted.
• FND_USER — used to resolve the operating user context for the launch.

Usage Notes

APPS.MSC_CL_PRE_PROCESS is not a public API and is not designed to be called directly from forms or custom code. It is invoked internally by the ASCP collection framework, typically through the concurrent programs that manage collection launches, and is referenced by three other MSC packages as part of the pre-process chain. Customizations should treat it as internal: the supported extension points are the underlying collection parameters and profile options, not the package interface itself. When troubleshooting, the g_error_flg and error-range variables make this package a useful reference for tracing why a collection pre-process terminated.