APPS.INV_LPN_TRX_PUB dependencies on INV_TXN_MANAGER_PUB

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

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

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

3939: -- For this case, change the process_mode to asynchronous .
3940: IF ((v_mmtt.lpn_id IS NOT NULL)
3941: OR(v_mmtt.content_lpn_id IS NOT NULL)
3942: OR(v_mmtt.transfer_lpn_id IS NOT NULL))
3943: AND(l_proc_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd) THEN
3944: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;
3945: END IF;
3946:
3947: -- Changes added to Patchet J. This is only to be done if PO pathset J

Line 3944: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;

3940: IF ((v_mmtt.lpn_id IS NOT NULL)
3941: OR(v_mmtt.content_lpn_id IS NOT NULL)
3942: OR(v_mmtt.transfer_lpn_id IS NOT NULL))
3943: AND(l_proc_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd) THEN
3944: l_proc_mode := inv_txn_manager_pub.proc_mode_mmtt_async;
3945: END IF;
3946:
3947: -- Changes added to Patchet J. This is only to be done if PO pathset J
3948: -- is installed. API update_fob_point, will derive and update

Line 4035: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_async

4031: -- Continue with the process based on the value of l_proc_mode
4032: IF l_proc_mode = 2 THEN -- Concurrent Mode
4033: -- Concurrent request. Submit request and return to caller
4034: UPDATE mtl_material_transactions_temp
4035: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_async
4036: WHERE transaction_header_id = p_trx_hdr_id;
4037:
4038: l_req_id := fnd_request.submit_request(application => 'INV', program => 'INVMBTRX', argument1 => p_trx_hdr_id);
4039: COMMIT; -- Need to commit for the request to be submitted

Line 4069: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd

4065:
4066: -- In this case, the background transaction manager would pick
4067: -- up this row from MMTT. Update transaction_mode and return to caller
4068: UPDATE mtl_material_transactions_temp
4069: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4070: WHERE transaction_header_id = p_trx_hdr_id;
4071:
4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4073: fnd_msg_pub.ADD;

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

4252: END;
4253:
4254: -- Batch Failed exit from loop
4255: EXIT;
4256: ELSIF(v_mmtt.transaction_mode = inv_txn_manager_pub.proc_mode_mti) THEN
4257: BEGIN
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

Line 4666: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);

4662: FROM DUAL
4663: WHERE EXISTS(SELECT 1
4664: FROM mtl_material_transactions_temp
4665: WHERE transaction_header_id = p_trx_hdr_id
4666: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);
4667: EXCEPTION
4668: WHEN NO_DATA_FOUND THEN
4669: IF (l_debug = 1) THEN
4670: inv_log_util.TRACE('no record found in mmtt', 'INV_LPN_TRX_PUB', 1);

Line 4677: -- in tmpinsert() in INV_TXN_MANAGER_PUB

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