1486:
1487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1488: THEN
1489:
1490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1491: OE_MSG_PUB.Add;
1492:
1493: END IF;
1494:
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506:
1507: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1508: OE_MSG_PUB.Add;
1509:
1510: END IF;
1511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1517: THEN
1518:
1519: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523: WHEN OTHERS THEN
1617:
1618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1619: THEN
1620:
1621: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1623: OE_MSG_PUB.Add;
1624:
1625: END IF;
1618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1619: THEN
1620:
1621: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1623: OE_MSG_PUB.Add;
1624:
1625: END IF;
1626:
1647:
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1649: THEN
1650:
1651: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1653: OE_MSG_PUB.Add;
1654:
1655: END IF;
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1649: THEN
1650:
1651: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1653: OE_MSG_PUB.Add;
1654:
1655: END IF;
1656:
1677:
1678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1679: THEN
1680:
1681: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1683: OE_MSG_PUB.Add;
1684:
1685: END IF;
1678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1679: THEN
1680:
1681: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1683: OE_MSG_PUB.Add;
1684:
1685: END IF;
1686:
1707:
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1713: OE_MSG_PUB.Add;
1714:
1715: END IF;
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1713: OE_MSG_PUB.Add;
1714:
1715: END IF;
1716: