769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Update_Booked_Flag'
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: IF FND_MSG_PUB.Check_Msg_Level
816: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME
812: EXCEPTION
813: WHEN OTHERS THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: IF FND_MSG_PUB.Check_Msg_Level
816: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME
820: , 'Verify_Payment_AT_Booking'
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: IF FND_MSG_PUB.Check_Msg_Level
932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
933: THEN
934: OE_MSG_PUB.Add_Exc_Msg
935: ( G_PKG_NAME
928: EXCEPTION
929: WHEN OTHERS THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: IF FND_MSG_PUB.Check_Msg_Level
932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
933: THEN
934: OE_MSG_PUB.Add_Exc_Msg
935: ( G_PKG_NAME
936: , 'Validate_Sales_Credits'
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level
1044: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level
1044: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME
1048: , 'Check_Booking_Holds'
1353: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1357: IF FND_MSG_PUB.Check_Msg_Level
1358: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1359: THEN
1360: OE_MSG_PUB.Add_Exc_Msg
1361: ( G_PKG_NAME
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1357: IF FND_MSG_PUB.Check_Msg_Level
1358: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1359: THEN
1360: OE_MSG_PUB.Add_Exc_Msg
1361: ( G_PKG_NAME
1362: , l_api_name