DBA Data[Home] [Help]

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on FND_API

Line 162: p_return_status:= FND_API.G_RET_STS_SUCCESS;

158: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',
159: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (+)');
160: END IF;
161:
162: p_return_status:= FND_API.G_RET_STS_SUCCESS;
163:
164: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
165: p_structure_index) IS NOT NULL THEN
166:

Line 187: p_return_status:= FND_API.G_RET_STS_ERROR;

183:
184:
185: IF p_begin_index is null or p_end_index is null THEN
186:
187: p_return_status:= FND_API.G_RET_STS_ERROR;
188: IF (g_level_procedure >= g_current_runtime_level ) THEN
189:
190: FND_LOG.STRING(g_level_procedure,
191: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 257: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 543: p_return_status := FND_API.G_RET_STS_ERROR;

539: END IF;
540: END IF;
541:
542: IF l_formula_code IS NULL THEN
543: p_return_status := FND_API.G_RET_STS_ERROR;
544: IF (g_level_error >= g_current_runtime_level ) THEN
545:
546: FND_LOG.STRING(g_level_error ,
547: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 607: p_return_status:= FND_API.G_RET_STS_ERROR;

603: OR ( l_formula_code = 'STANDARD_QUANTITY' AND
604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'QUANTITY' )
605: THEN
606:
607: p_return_status:= FND_API.G_RET_STS_ERROR;
608:
609: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_FORMULA_MISMATCH');
610: FND_MESSAGE.SET_TOKEN('RATE_TYPE',
611: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type);

Line 678: p_return_status:= FND_API.G_RET_STS_ERROR;

674: l_Other_Charge_Appl_Flag;
675:
676: if getFormulaInfoH%notfound then
677:
678: p_return_status:= FND_API.G_RET_STS_ERROR;
679: IF (g_level_error >= g_current_runtime_level ) THEN
680: FND_LOG.STRING(g_level_error,
681: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
682: 'Formula Info not found for formula code ' || l_formula_code );

Line 718: p_return_status:= FND_API.G_RET_STS_ERROR;

714: ( parameter_tbl(l_tax_id).Taxable_Basis_Type_Code = 'QUANTITY' AND
715: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'QUANTITY')
716: THEN
717:
718: p_return_status:= FND_API.G_RET_STS_ERROR;
719:
720: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_FORMULA_MISMATCH');
721: FND_MESSAGE.SET_TOKEN('RATE_TYPE',
722: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type);

Line 844: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

840: parameter_tbl(l_tax_id).constcoef);
841: END IF;
842:
843: if l_formula_id is null then
844: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
845: IF (g_level_error >= g_current_runtime_level ) THEN
846: FND_LOG.STRING(g_level_error ,
847: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
848: 'l_formula_id is null ');

Line 895: if p_return_status = FND_API.G_RET_STS_SUCCESS then

891: l_tax_rec,
892: p_return_status,
893: p_error_buffer);
894:
895: if p_return_status = FND_API.G_RET_STS_SUCCESS then
896: l_compounding_tax_id := l_tax_rec.tax_id;
897: end if;
898:
899: -- if getTaxID%notfound then

Line 901: p_return_status:= FND_API.G_RET_STS_ERROR;

897: end if;
898:
899: -- if getTaxID%notfound then
900: if l_compounding_tax_id IS NULL then
901: p_return_status:= FND_API.G_RET_STS_ERROR;
902:
903: IF (g_level_error >= g_current_runtime_level ) THEN
904: FND_LOG.STRING(g_level_error ,
905: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 945: p_return_status:= FND_API.G_RET_STS_ERROR;

941:
942: -- bug fix 3282007: add the following IF condition handling.
943: IF l_enforce_compounding_flag = 'Y' THEN
944:
945: p_return_status:= FND_API.G_RET_STS_ERROR;
946:
947: FND_MESSAGE.SET_NAME('ZX','ZX_COMPND_TAX_NOT_FOUND');
948: FND_MESSAGE.SET_TOKEN('TAX',l_compounding_tax);
949: FND_MESSAGE.SET_TOKEN('FORMULA_CODE',l_formula_code);

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

1009: NULL;
1010:
1011: END CASE; -- Delete_Flag
1012:
1013: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: EXIT;
1015: END IF;
1016: END IF;
1017:

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

1022: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1023: ' ');
1024: END IF;
1025:
1026: IF nvl(p_return_status, 'SUCCESS') <> FND_API.G_RET_STS_ERROR THEN
1027:
1028: l_common_comp_base := (l_line_amt - l_sum_constcoef) / l_sum_basiscoef;
1029:
1030: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1178: p_return_status := FND_API.G_RET_STS_ERROR;

1174: OPEN getAdhocInfo(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id);
1175: FETCH getAdhocInfo into l_adj_for_adhoc_amt_code, l_allow_adhoc_tax_rate_flag;
1176: IF getAdhocInfo%NOTFOUND THEN
1177: close getAdhocInfo;
1178: p_return_status := FND_API.G_RET_STS_ERROR;
1179: IF (g_level_error >= g_current_runtime_level ) THEN
1180: FND_LOG.STRING(g_level_error,
1181: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1182: 'No Data Found for tax_rate_code: '||

Line 1204: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1200:
1201:
1202: -- bug#7344499- return error to user when rate is not found
1203:
1204: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: -- no rate found for the specify tax_rate_id
1206: RETURN;
1207: END IF;
1208:

Line 1239: p_return_status := FND_API.G_RET_STS_ERROR;

1235:
1236: -- when tax_rate = 0, unrounded_tax_amt = 0, do nothing.
1237: -- Error out when Tax_rate = 0, unrounded_tax_amt <> 0.
1238: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1239: p_return_status := FND_API.G_RET_STS_ERROR;
1240: IF (g_level_error >= g_current_runtime_level ) THEN
1241: FND_LOG.STRING(g_level_error,
1242: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1243: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );

Line 1276: p_return_status := FND_API.G_RET_STS_ERROR;

1272: ELSE
1273: -- when Taxable_amt = 0, unrounded_tax_amt = 0, do nothing.
1274: -- Error out when Taxable_amt = 0, unrounded_tax_amt <> 0.
1275: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1276: p_return_status := FND_API.G_RET_STS_ERROR;
1277: IF (g_level_error >= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_error,
1279: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1280: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );

Line 1347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1343: END IF;
1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1349:
1350: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1351: FND_LOG.STRING(g_level_unexpected,

Line 1394: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1390: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',
1391: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (+)');
1392: END IF;
1393:
1394: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1395:
1396:
1397: -- IF line_amt_includes_tax_flag is 'A'/'N', tax_amt_included_flag
1398: -- is 'Y'/'N'. If line_amt_includes_tax_flag IN ('S', 'I'), need to

Line 1485: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1481: l_reg_party_type,
1482: l_site_ptp_id,
1483: p_return_status );
1484:
1485: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: IF (g_level_error >= g_current_runtime_level ) THEN
1487: FND_LOG.STRING(g_level_error ,
1488: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1489: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');

Line 1529: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1525: l_reg_party_type,
1526: l_ptp_id,
1527: p_return_status );
1528:
1529: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1530: IF (g_level_statement>= g_current_runtime_level ) THEN
1531: FND_LOG.STRING(g_level_statement,
1532: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1533: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');

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

1589: END IF;
1590:
1591: ---- raise error because l_inclusive_tax_flag is not available
1592: ----
1593: --p_return_status := FND_API.G_RET_STS_ERROR;
1594: --p_error_buffer := 'Inclusive Tax Flag is not available.';
1595: --
1596: --FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1597: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

Line 1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1621: END IF;
1622:
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1627:
1628: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1629: FND_LOG.STRING(g_level_unexpected,