415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN
421: OE_MSG_PUB.Add_Exc_Msg
422: (G_PKG_NAME
423: ,'Create_Modifiers'
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN
421: OE_MSG_PUB.Add_Exc_Msg
422: (G_PKG_NAME
423: ,'Create_Modifiers'
424: );
425: END IF;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN
502: OE_MSG_PUB.Add_Exc_Msg
503: (G_PKG_NAME
504: ,'Deactivate_Price_List'
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN
502: OE_MSG_PUB.Add_Exc_Msg
503: (G_PKG_NAME
504: ,'Deactivate_Price_List'
505: );
506: END IF;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: OE_MSG_PUB.Add_Exc_Msg
598: (G_PKG_NAME
599: ,'Deactivate_Modifier'
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: OE_MSG_PUB.Add_Exc_Msg
598: (G_PKG_NAME
599: ,'Deactivate_Modifier'
600: );
601: END IF;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: OE_MSG_PUB.Add_Exc_Msg
715: (G_PKG_NAME
716: ,'Deactivate_Pricing'
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: OE_MSG_PUB.Add_Exc_Msg
715: (G_PKG_NAME
716: ,'Deactivate_Pricing'
717: );
718: END IF;
758: WHEN OTHERS THEN
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add('other error :'||SQLERRM ) ;
761: END IF;
762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME
766: , 'Get_Blanket_Header_ID'
760: oe_debug_pub.add('other error :'||SQLERRM ) ;
761: END IF;
762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME
766: , 'Get_Blanket_Header_ID'
767: );
768: END IF;
810: WHEN OTHERS THEN
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add('other error :'||SQLERRM ) ;
813: END IF;
814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: OE_MSG_PUB.Add_Exc_Msg
817: ( G_PKG_NAME
818: , 'Get_Blanket_Line_ID'
812: oe_debug_pub.add('other error :'||SQLERRM ) ;
813: END IF;
814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: OE_MSG_PUB.Add_Exc_Msg
817: ( G_PKG_NAME
818: , 'Get_Blanket_Line_ID'
819: );
820: END IF;
859: oe_debug_pub.add('No data found in Get_List_Line_ID');
860: end if;
861: RETURN NULL;
862: WHEN OTHERS THEN
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME
867: , 'Get_List_Line_ID'
861: RETURN NULL;
862: WHEN OTHERS THEN
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME
867: , 'Get_List_Line_ID'
868: );
869: END IF;
945: RETURN l_rel_amt;
946:
947: EXCEPTION
948: WHEN OTHERS THEN
949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: OE_MSG_PUB.Add_Exc_Msg
952: ( G_PKG_NAME
953: , 'Get_Blanket_Rel_Amt'
947: EXCEPTION
948: WHEN OTHERS THEN
949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: OE_MSG_PUB.Add_Exc_Msg
952: ( G_PKG_NAME
953: , 'Get_Blanket_Rel_Amt'
954: );
955: END IF;
1026: RETURN l_rel_amt;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1031: THEN
1032: OE_MSG_PUB.Add_Exc_Msg
1033: ( G_PKG_NAME
1034: , 'Get_Bl_Line_Rel_Amt'
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1031: THEN
1032: OE_MSG_PUB.Add_Exc_Msg
1033: ( G_PKG_NAME
1034: , 'Get_Bl_Line_Rel_Amt'
1035: );
1036: END IF;
1109: WHEN OTHERS THEN
1110: IF l_debug_level > 0 THEN
1111: oe_debug_pub.add('other error :'||SQLERRM ) ;
1112: END IF;
1113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1114: THEN
1115: OE_MSG_PUB.Add_Exc_Msg
1116: ( G_PKG_NAME
1117: , 'Get_Bl_Line_Rel_Qty'
1111: oe_debug_pub.add('other error :'||SQLERRM ) ;
1112: END IF;
1113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1114: THEN
1115: OE_MSG_PUB.Add_Exc_Msg
1116: ( G_PKG_NAME
1117: , 'Get_Bl_Line_Rel_Qty'
1118: );
1119: END IF;