29: l_exchange_rate_type);
30: EXCEPTION
31: WHEN OTHERS
32: THEN
33: FND_MSG_PUB.ADD;
34:
35: IF FND_MSG_PUB.Check_Msg_Level
36: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
37: THEN
31: WHEN OTHERS
32: THEN
33: FND_MSG_PUB.ADD;
34:
35: IF FND_MSG_PUB.Check_Msg_Level
36: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
37: THEN
38: FND_MSG_PUB.Add_Exc_Msg
39: ( 'FUN_WF_AUTHORIZATION_LIMIT',
32: THEN
33: FND_MSG_PUB.ADD;
34:
35: IF FND_MSG_PUB.Check_Msg_Level
36: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
37: THEN
38: FND_MSG_PUB.Add_Exc_Msg
39: ( 'FUN_WF_AUTHORIZATION_LIMIT',
40: 'get_converted_amount'
34:
35: IF FND_MSG_PUB.Check_Msg_Level
36: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
37: THEN
38: FND_MSG_PUB.Add_Exc_Msg
39: ( 'FUN_WF_AUTHORIZATION_LIMIT',
40: 'get_converted_amount'
41: );
42: END IF;
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: l_rate := get_conv_rate(p_trx_id);
219: IF l_rate = -1 THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
222: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
223: FND_MSG_PUB.Add;
224: END IF;
225: END IF;
219: IF l_rate = -1 THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
222: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
223: FND_MSG_PUB.Add;
224: END IF;
225: END IF;
226:
227: EXCEPTION