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.GMI_MOVE_ORDER_LINE_UTIL dependencies on FND_MSG_PUB

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

447: EXCEPTION
448:
449: WHEN OTHERS THEN
450:
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: FND_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Update_Row'

Line 453: FND_MSG_PUB.Add_Exc_Msg

449: WHEN OTHERS THEN
450:
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: FND_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Update_Row'
456: );
457: END IF;

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

480: EXCEPTION
481:
482: WHEN OTHERS THEN
483:
484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: FND_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Update_Row_Status'

Line 486: FND_MSG_PUB.Add_Exc_Msg

482: WHEN OTHERS THEN
483:
484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: FND_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Update_Row_Status'
489: );
490: END IF;

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

666:
667: WSH_UTIL_CORE.Println(' Line Insert Error => ' || err_num || err_msg);
668: gmi_reservation_util.Println(' Line Insert Error => ' || err_num || err_msg);
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Insert_Row'

Line 672: FND_MSG_PUB.Add_Exc_Msg

668: gmi_reservation_util.Println(' Line Insert Error => ' || err_num || err_msg);
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Insert_Row'
675: );
676: END IF;

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

695: EXCEPTION
696:
697: WHEN OTHERS THEN
698:
699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
700: THEN
701: FND_MSG_PUB.Add_Exc_Msg
702: ( G_PKG_NAME
703: , 'Delete_Row'

Line 701: FND_MSG_PUB.Add_Exc_Msg

697: WHEN OTHERS THEN
698:
699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
700: THEN
701: FND_MSG_PUB.Add_Exc_Msg
702: ( G_PKG_NAME
703: , 'Delete_Row'
704: );
705: END IF;

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

841: (p_line_id IS NOT NULL)
842: AND
843: (p_header_id IS NOT NULL)
844: THEN
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , 'Query Rows'

Line 847: FND_MSG_PUB.Add_Exc_Msg

843: (p_header_id IS NOT NULL)
844: THEN
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , 'Query Rows'
850: , 'Keys are mutually exclusive: line_id = '|| p_line_id || ', header_id = '|| p_header_id
851: );

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

962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963:
964: WHEN OTHERS THEN
965:
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
967: THEN
968: FND_MSG_PUB.Add_Exc_Msg
969: ( G_PKG_NAME
970: , 'Query_Rows'

Line 968: FND_MSG_PUB.Add_Exc_Msg

964: WHEN OTHERS THEN
965:
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
967: THEN
968: FND_MSG_PUB.Add_Exc_Msg
969: ( G_PKG_NAME
970: , 'Query_Rows'
971: );
972: END IF;

Line 1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1164:
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1167:
1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1169: THEN
1170:
1171: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_DELETED');
1172: FND_MSG_PUB.Add;

Line 1172: FND_MSG_PUB.Add;

1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1169: THEN
1170:
1171: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_DELETED');
1172: FND_MSG_PUB.Add;
1173:
1174: END IF;
1175: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1176:

Line 1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1177: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is locked for line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1178: x_return_status := '54';
1179: x_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1182: THEN
1183:
1184: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_ALREADY_LOCKED');
1185: FND_MSG_PUB.Add;

Line 1185: FND_MSG_PUB.Add;

1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1182: THEN
1183:
1184: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_ALREADY_LOCKED');
1185: FND_MSG_PUB.Add;
1186:
1187: END IF;
1188: WHEN OTHERS THEN
1189: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is OTHERS line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);

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

1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: x_mo_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193:
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1195: THEN
1196: FND_MSG_PUB.Add_Exc_Msg
1197: ( G_PKG_NAME
1198: , 'Lock_Row'

Line 1196: FND_MSG_PUB.Add_Exc_Msg

1192: x_mo_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193:
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1195: THEN
1196: FND_MSG_PUB.Add_Exc_Msg
1197: ( G_PKG_NAME
1198: , 'Lock_Row'
1199: );
1200: END IF;

Line 1447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1443: IF p_mo_line_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
1444:
1445: l_mo_line_rec.from_locator_id := p_mo_line_rec.from_locator_id;
1446:
1447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1448: THEN
1449:
1450: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');

Line 1452: FND_MSG_PUB.Add;

1448: THEN
1449:
1450: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');
1452: FND_MSG_PUB.Add;
1453:
1454: END IF;
1455:
1456: ELSE

Line 1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1474: IF p_mo_line_rec.from_subinventory_id <> FND_API.G_MISS_NUM THEN
1475:
1476: l_mo_line_rec.from_subinventory_id := p_mo_line_rec.from_subinventory_id;
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1479: THEN
1480:
1481: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_subinventory');

Line 1483: FND_MSG_PUB.Add;

1479: THEN
1480:
1481: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_subinventory');
1483: FND_MSG_PUB.Add;
1484:
1485: END IF;
1486:
1487: ELSE

Line 1509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1505: IF p_mo_line_rec.header_id <> FND_API.G_MISS_NUM THEN
1506:
1507: l_mo_line_rec.header_id := p_mo_line_rec.header_id;
1508:
1509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1510: THEN
1511:
1512: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 1514: FND_MSG_PUB.Add;

1510: THEN
1511:
1512: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1514: FND_MSG_PUB.Add;
1515:
1516: END IF;
1517:
1518: ELSE

Line 1539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1535: IF p_mo_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
1536:
1537: l_mo_line_rec.inventory_item_id := p_mo_line_rec.inventory_item_id;
1538:
1539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1540: THEN
1541:
1542: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 1544: FND_MSG_PUB.Add;

1540: THEN
1541:
1542: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
1544: FND_MSG_PUB.Add;
1545:
1546: END IF;
1547:
1548: ELSE

Line 1570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1566: IF p_mo_line_rec.line_id <> FND_API.G_MISS_NUM THEN
1567:
1568: l_mo_line_rec.line_id := p_mo_line_rec.line_id;
1569:
1570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1571: THEN
1572:
1573: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1574: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');

Line 1575: FND_MSG_PUB.Add;

1571: THEN
1572:
1573: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1574: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
1575: FND_MSG_PUB.Add;
1576:
1577: END IF;
1578:
1579: ELSE

Line 1600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1596: IF p_mo_line_rec.organization_id <> FND_API.G_MISS_NUM THEN
1597:
1598: l_mo_line_rec.organization_id := p_mo_line_rec.organization_id;
1599:
1600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1601: THEN
1602:
1603: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 1605: FND_MSG_PUB.Add;

1601: THEN
1602:
1603: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
1605: FND_MSG_PUB.Add;
1606:
1607: END IF;
1608:
1609: ELSE

Line 1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1626: IF p_mo_line_rec.to_organization_id <> FND_API.G_MISS_NUM THEN
1627:
1628: l_mo_line_rec.to_organization_id := p_mo_line_rec.to_organization_id;
1629:
1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1631: THEN
1632:
1633: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1634: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_organization');

Line 1635: FND_MSG_PUB.Add;

1631: THEN
1632:
1633: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1634: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_organization');
1635: FND_MSG_PUB.Add;
1636:
1637: END IF;
1638:
1639: ELSE

Line 1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1655: IF p_mo_line_rec.project_id <> FND_API.G_MISS_NUM THEN
1656:
1657: l_mo_line_rec.project_id := p_mo_line_rec.project_id;
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1660: THEN
1661:
1662: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');

Line 1664: FND_MSG_PUB.Add;

1660: THEN
1661:
1662: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
1664: FND_MSG_PUB.Add;
1665:
1666: END IF;
1667:
1668: ELSE

Line 1689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1685: IF p_mo_line_rec.reason_id <> FND_API.G_MISS_NUM THEN
1686:
1687: l_mo_line_rec.reason_id := p_mo_line_rec.reason_id;
1688:
1689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1690: THEN
1691:
1692: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reason');

Line 1694: FND_MSG_PUB.Add;

1690: THEN
1691:
1692: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reason');
1694: FND_MSG_PUB.Add;
1695:
1696: END IF;
1697:
1698: ELSE

Line 1719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1715: IF p_mo_line_rec.reference_id <> FND_API.G_MISS_NUM THEN
1716:
1717: l_mo_line_rec.reference_id := p_mo_line_rec.reference_id;
1718:
1719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1720: THEN
1721:
1722: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference');

Line 1724: FND_MSG_PUB.Add;

1720: THEN
1721:
1722: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference');
1724: FND_MSG_PUB.Add;
1725:
1726: END IF;
1727:
1728: ELSE

Line 1749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1745: IF p_mo_line_rec.reference_type_code <> FND_API.G_MISS_NUM THEN
1746:
1747: l_mo_line_rec.reference_type_code := p_mo_line_rec.reference_type_code;
1748:
1749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1750: THEN
1751:
1752: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_type');

Line 1754: FND_MSG_PUB.Add;

1750: THEN
1751:
1752: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_type');
1754: FND_MSG_PUB.Add;
1755:
1756: END IF;
1757:
1758: ELSE

Line 1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1775: IF p_mo_line_rec.task_id <> FND_API.G_MISS_NUM THEN
1776:
1777: l_mo_line_rec.task_id := p_mo_line_rec.task_id;
1778:
1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1780: THEN
1781:
1782: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');

Line 1784: FND_MSG_PUB.Add;

1780: THEN
1781:
1782: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
1784: FND_MSG_PUB.Add;
1785:
1786: END IF;
1787:
1788: ELSE

Line 1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1805: IF p_mo_line_rec.to_account_id <> FND_API.G_MISS_NUM THEN
1806:
1807: l_mo_line_rec.to_account_id := p_mo_line_rec.to_account_id;
1808:
1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1810: THEN
1811:
1812: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account');

Line 1814: FND_MSG_PUB.Add;

1810: THEN
1811:
1812: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account');
1814: FND_MSG_PUB.Add;
1815:
1816: END IF;
1817:
1818: ELSE

Line 1840: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1836: IF p_mo_line_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
1837:
1838: l_mo_line_rec.to_locator_id := p_mo_line_rec.to_locator_id;
1839:
1840: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1841: THEN
1842:
1843: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');

Line 1845: FND_MSG_PUB.Add;

1841: THEN
1842:
1843: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');
1845: FND_MSG_PUB.Add;
1846:
1847: END IF;
1848:
1849: ELSE

Line 1870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1866: IF p_mo_line_rec.to_subinventory_code <> FND_API.G_MISS_CHAR THEN
1867:
1868: l_mo_line_rec.to_subinventory_code := p_mo_line_rec.to_subinventory_code;
1869:
1870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1871: THEN
1872:
1873: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1874: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_subinventory');

Line 1875: FND_MSG_PUB.Add;

1871: THEN
1872:
1873: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1874: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_subinventory');
1875: FND_MSG_PUB.Add;
1876:
1877: END IF;
1878:
1879: ELSE

Line 1901: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1897: IF p_mo_line_rec.to_subinventory_id <> FND_API.G_MISS_NUM THEN
1898:
1899: l_mo_line_rec.to_subinventory_id := p_mo_line_rec.to_subinventory_id;
1900:
1901: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1902: THEN
1903:
1904: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_subinventory');

Line 1906: FND_MSG_PUB.Add;

1902: THEN
1903:
1904: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_subinventory');
1906: FND_MSG_PUB.Add;
1907:
1908: END IF;
1909:
1910: ELSE

Line 1932: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1928: IF p_mo_line_rec.transaction_header_id <> FND_API.G_MISS_NUM THEN
1929:
1930: l_mo_line_rec.transaction_header_id := p_mo_line_rec.transaction_header_id;
1931:
1932: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1933: THEN
1934:
1935: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1936: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_header');

Line 1937: FND_MSG_PUB.Add;

1933: THEN
1934:
1935: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1936: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_header');
1937: FND_MSG_PUB.Add;
1938:
1939: END IF;
1940:
1941: ELSE

Line 1961: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1957: IF p_mo_line_rec.transaction_type_id <> FND_API.G_MISS_NUM THEN
1958:
1959: l_mo_line_rec.transaction_type_id := p_mo_line_rec.transaction_type_id;
1960:
1961: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1962: THEN
1963:
1964: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type');

Line 1966: FND_MSG_PUB.Add;

1962: THEN
1963:
1964: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type');
1966: FND_MSG_PUB.Add;
1967:
1968: END IF;
1969:
1970: ELSE

Line 1991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1987: IF p_mo_line_rec.uom_code <> FND_API.G_MISS_CHAR THEN
1988:
1989: l_mo_line_rec.uom_code := p_mo_line_rec.uom_code;
1990:
1991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1992: THEN
1993:
1994: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','uom');

Line 1996: FND_MSG_PUB.Add;

1992: THEN
1993:
1994: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','uom');
1996: FND_MSG_PUB.Add;
1997:
1998: END IF;
1999:
2000: ELSE

Line 2118: FND_MSG_PUB.Initialize;

2114:
2115:
2116: IF (p_init_msg_list = 1)
2117: THEN
2118: FND_MSG_PUB.Initialize;
2119: END IF;
2120:
2121: GMI_Reservation_Util.PrintLn('(opm_dbg) Line_Auto_Detail after init Mesg. mo_type='||p_move_order_type||', mo_line_id='||p_mo_line_id);
2122: /* check what is the move order type. If it's a non pick wave mo, */

Line 2182: fnd_msg_pub.add;

2178: GMI_Reservation_Util.PrintLn('(opm_dbg) l_auto_pick_flag is ' || l_auto_pick_flag);
2179: EXCEPTION
2180: WHEN no_data_found THEN
2181: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
2182: fnd_msg_pub.add;
2183: raise fnd_api.g_exc_unexpected_error;
2184: END;
2185: */
2186: SAVEPOINT GMI_Before_Pick_Release;

Line 2217: /* fnd_msg_pub.count_and_get(p_count => l_count,

2213: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
2214:
2215: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2216: GMI_Reservation_Util.PrintLn('return error');
2217: /* fnd_msg_pub.count_and_get(p_count => l_count,
2218: p_data => l_message,
2219: p_encoded => 'F');
2220: if( l_count = 0) then
2221: GMI_Reservation_Util.PrintLn('(opm_dbg) no message return');

Line 2224: l_message := fnd_msg_pub.get(I, 'F');

2220: if( l_count = 0) then
2221: GMI_Reservation_Util.PrintLn('(opm_dbg) no message return');
2222: else
2223: for I in 1..l_count LOOP
2224: l_message := fnd_msg_pub.get(I, 'F');
2225: GMI_Reservation_Util.PrintLn(l_message);
2226: end LOOP;
2227: end if;
2228: */

Line 2266: fnd_msg_pub.add;

2262: l_mold_tbl_temp := l_mold_tbl;
2263: if( l_mold_tbl.count = 0 ) then
2264: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
2266: fnd_msg_pub.add;
2267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2268: else
2269: GMI_Reservation_Util.PrintLn('number of mold record is ' || l_mold_tbl.count);
2270: GMI_Reservation_Util.PrintLn('calling pick confirm');

Line 2382: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2378:
2379: EXCEPTION
2380: WHEN FND_API.G_EXC_ERROR THEN
2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2383:
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2385: IF (x_return_status = '54')
2386: THEN

Line 2392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2388: ELSE
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2390: END IF;
2391:
2392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2393:
2394: WHEN OTHERS THEN
2395:
2396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2393:
2394: WHEN OTHERS THEN
2395:
2396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: FND_MSG_PUB.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Line_Details_PUB'

Line 2398: FND_MSG_PUB.Add_Exc_Msg

2394: WHEN OTHERS THEN
2395:
2396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: FND_MSG_PUB.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Line_Details_PUB'
2401: );
2402: END IF;

Line 2403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2399: ( G_PKG_NAME
2400: , 'Line_Details_PUB'
2401: );
2402: END IF;
2403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2404:
2405: END Line_Auto_Detail;
2406:
2407: PROCEDURE Line_Pick_Confirm

Line 2449: FND_MSG_PUB.Initialize;

2445: x_return_status := FND_API.G_RET_STS_SUCCESS;
2446:
2447: IF (p_init_msg_list = 1)
2448: THEN
2449: FND_MSG_PUB.Initialize;
2450: END IF;
2451:
2452: /* check what is the move order type. If it's a non pick wave mo,
2453: call the pick engine, otherwise, call the pick release api

Line 2510: FND_MSG_PUB.Add;

2506: GMI_Reservation_Util.PrintLn('return error');
2507: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
2508: FND_MESSAGE.Set_Token('WHERE', 'AFTER_CALL_PICK_CONFIRM');
2509: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
2510: FND_MSG_PUB.Add;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: END IF;
2513:
2514: IF ( l_mo_line_tbl.count = 0 )

Line 2520: FND_MSG_PUB.Add;

2516: GMI_Reservation_Util.PrintLn('return error');
2517: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
2518: FND_MESSAGE.Set_Token('WHERE', 'MO_LINE_COUNT_0');
2519: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
2520: FND_MSG_PUB.Add;
2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END IF;
2523:
2524: END IF;

Line 2547: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2543: WHEN FND_API.G_EXC_ERROR THEN
2544: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2548:
2549: WHEN OTHERS THEN
2550: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
2551:

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

2555: ELSE
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2557: END IF;
2558:
2559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2560: THEN
2561: FND_MSG_PUB.Add_Exc_Msg
2562: ( G_PKG_NAME
2563: , 'Line_Pick_Confirm');

Line 2561: FND_MSG_PUB.Add_Exc_Msg

2557: END IF;
2558:
2559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2560: THEN
2561: FND_MSG_PUB.Add_Exc_Msg
2562: ( G_PKG_NAME
2563: , 'Line_Pick_Confirm');
2564: END IF;
2565: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 2565: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2561: FND_MSG_PUB.Add_Exc_Msg
2562: ( G_PKG_NAME
2563: , 'Line_Pick_Confirm');
2564: END IF;
2565: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2566:
2567: END Line_Pick_Confirm;
2568:
2569:

Line 2853: FND_MSG_PUB.INITIALIZE;

2849: WSH_UTIL_CORE.PRINTLN( ' G_TO_ORDER_NUM => ' || G_TO_ORDER_NUM);
2850: WSH_UTIL_CORE.PRINTLN( ' G_SHIP_TO_ID => ' || G_SHIP_TO_ID);
2851:
2852:
2853: FND_MSG_PUB.INITIALIZE;
2854: l_required_lines :=0;
2855: l_total_lines :=0;
2856: l_sucess_pick :=0;
2857: l_pick_fail :=0;

Line 3008: l_message := fnd_msg_pub.get(1,'F');

3004:
3005: WSH_UTIL_CORE.PRINTMSG( ' Return Status => ' || l_return_status);
3006: WSH_UTIL_CORE.PRINTMSG( ' MSG count => ' || l_msg_count);
3007: -- FOR i in 1..l_msg_count LOOP
3008: l_message := fnd_msg_pub.get(1,'F');
3009: l_message := replace(l_message,fnd_global.local_chr(0),' ');
3010:
3011:
3012: WSH_UTIL_CORE.PRINTMSG( ' Error => ' || l_message);

Line 3018: FND_MSG_PUB.INITIALIZE;

3014:
3015: WSH_UTIL_CORE.PRINTMSG;
3016: WSH_UTIL_CORE.PRINTMSG(c_event_separator);
3017: WSH_UTIL_CORE.PRINTMSG;
3018: FND_MSG_PUB.INITIALIZE;
3019: l_completion_status := G_WARNING;
3020:
3021: ELSE
3022:

Line 3064: l_message := fnd_msg_pub.get(1,'F');

3060: WSH_UTIL_CORE.PRINTMSG(c_event_separator);
3061: WSH_UTIL_CORE.PRINTMSG(' PICK CONFIRM ERROR');
3062: WSH_UTIL_CORE.PRINTMSG(' Return Status => ' || l_return_status);
3063: WSH_UTIL_CORE.PRINTMSG(' MSG count => ' || l_msg_count);
3064: l_message := fnd_msg_pub.get(1,'F');
3065: l_message := replace(l_message,fnd_global.local_chr(0),' ');
3066: WSH_UTIL_CORE.PRINTMSG(' Error => ' || l_message);
3067: FND_MSG_PUB.INITIALIZE;
3068: WSH_UTIL_CORE.PRINTMSG;

Line 3067: FND_MSG_PUB.INITIALIZE;

3063: WSH_UTIL_CORE.PRINTMSG(' MSG count => ' || l_msg_count);
3064: l_message := fnd_msg_pub.get(1,'F');
3065: l_message := replace(l_message,fnd_global.local_chr(0),' ');
3066: WSH_UTIL_CORE.PRINTMSG(' Error => ' || l_message);
3067: FND_MSG_PUB.INITIALIZE;
3068: WSH_UTIL_CORE.PRINTMSG;
3069: WSH_UTIL_CORE.PRINTMSG(c_event_separator);
3070: l_completion_status := G_WARNING;
3071: ELSE