DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on WMS_EXCEPTIONS_S

Line 1484: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

1480: l_proc_name VARCHAR2(30) := 'Log_exception';
1481: BEGIN
1482:
1483: --Calculate Sequence Number
1484: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
1485: g_debug := l_debug;
1486: g_module_name := l_proc_name;
1487: IF (l_debug = 1) THEN
1488: mdebug('Inserting into exceptions');

Line 2324: l_subinventory_code wms_exceptions.subinventory_code%TYPE;

2320: l_discrepancy VARCHAR2(1000);
2321: l_reason_context_code VARCHAR2(2);
2322: l_reason_id NUMBER;
2323: l_transaction_temp_id NUMBER;
2324: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2325: l_locator_id NUMBER;
2326: l_lpn_id NUMBER;
2327: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2328: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;