DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on FND_MSG_PUB

Line 516: FND_MSG_PUB.Initialize;

512: /* Initialize message list if p_int_msg_lst is set TRUE. */
513:
514: IF FND_API.to_boolean(p_init_msg_lst)
515: THEN
516: FND_MSG_PUB.Initialize;
517: END IF;
518:
519: /* Initialize API return status to sucess */
520: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 537: FND_MSG_PUB.ADD;

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:
541: -- HW BUG#:2296620 call to check ship_sets

Line 591: FND_MSG_PUB.ADD;

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:
595: /* Get Process Item details */

Line 779: FND_MSG_PUB.Add;

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 ');
779: FND_MSG_PUB.Add;
780: l_tolerance_flag := 1;
781: /* NC End of Bug #2557029 */
782:
783: goto next_line;

Line 1125: FND_MSG_PUB.Add;

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:
1129: UPDATE ic_tran_pnd

Line 1437: FND_MSG_PUB.count_and_get

1433: END IF;
1434: x_return_status := fnd_api.g_ret_sts_error;
1435:
1436: /* Get message count and data */
1437: FND_MSG_PUB.count_and_get
1438: ( p_count => x_msg_count
1439: , p_data => x_msg_data
1440: );
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1442: ROLLBACK TO PICK_WAVE_CONFIRM;
1443: x_return_status := fnd_api.g_ret_sts_unexp_error;
1444:
1445:
1446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1447: ,l_api_name
1448: );
1449:
1450: -- HW BUG#:2296620

Line 1465: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1461: WHEN OTHERS THEN
1462: ROLLBACK TO PICK_WAVE_CONFIRM;
1463: x_return_status := fnd_api.g_ret_sts_unexp_error;
1464:
1465: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1466: ,l_api_name
1467: );
1468:
1469:

Line 1471: FND_MSG_PUB.count_and_get

1467: );
1468:
1469:
1470: /* Get message count and data */
1471: FND_MSG_PUB.count_and_get
1472: ( p_count => x_msg_count
1473: , p_data => x_msg_data
1474: );
1475:

Line 1517: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1513: RETURN TRUE;
1514:
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1518: 'Check Required'
1519: );
1520:
1521: RETURN TRUE;

Line 1555: FND_MSG_PUB.Add;

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:
1559: IF ( p_apps_from_uom is NULL

Line 1563: FND_MSG_PUB.Add;

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:
1567: IF ( p_apps_to_uom is NULL

Line 1571: FND_MSG_PUB.Add;

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:
1575: IF ( p_original_qty is NULL

Line 1579: FND_MSG_PUB.Add;

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:
1583: /* Now Input Values have Been Validated Lets Get OPM */

Line 1600: FND_MSG_PUB.Add;

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:
1604: GMI_reservation_Util.PrintLn('Convert From OPM UOM => ' || l_opm_from_uom);

Line 1621: FND_MSG_PUB.Add;

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:
1625: GMI_reservation_Util.PrintLn('Convert To OPM UOM => ' || l_opm_from_uom);

Line 1660: FND_MSG_PUB.count_and_get

1656: WHEN FND_API.G_EXC_ERROR THEN
1657: x_return_status := fnd_api.g_ret_sts_error;
1658:
1659: /* Get message count and data */
1660: FND_MSG_PUB.count_and_get
1661: ( p_count => x_msg_count
1662: , p_data => x_msg_data
1663: );
1664:

Line 1669: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666: ROLLBACK TO PICK_WAVE_CONFIRM;
1667: x_return_status := fnd_api.g_ret_sts_unexp_error;
1668:
1669: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1670: ,l_api_name
1671: );
1672:
1673: WHEN OTHERS THEN

Line 1677: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1673: WHEN OTHERS THEN
1674: ROLLBACK TO PICK_WAVE_CONFIRM;
1675: x_return_status := fnd_api.g_ret_sts_unexp_error;
1676:
1677: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1678: ,l_api_name
1679: );
1680:
1681:

Line 1785: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1781:
1782: WHEN fnd_api.g_exc_error THEN
1783: x_return_status := FND_API.G_RET_STS_ERROR;
1784: x_allowed := 'N';
1785: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1786: ,p_data => x_msg_data);
1787:
1788: WHEN fnd_api.g_exc_unexpected_error THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1791: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1787:
1788: WHEN fnd_api.g_exc_unexpected_error THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: x_allowed := 'N';
1791: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793:
1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1797: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1793:
1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: x_allowed := 'N';
1797: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1798: THEN
1799: FND_MSG_PUB.Add_Exc_Msg
1800: (G_PKG_NAME
1801: ,l_api_name);

Line 1799: FND_MSG_PUB.Add_Exc_Msg

1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: x_allowed := 'N';
1797: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1798: THEN
1799: FND_MSG_PUB.Add_Exc_Msg
1800: (G_PKG_NAME
1801: ,l_api_name);
1802: END IF;
1803:

Line 2353: FND_MSG_PUB.Count_And_Get

2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2350:
2351: -- Get message count and data
2352:
2353: FND_MSG_PUB.Count_And_Get
2354: ( p_count => x_msg_count
2355: , p_data => x_msg_data
2356: );
2357:

Line 2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2359:
2360: gmi_reservation_util.println('Unexpected Error : '||sqlerrm);
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362:
2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg
2366: ( G_PKG_NAME
2367: , 'Get_Min_Max_Tolerance_Quantity'

Line 2365: FND_MSG_PUB.Add_Exc_Msg

2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362:
2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg
2366: ( G_PKG_NAME
2367: , 'Get_Min_Max_Tolerance_Quantity'
2368: );
2369: END IF;

Line 2373: FND_MSG_PUB.Count_And_Get

2369: END IF;
2370:
2371: -- Get message count and data
2372:
2373: FND_MSG_PUB.Count_And_Get
2374: ( p_count => x_msg_count
2375: , p_data => x_msg_data
2376: );
2377:

Line 2433: FND_MSG_PUB.Add;

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:
2437: l_dflt_nonctl_tran_rec.trans_id := NULL;

Line 2466: FND_MSG_PUB.Add;

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:
2470: EXCEPTION

Line 2475: FND_MSG_PUB.Count_And_Get

2471:
2472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2474:
2475: FND_MSG_PUB.Count_And_Get
2476: ( p_count => x_msg_count
2477: , p_data => x_msg_data
2478: );
2479: WHEN OTHERS THEN

Line 2482: FND_MSG_PUB.Count_And_Get

2478: );
2479: WHEN OTHERS THEN
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2481:
2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => x_msg_count
2484: , p_data => x_msg_data
2485: );
2486:

Line 2661: FND_MSG_PUB.Add;

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:
2665: UPDATE ic_tran_pnd

Line 2750: FND_MSG_PUB.Add;

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:
2754: ELSIF (p_requested_qty <> ABS(l_dflt_nonctl_tran_rec.trans_qty)) THEN

Line 2785: FND_MSG_PUB.Add;

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:
2789: l_dflt_nonctl_tran_rec.trans_id := NULL;

Line 2817: FND_MSG_PUB.Add;

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:
2821: ELSE

Line 2846: FND_MSG_PUB.Add;

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:
2850: END IF;

Line 2872: FND_MSG_PUB.Add;

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:
2876: GMI_reservation_Util.PrintLn('l_tran_row.trans_id '||l_tran_row.trans_id );

Line 2890: FND_MSG_PUB.Count_And_Get

2886:
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2889:
2890: FND_MSG_PUB.Count_And_Get
2891: ( p_count => x_msg_count
2892: , p_data => x_msg_data
2893: );
2894: WHEN OTHERS THEN

Line 2897: FND_MSG_PUB.Count_And_Get

2893: );
2894: WHEN OTHERS THEN
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2896:
2897: FND_MSG_PUB.Count_And_Get
2898: ( p_count => x_msg_count
2899: , p_data => x_msg_data
2900: );
2901: