305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
307: END IF;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');
313: END IF;
307: END IF;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');
313: END IF;
314:
315:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');
520: END IF;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');
520: END IF;
521:
522: End Raise_Event_Showso;
689: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;
690: END IF;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692:
693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg
696: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
697: END IF;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692:
693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg
696: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
697: END IF;
698:
699:
735: END IF;
736: return 0;
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
740: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'get_line_index');
741: END IF;
742: END Get_Line_Index;
743:
736: return 0;
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
740: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'get_line_index');
741: END IF;
742: END Get_Line_Index;
743:
744: -- {Start of procedure Insert_Header
792: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;
793: END IF;
794: EXCEPTION
795: WHEN OTHERS THEN
796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
797: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_header');
798: END IF;
799: END Insert_Header;
800: -- End of procedure Insert_Header }
793: END IF;
794: EXCEPTION
795: WHEN OTHERS THEN
796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
797: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_header');
798: END IF;
799: END Insert_Header;
800: -- End of procedure Insert_Header }
801:
841: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;
842: END IF;
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_line');
847: END IF;
848: END Insert_Line;
849: -- End of procedure Insert_Line }
842: END IF;
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'insert_line');
847: END IF;
848: END Insert_Line;
849: -- End of procedure Insert_Line }
850:
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1063: END IF;
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1065: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1066: END IF;
1067: END Query_Inf_Records;
1068: -- End of procedure Query Interface Records }
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1063: END IF;
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1065: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1066: END IF;
1067: END Query_Inf_Records;
1068: -- End of procedure Query Interface Records }
1069:
3572: IF l_debug_level > 0 THEN
3573: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3574: END IF;
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN
3578: FND_MSG_PUB.Add_Exc_Msg
3579: ( G_PKG_NAME
3580: , 'Apply_3A7_Hold'
3574: END IF;
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN
3578: FND_MSG_PUB.Add_Exc_Msg
3579: ( G_PKG_NAME
3580: , 'Apply_3A7_Hold'
3581: );
3582: END IF;
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: FND_MSG_PUB.Add_Exc_Msg
3705: ( G_PKG_NAME
3706: , 'Release_3A7_Hold'
3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: FND_MSG_PUB.Add_Exc_Msg
3705: ( G_PKG_NAME
3706: , 'Release_3A7_Hold'
3707: );
3708: END IF;
3823: IF l_debug_level > 0 THEN
3824: oe_debug_pub.add('In when others exception - Process_3A8');
3825: END IF;
3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: FND_MSG_PUB.Add_Exc_Msg
3830: ( G_PKG_NAME
3831: , 'Process_3A8'
3825: END IF;
3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: FND_MSG_PUB.Add_Exc_Msg
3830: ( G_PKG_NAME
3831: , 'Process_3A8'
3832: );
3833: END IF;