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.

[Home] [Help]

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 578: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 580: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 908: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1172: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1203: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1355: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1697: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1716: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1757: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1759: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1850: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1918: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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