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

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

874: EXCEPTION
875:
876: WHEN OTHERS THEN
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Update_Row'

Line 880: OE_MSG_PUB.Add_Exc_Msg

876: WHEN OTHERS THEN
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Update_Row'
883: );
884: END IF;

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

972: EXCEPTION
973:
974: WHEN OTHERS THEN
975:
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME
980: , 'Insert_Row'

Line 978: OE_MSG_PUB.Add_Exc_Msg

974: WHEN OTHERS THEN
975:
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME
980: , 'Insert_Row'
981: );
982: END IF;

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

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

Line 1006: OE_MSG_PUB.Add_Exc_Msg

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

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

1093: (p_lookup_code IS NOT NULL
1094: AND
1095: p_lookup_code <> FND_API.G_MISS_CHAR)
1096: THEN
1097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: OE_MSG_PUB.Add_Exc_Msg
1100: ( G_PKG_NAME
1101: , 'Query Rows'

Line 1099: OE_MSG_PUB.Add_Exc_Msg

1095: p_lookup_code <> FND_API.G_MISS_CHAR)
1096: THEN
1097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: OE_MSG_PUB.Add_Exc_Msg
1100: ( G_PKG_NAME
1101: , 'Query Rows'
1102: , 'Keys are mutually exclusive: segment_pte_id = '|| p_segment_pte_id || ', lookup_code = '|| p_lookup_code
1103: );

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

1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177:
1178: WHEN OTHERS THEN
1179:
1180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: OE_MSG_PUB.Add_Exc_Msg
1183: ( G_PKG_NAME
1184: , 'Query_Rows'

Line 1182: OE_MSG_PUB.Add_Exc_Msg

1178: WHEN OTHERS THEN
1179:
1180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: OE_MSG_PUB.Add_Exc_Msg
1183: ( G_PKG_NAME
1184: , 'Query_Rows'
1185: );
1186: END IF;

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

1360:
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1363:
1364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1365: THEN
1366:
1367: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1368: OE_MSG_PUB.Add;

Line 1368: OE_MSG_PUB.Add;

1364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1365: THEN
1366:
1367: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1368: OE_MSG_PUB.Add;
1369:
1370: END IF;
1371:
1372: END IF;

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

1377:
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1380:
1381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1382: THEN
1383:
1384: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1385: OE_MSG_PUB.Add;

Line 1385: OE_MSG_PUB.Add;

1381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1382: THEN
1383:
1384: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1385: OE_MSG_PUB.Add;
1386:
1387: END IF;
1388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1389:

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

1389:
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1392:
1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1394: THEN
1395:
1396: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1397: OE_MSG_PUB.Add;

Line 1397: OE_MSG_PUB.Add;

1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1394: THEN
1395:
1396: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1397: OE_MSG_PUB.Add;
1398:
1399: END IF;
1400: WHEN OTHERS THEN
1401:

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

1401:
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: x_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404:
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1406: THEN
1407: OE_MSG_PUB.Add_Exc_Msg
1408: ( G_PKG_NAME
1409: , 'Lock_Row'

Line 1407: OE_MSG_PUB.Add_Exc_Msg

1403: x_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404:
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1406: THEN
1407: OE_MSG_PUB.Add_Exc_Msg
1408: ( G_PKG_NAME
1409: , 'Lock_Row'
1410: );
1411: END IF;

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

1481: IF p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1482:
1483: l_PSG_rec.pte_code := p_PSG_rec.pte_code;
1484:
1485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1486: THEN
1487:
1488: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1489: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');

Line 1490: OE_MSG_PUB.Add;

1486: THEN
1487:
1488: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1489: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1490: OE_MSG_PUB.Add;
1491:
1492: END IF;
1493:
1494: ELSE

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

1511: IF p_PSG_rec.segment_id <> FND_API.G_MISS_NUM THEN
1512:
1513: l_PSG_rec.segment_id := p_PSG_rec.segment_id;
1514:
1515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1516: THEN
1517:
1518: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');

Line 1520: OE_MSG_PUB.Add;

1516: THEN
1517:
1518: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523:
1524: ELSE

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

1543: IF p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM THEN
1544:
1545: l_PSG_rec.segment_pte_id := p_PSG_rec.segment_pte_id;
1546:
1547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1548: THEN
1549:
1550: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte');

Line 1552: OE_MSG_PUB.Add;

1548: THEN
1549:
1550: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte');
1552: OE_MSG_PUB.Add;
1553:
1554: END IF;
1555:
1556: ELSE