[Home] [Help]
415: END IF;
416:
417: -- Set the return status to success initially
418: x_return_status := fnd_api.g_ret_sts_success;
419: gme_transactions_pvt.get_mat_trans
420: (p_mat_det_id => p_material_detail_rec.material_detail_id
421: ,p_batch_id => p_material_detail_rec.batch_id
422: ,x_mmt_tbl => l_mmt_tbl
423: ,x_return_status => x_return_status);
446: CLOSE Cur_item_details;
447: END IF;
448: /* End Bug 5021522 */
449: IF (l_item_rec.lot_control_code = 2) THEN
450: gme_transactions_pvt.get_lot_trans
451: (p_transaction_id => l_mmt_rec.transaction_id
452: ,x_mmln_tbl => l_mmln_tbl
453: ,x_return_status => x_return_status);
454: IF x_return_status <> fnd_api.g_ret_sts_success THEN
478: END IF;
479:
480: IF (l_mmt_rec.lpn_id IS NOT NULL AND
481: l_mmt_rec.subinventory_code IS NOT NULL AND
482: GME_TRANSACTIONS_PVT.check_lpn_subinv_loc
483: (p_lpn_id => l_mmt_rec.lpn_id,
484: p_in_subinv => l_mmt_rec.subinventory_code,
485: p_in_locid => l_mmt_rec.locator_id,
486: x_out_subinv => l_lpn_subinv,
537: END IF;
538:
539: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
540: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||
541: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);
542: END IF;
543:
544: -- Bug 13017256 - Let's pass in user entered date. It will only get
545: -- used if necessary. This should only be set during negative IB.
544: -- Bug 13017256 - Let's pass in user entered date. It will only get
545: -- used if necessary. This should only be set during negative IB.
546:
547: -- delete this transaction, reduce the qty to decrement
548: gme_transactions_pvt.delete_material_txn
549: (p_transaction_id => l_mmt_rec.transaction_id
550: ,p_trans_date => l_trans_date
551: ,p_txns_pair => NULL
552: ,x_return_status => x_return_status);
555: IF x_return_status = gme_common_pvt.g_not_transactable AND p_ignore_transactable THEN
556: -- don't do anything... move to the next...
557: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
558: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
559: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
560: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
561: END IF;
562: ELSE
563: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
561: END IF;
562: ELSE
563: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
564: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
565: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
566: || ' but p_ignore_transactable is set to FALSE; raising exception');
567: END IF;
568: RAISE error_del_trans;
569: END IF;
655: END revert_material_full;
656:
657: -- nsinghi bug#5176319. Created this proc. It will create ingredient reservation during batch/step unrelease.
658: -- Bug 6997483 01-May-2008 Archana Mundhe Added parameter transaction_id.
659: -- The transaction_id will be pased by GME_transactions_PVT.gme_post_process
660: -- and is the ingredient return/reversal transaction id.
661: PROCEDURE create_matl_resv_pplot (
662: p_material_dtl_id IN NUMBER,
663: p_transaction_id IN NUMBER,
710: ,x_material_detail => l_mat_dtl_rec) THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;
713:
714: gme_transactions_pvt.get_mmt_transactions (
715: p_transaction_id => gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id
716: ,x_mmt_rec => l_mmt_rec
717: ,x_mmln_tbl => l_mmln_rec
718: ,x_return_status => x_return_status);
974: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
975: END IF;
976: IF (p_mmln_tbl.COUNT > 0) THEN
977: FOR i IN 1..p_mmln_tbl.COUNT LOOP
978: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,
979: x_msg_count => l_msg_cnt,
980: x_msg_data => l_msg_data,
981: p_organization_id => p_mmt_rec.organization_id,
982: p_inventory_item_id => p_mmt_rec.inventory_item_id,
1029: END IF;
1030: END IF;
1031: END LOOP;
1032: ELSE
1033: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,
1034: x_msg_count => l_msg_cnt,
1035: x_msg_data => l_msg_data,
1036: p_organization_id => p_mmt_rec.organization_id,
1037: p_inventory_item_id => p_mmt_rec.inventory_item_id,