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.WSH_PICKING_BATCHES_GRP dependencies on FND_MESSAGE

Line 375: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

371: WSH_DEBUG_SV.logmsg(l_module_name, 'P_RULE_ID : ' || TO_CHAR( p_rule_id ) || 'P_RULE_NAME: '|| p_rule_name || ' DOES NOT EXIST.');
372: --}
373: END IF;
374: --
375: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: wsh_util_core.add_message(x_return_status);
379: CLOSE Get_Picking_Rule_Info;

Line 376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');

372: --}
373: END IF;
374: --
375: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: wsh_util_core.add_message(x_return_status);
379: CLOSE Get_Picking_Rule_Info;
380: IF l_debug_on THEN

Line 412: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

408: -- BUG # 6719369 (Rplenishment project); Need to consider the
409: -- 'replenishment completed' status.
410: IF ( l_batch_in_rec.Backorders_Only_Flag NOT IN ('I','E','O','M') ) THEN
411: --{
412: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
415: wsh_util_core.add_message(x_return_status);
416: return;

Line 413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');

409: -- 'replenishment completed' status.
410: IF ( l_batch_in_rec.Backorders_Only_Flag NOT IN ('I','E','O','M') ) THEN
411: --{
412: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
415: wsh_util_core.add_message(x_return_status);
416: return;
417: --}

Line 719: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

715: OPEN Get_Order_Type_id(l_batch_in_rec.Order_Type_Id,l_batch_in_rec.Order_Type_Name);
716: FETCH Get_Order_Type_id INTO l_batch_in_rec.Order_Type_Id;
717: IF ( Get_Order_Type_id%NOTFOUND ) THEN
718: --{
719: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
722: wsh_util_core.add_message(x_return_status);
723: CLOSE Get_Order_Type_id;

Line 720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');

716: FETCH Get_Order_Type_id INTO l_batch_in_rec.Order_Type_Id;
717: IF ( Get_Order_Type_id%NOTFOUND ) THEN
718: --{
719: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
722: wsh_util_core.add_message(x_return_status);
723: CLOSE Get_Order_Type_id;
724: return;

Line 755: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

751: --}
752: END IF;
753: IF ( l_batch_in_rec.order_number IS NOT NULL AND l_batch_grp_rec.order_type_id IS NULL ) THEN
754: --{
755: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
758: wsh_util_core.add_message(x_return_status);
759: return;

Line 756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');

752: END IF;
753: IF ( l_batch_in_rec.order_number IS NOT NULL AND l_batch_grp_rec.order_type_id IS NULL ) THEN
754: --{
755: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
758: wsh_util_core.add_message(x_return_status);
759: return;
760: --}

Line 768: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

764: OPEN Get_Order_Header_id(l_batch_in_rec.Order_Number,l_batch_grp_rec.Order_Type_id,l_batch_in_rec.order_header_id);
765: FETCH Get_Order_Header_id INTO l_batch_in_rec.order_header_id;
766: IF ( Get_Order_Header_id%NOTFOUND ) THEN
767: --{
768: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
770: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
771: wsh_util_core.add_message(x_return_status);
772: CLOSE Get_Order_Header_id;

Line 769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');

765: FETCH Get_Order_Header_id INTO l_batch_in_rec.order_header_id;
766: IF ( Get_Order_Header_id%NOTFOUND ) THEN
767: --{
768: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
770: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
771: wsh_util_core.add_message(x_return_status);
772: CLOSE Get_Order_Header_id;
773: return;

Line 803: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

799: --}
800: END IF;
801: IF ( l_batch_in_rec.ship_set_number IS NOT NULL AND l_batch_grp_rec.order_header_id IS NULL ) THEN
802: --{
803: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: wsh_util_core.add_message(x_return_status);
807: return;

Line 804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');

800: END IF;
801: IF ( l_batch_in_rec.ship_set_number IS NOT NULL AND l_batch_grp_rec.order_header_id IS NULL ) THEN
802: --{
803: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: wsh_util_core.add_message(x_return_status);
807: return;
808: --}

Line 816: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

812: OPEN Get_Ship_Set_Id(l_batch_in_rec.ship_set_id,l_batch_in_rec.ship_set_number,l_batch_grp_rec.order_header_id);
813: FETCH Get_Ship_Set_Id INTO l_batch_in_rec.ship_set_id;
814: IF ( Get_Ship_Set_Id%NOTFOUND ) THEN
815: --{
816: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
819: wsh_util_core.add_message(x_return_status);
820: CLOSE Get_Ship_Set_Id;

Line 817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');

813: FETCH Get_Ship_Set_Id INTO l_batch_in_rec.ship_set_id;
814: IF ( Get_Ship_Set_Id%NOTFOUND ) THEN
815: --{
816: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
819: wsh_util_core.add_message(x_return_status);
820: CLOSE Get_Ship_Set_Id;
821: return;

Line 1300: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');

1296: IF l_batch_grp_rec.ship_confirm_rule_id IS NULL THEN
1297: --{
1298: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1299: --
1300: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1302: wsh_util_core.add_message(x_return_status);
1303: --
1304: IF l_debug_on THEN

Line 1399: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1395: OPEN Check_Item_id(l_batch_in_rec.Inventory_Item_Id,l_batch_grp_rec.organization_id);
1396: FETCH Check_Item_id INTO l_batch_in_rec.Inventory_Item_Id;
1397: IF ( Check_Item_id%NOTFOUND ) THEN
1398: --{
1399: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1402: wsh_util_core.add_message(x_return_status);
1403: CLOSE Check_Item_id;

Line 1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');

1396: FETCH Check_Item_id INTO l_batch_in_rec.Inventory_Item_Id;
1397: IF ( Check_Item_id%NOTFOUND ) THEN
1398: --{
1399: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1402: wsh_util_core.add_message(x_return_status);
1403: CLOSE Check_Item_id;
1404: return;

Line 1432: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1428: OPEN Check_Subinventory( l_batch_in_rec.Default_Stage_Subinventory,l_batch_grp_rec.organization_id);
1429: FETCH Check_Subinventory INTO l_batch_in_rec.Default_Stage_Subinventory;
1430: IF ( Check_Subinventory%NOTFOUND ) THEN
1431: --{
1432: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1435: wsh_util_core.add_message(x_return_status);
1436: CLOSE Check_Subinventory;

Line 1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');

1429: FETCH Check_Subinventory INTO l_batch_in_rec.Default_Stage_Subinventory;
1430: IF ( Check_Subinventory%NOTFOUND ) THEN
1431: --{
1432: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1435: wsh_util_core.add_message(x_return_status);
1436: CLOSE Check_Subinventory;
1437: return;

Line 1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1454: OPEN Check_Subinventory( l_batch_in_rec.rel_subinventory,l_batch_grp_rec.organization_id);
1455: FETCH Check_Subinventory INTO l_batch_in_rec.rel_subinventory;
1456: IF ( Check_Subinventory%NOTFOUND ) THEN
1457: --{
1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REL_SUBINVENTORY');
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: CLOSE Check_Subinventory;

Line 1459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REL_SUBINVENTORY');

1455: FETCH Check_Subinventory INTO l_batch_in_rec.rel_subinventory;
1456: IF ( Check_Subinventory%NOTFOUND ) THEN
1457: --{
1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REL_SUBINVENTORY');
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: CLOSE Check_Subinventory;
1463: return;

Line 1485: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1481: OPEN Check_Locator_Id( l_batch_in_rec.Default_Stage_Locator_Id,l_batch_grp_rec.Default_Stage_Subinventory,l_batch_grp_rec.organization_id);
1482: FETCH Check_Locator_Id INTO l_batch_in_rec.Default_Stage_Locator_Id;
1483: IF ( Check_Locator_Id%NOTFOUND ) THEN
1484: --{
1485: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1488: wsh_util_core.add_message(x_return_status);
1489: CLOSE Check_Locator_Id;

Line 1486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');

1482: FETCH Check_Locator_Id INTO l_batch_in_rec.Default_Stage_Locator_Id;
1483: IF ( Check_Locator_Id%NOTFOUND ) THEN
1484: --{
1485: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1488: wsh_util_core.add_message(x_return_status);
1489: CLOSE Check_Locator_Id;
1490: return;

Line 1513: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1509: OPEN Check_Subinventory( l_batch_in_rec.Pick_From_Subinventory,l_batch_grp_rec.organization_id);
1510: FETCH Check_Subinventory INTO l_batch_in_rec.Pick_From_Subinventory;
1511: IF ( Check_Subinventory%NOTFOUND ) THEN
1512: --{
1513: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_SUBINVENTORY');
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: wsh_util_core.add_message(x_return_status);
1517: CLOSE Check_Subinventory;

Line 1514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_SUBINVENTORY');

1510: FETCH Check_Subinventory INTO l_batch_in_rec.Pick_From_Subinventory;
1511: IF ( Check_Subinventory%NOTFOUND ) THEN
1512: --{
1513: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_SUBINVENTORY');
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: wsh_util_core.add_message(x_return_status);
1517: CLOSE Check_Subinventory;
1518: return;

Line 1540: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1536: OPEN Check_Locator_Id( l_batch_in_rec.Pick_From_locator_Id,l_batch_grp_rec.Pick_From_Subinventory,l_batch_grp_rec.organization_id );
1537: FETCH Check_Locator_Id INTO l_batch_in_rec.Pick_From_locator_Id;
1538: IF ( Check_Locator_Id%NOTFOUND ) THEN
1539: --{
1540: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_LOCATOR_ID');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: wsh_util_core.add_message(x_return_status);
1544: CLOSE Check_Locator_Id;

Line 1541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_LOCATOR_ID');

1537: FETCH Check_Locator_Id INTO l_batch_in_rec.Pick_From_locator_Id;
1538: IF ( Check_Locator_Id%NOTFOUND ) THEN
1539: --{
1540: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_LOCATOR_ID');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: wsh_util_core.add_message(x_return_status);
1544: CLOSE Check_Locator_Id;
1545: return;

Line 1577: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1573: OPEN Check_Delivery_Detail_Id(l_batch_in_rec.Delivery_Detail_Id);
1574: FETCH Check_Delivery_Detail_Id INTO l_batch_in_rec.Delivery_Detail_Id;
1575: IF ( Check_Delivery_Detail_Id%NOTFOUND ) THEN
1576: --{
1577: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1580: wsh_util_core.add_message(x_return_status);
1581: CLOSE Check_Delivery_Detail_Id;

Line 1578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');

1574: FETCH Check_Delivery_Detail_Id INTO l_batch_in_rec.Delivery_Detail_Id;
1575: IF ( Check_Delivery_Detail_Id%NOTFOUND ) THEN
1576: --{
1577: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1580: wsh_util_core.add_message(x_return_status);
1581: CLOSE Check_Delivery_Detail_Id;
1582: return;

Line 1607: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1603: OPEN Check_Category_Set_Id(l_batch_in_rec.Category_Set_Id);
1604: FETCH Check_Category_Set_Id INTO l_batch_in_rec.Category_Set_Id;
1605: IF ( Check_Category_Set_Id%NOTFOUND ) THEN
1606: --{
1607: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: wsh_util_core.add_message(x_return_status);
1611: CLOSE Check_Category_Set_Id;

Line 1608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');

1604: FETCH Check_Category_Set_Id INTO l_batch_in_rec.Category_Set_Id;
1605: IF ( Check_Category_Set_Id%NOTFOUND ) THEN
1606: --{
1607: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: wsh_util_core.add_message(x_return_status);
1611: CLOSE Check_Category_Set_Id;
1612: return;

Line 1637: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1633: OPEN Check_Category_Id(l_batch_in_rec.Category_Id);
1634: FETCH Check_Category_Id INTO l_batch_in_rec.Category_Id;
1635: IF ( Check_Category_Id%NOTFOUND ) THEN
1636: --{
1637: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: wsh_util_core.add_message(x_return_status);
1641: CLOSE Check_Category_Id;

Line 1638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');

1634: FETCH Check_Category_Id INTO l_batch_in_rec.Category_Id;
1635: IF ( Check_Category_Id%NOTFOUND ) THEN
1636: --{
1637: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: wsh_util_core.add_message(x_return_status);
1641: CLOSE Check_Category_Id;
1642: return;

Line 1666: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1662: IF ( l_batch_in_rec.Ship_Set_Smc_Flag <> FND_API.G_MISS_CHAR ) THEN
1663: --{
1664: IF ( l_batch_in_rec.Ship_Set_Smc_Flag NOT IN ('I','E','A') ) THEN
1665: --{
1666: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1668: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1669: wsh_util_core.add_message(x_return_status);
1670: return;

Line 1667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');

1663: --{
1664: IF ( l_batch_in_rec.Ship_Set_Smc_Flag NOT IN ('I','E','A') ) THEN
1665: --{
1666: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1668: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1669: wsh_util_core.add_message(x_return_status);
1670: return;
1671: --}

Line 1691: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1687: IF (l_batch_in_rec.Auto_Pick_Confirm_Flag <> FND_API.G_MISS_CHAR) THEN
1688: --{
1689: IF ( l_batch_in_rec.Auto_Pick_Confirm_Flag NOT IN ('Y','N') ) THEN
1690: --{
1691: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1694: wsh_util_core.add_message(x_return_status);
1695: return;

Line 1692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');

1688: --{
1689: IF ( l_batch_in_rec.Auto_Pick_Confirm_Flag NOT IN ('Y','N') ) THEN
1690: --{
1691: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1694: wsh_util_core.add_message(x_return_status);
1695: return;
1696: --}

Line 1715: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1711: IF (l_batch_in_rec.Existing_Rsvs_Only_Flag <> FND_API.G_MISS_CHAR) THEN
1712: --{
1713: IF ( l_batch_in_rec.Existing_Rsvs_Only_Flag NOT IN ('N','Y')) THEN
1714: --{
1715: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1716: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: return;

Line 1716: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');

1712: --{
1713: IF ( l_batch_in_rec.Existing_Rsvs_Only_Flag NOT IN ('N','Y')) THEN
1714: --{
1715: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1716: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: return;
1720: --}

Line 1740: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1736: IF (l_batch_in_rec.Include_Planned_Lines <> FND_API.G_MISS_CHAR) THEN
1737: --{
1738: IF ( l_batch_in_rec.Include_Planned_Lines NOT IN ('Y','N') ) THEN
1739: --{
1740: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: wsh_util_core.add_message(x_return_status);
1744: return;

Line 1741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');

1737: --{
1738: IF ( l_batch_in_rec.Include_Planned_Lines NOT IN ('Y','N') ) THEN
1739: --{
1740: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: wsh_util_core.add_message(x_return_status);
1744: return;
1745: --}

Line 1765: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1761: IF (l_batch_in_rec.Autodetail_Pr_Flag <> FND_API.G_MISS_CHAR) THEN
1762: --{
1763: IF ( l_batch_in_rec.Autodetail_Pr_Flag NOT IN ('Y','N') ) THEN
1764: --{
1765: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: wsh_util_core.add_message(x_return_status);
1769: return;

Line 1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');

1762: --{
1763: IF ( l_batch_in_rec.Autodetail_Pr_Flag NOT IN ('Y','N') ) THEN
1764: --{
1765: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: wsh_util_core.add_message(x_return_status);
1769: return;
1770: --}

Line 1791: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1787: IF (l_batch_in_rec.Autopack_Flag <> FND_API.G_MISS_CHAR) THEN
1788: --{
1789: IF ( l_batch_in_rec.Autopack_Flag NOT IN ('Y','N') ) THEN
1790: --{
1791: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1792: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1794: wsh_util_core.add_message(x_return_status);
1795: return;

Line 1792: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');

1788: --{
1789: IF ( l_batch_in_rec.Autopack_Flag NOT IN ('Y','N') ) THEN
1790: --{
1791: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1792: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1794: wsh_util_core.add_message(x_return_status);
1795: return;
1796: --}

Line 1818: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1814: IF (l_batch_in_rec.Autopack_Level <> FND_API.G_MISS_NUM) THEN
1815: --{
1816: IF ( l_batch_in_rec.Autopack_Level NOT IN (0,1,2) ) THEN
1817: --{
1818: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1821: wsh_util_core.add_message(x_return_status);
1822: return;

Line 1819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');

1815: --{
1816: IF ( l_batch_in_rec.Autopack_Level NOT IN (0,1,2) ) THEN
1817: --{
1818: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1821: wsh_util_core.add_message(x_return_status);
1822: return;
1823: --}

Line 1845: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1841: IF (l_batch_in_rec.Task_Planning_Flag <> FND_API.G_MISS_CHAR) THEN
1842: --{
1843: IF ( l_batch_in_rec.Task_Planning_Flag NOT IN ('Y','N') ) THEN
1844: --{
1845: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: wsh_util_core.add_message(x_return_status);
1849: return;

Line 1846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');

1842: --{
1843: IF ( l_batch_in_rec.Task_Planning_Flag NOT IN ('Y','N') ) THEN
1844: --{
1845: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: wsh_util_core.add_message(x_return_status);
1849: return;
1850: --}

Line 1877: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1873: IF (l_batch_in_rec.dynamic_replenishment_flag <> FND_API.G_MISS_CHAR) THEN
1874: --{
1875: IF ( l_batch_in_rec.dynamic_replenishment_flag NOT IN ('Y','N') ) THEN
1876: --{
1877: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1878: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','dynamic_replenishment_flag');
1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1880: wsh_util_core.add_message(x_return_status);
1881: return;

Line 1878: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','dynamic_replenishment_flag');

1874: --{
1875: IF ( l_batch_in_rec.dynamic_replenishment_flag NOT IN ('Y','N') ) THEN
1876: --{
1877: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1878: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','dynamic_replenishment_flag');
1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1880: wsh_util_core.add_message(x_return_status);
1881: return;
1882: --}

Line 1909: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

1905: IF (l_batch_in_rec.Non_Picking_flag <> FND_API.G_MISS_CHAR) THEN
1906: --{
1907: IF ( l_batch_in_rec.Non_Picking_flag NOT IN ('Y','N') ) THEN
1908: --{
1909: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1912: wsh_util_core.add_message(x_return_status);
1913: return;

Line 1910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');

1906: --{
1907: IF ( l_batch_in_rec.Non_Picking_flag NOT IN ('Y','N') ) THEN
1908: --{
1909: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1912: wsh_util_core.add_message(x_return_status);
1913: return;
1914: --}

Line 2264: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

2260: --
2261: IF (l_batch_grp_rec.autocreate_delivery_flag IS NOT NULL AND
2262: l_batch_grp_rec.autocreate_Delivery_flag NOT IN ('Y', 'N')) THEN
2263: --{
2264: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2267: wsh_util_core.add_message(x_return_status);
2268: --

Line 2265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');

2261: IF (l_batch_grp_rec.autocreate_delivery_flag IS NOT NULL AND
2262: l_batch_grp_rec.autocreate_Delivery_flag NOT IN ('Y', 'N')) THEN
2263: --{
2264: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2267: wsh_util_core.add_message(x_return_status);
2268: --
2269: IF l_debug_on THEN

Line 2284: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');

2280: --
2281: IF (l_batch_grp_rec.ac_delivery_criteria IS NOT NULL AND
2282: l_batch_grp_rec.autocreate_delivery_flag <> 'Y') THEN
2283: --{
2284: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');
2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2286: wsh_util_core.add_message(x_return_status, l_module_name);
2287: --
2288: IF l_debug_on THEN

Line 2299: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');

2295: --
2296: IF l_batch_grp_rec.Append_Flag = 'Y' or l_batch_grp_rec.Append_Flag is NULL THEN
2297:
2298: IF l_batch_grp_rec.organization_id is NULL THEN
2299: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2301: wsh_util_core.add_message(x_return_status);
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.pop(l_module_name);

Line 2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');

2321: p_msg_data => l_msg_data
2322: );
2323:
2324: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2328: wsh_util_core.add_message(x_return_status);
2329: IF l_debug_on THEN

Line 2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));

2322: );
2323:
2324: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2328: wsh_util_core.add_message(x_return_status);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.pop(l_module_name);

Line 2336: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');

2332: return;
2333: END IF;
2334:
2335: IF NVL(l_batch_grp_rec.autocreate_delivery_flag, 'N') <> 'Y' THEN
2336: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2338: wsh_util_core.add_message(x_return_status);
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.pop(l_module_name);

Line 2346: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');

2342: return;
2343: END IF;
2344:
2345: IF NVL(l_batch_grp_rec.ac_delivery_criteria, 'Y') <> 'N' THEN
2346: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2348: wsh_util_core.add_message(x_return_status);
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.pop(l_module_name);

Line 2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');

2352: return;
2353: END IF;
2354:
2355: IF NVL(l_batch_grp_rec.auto_pick_confirm_flag, 'Y') <> 'N' THEN
2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2358: wsh_util_core.add_message(x_return_status);
2359: IF l_debug_on THEN
2360: WSH_DEBUG_SV.pop(l_module_name);

Line 2366: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');

2362: return;
2363: END IF;
2364:
2365: IF l_batch_grp_rec.ship_confirm_rule_id is not NULL THEN
2366: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2368: wsh_util_core.add_message(x_return_status);
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.pop(l_module_name);

Line 2376: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');

2372: return;
2373: END IF;
2374:
2375: IF NVL(l_batch_grp_rec.autopack_flag, 'Y') <> 'N' THEN
2376: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2378: wsh_util_core.add_message(x_return_status);
2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.pop(l_module_name);

Line 2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

2382: return;
2383: END IF;
2384:
2385: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2389: wsh_util_core.add_message(x_return_status);
2390: IF l_debug_on THEN

Line 2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');

2383: END IF;
2384:
2385: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2389: wsh_util_core.add_message(x_return_status);
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.pop(l_module_name);

Line 2405: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');

2401: FETCH c_location_id into l_ship_from_loc_id;
2402: close c_location_id;
2403:
2404: IF l_ship_from_loc_id <> l_batch_grp_rec.Ship_From_Location_Id THEN
2405: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2407: wsh_util_core.add_message(x_return_status);
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.pop(l_module_name);

Line 2435: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');

2431: l_batch_grp_rec.Project_Id IS NULL AND l_batch_grp_rec.Task_Id IS NULL ) THEN --{
2432: --
2433: IF l_batch_grp_rec.Organization_Id IS NULL THEN --{
2434: -- Fatal error if no warehouse specified
2435: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2437: wsh_util_core.add_message(x_return_status);
2438: IF l_debug_on THEN
2439: WSH_DEBUG_SV.pop(l_module_name);

Line 2444: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');

2440: END IF;
2441: RETURN;
2442: ELSE --}{
2443: -- Warning if warehouse specified and others null
2444: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');
2445: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2446: wsh_util_core.add_message(x_return_status);
2447: END IF; --}
2448: --

Line 2514: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');

2510: (WSH_PICK_LIST.C_INVENTORY_ONLY,WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2511: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY
2512: )
2513: ) THEN
2514: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2516: wsh_util_core.add_message(x_return_status);
2517: IF l_debug_on THEN
2518: WSH_DEBUG_SV.pop(l_module_name);

Line 2529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');

2525: WMS_CROSSDOCK_GRP.validate_planxdock_crt_id
2526: (p_criterion_id => l_batch_grp_rec.crossdock_criteria_id,
2527: x_return_status => l_return_status);
2528: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2531: wsh_util_core.add_message(x_return_status);
2532: IF l_debug_on THEN
2533: WSH_DEBUG_SV.pop(l_module_name);

Line 2539: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');

2535: RETURN;
2536: END IF;
2537: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2538: l_batch_grp_rec.allocation_method = (WSH_PICK_LIST.C_INVENTORY_ONLY)) THEN
2539: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2541: wsh_util_core.add_message(x_return_status);
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.pop(l_module_name);

Line 2550: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

2546: -- Bug#7168917: Dynamic_replenish_flag value should not be 'Yes' when
2547: -- allocation method is 'Cross Dock Only' OR 'Prioritize Inventory'.
2548: ELSIF (l_batch_grp_rec.dynamic_replenishment_flag = 'Y' AND
2549: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2550: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: wsh_util_core.add_message(x_return_status);
2554: IF l_debug_on THEN

Line 2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');

2547: -- allocation method is 'Cross Dock Only' OR 'Prioritize Inventory'.
2548: ELSIF (l_batch_grp_rec.dynamic_replenishment_flag = 'Y' AND
2549: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2550: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: wsh_util_core.add_message(x_return_status);
2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.pop(l_module_name);

Line 2565: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');

2561: IF l_batch_grp_rec.existing_rsvs_only_flag = 'Y' AND
2562: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2563: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,
2564: WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2565: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2567: wsh_util_core.add_message(x_return_status);
2568: IF l_debug_on THEN
2569: WSH_DEBUG_SV.pop(l_module_name);

Line 2578: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');

2574: -- Bug #7505524: end of bug.
2575: ELSE -- non WMS org
2576: IF l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2577: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2578: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2580: wsh_util_core.add_message(x_return_status);
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.pop(l_module_name);

Line 2743: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_PR');

2739: --
2740:
2741: WHEN WSH_INVALID_CONSOL_DEL THEN
2742: ROLLBACK TO PICKING_BATCH_GRP;
2743: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_PR');
2744: FND_MESSAGE.SET_TOKEN('PARAMETER',l_batch_in_rec.Delivery_id);
2745: x_return_status := FND_API.G_RET_STS_ERROR ;
2746: wsh_util_core.add_message(x_return_status);
2747: FND_MSG_PUB.Count_And_Get

Line 2744: FND_MESSAGE.SET_TOKEN('PARAMETER',l_batch_in_rec.Delivery_id);

2740:
2741: WHEN WSH_INVALID_CONSOL_DEL THEN
2742: ROLLBACK TO PICKING_BATCH_GRP;
2743: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_PR');
2744: FND_MESSAGE.SET_TOKEN('PARAMETER',l_batch_in_rec.Delivery_id);
2745: x_return_status := FND_API.G_RET_STS_ERROR ;
2746: wsh_util_core.add_message(x_return_status);
2747: FND_MSG_PUB.Count_And_Get
2748: (

Line 2969: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

2965: END IF;
2966: ELSE
2967: --
2968: --
2969: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2970: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2972: wsh_util_core.add_message(x_return_status);
2973: return;

Line 2970: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');

2966: ELSE
2967: --
2968: --
2969: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2970: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2972: wsh_util_core.add_message(x_return_status);
2973: return;
2974: --}

Line 2982: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

2978:
2979: -- Validating the Release Mode
2980: IF ( ( p_release_mode IS NULL ) OR ( p_release_mode NOT IN ('CONCURRENT','ONLINE'))) THEN
2981: --{
2982: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2984: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2985: wsh_util_core.add_message(x_return_status);
2986: return;

Line 2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');

2979: -- Validating the Release Mode
2980: IF ( ( p_release_mode IS NULL ) OR ( p_release_mode NOT IN ('CONCURRENT','ONLINE'))) THEN
2981: --{
2982: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2984: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2985: wsh_util_core.add_message(x_return_status);
2986: return;
2987: --}

Line 3047: FND_MESSAGE.SET_NAME('ONT','SO_OTHER_CONCURRENT_REQUEST_ID');

3043: );
3044:
3045: IF ( x_request_id > 0) THEN
3046: --{
3047: FND_MESSAGE.SET_NAME('ONT','SO_OTHER_CONCURRENT_REQUEST_ID');
3048: FND_MESSAGE.SET_TOKEN('REQUESTID',TO_CHAR(x_request_id));
3049: ELSE
3050: FND_MESSAGE.SET_NAME('WSH','WSH_PR_REVOKED');
3051: FND_MESSAGE.SET_NAME('ONT','SO_SH_NO_CREATE_PICK_SLIPS');

Line 3048: FND_MESSAGE.SET_TOKEN('REQUESTID',TO_CHAR(x_request_id));

3044:
3045: IF ( x_request_id > 0) THEN
3046: --{
3047: FND_MESSAGE.SET_NAME('ONT','SO_OTHER_CONCURRENT_REQUEST_ID');
3048: FND_MESSAGE.SET_TOKEN('REQUESTID',TO_CHAR(x_request_id));
3049: ELSE
3050: FND_MESSAGE.SET_NAME('WSH','WSH_PR_REVOKED');
3051: FND_MESSAGE.SET_NAME('ONT','SO_SH_NO_CREATE_PICK_SLIPS');
3052: --}

Line 3050: FND_MESSAGE.SET_NAME('WSH','WSH_PR_REVOKED');

3046: --{
3047: FND_MESSAGE.SET_NAME('ONT','SO_OTHER_CONCURRENT_REQUEST_ID');
3048: FND_MESSAGE.SET_TOKEN('REQUESTID',TO_CHAR(x_request_id));
3049: ELSE
3050: FND_MESSAGE.SET_NAME('WSH','WSH_PR_REVOKED');
3051: FND_MESSAGE.SET_NAME('ONT','SO_SH_NO_CREATE_PICK_SLIPS');
3052: --}
3053: END IF;
3054:

Line 3051: FND_MESSAGE.SET_NAME('ONT','SO_SH_NO_CREATE_PICK_SLIPS');

3047: FND_MESSAGE.SET_NAME('ONT','SO_OTHER_CONCURRENT_REQUEST_ID');
3048: FND_MESSAGE.SET_TOKEN('REQUESTID',TO_CHAR(x_request_id));
3049: ELSE
3050: FND_MESSAGE.SET_NAME('WSH','WSH_PR_REVOKED');
3051: FND_MESSAGE.SET_NAME('ONT','SO_SH_NO_CREATE_PICK_SLIPS');
3052: --}
3053: END IF;
3054:
3055: ELSE

Line 3086: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');

3082: IF (nvl(l_pick_result,'F') = 'F' ) then
3083: --{
3084: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
3085: --{
3086: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE

Line 3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);

3083: --{
3084: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
3085: --{
3086: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');

Line 3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');

3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3093: wsh_util_core.add_message(x_return_status,l_module_name);
3094: --}
3095: END IF;

Line 3099: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');

3095: END IF;
3096: ELSIF (nvl(l_pick_result, 'F') = 'W') then
3097: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
3098: --{
3099: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');
3100: -- bug# 8340984 : Changed error to warning here (same behavior when performed
3101: -- pick release through release sales orders form)
3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3103: wsh_util_core.add_message(x_return_status,l_module_name);

Line 3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');

3101: -- pick release through release sales orders form)
3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3103: wsh_util_core.add_message(x_return_status,l_module_name);
3104: ELSE
3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3107: wsh_util_core.add_message(x_return_status,l_module_name);
3108: --}
3109: END IF;

Line 3111: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');

3107: wsh_util_core.add_message(x_return_status,l_module_name);
3108: --}
3109: END IF;
3110: ELSE
3111: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3113: wsh_util_core.add_message(x_return_status,l_module_name);
3114: --}
3115: END IF;

Line 3359: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');

3355: l_dd_upd_tbl(l_dd_upd_tbl.COUNT + 1) := l_dd_tbl(i);
3356: EXCEPTION
3357: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3358: rollback to lock_delivery_detail_loop;
3359: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
3360: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_dd_tbl(i));
3361: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3362: l_num_errors := l_num_errors + 1;
3363: --

Line 3360: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_dd_tbl(i));

3356: EXCEPTION
3357: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3358: rollback to lock_delivery_detail_loop;
3359: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
3360: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_dd_tbl(i));
3361: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3362: l_num_errors := l_num_errors + 1;
3363: --
3364: IF l_debug_on THEN