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 890: gme_transactions_pvt.get_mat_trans

886:
887: l_qty := p_qty;
888: l_total_decr_qty := 0;
889:
890: gme_transactions_pvt.get_mat_trans
891: (p_mat_det_id => p_material_detail_rec.material_detail_id
892: ,p_batch_id => p_material_detail_rec.batch_id
893: ,x_mmt_tbl => l_mmt_tbl
894: ,x_return_status => x_return_status);

Line 897: 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);

893: ,x_mmt_tbl => l_mmt_tbl
894: ,x_return_status => x_return_status);
895:
896: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
897: 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);
898: END IF;
899:
900: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
901: RAISE error_get_trans;

Line 995: 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);

991: END IF;
992: END IF;
993:
994: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
995: 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);
996: END IF;
997: -- delete this transaction, reduce the qty to decrement
998: gme_transactions_pvt.delete_material_txn
999: (p_transaction_id => l_mmt_rec.transaction_id

Line 998: gme_transactions_pvt.delete_material_txn

994: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
995: 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);
996: END IF;
997: -- delete this transaction, reduce the qty to decrement
998: gme_transactions_pvt.delete_material_txn
999: (p_transaction_id => l_mmt_rec.transaction_id
1000: ,p_txns_pair => NULL
1001: ,x_return_status => l_return_status);
1002:

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

1002:
1003: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1004: -- do nothing... move on to the next, to try to reduce
1005: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1006: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1007: END IF;
1008: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1009: x_return_status := l_return_status;
1010: RAISE error_trans;

Line 1046: 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);

1042: END IF;
1043: END IF;
1044:
1045: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1046: 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);
1047: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; update trxn with qty='||l_mmt_rec.transaction_quantity);
1048: END IF;
1049:
1050: gme_transactions_pvt.update_material_txn

Line 1050: gme_transactions_pvt.update_material_txn

1046: 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);
1047: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; update trxn with qty='||l_mmt_rec.transaction_quantity);
1048: END IF;
1049:
1050: gme_transactions_pvt.update_material_txn
1051: (p_mmt_rec => l_mmt_rec
1052: ,p_mmln_tbl => l_mmln_tbl
1053: ,x_return_status => l_return_status);
1054:

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

1054:
1055: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1056: -- do nothing... move on to the next, to try to reduce
1057: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1058: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1059: END IF;
1060: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: x_return_status := l_return_status;
1062: RAISE error_trans;

Line 1147: gme_transactions_pvt.get_lot_trans

1143: -- decrement in place what is available according to l_lot_qty_tab
1144: -- if all qties are 0 delete the transaction
1145: -- if any lot transactions remain, transaction must be updated
1146:
1147: gme_transactions_pvt.get_lot_trans
1148: (p_transaction_id => l_mmt_rec.transaction_id
1149: ,x_mmln_tbl => l_mmln_tbl
1150: ,x_return_status => x_return_status);
1151:

Line 1255: 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);

1251: END IF;
1252: END IF;
1253:
1254: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1255: 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);
1256: END IF;
1257:
1258: -- delete the transaction... all lots were used
1259: gme_transactions_pvt.delete_material_txn

Line 1259: gme_transactions_pvt.delete_material_txn

1255: 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);
1256: END IF;
1257:
1258: -- delete the transaction... all lots were used
1259: gme_transactions_pvt.delete_material_txn
1260: (p_transaction_id => l_mmt_tbl(i).transaction_id
1261: ,p_txns_pair => NULL
1262: ,x_return_status => l_return_status);
1263:

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

1264: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1265: l_trxn_success := FALSE;
1266: -- do nothing... move on to the next, to try to reduce
1267: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1268: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1269: END IF;
1270: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1271: x_return_status := l_return_status;
1272: RAISE error_trans;

Line 1326: 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');

1322: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_mmln_tbl_new lot number:'||l_mmln_tbl_new(j).lot_number);
1323: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_mmln_tbl_new lot quantity: '||l_mmln_tbl_new(j).transaction_quantity);
1324: END LOOP;
1325:
1326: 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');
1327: END IF;
1328:
1329: gme_transactions_pvt.update_material_txn
1330: (p_mmt_rec => l_mmt_rec

Line 1329: gme_transactions_pvt.update_material_txn

1325:
1326: 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');
1327: END IF;
1328:
1329: gme_transactions_pvt.update_material_txn
1330: (p_mmt_rec => l_mmt_rec
1331: ,p_mmln_tbl => l_mmln_tbl_new
1332: ,x_return_status => l_return_status);
1333:

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

1334: IF l_return_status = gme_common_pvt.g_not_transactable THEN
1335: l_trxn_success := FALSE;
1336: -- do nothing... move on to the next, to try to reduce
1337: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1338: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1339: END IF;
1340: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1341: x_return_status := l_return_status;
1342: RAISE error_trans;