1359:
1360: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1361: THEN
1362:
1363: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1364: OE_MSG_PUB.Add;
1365:
1366: END IF;
1367:
1376:
1377: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379:
1380: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1381: OE_MSG_PUB.Add;
1382:
1383: END IF;
1384: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1388:
1389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1390: THEN
1391:
1392: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1393: OE_MSG_PUB.Add;
1394:
1395: END IF;
1396: WHEN OTHERS THEN
1480:
1481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1482: THEN
1483:
1484: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1486: OE_MSG_PUB.Add;
1487:
1488: END IF;
1481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1482: THEN
1483:
1484: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1486: OE_MSG_PUB.Add;
1487:
1488: END IF;
1489:
1510:
1511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1512: THEN
1513:
1514: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
1516: OE_MSG_PUB.Add;
1517:
1518: END IF;
1511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1512: THEN
1513:
1514: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
1516: OE_MSG_PUB.Add;
1517:
1518: END IF;
1519:
1540:
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1542: THEN
1543:
1544: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1545: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1546: OE_MSG_PUB.Add;
1547:
1548: END IF;
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1542: THEN
1543:
1544: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1545: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1546: OE_MSG_PUB.Add;
1547:
1548: END IF;
1549: