APPS.OKL_RGRP_RULES_PROCESS_PUB dependencies on OKC_API

Line 11: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

7:
8:
9: PROCEDURE process_rule_group_rules(
10: p_api_version IN NUMBER,
11: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_chr_id IN NUMBER,

Line 31: x_return_status := OKC_API.G_RET_STS_SUCCESS;

27: l_proc_name VARCHAR2(35) := 'PROCESS_RULE_GROUP_RULES';
28: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
29:
30: BEGIN
31: x_return_status := OKC_API.G_RET_STS_SUCCESS;
32: -- call START_ACTIVITY to create savepoint, check compatibility
33: -- and initialize message list
34: x_return_status := OKC_API.START_ACTIVITY(
35: p_api_name => l_api_name,

Line 34: x_return_status := OKC_API.START_ACTIVITY(

30: BEGIN
31: x_return_status := OKC_API.G_RET_STS_SUCCESS;
32: -- call START_ACTIVITY to create savepoint, check compatibility
33: -- and initialize message list
34: x_return_status := OKC_API.START_ACTIVITY(
35: p_api_name => l_api_name,
36: p_pkg_name => G_PKG_NAME,
37: p_init_msg_list => p_init_msg_list,
38: l_api_version => l_api_version,

Line 44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

40: p_api_type => G_API_TYPE,
41: x_return_status => x_return_status);
42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;

Line 45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

41: x_return_status => x_return_status);
42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:

Line 46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50:

Line 47: raise OKC_API.G_EXCEPTION_ERROR;

43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50:
51: OKL_RGRP_RULES_PROCESS_PVT.process_rule_group_rules(

Line 63: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

59: p_cpl_id => p_cpl_id,
60: p_rrd_id => p_rrd_id,
61: p_rgr_tbl => p_rgr_tbl);
62:
63: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;
66:
67: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 64: RAISE OKC_API.G_EXCEPTION_ERROR;

60: p_rrd_id => p_rrd_id,
61: p_rgr_tbl => p_rgr_tbl);
62:
63: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;
66:
67: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
68: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 72: when OKC_API.G_EXCEPTION_ERROR then

68: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
69: x_msg_data => x_msg_data);
70:
71: EXCEPTION
72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

69: x_msg_data => x_msg_data);
70:
71: EXCEPTION
72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
77: x_msg_count => x_msg_count,

Line 76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:

Line 81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:
81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:
81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count => x_msg_count,

Line 85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count => x_msg_count,
87: x_msg_data => x_msg_data,
88: p_api_type => G_API_TYPE);
89:

Line 91: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

87: x_msg_data => x_msg_data,
88: p_api_type => G_API_TYPE);
89:
90: when OTHERS then
91: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
92: p_api_name => l_api_name,
93: p_pkg_name => G_PKG_NAME,
94: p_exc_name => 'OTHERS',
95: x_msg_count => x_msg_count,

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: END process_rule_group_rules;
100:
101: PROCEDURE process_template_rules(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_id IN NUMBER,

Line 122: x_return_status := OKC_API.G_RET_STS_SUCCESS;

118: l_proc_name VARCHAR2(35) := 'PROCESS_TEMPLATE_RULES';
119:
120: BEGIN
121:
122: x_return_status := OKC_API.G_RET_STS_SUCCESS;
123: -- call START_ACTIVITY to create savepoint, check compatibility
124: -- and initialize message list
125: x_return_status := OKC_API.START_ACTIVITY(
126: p_api_name => l_api_name,

Line 125: x_return_status := OKC_API.START_ACTIVITY(

121:
122: x_return_status := OKC_API.G_RET_STS_SUCCESS;
123: -- call START_ACTIVITY to create savepoint, check compatibility
124: -- and initialize message list
125: x_return_status := OKC_API.START_ACTIVITY(
126: p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_init_msg_list => p_init_msg_list,
129: l_api_version => l_api_version,

Line 135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

131: p_api_type => G_API_TYPE,
132: x_return_status => x_return_status);
133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;

Line 136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

132: x_return_status => x_return_status);
133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:

Line 137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141:

Line 138: raise OKC_API.G_EXCEPTION_ERROR;

134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141:
142: OKL_RGRP_RULES_PROCESS_PVT.process_template_rules(

Line 153: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

149: p_rgr_tbl => p_rgr_tbl,
150: x_rgr_tbl => x_rgr_tbl);
151:
152:
153: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 154: RAISE OKC_API.G_EXCEPTION_ERROR;

150: x_rgr_tbl => x_rgr_tbl);
151:
152:
153: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
158: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 162: when OKC_API.G_EXCEPTION_ERROR then

158: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
159: x_msg_data => x_msg_data);
160:
161: EXCEPTION
162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

159: x_msg_data => x_msg_data);
160:
161: EXCEPTION
162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
167: x_msg_count => x_msg_count,

Line 166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:

Line 171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:
171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:
171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
176: x_msg_count => x_msg_count,

Line 175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
176: x_msg_count => x_msg_count,
177: x_msg_data => x_msg_data,
178: p_api_type => G_API_TYPE);
179:

Line 181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

177: x_msg_data => x_msg_data,
178: p_api_type => G_API_TYPE);
179:
180: when OTHERS then
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
182: p_api_name => l_api_name,
183: p_pkg_name => G_PKG_NAME,
184: p_exc_name => 'OTHERS',
185: x_msg_count => x_msg_count,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: END process_template_rules;
190:
191: FUNCTION get_header_rule_group_id(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_chr_id IN NUMBER,