APPS.WSH_BATCH_PROCESS dependencies on WSH_EXCEPTIONS

Line 923: select '1' from wsh_exceptions we where

919: wnd.batch_id = p_sc_batch_id AND
920: wtp.trip_id = wst.trip_id AND
921: wst.status_code = 'OP' AND
922: NOT EXISTS (
923: select '1' from wsh_exceptions we where
924: we.delivery_id = wnd.delivery_id AND
925: we.severity = 'ERROR' AND
926: we.status = 'OPEN' AND
927: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 946: select '1' from wsh_exceptions we

942: and wlg.pick_up_stop_id = wst.stop_id
943: and wnd.INITIAL_PICKUP_LOCATION_ID = wst.STOP_LOCATION_ID
944: and wst.status_code in ( 'OP' , 'AR' )
945: and NOT EXISTS (
946: select '1' from wsh_exceptions we
947: where we.delivery_id = wnd.delivery_id
948: AND we.severity = 'ERROR'
949: AND we.status = 'OPEN'
950: AND we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 2774: l_error_message wsh_exceptions.error_message%type;

2770: l_return_status VARCHAR2(1);
2771: l_msg_count NUMBER;
2772: l_msg_data VARCHAR2(2000);
2773: l_exception_id NUMBER;
2774: l_error_message wsh_exceptions.error_message%type;
2775:
2776: --
2777: l_debug_on BOOLEAN;
2778: --

Line 2805: -- We populate the error_message column in wsh_exceptions if the exception

2801:
2802: IF p_batch_id IS NULL THEN
2803: RETURN;
2804: END IF;
2805: -- We populate the error_message column in wsh_exceptions if the exception
2806: -- was logged for autopack. If the exception was logged for ship confirm we
2807: -- leave it as NULL.
2808: /* IF p_error_status = 'W' THEN
2809: