DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PVT dependencies on WSH_UTIL_CORE

Line 2044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2040: -- Get whse code
2041: OPEN get_whse_code (p_organization_id);
2042: FETCH get_whse_code INTO l_whse_code,l_whse_loct_ctl;
2043: IF ( get_whse_code%NOTFOUND ) THEN
2044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2045: GMI_RESERVATION_UTIL.PRINTLN('Error retrieving whse code');
2046: RAISE NO_DATA_FOUND;
2047: CLOSE get_whse_code;
2048: RETURN;

Line 2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2750: OPEN get_item_ctl;
2751: FETCH get_item_ctl INTO l_item_loct_ctl, l_lot_ctl, l_noninv_ind;
2752: IF(get_item_ctl%NOTFOUND)
2753: THEN
2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2755: CLOSE get_item_ctl;
2756: GMI_RESERVATION_UTIL.PrintLn('Error retrieving item details');
2757: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
2758: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

Line 2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2765: -- Get whse code
2766: OPEN get_whse_code (p_organization_id);
2767: FETCH get_whse_code INTO l_whse_code,l_whse_loct_ctl;
2768: IF ( get_whse_code%NOTFOUND ) THEN
2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2770: CLOSE get_whse_code;
2771: GMI_RESERVATION_UTIL.PrintLn('Error retrieving whse code');
2772: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
2773: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);

Line 2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2801: IF (l_is_noctl <> TRUE) THEN
2802: OPEN get_trans_for_del;
2803: FETCH get_trans_for_del INTO l_qty_reserved,l_qty2_reserved;
2804: IF (get_trans_for_del%NOTFOUND ) THEN
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2806: CLOSE get_trans_for_del;
2807: GMI_RESERVATION_UTIL.PrintLn('Error retrieving Reserved qunatity');
2808: RAISE FND_API.G_EXC_ERROR;
2809: ELSE