Search Results csm_util_pkg




Overview
Explore in AI Chat

Overview

CSM_UTIL_PKG is a utility package in the Oracle E-Business Suite APPS schema that supports the Service (CSM/CSF) and Field Service (ASG/JTM) product families. It provides the shared runtime plumbing used across the Service application modules: user, resource, and responsibility resolution; Palm/OMFS field-synchronization lookups; multilingual message retrieval; profile and debug-level access; task escalation level determination; and the dirty-record, deferral, and rejection mechanics required to keep mobile field devices and the central database synchronized. The package is also used to control and inspect the application-level accounting refresh and the publication of service data through the ASG (Advanced Service Gateway) interfaces.

The package body is classified as OTHER under the ETRM 12.2.2 catalog and is marked VALID. It exposes 51 documented procedures and functions, and it is referenced by 133 other database objects, making it a foundational internal API rather than a standalone user-facing program.

Key Procedures and Functions

  • GET_DEBUG_LEVEL — Returns the current debug/verbosity setting, used to gate FND_LOG diagnostics throughout the Service modules.
  • GETLOCALTIME — Returns the current local time, respecting the session or user time zone.
  • GET_RESPONSIBILITY_ID — Resolves the responsibility identifier for the current session.
  • GET_USER_NAME — Returns the display or user name for a given user, used in messages and audit fields.
  • MAKEDIRTYFORUSER / MAKEDIRTYFORRESOURCE — Flag user or resource records as dirty so that the ASG dirty-queue processes pick them up for re-synchronization to field devices.
  • GETASGDMLCONSTANT — Retrieves an ASG DML constant used when building or interpreting synchronization operations.
  • GET_TL_OMFS_PALM_RESOURCES / GET_TL_OMFS_PALM_USERS — Return the translated list of Palm (OMFS) resources or users for a given language.
  • IS_PALM_RESOURCE / IS_PALM_USER — Predicates that test whether a resource or user participates in the Palm/OMFS synchronization set.
  • GET_ALL_OMFS_PALM_RES_LIST / GET_ALL_OMFS_PALM_USER_LIST — Return the complete set of OMFS Palm resources or users, typically for bulk processing or publication.
  • GET_USER_LANGUAGE — Resolves the language assigned to a user, driving the TL (translated) lookups used elsewhere in the package.
  • REFRESH_ALL_APP_LEVEL_ACC — Refreshes all application-level accounting access records; used when accounting configuration changes.
  • GET_ERROR_MESSAGE_TEXT — Returns the formatted text of an error message from FND_MESSAGE/FND_MSG_PUB for display or logging.
  • DELETE_RECORD — Submits a record for deletion as part of the ASG delete-queue workflow.
  • DEFER_RECORD — Defers a record, writing it to the deferred transaction information structures so it is processed in a later synchronization cycle.
  • REJECT_RECORD — Rejects a record, recording the rejection with an associated reason.
  • GET_TASK_ESC_LEVEL — Determines the escalation level for a service task, based on the task and profile configuration.

Tables Accessed

The package reads and writes the core Service and synchronization tables. User and security context is drawn from FND_USER, FND_APPLICATION, FND_LANGUAGES, ASG_USER, and ASG_USER_PUB_RESPS; resource data comes from the JTF_RS family (JTF_RS_GROUPS_B, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, JTF_RS_RESOURCE_EXTNS) and PER_ALL_PEOPLE_F. Synchronization state is maintained in ASG_PUB_ITEM, ASG_SYSTEM_DIRTY_QUEUE, ASG_DEFERRED_TRANINFO, and ASG_DELETE_QUEUE. Service transactions and debrief data reside in CSF_DEBRIEF_HEADERS, JTM_CON_REQUEST_DATA, and the CSM tables CSM_DEFERRED_NFN_INFO, CSM_HTML5_PARSED_DATA, and CSM_UNIT_OF_MEASURE_TL_ACC. Unit-of-measure conversion reads MTL_UNITS_OF_MEASURE and MTL_UOM_CONVERSIONS. Message text uses FND_NEW_MESSAGES and WF_NOTIFICATION, and task objects are read from JTF_TASKS_B and JTF_TASK_REFERENCES_VL.

Usage Notes

CSM_UTIL_PKG is invoked primarily from other PL/SQL packages, forms, and concurrent programs within the Service and Field Service modules; it is not intended for direct end-user invocation. The 133 inbound references confirm its role as a common library: callers rely on it rather than duplicating user, resource, language, and dirty-queue logic. Given the SYSDATE-sensitive and FND_PROFILE-dependent procedures, session initialization should precede calls into the package. Because it participates in mobile synchronization and accounting access refresh, changes to its behavior affect field-device data integrity, so the package should be treated as a supported internal API and modified only through Oracle patches or validated extensions.