DBA Data[Home] [Help]

APPS.OKC_XPRT_REP_INT_PVT dependencies on FND_API

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

4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_REP_INT_PVT';

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

8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_REP_INT_PVT';
16: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';

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

9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_REP_INT_PVT';
16: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
17: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: l_debug := true;
136: END IF;
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
141:
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 151: IF NOT FND_API.Compatible_API_Call (l_api_version,

147:
148: --
149: -- Standard call to check for call compatibility.
150: --
151: IF NOT FND_API.Compatible_API_Call (l_api_version,
152: p_api_version,
153: l_api_name,
154: G_PKG_NAME)
155: THEN

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: p_api_version,
153: l_api_name,
154: G_PKG_NAME)
155: THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158:
159: --
160: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 162: IF FND_API.to_Boolean( p_init_msg_list ) THEN

158:
159: --
160: -- Initialize message list if p_init_msg_list is set to TRUE.
161: --
162: IF FND_API.to_Boolean( p_init_msg_list ) THEN
163: FND_MSG_PUB.initialize;
164: END IF;
165:
166: -- Query REPOSITORY tables to retrieve values against variable codes sent in by calling contract expert API.

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: END IF;
291:
292: EXCEPTION
293:
294: WHEN FND_API.G_EXC_ERROR THEN
295: IF c_get_repository_variables%ISOPEN THEN
296: CLOSE c_get_repository_variables;
297: END IF;
298:

Line 299: x_return_status := FND_API.G_RET_STS_ERROR ;

295: IF c_get_repository_variables%ISOPEN THEN
296: CLOSE c_get_repository_variables;
297: END IF;
298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300:
301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
303: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);

Line 302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300:
301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
303: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
304: END IF;
305:
306: FND_MSG_PUB.Count_And_Get(

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

306: FND_MSG_PUB.Count_And_Get(
307: p_count => x_msg_count,
308: p_data => x_msg_data );
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311:
312: IF c_get_repository_variables%ISOPEN THEN
313: CLOSE c_get_repository_variables;
314: END IF;

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

312: IF c_get_repository_variables%ISOPEN THEN
313: CLOSE c_get_repository_variables;
314: END IF;
315:
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);

Line 319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');

315:
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
321: END IF;
322:
323: FND_MSG_PUB.Count_And_Get(

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: IF c_get_repository_variables%ISOPEN THEN
330: CLOSE c_get_repository_variables;
331: END IF;
332:
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
336: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
337: END IF;