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

Line 482: OE_MSG_PUB.Add;

478: -- if the multi-currency list is attached to multiple price lists
479: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to more than one Price Lists, so Base Currency Code can not be modified');
480:
481: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
482: OE_MSG_PUB.Add;
483:
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: WHEN list_already_attached THEN
486: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to a Price List, so Base Currency Code can not be modified');

Line 489: OE_MSG_PUB.Add;

485: WHEN list_already_attached THEN
486: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to a Price List, so Base Currency Code can not be modified');
487:
488: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
489: OE_MSG_PUB.Add;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: End;

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

982: EXCEPTION
983:
984: WHEN OTHERS THEN
985:
986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: OE_MSG_PUB.Add_Exc_Msg
989: ( G_PKG_NAME
990: , 'Update_Row'

Line 988: OE_MSG_PUB.Add_Exc_Msg

984: WHEN OTHERS THEN
985:
986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: OE_MSG_PUB.Add_Exc_Msg
989: ( G_PKG_NAME
990: , 'Update_Row'
991: );
992: END IF;

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

1112: EXCEPTION
1113:
1114: WHEN OTHERS THEN
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1117: THEN
1118: OE_MSG_PUB.Add_Exc_Msg
1119: ( G_PKG_NAME
1120: , 'Insert_Row'

Line 1118: OE_MSG_PUB.Add_Exc_Msg

1114: WHEN OTHERS THEN
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1117: THEN
1118: OE_MSG_PUB.Add_Exc_Msg
1119: ( G_PKG_NAME
1120: , 'Insert_Row'
1121: );
1122: END IF;

Line 1163: OE_MSG_PUB.Add;

1159: Exception
1160: WHEN DUP_VAL_ON_INDEX THEN
1161:
1162: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MULTICURR');
1163: OE_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN OTHERS THEN
1167:

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

1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN OTHERS THEN
1167:
1168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: OE_MSG_PUB.Add_Exc_Msg
1171: ( G_PKG_NAME
1172: , 'Insert_Row'

Line 1170: OE_MSG_PUB.Add_Exc_Msg

1166: WHEN OTHERS THEN
1167:
1168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: OE_MSG_PUB.Add_Exc_Msg
1171: ( G_PKG_NAME
1172: , 'Insert_Row'
1173: );
1174: END IF;

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

1241: raise;
1242:
1243: WHEN OTHERS THEN
1244:
1245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: OE_MSG_PUB.Add_Exc_Msg
1248: ( G_PKG_NAME
1249: , 'Insert_Row'

Line 1247: OE_MSG_PUB.Add_Exc_Msg

1243: WHEN OTHERS THEN
1244:
1245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: OE_MSG_PUB.Add_Exc_Msg
1248: ( G_PKG_NAME
1249: , 'Insert_Row'
1250: );
1251: END IF;

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

1273: EXCEPTION
1274:
1275: WHEN OTHERS THEN
1276:
1277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: OE_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME
1281: , 'Delete_Row'

Line 1279: OE_MSG_PUB.Add_Exc_Msg

1275: WHEN OTHERS THEN
1276:
1277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: OE_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME
1281: , 'Delete_Row'
1282: );
1283: END IF;

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

1394:
1395: WHEN OTHERS THEN
1396:
1397:
1398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1399: THEN
1400: OE_MSG_PUB.Add_Exc_Msg
1401: ( G_PKG_NAME
1402: , 'Query_Row'

Line 1400: OE_MSG_PUB.Add_Exc_Msg

1396:
1397:
1398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1399: THEN
1400: OE_MSG_PUB.Add_Exc_Msg
1401: ( G_PKG_NAME
1402: , 'Query_Row'
1403: );
1404: END IF;

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

1596:
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1599:
1600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1601: THEN
1602:
1603: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1604: OE_MSG_PUB.Add;

Line 1604: OE_MSG_PUB.Add;

1600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1601: THEN
1602:
1603: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1604: OE_MSG_PUB.Add;
1605:
1606: END IF;
1607:
1608: END IF;

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

1613:
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1618: THEN
1619:
1620: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1621: OE_MSG_PUB.Add;

Line 1621: OE_MSG_PUB.Add;

1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1618: THEN
1619:
1620: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1621: OE_MSG_PUB.Add;
1622:
1623: END IF;
1624: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1625:

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

1625:
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1628:
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631:
1632: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1633: OE_MSG_PUB.Add;

Line 1633: OE_MSG_PUB.Add;

1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631:
1632: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1633: OE_MSG_PUB.Add;
1634:
1635: END IF;
1636: WHEN OTHERS THEN
1637:

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

1637:
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1642: THEN
1643: OE_MSG_PUB.Add_Exc_Msg
1644: ( G_PKG_NAME
1645: , 'Lock_Row'

Line 1643: OE_MSG_PUB.Add_Exc_Msg

1639: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1642: THEN
1643: OE_MSG_PUB.Add_Exc_Msg
1644: ( G_PKG_NAME
1645: , 'Lock_Row'
1646: );
1647: END IF;

Line 1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1735: IF p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR THEN
1736:
1737: l_CURR_LISTS_rec.base_currency_code := p_CURR_LISTS_rec.base_currency_code;
1738:
1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1740: THEN
1741:
1742: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');

Line 1744: OE_MSG_PUB.Add;

1740: THEN
1741:
1742: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');
1744: OE_MSG_PUB.Add;
1745:
1746: END IF;
1747:
1748: ELSE

Line 1769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1765: IF p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1766:
1767: l_CURR_LISTS_rec.currency_header_id := p_CURR_LISTS_rec.currency_header_id;
1768:
1769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1770: THEN
1771:
1772: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');

Line 1774: OE_MSG_PUB.Add;

1770: THEN
1771:
1772: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');
1774: OE_MSG_PUB.Add;
1775:
1776: END IF;
1777:
1778: ELSE

Line 1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1796: IF p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM THEN
1797:
1798: l_CURR_LISTS_rec.base_markup_formula_id := p_CURR_LISTS_rec.base_markup_formula_id;
1799:
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1801: THEN
1802:
1803: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');

Line 1805: OE_MSG_PUB.Add;

1801: THEN
1802:
1803: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');
1805: OE_MSG_PUB.Add;
1806:
1807: END IF;
1808:
1809: ELSE

Line 1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1827: IF p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_CHAR THEN
1828:
1829: l_CURR_LISTS_rec.row_id := p_CURR_LISTS_rec.row_id;
1830:
1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1832: THEN
1833:
1834: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');

Line 1836: OE_MSG_PUB.Add;

1832: THEN
1833:
1834: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1836: OE_MSG_PUB.Add;
1837:
1838: END IF;
1839:
1840: ELSE