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.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 1578: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1574: '100: p_org_id '||p_org_id);
1575: END IF;
1576:
1577: -- Standard call to check for call compatibility.
1578: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: END IF;
1581:
1582: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1575: END IF;
1576:
1577: -- Standard call to check for call compatibility.
1578: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: END IF;
1581:
1582: -- Initialize message list if p_init_msg_list is set to TRUE.
1583: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1583: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: END IF;
1581:
1582: -- Initialize message list if p_init_msg_list is set to TRUE.
1583: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1584: FND_MSG_PUB.initialize;
1585: END IF;
1586:
1587: -- Initialize API return status to success

Line 1588: x_return_status := FND_API.G_RET_STS_SUCCESS;

1584: FND_MSG_PUB.initialize;
1585: END IF;
1586:
1587: -- Initialize API return status to success
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589:
1590: /*
1591: -- Generate the Run Id
1592: OPEN csr_cz_run_id;

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: END IF;
1649:
1650: --- If any errors happen abort API
1651: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:

Line 1654: RAISE FND_API.G_EXC_ERROR;

1650: --- If any errors happen abort API
1651: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:
1657: create_variable_component
1658: (

Line 1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1670: END IF;
1671:
1672: --- If any errors happen abort API
1673: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: --- If any errors happen abort API
1673: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:
1679: create_variable_features
1680: (

Line 1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1692: END IF;
1693:
1694: --- If any errors happen abort API
1695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: --- If any errors happen abort API
1695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: create_variable_options
1702: (

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: END IF;
1715:
1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722:

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722:
1723:
1724: -- END LOOP;

Line 1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1771: END IF;
1772:
1773: --- If any errors happen abort API
1774: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779:

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: --- If any errors happen abort API
1774: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779:
1780:
1781: END LOOP;

Line 1784: IF FND_API.To_Boolean( p_commit ) THEN

1780:
1781: END LOOP;
1782: CLOSE csr_intent;
1783:
1784: IF FND_API.To_Boolean( p_commit ) THEN
1785: COMMIT WORK;
1786: END IF;
1787:
1788: -- Standard call to get message count and if count is 1, get message info.

Line 1799: WHEN FND_API.G_EXC_ERROR THEN

1795: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1796: END IF;
1797:
1798: EXCEPTION
1799: WHEN FND_API.G_EXC_ERROR THEN
1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1802: G_MODULE||l_api_name,
1803: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1805:
1806: x_return_status := G_RET_STS_ERROR ;
1807: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1812: G_MODULE||l_api_name,
1813: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);