APPS.INV_LPN_TRX_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 888: UPDATE mtl_transactions_interface

884:
885: -- If transaction came from MTI, need to also update MTI with
886: -- the same batch and sequence so java tm can update delete MTIs
887: IF ( p_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti ) THEN
888: UPDATE mtl_transactions_interface
889: SET transaction_batch_id = p_mmtt.transaction_batch_id
890: , transaction_batch_seq = p_mmtt.transaction_batch_seq
891: WHERE transaction_interface_id = p_mmtt.transaction_temp_id;
892:

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

895: END IF;
896:
897: IF ( sql%rowcount = 0 ) THEN
898: fnd_message.set_name('INV', 'INV_NO_RECORDS');
899: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
900: fnd_msg_pub.ADD;
901: RAISE fnd_api.g_exc_error;
902: END IF;
903: END IF;

Line 4585: UPDATE mtl_transactions_interface

4581: IF (v_mmtt.transaction_batch_id IS NOT NULL) THEN
4582: -- This record was part of a batch and it originated from MTI
4583: -- Update MTI records with error message and set status to error
4584: -- and delete all rows belonging to this group from MMTT/MTLT/MSNT
4585: UPDATE mtl_transactions_interface
4586: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
4587: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
4588: , process_flag = 3
4589: , lock_flag = 2

Line 4632: UPDATE mtl_transactions_interface

4628: ELSE -- IF v_mmtt.transaction_batch_id IS NULL
4629: -- This record was not part of a batch and it originated from MTI
4630: -- Update MTI record with error message and set status to error
4631: -- and delete the corresponding record from MMTT/MTLT/MSNT
4632: UPDATE mtl_transactions_interface
4633: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
4634: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
4635: , process_flag = 3
4636: , lock_flag = 2

Line 5178: UPDATE mtl_transactions_interface

5174: IF (l_is_from_mti = 1) THEN
5175: -- record originated from MTI. Update all records in MTI for this batch
5176: -- Delete from MMTT, MTLT and MSNT. Records from MTI get copied to MMTT
5177: -- in tmpinsert() in INV_TXN_MANAGER_PUB
5178: UPDATE mtl_transactions_interface
5179: SET ERROR_CODE = substrb(l_error_code,1,240)/*added substrb for 3632722*/
5180: , error_explanation = substrb(x_proc_msg,1,240)/*added substrb for 3632722*/
5181: , process_flag = 3
5182: , lock_flag = 2