DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on OE_MSG_PUB

Line 1916: OE_MSG_PUB.Add;

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
1920:

Line 1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1917: RAISE FND_API.G_EXC_ERROR;
1918:
1919: WHEN OTHERS THEN
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1922: THEN
1923: OE_MSG_PUB.Add_Exc_Msg
1924: ( G_PKG_NAME
1925: , 'Update_Row'

Line 1923: OE_MSG_PUB.Add_Exc_Msg

1919: WHEN OTHERS THEN
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1922: THEN
1923: OE_MSG_PUB.Add_Exc_Msg
1924: ( G_PKG_NAME
1925: , 'Update_Row'
1926: );
1927: END IF;

Line 1941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1937: RAISE;
1938:
1939: WHEN OTHERS THEN
1940:
1941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1942: THEN
1943: OE_MSG_PUB.Add_Exc_Msg
1944: ( G_PKG_NAME
1945: , 'Update_Row'

Line 1943: OE_MSG_PUB.Add_Exc_Msg

1939: WHEN OTHERS THEN
1940:
1941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1942: THEN
1943: OE_MSG_PUB.Add_Exc_Msg
1944: ( G_PKG_NAME
1945: , 'Update_Row'
1946: );
1947: END IF;

Line 2007: OE_MSG_PUB.Add;

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
2011:

Line 2012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2008: RAISE FND_API.G_EXC_ERROR;
2009:
2010: WHEN OTHERS THEN
2011:
2012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2013: THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME
2016: , 'Insert_Row'

Line 2014: OE_MSG_PUB.Add_Exc_Msg

2010: WHEN OTHERS THEN
2011:
2012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2013: THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME
2016: , 'Insert_Row'
2017: );
2018: END IF;

Line 2184: OE_MSG_PUB.Add;

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
2188: oe_debug_pub.add('l_ret_sts else '||l_return_status);

Line 2190: OE_MSG_PUB.Add;

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:
2194:

Line 2208: OE_MSG_PUB.Count_And_Get

2204:
2205: /*
2206: -- Get message count and data
2207:
2208: OE_MSG_PUB.Count_And_Get
2209: ( p_count => x_msg_count
2210: , p_data => x_msg_data
2211: );
2212: */

Line 2214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2210: , p_data => x_msg_data
2211: );
2212: */
2213: /* Commented for Bug 2101393
2214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: OE_MSG_PUB.Add_Exc_Msg
2217: ( G_PKG_NAME
2218: , 'Insert_Row'

Line 2216: OE_MSG_PUB.Add_Exc_Msg

2212: */
2213: /* Commented for Bug 2101393
2214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: OE_MSG_PUB.Add_Exc_Msg
2217: ( G_PKG_NAME
2218: , 'Insert_Row'
2219: );
2220: END IF;

Line 2234: OE_MSG_PUB.Count_And_Get

2230:
2231: /*
2232: -- Get message count and data
2233:
2234: OE_MSG_PUB.Count_And_Get
2235: ( p_count => x_msg_count
2236: , p_data => x_msg_data
2237: );
2238: */

Line 2240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2236: , p_data => x_msg_data
2237: );
2238: */
2239:
2240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2241: THEN
2242: OE_MSG_PUB.Add_Exc_Msg
2243: ( G_PKG_NAME
2244: , 'Insert_Row'

Line 2242: OE_MSG_PUB.Add_Exc_Msg

2238: */
2239:
2240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2241: THEN
2242: OE_MSG_PUB.Add_Exc_Msg
2243: ( G_PKG_NAME
2244: , 'Insert_Row'
2245: );
2246: END IF;

Line 2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2249:
2250:
2251: WHEN OTHERS THEN
2252:
2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: THEN
2255: OE_MSG_PUB.Add_Exc_Msg
2256: ( G_PKG_NAME
2257: , 'Insert_Row'

Line 2255: OE_MSG_PUB.Add_Exc_Msg

2251: WHEN OTHERS THEN
2252:
2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: THEN
2255: OE_MSG_PUB.Add_Exc_Msg
2256: ( G_PKG_NAME
2257: , 'Insert_Row'
2258: );
2259: END IF;

Line 2309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2305: EXCEPTION
2306:
2307: WHEN OTHERS THEN
2308:
2309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2310: THEN
2311: OE_MSG_PUB.Add_Exc_Msg
2312: ( G_PKG_NAME
2313: , 'Delete_Row'

Line 2311: OE_MSG_PUB.Add_Exc_Msg

2307: WHEN OTHERS THEN
2308:
2309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2310: THEN
2311: OE_MSG_PUB.Add_Exc_Msg
2312: ( G_PKG_NAME
2313: , 'Delete_Row'
2314: );
2315: END IF;

Line 2469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2465: null;
2466:
2467: WHEN OTHERS THEN
2468:
2469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2470: THEN
2471: OE_MSG_PUB.Add_Exc_Msg
2472: ( G_PKG_NAME
2473: , 'Query_Row'

Line 2471: OE_MSG_PUB.Add_Exc_Msg

2467: WHEN OTHERS THEN
2468:
2469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2470: THEN
2471: OE_MSG_PUB.Add_Exc_Msg
2472: ( G_PKG_NAME
2473: , 'Query_Row'
2474: );
2475: END IF;

Line 2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2803: --end debug messages added as per 8594682 for oe_lock_row error
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2811: OE_MSG_PUB.Add;

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:
2815: END IF;

Line 2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2821:
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2829: OE_MSG_PUB.Add;

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
2833:

Line 2837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2833:
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2841: OE_MSG_PUB.Add;

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
2845:

Line 2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2845:
2846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2847: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2848:
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2850: THEN
2851: OE_MSG_PUB.Add_Exc_Msg
2852: ( G_PKG_NAME
2853: , 'Lock_Row'

Line 2851: OE_MSG_PUB.Add_Exc_Msg

2847: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2848:
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2850: THEN
2851: OE_MSG_PUB.Add_Exc_Msg
2852: ( G_PKG_NAME
2853: , 'Lock_Row'
2854: );
2855: END IF;

Line 2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2988: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2989:
2990: l_MODIFIER_LIST_rec.automatic_flag := p_MODIFIER_LIST_rec.automatic_flag;
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');

Line 2997: OE_MSG_PUB.Add;

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:
3001: ELSE

Line 3022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3018: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
3019:
3020: l_MODIFIER_LIST_rec.currency_code := p_MODIFIER_LIST_rec.currency_code;
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');

Line 3027: OE_MSG_PUB.Add;

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:
3031: ELSE

Line 3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3048: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
3049:
3050: l_MODIFIER_LIST_rec.discount_lines_flag := p_MODIFIER_LIST_rec.discount_lines_flag;
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');

Line 3057: OE_MSG_PUB.Add;

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:
3061: ELSE

Line 3082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3078: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
3079:
3080: l_MODIFIER_LIST_rec.freight_terms_code := p_MODIFIER_LIST_rec.freight_terms_code;
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');

Line 3087: OE_MSG_PUB.Add;

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:
3091: ELSE

Line 3112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3108: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3109:
3110: l_MODIFIER_LIST_rec.list_header_id := p_MODIFIER_LIST_rec.list_header_id;
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');

Line 3117: OE_MSG_PUB.Add;

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:
3121: ELSE

Line 3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3138: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
3139:
3140: l_MODIFIER_LIST_rec.list_type_code := p_MODIFIER_LIST_rec.list_type_code;
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');

Line 3147: OE_MSG_PUB.Add;

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:
3151: ELSE

Line 3172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3168: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
3169:
3170: l_MODIFIER_LIST_rec.prorate_flag := p_MODIFIER_LIST_rec.prorate_flag;
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');

Line 3177: OE_MSG_PUB.Add;

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:
3181: ELSE

Line 3202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3198: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
3199:
3200: l_MODIFIER_LIST_rec.ship_method_code := p_MODIFIER_LIST_rec.ship_method_code;
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');

Line 3207: OE_MSG_PUB.Add;

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:
3211: ELSE

Line 3232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3228: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
3229:
3230: l_MODIFIER_LIST_rec.terms_id := p_MODIFIER_LIST_rec.terms_id;
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');

Line 3237: OE_MSG_PUB.Add;

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:
3241: ELSE

Line 3351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3347: WHEN FND_API.G_EXC_ERROR THEN
3348: return(null);
3349:
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3352: OE_MSG_PUB.Add_Exc_Msg
3353: (G_PKG_NAME
3354: ,'Get_Segment_Level_for_Group');
3355: END IF;

Line 3352: OE_MSG_PUB.Add_Exc_Msg

3348: return(null);
3349:
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3352: OE_MSG_PUB.Add_Exc_Msg
3353: (G_PKG_NAME
3354: ,'Get_Segment_Level_for_Group');
3355: END IF;
3356: return(null);

Line 3359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3355: END IF;
3356: return(null);
3357:
3358: WHEN OTHERS THEN
3359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3360: OE_MSG_PUB.Add_Exc_Msg
3361: (G_PKG_NAME
3362: ,'Get_Segment_Level_for_Group');
3363: END IF;

Line 3360: OE_MSG_PUB.Add_Exc_Msg

3356: return(null);
3357:
3358: WHEN OTHERS THEN
3359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3360: OE_MSG_PUB.Add_Exc_Msg
3361: (G_PKG_NAME
3362: ,'Get_Segment_Level_for_Group');
3363: END IF;
3364: return(null);