DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on FND_MESSAGE

Line 536: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');

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;
540:

Line 590: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');

586: /* Should I exit Loop Or Raise an exception */
587:
588: /*IF ( l_mo_line_rec.quantity_delivered = l_mo_line_rec.quantity_detailed )
589: OR ( l_mo_line_rec.quantity_detailed = 0) THEN
590: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');
591: FND_MSG_PUB.ADD;
592: raise FND_API.G_EXC_ERROR;
593: END IF; */
594:

Line 607: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

603: , x_msg_data => x_msg_data);
604:
605: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
606: THEN
607: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
608: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');
609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;

Line 608: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');

604:
605: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
606: THEN
607: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
608: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');
609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:

Line 609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

605: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
606: THEN
607: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
608: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');
609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: GMI_Reservation_Util.PrintLn('Item Found. Now Qty treatment');

Line 644: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');

640: FETCH cur_txn_no_default INTO l_trans_qty, l_trans_qty2;
641: IF cur_txn_no_default%NOTFOUND THEN
642: CLOSE cur_txn_no_default;
643: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
644: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647: CLOSE cur_txn_no_default;
648: l_trans_qty_sts := l_trans_qty;

Line 662: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');

658: FETCH cur_txn_no_dflt_sts INTO l_trans_qty, l_trans_qty2; -- this portion would be transacted
659: IF cur_txn_no_dflt_sts%NOTFOUND THEN
660: CLOSE cur_txn_no_dflt_sts;
661: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
662: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
663: END IF;
664: CLOSE cur_txn_no_dflt_sts;
665: GMI_Reservation_Util.PrintLn('trans_qty '||l_trans_qty ||' trans_qty2 '||l_trans_qty2 );
666: END IF;

Line 699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

695: , x_msg_data => x_msg_data
696: );
697: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
698: THEN
699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
700: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
701: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;

Line 700: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');

696: );
697: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
698: THEN
699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
700: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
701: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: ELSE

Line 701: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

697: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
698: THEN
699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
700: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
701: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: ELSE
705: OPEN cur_txn_with_default

Line 760: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');

756: p_quantity => l_trans_qty,
757: p_quantity2 => l_trans_qty2
758: );
759: IF x_return_status <> 'S' THEN
760: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: IF l_allowed = 'N' THEN
764: GMI_Reservation_Util.PrintLn('ATTENTION :');

Line 771: FND_MESSAGE.SET_NAME('GMI','GMI_API_OVER_SHIP_TOLERANCE');

767: ' The allocated quantity is '|| l_trans_qty ||' but the max allowed quantity is'||
768: l_max_qty || ' Please reduce allocation quantity ');
769:
770: /* NC Bug #2557029 */
771: FND_MESSAGE.SET_NAME('GMI','GMI_API_OVER_SHIP_TOLERANCE');
772: FND_MESSAGE.SET_TOKEN('QUANTITY1',to_char(l_trans_qty));
773: FND_MESSAGE.SET_TOKEN('QUANTITY2',to_char(l_max_qty));
774: FND_MESSAGE.SET_TOKEN('LINE_ID',l_mo_line_rec.line_id);
775: GMI_PICK_CONFIRM_PUB.PrintMsg('ERROR: MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||

Line 772: FND_MESSAGE.SET_TOKEN('QUANTITY1',to_char(l_trans_qty));

768: l_max_qty || ' Please reduce allocation quantity ');
769:
770: /* NC Bug #2557029 */
771: FND_MESSAGE.SET_NAME('GMI','GMI_API_OVER_SHIP_TOLERANCE');
772: FND_MESSAGE.SET_TOKEN('QUANTITY1',to_char(l_trans_qty));
773: FND_MESSAGE.SET_TOKEN('QUANTITY2',to_char(l_max_qty));
774: FND_MESSAGE.SET_TOKEN('LINE_ID',l_mo_line_rec.line_id);
775: GMI_PICK_CONFIRM_PUB.PrintMsg('ERROR: MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
776: ' can not be transacted because picked qty exceeds over shippment tolerance. '||

Line 773: FND_MESSAGE.SET_TOKEN('QUANTITY2',to_char(l_max_qty));

769:
770: /* NC Bug #2557029 */
771: FND_MESSAGE.SET_NAME('GMI','GMI_API_OVER_SHIP_TOLERANCE');
772: FND_MESSAGE.SET_TOKEN('QUANTITY1',to_char(l_trans_qty));
773: FND_MESSAGE.SET_TOKEN('QUANTITY2',to_char(l_max_qty));
774: FND_MESSAGE.SET_TOKEN('LINE_ID',l_mo_line_rec.line_id);
775: GMI_PICK_CONFIRM_PUB.PrintMsg('ERROR: MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
776: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
777: 'The allocated quantity is '|| l_trans_qty ||' but the max allowed quantity is'||

Line 774: FND_MESSAGE.SET_TOKEN('LINE_ID',l_mo_line_rec.line_id);

770: /* NC Bug #2557029 */
771: FND_MESSAGE.SET_NAME('GMI','GMI_API_OVER_SHIP_TOLERANCE');
772: FND_MESSAGE.SET_TOKEN('QUANTITY1',to_char(l_trans_qty));
773: FND_MESSAGE.SET_TOKEN('QUANTITY2',to_char(l_max_qty));
774: FND_MESSAGE.SET_TOKEN('LINE_ID',l_mo_line_rec.line_id);
775: GMI_PICK_CONFIRM_PUB.PrintMsg('ERROR: MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
776: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
777: 'The allocated quantity is '|| l_trans_qty ||' but the max allowed quantity is'||
778: l_max_qty || ' Please reduce allocation quantity ');

Line 886: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

882: --
883: -- Fail the pick confirm process if exception occured during truncation of transactions
884: --
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
887: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.truncate_trans_qty');
888: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;

Line 887: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.truncate_trans_qty');

883: -- Fail the pick confirm process if exception occured during truncation of transactions
884: --
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
887: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.truncate_trans_qty');
888: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: END IF;

Line 888: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

884: --
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
887: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.truncate_trans_qty');
888: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: END IF;
892: -- End 3776538

Line 1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

1090: GMI_Reservation_Util.PrintLn('Return Status from [1] Update_Shipping_Attributes Call '||l_return_status);
1091:
1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1095: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1096: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;

Line 1095: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');

1091:
1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1095: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1096: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099:

Line 1096: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1095: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1096: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099:
1100: /* Now Update staged_ind in transaction record from 0 to 1 */

Line 1122: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

1118:
1119: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1120: THEN
1121: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
1122: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1123: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
1124: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;

Line 1123: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');

1119: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1120: THEN
1121: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
1122: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1123: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
1124: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;

Line 1124: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

1120: THEN
1121: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
1122: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1123: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
1124: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:

Line 1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

1199: GMI_Reservation_Util.PrintLn('Return Status from [2] Update_Shipping_Attributes Call '||l_return_status);
1200:
1201: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1202: THEN
1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1204: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1205: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1204: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');

1200:
1201: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1202: THEN
1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1204: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1205: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF;

Line 1205: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

1201: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1202: THEN
1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1204: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1205: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF;
1209: /* HW end of bug #:1941429 */

Line 1553: FND_MESSAGE.Set_Name('GMI','MISSING');

1549:
1550: IF ( p_opm_item_id is NULL
1551: OR p_opm_item_id = 0
1552: OR p_opm_item_id = FND_API.G_MISS_NUM ) THEN
1553: FND_MESSAGE.Set_Name('GMI','MISSING');
1554: FND_MESSAGE.Set_Token('MISSING', 'Opm Item Id');
1555: FND_MSG_PUB.Add;
1556: raise FND_API.G_EXC_ERROR;
1557: END IF;

Line 1554: FND_MESSAGE.Set_Token('MISSING', 'Opm Item Id');

1550: IF ( p_opm_item_id is NULL
1551: OR p_opm_item_id = 0
1552: OR p_opm_item_id = FND_API.G_MISS_NUM ) THEN
1553: FND_MESSAGE.Set_Name('GMI','MISSING');
1554: FND_MESSAGE.Set_Token('MISSING', 'Opm Item Id');
1555: FND_MSG_PUB.Add;
1556: raise FND_API.G_EXC_ERROR;
1557: END IF;
1558:

Line 1561: FND_MESSAGE.Set_Name('GMI','MISSING');

1557: END IF;
1558:
1559: IF ( p_apps_from_uom is NULL
1560: OR p_apps_from_uom = FND_API.G_MISS_CHAR ) THEN
1561: FND_MESSAGE.Set_Name('GMI','MISSING');
1562: FND_MESSAGE.Set_Token('MISSING', 'apps from uom');
1563: FND_MSG_PUB.Add;
1564: raise FND_API.G_EXC_ERROR;
1565: END IF;

Line 1562: FND_MESSAGE.Set_Token('MISSING', 'apps from uom');

1558:
1559: IF ( p_apps_from_uom is NULL
1560: OR p_apps_from_uom = FND_API.G_MISS_CHAR ) THEN
1561: FND_MESSAGE.Set_Name('GMI','MISSING');
1562: FND_MESSAGE.Set_Token('MISSING', 'apps from uom');
1563: FND_MSG_PUB.Add;
1564: raise FND_API.G_EXC_ERROR;
1565: END IF;
1566:

Line 1569: FND_MESSAGE.Set_Name('GMI','MISSING');

1565: END IF;
1566:
1567: IF ( p_apps_to_uom is NULL
1568: OR p_apps_to_uom = FND_API.G_MISS_CHAR) THEN
1569: FND_MESSAGE.Set_Name('GMI','MISSING');
1570: FND_MESSAGE.Set_Token('MISSING', 'apps to uom');
1571: FND_MSG_PUB.Add;
1572: raise FND_API.G_EXC_ERROR;
1573: END IF;

Line 1570: FND_MESSAGE.Set_Token('MISSING', 'apps to uom');

1566:
1567: IF ( p_apps_to_uom is NULL
1568: OR p_apps_to_uom = FND_API.G_MISS_CHAR) THEN
1569: FND_MESSAGE.Set_Name('GMI','MISSING');
1570: FND_MESSAGE.Set_Token('MISSING', 'apps to uom');
1571: FND_MSG_PUB.Add;
1572: raise FND_API.G_EXC_ERROR;
1573: END IF;
1574:

Line 1577: FND_MESSAGE.Set_Name('GMI','MISSING');

1573: END IF;
1574:
1575: IF ( p_original_qty is NULL
1576: OR p_apps_to_uom = FND_API.G_MISS_NUM ) THEN
1577: FND_MESSAGE.Set_Name('GMI','MISSING');
1578: FND_MESSAGE.Set_Token('MISSING', 'Original Qty Value');
1579: FND_MSG_PUB.Add;
1580: raise FND_API.G_EXC_ERROR;
1581: END IF;

Line 1578: FND_MESSAGE.Set_Token('MISSING', 'Original Qty Value');

1574:
1575: IF ( p_original_qty is NULL
1576: OR p_apps_to_uom = FND_API.G_MISS_NUM ) THEN
1577: FND_MESSAGE.Set_Name('GMI','MISSING');
1578: FND_MESSAGE.Set_Token('MISSING', 'Original Qty Value');
1579: FND_MSG_PUB.Add;
1580: raise FND_API.G_EXC_ERROR;
1581: END IF;
1582:

Line 1598: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

1594: x_msg_data => x_msg_data
1595: );
1596:
1597: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1598: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1599: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
1600: FND_MSG_PUB.Add;
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;

Line 1599: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);

1595: );
1596:
1597: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1598: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1599: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
1600: FND_MSG_PUB.Add;
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:

Line 1619: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

1615: x_msg_data => x_msg_data
1616: );
1617:
1618: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1619: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1620: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
1621: FND_MSG_PUB.Add;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;

Line 1620: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);

1616: );
1617:
1618: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1619: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1620: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
1621: FND_MSG_PUB.Add;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:

Line 1925: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');

1921: CLOSE c_detail_info;
1922:
1923: -- HW OPM Added qty2
1924: IF NOT l_found_flag THEN
1925: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');
1926: x_allowed_flag := 'N';
1927: x_max_quantity_allowed := NULL;
1928: x_avail_req_quantity := NULL;
1929: x_max_quantity2_allowed := NULL;

Line 1952: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');

1948: CLOSE c_detail_staged_quantities;
1949:
1950: -- HW OPM Added qty2
1951: IF NOT l_found_flag THEN
1952: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');
1953: x_allowed_flag := 'N';
1954: x_max_quantity_allowed := NULL;
1955: x_avail_req_quantity := NULL;
1956: x_max_quantity2_allowed := NULL;

Line 1995: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');

1991: END IF; -- of branching
1992:
1993: -- HW OPM Added qty2
1994: IF NOT l_found_flag THEN
1995: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');
1996: x_allowed_flag := 'N';
1997: x_max_quantity_allowed := NULL;
1998: x_avail_req_quantity := NULL;
1999: x_max_quantity2_allowed := NULL;

Line 2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2433: FND_MSG_PUB.Add;
2434: RAISE FND_API.G_EXC_ERROR;

Line 2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2433: FND_MSG_PUB.Add;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;

Line 2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2433: FND_MSG_PUB.Add;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436:

Line 2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

2459: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2460: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2466: FND_MSG_PUB.Add;
2467: raise FND_API.G_EXC_ERROR;

Line 2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2460: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2466: FND_MSG_PUB.Add;
2467: raise FND_API.G_EXC_ERROR;
2468: END IF;

Line 2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');

2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2466: FND_MSG_PUB.Add;
2467: raise FND_API.G_EXC_ERROR;
2468: END IF;
2469:

Line 2658: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2654:
2655: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2656: THEN
2657: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2658: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2659: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2660: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2661: FND_MSG_PUB.Add;
2662: RAISE FND_API.G_EXC_ERROR;

Line 2659: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');

2655: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2656: THEN
2657: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2658: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2659: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2660: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2661: FND_MSG_PUB.Add;
2662: RAISE FND_API.G_EXC_ERROR;
2663: END IF;

Line 2660: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2656: THEN
2657: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2658: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2659: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2660: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2661: FND_MSG_PUB.Add;
2662: RAISE FND_API.G_EXC_ERROR;
2663: END IF;
2664:

Line 2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

2743: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2744: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
2750: FND_MSG_PUB.Add;
2751: raise FND_API.G_EXC_ERROR;

Line 2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2744: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
2750: FND_MSG_PUB.Add;
2751: raise FND_API.G_EXC_ERROR;
2752: END IF;

Line 2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');

2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
2750: FND_MSG_PUB.Add;
2751: raise FND_API.G_EXC_ERROR;
2752: END IF;
2753:

Line 2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2785: FND_MSG_PUB.Add;
2786: RAISE FND_API.G_EXC_ERROR;

Line 2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2785: FND_MSG_PUB.Add;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;

Line 2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2785: FND_MSG_PUB.Add;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;
2788:

Line 2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

2810: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2811: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2817: FND_MSG_PUB.Add;
2818: raise FND_API.G_EXC_ERROR;

Line 2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2811: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2817: FND_MSG_PUB.Add;
2818: raise FND_API.G_EXC_ERROR;
2819: END IF;

Line 2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');

2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2817: FND_MSG_PUB.Add;
2818: raise FND_API.G_EXC_ERROR;
2819: END IF;
2820:

Line 2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2839: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2846: FND_MSG_PUB.Add;
2847: RAISE FND_API.G_EXC_ERROR;

Line 2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2846: FND_MSG_PUB.Add;
2847: RAISE FND_API.G_EXC_ERROR;
2848: END IF;

Line 2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2846: FND_MSG_PUB.Add;
2847: RAISE FND_API.G_EXC_ERROR;
2848: END IF;
2849:

Line 2869: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2865:
2866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2867: THEN
2868: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2869: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2870: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2871: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2872: FND_MSG_PUB.Add;
2873: RAISE FND_API.G_EXC_ERROR;

Line 2870: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');

2866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2867: THEN
2868: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2869: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2870: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2871: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2872: FND_MSG_PUB.Add;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;

Line 2871: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2867: THEN
2868: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2869: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2870: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2871: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2872: FND_MSG_PUB.Add;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875: