DBA Data[Home] [Help]

APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_UNRELEASE_BATCH_PVT

Line 457: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' new actual = 0; calling gme_unrelease_batch_pvt.revert_material_full');

453: l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
454: IF l_new_actual = 0 THEN
455: -- full revert
456: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
457: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' new actual = 0; calling gme_unrelease_batch_pvt.revert_material_full');
458: END IF;
459:
460: -- Bug 8751983 - Set to 2 if user is going negative.
461: IF gme_common_pvt.g_ib_timestamp_set = 1 THEN

Line 465: gme_unrelease_batch_pvt.revert_material_full

461: IF gme_common_pvt.g_ib_timestamp_set = 1 THEN
462: gme_common_pvt.g_ib_timestamp_set := 2;
463: END IF;
464:
465: gme_unrelease_batch_pvt.revert_material_full
466: (p_material_detail_rec => l_material_detail_rec
467: ,p_create_resv_pend_lots => 1
468: ,p_ignore_transactable => TRUE
469: ,x_actual_qty => l_actual_qty

Line 1178: IF gme_unrelease_batch_pvt.check_inv_negative

1174: call check_inv_negative only for prod/byprod. in IB, there is no ing return transaction */
1175: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
1176: -- Bug 8639523 - No need to do negative inventory checking for phantom prods or ingredients.
1177: IF (NVL(p_material_detail_rec.phantom_line_id, 0) = 0) THEN
1178: IF gme_unrelease_batch_pvt.check_inv_negative
1179: ( p_mmt_rec => l_mmt_rec
1180: ,p_mmln_tbl => l_mmln_tbl
1181: ,p_item_no => l_item_no) THEN
1182: RAISE inv_negative;

Line 1216: gme_unrelease_batch_pvt.create_resv_pplot

1212: ELSE
1213: l_qty := 0;
1214: END IF;
1215:
1216: gme_unrelease_batch_pvt.create_resv_pplot
1217: (p_material_detail_rec => p_material_detail_rec
1218: ,p_mmt_rec => l_mmt_rec
1219: ,p_mmln_tbl => l_mmln_tbl
1220: ,x_return_status => l_return_status);

Line 1241: IF gme_unrelease_batch_pvt.check_inv_negative

1237: /* Jalaj Srivastava Bug 5021522
1238: call check_inv_negative only for prod/byprod.
1239: in IB, there is no ing return transaction*/
1240: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
1241: IF gme_unrelease_batch_pvt.check_inv_negative
1242: ( p_mmt_rec => l_mmt_rec
1243: ,p_mmln_tbl => l_mmln_tbl
1244: ,p_item_no => l_item_no) THEN
1245: RAISE inv_negative;

Line 1289: gme_unrelease_batch_pvt.create_resv_pplot

1285: ,x_return_status => l_return_status);
1286: END IF;
1287:
1288: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1289: gme_unrelease_batch_pvt.create_resv_pplot
1290: (p_material_detail_rec => p_material_detail_rec
1291: ,p_mmt_rec => l_mmt_rec
1292: ,p_mmln_tbl => l_mmln_tbl
1293: ,x_return_status => l_return_status);

Line 1390: IF gme_unrelease_batch_pvt.check_inv_negative

1386: -- Continue to next lot if this one cannot be used.
1387: l_skip_lot := 0;
1388: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
1389: l_mmln_tbl_lot(1) := l_mmln_tbl(j);
1390: IF gme_unrelease_batch_pvt.check_inv_negative
1391: ( p_mmt_rec => l_mmt_rec
1392: ,p_mmln_tbl => l_mmln_tbl_lot
1393: ,p_item_no => l_item_no) THEN
1394: l_skip_lot := 1;

Line 1472: IF gme_unrelease_batch_pvt.check_inv_negative

1468: /* Jalaj Srivastava Bug 5021522
1469: call check_inv_negative only for prod/byprod.
1470: in IB, there is no ing return transaction*/
1471: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
1472: IF gme_unrelease_batch_pvt.check_inv_negative
1473: ( p_mmt_rec => l_mmt_rec
1474: ,p_mmln_tbl => l_mmln_tbl_orig
1475: ,p_item_no => l_item_no) THEN
1476: RAISE inv_negative;

Line 1505: gme_unrelease_batch_pvt.create_resv_pplot

1501: RAISE error_trans;
1502: ELSE
1503: l_trxn_success := TRUE;
1504: -- l_mmt_rec.transaction_quantity was not updated, so l_mmt_rec can be used with no modifications
1505: gme_unrelease_batch_pvt.create_resv_pplot
1506: (p_material_detail_rec => p_material_detail_rec
1507: ,p_mmt_rec => l_mmt_rec
1508: ,p_mmln_tbl => l_mmln_tbl_orig
1509: ,x_return_status => l_return_status);

Line 1542: IF gme_unrelease_batch_pvt.check_inv_negative

1538: /* Jalaj Srivastava Bug 5021522
1539: call check_inv_negative only for prod/byprod.
1540: in IB, there is no ing return transaction*/
1541: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
1542: IF gme_unrelease_batch_pvt.check_inv_negative
1543: ( p_mmt_rec => l_mmt_rec
1544: ,p_mmln_tbl => l_mmln_tbl_new
1545: ,p_item_no => l_item_no) THEN
1546: RAISE inv_negative;

Line 1616: gme_unrelease_batch_pvt.create_resv_pplot

1612: END IF;
1613: END LOOP;
1614:
1615: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1616: gme_unrelease_batch_pvt.create_resv_pplot
1617: (p_material_detail_rec => p_material_detail_rec
1618: ,p_mmt_rec => l_mmt_rec
1619: ,p_mmln_tbl => l_mmln_tbl_orig
1620: ,x_return_status => l_return_status);