1807:
1808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810:
1811: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1812: OE_MSG_PUB.Add;
1813:
1814: END IF;
1815:
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827:
1828: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1829: OE_MSG_PUB.Add;
1830:
1831: END IF;
1832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1836:
1837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1838: THEN
1839:
1840: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1841: OE_MSG_PUB.Add;
1842:
1843: END IF;
1844: WHEN OTHERS THEN
1960:
1961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1962: THEN
1963:
1964: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');
1966: OE_MSG_PUB.Add;
1967:
1968: END IF;
1961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1962: THEN
1963:
1964: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');
1966: OE_MSG_PUB.Add;
1967:
1968: END IF;
1969:
1990:
1991: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1992: THEN
1993:
1994: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');
1996: OE_MSG_PUB.Add;
1997:
1998: END IF;
1991: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1992: THEN
1993:
1994: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');
1996: OE_MSG_PUB.Add;
1997:
1998: END IF;
1999:
2020:
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2022: THEN
2023:
2024: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');
2026: OE_MSG_PUB.Add;
2027:
2028: END IF;
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2022: THEN
2023:
2024: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');
2026: OE_MSG_PUB.Add;
2027:
2028: END IF;
2029:
2050:
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2052: THEN
2053:
2054: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2056: OE_MSG_PUB.Add;
2057:
2058: END IF;
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2052: THEN
2053:
2054: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2056: OE_MSG_PUB.Add;
2057:
2058: END IF;
2059:
2080:
2081: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2082: THEN
2083:
2084: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2086: OE_MSG_PUB.Add;
2087:
2088: END IF;
2081: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2082: THEN
2083:
2084: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2086: OE_MSG_PUB.Add;
2087:
2088: END IF;
2089:
2110:
2111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2112: THEN
2113:
2114: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2116: OE_MSG_PUB.Add;
2117:
2118: END IF;
2111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2112: THEN
2113:
2114: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2116: OE_MSG_PUB.Add;
2117:
2118: END IF;
2119: