APPS.INV_LPN_TRX_PUB dependencies on INV_TXN_MANAGER_PUB

Line 887: IF ( p_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti ) THEN

883: WHERE transaction_temp_id = p_mmtt.transaction_temp_id;
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;

Line 4230: AND(l_proc_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd) THEN

4226: -- For this case, change the process_mode to asynchronous .
4227: IF ((v_mmtt.lpn_id IS NOT NULL)
4228: OR(v_mmtt.content_lpn_id IS NOT NULL)
4229: OR(v_mmtt.transfer_lpn_id IS NOT NULL))
4230: AND(l_proc_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd) THEN
4231: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;
4232: END IF;
4233:
4234: -- Changes added to Patchet J. This is only to be done if PO pathset J

Line 4231: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;

4227: IF ((v_mmtt.lpn_id IS NOT NULL)
4228: OR(v_mmtt.content_lpn_id IS NOT NULL)
4229: OR(v_mmtt.transfer_lpn_id IS NOT NULL))
4230: AND(l_proc_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd) THEN
4231: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;
4232: END IF;
4233:
4234: -- Changes added to Patchet J. This is only to be done if PO pathset J
4235: -- is installed. API update_fob_point, will derive and update

Line 4332: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_async

4328: -- Continue with the process based on the value of l_proc_mode
4329: IF l_proc_mode = 2 THEN -- Concurrent Mode
4330: -- Concurrent request. Submit request and return to caller
4331: UPDATE mtl_material_transactions_temp
4332: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_async
4333: WHERE transaction_header_id = p_trx_hdr_id;
4334:
4335: l_req_id := fnd_request.submit_request(application => 'INV', program => 'INVMBTRX', argument1 => p_trx_hdr_id);
4336: COMMIT; -- Need to commit for the request to be submitted

Line 4366: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd

4362:
4363: -- In this case, the background transaction manager would pick
4364: -- up this row from MMTT. Update transaction_mode and return to caller
4365: UPDATE mtl_material_transactions_temp
4366: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4367: WHERE transaction_header_id = p_trx_hdr_id;
4368:
4369: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4370: fnd_msg_pub.ADD;

Line 4579: ELSIF(v_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti) THEN

4575: END;
4576:
4577: -- Batch Failed exit from loop
4578: EXIT;
4579: ELSIF(v_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti) THEN
4580: BEGIN
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

Line 5166: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);

5162: FROM DUAL
5163: WHERE EXISTS(SELECT 1
5164: FROM mtl_material_transactions_temp
5165: WHERE transaction_header_id = p_trx_hdr_id
5166: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);
5167: EXCEPTION
5168: WHEN NO_DATA_FOUND THEN
5169: IF (l_debug = 1) THEN
5170: inv_log_util.TRACE('no record found in mmtt', 'INV_LPN_TRX_PUB', 1);

Line 5177: -- in tmpinsert() in INV_TXN_MANAGER_PUB

5173:
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