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

Line 122: p_return_status := FND_API.G_RET_STS_SUCCESS;

118: ' status code: ' || p_tax_status_code||
119: ' tax: ' || p_tax);
120: END IF;
121:
122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: l_index := get_tax_status_index(p_tax,
125: p_tax_regime_code,
126: p_tax_status_code);

Line 160: p_return_status := FND_API.G_RET_STS_ERROR;

156: p_status_rec.Allow_Exemptions_Flag,
157: p_status_rec.Allow_Exceptions_Flag;
158:
159: IF get_status_info_csr%NOTFOUND THEN
160: p_return_status := FND_API.G_RET_STS_ERROR;
161: p_error_buffer := 'No data found for the specified tax status code';
162:
163: FND_MESSAGE.SET_NAME('ZX','ZX_TAX_STATUS_INFO_NOT_FOUND');
164: FND_MESSAGE.SET_TOKEN('TAX_REGIME',p_tax_regime_code);

Line 177: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

173: CLOSE get_status_info_csr;
174:
175: -- update the global status cache structure
176: --
177: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
178: g_tax_status_info_tbl(l_index) := p_status_rec;
179: END IF;
180: END IF;
181:

Line 204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: END IF;
201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
206: IF get_status_info_csr%ISOPEN THEN
207: CLOSE get_status_info_csr;
208: END IF;

Line 263: p_return_status := FND_API.G_RET_STS_SUCCESS;

259: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(+)'||
260: ' regime code: ' || p_tax_regime_code);
261: END IF;
262:
263: p_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: -- check if this tax regime exists in the cache structure
266: --
267: l_index := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.FIRST;

Line 307: p_return_status := FND_API.G_RET_STS_ERROR;

303: -- CLOSE get_regime_info_csr;
304:
305: IF get_regime_info_csr%NOTFOUND THEN
306:
307: p_return_status := FND_API.G_RET_STS_ERROR;
308: p_error_buffer := 'No data found for the specified tax regime code';
309:
310: FND_MESSAGE.SET_NAME('ZX','ZX_TAX_REGIME_INFO_NOT_FOUND');
311: FND_MESSAGE.SET_TOKEN('TAX_REGIME',p_tax_regime_code);

Line 343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: WHEN OTHERS THEN
340: IF get_regime_info_csr%ISOPEN THEN
341: CLOSE get_regime_info_csr;
342: END IF;
343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
345: IF (g_level_unexpected >= g_current_runtime_level ) THEN
346: FND_LOG.STRING(g_level_unexpected,
347: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info',

Line 444: p_return_status := FND_API.G_RET_STS_SUCCESS;

440: ' regime_code: ' || p_tax_regime_code||
441: ' tax: ' || p_tax);
442: END IF;
443:
444: p_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: --
447: -- first check if tax exists in tax cache structure
448: --

Line 473: p_return_status := FND_API.G_RET_STS_ERROR;

469: OPEN get_tax_info_csr;
470: FETCH get_tax_info_csr INTO x_tax_rec;
471:
472: IF get_tax_info_csr%NOTFOUND THEN
473: p_return_status := FND_API.G_RET_STS_ERROR;
474: p_error_buffer := 'No data found for the specified tax_regime_code and tax';
475:
476: FND_MESSAGE.SET_NAME('ZX','ZX_TAX_INFO_NOT_FOUND');
477: FND_MESSAGE.SET_TOKEN('TAX_REGIME',p_tax_regime_code);

Line 507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: WHEN OTHERS THEN
504: IF get_tax_info_csr%ISOPEN THEN
505: CLOSE get_tax_info_csr;
506: END IF;
507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
509: IF (g_level_unexpected >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_unexpected,
511: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',

Line 567: p_return_status := FND_API.G_RET_STS_SUCCESS;

563: ' jurisdiciton_code = ' || p_tax_jurisdiction_code);
564:
565: END IF;
566:
567: p_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: --
570: -- first check if tax exists in tax cache structure
571: --

Line 603: p_return_status := FND_API.G_RET_STS_ERROR;

599: x_jurisdiction_rec.tax_regime_code,
600: x_jurisdiction_rec.tax;
601:
602: IF get_jur_info_csr%NOTFOUND THEN
603: p_return_status := FND_API.G_RET_STS_ERROR;
604: p_error_buffer := 'No data found for the specified tax_regime_code and tax';
605: ELSE
606:
607: -- populate tax cache

Line 630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: WHEN OTHERS THEN
627: IF get_jur_info_csr%ISOPEN THEN
628: CLOSE get_jur_info_csr;
629: END IF;
630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
632: IF (g_level_unexpected >= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_unexpected,
634: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info',

Line 711: p_return_status := FND_API.G_RET_STS_SUCCESS;

707: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(+)'||
708: 'tax_id := ' || to_char(p_tax_id));
709: END IF;
710:
711: p_return_status := FND_API.G_RET_STS_SUCCESS;
712:
713: IF p_tax_id IS NULL THEN
714: IF (g_level_statement >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_statement,

Line 719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

715: FND_LOG.STRING(g_level_statement,
716: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',
717: 'tax_id cannot be null');
718: END IF;
719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
720: p_error_buffer := 'tax_id cannot be null';
721: RETURN;
722: END IF;
723:

Line 732: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

728: OPEN get_tax_info_csr;
729: FETCH get_tax_info_csr INTO g_tax_rec_tbl(p_tax_id);
730:
731: IF get_tax_info_csr%NOTFOUND THEN
732: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
733: p_error_buffer := 'No data found for the specified tax_id';
734: END IF;
735:
736: CLOSE get_tax_info_csr;

Line 753: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

749: WHEN OTHERS THEN
750: IF get_tax_info_csr%ISOPEN THEN
751: CLOSE get_tax_info_csr;
752: END IF;
753: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
755: IF (g_level_unexpected >= g_current_runtime_level ) THEN
756: FND_LOG.STRING(g_level_unexpected,
757: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',

Line 800: p_return_status := FND_API.G_RET_STS_SUCCESS;

796: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(+)'||
797: 'ledger_id := ' || to_char(p_ledger_id));
798: END IF;
799:
800: p_return_status := FND_API.G_RET_STS_SUCCESS;
801:
802: IF p_ledger_id IS NULL THEN
803: IF (g_level_statement >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_statement,

Line 808: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

804: FND_LOG.STRING(g_level_statement,
805: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',
806: 'ledger_id cannot be null');
807: END IF;
808: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
809: p_error_buffer := 'ledger_id cannot be null';
810: RETURN;
811: END IF;
812:

Line 826: p_return_status := FND_API.G_RET_STS_ERROR;

822: g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit,
823: g_currency_rec_tbl(p_ledger_id).precision;
824:
825: IF get_currency_info_csr%NOTFOUND THEN
826: p_return_status := FND_API.G_RET_STS_ERROR;
827: p_error_buffer := 'No data found for the specified ledger_id';
828: END IF;
829:
830: CLOSE get_currency_info_csr;

Line 847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

843: WHEN OTHERS THEN
844: IF get_currency_info_csr%ISOPEN THEN
845: CLOSE get_currency_info_csr;
846: END IF;
847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
849: IF (g_level_unexpected >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_unexpected,
851: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',

Line 971: p_return_status := FND_API.G_RET_STS_SUCCESS;

967:
968: BEGIN
969: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
970:
971: p_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: IF (g_level_statement >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_statement,
975: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',

Line 1004: p_return_status := FND_API.G_RET_STS_ERROR;

1000: OPEN fetch_tax_rate_info_csr_no_JUR;
1001: FETCH fetch_tax_rate_info_csr_no_jur INTO p_tax_rate_rec;
1002:
1003: IF fetch_tax_rate_info_csr_no_JUR%NOTFOUND THEN
1004: p_return_status := FND_API.G_RET_STS_ERROR;
1005: p_error_buffer := 'No tax_rate_id found for the specified ' ||
1006: 'tax_regime_code, tax, tax_status_code and tax_rate_code';
1007:
1008: FND_MESSAGE.SET_NAME('ZX','ZX_TAX_RATE_INFO_NOT_FOUND');

Line 1029: p_return_status := FND_API.G_RET_STS_ERROR;

1025: OPEN fetch_tax_rate_info_csr_no_JUR;
1026: FETCH fetch_tax_rate_info_csr_no_jur INTO p_tax_rate_rec;
1027:
1028: IF fetch_tax_rate_info_csr_no_JUR%NOTFOUND THEN
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: p_error_buffer := 'No tax_rate_id found for the specified ' ||
1031: 'tax_regime_code, tax, tax_status_code and tax_rate_code';
1032:
1033: FND_MESSAGE.SET_NAME('ZX','ZX_TAX_RATE_INFO_NOT_FOUND');

Line 1058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_unexpected,
1061: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1062: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1099: x_return_status := FND_API.G_RET_STS_SUCCESS;

1095:
1096: BEGIN
1097:
1098: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101: IF (g_level_statement >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.BEGIN',
1103: 'ZX_TDS_UTILITIES_PKG.get_tax_index(+)'||

Line 1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1147: RETURN NULL;
1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1155: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',

Line 1221: p_return_status := FND_API.G_RET_STS_SUCCESS;

1217:
1218: BEGIN
1219: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1220:
1221: p_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: IF (g_level_statement >= g_current_runtime_level ) THEN
1224: FND_LOG.STRING(g_level_statement,
1225: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',

Line 1258: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1254: g_tax_rate_info_ind_by_hash(l_tbl_index) := p_tax_rate_rec;
1255:
1256: IF fetch_tax_rate_info_csr%NOTFOUND THEN
1257: -- Bug 7344499 - should return expected error to user
1258: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1259: p_return_status := FND_API.G_RET_STS_ERROR;
1260: p_error_buffer := 'No tax rate info found for the specified tax_rate_id';
1261: END IF;
1262:

Line 1259: p_return_status := FND_API.G_RET_STS_ERROR;

1255:
1256: IF fetch_tax_rate_info_csr%NOTFOUND THEN
1257: -- Bug 7344499 - should return expected error to user
1258: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1259: p_return_status := FND_API.G_RET_STS_ERROR;
1260: p_error_buffer := 'No tax rate info found for the specified tax_rate_id';
1261: END IF;
1262:
1263: CLOSE fetch_tax_rate_info_csr;

Line 1277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1273: END IF;
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1279: FND_LOG.STRING(g_level_unexpected,
1280: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1281: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));