1375:
1376: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1377: THEN
1378:
1379: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1380: OE_MSG_PUB.Add;
1381:
1382: END IF;
1383:
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_DELETED');
1398: OE_MSG_PUB.Add;
1399:
1400: END IF;
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1405:
1406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1407: THEN
1408:
1409: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1410: OE_MSG_PUB.Add;
1411:
1412: END IF;
1413: WHEN OTHERS THEN
1520:
1521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1522: THEN
1523:
1524: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
1526: OE_MSG_PUB.Add;
1527:
1528: END IF;
1521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1522: THEN
1523:
1524: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
1526: OE_MSG_PUB.Add;
1527:
1528: END IF;
1529:
1550:
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1555: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');
1556: OE_MSG_PUB.Add;
1557:
1558: END IF;
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1555: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');
1556: OE_MSG_PUB.Add;
1557:
1558: END IF;
1559:
1580:
1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1582: THEN
1583:
1584: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');
1586: OE_MSG_PUB.Add;
1587:
1588: END IF;
1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1582: THEN
1583:
1584: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');
1586: OE_MSG_PUB.Add;
1587:
1588: END IF;
1589:
1610:
1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1612: THEN
1613:
1614: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
1616: OE_MSG_PUB.Add;
1617:
1618: END IF;
1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1612: THEN
1613:
1614: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
1616: OE_MSG_PUB.Add;
1617:
1618: END IF;
1619:
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1642: THEN
1643:
1644: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');
1646: OE_MSG_PUB.Add;
1647:
1648: END IF;
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1642: THEN
1643:
1644: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');
1646: OE_MSG_PUB.Add;
1647:
1648: END IF;
1649: