DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on OE_MSG_PUB

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

436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: OE_MSG_PUB.Add_Exc_Msg
443: (G_PKG_NAME
444: ,'Create_Modifiers'

Line 442: OE_MSG_PUB.Add_Exc_Msg

438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: OE_MSG_PUB.Add_Exc_Msg
443: (G_PKG_NAME
444: ,'Create_Modifiers'
445: );
446: END IF;

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

517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: OE_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME
525: ,'Deactivate_Price_List'

Line 523: OE_MSG_PUB.Add_Exc_Msg

519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: OE_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME
525: ,'Deactivate_Price_List'
526: );
527: END IF;

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

612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: OE_MSG_PUB.Add_Exc_Msg
619: (G_PKG_NAME
620: ,'Deactivate_Modifier'

Line 618: OE_MSG_PUB.Add_Exc_Msg

614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: OE_MSG_PUB.Add_Exc_Msg
619: (G_PKG_NAME
620: ,'Deactivate_Modifier'
621: );
622: END IF;

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

729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: OE_MSG_PUB.Add_Exc_Msg
736: (G_PKG_NAME
737: ,'Deactivate_Pricing'

Line 735: OE_MSG_PUB.Add_Exc_Msg

731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: OE_MSG_PUB.Add_Exc_Msg
736: (G_PKG_NAME
737: ,'Deactivate_Pricing'
738: );
739: END IF;

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

779: WHEN OTHERS THEN
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add('other error :'||SQLERRM ) ;
782: END IF;
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: OE_MSG_PUB.Add_Exc_Msg
786: ( G_PKG_NAME
787: , 'Get_Blanket_Header_ID'

Line 785: OE_MSG_PUB.Add_Exc_Msg

781: oe_debug_pub.add('other error :'||SQLERRM ) ;
782: END IF;
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: OE_MSG_PUB.Add_Exc_Msg
786: ( G_PKG_NAME
787: , 'Get_Blanket_Header_ID'
788: );
789: END IF;

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

831: WHEN OTHERS THEN
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add('other error :'||SQLERRM ) ;
834: END IF;
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'Get_Blanket_Line_ID'

Line 837: OE_MSG_PUB.Add_Exc_Msg

833: oe_debug_pub.add('other error :'||SQLERRM ) ;
834: END IF;
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'Get_Blanket_Line_ID'
840: );
841: END IF;

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

880: oe_debug_pub.add('No data found in Get_List_Line_ID');
881: end if;
882: RETURN NULL;
883: WHEN OTHERS THEN
884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: OE_MSG_PUB.Add_Exc_Msg
887: ( G_PKG_NAME
888: , 'Get_List_Line_ID'

Line 886: OE_MSG_PUB.Add_Exc_Msg

882: RETURN NULL;
883: WHEN OTHERS THEN
884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: OE_MSG_PUB.Add_Exc_Msg
887: ( G_PKG_NAME
888: , 'Get_List_Line_ID'
889: );
890: END IF;

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

968: RETURN l_rel_amt;
969:
970: EXCEPTION
971: WHEN OTHERS THEN
972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
973: THEN
974: OE_MSG_PUB.Add_Exc_Msg
975: ( G_PKG_NAME
976: , 'Get_Blanket_Rel_Amt'

Line 974: OE_MSG_PUB.Add_Exc_Msg

970: EXCEPTION
971: WHEN OTHERS THEN
972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
973: THEN
974: OE_MSG_PUB.Add_Exc_Msg
975: ( G_PKG_NAME
976: , 'Get_Blanket_Rel_Amt'
977: );
978: END IF;

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

1051: RETURN l_rel_amt;
1052:
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: OE_MSG_PUB.Add_Exc_Msg
1058: ( G_PKG_NAME
1059: , 'Get_Bl_Line_Rel_Amt'

Line 1057: OE_MSG_PUB.Add_Exc_Msg

1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: OE_MSG_PUB.Add_Exc_Msg
1058: ( G_PKG_NAME
1059: , 'Get_Bl_Line_Rel_Amt'
1060: );
1061: END IF;

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

1136: WHEN OTHERS THEN
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add('other error :'||SQLERRM ) ;
1139: END IF;
1140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: OE_MSG_PUB.Add_Exc_Msg
1143: ( G_PKG_NAME
1144: , 'Get_Bl_Line_Rel_Qty'

Line 1142: OE_MSG_PUB.Add_Exc_Msg

1138: oe_debug_pub.add('other error :'||SQLERRM ) ;
1139: END IF;
1140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: OE_MSG_PUB.Add_Exc_Msg
1143: ( G_PKG_NAME
1144: , 'Get_Bl_Line_Rel_Qty'
1145: );
1146: END IF;