835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: WHEN OTHERS THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level
840: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
841: THEN
842: OE_MSG_PUB.Add_Exc_Msg
843: ( G_PKG_NAME
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: WHEN OTHERS THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level
840: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
841: THEN
842: OE_MSG_PUB.Add_Exc_Msg
843: ( G_PKG_NAME
844: , 'Update_Booked_Flag'
877:
878: EXCEPTION
879: WHEN OTHERS THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: IF FND_MSG_PUB.Check_Msg_Level
882: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
878: EXCEPTION
879: WHEN OTHERS THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: IF FND_MSG_PUB.Check_Msg_Level
882: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Verify_Payment_AT_Booking'
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level
998: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
999: THEN
1000: OE_MSG_PUB.Add_Exc_Msg
1001: ( G_PKG_NAME
994: EXCEPTION
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level
998: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
999: THEN
1000: OE_MSG_PUB.Add_Exc_Msg
1001: ( G_PKG_NAME
1002: , 'Validate_Sales_Credits'
1105:
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level
1110: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level
1110: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME
1114: , 'Check_Booking_Holds'
1435: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , l_api_name