APPS.WSH_BATCH_PROCESS dependencies on WSH_EXCEPTIONS

Line 899: select '1' from wsh_exceptions we where

895: wnd.batch_id = p_sc_batch_id AND
896: wtp.trip_id = wst.trip_id AND
897: wst.status_code = 'OP' AND
898: NOT EXISTS (
899: select '1' from wsh_exceptions we where
900: we.delivery_id = wnd.delivery_id AND
901: we.severity = 'ERROR' AND
902: we.status = 'OPEN' AND
903: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 922: select '1' from wsh_exceptions we

918: and wlg.pick_up_stop_id = wst.stop_id
919: and wnd.INITIAL_PICKUP_LOCATION_ID = wst.STOP_LOCATION_ID
920: and wst.status_code in ( 'OP' , 'AR' )
921: and NOT EXISTS (
922: select '1' from wsh_exceptions we
923: where we.delivery_id = wnd.delivery_id
924: AND we.severity = 'ERROR'
925: AND we.status = 'OPEN'
926: AND we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 2744: l_error_message wsh_exceptions.error_message%type;

2740: l_return_status VARCHAR2(1);
2741: l_msg_count NUMBER;
2742: l_msg_data VARCHAR2(2000);
2743: l_exception_id NUMBER;
2744: l_error_message wsh_exceptions.error_message%type;
2745:
2746: --
2747: l_debug_on BOOLEAN;
2748: --

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

2771:
2772: IF p_batch_id IS NULL THEN
2773: RETURN;
2774: END IF;
2775: -- We populate the error_message column in wsh_exceptions if the exception
2776: -- was logged for autopack. If the exception was logged for ship confirm we
2777: -- leave it as NULL.
2778: /* IF p_error_status = 'W' THEN
2779: