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_TDS_TAXABLE_BASIS_DETM_PKG dependencies on FND_API

Line 154: p_return_status:= FND_API.G_RET_STS_SUCCESS;

150: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',
151: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (+)');
152: END IF;
153:
154: p_return_status:= FND_API.G_RET_STS_SUCCESS;
155:
156: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
157: p_structure_index) IS NOT NULL THEN
158: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 176: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

172: --l_line_amt:= ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_begin_index).line_amt;
173: l_line_amt:= ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_structure_index);
174:
175: IF p_begin_index IS NULL OR p_end_index IS NULL THEN
176: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
177: IF (g_level_procedure >= g_current_runtime_level) THEN
178: FND_LOG.STRING(g_level_procedure,
179: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
180: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||

Line 259: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

255: p_structure_index => p_structure_index,
256: p_return_status => p_return_status,
257: p_error_buffer => p_error_buffer);
258:
259: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
260: IF (g_level_statement>= g_current_runtime_level ) THEN
261: FND_LOG.STRING(g_level_statement,
262: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
263: 'Incorrect return_status after calling ' ||

Line 605: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

601: l_formula_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula;
602: END IF;
603:
604: IF l_formula_code IS NULL THEN
605: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: IF (g_level_error >= g_current_runtime_level ) THEN
607: FND_LOG.STRING(g_level_error ,
608: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
609: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||

Line 675: p_return_status:= FND_API.G_RET_STS_ERROR;

671: OR
672: (l_formula_code = 'STANDARD_QUANTITY' AND
673: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'QUANTITY')
674: THEN
675: p_return_status:= FND_API.G_RET_STS_ERROR;
676: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_FORMULA_MISMATCH');
677: FND_MESSAGE.SET_TOKEN('RATE_TYPE',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type);
678: FND_MESSAGE.SET_TOKEN('TAX',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax );
679: FND_MESSAGE.SET_TOKEN('TAXABLE_BASIS_TYPE', NVL(l_Taxable_Basis_Type_Code, 'PERCENTAGE') );

Line 740: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734

736: l_insurance_charge_appl_flag,
737: l_other_charge_appl_flag;
738:
739: IF getFormulaInfoH%NOTFOUND THEN
740: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
741: IF (g_level_error >= g_current_runtime_level ) THEN
742: FND_LOG.STRING(g_level_error,
743: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
744: 'Formula Info not found for formula code : ' || l_formula_code );

Line 779: p_return_status:= FND_API.G_RET_STS_ERROR;

775: OR
776: (parameter_tbl(l_tax_id).Taxable_Basis_Type_Code = 'QUANTITY' AND
777: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'QUANTITY')
778: THEN
779: p_return_status:= FND_API.G_RET_STS_ERROR;
780: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_FORMULA_MISMATCH');
781: FND_MESSAGE.SET_TOKEN('RATE_TYPE',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type);
782: FND_MESSAGE.SET_TOKEN('TAX',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax );
783: FND_MESSAGE.SET_TOKEN('TAXABLE_BASIS_TYPE', parameter_tbl(l_tax_id).Taxable_Basis_Type_Code);

Line 879: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

875: ', Constcoef: ' ||parameter_tbl(l_tax_id).constcoef);
876: END IF;
877:
878: IF l_formula_id IS NULL THEN
879: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
880: IF (g_level_error >= g_current_runtime_level ) THEN
881: FND_LOG.STRING(g_level_error ,
882: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
883: 'Error : l_formula_id IS NULL ');

Line 929: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

925: l_tax_rec,
926: p_return_status,
927: p_error_buffer);
928:
929: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
930: l_compounding_tax_id := l_tax_rec.tax_id;
931: END IF;
932:
933: -- if getTaxID%notfound then

Line 935: p_return_status:= FND_API.G_RET_STS_ERROR;

931: END IF;
932:
933: -- if getTaxID%notfound then
934: IF l_compounding_tax_id IS NULL THEN
935: p_return_status:= FND_API.G_RET_STS_ERROR;
936: FND_MESSAGE.SET_NAME('ZX','ZX_COMPND_TAX_NOT_FOUND');
937: FND_MESSAGE.SET_TOKEN('TAX',l_compounding_tax);
938: FND_MESSAGE.SET_TOKEN('FORMULA_CODE',l_formula_code);
939: FND_MESSAGE.SET_TOKEN('TRANSACTION_DATE',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

Line 1025: p_return_status:= FND_API.G_RET_STS_ERROR;

1021:
1022: ELSE --l_compounding_tax_id not exists
1023: -- bug fix 3282007: add the following IF condition handling.
1024: IF l_enforce_compounding_flag = 'Y' THEN
1025: p_return_status:= FND_API.G_RET_STS_ERROR;
1026: FND_MESSAGE.SET_NAME('ZX','ZX_COMPND_TAX_NOT_FOUND');
1027: FND_MESSAGE.SET_TOKEN('TAX',l_compounding_tax);
1028: FND_MESSAGE.SET_TOKEN('FORMULA_CODE',l_formula_code);
1029: FND_MESSAGE.SET_TOKEN('TRANSACTION_DATE',ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

Line 1114: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

1110: NULL;
1111:
1112: END CASE;
1113:
1114: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1115: EXIT;
1116: END IF;
1117:
1118: END IF;

Line 1121: IF nvl(p_return_status, 'SUCCESS') <> FND_API.G_RET_STS_ERROR THEN

1117:
1118: END IF;
1119: END LOOP;
1120:
1121: IF nvl(p_return_status, 'SUCCESS') <> FND_API.G_RET_STS_ERROR THEN
1122: IF l_line_amt - l_sum_basiscoef_qua <> 0 THEN
1123: l_common_comp_base := round((l_line_amt - l_sum_constcoef)
1124: / (l_sum_basiscoef *
1125: (1 + l_sum_basiscoef_qua

Line 1384: -- p_return_status := FND_API.G_RET_STS_ERROR;

1380: --OPEN getAdhocInfo(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id);
1381: --FETCH getAdhocInfo into l_adj_for_adhoc_amt_code, l_allow_adhoc_tax_rate_flag;
1382: --IF getAdhocInfo%NOTFOUND THEN
1383: -- close getAdhocInfo;
1384: -- p_return_status := FND_API.G_RET_STS_ERROR;
1385: -- IF (g_level_error >= g_current_runtime_level ) THEN
1386: -- FND_LOG.STRING(g_level_error,
1387: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1388: -- 'No Data Found for tax_rate_code: '||

Line 1407: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1403: p_return_status => p_return_status,
1404: p_error_buffer => p_error_buffer);
1405:
1406: -- bug#7344499- return error to user when rate is not found
1407: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1408: -- no rate found for the specify tax_rate_id
1409: RETURN;
1410: END IF;
1411:

Line 1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734

1464: END IF;
1465:
1466: -- Error out when Tax_rate = 0, unrounded_tax_amt <> 0.
1467: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
1469: IF (g_level_error >= g_current_runtime_level ) THEN
1470: FND_LOG.STRING(g_level_error,
1471: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1472: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||

Line 1501: p_return_status := FND_API.G_RET_STS_ERROR;

1497: ELSE
1498: -- when Taxable_amt = 0, unrounded_tax_amt = 0, do nothing.
1499: -- Error out when Taxable_amt = 0, unrounded_tax_amt <> 0.
1500: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1501: p_return_status := FND_API.G_RET_STS_ERROR;
1502: IF (g_level_error >= g_current_runtime_level ) THEN
1503: FND_LOG.STRING(g_level_error,
1504: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1505: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||

Line 1574: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1570: END IF;
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1576:
1577: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1578: FND_LOG.STRING(g_level_unexpected,

Line 1622: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1618: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',
1619: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (+)');
1620: END IF;
1621:
1622: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1623:
1624: -- IF line_amt_includes_tax_flag is 'A'/'N', tax_amt_included_flag
1625: -- is 'Y'/'N'. If line_amt_includes_tax_flag IN ('S', 'I'), need to
1626: -- determine tax_amt_included_flag from tax rate/tax registration/

Line 1783: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1779: l_reg_party_type,
1780: l_site_ptp_id,
1781: p_return_status );
1782:
1783: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: IF (g_level_error >= g_current_runtime_level ) THEN
1785: FND_LOG.STRING(g_level_error ,
1786: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1787: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');

Line 1828: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1824: l_reg_party_type,
1825: l_ptp_id,
1826: p_return_status );
1827:
1828: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1829: IF (g_level_statement>= g_current_runtime_level ) THEN
1830: FND_LOG.STRING(g_level_statement,
1831: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1832: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');

Line 1892: --p_return_status := FND_API.G_RET_STS_ERROR;

1888: END IF;
1889:
1890: ---- raise error because l_inclusive_tax_flag is not available
1891: ----
1892: --p_return_status := FND_API.G_RET_STS_ERROR;
1893: --p_error_buffer := 'Inclusive Tax Flag is not available.';
1894: --
1895: --FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1896: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

Line 1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1920: END IF;
1921:
1922: EXCEPTION
1923: WHEN OTHERS THEN
1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1926:
1927: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1928: FND_LOG.STRING(g_level_unexpected,