255: --Bug 9277386:Populating existing Exception's Error Message, when respose STATUS is ERROR.
256: UPDATE wsh_exceptions
257: SET error_message = l_exception_message ,
258: last_update_date = SYSDATE ,
259: last_updated_by = fnd_global.user_id
260: WHERE exception_id = l_exception_id;
261: --Bug 9277386:When the error code from Response XML is interpreted as 'SUCCESS',
262: -- updating process_flag to 1 and closing the existing ITM exceptions.
263: IF l_interpreted_value = 'SUCCESS' THEN
264:
265: UPDATE wsh_itm_request_control
266: SET process_flag = 1 ,
267: last_update_date= sysdate,
268: last_updated_by = fnd_global.user_id
269: WHERE request_control_id = p_request_control_id;
270:
271: GOTO CLOSE_EXCEPTION;
272: ELSE