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_API dependencies on OKC_API

Line 1: PACKAGE BODY OKC_API AS

1: PACKAGE BODY OKC_API AS
2: /* $Header: OKCPAPIB.pls 120.0 2005/05/30 04:12:53 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4: --------------------------------------------------------------------------------
5: -- MESSAGE CONSTANTS

Line 2: /* $Header: OKCPAPIB.pls 120.0 2005/05/30 04:12:53 appldev noship $ */

1: PACKAGE BODY OKC_API AS
2: /* $Header: OKCPAPIB.pls 120.0 2005/05/30 04:12:53 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4: --------------------------------------------------------------------------------
5: -- MESSAGE CONSTANTS
6: --------------------------------------------------------------------------------

Line 7: G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := OKC_API.G_MISS_NUM;

3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4: --------------------------------------------------------------------------------
5: -- MESSAGE CONSTANTS
6: --------------------------------------------------------------------------------
7: G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := OKC_API.G_MISS_NUM;
8: --------------------------------------------------------------------------------
9: -- PROCEDURE init_msg_list
10: --------------------------------------------------------------------------------
11: PROCEDURE init_msg_list (

Line 20: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

16: FND_MSG_PUB.initialize;
17: END IF;
18: EXCEPTION
19: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
20: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21: END init_msg_list;
22: --------------------------------------------------------------------------------
23: -- FUNCTION start_activity
24: --------------------------------------------------------------------------------

Line 44: RETURN(OKC_API.G_RET_STS_UNEXP_ERROR);

40: p_api_version,
41: p_api_name,
42: p_pkg_name)
43: THEN
44: RETURN(OKC_API.G_RET_STS_UNEXP_ERROR);
45: END IF;
46:
47: OKC_API.init_msg_list(p_init_msg_list);
48:

Line 47: OKC_API.init_msg_list(p_init_msg_list);

43: THEN
44: RETURN(OKC_API.G_RET_STS_UNEXP_ERROR);
45: END IF;
46:
47: OKC_API.init_msg_list(p_init_msg_list);
48:
49: x_return_status := OKC_API.G_RET_STS_SUCCESS;
50: RETURN(OKC_API.G_RET_STS_SUCCESS);
51: END start_activity;

Line 49: x_return_status := OKC_API.G_RET_STS_SUCCESS;

45: END IF;
46:
47: OKC_API.init_msg_list(p_init_msg_list);
48:
49: x_return_status := OKC_API.G_RET_STS_SUCCESS;
50: RETURN(OKC_API.G_RET_STS_SUCCESS);
51: END start_activity;
52: FUNCTION start_activity(
53: p_api_name IN VARCHAR2,

Line 50: RETURN(OKC_API.G_RET_STS_SUCCESS);

46:
47: OKC_API.init_msg_list(p_init_msg_list);
48:
49: x_return_status := OKC_API.G_RET_STS_SUCCESS;
50: RETURN(OKC_API.G_RET_STS_SUCCESS);
51: END start_activity;
52: FUNCTION start_activity(
53: p_api_name IN VARCHAR2,
54: p_init_msg_list IN VARCHAR2,

Line 62: OKC_API.init_msg_list(p_init_msg_list);

58: BEGIN
59: -- Standard START OF API SAVEPOINT
60:
61: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
62: OKC_API.init_msg_list(p_init_msg_list);
63:
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: RETURN(OKC_API.G_RET_STS_SUCCESS);
66: END start_activity;

Line 64: x_return_status := OKC_API.G_RET_STS_SUCCESS;

60:
61: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
62: OKC_API.init_msg_list(p_init_msg_list);
63:
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: RETURN(OKC_API.G_RET_STS_SUCCESS);
66: END start_activity;
67: --------------------------------------------------------------------------------
68: -- FUNCTION handle_exceptions

Line 65: RETURN(OKC_API.G_RET_STS_SUCCESS);

61: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
62: OKC_API.init_msg_list(p_init_msg_list);
63:
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: RETURN(OKC_API.G_RET_STS_SUCCESS);
66: END start_activity;
67: --------------------------------------------------------------------------------
68: -- FUNCTION handle_exceptions
69: --------------------------------------------------------------------------------

Line 78: l_return_value VARCHAR2(200) := OKC_API.G_RET_STS_UNEXP_ERROR;

74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_api_type IN VARCHAR2
77: ) RETURN VARCHAR2 IS
78: l_return_value VARCHAR2(200) := OKC_API.G_RET_STS_UNEXP_ERROR;
79: BEGIN
80: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
81: IF p_exc_name = 'OKC_API.G_RET_STS_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get

Line 81: IF p_exc_name = 'OKC_API.G_RET_STS_ERROR' THEN

77: ) RETURN VARCHAR2 IS
78: l_return_value VARCHAR2(200) := OKC_API.G_RET_STS_UNEXP_ERROR;
79: BEGIN
80: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
81: IF p_exc_name = 'OKC_API.G_RET_STS_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get
83: (
84: p_count => x_msg_count,
85: p_data => x_msg_data

Line 87: l_return_value := OKC_API.G_RET_STS_ERROR;

83: (
84: p_count => x_msg_count,
85: p_data => x_msg_data
86: );
87: l_return_value := OKC_API.G_RET_STS_ERROR;
88: ELSIF p_exc_name = 'OKC_API.G_RET_STS_UNEXP_ERROR' THEN
89: FND_MSG_PUB.Count_And_Get
90: (
91: p_count => x_msg_count,

Line 88: ELSIF p_exc_name = 'OKC_API.G_RET_STS_UNEXP_ERROR' THEN

84: p_count => x_msg_count,
85: p_data => x_msg_data
86: );
87: l_return_value := OKC_API.G_RET_STS_ERROR;
88: ELSIF p_exc_name = 'OKC_API.G_RET_STS_UNEXP_ERROR' THEN
89: FND_MSG_PUB.Count_And_Get
90: (
91: p_count => x_msg_count,
92: p_data => x_msg_data

Line 197: END OKC_API;

193: FND_MSG_PUB.add;
194: END set_message;
195:
196:
197: END OKC_API;