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_RELEASE_BATCH_PVT dependencies on GME_RESERVATIONS_PVT

Line 586: gme_reservations_pvt.get_material_reservations

582: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);
583: END IF;
584:
585: -- channges for GMO
586: gme_reservations_pvt.get_material_reservations
587: (p_organization_id => p_material_dtl_rec.organization_id
588: ,p_batch_id => p_material_dtl_rec.batch_id
589: ,p_material_detail_id => p_material_dtl_rec.material_detail_id
590: ,p_dispense_ind => nvl(p_material_dtl_rec.dispense_ind,'N')

Line 630: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified

626: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
627: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);
628: END IF;
629: /* Bug 5441643 Added NVL condition for location control code*/
630: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified
631: (p_reservation_rec => l_reservation_rec
632: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
633: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
634:

Line 636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);

632: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
633: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
634:
635: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);
637: END IF;
638:
639: IF l_rsrv_type = -1 THEN
640: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 641: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');

637: END IF;
638:
639: IF l_rsrv_type = -1 THEN
640: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
641: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');
642: RAISE error_unexpected;
643: ENd IF;
644: END IF;
645:

Line 772: gme_reservations_pvt.convert_partial_to_dlr

768: i := 1;
769: WHILE l_consume_qty > x_actual_qty AND i <= l_PLR_tab.COUNT LOOP
770: -- try to convert PLR to DLR
771: l_partial_rec := l_PLR_tab(i);
772: gme_reservations_pvt.convert_partial_to_dlr
773: (p_reservation_rec => l_partial_rec
774: ,p_material_dtl_rec => p_material_dtl_rec
775: ,p_item_rec => p_item_rec
776: ,x_reservation_rec => l_reservation_rec

Line 872: END IF; -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS for gme_reservations_pvt.convert_partial_to_dlr

868: gme_debug.put_line ('after build and create build is successful');
869: END IF;
870:
871: END IF; -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND l_att
872: END IF; -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS for gme_reservations_pvt.convert_partial_to_dlr
873:
874: i := i + 1; -- move on to the next partial reservation
875: END LOOP;
876:

Line 1214: gme_reservations_pvt.get_reservation_dtl_qty

1210: IF l_rsrv_mode THEN
1211: l_prim_qty := p_rsrv_rec.primary_reservation_quantity;
1212: l_sec_qty := p_rsrv_rec.secondary_reservation_quantity;
1213:
1214: gme_reservations_pvt.get_reservation_dtl_qty
1215: (p_reservation_rec => p_rsrv_rec
1216: ,p_uom_code => p_mtl_dtl_rec.dtl_um
1217: ,x_qty => l_dtl_qty
1218: ,x_return_status => x_return_status);

Line 1222: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');

1218: ,x_return_status => x_return_status);
1219:
1220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1221: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1222: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');
1223: END IF;
1224:
1225: RAISE error_get_dtl_qty;
1226: END IF;

Line 1532: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));

1528: END IF;
1529: RAISE um_convert_error;
1530: END IF;
1531: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1532: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));
1533: END IF;
1534: END IF;
1535: gme_reservations_pvt.relieve_reservation
1536: (p_reservation_id => p_rsrv_rec.reservation_id

Line 1535: gme_reservations_pvt.relieve_reservation

1531: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1532: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));
1533: END IF;
1534: END IF;
1535: gme_reservations_pvt.relieve_reservation
1536: (p_reservation_id => p_rsrv_rec.reservation_id
1537: ,p_prim_relieve_qty => l_prim_qty
1538: ,x_return_status => x_return_status);
1539:

Line 1796: l_pending_rsrv_ind:= gme_reservations_pvt.pending_reservations_exist

1792: END IF;
1793:
1794: IF p_pending_rsrv_ind IS NULL THEN
1795: IF p_material_dtl_rec.line_type = gme_common_pvt.g_line_type_ing THEN
1796: l_pending_rsrv_ind:= gme_reservations_pvt.pending_reservations_exist
1797: (p_organization_id => p_material_dtl_rec.organization_id
1798: ,p_batch_id => p_material_dtl_rec.batch_id
1799: ,p_material_detail_id => p_material_dtl_rec.material_detail_id);
1800: ELSE