Search Results get_tl_omfs_palm_resources

Overview

CSM_UTIL_PKG is a foundational utility package in the Oracle E-Business Suite Field Service (CSM) product family. It provides the shared infrastructure used by the Field Service application to synchronize the mobile "Palm" or handheld client with the server-side database — the mechanism historically branded as Mobile Field Service (MFS) and, in later releases, as the Oracle Field Service disconnected client. The package owns the dirty-queue logic that marks records as modified so they can be pushed to connected devices, resolves user, responsibility and language context, and performs deferred and rejected transaction handling.

A secondary use is diagnostic support: the package exposes a tiered debug-level facility, ranging from no logging (0) through error-only (1), functional messaging (2), SQL tracing (3) and full debug (4), allowing Field Service developers to instrument synchronization routines without recompiling dependent code. The presence of strongly-typed PL/SQL record types, such as the ACC refresh descriptor and the changed-records REF CURSOR, indicates that the package also centralises the descriptor metadata needed to refresh access-control (ACC) tables from backend tables and their translation (TL) counterparts.

Key Procedures and Functions

With over fifty documented entry points, the package serves several functional clusters:

• Debug support: GET_DEBUG_LEVEL returns the currently configured debug level.
• Session context resolution: GET_LOCALTIME, GET_RESPONSIBILITY_ID, GET_USER_NAME and GET_USER_LANGUAGE derive the caller's local time, responsibility, user name and language — information essential when formatting data for handheld clients.
• Dirty-queue management: MAKEDIRTYFORUSER and MAKEDIRTYFORRESOURCE flag records as changed for a specific user or resource, driving the sync publication mechanism.
• Palm resource and user resolution: GET_TL_OMFS_PALM_RESOURCES and GET_TL_OMFS_PALM_USERS retrieve translated lists of Palm-eligible resources and users, while IS_PALM_RESOURCE and IS_PALM_USER test eligibility, and GET_ALL_OMFS_PALM_RES_LIST / GET_ALL_OMFS_PALM_USER_LIST return the full sets.
• Dissemination constants: GETASGDMLCONSTANT supplies standard DML constant values used by the dissemination (ASG) layer.
• Refresh processing: REFRESH_ALL_APP_LEVEL_ACC and the ACC_Refresh_Desc_Tbl_Type descriptor collection coordinate synchronisation between backend tables and access tables, including translation tables.
• Deferred and rejected transactions: DELETE_RECORD, DEFER_RECORD and REJECT_RECORD handle records that cannot be applied immediately, moving them into the appropriate queue.
• Error and task utilities: GET_ERROR_MESSAGE_TEXT and GET_TASK_ESC_LEVEL support error messaging and task escalation-level retrieval.

Tables Accessed

The package touches a mixture of Foundation, Application Object Library and Field Service tables through APPS synonyms. FND_USER, FND_LANGUAGES and FND_APPLICATION are consulted for user, language and application context; FND_NEW_MESSAGES supplies error text. The dissemination layer is represented by ASG_USER, ASG_USER_PUB_RESPS, ASG_PUB_ITEM, ASG_SYSTEM_DIRTY_QUEUE, ASG_DELETE_QUEUE and ASG_DEFERRED_TRANINFO, which together record subscriptions, dirty records and deferred or deleted transactions. Field Service-specific data resides in CSF_DEBRIEF_HEADERS, CSM_HTML5_PARSED_DATA, CSM_DEFERRED_NFN_INFO and CSM_UNIT_OF_MEASURE_TL_ACC. Inventory and unit-of-measure context comes from MTL_UNITS_OF_MEASURE.

Usage Notes

CSM_UTIL_PKG is not an end-user API; it is invoked internally by the Field Service forms, concurrent programs and synchronization routines that build and transmit the handheld data set. Because it is referenced by 133 other packages, customisations should call its documented functions rather than duplicating their logic, and any changes to its specification require recompilation of all dependents. Sites extending Mobile Field Service should verify that resource and user eligibility queries remain consistent with IS_PALM_RESOURCE and IS_PALM_USER, since these govern which records are dispatched to disconnected clients.