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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;