DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on WSH_UTIL_CORE

Line 151: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149:
150: WHEN l_warning THEN
151: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
152:
153: WHEN l_manual_warning THEN
154: x_return_status := G_WARNING_SHIP_SET;
155:

Line 535: WSH_Util_Core.PrintLn('Check Missing Falied ');

531: FOR I in 1..p_mo_line_TBL.COUNT LOOP
532: l_mo_line_rec := p_mo_line_tbl(I);
533: GMI_RESERVATION_UTIL.PrintLn('Check Missing For Row > '|| I );
534: IF check_required( p_mo_line_rec => l_mo_line_rec) THEN
535: WSH_Util_Core.PrintLn('Check Missing Falied ');
536: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
537: FND_MSG_PUB.ADD;
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 562: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

558: );
559:
560: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
561: l_no_error := '0';
562: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
563: RAISE l_warning;
564: ELSE
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;

Line 1340: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1336: x_msg_data => x_msg_data,
1337: x_reservation_id => d_trans_id,
1338: p_line_id => l_mo_line_rec.txn_source_line_id
1339: );
1340: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1341: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: END IF;
1344:

Line 1417: WSH_Util_Core.PrintLn('Count MOL Table => '|| x_mo_line_tbl.COUNT);

1413:
1414: /* Load Output table */
1415:
1416: x_mo_line_tbl := l_mo_line_tbl;
1417: WSH_Util_Core.PrintLn('Count MOL Table => '|| x_mo_line_tbl.COUNT);
1418: IF( l_warning_flag = 1 ) THEN
1419: RAISE l_warning;
1420: END IF;
1421:

Line 1453: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1449:
1450: -- HW BUG#:2296620
1451: WHEN l_warning THEN
1452: ROLLBACK TO PICK_WAVE_CONFIRM;
1453: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1454: -- HW end of 2296620
1455:
1456: /* NC Bug #2557029 */
1457: WHEN l_tolerance_warning THEN

Line 1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);

1484: RETURN BOOLEAN
1485: IS
1486: BEGIN
1487:
1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);
1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);

Line 1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);

1485: IS
1486: BEGIN
1487:
1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);
1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);

Line 1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);

1486: BEGIN
1487:
1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);
1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);

Line 1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);

1487:
1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);
1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);
1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);

Line 1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);

1488: WSH_Util_Core.PrintLn('header id ==> '||p_mo_line_rec.header_id);
1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);
1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);
1496:

Line 1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);

1489: WSH_Util_Core.PrintLn('line num ==> '||p_mo_line_rec.line_number);
1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);
1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);
1496:
1497: IF p_mo_line_rec.header_id is NULL OR

Line 1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);

1490: WSH_Util_Core.PrintLn('org id ==> '||p_mo_line_rec.organization_id);
1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);
1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);
1496:
1497: IF p_mo_line_rec.header_id is NULL OR
1498: p_mo_line_rec.line_number is NULL OR

Line 1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);

1491: WSH_Util_Core.PrintLn('Item id ==> '||p_mo_line_rec.inventory_item_id);
1492: WSH_Util_Core.PrintLn('uom code ==> '||p_mo_line_rec.uom_code);
1493: WSH_Util_Core.PrintLn('quantity ==> '||p_mo_line_rec.quantity);
1494: WSH_Util_Core.PrintLn('status ==> '||p_mo_line_rec.line_status);
1495: WSH_Util_Core.PrintLn('trans id ==> '||p_mo_line_rec.transaction_type_id);
1496:
1497: IF p_mo_line_rec.header_id is NULL OR
1498: p_mo_line_rec.line_number is NULL OR
1499: p_mo_line_rec.organization_id is NULL OR

Line 1507: WSH_Util_Core.PrintLn('Return True');

1503: p_mo_line_rec.line_status is NULL OR
1504: p_mo_line_rec.transaction_type_id is NULL THEN
1505:
1506: RETURN TRUE;
1507: WSH_Util_Core.PrintLn('Return True');
1508: ELSE
1509: WSH_Util_Core.PrintLn('Return False');
1510: RETURN FALSE;
1511: END IF;

Line 1509: WSH_Util_Core.PrintLn('Return False');

1505:
1506: RETURN TRUE;
1507: WSH_Util_Core.PrintLn('Return True');
1508: ELSE
1509: WSH_Util_Core.PrintLn('Return False');
1510: RETURN FALSE;
1511: END IF;
1512:
1513: RETURN TRUE;

Line 1932: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1928: x_avail_req_quantity := NULL;
1929: x_max_quantity2_allowed := NULL;
1930: x_avail_req_quantity2 := NULL;
1931:
1932: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1933: RETURN;
1934: END IF;
1935:
1936: -- HW OPM Need to check the org for forking

Line 1958: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1954: x_max_quantity_allowed := NULL;
1955: x_avail_req_quantity := NULL;
1956: x_max_quantity2_allowed := NULL;
1957: x_avail_req_quantity2 := NULL;
1958: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1959: RETURN;
1960: END IF;
1961:
1962: -- HW OPM for debugging puproses. Print values

Line 2001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1997: x_max_quantity_allowed := NULL;
1998: x_avail_req_quantity := NULL;
1999: x_max_quantity2_allowed := NULL;
2000: x_avail_req_quantity2 := NULL;
2001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2002: RETURN;
2003: END IF;
2004:
2005: Get_Min_Max_Tolerance_Quantity

Line 2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2118: gmi_reservation_util.println('Value of x_avail_req_quantity is '||x_avail_req_quantity);
2119: gmi_reservation_util.println('Value of x_avail_req_quantity2 is '||x_avail_req_quantity2);
2120: END IF;
2121:
2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2123:
2124:
2125: EXCEPTION
2126: WHEN others THEN

Line 2147: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2143: x_avail_req_quantity := NULL;
2144: -- HW Added for OPM
2145: x_max_quantity2_allowed := NULL;
2146: x_avail_req_quantity2 := NULL;
2147: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2148: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2149:
2150: END check_quantity_to_pick;
2151:

Line 2148: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');

2144: -- HW Added for OPM
2145: x_max_quantity2_allowed := NULL;
2146: x_avail_req_quantity2 := NULL;
2147: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2148: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2149:
2150: END check_quantity_to_pick;
2151:
2152: PROCEDURE Get_Min_Max_Tolerance_Quantity