1085: IF get_rate_info_csr%NOTFOUND THEN
1086: p_return_status := FND_API.G_RET_STS_ERROR;
1087:
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1086: p_return_status := FND_API.G_RET_STS_ERROR;
1087:
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1094: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1087:
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1094: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1095: ZX_API_PUB.add_msg(
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1094: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1095: ZX_API_PUB.add_msg(
1096: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1094: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1095: ZX_API_PUB.add_msg(
1096: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1097: ELSE
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1178: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1180: ZX_API_PUB.add_msg(
1181: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1182: ELSE
1313: EXCEPTION
1314: WHEN ZERO_DIVIDE THEN
1315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: p_error_buffer := 'Minimum Accountable Unit can not be 0';
1317: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1318: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','round_tax- '|| p_error_buffer);
1319: FND_MSG_PUB.Add;
1320: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1321: FND_LOG.STRING(g_level_unexpected,
1314: WHEN ZERO_DIVIDE THEN
1315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: p_error_buffer := 'Minimum Accountable Unit can not be 0';
1317: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1318: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','round_tax- '|| p_error_buffer);
1319: FND_MSG_PUB.Add;
1320: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1321: FND_LOG.STRING(g_level_unexpected,
1322: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.round_tax',
5502: -- Bug#5506495- quantity based tax, raise error
5503: --
5504: p_return_status := FND_API.G_RET_STS_ERROR;
5505:
5506: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5507: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5508: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5509: ZX_API_PUB.add_msg(
5510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5503: --
5504: p_return_status := FND_API.G_RET_STS_ERROR;
5505:
5506: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5507: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5508: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5509: ZX_API_PUB.add_msg(
5510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5511: ELSE
5520: -- Bug#5506495- quantity based tax, raise error
5521: --
5522: p_return_status := FND_API.G_RET_STS_ERROR;
5523:
5524: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5525: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5526: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5527: ZX_API_PUB.add_msg(
5528: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5521: --
5522: p_return_status := FND_API.G_RET_STS_ERROR;
5523:
5524: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5525: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5526: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5527: ZX_API_PUB.add_msg(
5528: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5529: ELSE
7715: WHEN OTHERS THEN
7716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7717: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7718:
7719: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
7720: FND_MSG_PUB.Add;
7721:
7722: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7723: FND_LOG.STRING(g_level_unexpected,