1911:
1912: Exception
1913: WHEN DUP_VAL_ON_INDEX THEN
1914:
1915: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1916: OE_MSG_PUB.Add;
1917: RAISE FND_API.G_EXC_ERROR;
1918:
1919: WHEN OTHERS THEN
2002:
2003: Exception
2004: WHEN DUP_VAL_ON_INDEX THEN
2005:
2006: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
2007: OE_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_ERROR;
2009:
2010: WHEN OTHERS THEN
2179: /*added this code to raise exception if qualifier does not get created-spgopal*/
2180:
2181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: oe_debug_pub.add('l_ret_sts if'||l_return_status);
2183: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2184: OE_MSG_PUB.Add;
2185:
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185:
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: oe_debug_pub.add('l_ret_sts else '||l_return_status);
2189: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2190: OE_MSG_PUB.Add;
2191: RAISE FND_API.G_EXC_ERROR;
2192: END IF;
2193:
2806:
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2808: THEN
2809:
2810: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2811: OE_MSG_PUB.Add;
2812:
2813: END IF;
2814:
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN
2827:
2828: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2829: OE_MSG_PUB.Add;
2830:
2831: END IF;
2832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2836:
2837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2838: THEN
2839:
2840: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2841: OE_MSG_PUB.Add;
2842:
2843: END IF;
2844: WHEN OTHERS THEN
2991:
2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2993: THEN
2994:
2995: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
2997: OE_MSG_PUB.Add;
2998:
2999: END IF;
2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2993: THEN
2994:
2995: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
2997: OE_MSG_PUB.Add;
2998:
2999: END IF;
3000:
3021:
3022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3023: THEN
3024:
3025: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
3027: OE_MSG_PUB.Add;
3028:
3029: END IF;
3022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3023: THEN
3024:
3025: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
3027: OE_MSG_PUB.Add;
3028:
3029: END IF;
3030:
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3053: THEN
3054:
3055: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
3057: OE_MSG_PUB.Add;
3058:
3059: END IF;
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3053: THEN
3054:
3055: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
3057: OE_MSG_PUB.Add;
3058:
3059: END IF;
3060:
3081:
3082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3083: THEN
3084:
3085: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
3087: OE_MSG_PUB.Add;
3088:
3089: END IF;
3082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3083: THEN
3084:
3085: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
3087: OE_MSG_PUB.Add;
3088:
3089: END IF;
3090:
3111:
3112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3113: THEN
3114:
3115: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3117: OE_MSG_PUB.Add;
3118:
3119: END IF;
3112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3113: THEN
3114:
3115: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3117: OE_MSG_PUB.Add;
3118:
3119: END IF;
3120:
3141:
3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3143: THEN
3144:
3145: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
3147: OE_MSG_PUB.Add;
3148:
3149: END IF;
3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3143: THEN
3144:
3145: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
3147: OE_MSG_PUB.Add;
3148:
3149: END IF;
3150:
3171:
3172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3173: THEN
3174:
3175: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
3177: OE_MSG_PUB.Add;
3178:
3179: END IF;
3172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3173: THEN
3174:
3175: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
3177: OE_MSG_PUB.Add;
3178:
3179: END IF;
3180:
3201:
3202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3203: THEN
3204:
3205: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
3207: OE_MSG_PUB.Add;
3208:
3209: END IF;
3202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3203: THEN
3204:
3205: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
3207: OE_MSG_PUB.Add;
3208:
3209: END IF;
3210:
3231:
3232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3233: THEN
3234:
3235: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
3237: OE_MSG_PUB.Add;
3238:
3239: END IF;
3232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3233: THEN
3234:
3235: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
3237: OE_MSG_PUB.Add;
3238:
3239: END IF;
3240: