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

Line 1258: OE_MSG_PUB.Add_Exc_Msg

1254: ,null
1255: ,p_LIMITS_rec.limit_id
1256: ,null);
1257: IF x_retcode = 2 THEN
1258: OE_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'UPDATE_BALANCES'
1261: );
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1269:
1270: WHEN OTHERS THEN
1271:
1272:
1273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: OE_MSG_PUB.Add_Exc_Msg
1276: ( G_PKG_NAME
1277: , 'Update_Row'

Line 1275: OE_MSG_PUB.Add_Exc_Msg

1271:
1272:
1273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: OE_MSG_PUB.Add_Exc_Msg
1276: ( G_PKG_NAME
1277: , 'Update_Row'
1278: );
1279: END IF;

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

1426: EXCEPTION
1427:
1428: WHEN OTHERS THEN
1429:
1430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: OE_MSG_PUB.Add_Exc_Msg
1433: ( G_PKG_NAME
1434: , 'Insert_Row'

Line 1432: OE_MSG_PUB.Add_Exc_Msg

1428: WHEN OTHERS THEN
1429:
1430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: OE_MSG_PUB.Add_Exc_Msg
1433: ( G_PKG_NAME
1434: , 'Insert_Row'
1435: );
1436: END IF;

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

1464: EXCEPTION
1465:
1466: WHEN OTHERS THEN
1467:
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: OE_MSG_PUB.Add_Exc_Msg
1471: ( G_PKG_NAME
1472: , 'Delete_Row'

Line 1470: OE_MSG_PUB.Add_Exc_Msg

1466: WHEN OTHERS THEN
1467:
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: OE_MSG_PUB.Add_Exc_Msg
1471: ( G_PKG_NAME
1472: , 'Delete_Row'
1473: );
1474: END IF;

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

1584: RETURN l_LIMITS_rec;
1585:
1586: WHEN OTHERS THEN
1587:
1588: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1589: THEN
1590: OE_MSG_PUB.Add_Exc_Msg
1591: ( G_PKG_NAME
1592: , 'Query_Row'

Line 1590: OE_MSG_PUB.Add_Exc_Msg

1586: WHEN OTHERS THEN
1587:
1588: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1589: THEN
1590: OE_MSG_PUB.Add_Exc_Msg
1591: ( G_PKG_NAME
1592: , 'Query_Row'
1593: );
1594: END IF;

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

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

Line 1812: OE_MSG_PUB.Add;

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

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

1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827:
1828: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1829: OE_MSG_PUB.Add;

Line 1829: OE_MSG_PUB.Add;

1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827:
1828: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1829: OE_MSG_PUB.Add;
1830:
1831: END IF;
1832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1833:

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

1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1836:
1837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1838: THEN
1839:
1840: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1841: OE_MSG_PUB.Add;

Line 1841: OE_MSG_PUB.Add;

1837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1838: THEN
1839:
1840: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1841: OE_MSG_PUB.Add;
1842:
1843: END IF;
1844: WHEN OTHERS THEN
1845:

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

1845:
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848:
1849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: OE_MSG_PUB.Add_Exc_Msg
1852: ( G_PKG_NAME
1853: , 'Lock_Row'

Line 1851: OE_MSG_PUB.Add_Exc_Msg

1847: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848:
1849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: OE_MSG_PUB.Add_Exc_Msg
1852: ( G_PKG_NAME
1853: , 'Lock_Row'
1854: );
1855: END IF;

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

1957: IF p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN
1958:
1959: l_LIMITS_rec.limit_exceed_action_code := p_LIMITS_rec.limit_exceed_action_code;
1960:
1961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1962: THEN
1963:
1964: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');

Line 1966: OE_MSG_PUB.Add;

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

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

1987: IF p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1988:
1989: l_LIMITS_rec.limit_id := p_LIMITS_rec.limit_id;
1990:
1991: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1992: THEN
1993:
1994: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');

Line 1996: OE_MSG_PUB.Add;

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

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

2017: IF p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR THEN
2018:
2019: l_LIMITS_rec.limit_level_code := p_LIMITS_rec.limit_level_code;
2020:
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2022: THEN
2023:
2024: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');

Line 2026: OE_MSG_PUB.Add;

2022: THEN
2023:
2024: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');
2026: OE_MSG_PUB.Add;
2027:
2028: END IF;
2029:
2030: ELSE

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

2047: IF p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2048:
2049: l_LIMITS_rec.list_header_id := p_LIMITS_rec.list_header_id;
2050:
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2052: THEN
2053:
2054: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 2056: OE_MSG_PUB.Add;

2052: THEN
2053:
2054: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2056: OE_MSG_PUB.Add;
2057:
2058: END IF;
2059:
2060: ELSE

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

2077: IF p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2078:
2079: l_LIMITS_rec.list_line_id := p_LIMITS_rec.list_line_id;
2080:
2081: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2082: THEN
2083:
2084: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 2086: OE_MSG_PUB.Add;

2082: THEN
2083:
2084: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2086: OE_MSG_PUB.Add;
2087:
2088: END IF;
2089:
2090: ELSE

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

2107: IF p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR THEN
2108:
2109: l_LIMITS_rec.organization_flag := p_LIMITS_rec.organization_flag;
2110:
2111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2112: THEN
2113:
2114: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 2116: OE_MSG_PUB.Add;

2112: THEN
2113:
2114: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2116: OE_MSG_PUB.Add;
2117:
2118: END IF;
2119:
2120: ELSE

Line 2171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2167: RAISE;
2168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2169: RAISE;
2170: WHEN OTHERS THEN
2171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2172: THEN
2173: oe_msg_pub.Add_Exc_Msg
2174: ( G_PKG_NAME
2175: , 'Pre_Write_Process'

Line 2173: oe_msg_pub.Add_Exc_Msg

2169: RAISE;
2170: WHEN OTHERS THEN
2171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2172: THEN
2173: oe_msg_pub.Add_Exc_Msg
2174: ( G_PKG_NAME
2175: , 'Pre_Write_Process'
2176: );
2177: END IF;