Search Results ar_cmgt_wf_debug_file
Overview
APPS.AR_CMGT_UTIL is a shared utility package body belonging to the Oracle E-Business Suite Credit Management (CMGT) module, the component of Oracle Receivables that governs customer credit reviews, credit case folders, and credit analyst workflow. The package is classified as a UTIL object, meaning it does not represent a business transaction API in its own right but instead supplies reusable helper logic consumed by the forms, workflow activities, and concurrent programs that make up Credit Management. Its responsibilities span debugging and diagnostics, permissions validation, employee-and-resource resolution, credit analyst identification, checklist management, case folder validation, and reference data handling. The header comment reflects a 12.1.1-era build (120.28.12010000.2), and the object remains documented for 12.2.2 with thirty public procedures and functions; it is referenced by sixteen other packages, confirming its role as a low-level dependency within the CMGT stack.
Key Procedures and Functions
The package groups its documented routines into several functional clusters.
- Diagnostics: DEBUG, WF_DEBUG, and GET_WF_DEBUG_FLAG provide logging. DEBUG routes messages through FND_LOG subject to the current runtime log level, while WF_DEBUG writes to a file path and filename derived from the AR_CMGT_WF_DEBUG profile, because standard FND debugging behaves inconsistently when execution passes through Workflow.
- Security and permissions: CHECK_UPDATE_PERMISSIONS and CHECK_DELETE_PERMISSIONS determine whether the current user may modify or remove credit management records; CHECK_EMP_CREDIT_ANALYST and CHECK_CREDIT_ANALYST validate whether a person or resource qualifies as a credit analyst.
- Analyst and resource resolution: GET_CREDIT_ANALYST_NAME, GET_FND_USER_NAME, GET_PERSON_BASED_ON_RESOURCE, and GET_PERSON_BASED_ON_CF resolve display names and map an Oracle resource or case folder back to the underlying person record. These are the routines most closely associated with the search term "get_resource_analyst," whose behavior is delivered through this resolution family.
- Checklist handling: FIND_ANALYSIS_LEVEL, GET_NO_OF_REF_DATA_POINTS, COPY_CHECKLIST_DATA_POINTS, and IS_DUPLICATE_CHECKLIST support scoring and checklist setup, including detection of duplicated checklist definitions.
- Case and reference validation: CHECK_CASEFOLDER_EXISTS, IS_VALID_DATE, GET_LATEST_CF_NUMBER, GET_LIMIT_CURRENCY, and ISAPPLICATIONEXISTS provide existence checks, currency and limit retrieval, and application validation.
Tables Accessed
The package reads and writes the core Credit Management schema through APPS synonyms. AR_CMGT_SETUP_OPTIONS supplies configuration; AR_CMGT_CASE_FOLDERS, AR_CMGT_CF_DTLS, AR_CMGT_CHECK_LISTS, AR_CMGT_CHECK_LIST_DTLS, and AR_CMGT_CREDIT_REQUESTS hold the transaction and setup data for credit reviews. FND_USER supports user name resolution, and WF_NOTIFICATIONS is consulted for workflow notification context. HZ_CUST_ACCOUNTS provides customer account identity, while JTF_RS_RESOURCE_EXTNS and JTF_RS_ROLE_RELATIONS supply resource and role data used to determine analysts and their assignments. PER_ALL_PEOPLE_F provides the HR person records behind resources. FND_CURRENCIES supports currency retrieval, DUAL is used for scalar evaluation, and PLITBLM is the standard PL/SQL index-by table type used for internal collections.
Usage Notes
AR_CMGT_UTIL is not intended for direct end-user invocation. It is called from Credit Management forms and workflow background processes, and from the sixteen dependent packages that rely on its permission, resolution, and validation logic. Customizations that extend credit analyst assignment, checklist copying, or case folder creation should call these routines rather than reimplementing the checks, since the permission and analyst validation routines encode the security rules enforced elsewhere in the module. Debug behavior should be enabled only in controlled environments: the workflow debug routines write to operating-system files, so the AR_CMGT_WF_DEBUG, AR_CMGT_WF_DEBUG_FILE, and AR_CMGT_WF_DEBUG_PATH profiles must be set deliberately. The universal FND debug switch is AFLOG_ENABLED.