Search Results fm_submit_req_v1

Overview

JTF_FM_UTL_V is a utility package body in the Oracle EBS Applications (APPS) schema that supports the CRM Foundation File Manager (JTF_FM) subsystem. Its primary business function is to provide reusable helper logic for the submission, tracking, formatting, and retrieval of outbound document requests generated through the File Manager framework. These requests commonly drive multi-channel delivery of documents such as email attachments, printable output, and message content rendered for the Oracle EBS user interface. The package encapsulates routine operations that surround a request lifecycle: validating document content types, determining whether a request is printable as an RTF or PDF artifact, constructing and posting messages, capturing error conditions, and submitting a formatted request through the FM_SUBMIT_REQ_V1 entry point. Because it is a utility ("UTL") package, it is not intended to be called directly by end users. Instead, it is invoked by other File Manager packages and dependent modules that require consistent, centralized handling of request-related operations.

Key Procedures and Functions

• CONFIRM_PASTA_PRINTABLE — Evaluates a request's content to determine whether it can be treated as "PASTA printable." It iterates distinct content numbers and their document types, and returns a flag indicating printability only when document types such as APPLICATION/RTF or APPLICATION/PDF are present across the request content.
• CONFIRM_RTF, CONFIRM_PDF, CONFIRM_TEXT_HTML — Validation helpers that confirm whether the content or media type conforms to the RTF, PDF, or text/HTML formats respectively, supporting correct rendering and delivery decisions.
• GET_MESSAGE, POST_MESSAGE, GET_POST_MESSAGE, PRINT_MESSAGE — Message handling routines used to retrieve, post, retrieve-and-post, and print message content associated with File Manager requests.
• ADD_ERROR_MESSAGE, GET_ERROR_MESSAGE, HANDLE_ERROR — Error management utilities that register error messages, retrieve accumulated errors, and centralize error handling for calling programs.
• INSERT_EMAIL_STATS — Records email delivery statistics into the email statistics table for auditing and reporting.
• IS_FLD_VALID — Performs a field-level validation check used by the package's other routines.
• GET_ENCODING, REPLACE_TAG — Retrieve encoding information and perform tag substitution within message or document content.
• GET_MEDIA, GET_MEDIA_TYPE, GET_DTD — Retrieve media content, its media type, and the associated document type definition used in XML-based processing.
• FM_SUBMIT_REQ_V1 — The documented submission routine corresponding to the search term. It serves as the versioned entry point for submitting a File Manager request, coordinating the validation, content, and message utilities of the package.

Tables Accessed

The package reads and writes several CRM Foundation tables through APPS synonyms. JTF_FM_REQUEST_CONTENTS is central to CONFIRM_PASTA_PRINTABLE and related validations, since it holds the request's content numbers and document types. JTF_FM_REQUEST_HISTORY_ALL tracks the request lifecycle and status history. JTF_FM_SERVICE_ALL and JTF_FM_STATUS_ALL provide service definitions and status lookups used when managing requests. JTF_FM_EMAIL_STATS receives rows inserted by INSERT_EMAIL_STATS. JTF_FM_GROUPS_ALL and JTF_FM_GROUP_FND_USER associate File Manager groups with FND users. FND_LOBS is referenced for large object storage, and DUAL is used for scalar operations. The package also leverages the standard PL/SQL packages DBMS_AQ, DBMS_LOB, UTL_RAW, and XMLPARSER for advanced queueing, large object manipulation, raw data conversion, and XML parsing respectively.

Usage Notes

JTF_FM_UTL_V is an internal utility rather than a user-facing API. It is typically invoked from other File Manager PL/SQL packages, concurrent programs that render or deliver documents, and customized extensions that must submit requests or validate document types. The documented package is referenced by three other packages, confirming its role as a shared dependency within the File Manager framework. Customizations that require direct submission of a File Manager request would call FM_SUBMIT_REQ_V1 or the public wrapper routines, while format-specific checks should use the CONFIRM_* and GET_MEDIA* functions. Because behavior such as PASTA printability depends on the content types present, callers should ensure request contents are populated before invoking these validations. The package is classified as an OTHER API, meaning Oracle does not guarantee its signature across releases; custom code should be validated against the specific EBS release (12.1.1 or 12.2.2) in use.