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

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

878: EXCEPTION
879:
880: WHEN OTHERS THEN
881:
882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Update_Row'

Line 884: OE_MSG_PUB.Add_Exc_Msg

880: WHEN OTHERS THEN
881:
882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Update_Row'
887: );
888: END IF;

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

998: EXCEPTION
999:
1000: WHEN OTHERS THEN
1001:
1002: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1003: THEN
1004: OE_MSG_PUB.Add_Exc_Msg
1005: ( G_PKG_NAME
1006: , 'Insert_Row'

Line 1004: OE_MSG_PUB.Add_Exc_Msg

1000: WHEN OTHERS THEN
1001:
1002: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1003: THEN
1004: OE_MSG_PUB.Add_Exc_Msg
1005: ( G_PKG_NAME
1006: , 'Insert_Row'
1007: );
1008: END IF;

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

1027: EXCEPTION
1028:
1029: WHEN OTHERS THEN
1030:
1031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: OE_MSG_PUB.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Delete_Row'

Line 1033: OE_MSG_PUB.Add_Exc_Msg

1029: WHEN OTHERS THEN
1030:
1031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: OE_MSG_PUB.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Delete_Row'
1036: );
1037: END IF;

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

1118: (p_limit_id IS NOT NULL
1119: AND
1120: p_limit_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg
1125: ( G_PKG_NAME
1126: , 'Query Rows'

Line 1124: OE_MSG_PUB.Add_Exc_Msg

1120: p_limit_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg
1125: ( G_PKG_NAME
1126: , 'Query Rows'
1127: , 'Keys are mutually exclusive: limit_attribute_id = '|| p_limit_attribute_id || ', limit_id = '|| p_limit_id
1128: );

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

1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201:
1202: WHEN OTHERS THEN
1203:
1204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205: THEN
1206: OE_MSG_PUB.Add_Exc_Msg
1207: ( G_PKG_NAME
1208: , 'Query_Rows'

Line 1206: OE_MSG_PUB.Add_Exc_Msg

1202: WHEN OTHERS THEN
1203:
1204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205: THEN
1206: OE_MSG_PUB.Add_Exc_Msg
1207: ( G_PKG_NAME
1208: , 'Query_Rows'
1209: );
1210: END IF;

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

1380:
1381: x_return_status := FND_API.G_RET_STS_ERROR;
1382: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN
1386:
1387: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1388: OE_MSG_PUB.Add;

Line 1388: OE_MSG_PUB.Add;

1384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN
1386:
1387: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1388: OE_MSG_PUB.Add;
1389:
1390: END IF;
1391:
1392: END IF;

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

1397:
1398: x_return_status := FND_API.G_RET_STS_ERROR;
1399: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1400:
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1402: THEN
1403:
1404: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1405: OE_MSG_PUB.Add;

Line 1405: OE_MSG_PUB.Add;

1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1402: THEN
1403:
1404: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1405: OE_MSG_PUB.Add;
1406:
1407: END IF;
1408: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1409:

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

1409:
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1414: THEN
1415:
1416: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1417: OE_MSG_PUB.Add;

Line 1417: OE_MSG_PUB.Add;

1413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1414: THEN
1415:
1416: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1417: OE_MSG_PUB.Add;
1418:
1419: END IF;
1420: WHEN OTHERS THEN
1421:

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

1421:
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN
1427: OE_MSG_PUB.Add_Exc_Msg
1428: ( G_PKG_NAME
1429: , 'Lock_Row'

Line 1427: OE_MSG_PUB.Add_Exc_Msg

1423: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN
1427: OE_MSG_PUB.Add_Exc_Msg
1428: ( G_PKG_NAME
1429: , 'Lock_Row'
1430: );
1431: END IF;

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

1501: IF p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1502:
1503: l_LIMIT_ATTRS_rec.comparison_operator_code := p_LIMIT_ATTRS_rec.comparison_operator_code;
1504:
1505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1506: THEN
1507:
1508: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');

Line 1510: OE_MSG_PUB.Add;

1506: THEN
1507:
1508: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
1510: OE_MSG_PUB.Add;
1511:
1512: END IF;
1513:
1514: ELSE

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

1531: IF p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM THEN
1532:
1533: l_LIMIT_ATTRS_rec.limit_attribute_id := p_LIMIT_ATTRS_rec.limit_attribute_id;
1534:
1535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1536: THEN
1537:
1538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute');

Line 1540: OE_MSG_PUB.Add;

1536: THEN
1537:
1538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute');
1540: OE_MSG_PUB.Add;
1541:
1542: END IF;
1543:
1544: ELSE

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

1561: IF p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1562:
1563: l_LIMIT_ATTRS_rec.limit_id := p_LIMIT_ATTRS_rec.limit_id;
1564:
1565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1566: THEN
1567:
1568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');

Line 1570: OE_MSG_PUB.Add;

1566: THEN
1567:
1568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');
1570: OE_MSG_PUB.Add;
1571:
1572: END IF;
1573:
1574: ELSE

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

1621: RAISE;
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623: RAISE;
1624: WHEN OTHERS THEN
1625: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1626: THEN
1627: oe_msg_pub.Add_Exc_Msg
1628: ( G_PKG_NAME
1629: , 'Pre_Write_Process'

Line 1627: oe_msg_pub.Add_Exc_Msg

1623: RAISE;
1624: WHEN OTHERS THEN
1625: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1626: THEN
1627: oe_msg_pub.Add_Exc_Msg
1628: ( G_PKG_NAME
1629: , 'Pre_Write_Process'
1630: );
1631: END IF;