Results for “edr_invalid_sign_request”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDR_PSIG is the core PL/SQL package body of the Oracle E-Business Suite Electronic Records and Signature (ERES) framework, delivered under the APPS schema. Its primary business function is to manage the lifecycle of electronic records ("e-records") and the electronic signatures applied to them, satisfying regulatory requirements such as FDA 21 CFR Part 11, EU Annex 11, and similar good-practice mandates. The package creates, opens, updates, and closes signature-controlled documents; it records signature intents and results; it captures document-level and signature-level parameters; and it produces the printable output associated with signed records.
The package is classified as OTHER (not a public open interface), reflecting its role as an internal engine invoked by other EBS modules rather than a documented integration API. It is referenced by twelve other packages and therefore sits deep in the dependency tree of the EDR product family. The package header carries the version marker $Header: EDRPSIGB.pls 120.4 2011/03/31, indicating sustained maintenance through several bug fixes, including corrections for timezone validation and child e-record counting.
Key Procedures and Functions
The package exposes twenty-eight documented procedures and functions. Their responsibilities group as follows:
- Document lifecycle: OPENDOCUMENT, CLOSEDOCUMENT, UPDATEDOCUMENT, CHANGEDOCUMENTSTATUS, CANCELDOCUMENT, and DELETEDOCUMENT. These create the e-record, transition its status, refresh its content, or terminate it. CLOSEDOCUMENT finalizes a record and triggers related exception handling such as DOCUMENT_CLOSE_ERROR.
- Signature processing: REQUESTSIGNATURE, POSTSIGNATURE, CANCELSIGNATURE, GETSIGNATUREID, and GETSIGNATUREDETAILS. These support the signature request/response cycle, retrieving the identity of a signer and the detailed audit trail of a completed signature.
- Parameter maintenance: POSTDOCUMENTPARAMETER, DELETEDOCUMENTPARAMETER, DELETEALLDOCUMENTPARAMS, POSTSIGNATUREPARAMETER, DELETESIGNATUREPARAMETER, and DELETEALLSIGNATUREPARAMS. These manage the key-value pairs attached to documents and signatures.
- Query and status: GETDOCUMENTDETAILS, GET_DOCUMENT_STATUS (implemented via the VERIFY_TIMEZONE pattern in the body), GET_ADHOC_STATUS, and UPDATEPRINTCOUNT.
- Ad hoc signer management: DELETE_ADHOC_USER.
- Internal exception declarations: TIMEZONE_ERROR, DOCUMENT_NOT_FOUND, DOCUMENT_PENDING, DOCUMENT_CLOSE_ERROR, EDR_GENERIC_ERROR, EDR_INVALID_DOC_STATUS, EDR_INVALID_DOC_TRAN, EDR_INVALID_SIGN_REQUEST, EDR_INVALID_USER, and EDR_DUPLICATE_SIGNER.
VERIFY_TIMEZONE compares the database server timezone from FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE against the profile option EDR_SERVER_TIMEZONE, raising EDR_PSIG_TIMEZONE_ERROR when they diverge or when either value is null.
Tables Accessed
The package reads and writes the following APPS synonyms:
- EDR_PSIG_DOCUMENTS / _S: document master records and their audit shadow table.
- EDR_PSIG_DETAILS / _S: document line-level detail and its audit shadow.
- EDR_PSIG_PARAMS_S: parameters associated with signatures and documents.
- EDR_PSIG_PRINT_HISTORY: tracks print events via UPDATEPRINTCOUNT.
- EDR_EVENT_RELATIONSHIP and EDR_TRANS_ACKN: link e-records to the transactions and acknowledgements they govern.
- FND_USER: resolves signer identity.
- XMLTYPE, DBMS_XMLGEN, XMLAGG, PLITBLM, DUAL: used to assemble XML payloads and reference data for signature processing.
Usage Notes
EDR_PSIG is normally invoked indirectly. EBS forms and OA framework pages that present signature-controlled transactions call these procedures to open a document before data entry and to close it after commit; concurrent programs invoke it to finalize, print, or archive signed records. Custom code should call the package through the documented procedure names rather than querying the underlying tables, because the procedures enforce timezone validation, status transitions, and audit shadow-table writes that maintain regulatory compliance. Because the package is not a public API, customers should validate inter-version behavior between 12.1.1 and 12.2.2, where profile and message definitions (EDR_SERVER_TIMEZONE, EDR_PSIG_TIMEZONE_ERROR) must be present for VERIFY_TIMEZONE to succeed.
-
PACKAGE BODY: APPS.EDR_PSIG 12.2.2
-
PACKAGE BODY: APPS.EDR_PSIG 12.1.1