1329:
1330: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1331:
1332: p_return_status := FND_API.G_RET_STS_ERROR;
1333: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1334: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1335:
1336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1330: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1331:
1332: p_return_status := FND_API.G_RET_STS_ERROR;
1333: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1334: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1335:
1336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1338: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1461: p_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1464:
1465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1461: p_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1464:
1465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1467: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;
1489: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1490: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1491:
1492: p_return_status := FND_API.G_RET_STS_ERROR;
1493: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1494: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1495:
1496: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1497: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1490: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1491:
1492: p_return_status := FND_API.G_RET_STS_ERROR;
1493: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1494: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1495:
1496: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1497: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1498: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;
2210:
2211: IF l_rec_rate_code IS NULL THEN
2212: p_return_status := FND_API.G_RET_STS_ERROR;
2213:
2214: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_CODE_NOT_FOUND');
2215: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2217: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2218:
2211: IF l_rec_rate_code IS NULL THEN
2212: p_return_status := FND_API.G_RET_STS_ERROR;
2213:
2214: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_CODE_NOT_FOUND');
2215: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2217: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2218:
2219: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2212: p_return_status := FND_API.G_RET_STS_ERROR;
2213:
2214: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_CODE_NOT_FOUND');
2215: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2217: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2218:
2219: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2220: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2215: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2217: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2218:
2219: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2220: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2221:
2222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2223: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2217: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2218:
2219: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2220: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2221:
2222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2223: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
2362: ELSE -- l_rec_rate NULL
2363:
2364: p_return_status := FND_API.G_RET_STS_ERROR;
2365:
2366: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_NOT_FOUND');
2367: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2363:
2364: p_return_status := FND_API.G_RET_STS_ERROR;
2365:
2366: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_NOT_FOUND');
2367: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2371: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2364: p_return_status := FND_API.G_RET_STS_ERROR;
2365:
2366: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_NOT_FOUND');
2367: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2371: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2372: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2367: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2371: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2372: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2373: FND_MESSAGE.SET_TOKEN('RECOVERY_RATE_CODE', l_rec_rate_code);
2374:
2375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2371: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2372: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2373: FND_MESSAGE.SET_TOKEN('RECOVERY_RATE_CODE', l_rec_rate_code);
2374:
2375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2376: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2369: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id);
2370:
2371: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2372: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE', l_rec_type_code);
2373: FND_MESSAGE.SET_TOKEN('RECOVERY_RATE_CODE', l_rec_rate_code);
2374:
2375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2376: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2377: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
2593: p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate:= 100 - l_total_rec_rate;
2594: IF p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate < 0 THEN
2595: p_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: FND_MESSAGE.SET_NAME('ZX','ZX_SUM_REC_RATE_OVER');
2598:
2599: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_1',
2600: g_tax_recovery_info_tbl(
2601: l_tax_id).primary_recovery_type_code);
2595: p_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: FND_MESSAGE.SET_NAME('ZX','ZX_SUM_REC_RATE_OVER');
2598:
2599: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_1',
2600: g_tax_recovery_info_tbl(
2601: l_tax_id).primary_recovery_type_code);
2602: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_2',
2603: g_tax_recovery_info_tbl(
2598:
2599: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_1',
2600: g_tax_recovery_info_tbl(
2601: l_tax_id).primary_recovery_type_code);
2602: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_2',
2603: g_tax_recovery_info_tbl(
2604: l_tax_id).secondary_recovery_type_code);
2605: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2606: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2601: l_tax_id).primary_recovery_type_code);
2602: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_2',
2603: g_tax_recovery_info_tbl(
2604: l_tax_id).secondary_recovery_type_code);
2605: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2606: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2607:
2608: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2609: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2602: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_2',
2603: g_tax_recovery_info_tbl(
2604: l_tax_id).secondary_recovery_type_code);
2605: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2606: FND_MESSAGE.SET_TOKEN('TAX_NAME', l_tax);
2607:
2608: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2609: p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
2610: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=