259: THEN
260: -- raise error for multiple rate retrieved for the same jurisdiction code
261: x_return_status:= FND_API.G_RET_STS_ERROR;
262:
263: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
264: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
265: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
266: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
267: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
260: -- raise error for multiple rate retrieved for the same jurisdiction code
261: x_return_status:= FND_API.G_RET_STS_ERROR;
262:
263: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
264: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
265: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
266: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
267: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
268:
261: x_return_status:= FND_API.G_RET_STS_ERROR;
262:
263: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
264: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
265: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
266: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
267: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
268:
269: CLOSE get_tax_rate_csr;
262:
263: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
264: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
265: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
266: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
267: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
268:
269: CLOSE get_tax_rate_csr;
270:
263: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
264: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
265: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
266: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
267: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
268:
269: CLOSE get_tax_rate_csr;
270:
271: IF (g_level_unexpected >= g_current_runtime_level ) THEN
316: THEN
317: -- raise error for multiple rate retrieved for the same jurisdiction code
318: x_return_status:= FND_API.G_RET_STS_ERROR;
319:
320: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
321: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
322: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
323: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
324: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
317: -- raise error for multiple rate retrieved for the same jurisdiction code
318: x_return_status:= FND_API.G_RET_STS_ERROR;
319:
320: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
321: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
322: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
323: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
324: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
325:
318: x_return_status:= FND_API.G_RET_STS_ERROR;
319:
320: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
321: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
322: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
323: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
324: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
325:
326: CLOSE get_tax_rate_mig_csr;
319:
320: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
321: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
322: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
323: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
324: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
325:
326: CLOSE get_tax_rate_mig_csr;
327:
320: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
321: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
322: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
323: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
324: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
325:
326: CLOSE get_tax_rate_mig_csr;
327:
328: IF (g_level_unexpected >= g_current_runtime_level ) THEN
519: THEN
520: -- raise error for multiple rate retrieved for the same jurisdiction code
521: x_return_status:= FND_API.G_RET_STS_ERROR;
522:
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
520: -- raise error for multiple rate retrieved for the same jurisdiction code
521: x_return_status:= FND_API.G_RET_STS_ERROR;
522:
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
528: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
521: x_return_status:= FND_API.G_RET_STS_ERROR;
522:
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
528: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
529:
522:
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
528: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
529:
530: CLOSE get_def_tax_rate_csr;
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
528: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
529:
530: CLOSE get_def_tax_rate_csr;
531:
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
526: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
527: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
528: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
529:
530: CLOSE get_def_tax_rate_csr;
531:
532: IF (g_level_unexpected >= g_current_runtime_level ) THEN
574: THEN
575: -- raise error for multiple rate retrieved for the same jurisdiction code
576: x_return_status:= FND_API.G_RET_STS_ERROR;
577:
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
575: -- raise error for multiple rate retrieved for the same jurisdiction code
576: x_return_status:= FND_API.G_RET_STS_ERROR;
577:
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
583: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
576: x_return_status:= FND_API.G_RET_STS_ERROR;
577:
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
583: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
584:
577:
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
583: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
584:
585: CLOSE get_def_tax_rate_mig_csr;
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
583: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
584:
585: CLOSE get_def_tax_rate_mig_csr;
586:
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
581: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
582: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
583: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
584:
585: CLOSE get_def_tax_rate_mig_csr;
586:
587: IF (g_level_unexpected >= g_current_runtime_level ) THEN
775: IF get_tax_rate_csr%FOUND THEN
776: -- raise error for multiple rate retrieved
777: x_return_status:= FND_API.G_RET_STS_ERROR;
778:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
782: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
783: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
776: -- raise error for multiple rate retrieved
777: x_return_status:= FND_API.G_RET_STS_ERROR;
778:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
782: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
783: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
784:
777: x_return_status:= FND_API.G_RET_STS_ERROR;
778:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
782: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
783: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
784:
785: CLOSE get_tax_rate_csr;
778:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
782: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
783: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
784:
785: CLOSE get_tax_rate_csr;
786:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
782: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
783: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
784:
785: CLOSE get_tax_rate_csr;
786:
787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
824: IF get_tax_rate_mig_csr%FOUND THEN
825: -- raise error for multiple rate retrieved
826: x_return_status:= FND_API.G_RET_STS_ERROR;
827:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
831: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
832: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
825: -- raise error for multiple rate retrieved
826: x_return_status:= FND_API.G_RET_STS_ERROR;
827:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
831: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
832: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
833:
826: x_return_status:= FND_API.G_RET_STS_ERROR;
827:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
831: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
832: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
833:
834: CLOSE get_tax_rate_mig_csr;
827:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
831: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
832: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
833:
834: CLOSE get_tax_rate_mig_csr;
835:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
831: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
832: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
833:
834: CLOSE get_tax_rate_mig_csr;
835:
836: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1016:
1017: IF get_tax_rate_csr_no_jur%FOUND THEN
1018: -- raise error for multiple rate retrieved
1019: x_return_status:= FND_API.G_RET_STS_ERROR;
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1024: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1017: IF get_tax_rate_csr_no_jur%FOUND THEN
1018: -- raise error for multiple rate retrieved
1019: x_return_status:= FND_API.G_RET_STS_ERROR;
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1024: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1025:
1018: -- raise error for multiple rate retrieved
1019: x_return_status:= FND_API.G_RET_STS_ERROR;
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1024: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1025:
1026: CLOSE get_tax_rate_csr_no_jur;
1019: x_return_status:= FND_API.G_RET_STS_ERROR;
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1024: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1025:
1026: CLOSE get_tax_rate_csr_no_jur;
1027:
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1024: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1025:
1026: CLOSE get_tax_rate_csr_no_jur;
1027:
1028: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1066:
1067: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1068: -- raise error for multiple rate retrieved
1069: x_return_status:= FND_API.G_RET_STS_ERROR;
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1074: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1067: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1068: -- raise error for multiple rate retrieved
1069: x_return_status:= FND_API.G_RET_STS_ERROR;
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1074: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1075:
1068: -- raise error for multiple rate retrieved
1069: x_return_status:= FND_API.G_RET_STS_ERROR;
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1074: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1075:
1076: CLOSE get_tax_rate_csr_no_jur_mig;
1069: x_return_status:= FND_API.G_RET_STS_ERROR;
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1074: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1075:
1076: CLOSE get_tax_rate_csr_no_jur_mig;
1077:
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1074: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1075:
1076: CLOSE get_tax_rate_csr_no_jur_mig;
1077:
1078: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1262: IF get_def_tax_rate_csr%FOUND THEN
1263: -- raise error for multiple rate retrieved
1264: x_return_status:= FND_API.G_RET_STS_ERROR;
1265:
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1263: -- raise error for multiple rate retrieved
1264: x_return_status:= FND_API.G_RET_STS_ERROR;
1265:
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1271: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1264: x_return_status:= FND_API.G_RET_STS_ERROR;
1265:
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1271: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1272:
1265:
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1271: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1272:
1273: CLOSE get_def_tax_rate_csr;
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1271: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1272:
1273: CLOSE get_def_tax_rate_csr;
1274:
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1269: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1270: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1271: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1272:
1273: CLOSE get_def_tax_rate_csr;
1274:
1275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1313: IF get_def_tax_rate_mig_csr%FOUND THEN
1314: -- raise error for multiple rate retrieved
1315: x_return_status:= FND_API.G_RET_STS_ERROR;
1316:
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1314: -- raise error for multiple rate retrieved
1315: x_return_status:= FND_API.G_RET_STS_ERROR;
1316:
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1315: x_return_status:= FND_API.G_RET_STS_ERROR;
1316:
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1323:
1316:
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1323:
1324: CLOSE get_def_tax_rate_mig_csr;
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1323:
1324: CLOSE get_def_tax_rate_mig_csr;
1325:
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1321: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1322: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1323:
1324: CLOSE get_def_tax_rate_mig_csr;
1325:
1326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1505: IF get_def_tax_rate_no_jur_csr%FOUND THEN
1506: -- raise error for multiple rate found
1507: x_return_status:= FND_API.G_RET_STS_ERROR;
1508:
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1506: -- raise error for multiple rate found
1507: x_return_status:= FND_API.G_RET_STS_ERROR;
1508:
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1507: x_return_status:= FND_API.G_RET_STS_ERROR;
1508:
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1515:
1508:
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1515:
1516: CLOSE get_def_tax_rate_no_jur_csr;
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1515:
1516: CLOSE get_def_tax_rate_no_jur_csr;
1517: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1512: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1513: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1515:
1516: CLOSE get_def_tax_rate_no_jur_csr;
1517: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1518: FND_LOG.STRING(g_level_unexpected,
1561: IF get_def_tax_rate_no_jur_mi_csr%FOUND THEN
1562: -- raise error for multiple rate found
1563: x_return_status:= FND_API.G_RET_STS_ERROR;
1564:
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1562: -- raise error for multiple rate found
1563: x_return_status:= FND_API.G_RET_STS_ERROR;
1564:
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1563: x_return_status:= FND_API.G_RET_STS_ERROR;
1564:
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1571:
1564:
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1571:
1572: CLOSE get_def_tax_rate_no_jur_mi_csr;
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1571:
1572: CLOSE get_def_tax_rate_no_jur_mi_csr;
1573: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);
1568: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1569: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1571:
1572: CLOSE get_def_tax_rate_no_jur_mi_csr;
1573: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1574: FND_LOG.STRING(g_level_unexpected,
1979:
1980: -- raise error when no tax rate found finally.
1981: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1982: x_return_status:= FND_API.G_RET_STS_ERROR;
1983: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1984: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1987:
1980: -- raise error when no tax rate found finally.
1981: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1982: x_return_status:= FND_API.G_RET_STS_ERROR;
1983: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1984: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1987:
1988: IF (g_level_statement >= g_current_runtime_level) THEN
1981: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1982: x_return_status:= FND_API.G_RET_STS_ERROR;
1983: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1984: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1987:
1988: IF (g_level_statement >= g_current_runtime_level) THEN
1989: FND_LOG.STRING(g_level_statement,
1982: x_return_status:= FND_API.G_RET_STS_ERROR;
1983: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1984: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1987:
1988: IF (g_level_statement >= g_current_runtime_level) THEN
1989: FND_LOG.STRING(g_level_statement,
1990: g_module_name||'.'||l_procedure_name,
2170: -- raise error when no tax rate found finally.
2171: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2172: x_return_status:= FND_API.G_RET_STS_ERROR;
2173:
2174: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2175: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2177: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
2178:
2171: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2172: x_return_status:= FND_API.G_RET_STS_ERROR;
2173:
2174: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2175: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2177: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
2178:
2179: IF (g_level_statement >= g_current_runtime_level) THEN
2172: x_return_status:= FND_API.G_RET_STS_ERROR;
2173:
2174: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2175: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2177: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
2178:
2179: IF (g_level_statement >= g_current_runtime_level) THEN
2180: FND_LOG.STRING(g_level_statement,
2173:
2174: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2175: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2177: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
2178:
2179: IF (g_level_statement >= g_current_runtime_level) THEN
2180: FND_LOG.STRING(g_level_statement,
2181: g_module_name||'.'||l_procedure_name,