DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_TRANSACTIONS_PVT

Line 1480: gme_transactions_pvt.delete_material_txn

1476:
1477: -- If the new actual qty is zero we need to delete the transaction
1478: IF (p_material_detail_rec.actual_qty = 0 AND p_trans_id > 0) THEN
1479:
1480: gme_transactions_pvt.delete_material_txn
1481: (p_transaction_id => p_trans_id
1482: ,p_txns_pair => NULL
1483: ,x_return_status => x_return_status);
1484:

Line 1493: || ' from gme_transactions_pvt.delete_material_txn');

1489: || '.'
1490: || l_api_name
1491: || ' return '
1492: || x_return_status
1493: || ' from gme_transactions_pvt.delete_material_txn');
1494: END IF;
1495:
1496: RAISE error_trans;
1497: END IF;

Line 1587: gme_transactions_pvt.create_material_txn

1583: ,p_batch_step_rec => p_batch_step_rec
1584: ,x_mmti_rec => l_mmti_rec
1585: ,x_return_status => x_return_status);
1586:
1587: gme_transactions_pvt.create_material_txn
1588: (p_mmti_rec => l_mmti_rec
1589: ,p_mmli_tbl => l_mmli_tbl
1590: ,p_phantom_trans => 0
1591: ,x_return_status => x_return_status);

Line 1601: || ' from gme_transactions_pvt.create_material_txn');

1597: || '.'
1598: || l_api_name
1599: || ' return '
1600: || x_return_status
1601: || ' from gme_transactions_pvt.create_material_txn');
1602: END IF;
1603:
1604: RAISE error_trans;
1605: END IF;

Line 1621: gme_transactions_pvt.get_transactions

1617: ELSE
1618: /* Bug 5681997 added condition to touch txns only if enabled */
1619: IF p_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
1620: -- Actual qty is non zero. Need to update the transaction.
1621: gme_transactions_pvt.get_transactions
1622: (p_transaction_id => p_trans_id
1623: ,x_mmt_rec => l_mmt_rec
1624: ,x_mmln_tbl => l_mmln_tbl
1625: ,x_return_status => x_return_status);

Line 1628: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.get_transactions');

1624: ,x_mmln_tbl => l_mmln_tbl
1625: ,x_return_status => x_return_status);
1626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1627: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1628: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.get_transactions');
1629: END IF;
1630: RAISE error_trans;
1631: END IF;
1632: l_mmt_rec.transaction_quantity := p_material_detail_rec.actual_qty;

Line 1650: gme_transactions_pvt.update_material_txn

1646: -- Bug 13743650 - Assign secondary qty with a value instead of NULL.
1647: l_mmln_tbl(1).secondary_transaction_quantity := l_secondary_qty;
1648: END IF;
1649: END IF;
1650: gme_transactions_pvt.update_material_txn
1651: (p_mmt_rec => l_mmt_rec
1652: ,p_mmln_tbl => l_mmln_tbl
1653: ,x_return_status => x_return_status);
1654:

Line 1657: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.create_material_txn');

1653: ,x_return_status => x_return_status);
1654:
1655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1656: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1657: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.create_material_txn');
1658: END IF;
1659: RAISE error_trans;
1660: END IF;
1661: END IF;

Line 4662: gme_transactions_pvt.get_mat_trans (

4658: ,p_material_detail_id => p_material_detail_rec.material_detail_id
4659: ,x_return_status => x_return_status);
4660:
4661: -- delete all transactions for this line
4662: gme_transactions_pvt.get_mat_trans (
4663: p_mat_det_id => p_material_detail_rec.material_detail_id
4664: ,p_batch_id => p_batch_header_rec.batch_id
4665: ,x_mmt_tbl => l_mmt_tbl
4666: ,x_return_status => x_return_status);

Line 4669: l_proc := 'gme_transactions_pvt.get_mat_trans';

4665: ,x_mmt_tbl => l_mmt_tbl
4666: ,x_return_status => x_return_status);
4667:
4668: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4669: l_proc := 'gme_transactions_pvt.get_mat_trans';
4670: RAISE error_processing;
4671: END IF;
4672:
4673: FOR i in 1..l_mmt_tbl.COUNT LOOP

Line 4674: gme_transactions_pvt.delete_material_txn (

4670: RAISE error_processing;
4671: END IF;
4672:
4673: FOR i in 1..l_mmt_tbl.COUNT LOOP
4674: gme_transactions_pvt.delete_material_txn (
4675: p_transaction_id => l_mmt_tbl(i).transaction_id
4676: ,p_txns_pair => NULL
4677: ,x_return_status => x_return_status);
4678: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 4679: l_proc := 'gme_transactions_pvt.delete_material_txn';

4675: p_transaction_id => l_mmt_tbl(i).transaction_id
4676: ,p_txns_pair => NULL
4677: ,x_return_status => x_return_status);
4678: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4679: l_proc := 'gme_transactions_pvt.delete_material_txn';
4680: RAISE error_processing;
4681: END IF;
4682: END LOOP;
4683: