135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: OE_MSG_PUB.Add_Exc_Msg
142: ( G_PKG_NAME
143: , 'NOTIFY_OTA'
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: OE_MSG_PUB.Add_Exc_Msg
142: ( G_PKG_NAME
143: , 'NOTIFY_OTA'
144: );
145: END IF;
622: EXCEPTION
623:
624: WHEN OTHERS THEN
625:
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: OE_MSG_PUB.Add_Exc_Msg
629: ( G_PKG_NAME
630: , 'Get_OTA_Event_End_Date'
624: WHEN OTHERS THEN
625:
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: OE_MSG_PUB.Add_Exc_Msg
629: ( G_PKG_NAME
630: , 'Get_OTA_Event_End_Date'
631: );
632: END IF;