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.OE_LOT_SERIAL_UTIL dependencies on OE_MSG_PUB

Line 495: oe_msg_pub.ADD;

491: x_to_number,
492: x_error_code)
493: THEN
494: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');
495: oe_msg_pub.ADD;
496: raise FND_API.G_EXC_ERROR;
497: ELSE
498: IF p_x_Lot_Serial_rec.quantity <> x_quantity THEN
499: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');

Line 500: oe_msg_pub.ADD;

496: raise FND_API.G_EXC_ERROR;
497: ELSE
498: IF p_x_Lot_Serial_rec.quantity <> x_quantity THEN
499: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');
500: oe_msg_pub.ADD;
501: raise FND_API.G_EXC_ERROR;
502: END IF;
503: END IF;
504:

Line 808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

804: EXCEPTION
805:
806: WHEN OTHERS THEN
807:
808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: OE_MSG_PUB.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Set_Line_Set_ID'

Line 810: OE_MSG_PUB.Add_Exc_Msg

806: WHEN OTHERS THEN
807:
808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: OE_MSG_PUB.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Set_Line_Set_ID'
813: );
814: END IF;

Line 925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

921: EXCEPTION
922:
923: WHEN OTHERS THEN
924:
925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: OE_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Update_Row'

Line 927: OE_MSG_PUB.Add_Exc_Msg

923: WHEN OTHERS THEN
924:
925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: OE_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Update_Row'
930: );
931: END IF;

Line 1053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1049: EXCEPTION
1050:
1051: WHEN OTHERS THEN
1052:
1053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: OE_MSG_PUB.Add_Exc_Msg
1056: ( G_PKG_NAME
1057: , 'Insert_Row'

Line 1055: OE_MSG_PUB.Add_Exc_Msg

1051: WHEN OTHERS THEN
1052:
1053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: OE_MSG_PUB.Add_Exc_Msg
1056: ( G_PKG_NAME
1057: , 'Insert_Row'
1058: );
1059: END IF;

Line 1256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1252: EXCEPTION
1253:
1254: WHEN OTHERS THEN
1255:
1256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: OE_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'Delete_Row'

Line 1258: OE_MSG_PUB.Add_Exc_Msg

1254: WHEN OTHERS THEN
1255:
1256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: OE_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'Delete_Row'
1261: );
1262: END IF;

Line 1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1352: (p_line_id IS NOT NULL
1353: AND
1354: p_line_id <> FND_API.G_MISS_NUM)
1355: THEN
1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: OE_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Query Rows'

Line 1358: OE_MSG_PUB.Add_Exc_Msg

1354: p_line_id <> FND_API.G_MISS_NUM)
1355: THEN
1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: OE_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Query Rows'
1361: , 'Keys are mutually exclusive: lot_serial_id = '|| p_lot_serial_id || ', line_id = '|| p_line_id
1362: );

Line 1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1374: (p_line_set_id IS NOT NULL
1375: AND
1376: p_line_set_id <> FND_API.G_MISS_NUM)
1377: THEN
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: OE_MSG_PUB.Add_Exc_Msg
1381: ( G_PKG_NAME
1382: , 'Query Rows'

Line 1380: OE_MSG_PUB.Add_Exc_Msg

1376: p_line_set_id <> FND_API.G_MISS_NUM)
1377: THEN
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: OE_MSG_PUB.Add_Exc_Msg
1381: ( G_PKG_NAME
1382: , 'Query Rows'
1383: , 'Keys are mutually exclusive: lot_serial_id = '|| p_lot_serial_id || ', line_set_id = '|| p_line_set_id
1384: );

Line 1400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1396: (p_line_id IS NOT NULL
1397: AND
1398: p_line_id <> FND_API.G_MISS_NUM)
1399: THEN
1400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: OE_MSG_PUB.Add_Exc_Msg
1403: ( G_PKG_NAME
1404: , 'Query Rows'

Line 1402: OE_MSG_PUB.Add_Exc_Msg

1398: p_line_id <> FND_API.G_MISS_NUM)
1399: THEN
1400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: OE_MSG_PUB.Add_Exc_Msg
1403: ( G_PKG_NAME
1404: , 'Query Rows'
1405: , 'Keys are mutually exclusive: line_set_id = '|| p_line_set_id ||', line_id = '|| p_line_id
1406: );

Line 1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534:
1535: WHEN OTHERS THEN
1536:
1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1538: THEN
1539: OE_MSG_PUB.Add_Exc_Msg
1540: ( G_PKG_NAME
1541: , 'Query_Rows'

Line 1539: OE_MSG_PUB.Add_Exc_Msg

1535: WHEN OTHERS THEN
1536:
1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1538: THEN
1539: OE_MSG_PUB.Add_Exc_Msg
1540: ( G_PKG_NAME
1541: , 'Query_Rows'
1542: );
1543: END IF;

Line 1621: IF oe_msg_pub.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1617:
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1620:
1621: IF oe_msg_pub.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1622: THEN
1623:
1624: -- Release the lock
1625: ROLLBACK TO Lock_Row;

Line 1628: oe_msg_pub.Add;

1624: -- Release the lock
1625: ROLLBACK TO Lock_Row;
1626:
1627: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_CHANGED');
1628: oe_msg_pub.Add;
1629:
1630: END IF;
1631:
1632: END IF;

Line 1643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1639:
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1642:
1643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN
1645:
1646: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1647: OE_MSG_PUB.Add;

Line 1647: OE_MSG_PUB.Add;

1643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN
1645:
1646: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1647: OE_MSG_PUB.Add;
1648:
1649: END IF;
1650: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1651:

Line 1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1651:
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1656: THEN
1657:
1658: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1659: OE_MSG_PUB.Add;

Line 1659: OE_MSG_PUB.Add;

1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1656: THEN
1657:
1658: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1659: OE_MSG_PUB.Add;
1660:
1661: END IF;
1662: WHEN OTHERS THEN
1663:

Line 1667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1663:
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666:
1667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1668: THEN
1669: OE_MSG_PUB.Add_Exc_Msg
1670: ( G_PKG_NAME
1671: , 'Lock_Row'

Line 1669: OE_MSG_PUB.Add_Exc_Msg

1665: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666:
1667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1668: THEN
1669: OE_MSG_PUB.Add_Exc_Msg
1670: ( G_PKG_NAME
1671: , 'Lock_Row'
1672: );
1673: END IF;

Line 1703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND
1701: p_line_id <> FND_API.G_MISS_NUM)
1702: THEN
1703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1704: THEN
1705: OE_MSG_PUB.Add_Exc_Msg
1706: ( G_PKG_NAME
1707: , 'Lock Rows'

Line 1705: OE_MSG_PUB.Add_Exc_Msg

1701: p_line_id <> FND_API.G_MISS_NUM)
1702: THEN
1703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1704: THEN
1705: OE_MSG_PUB.Add_Exc_Msg
1706: ( G_PKG_NAME
1707: , 'Lock Rows'
1708: , 'Keys are mutually exclusive: lot_serial_id = '||
1709: p_lot_serial_id || ', line_id = '|| p_line_id );

Line 1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1769: WHEN NO_DATA_FOUND THEN
1770:
1771: x_return_status := FND_API.G_RET_STS_ERROR;
1772:
1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1774: THEN
1775: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
1776: OE_MSG_PUB.Add;
1777: END IF;

Line 1776: OE_MSG_PUB.Add;

1772:
1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1774: THEN
1775: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
1776: OE_MSG_PUB.Add;
1777: END IF;
1778:
1779: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1780:

Line 1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1778:
1779: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1780:
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1783: THEN
1784: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1785: OE_MSG_PUB.Add;
1786: END IF;

Line 1785: OE_MSG_PUB.Add;

1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1783: THEN
1784: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1785: OE_MSG_PUB.Add;
1786: END IF;
1787:
1788: WHEN OTHERS THEN
1789:

Line 1792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1788: WHEN OTHERS THEN
1789:
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791:
1792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1793: THEN
1794: OE_MSG_PUB.Add_Exc_Msg
1795: ( G_PKG_NAME
1796: , 'Lock_Rows'

Line 1794: OE_MSG_PUB.Add_Exc_Msg

1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791:
1792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1793: THEN
1794: OE_MSG_PUB.Add_Exc_Msg
1795: ( G_PKG_NAME
1796: , 'Lock_Rows'
1797: );
1798: END IF;