310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
312: END IF;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');
318: END IF;
312: END IF;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');
318: END IF;
319:
320:
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;
519: END IF;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');
525: END IF;
519: END IF;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');
525: END IF;
526:
527: End Raise_Event_Showso;
694: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;
695: END IF;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
697:
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: FND_MSG_PUB.Add_Exc_Msg
701: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
702: END IF;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
697:
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: FND_MSG_PUB.Add_Exc_Msg
701: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
702: END IF;
703:
704:
740: END IF;
741: return 0;
742: EXCEPTION
743: WHEN OTHERS THEN
744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
745: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'get_line_index');
746: END IF;
747: END Get_Line_Index;
748:
741: return 0;
742: EXCEPTION
743: WHEN OTHERS THEN
744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
745: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'get_line_index');
746: END IF;
747: END Get_Line_Index;
748:
749: -- {Start of procedure Insert_Header
797: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;
798: END IF;
799: EXCEPTION
800: WHEN OTHERS THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
802: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_header');
803: END IF;
804: END Insert_Header;
805: -- End of procedure Insert_Header }
798: END IF;
799: EXCEPTION
800: WHEN OTHERS THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
802: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_header');
803: END IF;
804: END Insert_Header;
805: -- End of procedure Insert_Header }
806:
846: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;
847: END IF;
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
851: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_line');
852: END IF;
853: END Insert_Line;
854: -- End of procedure Insert_Line }
847: END IF;
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
851: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_line');
852: END IF;
853: END Insert_Line;
854: -- End of procedure Insert_Line }
855:
1065: WHEN OTHERS THEN
1066: IF l_debug_level > 0 THEN
1067: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1068: END IF;
1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1071: END IF;
1072: END Query_Inf_Records;
1073: -- End of procedure Query Interface Records }
1066: IF l_debug_level > 0 THEN
1067: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1068: END IF;
1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1071: END IF;
1072: END Query_Inf_Records;
1073: -- End of procedure Query Interface Records }
1074:
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3693: THEN
3694: FND_MSG_PUB.Add_Exc_Msg
3695: ( G_PKG_NAME
3696: , 'Apply_3A7_Hold'
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3693: THEN
3694: FND_MSG_PUB.Add_Exc_Msg
3695: ( G_PKG_NAME
3696: , 'Apply_3A7_Hold'
3697: );
3698: END IF;
3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN
3820: FND_MSG_PUB.Add_Exc_Msg
3821: ( G_PKG_NAME
3822: , 'Release_3A7_Hold'
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN
3820: FND_MSG_PUB.Add_Exc_Msg
3821: ( G_PKG_NAME
3822: , 'Release_3A7_Hold'
3823: );
3824: END IF;
3939: IF l_debug_level > 0 THEN
3940: oe_debug_pub.add('In when others exception - Process_3A8');
3941: END IF;
3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg
3946: ( G_PKG_NAME
3947: , 'Process_3A8'
3941: END IF;
3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg
3946: ( G_PKG_NAME
3947: , 'Process_3A8'
3948: );
3949: END IF;