File name: rmsasyncprocs/b.pls
Function Level Description – ENQUEUE_WH_ADD
Function: ENQUEUE_WH_ADD
(O_error_message IN OUT RTK_ERRORS.RTK_TEXT%TYPE,
I_rms_async_id IN RMS_ASYNC_STATUS.RMS_ASYNC_ID%TYPE)
This function adds the RMS_ASYNC_ID associated with the JOB_TYPE WH_ADD created from the warehouse form to the asynchronous queue. It also makes entries into the RMS_ASYNC_STATUS and RMS_ASYNC_RETRY tables to track the status of the asynchronous job.
Function Level Description – ENQUEUE_WH_ADD_RETRY
Function: ENQUEUE_WH_ADD_RETRY
(O_error_message IN OUT RTK_ERRORS.RTK_TEXT%TYPE,
I_rms_async_id IN RMS_ASYNC_STATUS.RMS_ASYNC_ID%TYPE)
This function puts the RMS_ASYNC_ID associated with a WH_ADD event into the asynchronous queue again for re-processing. It is invoked through the asynchronous job log form.
Function Level Description – NOTIFY_WH_ADD
Procedure: NOTIFY_WH_ADD(context raw,
reginfo sys.aq$_reg_info,
descr sys.aq$_descriptor,
payload raw,
payloadl number)
This procedure is called during the de-queue process. This procedure calls the function CORESVC_WH_ADD_SQL.ADD_WH for WH creation. Once the WH creation is completed successfully it calls the function RMS_ASYNC_PROCESS_SQL.WRITE_SUCCESS to update the status of the RMS_ASYNC_ID as ‘success’. During failure in WH creation it calls the function RMS_ASYNC_PROCESS_SQL.WRITE_ERROR to update the status as ‘error’ and updates the error message. The user is notified about the success or failure of the WH creation process.