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_DETAILS_UTIL dependencies on OE_MSG_PUB

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

1194: EXCEPTION
1195:
1196: WHEN OTHERS THEN
1197:
1198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1199: THEN
1200: OE_MSG_PUB.Add_Exc_Msg
1201: ( G_PKG_NAME
1202: , 'Update_Row'

Line 1200: OE_MSG_PUB.Add_Exc_Msg

1196: WHEN OTHERS THEN
1197:
1198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1199: THEN
1200: OE_MSG_PUB.Add_Exc_Msg
1201: ( G_PKG_NAME
1202: , 'Update_Row'
1203: );
1204: END IF;

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

1315: EXCEPTION
1316:
1317: WHEN OTHERS THEN
1318:
1319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: OE_MSG_PUB.Add_Exc_Msg
1322: ( G_PKG_NAME
1323: , 'Insert_Row'

Line 1321: OE_MSG_PUB.Add_Exc_Msg

1317: WHEN OTHERS THEN
1318:
1319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: OE_MSG_PUB.Add_Exc_Msg
1322: ( G_PKG_NAME
1323: , 'Insert_Row'
1324: );
1325: END IF;

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

1343: EXCEPTION
1344:
1345: WHEN OTHERS THEN
1346:
1347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1348: THEN
1349: OE_MSG_PUB.Add_Exc_Msg
1350: ( G_PKG_NAME
1351: , 'Delete_Row'

Line 1349: OE_MSG_PUB.Add_Exc_Msg

1345: WHEN OTHERS THEN
1346:
1347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1348: THEN
1349: OE_MSG_PUB.Add_Exc_Msg
1350: ( G_PKG_NAME
1351: , 'Delete_Row'
1352: );
1353: END IF;

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

1447: (p_currency_header_id IS NOT NULL
1448: AND
1449: p_currency_header_id <> FND_API.G_MISS_NUM)
1450: THEN
1451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1452: THEN
1453: OE_MSG_PUB.Add_Exc_Msg
1454: ( G_PKG_NAME
1455: , 'Query Rows'

Line 1453: OE_MSG_PUB.Add_Exc_Msg

1449: p_currency_header_id <> FND_API.G_MISS_NUM)
1450: THEN
1451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1452: THEN
1453: OE_MSG_PUB.Add_Exc_Msg
1454: ( G_PKG_NAME
1455: , 'Query Rows'
1456: , 'Keys are mutually exclusive: currency_detail_id = '|| p_currency_detail_id || ', currency_header_id = '|| p_currency_header_id
1457: );

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

1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543:
1544: WHEN OTHERS THEN
1545:
1546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1547: THEN
1548: OE_MSG_PUB.Add_Exc_Msg
1549: ( G_PKG_NAME
1550: , 'Query_Rows'

Line 1548: OE_MSG_PUB.Add_Exc_Msg

1544: WHEN OTHERS THEN
1545:
1546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1547: THEN
1548: OE_MSG_PUB.Add_Exc_Msg
1549: ( G_PKG_NAME
1550: , 'Query_Rows'
1551: );
1552: END IF;

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

1774:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1777:
1778: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1779: THEN
1780:
1781: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1782: OE_MSG_PUB.Add;

Line 1782: OE_MSG_PUB.Add;

1778: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1779: THEN
1780:
1781: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1782: OE_MSG_PUB.Add;
1783:
1784: END IF;
1785:
1786: END IF;

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

1791:
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1794:
1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1796: THEN
1797:
1798: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1799: OE_MSG_PUB.Add;

Line 1799: OE_MSG_PUB.Add;

1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1796: THEN
1797:
1798: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1799: OE_MSG_PUB.Add;
1800:
1801: END IF;
1802: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1803:

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

1803:
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1808: THEN
1809:
1810: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1811: OE_MSG_PUB.Add;

Line 1811: OE_MSG_PUB.Add;

1807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1808: THEN
1809:
1810: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1811: OE_MSG_PUB.Add;
1812:
1813: END IF;
1814: WHEN OTHERS THEN
1815:

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

1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1817: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN
1821: OE_MSG_PUB.Add_Exc_Msg
1822: ( G_PKG_NAME
1823: , 'Lock_Row'

Line 1821: OE_MSG_PUB.Add_Exc_Msg

1817: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN
1821: OE_MSG_PUB.Add_Exc_Msg
1822: ( G_PKG_NAME
1823: , 'Lock_Row'
1824: );
1825: END IF;

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

1915: IF p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM THEN
1916:
1917: l_CURR_DETAILS_rec.currency_detail_id := p_CURR_DETAILS_rec.currency_detail_id;
1918:
1919: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1920: THEN
1921:
1922: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1923: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail');

Line 1924: OE_MSG_PUB.Add;

1920: THEN
1921:
1922: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1923: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail');
1924: OE_MSG_PUB.Add;
1925:
1926: END IF;
1927:
1928: ELSE

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

1945: IF p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1946:
1947: l_CURR_DETAILS_rec.currency_header_id := p_CURR_DETAILS_rec.currency_header_id;
1948:
1949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1950: THEN
1951:
1952: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');

Line 1954: OE_MSG_PUB.Add;

1950: THEN
1951:
1952: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');
1954: OE_MSG_PUB.Add;
1955:
1956: END IF;
1957:
1958: ELSE

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

1975: IF p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM THEN
1976:
1977: l_CURR_DETAILS_rec.markup_formula_id := p_CURR_DETAILS_rec.markup_formula_id;
1978:
1979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1980: THEN
1981:
1982: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula');

Line 1984: OE_MSG_PUB.Add;

1980: THEN
1981:
1982: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula');
1984: OE_MSG_PUB.Add;
1985:
1986: END IF;
1987:
1988: ELSE

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

2005: IF p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
2006:
2007: l_CURR_DETAILS_rec.price_formula_id := p_CURR_DETAILS_rec.price_formula_id;
2008:
2009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2010: THEN
2011:
2012: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');

Line 2014: OE_MSG_PUB.Add;

2010: THEN
2011:
2012: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
2014: OE_MSG_PUB.Add;
2015:
2016: END IF;
2017:
2018: ELSE

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

2035: IF p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR THEN
2036:
2037: l_CURR_DETAILS_rec.to_currency_code := p_CURR_DETAILS_rec.to_currency_code;
2038:
2039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2040: THEN
2041:
2042: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency');

Line 2044: OE_MSG_PUB.Add;

2040: THEN
2041:
2042: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency');
2044: OE_MSG_PUB.Add;
2045:
2046: END IF;
2047:
2048: ELSE