[Home] [Help]
71: END IF;
72:
73: l_progress := '20';
74:
75: SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
76:
77: IF (l_debug = 1) THEN
78: mydebug('l_sequence: ' || l_sequence);
79: END IF;
111: mydebug('WMSSKIPB: value of l_inventory_item_id ' || l_inventory_item_id);
112: mydebug('Before inserting into WMS_exception');
113: END IF;
114:
115: INSERT INTO wms_exceptions(
116: TASK_ID,
117: SEQUENCE_NUMBER,
118: ORGANIZATION_ID,
119: INVENTORY_ITEM_ID,