DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on WMS_EXCEPTIONS

Line 75: SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

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;

Line 115: INSERT INTO wms_exceptions(

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,