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

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

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

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

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

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

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

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

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

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

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

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

1997: '100: p_org_id '||p_org_id);
1998: END IF;
1999:
2000: -- Standard call to check for call compatibility.
2001: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1998: END IF;
1999:
2000: -- Standard call to check for call compatibility.
2001: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: -- Initialize message list if p_init_msg_list is set to TRUE.
2006: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2006: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: -- Initialize message list if p_init_msg_list is set to TRUE.
2006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2007: FND_MSG_PUB.initialize;
2008: END IF;
2009:
2010: -- Initialize API return status to success

Line 2011: x_return_status := FND_API.G_RET_STS_SUCCESS;

2007: FND_MSG_PUB.initialize;
2008: END IF;
2009:
2010: -- Initialize API return status to success
2011: x_return_status := FND_API.G_RET_STS_SUCCESS;
2012:
2013: -- Get the Organization Name
2014: OPEN csr_org_name;
2015: FETCH csr_org_name INTO G_ORGANIZATION_NAME;

Line 2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2049: END IF;
2050:
2051: --- If any errors happen abort API
2052: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2055: RAISE FND_API.G_EXC_ERROR;
2056: END IF;
2057:

Line 2055: RAISE FND_API.G_EXC_ERROR;

2051: --- If any errors happen abort API
2052: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2055: RAISE FND_API.G_EXC_ERROR;
2056: END IF;
2057:
2058:
2059: END IF; -- folder does not exists

Line 2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2132: END IF;
2133:
2134: --- If any errors happen abort API
2135: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140:

Line 2138: RAISE FND_API.G_EXC_ERROR;

2134: --- If any errors happen abort API
2135: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140:
2141:
2142: create_clause_component

Line 2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2156: END IF;
2157:
2158: --- If any errors happen abort API
2159: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2161: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;
2164:

Line 2162: RAISE FND_API.G_EXC_ERROR;

2158: --- If any errors happen abort API
2159: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2161: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;
2164:
2165: create_clause_feature
2166: (

Line 2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2179: END IF;
2180:
2181: --- If any errors happen abort API
2182: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:

Line 2185: RAISE FND_API.G_EXC_ERROR;

2181: --- If any errors happen abort API
2182: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: create_clause_options
2189: (

Line 2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2202: END IF;
2203:
2204: --- If any errors happen abort API
2205: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2207: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2208: RAISE FND_API.G_EXC_ERROR;
2209: END IF;
2210:

Line 2208: RAISE FND_API.G_EXC_ERROR;

2204: --- If any errors happen abort API
2205: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2207: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2208: RAISE FND_API.G_EXC_ERROR;
2209: END IF;
2210:
2211: create_variable_model_ref
2212: (

Line 2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2225: END IF;
2226:
2227: --- If any errors happen abort API
2228: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;
2233:

Line 2231: RAISE FND_API.G_EXC_ERROR;

2227: --- If any errors happen abort API
2228: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;
2233:
2234: -- END LOOP;
2235: --CLOSE csr_intent;

Line 2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2273: END IF;
2274:
2275: --- If any errors happen abort API
2276: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;
2281:

Line 2279: RAISE FND_API.G_EXC_ERROR;

2275: --- If any errors happen abort API
2276: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;
2281:
2282: END LOOP;
2283: CLOSE csr_intent;

Line 2285: IF FND_API.To_Boolean( p_commit ) THEN

2281:
2282: END LOOP;
2283: CLOSE csr_intent;
2284:
2285: IF FND_API.To_Boolean( p_commit ) THEN
2286: COMMIT WORK;
2287: END IF;
2288:
2289: -- Standard call to get message count and if count is 1, get message info.

Line 2300: WHEN FND_API.G_EXC_ERROR THEN

2296: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2297: END IF;
2298:
2299: EXCEPTION
2300: WHEN FND_API.G_EXC_ERROR THEN
2301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2303: G_MODULE||l_api_name,
2304: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2306:
2307: x_return_status := G_RET_STS_ERROR ;
2308: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2313: G_MODULE||l_api_name,
2314: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);