DBA Data[Home] [Help]

APPS.OKL_API dependencies on OKL_API

Line 1: PACKAGE BODY OKL_API AS

1: PACKAGE BODY OKL_API AS
2: /* $Header: OKLPAPIB.pls 120.4 2007/10/03 20:51:28 rmunjulu ship $ */
3: --------------------------------------------------------------------------------
4: -- MESSAGE CONSTANTS
5: --------------------------------------------------------------------------------

Line 2: /* $Header: OKLPAPIB.pls 120.4 2007/10/03 20:51:28 rmunjulu ship $ */

1: PACKAGE BODY OKL_API AS
2: /* $Header: OKLPAPIB.pls 120.4 2007/10/03 20:51:28 rmunjulu ship $ */
3: --------------------------------------------------------------------------------
4: -- MESSAGE CONSTANTS
5: --------------------------------------------------------------------------------
6: G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := OKL_API.G_MISS_NUM;

Line 6: G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := OKL_API.G_MISS_NUM;

2: /* $Header: OKLPAPIB.pls 120.4 2007/10/03 20:51:28 rmunjulu ship $ */
3: --------------------------------------------------------------------------------
4: -- MESSAGE CONSTANTS
5: --------------------------------------------------------------------------------
6: G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := OKL_API.G_MISS_NUM;
7: --------------------------------------------------------------------------------
8: -- PROCEDURE init_msg_list
9: --------------------------------------------------------------------------------
10: PROCEDURE init_msg_list (

Line 19: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 41: RETURN(OKL_API.G_RET_STS_UNEXP_ERROR);

37: p_api_version,
38: p_api_name,
39: p_pkg_name)
40: THEN
41: RETURN(OKL_API.G_RET_STS_UNEXP_ERROR);
42: END IF;
43: OKL_API.init_msg_list(p_init_msg_list);
44: x_return_status := OKL_API.G_RET_STS_SUCCESS;
45: RETURN(OKL_API.G_RET_STS_SUCCESS);

Line 43: OKL_API.init_msg_list(p_init_msg_list);

39: p_pkg_name)
40: THEN
41: RETURN(OKL_API.G_RET_STS_UNEXP_ERROR);
42: END IF;
43: OKL_API.init_msg_list(p_init_msg_list);
44: x_return_status := OKL_API.G_RET_STS_SUCCESS;
45: RETURN(OKL_API.G_RET_STS_SUCCESS);
46: END start_activity;
47: FUNCTION start_activity(

Line 44: x_return_status := OKL_API.G_RET_STS_SUCCESS;

40: THEN
41: RETURN(OKL_API.G_RET_STS_UNEXP_ERROR);
42: END IF;
43: OKL_API.init_msg_list(p_init_msg_list);
44: x_return_status := OKL_API.G_RET_STS_SUCCESS;
45: RETURN(OKL_API.G_RET_STS_SUCCESS);
46: END start_activity;
47: FUNCTION start_activity(
48: p_api_name IN VARCHAR2,

Line 45: RETURN(OKL_API.G_RET_STS_SUCCESS);

41: RETURN(OKL_API.G_RET_STS_UNEXP_ERROR);
42: END IF;
43: OKL_API.init_msg_list(p_init_msg_list);
44: x_return_status := OKL_API.G_RET_STS_SUCCESS;
45: RETURN(OKL_API.G_RET_STS_SUCCESS);
46: END start_activity;
47: FUNCTION start_activity(
48: p_api_name IN VARCHAR2,
49: p_init_msg_list IN VARCHAR2,

Line 56: OKL_API.init_msg_list(p_init_msg_list);

52: ) RETURN VARCHAR2 IS
53: BEGIN
54: -- Standard START OF API SAVEPOINT
55: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
56: OKL_API.init_msg_list(p_init_msg_list);
57: x_return_status := OKL_API.G_RET_STS_SUCCESS;
58: RETURN(OKL_API.G_RET_STS_SUCCESS);
59: END start_activity;
60: --------------------------------------------------------------------------------

Line 57: x_return_status := OKL_API.G_RET_STS_SUCCESS;

53: BEGIN
54: -- Standard START OF API SAVEPOINT
55: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
56: OKL_API.init_msg_list(p_init_msg_list);
57: x_return_status := OKL_API.G_RET_STS_SUCCESS;
58: RETURN(OKL_API.G_RET_STS_SUCCESS);
59: END start_activity;
60: --------------------------------------------------------------------------------
61: -- FUNCTION handle_exceptions

Line 58: RETURN(OKL_API.G_RET_STS_SUCCESS);

54: -- Standard START OF API SAVEPOINT
55: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
56: OKL_API.init_msg_list(p_init_msg_list);
57: x_return_status := OKL_API.G_RET_STS_SUCCESS;
58: RETURN(OKL_API.G_RET_STS_SUCCESS);
59: END start_activity;
60: --------------------------------------------------------------------------------
61: -- FUNCTION handle_exceptions
62: --------------------------------------------------------------------------------

Line 71: l_return_value VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;

67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_api_type IN VARCHAR2
70: ) RETURN VARCHAR2 IS
71: l_return_value VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
72: BEGIN
73: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
74: IF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_ERROR' THEN
75: FND_MSG_PUB.Count_And_Get

Line 74: IF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_ERROR' THEN

70: ) RETURN VARCHAR2 IS
71: l_return_value VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
72: BEGIN
73: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
74: IF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_ERROR' THEN
75: FND_MSG_PUB.Count_And_Get
76: (
77: p_count => x_msg_count,
78: p_data => x_msg_data

Line 80: l_return_value := OKL_API.G_RET_STS_ERROR;

76: (
77: p_count => x_msg_count,
78: p_data => x_msg_data
79: );
80: l_return_value := OKL_API.G_RET_STS_ERROR;
81: ELSIF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_UNEXP_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get
83: (
84: p_count => x_msg_count,

Line 81: ELSIF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_UNEXP_ERROR' THEN

77: p_count => x_msg_count,
78: p_data => x_msg_data
79: );
80: l_return_value := OKL_API.G_RET_STS_ERROR;
81: ELSIF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_UNEXP_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get
83: (
84: p_count => x_msg_count,
85: p_data => x_msg_data

Line 121: p_app_name IN VARCHAR2 DEFAULT OKL_API.G_APP_NAME,

117: --------------------------------------------------------------------------------
118: -- PROCEDURE set_message
119: --------------------------------------------------------------------------------
120: PROCEDURE set_message (
121: p_app_name IN VARCHAR2 DEFAULT OKL_API.G_APP_NAME,
122: p_msg_name IN VARCHAR2,
123: p_token1 IN VARCHAR2 DEFAULT NULL,
124: p_token1_value IN VARCHAR2 DEFAULT NULL,
125: p_token2 IN VARCHAR2 DEFAULT NULL,

Line 228: END OKL_API;

224: RETURN NULL;
225:
226: END get_customer_baseline;
227:
228: END OKL_API;