257: THEN
258: -- raise error for multiple rate retrieved for the same jurisdiction code
259: x_return_status:= FND_API.G_RET_STS_ERROR;
260:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
264: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
265: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
258: -- raise error for multiple rate retrieved for the same jurisdiction code
259: x_return_status:= FND_API.G_RET_STS_ERROR;
260:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
264: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
265: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
266:
259: x_return_status:= FND_API.G_RET_STS_ERROR;
260:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
264: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
265: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
266:
267: CLOSE get_tax_rate_csr;
260:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
264: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
265: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
266:
267: CLOSE get_tax_rate_csr;
268:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
264: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
265: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
266:
267: CLOSE get_tax_rate_csr;
268:
269: IF (g_level_unexpected >= g_current_runtime_level ) THEN
314: THEN
315: -- raise error for multiple rate retrieved for the same jurisdiction code
316: x_return_status:= FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
315: -- raise error for multiple rate retrieved for the same jurisdiction code
316: x_return_status:= FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
323:
316: x_return_status:= FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
323:
324: CLOSE get_tax_rate_mig_csr;
317:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
323:
324: CLOSE get_tax_rate_mig_csr;
325:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
323:
324: CLOSE get_tax_rate_mig_csr;
325:
326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
512: THEN
513: -- raise error for multiple rate retrieved for the same jurisdiction code
514: x_return_status:= FND_API.G_RET_STS_ERROR;
515:
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
513: -- raise error for multiple rate retrieved for the same jurisdiction code
514: x_return_status:= FND_API.G_RET_STS_ERROR;
515:
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
521: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
514: x_return_status:= FND_API.G_RET_STS_ERROR;
515:
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
521: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
522:
515:
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
521: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
522:
523: CLOSE get_def_tax_rate_csr;
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
521: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
522:
523: CLOSE get_def_tax_rate_csr;
524:
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
519: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
520: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
521: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
522:
523: CLOSE get_def_tax_rate_csr;
524:
525: IF (g_level_unexpected >= g_current_runtime_level ) THEN
567: THEN
568: -- raise error for multiple rate retrieved for the same jurisdiction code
569: x_return_status:= FND_API.G_RET_STS_ERROR;
570:
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
568: -- raise error for multiple rate retrieved for the same jurisdiction code
569: x_return_status:= FND_API.G_RET_STS_ERROR;
570:
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
576: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
569: x_return_status:= FND_API.G_RET_STS_ERROR;
570:
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
576: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
577:
570:
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
576: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
577:
578: CLOSE get_def_tax_rate_mig_csr;
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
576: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
577:
578: CLOSE get_def_tax_rate_mig_csr;
579:
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
574: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
575: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
576: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
577:
578: CLOSE get_def_tax_rate_mig_csr;
579:
580: IF (g_level_unexpected >= g_current_runtime_level ) THEN
765: IF get_tax_rate_csr%FOUND THEN
766: -- raise error for multiple rate retrieved
767: x_return_status:= FND_API.G_RET_STS_ERROR;
768:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
772: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
773: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
766: -- raise error for multiple rate retrieved
767: x_return_status:= FND_API.G_RET_STS_ERROR;
768:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
772: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
773: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
774:
767: x_return_status:= FND_API.G_RET_STS_ERROR;
768:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
772: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
773: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
774:
775: CLOSE get_tax_rate_csr;
768:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
772: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
773: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
774:
775: CLOSE get_tax_rate_csr;
776:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
772: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
773: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
774:
775: CLOSE get_tax_rate_csr;
776:
777: IF (g_level_unexpected >= g_current_runtime_level ) THEN
814: IF get_tax_rate_mig_csr%FOUND THEN
815: -- raise error for multiple rate retrieved
816: x_return_status:= FND_API.G_RET_STS_ERROR;
817:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
821: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
822: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
815: -- raise error for multiple rate retrieved
816: x_return_status:= FND_API.G_RET_STS_ERROR;
817:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
821: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
822: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
823:
816: x_return_status:= FND_API.G_RET_STS_ERROR;
817:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
821: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
822: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
823:
824: CLOSE get_tax_rate_mig_csr;
817:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
821: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
822: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
823:
824: CLOSE get_tax_rate_mig_csr;
825:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
821: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
822: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
823:
824: CLOSE get_tax_rate_mig_csr;
825:
826: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1003:
1004: IF get_tax_rate_csr_no_jur%FOUND THEN
1005: -- raise error for multiple rate retrieved
1006: x_return_status:= FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1011: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1004: IF get_tax_rate_csr_no_jur%FOUND THEN
1005: -- raise error for multiple rate retrieved
1006: x_return_status:= FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1011: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1012:
1005: -- raise error for multiple rate retrieved
1006: x_return_status:= FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1011: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1012:
1013: CLOSE get_tax_rate_csr_no_jur;
1006: x_return_status:= FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1011: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1012:
1013: CLOSE get_tax_rate_csr_no_jur;
1014:
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1011: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1012:
1013: CLOSE get_tax_rate_csr_no_jur;
1014:
1015: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1053:
1054: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1055: -- raise error for multiple rate retrieved
1056: x_return_status:= FND_API.G_RET_STS_ERROR;
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1061: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1054: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1055: -- raise error for multiple rate retrieved
1056: x_return_status:= FND_API.G_RET_STS_ERROR;
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1061: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1062:
1055: -- raise error for multiple rate retrieved
1056: x_return_status:= FND_API.G_RET_STS_ERROR;
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1061: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1062:
1063: CLOSE get_tax_rate_csr_no_jur_mig;
1056: x_return_status:= FND_API.G_RET_STS_ERROR;
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1061: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1062:
1063: CLOSE get_tax_rate_csr_no_jur_mig;
1064:
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1061: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1062:
1063: CLOSE get_tax_rate_csr_no_jur_mig;
1064:
1065: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1246: IF get_def_tax_rate_csr%FOUND THEN
1247: -- raise error for multiple rate retrieved
1248: x_return_status:= FND_API.G_RET_STS_ERROR;
1249:
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1247: -- raise error for multiple rate retrieved
1248: x_return_status:= FND_API.G_RET_STS_ERROR;
1249:
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1255: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1248: x_return_status:= FND_API.G_RET_STS_ERROR;
1249:
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1255: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1256:
1249:
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1255: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1256:
1257: CLOSE get_def_tax_rate_csr;
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1255: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1256:
1257: CLOSE get_def_tax_rate_csr;
1258:
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1253: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1254: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1255: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1256:
1257: CLOSE get_def_tax_rate_csr;
1258:
1259: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1297: IF get_def_tax_rate_mig_csr%FOUND THEN
1298: -- raise error for multiple rate retrieved
1299: x_return_status:= FND_API.G_RET_STS_ERROR;
1300:
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1298: -- raise error for multiple rate retrieved
1299: x_return_status:= FND_API.G_RET_STS_ERROR;
1300:
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1306: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1299: x_return_status:= FND_API.G_RET_STS_ERROR;
1300:
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1306: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1307:
1300:
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1306: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1307:
1308: CLOSE get_def_tax_rate_mig_csr;
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1306: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1307:
1308: CLOSE get_def_tax_rate_mig_csr;
1309:
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1304: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1305: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1306: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1307:
1308: CLOSE get_def_tax_rate_mig_csr;
1309:
1310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1486: IF get_def_tax_rate_no_jur_csr%FOUND THEN
1487: -- raise error for multiple rate found
1488: x_return_status:= FND_API.G_RET_STS_ERROR;
1489:
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1487: -- raise error for multiple rate found
1488: x_return_status:= FND_API.G_RET_STS_ERROR;
1489:
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1488: x_return_status:= FND_API.G_RET_STS_ERROR;
1489:
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1496:
1489:
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1496:
1497: CLOSE get_def_tax_rate_no_jur_csr;
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1496:
1497: CLOSE get_def_tax_rate_no_jur_csr;
1498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1493: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1494: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1496:
1497: CLOSE get_def_tax_rate_no_jur_csr;
1498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1499: FND_LOG.STRING(g_level_unexpected,
1542: IF get_def_tax_rate_no_jur_mi_csr%FOUND THEN
1543: -- raise error for multiple rate found
1544: x_return_status:= FND_API.G_RET_STS_ERROR;
1545:
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1543: -- raise error for multiple rate found
1544: x_return_status:= FND_API.G_RET_STS_ERROR;
1545:
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1544: x_return_status:= FND_API.G_RET_STS_ERROR;
1545:
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1552:
1545:
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1552:
1553: CLOSE get_def_tax_rate_no_jur_mi_csr;
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1552:
1553: CLOSE get_def_tax_rate_no_jur_mi_csr;
1554: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1549: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1550: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1552:
1553: CLOSE get_def_tax_rate_no_jur_mi_csr;
1554: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1555: FND_LOG.STRING(g_level_unexpected,
1957:
1958: -- raise error when no tax rate found finally.
1959: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1960: x_return_status:= FND_API.G_RET_STS_ERROR;
1961: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1962: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1965:
1958: -- raise error when no tax rate found finally.
1959: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1960: x_return_status:= FND_API.G_RET_STS_ERROR;
1961: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1962: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1965:
1966: IF (g_level_statement >= g_current_runtime_level) THEN
1959: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1960: x_return_status:= FND_API.G_RET_STS_ERROR;
1961: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1962: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1965:
1966: IF (g_level_statement >= g_current_runtime_level) THEN
1967: FND_LOG.STRING(g_level_statement,
1960: x_return_status:= FND_API.G_RET_STS_ERROR;
1961: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1962: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1965:
1966: IF (g_level_statement >= g_current_runtime_level) THEN
1967: FND_LOG.STRING(g_level_statement,
1968: g_module_name||'.'||l_procedure_name,
2148: -- raise error when no tax rate found finally.
2149: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2150: x_return_status:= FND_API.G_RET_STS_ERROR;
2151:
2152: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2153: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2155: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
2156:
2149: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2150: x_return_status:= FND_API.G_RET_STS_ERROR;
2151:
2152: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2153: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2155: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
2156:
2157: IF (g_level_statement >= g_current_runtime_level) THEN
2150: x_return_status:= FND_API.G_RET_STS_ERROR;
2151:
2152: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2153: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2155: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
2156:
2157: IF (g_level_statement >= g_current_runtime_level) THEN
2158: FND_LOG.STRING(g_level_statement,
2151:
2152: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2153: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2155: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
2156:
2157: IF (g_level_statement >= g_current_runtime_level) THEN
2158: FND_LOG.STRING(g_level_statement,
2159: g_module_name||'.'||l_procedure_name,