1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN
1396:
1397: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1398: OE_MSG_PUB.Add;
1399:
1400: END IF;
1401:
1410:
1411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1412: THEN
1413:
1414: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1415: OE_MSG_PUB.Add;
1416:
1417: END IF;
1418: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1422:
1423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN
1425:
1426: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1427: OE_MSG_PUB.Add;
1428:
1429: END IF;
1430: WHEN OTHERS THEN
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','attribute_sourcing');
1540: OE_MSG_PUB.Add;
1541:
1542: END IF;
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','attribute_sourcing');
1540: OE_MSG_PUB.Add;
1541:
1542: END IF;
1543:
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','enabled');
1570: OE_MSG_PUB.Add;
1571:
1572: END IF;
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','enabled');
1570: OE_MSG_PUB.Add;
1571:
1572: END IF;
1573:
1594:
1595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1596: THEN
1597:
1598: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1600: OE_MSG_PUB.Add;
1601:
1602: END IF;
1595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1596: THEN
1597:
1598: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1600: OE_MSG_PUB.Add;
1601:
1602: END IF;
1603:
1624:
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1626: THEN
1627:
1628: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1630: OE_MSG_PUB.Add;
1631:
1632: END IF;
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1626: THEN
1627:
1628: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1630: OE_MSG_PUB.Add;
1631:
1632: END IF;
1633:
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1656: THEN
1657:
1658: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
1660: OE_MSG_PUB.Add;
1661:
1662: END IF;
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1656: THEN
1657:
1658: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
1660: OE_MSG_PUB.Add;
1661:
1662: END IF;
1663: