APPS.INV_LPN_TRX_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 692: UPDATE mtl_transactions_interface

688:
689: -- If transaction came from MTI, need to also update MTI with
690: -- the same batch and sequence so java tm can update delete MTIs
691: IF ( p_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti ) THEN
692: UPDATE mtl_transactions_interface
693: SET transaction_batch_id = p_mmtt.transaction_batch_id
694: , transaction_batch_seq = p_mmtt.transaction_batch_seq
695: WHERE transaction_interface_id = p_mmtt.transaction_temp_id;
696:

Line 703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');

699: END IF;
700:
701: IF ( sql%rowcount = 0 ) THEN
702: fnd_message.set_name('INV', 'INV_NO_RECORDS');
703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
704: fnd_msg_pub.ADD;
705: RAISE fnd_api.g_exc_error;
706: END IF;
707: END IF;

Line 4262: UPDATE mtl_transactions_interface

4258: IF (v_mmtt.transaction_batch_id IS NOT NULL) THEN
4259: -- This record was part of a batch and it originated from MTI
4260: -- Update MTI records with error message and set status to error
4261: -- and delete all rows belonging to this group from MMTT/MTLT/MSNT
4262: UPDATE mtl_transactions_interface
4263: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
4264: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
4265: , process_flag = 3
4266: , lock_flag = 2

Line 4309: UPDATE mtl_transactions_interface

4305: ELSE -- IF v_mmtt.transaction_batch_id IS NULL
4306: -- This record was not part of a batch and it originated from MTI
4307: -- Update MTI record with error message and set status to error
4308: -- and delete the corresponding record from MMTT/MTLT/MSNT
4309: UPDATE mtl_transactions_interface
4310: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
4311: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
4312: , process_flag = 3
4313: , lock_flag = 2

Line 4678: UPDATE mtl_transactions_interface

4674: IF (l_is_from_mti = 1) THEN
4675: -- record originated from MTI. Update all records in MTI for this batch
4676: -- Delete from MMTT, MTLT and MSNT. Records from MTI get copied to MMTT
4677: -- in tmpinsert() in INV_TXN_MANAGER_PUB
4678: UPDATE mtl_transactions_interface
4679: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
4680: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
4681: , process_flag = 3
4682: , lock_flag = 2