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;
1369:
1370: END IF;
1371:
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;
1386:
1387: END IF;
1388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
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;
1398:
1399: END IF;
1400: WHEN OTHERS THEN
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');
1490: OE_MSG_PUB.Add;
1491:
1492: END IF;
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');
1490: OE_MSG_PUB.Add;
1491:
1492: END IF;
1493:
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');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
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');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523:
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');
1552: OE_MSG_PUB.Add;
1553:
1554: END IF;
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');
1552: OE_MSG_PUB.Add;
1553:
1554: END IF;
1555: