1040: return( converted_amount );
1041:
1042: EXCEPTION
1043: WHEN gl_currency_api.NO_RATE THEN
1044: FND_MESSAGE.SET_NAME('AR', 'OCM_NO_RATE');
1045: FND_MESSAGE.SET_TOKEN('CODE1', p_from_currency);
1046: FND_MESSAGE.SET_TOKEN('CODE2', p_to_currency);
1047: FND_MESSAGE.SET_TOKEN('DATE', p_conversion_date);
1048: FND_MESSAGE.SET_TOKEN('TYPE', p_conversion_type);
1041:
1042: EXCEPTION
1043: WHEN gl_currency_api.NO_RATE THEN
1044: FND_MESSAGE.SET_NAME('AR', 'OCM_NO_RATE');
1045: FND_MESSAGE.SET_TOKEN('CODE1', p_from_currency);
1046: FND_MESSAGE.SET_TOKEN('CODE2', p_to_currency);
1047: FND_MESSAGE.SET_TOKEN('DATE', p_conversion_date);
1048: FND_MESSAGE.SET_TOKEN('TYPE', p_conversion_type);
1049: fnd_msg_pub.add();
1042: EXCEPTION
1043: WHEN gl_currency_api.NO_RATE THEN
1044: FND_MESSAGE.SET_NAME('AR', 'OCM_NO_RATE');
1045: FND_MESSAGE.SET_TOKEN('CODE1', p_from_currency);
1046: FND_MESSAGE.SET_TOKEN('CODE2', p_to_currency);
1047: FND_MESSAGE.SET_TOKEN('DATE', p_conversion_date);
1048: FND_MESSAGE.SET_TOKEN('TYPE', p_conversion_type);
1049: fnd_msg_pub.add();
1050: raise;
1043: WHEN gl_currency_api.NO_RATE THEN
1044: FND_MESSAGE.SET_NAME('AR', 'OCM_NO_RATE');
1045: FND_MESSAGE.SET_TOKEN('CODE1', p_from_currency);
1046: FND_MESSAGE.SET_TOKEN('CODE2', p_to_currency);
1047: FND_MESSAGE.SET_TOKEN('DATE', p_conversion_date);
1048: FND_MESSAGE.SET_TOKEN('TYPE', p_conversion_type);
1049: fnd_msg_pub.add();
1050: raise;
1051:
1044: FND_MESSAGE.SET_NAME('AR', 'OCM_NO_RATE');
1045: FND_MESSAGE.SET_TOKEN('CODE1', p_from_currency);
1046: FND_MESSAGE.SET_TOKEN('CODE2', p_to_currency);
1047: FND_MESSAGE.SET_TOKEN('DATE', p_conversion_date);
1048: FND_MESSAGE.SET_TOKEN('TYPE', p_conversion_type);
1049: fnd_msg_pub.add();
1050: raise;
1051:
1052: WHEN gl_currency_api.INVALID_CURRENCY THEN
1049: fnd_msg_pub.add();
1050: raise;
1051:
1052: WHEN gl_currency_api.INVALID_CURRENCY THEN
1053: FND_MESSAGE.SET_NAME('AR', 'OCM_INVALID_CURRENCY');
1054: FND_MESSAGE.SET_TOKEN('CURRCODE', p_from_currency);
1055: fnd_msg_pub.add();
1056: raise;
1057:
1050: raise;
1051:
1052: WHEN gl_currency_api.INVALID_CURRENCY THEN
1053: FND_MESSAGE.SET_NAME('AR', 'OCM_INVALID_CURRENCY');
1054: FND_MESSAGE.SET_TOKEN('CURRCODE', p_from_currency);
1055: fnd_msg_pub.add();
1056: raise;
1057:
1058: WHEN NO_DATA_FOUND THEN
1055: fnd_msg_pub.add();
1056: raise;
1057:
1058: WHEN NO_DATA_FOUND THEN
1059: FND_MESSAGE.SET_NAME('AR', 'OCM_INVALID_CURRENCY');
1060: FND_MESSAGE.SET_TOKEN('CURRCODE', p_to_currency);
1061: fnd_msg_pub.add();
1062: raise;
1063: END convert_amount;
1056: raise;
1057:
1058: WHEN NO_DATA_FOUND THEN
1059: FND_MESSAGE.SET_NAME('AR', 'OCM_INVALID_CURRENCY');
1060: FND_MESSAGE.SET_TOKEN('CURRCODE', p_to_currency);
1061: fnd_msg_pub.add();
1062: raise;
1063: END convert_amount;
1064: