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

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: G_MODULE_NAME || l_procedure_name,
197: l_log_msg);
198: END IF;
199:
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: IF p_account_type IN ('E', 'I') THEN
203: l_tax_class_tmp := 'INPUT';
204: ELSIF p_account_type IN ('R' , 'O') THEN

Line 226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

222: END IF;
223:
224: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
225:
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: -- Logging Infra: Statement level
228: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
229: FND_LOG.STRING(G_LEVEL_STATEMENT,
230: G_MODULE_NAME || l_procedure_name,

Line 363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

359: x_default_rounding_code,
360: x_return_status,
361: x_msg_out);
362:
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: -- Logging Infra: Statement level
365: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
366: FND_LOG.STRING(G_LEVEL_STATEMENT,
367: G_MODULE_NAME || l_procedure_name,

Line 390: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

386: x_default_incl_tax_flag,
387: x_return_status,
388: x_msg_out);
389:
390: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
391: -- Logging Infra: Statement level
392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
393: FND_LOG.STRING(G_LEVEL_STATEMENT,
394: G_MODULE_NAME || l_procedure_name,

Line 409: l_return_status := FND_API.G_RET_STS_ERROR;

405: FND_LOG.STRING(G_LEVEL_STATEMENT,
406: G_MODULE_NAME || l_procedure_name,
407: l_log_msg);
408: END IF;
409: l_return_status := FND_API.G_RET_STS_ERROR;
410: l_msg_out := 'ZX_GL_ROUNDING_CODE_NULL';
411: Return;
412: ELSE
413: -- ledger level information (rounding_rule_code) has been derived

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

422:
423: /* comment out as the user should be able to continue to enter journal even if
424: default value is not found. This is consistent with 11i behaviour.
425: IF x_default_tax_rate_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: x_msg_out := 'ZX_GL_RATE_ID_NULL';
428: -- Logging Infra: Statement level
429: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
430: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: END IF;
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: x_msg_out := TO_CHAR(SQLCODE);
463: -- Logging Infra:
464: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 579: l_return_status := FND_API.G_RET_STS_SUCCESS;

575:
576: FETCH get_pct_rate_ccid_cur INTO l_pct_rate,
577: l_tax_account_ccid;
578: IF get_pct_rate_ccid_cur%FOUND THEN
579: l_return_status := FND_API.G_RET_STS_SUCCESS;
580: ELSE
581: l_return_status := FND_API.G_RET_STS_ERROR;
582: x_msg_out := 'ZX_GL_OUT_RATE_CCID_NOTFOUND';
583: END IF;

Line 581: l_return_status := FND_API.G_RET_STS_ERROR;

577: l_tax_account_ccid;
578: IF get_pct_rate_ccid_cur%FOUND THEN
579: l_return_status := FND_API.G_RET_STS_SUCCESS;
580: ELSE
581: l_return_status := FND_API.G_RET_STS_ERROR;
582: x_msg_out := 'ZX_GL_OUT_RATE_CCID_NOTFOUND';
583: END IF;
584:
585: CLOSE get_pct_rate_ccid_cur;

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: END IF;
616:
617: EXCEPTION
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: x_msg_out := TO_CHAR(SQLCODE);
621: -- Logging Infra:
622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 727: x_return_status := FND_API.G_RET_STS_SUCCESS;

723:
724: FETCH tax_acct_cur INTO x_tax_account_ccid;
725:
726: IF tax_acct_cur%FOUND THEN
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: ELSE
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: x_msg_out := 'ZX_GL_TAXCCID_NOT_FOUND';
731: END IF;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725:
726: IF tax_acct_cur%FOUND THEN
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: ELSE
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: x_msg_out := 'ZX_GL_TAXCCID_NOT_FOUND';
731: END IF;
732:
733: CLOSE tax_acct_cur;

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

749: END IF;
750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: x_msg_out := TO_CHAR(SQLCODE);
755: -- Logging Infra:
756: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 906: x_return_status := FND_API.G_RET_STS_SUCCESS;

902: l_log_msg);
903: END IF;
904:
905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: IF p_tax_rate_code = 'STD_AR_INPUT' THEN
909: x_return_status := FND_API.G_RET_STS_ERROR;
910: x_msg_out := 'ZX_GL_INVALID_TAX_RATE_CODE';

Line 909: x_return_status := FND_API.G_RET_STS_ERROR;

905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: IF p_tax_rate_code = 'STD_AR_INPUT' THEN
909: x_return_status := FND_API.G_RET_STS_ERROR;
910: x_msg_out := 'ZX_GL_INVALID_TAX_RATE_CODE';
911: -- Logging Infra:
912: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

934: END IF;
935:
936: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
937:
938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
939: -- Logging Infra: Statement level
940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
941: FND_LOG.STRING(G_LEVEL_STATEMENT,
942: G_MODULE_NAME || l_procedure_name,

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: 'get_tax_rate_id(-)');
1035: END IF;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: x_msg_out := TO_CHAR(SQLCODE);
1040: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(G_LEVEL_STATEMENT,
1042: G_MODULE_NAME || l_procedure_name,

Line 1174: l_return_status := FND_API.G_RET_STS_SUCCESS;

1170: G_MODULE_NAME || l_procedure_name,
1171: l_log_msg);
1172: END IF;
1173:
1174: l_return_status := FND_API.G_RET_STS_SUCCESS;
1175:
1176: IF p_tax_type_code = 'I' THEN
1177:
1178: OPEN get_source_rate_code_cur (p_tax_rate_id);

Line 1205: l_return_status := FND_API.G_RET_STS_ERROR;

1201: l_source_indicator := 'N';
1202:
1203: ELSE
1204:
1205: l_return_status := FND_API.G_RET_STS_ERROR;
1206: x_msg_out := 'ZX_GL_INVALID_PARAM';
1207: -- Logging Infra:
1208: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1209: l_log_msg := 'B: Unexpected tax_type_code';

Line 1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1252: END IF;
1253:
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: x_msg_out := TO_CHAR(SQLCODE);
1258: -- Logging Infra:
1259: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1260: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1356: x_return_status := FND_API.G_RET_STS_SUCCESS;

1352: G_MODULE_NAME || l_procedure_name,
1353: l_log_msg);
1354: END IF;
1355:
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357:
1358: IF ZX_SECURITY.g_first_party_org_id is NULL then
1359: l_set_security_context_flag := 'Y';
1360: ELSE

Line 1375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1371: END IF;
1372:
1373: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
1374:
1375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1376: -- Logging Infra: Statement level
1377: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1378: FND_LOG.STRING(G_LEVEL_STATEMENT,
1379: G_MODULE_NAME || l_procedure_name,

Line 1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1431: END IF;
1432:
1433: EXCEPTION
1434: WHEN OTHERS THEN
1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: x_msg_out := TO_CHAR(SQLCODE);
1437: -- Logging Infra:
1438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1533: x_return_status := FND_API.G_RET_STS_SUCCESS;

1529: G_MODULE_NAME || l_procedure_name,
1530: l_log_msg);
1531: END IF;
1532:
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534:
1535: -- Logging Infra: Procedure level
1536: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1552: --ZX_SECURITY.name_value('FIRSTPTYORGID',to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID));
1553:
1554: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
1555:
1556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1557: -- Logging Infra: Statement level
1558: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1559: FND_LOG.STRING(G_LEVEL_STATEMENT,
1560: G_MODULE_NAME || l_procedure_name,

Line 1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1610: END IF;
1611:
1612: EXCEPTION
1613: WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: x_msg_out := TO_CHAR(SQLCODE);
1616: -- Logging Infra:
1617: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1698: l_return_status := FND_API.G_RET_STS_SUCCESS;

1694: G_MODULE_NAME || l_procedure_name,
1695: l_log_msg);
1696: END IF;
1697:
1698: l_return_status := FND_API.G_RET_STS_SUCCESS;
1699:
1700: IF ZX_SECURITY.g_first_party_org_id is NULL then
1701: l_set_security_context_flag := 'Y';
1702: ELSE

Line 1717: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1713: END IF;
1714:
1715: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
1716:
1717: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1718: -- Logging Infra: Statement level
1719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,
1721: G_MODULE_NAME || l_procedure_name,

Line 1758: l_return_status := FND_API.G_RET_STS_SUCCESS;

1754: l_tax_class);
1755: FETCH ledger_level_cur INTO l_include_tax_flag;
1756:
1757: IF ledger_level_cur%FOUND THEN
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759: ELSE
1760: l_return_status := FND_API.G_RET_STS_ERROR;
1761: l_msg_out := 'ZX_GL_DEF_INCL_TAX_NOTFOUND';
1762: END IF;

Line 1760: l_return_status := FND_API.G_RET_STS_ERROR;

1756:
1757: IF ledger_level_cur%FOUND THEN
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759: ELSE
1760: l_return_status := FND_API.G_RET_STS_ERROR;
1761: l_msg_out := 'ZX_GL_DEF_INCL_TAX_NOTFOUND';
1762: END IF;
1763:
1764: CLOSE ledger_level_cur;

Line 1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1794: END IF;
1795:
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1799: x_msg_out := TO_CHAR(SQLCODE);
1800: -- Logging Infra:
1801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1802: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1851: x_return_status := FND_API.G_RET_STS_SUCCESS;

1847: G_MODULE_NAME || l_procedure_name,
1848: l_log_msg);
1849: END IF;
1850:
1851: x_return_status := FND_API.G_RET_STS_SUCCESS;
1852:
1853: IF ZX_SECURITY.g_first_party_org_id is NULL then
1854: l_set_security_context_flag := 'Y';
1855: ELSE

Line 1870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1866: END IF;
1867:
1868: ZX_SECURITY.set_security_context(p_le_id, p_org_id, NULL, x_return_status);
1869:
1870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1871: -- Logging Infra: Statement level
1872: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1873: FND_LOG.STRING(G_LEVEL_STATEMENT,
1874: G_MODULE_NAME || l_procedure_name,

Line 1919: x_return_status := FND_API.G_RET_STS_ERROR;

1915: END IF;
1916:
1917: EXCEPTION
1918: WHEN NO_DATA_FOUND THEN
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: x_msg_out := 'ZX_GL_LEDGER_CONTROLS_NOTFOUND';
1921: -- Logging Infra:
1922: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1924: G_MODULE_NAME || l_procedure_name,
1925: 'NO_DATA_FOUND');
1926: END IF;
1927: WHEN OTHERS THEN
1928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: x_msg_out := TO_CHAR(SQLCODE);
1930: -- Logging Infra:
1931: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1932: FND_LOG.STRING(G_LEVEL_STATEMENT,