eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 4562: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

4558: l_date DATE;
4559: l_return_status VARCHAR2(30);
4560: l_error_buffer VARCHAR2(240);
4561: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4562: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4563: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4564: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
4565: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
4566: l_tax_rate_id ZX_RATES_B.tax_rate_id%type;

Line 4563: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

4559: l_return_status VARCHAR2(30);
4560: l_error_buffer VARCHAR2(240);
4561: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4562: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4563: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4564: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
4565: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
4566: l_tax_rate_id ZX_RATES_B.tax_rate_id%type;
4567:

Line 4564: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

4560: l_error_buffer VARCHAR2(240);
4561: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4562: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4563: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4564: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
4565: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
4566: l_tax_rate_id ZX_RATES_B.tax_rate_id%type;
4567:
4568:

Line 4565: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

4561: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4562: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4563: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4564: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
4565: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
4566: l_tax_rate_id ZX_RATES_B.tax_rate_id%type;
4567:
4568:
4569:

Line 4808: 'Calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info to populate tax_cache...');

4804:
4805: IF (g_level_statement >= g_current_runtime_level ) THEN
4806: FND_LOG.STRING(g_level_statement,
4807: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4808: 'Calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info to populate tax_cache...');
4809: END IF;
4810:
4811: -- populate tax_regime_cache_info
4812: --

Line 4816: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

4812: --
4813: -- Bug#5395227- get tax_regime_id if it is null
4814: --
4815: IF p_tax_out_rec.tax_regime_id IS NULL THEN
4816: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
4817: p_tax_out_rec.tax_regime_code,
4818: p_tax_out_rec.TRX_DATE,
4819: l_tax_regime_rec,
4820: l_return_status,

Line 4832: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');

4828: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4829: FND_LOG.STRING(g_level_unexpected,
4830: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4831: 'Incorrect return_status after calling ' ||
4832: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
4833: FND_LOG.STRING(g_level_unexpected,
4834: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4835: 'RETURN_STATUS = ' || l_return_status);
4836: FND_LOG.STRING(g_level_unexpected,

Line 4853: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

4849: -- populate tax_cache in Tax Determination Services for tail end processing
4850: -- Bug#5395227- call cache structure to get place of supply
4851: -- type code
4852: --
4853: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
4854: p_tax_regime_code => p_tax_out_rec.TAX_REGIME_CODE,
4855: p_tax => p_tax_out_rec.TAX,
4856: p_tax_determine_date => p_tax_out_rec.TRX_DATE,
4857: x_tax_rec => l_tax_rec,

Line 4882: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');

4878: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4879: FND_LOG.STRING(g_level_unexpected,
4880: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4881: 'Incorrect return_status after calling ' ||
4882: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
4883: FND_LOG.STRING(g_level_unexpected,
4884: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4885: 'RETURN_STATUS = ' || l_return_status);
4886: FND_LOG.STRING(g_level_unexpected,

Line 4896: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

4892: END IF;
4893:
4894: IF p_tax_out_rec.TAX_JURISDICTION_CODE IS NOT NULL THEN
4895:
4896: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
4897: p_tax_regime_code => p_tax_out_rec.TAX_REGIME_CODE,
4898: p_tax => p_tax_out_rec.TAX,
4899: p_tax_jurisdiction_code => p_tax_out_rec.TAX_JURISDICTION_CODE,
4900: p_tax_determine_date => p_tax_out_rec.TRX_DATE,

Line 4913: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');

4909: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4910: FND_LOG.STRING(g_level_unexpected,
4911: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4912: 'Incorrect return_status after calling ' ||
4913: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
4914: FND_LOG.STRING(g_level_unexpected,
4915: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4916: 'RETURN_STATUS = ' || l_return_status);
4917: FND_LOG.STRING(g_level_unexpected,

Line 4932: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

4928: --
4929: -- Bug#5395227- get tax_status_id only if it is null
4930: --
4931: IF p_tax_out_rec.tax_status_id IS NULL THEN
4932: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
4933: p_tax_out_rec.tax,
4934: p_tax_out_rec.tax_regime_code,
4935: p_tax_out_rec.tax_status_code,
4936: p_tax_out_rec.TRX_DATE,

Line 4949: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');

4945: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4946: FND_LOG.STRING(g_level_unexpected,
4947: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4948: 'Incorrect return_status after calling ' ||
4949: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
4950: FND_LOG.STRING(g_level_unexpected,
4951: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4952: 'RETURN_STATUS = ' || l_return_status);
4953: FND_LOG.STRING(g_level_unexpected,

Line 4965: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

4961: -- bug#5395227
4962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_status_id := p_tax_out_rec.tax_status_id;
4963: END IF;
4964:
4965: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
4966: p_tax_regime_code => p_tax_out_rec.TAX_REGIME_CODE,
4967: p_tax => p_tax_out_rec.TAX,
4968: p_tax_jurisdiction_code => NULL,
4969: p_tax_status_code => p_tax_out_rec.TAX_STATUS_CODE,

Line 4987: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');

4983: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4984: FND_LOG.STRING(g_level_unexpected,
4985: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4986: 'Incorrect return_status after calling ' ||
4987: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
4988: FND_LOG.STRING(g_level_unexpected,
4989: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4990: 'RETURN_STATUS = ' || l_return_status);
4991: FND_LOG.STRING(g_level_unexpected,

Line 5130: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

5126: p_new_row_num IN NUMBER,
5127: x_return_status OUT NOCOPY VARCHAR2) IS
5128:
5129: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
5130: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
5131: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
5132: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
5133:
5134: l_tax_date DATE;

Line 5131: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

5127: x_return_status OUT NOCOPY VARCHAR2) IS
5128:
5129: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
5130: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
5131: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
5132: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
5133:
5134: l_tax_date DATE;
5135: l_tax_determine_date DATE;

Line 5132: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

5128:
5129: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
5130: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
5131: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
5132: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
5133:
5134: l_tax_date DATE;
5135: l_tax_determine_date DATE;
5136: l_tax_point_date DATE;

Line 5214: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

5210: RETURN;
5211: END IF;
5212:
5213: -- populate tax_regime_cache_info
5214: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
5215: p_tax_line_rec.tax_regime_code,
5216: l_tax_determine_date,
5217: l_tax_regime_rec,
5218: x_return_status,

Line 5226: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');

5222: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5223: FND_LOG.STRING(g_level_unexpected,
5224: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5225: 'Incorrect return_status after calling ' ||
5226: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
5227: FND_LOG.STRING(g_level_unexpected,
5228: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5229: 'RETURN_STATUS = ' || x_return_status);
5230: FND_LOG.STRING(g_level_unexpected,

Line 5239: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

5235: RETURN;
5236: END IF;
5237:
5238: -- populate tax cache, if it does not exist there.
5239: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
5240: p_tax_line_rec.tax_regime_code,
5241: p_tax_line_rec.tax,
5242: l_tax_determine_date,
5243: l_tax_rec,

Line 5252: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');

5248: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5249: FND_LOG.STRING(g_level_unexpected,
5250: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5251: 'Incorrect return_status after calling ' ||
5252: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
5253: FND_LOG.STRING(g_level_unexpected,
5254: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5255: 'RETURN_STATUS = ' || x_return_status);
5256: FND_LOG.STRING(g_level_unexpected,

Line 5265: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

5261: RETURN;
5262: END IF;
5263:
5264: IF p_tax_line_rec.TAX_JURISDICTION_CODE IS NOT NULL THEN
5265: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
5266: p_tax_regime_code => p_tax_line_rec.TAX_REGIME_CODE,
5267: p_tax => p_tax_line_rec.TAX,
5268: p_tax_jurisdiction_code => p_tax_line_rec.TAX_JURISDICTION_CODE,
5269: p_tax_determine_date => l_tax_determine_date,

Line 5279: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');

5275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5276: FND_LOG.STRING(g_level_unexpected,
5277: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5278: 'Incorrect return_status after calling ' ||
5279: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
5280: FND_LOG.STRING(g_level_unexpected,
5281: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5282: 'RETURN_STATUS = ' || x_return_status);
5283: FND_LOG.STRING(g_level_unexpected,

Line 5293: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

5289: END IF;
5290: END IF;
5291:
5292: -- populate tax_status_cahce_info
5293: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
5294: p_tax_line_rec.tax,
5295: p_tax_line_rec.tax_regime_code,
5296: p_tax_line_rec.tax_status_code,
5297: l_tax_determine_date,

Line 5307: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');

5303: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5304: FND_LOG.STRING(g_level_unexpected,
5305: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5306: 'Incorrect return_status after calling ' ||
5307: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
5308: FND_LOG.STRING(g_level_unexpected,
5309: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5310: 'RETURN_STATUS = ' || x_return_status);
5311: FND_LOG.STRING(g_level_unexpected,

Line 5540: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

5536: (p_tax_determine_date <= effective_to OR effective_to IS NULL));
5537:
5538: */
5539: -- Bug#5395227
5540: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
5541:
5542: BEGIN
5543: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5544:

Line 5579: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

5575: */
5576:
5577: /* 5395227- this procedure get_tax_rate_id is
5578: currently not used
5579: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
5580: p_tax_regime_code,
5581: p_tax,
5582: p_tax_jurisdiction_code,
5583: p_tax_status_code,

Line 6633: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

6629: AND tax_provider_id IS NULL;
6630:
6631: l_row_num NUMBER;
6632: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
6633: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
6634: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6635: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6636: l_current_line_amt ZX_LINES.line_amt%TYPE;
6637: l_tax_class VARCHAR2(30);

Line 6634: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

6630:
6631: l_row_num NUMBER;
6632: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
6633: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
6634: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6635: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6636: l_current_line_amt ZX_LINES.line_amt%TYPE;
6637: l_tax_class VARCHAR2(30);
6638: l_tax_date DATE;

Line 6635: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

6631: l_row_num NUMBER;
6632: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
6633: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
6634: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6635: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6636: l_current_line_amt ZX_LINES.line_amt%TYPE;
6637: l_tax_class VARCHAR2(30);
6638: l_tax_date DATE;
6639: l_tax_determine_date DATE;

Line 6703: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

6699: NULL;
6700:
6701: ELSE
6702: -- validate and populate tax_regime_id
6703: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
6704: tax_line_rec.tax_regime_code,
6705: l_tax_determine_date,
6706: l_tax_regime_rec,
6707: x_return_status,

Line 6715: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');

6711: IF (g_level_statement >= g_current_runtime_level ) THEN
6712: FND_LOG.STRING(g_level_statement,
6713: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6714: 'Incorrect return_status after calling ' ||
6715: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
6716: FND_LOG.STRING(g_level_statement,
6717: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6718: 'RETURN_STATUS = ' || x_return_status);
6719: FND_LOG.STRING(g_level_statement,

Line 6729: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

6725:
6726: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
6727:
6728: -- validate and populate tax_id
6729: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
6730: tax_line_rec.tax_regime_code,
6731: tax_line_rec.tax,
6732: l_tax_determine_date,
6733: l_tax_rec,

Line 6742: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

6738: IF (g_level_statement >= g_current_runtime_level ) THEN
6739: FND_LOG.STRING(g_level_statement,
6740: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6741: 'Incorrect return_status after calling ' ||
6742: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
6743: FND_LOG.STRING(g_level_statement,
6744: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6745: 'RETURN_STATUS = ' || x_return_status);
6746: FND_LOG.STRING(g_level_statement,

Line 6756: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

6752:
6753: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_row_num).tax_id := l_tax_rec.tax_id;
6754:
6755: -- validate and populate tax_status_id
6756: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
6757: tax_line_rec.tax,
6758: tax_line_rec.tax_regime_code,
6759: tax_line_rec.tax_status_code,
6760: l_tax_determine_date,

Line 6770: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

6766: IF (g_level_statement >= g_current_runtime_level ) THEN
6767: FND_LOG.STRING(g_level_statement,
6768: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6769: 'Incorrect return_status after calling ' ||
6770: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
6771: FND_LOG.STRING(g_level_statement,
6772: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6773: 'RETURN_STATUS = ' || x_return_status);
6774: FND_LOG.STRING(g_level_statement,

Line 6784: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

6780:
6781: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
6782:
6783: -- validate and populate tax_rate_id
6784: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
6785: tax_line_rec.tax_regime_code,
6786: tax_line_rec.tax,
6787: tax_line_rec.tax_jurisdiction_code,
6788: tax_line_rec.tax_status_code,

Line 6801: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

6797: IF (g_level_statement >= g_current_runtime_level ) THEN
6798: FND_LOG.STRING(g_level_statement,
6799: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6800: 'Incorrect return_status after calling ' ||
6801: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
6802: FND_LOG.STRING(g_level_statement,
6803: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6804: 'RETURN_STATUS = ' || x_return_status);
6805: FND_LOG.STRING(g_level_statement,

Line 6974: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,

6970: END IF;
6971:
6972: FOR tax_line_rec IN get_manual_tax_lines LOOP
6973:
6974: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
6975: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
6976: p_tax_id => tax_line_rec.TAX_ID,
6977: p_return_status => x_return_status,
6978: p_error_buffer => l_error_buffer);

Line 6975: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

6971:
6972: FOR tax_line_rec IN get_manual_tax_lines LOOP
6973:
6974: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
6975: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
6976: p_tax_id => tax_line_rec.TAX_ID,
6977: p_return_status => x_return_status,
6978: p_error_buffer => l_error_buffer);
6979:

Line 6985: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');

6981: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6982: FND_LOG.STRING(g_level_unexpected,
6983: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
6984: 'Incorrect return_status after calling ' ||
6985: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
6986: FND_LOG.STRING(g_level_unexpected,
6987: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
6988: 'RETURN_STATUS = ' || x_return_status);
6989: FND_LOG.STRING(g_level_unexpected,

Line 7032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).LEGAL_REPORTING_STATUS := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

7028: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).MULTIPLE_JURISDICTIONS_FLAG := tax_line_rec.MULTIPLE_JURISDICTIONS_FLAG;
7029: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).ACCOUNT_SOURCE_TAX_RATE_ID := tax_line_rec.ACCOUNT_SOURCE_TAX_RATE_ID;
7030:
7031: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).LEGAL_REPORTING_STATUS := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7033: tax_line_rec.tax_id).LEGAL_REPORTING_STATUS_DEF_VAL;
7034: END IF;
7035:
7036: -- populate taxable_basis_formula and tax_calculation_formula