Search Results reject_record

Overview

CSL_SERVICEL_WRAPPER_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that functions as a wrapper layer over the Service (CSL) module's service request processing logic. Its primary role is to encapsulate the lower-level Service request handling APIs and expose a simplified, stable interface for applying client-side changes, managing record lifecycle transitions (defer, reject, delete), populating and cleaning up access control records, and formatting error messages. The package body header indicates it has been in production since at least the 11.5.x code line and was shipped into the 12.1.1 and 12.2.2 releases without structural change. Development of the package was maintained by Oracle's Service (CSL/ASG) development team, and it is referenced by twelve other packages, indicating that it occupies a central position in the Service request data model. The package uses a global debug-level variable (g_debug_level) that interoperates with JTM_HOOK_UTIL_PKG and JTM_MESSAGE_LOG_PKG to emit trace messages when the full debug level is enabled, a common Oracle pattern for diagnosing field-level issues.

Key Procedures and Functions

The package exposes ten documented program units:

• APPLY_CLIENT_CHANGES — Applies a set of pending client-side or external changes to the underlying service records, reconciling the caller's intent with the stored data.
• GET_ERROR_MESSAGE_TEXT — Retrieves the human-readable text associated with an error code, typically resolving messages stored in the FND message dictionary.
• DELETE_RECORD — Physically removes a record from the service data model, used when a change or record should be discarded entirely.
• DEFER_RECORD — Marks a record as deferred so it is skipped in the current processing pass and re-evaluated later, without deleting it.
• REJECT_RECORD — Marks a record as rejected, recording that the record was processed and found invalid or unacceptable. The user search term "reject_record" resolves to this program unit.
• POPULATE_ACCESS_RECORDS — Seeds access control records so that the appropriate users, groups, or responsibilities may view or modify the affected service data.
• DELETE_ACCESS_RECORDS — Removes access control records when they are no longer required, for example when a service request is closed or cancelled.
• AUTONOMOUS_MARK_DIRTY — Marks the relevant records as dirty in an autonomous transaction so that the dirty flag survives the caller's subsequent rollback.
• TO — A conversion or transformation helper used to move data between the wrapper's internal format and the calling layer.
• HANDLER — The main dispatching entry point that routes a requested action to the appropriate helper program unit.

Tables Accessed

• FND_NEW_MESSAGES — Read to obtain error and informational message text, underpinning GET_ERROR_MESSAGE_TEXT.
• ASG_USER — The Service user/resource table, read when resolving which users are associated with a record and written to when access records are populated or removed.
• PLITBLM — A PL/SQL index-by table structure used for message handling and related lookups.

Usage Notes

CSL_SERVICEL_WRAPPER_PKG is invoked from the Service (TeleService / Field Service) application tier, typically from Oracle Forms event handlers and occasionally from concurrent programs and custom extensions that must manipulate service request records. Because it is referenced by twelve other packages, direct calls should be made with care; callers should rely on HANDLER as the entry point and let the package dispatch the correct operation. The REJECT_RECORD, DEFER_RECORD, and DELETE_RECORD units are normally called together in a record-processing loop so that each incoming record is either applied, deferred, or rejected. Debug tracing is enabled by setting g_debug_level to JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL, which causes entry and exit messages to be written via JTM_MESSAGE_LOG_PKG.