DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_TRANSACTIONS_PVT

Line 1416: gme_transactions_pvt.delete_material_txn

1412:
1413: -- If the new actual qty is zero we need to delete the transaction
1414: IF (p_material_detail_rec.actual_qty = 0 AND p_trans_id > 0) THEN
1415:
1416: gme_transactions_pvt.delete_material_txn
1417: (p_transaction_id => p_trans_id
1418: ,p_txns_pair => NULL
1419: ,x_return_status => x_return_status);
1420:

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

1425: || '.'
1426: || l_api_name
1427: || ' return '
1428: || x_return_status
1429: || ' from gme_transactions_pvt.delete_material_txn');
1430: END IF;
1431:
1432: RAISE error_trans;
1433: END IF;

Line 1455: gme_transactions_pvt.create_material_txn

1451: ,p_batch_step_rec => p_batch_step_rec
1452: ,x_mmti_rec => l_mmti_rec
1453: ,x_return_status => x_return_status);
1454:
1455: gme_transactions_pvt.create_material_txn
1456: (p_mmti_rec => l_mmti_rec
1457: ,p_mmli_tbl => l_mmli_tbl
1458: ,p_phantom_trans => 0
1459: ,x_return_status => x_return_status);

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

1465: || '.'
1466: || l_api_name
1467: || ' return '
1468: || x_return_status
1469: || ' from gme_transactions_pvt.create_material_txn');
1470: END IF;
1471:
1472: RAISE error_trans;
1473: END IF;

Line 1487: gme_transactions_pvt.get_transactions

1483: ELSE
1484: /* Bug 5681997 added condition to touch txns only if enabled */
1485: IF p_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
1486: -- Actual qty is non zero. Need to update the transaction.
1487: gme_transactions_pvt.get_transactions
1488: (p_transaction_id => p_trans_id
1489: ,x_mmt_rec => l_mmt_rec
1490: ,x_mmln_tbl => l_mmln_tbl
1491: ,x_return_status => x_return_status);

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

1490: ,x_mmln_tbl => l_mmln_tbl
1491: ,x_return_status => x_return_status);
1492: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1493: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1494: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.get_transactions');
1495: END IF;
1496: RAISE error_trans;
1497: END IF;
1498: l_mmt_rec.transaction_quantity := p_material_detail_rec.actual_qty;

Line 1507: gme_transactions_pvt.update_material_txn

1503: l_mmln_tbl(1).transaction_quantity := p_material_detail_rec.actual_qty;
1504: l_mmln_tbl(1).secondary_transaction_quantity := NULL;
1505: END IF;
1506: END IF;
1507: gme_transactions_pvt.update_material_txn
1508: (p_mmt_rec => l_mmt_rec
1509: ,p_mmln_tbl => l_mmln_tbl
1510: ,x_return_status => x_return_status);
1511:

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

1510: ,x_return_status => x_return_status);
1511:
1512: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1513: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1514: gme_debug.put_line( g_pkg_name|| '.'|| l_api_name|| ' return '|| x_return_status|| ' from gme_transactions_pvt.create_material_txn');
1515: END IF;
1516: RAISE error_trans;
1517: END IF;
1518: END IF;

Line 4469: gme_transactions_pvt.get_mat_trans (

4465: ,p_material_detail_id => p_material_detail_rec.material_detail_id
4466: ,x_return_status => x_return_status);
4467:
4468: -- delete all transactions for this line
4469: gme_transactions_pvt.get_mat_trans (
4470: p_mat_det_id => p_material_detail_rec.material_detail_id
4471: ,p_batch_id => p_batch_header_rec.batch_id
4472: ,x_mmt_tbl => l_mmt_tbl
4473: ,x_return_status => x_return_status);

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

4472: ,x_mmt_tbl => l_mmt_tbl
4473: ,x_return_status => x_return_status);
4474:
4475: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4476: l_proc := 'gme_transactions_pvt.get_mat_trans';
4477: RAISE error_processing;
4478: END IF;
4479:
4480: FOR i in 1..l_mmt_tbl.COUNT LOOP

Line 4481: gme_transactions_pvt.delete_material_txn (

4477: RAISE error_processing;
4478: END IF;
4479:
4480: FOR i in 1..l_mmt_tbl.COUNT LOOP
4481: gme_transactions_pvt.delete_material_txn (
4482: p_transaction_id => l_mmt_tbl(i).transaction_id
4483: ,p_txns_pair => NULL
4484: ,x_return_status => x_return_status);
4485: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

4482: p_transaction_id => l_mmt_tbl(i).transaction_id
4483: ,p_txns_pair => NULL
4484: ,x_return_status => x_return_status);
4485: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4486: l_proc := 'gme_transactions_pvt.delete_material_txn';
4487: RAISE error_processing;
4488: END IF;
4489: END LOOP;
4490: