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

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

804: EXCEPTION
805:
806: WHEN OTHERS THEN
807:
808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: OE_MSG_PUB.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Update_Row'

Line 810: OE_MSG_PUB.Add_Exc_Msg

806: WHEN OTHERS THEN
807:
808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: OE_MSG_PUB.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Update_Row'
813: );
814: END IF;

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

893: EXCEPTION
894:
895: WHEN OTHERS THEN
896:
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: OE_MSG_PUB.Add_Exc_Msg
900: ( G_PKG_NAME
901: , 'Insert_Row'

Line 899: OE_MSG_PUB.Add_Exc_Msg

895: WHEN OTHERS THEN
896:
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: OE_MSG_PUB.Add_Exc_Msg
900: ( G_PKG_NAME
901: , 'Insert_Row'
902: );
903: END IF;

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

921: EXCEPTION
922:
923: WHEN OTHERS THEN
924:
925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: OE_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Delete_Row'

Line 927: OE_MSG_PUB.Add_Exc_Msg

923: WHEN OTHERS THEN
924:
925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: OE_MSG_PUB.Add_Exc_Msg
928: ( G_PKG_NAME
929: , 'Delete_Row'
930: );
931: END IF;

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

1009: (p_pte_source_system_id IS NOT NULL
1010: AND
1011: p_pte_source_system_id <> FND_API.G_MISS_NUM)
1012: THEN
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Query Rows'

Line 1015: OE_MSG_PUB.Add_Exc_Msg

1011: p_pte_source_system_id <> FND_API.G_MISS_NUM)
1012: THEN
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Query Rows'
1018: , 'Keys are mutually exclusive: pte_sourcesystem_fnarea_id = '|| p_pte_sourcesystem_fnarea_id || ', pte_source_system_id = '|| p_pte_source_system_id
1019: );

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

1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088:
1089: WHEN OTHERS THEN
1090:
1091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1092: THEN
1093: OE_MSG_PUB.Add_Exc_Msg
1094: ( G_PKG_NAME
1095: , 'Query_Rows'

Line 1093: OE_MSG_PUB.Add_Exc_Msg

1089: WHEN OTHERS THEN
1090:
1091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1092: THEN
1093: OE_MSG_PUB.Add_Exc_Msg
1094: ( G_PKG_NAME
1095: , 'Query_Rows'
1096: );
1097: END IF;

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

1255:
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1258:
1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN
1261:
1262: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1263: OE_MSG_PUB.Add;

Line 1263: OE_MSG_PUB.Add;

1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN
1261:
1262: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1263: OE_MSG_PUB.Add;
1264:
1265: END IF;
1266:
1267: END IF;

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

1272:
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1275:
1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1277: THEN
1278:
1279: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1280: OE_MSG_PUB.Add;

Line 1280: OE_MSG_PUB.Add;

1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1277: THEN
1278:
1279: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1280: OE_MSG_PUB.Add;
1281:
1282: END IF;
1283: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1284:

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

1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN
1290:
1291: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1292: OE_MSG_PUB.Add;

Line 1292: OE_MSG_PUB.Add;

1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN
1290:
1291: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1292: OE_MSG_PUB.Add;
1293:
1294: END IF;
1295: WHEN OTHERS THEN
1296:

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

1296:
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: x_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN
1302: OE_MSG_PUB.Add_Exc_Msg
1303: ( G_PKG_NAME
1304: , 'Lock_Row'

Line 1302: OE_MSG_PUB.Add_Exc_Msg

1298: x_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN
1302: OE_MSG_PUB.Add_Exc_Msg
1303: ( G_PKG_NAME
1304: , 'Lock_Row'
1305: );
1306: END IF;

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

1404: IF p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1405:
1406: l_FNA_rec.enabled_flag := p_FNA_rec.enabled_flag;
1407:
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');

Line 1413: OE_MSG_PUB.Add;

1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1413: OE_MSG_PUB.Add;
1414:
1415: END IF;
1416:
1417: ELSE

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

1434: IF p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM THEN
1435:
1436: l_FNA_rec.functional_area_id := p_FNA_rec.functional_area_id;
1437:
1438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1439: THEN
1440:
1441: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');

Line 1443: OE_MSG_PUB.Add;

1439: THEN
1440:
1441: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');
1443: OE_MSG_PUB.Add;
1444:
1445: END IF;
1446:
1447: ELSE

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

1464: IF p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM THEN
1465:
1466: l_FNA_rec.pte_sourcesystem_fnarea_id := p_FNA_rec.pte_sourcesystem_fnarea_id;
1467:
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1469: THEN
1470:
1471: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1472: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');

Line 1473: OE_MSG_PUB.Add;

1469: THEN
1470:
1471: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1472: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');
1473: OE_MSG_PUB.Add;
1474:
1475: END IF;
1476:
1477: ELSE

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

1494: IF p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM THEN
1495:
1496: l_FNA_rec.pte_source_system_id := p_FNA_rec.pte_source_system_id;
1497:
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');

Line 1503: OE_MSG_PUB.Add;

1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');
1503: OE_MSG_PUB.Add;
1504:
1505: END IF;
1506:
1507: ELSE

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

1524: IF p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1525:
1526: l_FNA_rec.seeded_flag := p_FNA_rec.seeded_flag;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1529: THEN
1530:
1531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');

Line 1533: OE_MSG_PUB.Add;

1529: THEN
1530:
1531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1533: OE_MSG_PUB.Add;
1534:
1535: END IF;
1536:
1537: ELSE

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

1566: l_ss VARCHAR2(30);
1567: l_fna_desc VARCHAR2(80);
1568: BEGIN
1569:
1570: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1571: THEN
1572: -- Get l_msg_name and l_action
1573: IF p_action = 'DELETE' OR
1574: p_action = 'DISABLE' THEN

Line 1608: OE_MSG_PUB.Add;

1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1608: OE_MSG_PUB.Add;
1609: END IF;
1610:
1611: END Warn_Disable_Delete_Fna;
1612: