149: END IF;
150: l_progress := '40';
151:
152: IF (l_debug = 1) THEN
153: mydebug('Before inserting into WMS_skip_task_exceptions');
154: END IF;
155:
156: INSERT INTO wms_skip_task_exceptions(
157: TASK_ID,
152: IF (l_debug = 1) THEN
153: mydebug('Before inserting into WMS_skip_task_exceptions');
154: END IF;
155:
156: INSERT INTO wms_skip_task_exceptions(
157: TASK_ID,
158: SEQUENCE_NUMBER,
159: ORGANIZATION_ID,
160: INVENTORY_ITEM_ID,
185: p_wms_task_type
186: );
187:
188: IF (l_debug = 1) THEN
189: mydebug('After inserting into WMS_skip_task_exceptions');
190: mydebug('Before Deleting from wms_dispatched_task');
191: END IF;
192: l_progress := '50';
193: