1237: end_user_column_name = p_SEG_rec.segment_code and
1238: rownum = 1;
1239:
1240: --l_return_status := FND_API.G_RET_STS_ERROR;
1241: FND_MESSAGE.SET_NAME('QP','QP_ATTR_EXISTS_IN_FF');
1242: --FND_MESSAGE.SET_TOKEN('PTE_CODE', l_pte_code);
1243: OE_MSG_PUB.Add;
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: exception
1238: rownum = 1;
1239:
1240: --l_return_status := FND_API.G_RET_STS_ERROR;
1241: FND_MESSAGE.SET_NAME('QP','QP_ATTR_EXISTS_IN_FF');
1242: --FND_MESSAGE.SET_TOKEN('PTE_CODE', l_pte_code);
1243: OE_MSG_PUB.Add;
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: exception
1246: when no_data_found then
1891:
1892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1893: THEN
1894:
1895: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED_abhi6');
1896: OE_MSG_PUB.Add;
1897:
1898: END IF;
1899:
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN
1911:
1912: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1913: OE_MSG_PUB.Add;
1914:
1915: END IF;
1916: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1922: THEN
1923:
1924: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1925: OE_MSG_PUB.Add;
1926:
1927: END IF;
1928: WHEN OTHERS THEN
2032:
2033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2034: THEN
2035:
2036: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
2038: OE_MSG_PUB.Add;
2039:
2040: END IF;
2033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2034: THEN
2035:
2036: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
2038: OE_MSG_PUB.Add;
2039:
2040: END IF;
2041:
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2064: THEN
2065:
2066: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
2068: OE_MSG_PUB.Add;
2069:
2070: END IF;
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2064: THEN
2065:
2066: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
2068: OE_MSG_PUB.Add;
2069:
2070: END IF;
2071:
2092:
2093: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2094: THEN
2095:
2096: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2097: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');
2098: OE_MSG_PUB.Add;
2099:
2100: END IF;
2093: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2094: THEN
2095:
2096: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2097: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');
2098: OE_MSG_PUB.Add;
2099:
2100: END IF;
2101:
2122:
2123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2124: THEN
2125:
2126: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
2128: OE_MSG_PUB.Add;
2129:
2130: END IF;
2123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2124: THEN
2125:
2126: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
2128: OE_MSG_PUB.Add;
2129:
2130: END IF;
2131:
2152:
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2154: THEN
2155:
2156: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');
2158: OE_MSG_PUB.Add;
2159:
2160: END IF;
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2154: THEN
2155:
2156: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');
2158: OE_MSG_PUB.Add;
2159:
2160: END IF;
2161: