setQualityCollectionTxn1227.txp

QualityCollectionTxn1227.txp

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.

bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables). In the process, it sets two flags (IS_INSERT and IS_UPDATE) to determine whether the incoming document contains Insert Transactions, Update Transactions, or both.

getOrgIdAndCode is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORGANIZATION_NAME as the input parameter, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID and ORGANIZATION_CODE corresponding to the ORGANIZATION_NAME.

getWIPEntityId is a transformer for mapping the business document that takes the WIP_ENTITY_NAME as input, and returns WIP_ENTITY_ID.

insertTypeLookUp converts the incoming insert type to a value.

getPOAgentId is a transformer that takes FULL_NAME as input, and returns the Agent ID by querying the database.

checkInsertType checks the type of actions to import the data into the production table. There can be two modes of import: insert and update. This service checks the incoming data string for the mode, and sets the IS_INSERT or IS_UPDATE flag to Y for further use.

importQualityCollection imports data to the production table from the interface table. Depending on the action type (Insert or Update), it calls the service execQualityCollectionConcProg with the appropriate parameters to execute the corresponding concurrent program that inserts data into the production table, and that generates the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execQualityCollectionConcProg), it checks for records in the interface table. If records are found, it then indicates an error during import. In this case, this service calls getQualityCollectionImport_ERR to retrieve the errors. If records are not found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED, it comes out of execution.

execQualityCollectionConcProg invokes the stored procedure WM_QA_IMP_HANDLER_PKG.WM_HANDLE_QA. The procedure calls the corresponding concurrent subroutine to execute the data import process for Quality Collection into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for concurrent program normal completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).

checkQualityCollectionImportStatus service checks the status of the execution by checking the Interface Table for any rejected record corresponding to the current request_id. If the query does not return any rows, it indicates successful import. If the query returns rows, it indicates that the concurrent program could not import data successfully in the Oracle Applications production tables.

getQualityCollectionImport_ERR gets the error message that occurs during the data import into the production table from the interface table. Based on the parameter REQUEST_ID, it scans the tables QA_INTERFACE_ERRORS and QA_RESULTS_INTERFACE to get the corresponding message.

QA_COLLECTION