477: WHEN TOO_MANY_ROWS THEN
478: -- if the multi-currency list is attached to multiple price lists
479: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to more than one Price Lists, so Base Currency Code can not be modified');
480:
481: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
482: OE_MSG_PUB.Add;
483:
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: WHEN list_already_attached THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: WHEN list_already_attached THEN
486: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to a Price List, so Base Currency Code can not be modified');
487:
488: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
489: OE_MSG_PUB.Add;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
1158:
1159: Exception
1160: WHEN DUP_VAL_ON_INDEX THEN
1161:
1162: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MULTICURR');
1163: OE_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN OTHERS THEN
1599:
1600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1601: THEN
1602:
1603: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1604: OE_MSG_PUB.Add;
1605:
1606: END IF;
1607:
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1618: THEN
1619:
1620: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1621: OE_MSG_PUB.Add;
1622:
1623: END IF;
1624: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1628:
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631:
1632: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1633: OE_MSG_PUB.Add;
1634:
1635: END IF;
1636: WHEN OTHERS THEN
1738:
1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1740: THEN
1741:
1742: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');
1744: OE_MSG_PUB.Add;
1745:
1746: END IF;
1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1740: THEN
1741:
1742: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');
1744: OE_MSG_PUB.Add;
1745:
1746: END IF;
1747:
1768:
1769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1770: THEN
1771:
1772: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');
1774: OE_MSG_PUB.Add;
1775:
1776: END IF;
1769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1770: THEN
1771:
1772: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');
1774: OE_MSG_PUB.Add;
1775:
1776: END IF;
1777:
1799:
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1801: THEN
1802:
1803: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');
1805: OE_MSG_PUB.Add;
1806:
1807: END IF;
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1801: THEN
1802:
1803: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');
1805: OE_MSG_PUB.Add;
1806:
1807: END IF;
1808:
1830:
1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1832: THEN
1833:
1834: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1836: OE_MSG_PUB.Add;
1837:
1838: END IF;
1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1832: THEN
1833:
1834: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1836: OE_MSG_PUB.Add;
1837:
1838: END IF;
1839: