DBA Data[Home] [Help]

APPS.OKS_TEMPLATE_SET_PUB dependencies on FND_API

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

9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

10: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';

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

13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

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

1697: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1698: END IF;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: END IF;
1704:
1705: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1698: END IF;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: END IF;
1704:
1705: -- Initialize message list if p_init_msg_list is set to TRUE.
1706: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1706: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: END IF;
1704:
1705: -- Initialize message list if p_init_msg_list is set to TRUE.
1706: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1707: FND_MSG_PUB.initialize;
1708: END IF;
1709:
1710: -- Initialize API return status to success

Line 1711: x_return_status := FND_API.G_RET_STS_SUCCESS;

1707: FND_MSG_PUB.initialize;
1708: END IF;
1709:
1710: -- Initialize API return status to success
1711: x_return_status := FND_API.G_RET_STS_SUCCESS;
1712:
1713: -- set moac context
1714: mo_global.init('OKC');
1715:

Line 1726: p_init_msg_list => FND_API.G_FALSE,

1722:
1723: OKS_WF_K_PROCESS_PVT.is_online_k_yn
1724: (
1725: p_api_version => 1.0,
1726: p_init_msg_list => FND_API.G_FALSE,
1727: p_contract_id => p_contract_id ,
1728: p_item_key => l_item_key ,
1729: x_online_yn => l_online_yn ,
1730: x_return_status => x_return_status,

Line 1750: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1746: END IF;
1747: --- If any errors happen treat it as online K
1748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1749: l_online_yn := 'Y';
1750: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1752: l_online_yn := 'Y';
1753: -- RAISE FND_API.G_EXC_ERROR;
1754: END IF;

Line 1753: -- RAISE FND_API.G_EXC_ERROR;

1749: l_online_yn := 'Y';
1750: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1752: l_online_yn := 'Y';
1753: -- RAISE FND_API.G_EXC_ERROR;
1754: END IF;
1755:
1756:
1757:

Line 1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1812: END IF;
1813:
1814: --- If any errors happen abort API
1815: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:

Line 1818: RAISE FND_API.G_EXC_ERROR;

1814: --- If any errors happen abort API
1815: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:
1821: -- get the template details
1822: OPEN csr_tmpl_set_dtls(p_template_set_id => l_template_set_id,

Line 1866: WHEN FND_API.G_EXC_ERROR THEN

1862: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1863: END IF;
1864:
1865: EXCEPTION
1866: WHEN FND_API.G_EXC_ERROR THEN
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1869: G_MODULE||l_api_name,
1870: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1872:
1873: x_return_status := G_RET_STS_ERROR ;
1874: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);