APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on WMS_EXCEPTIONS_S

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

1963: l_proc_name VARCHAR2(30) := 'Log_exception';
1964: BEGIN
1965:
1966: --Calculate Sequence Number
1967: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
1968: g_debug := l_debug;
1969: g_module_name := l_proc_name;
1970: IF (l_debug = 1) THEN
1971: mdebug('Inserting into exceptions');

Line 2960: l_subinventory_code wms_exceptions.subinventory_code%TYPE;

2956: l_discrepancy VARCHAR2(1000);
2957: l_reason_context_code VARCHAR2(2);
2958: l_reason_id NUMBER;
2959: l_transaction_temp_id NUMBER;
2960: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2961: l_locator_id NUMBER;
2962: l_lpn_id NUMBER;
2963: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2964: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;