eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_TRANSACTIONS_PVT

Line 1080: gme_transactions_pvt.get_mat_trans

1076: -- Bug 13017256 - Let's initialize the variable with the user entered date.
1077: l_trans_date := NVL(gme_common_pvt.g_ib_timestamp_date, gme_common_pvt.g_timestamp);
1078:
1079: -- Bug 8751983 - Added order by clause to fetch in reverse trans order.
1080: gme_transactions_pvt.get_mat_trans
1081: (p_mat_det_id => p_material_detail_rec.material_detail_id
1082: ,p_batch_id => p_material_detail_rec.batch_id
1083: ,p_order_by => 2
1084: ,x_mmt_tbl => l_mmt_tbl

Line 1088: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.get_mat_trans returned '||l_mmt_tbl.count||' trxns with return_status='||x_return_status);

1084: ,x_mmt_tbl => l_mmt_tbl
1085: ,x_return_status => x_return_status);
1086:
1087: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1088: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.get_mat_trans returned '||l_mmt_tbl.count||' trxns with return_status='||x_return_status);
1089: END IF;
1090:
1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: RAISE error_get_trans;

Line 1188: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.delete_material_txn for trxns_id='||l_mmt_rec.transaction_id);

1184: END IF;
1185: END IF;
1186:
1187: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1188: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.delete_material_txn for trxns_id='||l_mmt_rec.transaction_id);
1189: END IF;
1190:
1191: -- Bug 13017256 - Let's pass in user entered date. It will get used if necessary.
1192: -- delete this transaction, reduce the qty to decrement

Line 1193: gme_transactions_pvt.delete_material_txn

1189: END IF;
1190:
1191: -- Bug 13017256 - Let's pass in user entered date. It will get used if necessary.
1192: -- delete this transaction, reduce the qty to decrement
1193: gme_transactions_pvt.delete_material_txn
1194: (p_transaction_id => l_mmt_rec.transaction_id
1195: ,p_trans_date => l_trans_date
1196: ,p_txns_pair => NULL
1197: ,x_return_status => l_return_status);

Line 1202: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);

1198:
1199: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1200: -- do nothing... move on to the next, to try to reduce
1201: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1202: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1203: END IF;
1204: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: x_return_status := l_return_status;
1206: RAISE error_trans;

Line 1250: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.update_material_txn for trxns_id='||l_mmt_rec.transaction_id);

1246: END IF;
1247: END IF;
1248:
1249: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1250: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.update_material_txn for trxns_id='||l_mmt_rec.transaction_id);
1251: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; update trxn with qty='||l_mmt_rec.transaction_quantity);
1252: END IF;
1253:
1254: gme_transactions_pvt.update_material_txn

Line 1254: gme_transactions_pvt.update_material_txn

1250: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.update_material_txn for trxns_id='||l_mmt_rec.transaction_id);
1251: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; update trxn with qty='||l_mmt_rec.transaction_quantity);
1252: END IF;
1253:
1254: gme_transactions_pvt.update_material_txn
1255: (p_mmt_rec => l_mmt_rec
1256: ,p_mmln_tbl => l_mmln_tbl
1257: ,x_return_status => l_return_status);
1258:

Line 1262: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);

1258:
1259: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1260: -- do nothing... move on to the next, to try to reduce
1261: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1262: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1263: END IF;
1264: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1265: x_return_status := l_return_status;
1266: RAISE error_trans;

Line 1351: gme_transactions_pvt.get_lot_trans

1347: -- decrement in place what is available according to l_lot_qty_tab
1348: -- if all qties are 0 delete the transaction
1349: -- if any lot transactions remain, transaction must be updated
1350:
1351: gme_transactions_pvt.get_lot_trans
1352: (p_transaction_id => l_mmt_rec.transaction_id
1353: ,x_mmln_tbl => l_mmln_tbl
1354: ,x_return_status => x_return_status);
1355:

Line 1481: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.delete_material_txn with trxn_id='||l_mmt_tbl(i).transaction_id);

1477: END IF;
1478: END IF;
1479:
1480: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1481: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; calling gme_transactions_pvt.delete_material_txn with trxn_id='||l_mmt_tbl(i).transaction_id);
1482: END IF;
1483:
1484: -- Bug 13017256 - Let's pass in user entered date. It will get used if necessary.
1485: -- delete this transaction, reduce the qty to decrement

Line 1487: gme_transactions_pvt.delete_material_txn

1483:
1484: -- Bug 13017256 - Let's pass in user entered date. It will get used if necessary.
1485: -- delete this transaction, reduce the qty to decrement
1486: -- delete the transaction... all lots were used
1487: gme_transactions_pvt.delete_material_txn
1488: (p_transaction_id => l_mmt_tbl(i).transaction_id
1489: ,p_txns_pair => NULL
1490: ,p_trans_date => l_trans_date
1491: ,x_return_status => l_return_status);

Line 1497: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);

1493: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1494: l_trxn_success := FALSE;
1495: -- do nothing... move on to the next, to try to reduce
1496: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1497: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1498: END IF;
1499: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1500: x_return_status := l_return_status;
1501: RAISE error_trans;

Line 1565: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling gme_transactions_pvt.update_material_txn with updatd l_mmt_rec and new l_mmln_tbl_new');

1561: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_mmln_tbl_new lot number:'||l_mmln_tbl_new(j).lot_number);
1562: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_mmln_tbl_new lot quantity: '||l_mmln_tbl_new(j).transaction_quantity);
1563: END LOOP;
1564:
1565: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling gme_transactions_pvt.update_material_txn with updatd l_mmt_rec and new l_mmln_tbl_new');
1566: END IF;
1567:
1568: gme_transactions_pvt.update_material_txn
1569: (p_mmt_rec => l_mmt_rec

Line 1568: gme_transactions_pvt.update_material_txn

1564:
1565: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling gme_transactions_pvt.update_material_txn with updatd l_mmt_rec and new l_mmln_tbl_new');
1566: END IF;
1567:
1568: gme_transactions_pvt.update_material_txn
1569: (p_mmt_rec => l_mmt_rec
1570: ,p_mmln_tbl => l_mmln_tbl_new
1571: ,x_return_status => l_return_status);
1572:

Line 1577: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);

1573: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1574: l_trxn_success := FALSE;
1575: -- do nothing... move on to the next, to try to reduce
1576: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1577: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1578: END IF;
1579: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1580: x_return_status := l_return_status;
1581: RAISE error_trans;