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

Line 149: p_return_status:= FND_API.G_RET_STS_SUCCESS;

145: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE.BEGIN',
146: 'ZX_TDS_RATE_DETM_PKG: GET_TAX_RATE(+)');
147: END IF;
148:
149: p_return_status:= FND_API.G_RET_STS_SUCCESS;
150:
151: -- begin to get tax rate name, if available
152:
153: IF p_begin_index IS NULL or p_end_index IS NULL THEN

Line 154: p_return_status:= FND_API.G_RET_STS_ERROR;

150:
151: -- begin to get tax rate name, if available
152:
153: IF p_begin_index IS NULL or p_end_index IS NULL THEN
154: p_return_status:= FND_API.G_RET_STS_ERROR;
155: IF (g_level_error >= g_current_runtime_level ) THEN
156:
157: FND_LOG.STRING(g_level_error,
158: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 226: p_return_status:= FND_API.G_RET_STS_ERROR;

222: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry =
223: 'TAX_AMOUNT' AND
224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
225: THEN
226: p_return_status:= FND_API.G_RET_STS_ERROR;
227: p_error_buffer :=
228: 'Tax Rate must be entered when last manual entry is Tax Amount';
229: IF (g_level_error >= g_current_runtime_level ) THEN
230: FND_LOG.STRING(g_level_error,

Line 320: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

316: p_tax_rate_code => l_offset_tax_rate_code,
317: x_return_status => p_return_status,
318: x_error_buffer => p_error_buffer
319: );
320: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
321: p_error_buffer := 'Need to create Offset Tax. But offset tax is not
322: valid'; -- will be replaced with coded message
323:
324: IF g_level_error >= g_current_runtime_level THEN

Line 476: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

472: -- in the cache; Even when the user enters a manual tax line with status info.
473: -- the tax status determination will populate the Tax Status cache for that Status
474: -- hence if tax status info is not found in the cache, it is an error.
475:
476: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
477: p_error_buffer := 'The Tax Status information could not be located in cache.';
478:
479: IF (g_level_error >= g_current_runtime_level ) THEN
480: FND_LOG.STRING(g_level_error,

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

511: l_zx_result_rec,
512: p_return_status,
513: p_error_buffer);
514:
515: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR)
516: THEN
517: -- error is raised in rule based evaluation. Abort processing.
518: IF (g_level_error >= g_current_runtime_level ) THEN
519: FND_LOG.STRING(g_level_error,

Line 558: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

554: x_tax_rate_rec => l_tax_rate_rec,
555: x_return_status => p_return_status
556: );
557:
558: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
559: IF (g_level_error >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_error,
561: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
562: 'Incorrect return_status after calling ' ||

Line 625: p_return_status:= FND_API.G_RET_STS_ERROR;

621: IF l_Rate_Type_Code = 'SLABBED' THEN
622:
623: -- slabbed rate not supported in phase 1a;
624: -- UI need to take care of not to allow slabbed tax defined.
625: p_return_status:= FND_API.G_RET_STS_ERROR;
626: p_error_buffer := 'Slabbed rates are not supported in phase 1a ';
627: IF (g_level_error >= g_current_runtime_level ) THEN
628: FND_LOG.STRING(g_level_error,
629: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 650: p_return_status:= FND_API.G_RET_STS_ERROR;

646: IF l_uom_code <>
647: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(p_structure_index)
648: THEN
649: -- Raise error;
650: p_return_status:= FND_API.G_RET_STS_ERROR;
651: p_error_buffer := 'UOM_CODE on the transaction does not match the '||
652: ' UOM_CODE on the rate ';
653:
654: IF (g_level_error >= g_current_runtime_level ) THEN

Line 691: p_return_status:= FND_API.G_RET_STS_ERROR; -- error

687: 'tax rate code: ' ||l_tax_rate_code ||' tax_rate = ' || l_tax_rate);
688: END IF;
689:
690: ELSE -- if l_tax_rate_code is NULL
691: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
692:
693: IF (g_level_error>= g_current_runtime_level ) THEN
694: FND_LOG.STRING(g_level_error,
695: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 721: p_return_status:= FND_API.G_RET_STS_ERROR; -- error

717:
718: IF l_tax_rate IS NULL THEN
719: -- rate_code found from the zx_rates_b table, but no
720: -- rate associated with the rate_code
721: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
722: p_error_buffer := 'Error: No tax rate found';
723: IF (g_level_error >= g_current_runtime_level ) THEN
724: FND_LOG.STRING(g_level_error,
725: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 758: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

754: x_return_status => p_return_status,
755: x_error_buffer => p_error_buffer
756: );
757:
758: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: p_error_buffer := 'Need to create Offset Tax. But offset tax is not valid'; -- will be replaced with coded message
760:
761: IF g_level_error >= g_current_runtime_level THEN
762: FND_LOG.STRING(g_level_error,

Line 799: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

795: x_return_status => p_return_status,
796: x_error_buffer => p_error_buffer
797: );
798:
799: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800:
801: IF (g_level_statement >= g_current_runtime_level ) THEN
802: FND_LOG.STRING(g_level_statement,
803: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 806: p_return_status := FND_API.G_RET_STS_SUCCESS;

802: FND_LOG.STRING(g_level_statement,
803: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
804: 'Offset tax not found, reset the return status and continue the process');
805: END IF;
806: p_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: ELSE -- p_return_status = FND_API.G_RET_STS_SUCCESS
809:
810: l_reg_party_type:= p_event_class_rec.Offset_Tax_Basis_Code || '_TAX_PROF_ID';

Line 808: ELSE -- p_return_status = FND_API.G_RET_STS_SUCCESS

804: 'Offset tax not found, reset the return status and continue the process');
805: END IF;
806: p_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: ELSE -- p_return_status = FND_API.G_RET_STS_SUCCESS
809:
810: l_reg_party_type:= p_event_class_rec.Offset_Tax_Basis_Code || '_TAX_PROF_ID';
811:
812: -- Bug 7208618

Line 833: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

829: l_account_site_id,
830: p_return_status,
831: p_error_buffer);
832:
833: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
834: IF (g_level_error >= g_current_runtime_level ) THEN
835: FND_LOG.STRING(g_level_error,
836: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
837: 'Incorrect return_status after calling ' ||

Line 862: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

858: l_account_id,
859: p_return_status,
860: p_error_buffer);
861:
862: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
863: IF (g_level_error >= g_current_runtime_level ) THEN
864: FND_LOG.STRING(g_level_error,
865: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
866: 'Incorrect return_status after calling ' ||

Line 909: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

905: l_account_id,
906: p_return_status,
907: p_error_buffer);
908:
909: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: IF (g_level_error >= g_current_runtime_level ) THEN
911: FND_LOG.STRING(g_level_error,
912: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
913: 'Incorrect return_status after calling ' ||

Line 980: --IF p_return_status in (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR)

976: -- l_zx_result_rec,
977: -- p_return_status,
978: -- p_error_buffer);
979: --
980: --IF p_return_status in (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR)
981: --THEN
982: -- -- Error is raised in rule based evaluation. Abort processing.
983: -- --
984: -- IF (g_level_statement >= g_current_runtime_level ) THEN

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

985: -- FND_LOG.STRING(g_level_statement,
986: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
987: -- 'Rule Based engine returned error. Aborting... ');
988: -- END IF;
989: -- p_return_status:= FND_API.G_RET_STS_ERROR;
990: -- p_error_buffer := 'Rule Based engine returned error during offset tax determination ';
991: --
992: -- IF (g_level_statement >= g_current_runtime_level ) THEN
993: -- FND_LOG.STRING(g_level_statement,

Line 1078: p_return_status:= FND_API.G_RET_STS_ERROR;

1074: IF l_tax_rate <> l_numeric_result THEN
1075:
1076: -- Raise error
1077: --
1078: p_return_status:= FND_API.G_RET_STS_ERROR;
1079: p_error_buffer := 'Different Exception rate is specified for non-adhoc tax.';
1080:
1081: IF (g_level_error >= g_current_runtime_level) THEN
1082: FND_LOG.STRING(g_level_error,

Line 1136: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1132: x_exception_rec => l_exception_rec,
1133: x_return_status => p_return_status
1134: );
1135:
1136: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1137: IF (g_level_error >= g_current_runtime_level ) THEN
1138: FND_LOG.STRING(g_level_error,
1139: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1140: 'Incorrect return_status after calling ' ||

Line 1262: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1258: p_event_class_rec => p_event_class_rec,
1259: x_return_status => p_return_status,
1260: x_exemption_rec => l_exemption_rec);
1261:
1262: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1263: IF (g_level_error >= g_current_runtime_level ) THEN
1264: FND_LOG.STRING(g_level_error,
1265: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1266: 'Incorrect return_status after calling ' ||

Line 1392: p_return_status:= FND_API.G_RET_STS_ERROR;

1388: -- Tax Status Determination must always populate the Tax Status Information
1389: -- in the cache; Hence if tax status info is not found in the cache,
1390: -- it is an error.
1391:
1392: p_return_status:= FND_API.G_RET_STS_ERROR;
1393: p_error_buffer := 'The Tax Status information could not be located in cache.';
1394: IF (g_level_error >= g_current_runtime_level ) THEN
1395: FND_LOG.STRING(g_level_error,
1396: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1418: p_return_status:= FND_API.G_RET_STS_ERROR;

1414:
1415: IF l_adhoc_tax_rate_flg <> 'Y'
1416: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry = 'TAX_RATE' THEN
1417:
1418: p_return_status:= FND_API.G_RET_STS_ERROR;
1419: p_error_buffer := 'You cannot specify a rate percentage on a tax which '||
1420: ' is not ad-hoc';
1421: IF (g_level_error >= g_current_runtime_level ) THEN
1422: FND_LOG.STRING(g_level_error,

Line 1446: p_return_status:= FND_API.G_RET_STS_ERROR;

1442: THEN
1443: NULL;
1444:
1445: else
1446: p_return_status:= FND_API.G_RET_STS_ERROR;
1447: p_error_buffer := 'The rate is not valid for the tax determination date'||
1448: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date );
1449: IF (g_level_error >= g_current_runtime_level ) THEN
1450: FND_LOG.STRING(g_level_error,

Line 1474: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1470: END IF;
1471:
1472: EXCEPTION
1473: WHEN OTHERS THEN
1474: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1475: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1476:
1477: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1478: FND_LOG.STRING(g_level_unexpected,

Line 1584: x_return_status := FND_API.G_RET_STS_SUCCESS;

1580: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',
1581: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(+)');
1582: END IF;
1583:
1584: x_return_status := FND_API.G_RET_STS_SUCCESS;
1585:
1586: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
1587: p_tax_regime_code,
1588: p_tax,

Line 1594: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN

1590: l_offset_tax_rec,
1591: x_return_status,
1592: x_error_buffer);
1593:
1594: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1595: IF (g_level_error >= g_current_runtime_level ) THEN
1596: FND_LOG.STRING(g_level_error,
1597: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1598: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

Line 1615: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN

1611: l_offet_tax_status_rec,
1612: x_return_status,
1613: x_error_buffer);
1614:
1615: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1616: IF (g_level_error >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_error,
1618: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1619: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

Line 1636: x_return_status := FND_API.G_RET_STS_ERROR;

1632: p_tax_determine_date);
1633:
1634: FETCH get_offset_info_csr INTO l_tax_rate_id;
1635: IF get_offset_info_csr%NOTFOUND THEN
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: x_error_buffer := 'No data found for the specified tax rate '; -- will replace with coded message
1638: IF (g_level_error >= g_current_runtime_level ) THEN
1639: FND_LOG.STRING(g_level_error,
1640: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

Line 1659: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1655: l_offset_tax_rate_rec,
1656: x_return_status,
1657: x_error_buffer);
1658:
1659: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1660: l_tax_rate_id := l_offset_tax_rate_rec.tax_rate_id;
1661:
1662: ELSE
1663: IF (g_level_error >= g_current_runtime_level ) THEN

Line 1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1678: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1679: END IF;
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683:
1684: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1685: FND_LOG.STRING(g_level_unexpected,
1686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',