APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_TRANSACTIONS_PVT

Line 394: gme_transactions_pvt.get_mat_trans

390: END IF;
391:
392: -- Set the return status to success initially
393: x_return_status := fnd_api.g_ret_sts_success;
394: gme_transactions_pvt.get_mat_trans
395: (p_mat_det_id => p_material_detail_rec.material_detail_id
396: ,p_batch_id => p_material_detail_rec.batch_id
397: ,x_mmt_tbl => l_mmt_tbl
398: ,x_return_status => x_return_status);

Line 419: gme_transactions_pvt.get_lot_trans

415: CLOSE Cur_item_details;
416: END IF;
417: /* End Bug 5021522 */
418: IF (l_item_rec.lot_control_code = 2) THEN
419: gme_transactions_pvt.get_lot_trans
420: (p_transaction_id => l_mmt_rec.transaction_id
421: ,x_mmln_tbl => l_mmln_tbl
422: ,x_return_status => x_return_status);
423: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 437: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);

433: END IF;
434: END IF;
435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
436: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||
437: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);
438: END IF;
439:
440: gme_transactions_pvt.delete_material_txn
441: (p_transaction_id => l_mmt_rec.transaction_id

Line 440: gme_transactions_pvt.delete_material_txn

436: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||
437: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);
438: END IF;
439:
440: gme_transactions_pvt.delete_material_txn
441: (p_transaction_id => l_mmt_rec.transaction_id
442: ,p_txns_pair => NULL
443: ,x_return_status => x_return_status);
444:

Line 450: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status

446: IF x_return_status = gme_common_pvt.g_not_transactable AND p_ignore_transactable THEN
447: -- don't do anything... move to the next...
448: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
449: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
450: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
451: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
452: END IF;
453: ELSE
454: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 456: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status

452: END IF;
453: ELSE
454: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
455: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
456: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
457: || ' but p_ignore_transactable is set to FALSE; raising exception');
458: END IF;
459: RAISE error_del_trans;
460: END IF;

Line 550: -- The transaction_id will be pased by GME_transactions_PVT.gme_post_process

546: END revert_material_full;
547:
548: -- nsinghi bug#5176319. Created this proc. It will create ingredient reservation during batch/step unrelease.
549: -- Bug 6997483 01-May-2008 Archana Mundhe Added parameter transaction_id.
550: -- The transaction_id will be pased by GME_transactions_PVT.gme_post_process
551: -- and is the ingredient return/reversal transaction id.
552: PROCEDURE create_matl_resv_pplot (
553: p_material_dtl_id IN NUMBER,
554: p_transaction_id IN NUMBER,

Line 607: gme_transactions_pvt.get_mmt_transactions (

603: RAISE fnd_api.g_exc_error;
604: END IF;
605:
606:
607: gme_transactions_pvt.get_mmt_transactions (
608: p_transaction_id => gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id
609: ,x_mmt_rec => l_mmt_rec
610: ,x_mmln_tbl => l_mmln_rec
611: ,x_return_status => x_return_status);

Line 869: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,

865: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
866: END IF;
867: IF (p_mmln_tbl.COUNT > 0) THEN
868: FOR i IN 1..p_mmln_tbl.COUNT LOOP
869: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,
870: x_msg_count => l_msg_cnt,
871: x_msg_data => l_msg_data,
872: p_organization_id => p_mmt_rec.organization_id,
873: p_inventory_item_id => p_mmt_rec.inventory_item_id,

Line 924: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,

920: END IF;
921: END IF;
922: END LOOP;
923: ELSE
924: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,
925: x_msg_count => l_msg_cnt,
926: x_msg_data => l_msg_data,
927: p_organization_id => p_mmt_rec.organization_id,
928: p_inventory_item_id => p_mmt_rec.inventory_item_id,