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 579: gme_reservations_pvt.get_material_reservations

575: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);
576: END IF;
577:
578: -- channges for GMO
579: gme_reservations_pvt.get_material_reservations
580: (p_organization_id => p_material_dtl_rec.organization_id
581: ,p_batch_id => p_material_dtl_rec.batch_id
582: ,p_material_detail_id => p_material_dtl_rec.material_detail_id
583: ,p_dispense_ind => nvl(p_material_dtl_rec.dispense_ind,'N')

Line 616: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified

612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
613: 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);
614: END IF;
615: /* Bug 5441643 Added NVL condition for location control code*/
616: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified
617: (p_reservation_rec => l_reservation_rec
618: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
619: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

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

617: (p_reservation_rec => l_reservation_rec
618: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
619: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
621: 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);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');

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

621: 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);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');
626: RAISE error_unexpected;
627: ENd IF;
628: END IF;
629:

Line 722: gme_reservations_pvt.convert_partial_to_dlr

718: -- try to convert and consume Partial reservations
719: WHILE l_consume_qty > x_actual_qty AND i <= l_PLR_tab.COUNT LOOP
720: -- try to convert PLR to DLR
721: l_partial_rec := l_PLR_tab(i);
722: gme_reservations_pvt.convert_partial_to_dlr
723: (p_reservation_rec => l_partial_rec
724: ,p_material_dtl_rec => p_material_dtl_rec
725: ,p_item_rec => p_item_rec
726: ,x_reservation_rec => l_reservation_rec

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

743: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN
744: x_return_status := l_return_status;
745: RAISE error_build_trxn;
746: END IF;
747: END IF; -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS for gme_reservations_pvt.convert_partial_to_dlr
748:
749: i := i + 1; -- move on to the next partial reservation
750: END LOOP;
751:

Line 1022: gme_reservations_pvt.get_reservation_dtl_qty

1018: IF l_rsrv_mode THEN
1019: l_prim_qty := p_rsrv_rec.primary_reservation_quantity;
1020: l_sec_qty := p_rsrv_rec.secondary_reservation_quantity;
1021:
1022: gme_reservations_pvt.get_reservation_dtl_qty
1023: (p_reservation_rec => p_rsrv_rec
1024: ,p_uom_code => p_mtl_dtl_rec.dtl_um
1025: ,x_qty => l_dtl_qty
1026: ,x_return_status => x_return_status);

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

1026: ,x_return_status => x_return_status);
1027:
1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1030: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');
1031: END IF;
1032:
1033: RAISE error_get_dtl_qty;
1034: END IF;

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

1178: END IF;
1179: RAISE um_convert_error;
1180: END IF;
1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1182: 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));
1183: END IF;
1184: END IF;
1185: gme_reservations_pvt.relieve_reservation
1186: (p_reservation_id => p_rsrv_rec.reservation_id

Line 1185: gme_reservations_pvt.relieve_reservation

1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1182: 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));
1183: END IF;
1184: END IF;
1185: gme_reservations_pvt.relieve_reservation
1186: (p_reservation_id => p_rsrv_rec.reservation_id
1187: ,p_prim_relieve_qty => l_prim_qty
1188: ,x_return_status => x_return_status);
1189:

Line 1443: l_pending_rsrv_ind:= gme_reservations_pvt.pending_reservations_exist

1439: END IF;
1440:
1441: IF p_pending_rsrv_ind IS NULL THEN
1442: IF p_material_dtl_rec.line_type = gme_common_pvt.g_line_type_ing THEN
1443: l_pending_rsrv_ind:= gme_reservations_pvt.pending_reservations_exist
1444: (p_organization_id => p_material_dtl_rec.organization_id
1445: ,p_batch_id => p_material_dtl_rec.batch_id
1446: ,p_material_detail_id => p_material_dtl_rec.material_detail_id);
1447: ELSE