DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on OE_MSG_PUB

Line 1685: OE_MSG_PUB.Add;

1681: Exception
1682: WHEN DUP_VAL_ON_INDEX THEN
1683:
1684: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1685: OE_MSG_PUB.Add;
1686: RAISE FND_API.G_EXC_ERROR;
1687:
1688: WHEN OTHERS THEN
1689:

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

1686: RAISE FND_API.G_EXC_ERROR;
1687:
1688: WHEN OTHERS THEN
1689:
1690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1691: THEN
1692: OE_MSG_PUB.Add_Exc_Msg
1693: ( G_PKG_NAME
1694: , 'Update_Row'

Line 1692: OE_MSG_PUB.Add_Exc_Msg

1688: WHEN OTHERS THEN
1689:
1690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1691: THEN
1692: OE_MSG_PUB.Add_Exc_Msg
1693: ( G_PKG_NAME
1694: , 'Update_Row'
1695: );
1696: END IF;

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

1706: RAISE;
1707:
1708: WHEN OTHERS THEN
1709:
1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1711: THEN
1712: OE_MSG_PUB.Add_Exc_Msg
1713: ( G_PKG_NAME
1714: , 'Update_Row'

Line 1712: OE_MSG_PUB.Add_Exc_Msg

1708: WHEN OTHERS THEN
1709:
1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1711: THEN
1712: OE_MSG_PUB.Add_Exc_Msg
1713: ( G_PKG_NAME
1714: , 'Update_Row'
1715: );
1716: END IF;

Line 1776: OE_MSG_PUB.Add;

1772: Exception
1773: WHEN DUP_VAL_ON_INDEX THEN
1774:
1775: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1776: OE_MSG_PUB.Add;
1777: RAISE FND_API.G_EXC_ERROR;
1778:
1779: WHEN OTHERS THEN
1780:

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

1777: RAISE FND_API.G_EXC_ERROR;
1778:
1779: WHEN OTHERS THEN
1780:
1781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1782: THEN
1783: OE_MSG_PUB.Add_Exc_Msg
1784: ( G_PKG_NAME
1785: , 'Insert_Row'

Line 1783: OE_MSG_PUB.Add_Exc_Msg

1779: WHEN OTHERS THEN
1780:
1781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1782: THEN
1783: OE_MSG_PUB.Add_Exc_Msg
1784: ( G_PKG_NAME
1785: , 'Insert_Row'
1786: );
1787: END IF;

Line 1953: OE_MSG_PUB.Add;

1949:
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);
1952: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1953: OE_MSG_PUB.Add;
1954:
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);

Line 1959: OE_MSG_PUB.Add;

1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);
1958: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1959: OE_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END IF;
1962:
1963:

Line 1977: OE_MSG_PUB.Count_And_Get

1973:
1974: /*
1975: -- Get message count and data
1976:
1977: OE_MSG_PUB.Count_And_Get
1978: ( p_count => x_msg_count
1979: , p_data => x_msg_data
1980: );
1981: */

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

1979: , p_data => x_msg_data
1980: );
1981: */
1982: /* Commented for Bug 2101393
1983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: OE_MSG_PUB.Add_Exc_Msg
1986: ( G_PKG_NAME
1987: , 'Insert_Row'

Line 1985: OE_MSG_PUB.Add_Exc_Msg

1981: */
1982: /* Commented for Bug 2101393
1983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: OE_MSG_PUB.Add_Exc_Msg
1986: ( G_PKG_NAME
1987: , 'Insert_Row'
1988: );
1989: END IF;

Line 2003: OE_MSG_PUB.Count_And_Get

1999:
2000: /*
2001: -- Get message count and data
2002:
2003: OE_MSG_PUB.Count_And_Get
2004: ( p_count => x_msg_count
2005: , p_data => x_msg_data
2006: );
2007: */

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

2005: , p_data => x_msg_data
2006: );
2007: */
2008:
2009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2010: THEN
2011: OE_MSG_PUB.Add_Exc_Msg
2012: ( G_PKG_NAME
2013: , 'Insert_Row'

Line 2011: OE_MSG_PUB.Add_Exc_Msg

2007: */
2008:
2009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2010: THEN
2011: OE_MSG_PUB.Add_Exc_Msg
2012: ( G_PKG_NAME
2013: , 'Insert_Row'
2014: );
2015: END IF;

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

2018:
2019:
2020: WHEN OTHERS THEN
2021:
2022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2023: THEN
2024: OE_MSG_PUB.Add_Exc_Msg
2025: ( G_PKG_NAME
2026: , 'Insert_Row'

Line 2024: OE_MSG_PUB.Add_Exc_Msg

2020: WHEN OTHERS THEN
2021:
2022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2023: THEN
2024: OE_MSG_PUB.Add_Exc_Msg
2025: ( G_PKG_NAME
2026: , 'Insert_Row'
2027: );
2028: END IF;

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

2074: EXCEPTION
2075:
2076: WHEN OTHERS THEN
2077:
2078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: OE_MSG_PUB.Add_Exc_Msg
2081: ( G_PKG_NAME
2082: , 'Delete_Row'

Line 2080: OE_MSG_PUB.Add_Exc_Msg

2076: WHEN OTHERS THEN
2077:
2078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: OE_MSG_PUB.Add_Exc_Msg
2081: ( G_PKG_NAME
2082: , 'Delete_Row'
2083: );
2084: END IF;

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

2234: null;
2235:
2236: WHEN OTHERS THEN
2237:
2238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2239: THEN
2240: OE_MSG_PUB.Add_Exc_Msg
2241: ( G_PKG_NAME
2242: , 'Query_Row'

Line 2240: OE_MSG_PUB.Add_Exc_Msg

2236: WHEN OTHERS THEN
2237:
2238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2239: THEN
2240: OE_MSG_PUB.Add_Exc_Msg
2241: ( G_PKG_NAME
2242: , 'Query_Row'
2243: );
2244: END IF;

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

2515:
2516: x_return_status := FND_API.G_RET_STS_ERROR;
2517: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2518:
2519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2520: THEN
2521:
2522: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2523: OE_MSG_PUB.Add;

Line 2523: OE_MSG_PUB.Add;

2519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2520: THEN
2521:
2522: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2523: OE_MSG_PUB.Add;
2524:
2525: END IF;
2526:
2527: END IF;

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

2533:
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2536:
2537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2538: THEN
2539:
2540: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2541: OE_MSG_PUB.Add;

Line 2541: OE_MSG_PUB.Add;

2537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2538: THEN
2539:
2540: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2541: OE_MSG_PUB.Add;
2542:
2543: END IF;
2544: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2545:

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

2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2548:
2549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2550: THEN
2551:
2552: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2553: OE_MSG_PUB.Add;

Line 2553: OE_MSG_PUB.Add;

2549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2550: THEN
2551:
2552: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2553: OE_MSG_PUB.Add;
2554:
2555: END IF;
2556: WHEN OTHERS THEN
2557:

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

2557:
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560:
2561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2562: THEN
2563: OE_MSG_PUB.Add_Exc_Msg
2564: ( G_PKG_NAME
2565: , 'Lock_Row'

Line 2563: OE_MSG_PUB.Add_Exc_Msg

2559: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560:
2561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2562: THEN
2563: OE_MSG_PUB.Add_Exc_Msg
2564: ( G_PKG_NAME
2565: , 'Lock_Row'
2566: );
2567: END IF;

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

2700: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2701:
2702: l_MODIFIER_LIST_rec.automatic_flag := p_MODIFIER_LIST_rec.automatic_flag;
2703:
2704: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2705: THEN
2706:
2707: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 2709: OE_MSG_PUB.Add;

2705: THEN
2706:
2707: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
2709: OE_MSG_PUB.Add;
2710:
2711: END IF;
2712:
2713: ELSE

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

2730: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2731:
2732: l_MODIFIER_LIST_rec.currency_code := p_MODIFIER_LIST_rec.currency_code;
2733:
2734: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2735: THEN
2736:
2737: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2738: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');

Line 2739: OE_MSG_PUB.Add;

2735: THEN
2736:
2737: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2738: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2739: OE_MSG_PUB.Add;
2740:
2741: END IF;
2742:
2743: ELSE

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

2760: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2761:
2762: l_MODIFIER_LIST_rec.discount_lines_flag := p_MODIFIER_LIST_rec.discount_lines_flag;
2763:
2764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2765: THEN
2766:
2767: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2768: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');

Line 2769: OE_MSG_PUB.Add;

2765: THEN
2766:
2767: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2768: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
2769: OE_MSG_PUB.Add;
2770:
2771: END IF;
2772:
2773: ELSE

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

2790: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2791:
2792: l_MODIFIER_LIST_rec.freight_terms_code := p_MODIFIER_LIST_rec.freight_terms_code;
2793:
2794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2795: THEN
2796:
2797: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 2799: OE_MSG_PUB.Add;

2795: THEN
2796:
2797: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
2799: OE_MSG_PUB.Add;
2800:
2801: END IF;
2802:
2803: ELSE

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

2820: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2821:
2822: l_MODIFIER_LIST_rec.list_header_id := p_MODIFIER_LIST_rec.list_header_id;
2823:
2824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2825: THEN
2826:
2827: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 2829: OE_MSG_PUB.Add;

2825: THEN
2826:
2827: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2829: OE_MSG_PUB.Add;
2830:
2831: END IF;
2832:
2833: ELSE

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

2850: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2851:
2852: l_MODIFIER_LIST_rec.list_type_code := p_MODIFIER_LIST_rec.list_type_code;
2853:
2854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2855: THEN
2856:
2857: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');

Line 2859: OE_MSG_PUB.Add;

2855: THEN
2856:
2857: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
2859: OE_MSG_PUB.Add;
2860:
2861: END IF;
2862:
2863: ELSE

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

2880: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2881:
2882: l_MODIFIER_LIST_rec.prorate_flag := p_MODIFIER_LIST_rec.prorate_flag;
2883:
2884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2885: THEN
2886:
2887: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');

Line 2889: OE_MSG_PUB.Add;

2885: THEN
2886:
2887: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
2889: OE_MSG_PUB.Add;
2890:
2891: END IF;
2892:
2893: ELSE

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

2910: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2911:
2912: l_MODIFIER_LIST_rec.ship_method_code := p_MODIFIER_LIST_rec.ship_method_code;
2913:
2914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2915: THEN
2916:
2917: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2918: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 2919: OE_MSG_PUB.Add;

2915: THEN
2916:
2917: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2918: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
2919: OE_MSG_PUB.Add;
2920:
2921: END IF;
2922:
2923: ELSE

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

2940: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2941:
2942: l_MODIFIER_LIST_rec.terms_id := p_MODIFIER_LIST_rec.terms_id;
2943:
2944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2945: THEN
2946:
2947: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');

Line 2949: OE_MSG_PUB.Add;

2945: THEN
2946:
2947: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
2949: OE_MSG_PUB.Add;
2950:
2951: END IF;
2952:
2953: ELSE

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

3059: WHEN FND_API.G_EXC_ERROR THEN
3060: return(null);
3061:
3062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: OE_MSG_PUB.Add_Exc_Msg
3065: (G_PKG_NAME
3066: ,'Get_Segment_Level_for_Group');
3067: END IF;

Line 3064: OE_MSG_PUB.Add_Exc_Msg

3060: return(null);
3061:
3062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: OE_MSG_PUB.Add_Exc_Msg
3065: (G_PKG_NAME
3066: ,'Get_Segment_Level_for_Group');
3067: END IF;
3068: return(null);

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

3067: END IF;
3068: return(null);
3069:
3070: WHEN OTHERS THEN
3071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3072: OE_MSG_PUB.Add_Exc_Msg
3073: (G_PKG_NAME
3074: ,'Get_Segment_Level_for_Group');
3075: END IF;

Line 3072: OE_MSG_PUB.Add_Exc_Msg

3068: return(null);
3069:
3070: WHEN OTHERS THEN
3071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3072: OE_MSG_PUB.Add_Exc_Msg
3073: (G_PKG_NAME
3074: ,'Get_Segment_Level_for_Group');
3075: END IF;
3076: return(null);