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.OKL_SETUPCGRPARAMETERS_PVT dependencies on OKC_API

Line 136: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

132: x_cgmv_rec OUT NOCOPY cgmv_rec_type
133: ) IS
134: l_api_version CONSTANT NUMBER := 1;
135: l_api_name CONSTANT VARCHAR2(30) := 'insert_cgrparameters';
136: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
137: l_cgmv_rec cgmv_rec_type;
138: BEGIN
139: x_return_status := OKC_API.G_RET_STS_SUCCESS;
140: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

Line 139: x_return_status := OKC_API.G_RET_STS_SUCCESS;

135: l_api_name CONSTANT VARCHAR2(30) := 'insert_cgrparameters';
136: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
137: l_cgmv_rec cgmv_rec_type;
138: BEGIN
139: x_return_status := OKC_API.G_RET_STS_SUCCESS;
140: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
141: p_pkg_name => G_PKG_NAME,
142: p_init_msg_list => p_init_msg_list,
143: l_api_version => l_api_version,

Line 140: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

136: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
137: l_cgmv_rec cgmv_rec_type;
138: BEGIN
139: x_return_status := OKC_API.G_RET_STS_SUCCESS;
140: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
141: p_pkg_name => G_PKG_NAME,
142: p_init_msg_list => p_init_msg_list,
143: l_api_version => l_api_version,
144: p_api_version => p_api_version,

Line 147: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

143: l_api_version => l_api_version,
144: p_api_version => p_api_version,
145: p_api_type => '_PVT',
146: x_return_status => l_return_status);
147: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;

Line 148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

144: p_api_version => p_api_version,
145: p_api_type => '_PVT',
146: x_return_status => l_return_status);
147: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152:

Line 149: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

145: p_api_type => '_PVT',
146: x_return_status => l_return_status);
147: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: l_cgmv_rec := p_cgmv_rec;

Line 150: RAISE OKC_API.G_EXCEPTION_ERROR;

146: x_return_status => l_return_status);
147: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: l_cgmv_rec := p_cgmv_rec;
154:

Line 164: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

160: x_msg_data => x_msg_data,
161: p_cgmv_rec => l_cgmv_rec,
162: x_cgmv_rec => x_cgmv_rec);
163:
164: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
165: RAISE OKC_API.G_EXCEPTION_ERROR;
166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: END IF;

Line 165: RAISE OKC_API.G_EXCEPTION_ERROR;

161: p_cgmv_rec => l_cgmv_rec,
162: x_cgmv_rec => x_cgmv_rec);
163:
164: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
165: RAISE OKC_API.G_EXCEPTION_ERROR;
166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: END IF;
169:

Line 166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

162: x_cgmv_rec => x_cgmv_rec);
163:
164: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
165: RAISE OKC_API.G_EXCEPTION_ERROR;
166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: END IF;
169:
170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

163:
164: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
165: RAISE OKC_API.G_EXCEPTION_ERROR;
166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: END IF;
169:
170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data);

Line 170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

166: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: END IF;
169:
170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data);
172: EXCEPTION
173: WHEN OKC_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 173: WHEN OKC_API.G_EXCEPTION_ERROR THEN

169:
170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data);
172: EXCEPTION
173: WHEN OKC_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
175: p_pkg_name => G_PKG_NAME,
176: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count => x_msg_count,

Line 174: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

170: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data);
172: EXCEPTION
173: WHEN OKC_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
175: p_pkg_name => G_PKG_NAME,
176: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data,

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

172: EXCEPTION
173: WHEN OKC_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
175: p_pkg_name => G_PKG_NAME,
176: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data,
179: p_api_type => '_PVT');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

176: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data,
179: p_api_type => '_PVT');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
182: p_pkg_name => G_PKG_NAME,
183: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
184: x_msg_count => x_msg_count,

Line 181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data,
179: p_api_type => '_PVT');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
182: p_pkg_name => G_PKG_NAME,
183: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,

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

179: p_api_type => '_PVT');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
182: p_pkg_name => G_PKG_NAME,
183: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,
186: p_api_type => '_PVT');
187: WHEN OTHERS THEN

Line 188: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,
186: p_api_type => '_PVT');
187: WHEN OTHERS THEN
188: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
189: p_pkg_name => G_PKG_NAME,
190: p_exc_name => 'OTHERS',
191: x_msg_count => x_msg_count,
192: x_msg_data => x_msg_data,

Line 210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

206: x_cgmv_rec OUT NOCOPY cgmv_rec_type
207: ) IS
208: l_api_version CONSTANT NUMBER := 1;
209: l_api_name CONSTANT VARCHAR2(30) := 'update_cgrparameters';
210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
211: l_valid BOOLEAN;
212: l_cgmv_rec cgmv_rec_type;
213: BEGIN
214: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 214: x_return_status := OKC_API.G_RET_STS_SUCCESS;

210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
211: l_valid BOOLEAN;
212: l_cgmv_rec cgmv_rec_type;
213: BEGIN
214: x_return_status := OKC_API.G_RET_STS_SUCCESS;
215: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
216: p_pkg_name => G_PKG_NAME,
217: p_init_msg_list => p_init_msg_list,
218: l_api_version => l_api_version,

Line 215: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

211: l_valid BOOLEAN;
212: l_cgmv_rec cgmv_rec_type;
213: BEGIN
214: x_return_status := OKC_API.G_RET_STS_SUCCESS;
215: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
216: p_pkg_name => G_PKG_NAME,
217: p_init_msg_list => p_init_msg_list,
218: l_api_version => l_api_version,
219: p_api_version => p_api_version,

Line 222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

218: l_api_version => l_api_version,
219: p_api_version => p_api_version,
220: p_api_type => '_PVT',
221: x_return_status => l_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;

Line 223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

219: p_api_version => p_api_version,
220: p_api_type => '_PVT',
221: x_return_status => l_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227:

Line 224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

220: p_api_type => '_PVT',
221: x_return_status => l_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227:
228: l_cgmv_rec := p_cgmv_rec;

Line 225: RAISE OKC_API.G_EXCEPTION_ERROR;

221: x_return_status => l_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227:
228: l_cgmv_rec := p_cgmv_rec;
229:

Line 235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

231: check_context_groups(p_cgmv_rec => l_cgmv_rec,
232: x_return_status => l_return_status,
233: x_valid => l_valid);
234: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN
239: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 240: RAISE OKC_API.G_EXCEPTION_ERROR;

236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN
239: x_return_status := OKL_API.G_RET_STS_ERROR;
240: RAISE OKC_API.G_EXCEPTION_ERROR;
241: END IF;
242:
243: /* public api to update context groups */
244: okl_cntx_grp_prmtrs_pub.update_cntx_grp_prmtrs(p_api_version => p_api_version,

Line 252: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

248: x_msg_data => x_msg_data,
249: p_cgmv_rec => l_cgmv_rec,
250: x_cgmv_rec => x_cgmv_rec);
251:
252: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: END IF;

Line 253: RAISE OKC_API.G_EXCEPTION_ERROR;

249: p_cgmv_rec => l_cgmv_rec,
250: x_cgmv_rec => x_cgmv_rec);
251:
252: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: END IF;
257:

Line 254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

250: x_cgmv_rec => x_cgmv_rec);
251:
252: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: END IF;
257:
258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

251:
252: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: END IF;
257:
258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
259: x_msg_data => x_msg_data);

Line 258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

254: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: END IF;
257:
258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
259: x_msg_data => x_msg_data);
260: EXCEPTION
261: WHEN OKC_API.G_EXCEPTION_ERROR THEN
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 261: WHEN OKC_API.G_EXCEPTION_ERROR THEN

257:
258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
259: x_msg_data => x_msg_data);
260: EXCEPTION
261: WHEN OKC_API.G_EXCEPTION_ERROR THEN
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
263: p_pkg_name => G_PKG_NAME,
264: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
265: x_msg_count => x_msg_count,

Line 262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

258: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
259: x_msg_data => x_msg_data);
260: EXCEPTION
261: WHEN OKC_API.G_EXCEPTION_ERROR THEN
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
263: p_pkg_name => G_PKG_NAME,
264: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data,

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

260: EXCEPTION
261: WHEN OKC_API.G_EXCEPTION_ERROR THEN
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
263: p_pkg_name => G_PKG_NAME,
264: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data,
267: p_api_type => '_PVT');
268: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 268: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

264: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data,
267: p_api_type => '_PVT');
268: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
270: p_pkg_name => G_PKG_NAME,
271: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
272: x_msg_count => x_msg_count,

Line 269: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data,
267: p_api_type => '_PVT');
268: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
270: p_pkg_name => G_PKG_NAME,
271: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
272: x_msg_count => x_msg_count,
273: x_msg_data => x_msg_data,

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

267: p_api_type => '_PVT');
268: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
270: p_pkg_name => G_PKG_NAME,
271: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
272: x_msg_count => x_msg_count,
273: x_msg_data => x_msg_data,
274: p_api_type => '_PVT');
275: WHEN OTHERS THEN

Line 276: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

272: x_msg_count => x_msg_count,
273: x_msg_data => x_msg_data,
274: p_api_type => '_PVT');
275: WHEN OTHERS THEN
276: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
277: p_pkg_name => G_PKG_NAME,
278: p_exc_name => 'OTHERS',
279: x_msg_count => x_msg_count,
280: x_msg_data => x_msg_data,

Line 300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

296: ) IS
297: l_api_version CONSTANT NUMBER := 1;
298: l_cgmv_tbl cgmv_tbl_type;
299: l_api_name CONSTANT VARCHAR2(30) := 'delete_cgrparameters';
300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
301: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
302: l_valid BOOLEAN;
303: i NUMBER;
304:

Line 301: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

297: l_api_version CONSTANT NUMBER := 1;
298: l_cgmv_tbl cgmv_tbl_type;
299: l_api_name CONSTANT VARCHAR2(30) := 'delete_cgrparameters';
300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
301: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
302: l_valid BOOLEAN;
303: i NUMBER;
304:
305: BEGIN

Line 306: x_return_status := OKC_API.G_RET_STS_SUCCESS;

302: l_valid BOOLEAN;
303: i NUMBER;
304:
305: BEGIN
306: x_return_status := OKC_API.G_RET_STS_SUCCESS;
307: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_init_msg_list => p_init_msg_list,
310: l_api_version => l_api_version,

Line 307: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

303: i NUMBER;
304:
305: BEGIN
306: x_return_status := OKC_API.G_RET_STS_SUCCESS;
307: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_init_msg_list => p_init_msg_list,
310: l_api_version => l_api_version,
311: p_api_version => p_api_version,

Line 314: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

310: l_api_version => l_api_version,
311: p_api_version => p_api_version,
312: p_api_type => '_PVT',
313: x_return_status => l_return_status);
314: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
317: RAISE OKC_API.G_EXCEPTION_ERROR;
318: END IF;

Line 315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

311: p_api_version => p_api_version,
312: p_api_type => '_PVT',
313: x_return_status => l_return_status);
314: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
317: RAISE OKC_API.G_EXCEPTION_ERROR;
318: END IF;
319:

Line 316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

312: p_api_type => '_PVT',
313: x_return_status => l_return_status);
314: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
317: RAISE OKC_API.G_EXCEPTION_ERROR;
318: END IF;
319:
320: l_cgmv_tbl := p_cgmv_tbl;

Line 317: RAISE OKC_API.G_EXCEPTION_ERROR;

313: x_return_status => l_return_status);
314: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
317: RAISE OKC_API.G_EXCEPTION_ERROR;
318: END IF;
319:
320: l_cgmv_tbl := p_cgmv_tbl;
321: IF (l_cgmv_tbl.COUNT > 0) THEN

Line 344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

340: -- return overall status
341: l_return_status := l_overall_status;
342: END IF;
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN
348: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 349: RAISE OKC_API.G_EXCEPTION_ERROR;

345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN
348: x_return_status := OKL_API.G_RET_STS_ERROR;
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: /* delete context group parameters */
353: okl_cntx_grp_prmtrs_pub.delete_cntx_grp_prmtrs(p_api_version => p_api_version,

Line 360: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

356: x_msg_count => x_msg_count,
357: x_msg_data => x_msg_data,
358: p_cgmv_tbl => l_cgmv_tbl);
359:
360: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: END IF;

Line 361: RAISE OKC_API.G_EXCEPTION_ERROR;

357: x_msg_data => x_msg_data,
358: p_cgmv_tbl => l_cgmv_tbl);
359:
360: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: END IF;
365:

Line 362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

358: p_cgmv_tbl => l_cgmv_tbl);
359:
360: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: END IF;
365:
366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

359:
360: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: END IF;
365:
366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data);

Line 366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

362: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: END IF;
365:
366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data);
368: EXCEPTION
369: WHEN OKC_API.G_EXCEPTION_ERROR THEN
370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 369: WHEN OKC_API.G_EXCEPTION_ERROR THEN

365:
366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data);
368: EXCEPTION
369: WHEN OKC_API.G_EXCEPTION_ERROR THEN
370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
371: p_pkg_name => G_PKG_NAME,
372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
373: x_msg_count => x_msg_count,

Line 370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

366: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data);
368: EXCEPTION
369: WHEN OKC_API.G_EXCEPTION_ERROR THEN
370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
371: p_pkg_name => G_PKG_NAME,
372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data,

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

368: EXCEPTION
369: WHEN OKC_API.G_EXCEPTION_ERROR THEN
370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
371: p_pkg_name => G_PKG_NAME,
372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data,
375: p_api_type => '_PVT');
376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data,
375: p_api_type => '_PVT');
376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
378: p_pkg_name => G_PKG_NAME,
379: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
380: x_msg_count => x_msg_count,

Line 377: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data,
375: p_api_type => '_PVT');
376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
378: p_pkg_name => G_PKG_NAME,
379: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data,

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

375: p_api_type => '_PVT');
376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
378: p_pkg_name => G_PKG_NAME,
379: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data,
382: p_api_type => '_PVT');
383: WHEN OTHERS THEN

Line 384: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data,
382: p_api_type => '_PVT');
383: WHEN OTHERS THEN
384: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
385: p_pkg_name => G_PKG_NAME,
386: p_exc_name => 'OTHERS',
387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data,

Line 407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

403: x_cgmv_tbl OUT NOCOPY cgmv_tbl_type
404: ) IS
405: l_api_version CONSTANT NUMBER := 1;
406: l_api_name CONSTANT VARCHAR2(30) := 'insert_cgrparameters';
407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
408: l_cgmv_rec cgmv_rec_type;
409: i NUMBER := 0;
410: BEGIN
411: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 411: x_return_status := OKC_API.G_RET_STS_SUCCESS;

407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
408: l_cgmv_rec cgmv_rec_type;
409: i NUMBER := 0;
410: BEGIN
411: x_return_status := OKC_API.G_RET_STS_SUCCESS;
412: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
413: p_pkg_name => G_PKG_NAME,
414: p_init_msg_list => p_init_msg_list,
415: l_api_version => l_api_version,

Line 412: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

408: l_cgmv_rec cgmv_rec_type;
409: i NUMBER := 0;
410: BEGIN
411: x_return_status := OKC_API.G_RET_STS_SUCCESS;
412: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
413: p_pkg_name => G_PKG_NAME,
414: p_init_msg_list => p_init_msg_list,
415: l_api_version => l_api_version,
416: p_api_version => p_api_version,

Line 419: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

415: l_api_version => l_api_version,
416: p_api_version => p_api_version,
417: p_api_type => '_PVT',
418: x_return_status => l_return_status);
419: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
420: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
421: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
422: RAISE OKC_API.G_EXCEPTION_ERROR;
423: END IF;

Line 420: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

416: p_api_version => p_api_version,
417: p_api_type => '_PVT',
418: x_return_status => l_return_status);
419: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
420: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
421: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
422: RAISE OKC_API.G_EXCEPTION_ERROR;
423: END IF;
424:

Line 421: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

417: p_api_type => '_PVT',
418: x_return_status => l_return_status);
419: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
420: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
421: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
422: RAISE OKC_API.G_EXCEPTION_ERROR;
423: END IF;
424:
425: IF (p_cgmv_tbl.COUNT > 0) THEN

Line 422: RAISE OKC_API.G_EXCEPTION_ERROR;

418: x_return_status => l_return_status);
419: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
420: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
421: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
422: RAISE OKC_API.G_EXCEPTION_ERROR;
423: END IF;
424:
425: IF (p_cgmv_tbl.COUNT > 0) THEN
426: i := p_cgmv_tbl.FIRST;

Line 439: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

435: x_msg_data => x_msg_data,
436: p_cgmv_rec => l_cgmv_rec,
437: x_cgmv_rec => x_cgmv_tbl(i));
438:
439: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
440: RAISE OKC_API.G_EXCEPTION_ERROR;
441: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: END IF;

Line 440: RAISE OKC_API.G_EXCEPTION_ERROR;

436: p_cgmv_rec => l_cgmv_rec,
437: x_cgmv_rec => x_cgmv_tbl(i));
438:
439: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
440: RAISE OKC_API.G_EXCEPTION_ERROR;
441: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: END IF;
444:

Line 441: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

437: x_cgmv_rec => x_cgmv_tbl(i));
438:
439: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
440: RAISE OKC_API.G_EXCEPTION_ERROR;
441: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: END IF;
444:
445: EXIT WHEN (i = p_cgmv_tbl.LAST);

Line 442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

438:
439: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
440: RAISE OKC_API.G_EXCEPTION_ERROR;
441: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: END IF;
444:
445: EXIT WHEN (i = p_cgmv_tbl.LAST);
446: i := p_cgmv_tbl.NEXT(i);

Line 451: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

447: END LOOP;
448:
449: END IF;
450:
451: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
452: x_msg_data => x_msg_data);
453: EXCEPTION
454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
455: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 454: WHEN OKC_API.G_EXCEPTION_ERROR THEN

450:
451: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
452: x_msg_data => x_msg_data);
453: EXCEPTION
454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
455: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
456: p_pkg_name => G_PKG_NAME,
457: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
458: x_msg_count => x_msg_count,

Line 455: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

451: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
452: x_msg_data => x_msg_data);
453: EXCEPTION
454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
455: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
456: p_pkg_name => G_PKG_NAME,
457: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,

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

453: EXCEPTION
454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
455: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
456: p_pkg_name => G_PKG_NAME,
457: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,
460: p_api_type => '_PVT');
461: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 461: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

457: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,
460: p_api_type => '_PVT');
461: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
462: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
463: p_pkg_name => G_PKG_NAME,
464: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
465: x_msg_count => x_msg_count,

Line 462: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,
460: p_api_type => '_PVT');
461: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
462: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
463: p_pkg_name => G_PKG_NAME,
464: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,

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

460: p_api_type => '_PVT');
461: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
462: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
463: p_pkg_name => G_PKG_NAME,
464: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,
467: p_api_type => '_PVT');
468: WHEN OTHERS THEN

Line 469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,
467: p_api_type => '_PVT');
468: WHEN OTHERS THEN
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_exc_name => 'OTHERS',
472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data,

Line 493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

489: x_cgmv_tbl OUT NOCOPY cgmv_tbl_type
490: ) IS
491: l_api_version CONSTANT NUMBER := 1;
492: l_api_name CONSTANT VARCHAR2(30) := 'update_cgrparameters';
493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: l_valid BOOLEAN;
495: l_cgmv_rec cgmv_rec_type;
496: i NUMBER := 0;
497: BEGIN

Line 498: x_return_status := OKC_API.G_RET_STS_SUCCESS;

494: l_valid BOOLEAN;
495: l_cgmv_rec cgmv_rec_type;
496: i NUMBER := 0;
497: BEGIN
498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
499: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
500: p_pkg_name => G_PKG_NAME,
501: p_init_msg_list => p_init_msg_list,
502: l_api_version => l_api_version,

Line 499: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

495: l_cgmv_rec cgmv_rec_type;
496: i NUMBER := 0;
497: BEGIN
498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
499: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
500: p_pkg_name => G_PKG_NAME,
501: p_init_msg_list => p_init_msg_list,
502: l_api_version => l_api_version,
503: p_api_version => p_api_version,

Line 506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

502: l_api_version => l_api_version,
503: p_api_version => p_api_version,
504: p_api_type => '_PVT',
505: x_return_status => l_return_status);
506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
508: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
509: RAISE OKC_API.G_EXCEPTION_ERROR;
510: END IF;

Line 507: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

503: p_api_version => p_api_version,
504: p_api_type => '_PVT',
505: x_return_status => l_return_status);
506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
508: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
509: RAISE OKC_API.G_EXCEPTION_ERROR;
510: END IF;
511:

Line 508: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

504: p_api_type => '_PVT',
505: x_return_status => l_return_status);
506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
508: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
509: RAISE OKC_API.G_EXCEPTION_ERROR;
510: END IF;
511:
512:

Line 509: RAISE OKC_API.G_EXCEPTION_ERROR;

505: x_return_status => l_return_status);
506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
508: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
509: RAISE OKC_API.G_EXCEPTION_ERROR;
510: END IF;
511:
512:
513: IF (p_cgmv_tbl.COUNT > 0) THEN

Line 524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

520: check_context_groups(p_cgmv_rec => l_cgmv_rec,
521: x_return_status => l_return_status,
522: x_valid => l_valid);
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN
528: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 529: RAISE OKC_API.G_EXCEPTION_ERROR;

525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN
528: x_return_status := OKL_API.G_RET_STS_ERROR;
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531:
532: /* public api to update context groups */
533: okl_cntx_grp_prmtrs_pub.update_cntx_grp_prmtrs(p_api_version => p_api_version,

Line 541: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

537: x_msg_data => x_msg_data,
538: p_cgmv_rec => l_cgmv_rec,
539: x_cgmv_rec => x_cgmv_tbl(i));
540:
541: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: END IF;

Line 542: RAISE OKC_API.G_EXCEPTION_ERROR;

538: p_cgmv_rec => l_cgmv_rec,
539: x_cgmv_rec => x_cgmv_tbl(i));
540:
541: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: END IF;
546:

Line 543: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

539: x_cgmv_rec => x_cgmv_tbl(i));
540:
541: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: END IF;
546:
547: EXIT WHEN (i = p_cgmv_tbl.LAST);

Line 544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

540:
541: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: END IF;
546:
547: EXIT WHEN (i = p_cgmv_tbl.LAST);
548: i := p_cgmv_tbl.NEXT(i);

Line 553: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

549: END LOOP;
550:
551: END IF;
552:
553: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
554: x_msg_data => x_msg_data);
555: EXCEPTION
556: WHEN OKC_API.G_EXCEPTION_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 556: WHEN OKC_API.G_EXCEPTION_ERROR THEN

552:
553: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
554: x_msg_data => x_msg_data);
555: EXCEPTION
556: WHEN OKC_API.G_EXCEPTION_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
558: p_pkg_name => G_PKG_NAME,
559: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
560: x_msg_count => x_msg_count,

Line 557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

553: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
554: x_msg_data => x_msg_data);
555: EXCEPTION
556: WHEN OKC_API.G_EXCEPTION_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
558: p_pkg_name => G_PKG_NAME,
559: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
560: x_msg_count => x_msg_count,
561: x_msg_data => x_msg_data,

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

555: EXCEPTION
556: WHEN OKC_API.G_EXCEPTION_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
558: p_pkg_name => G_PKG_NAME,
559: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
560: x_msg_count => x_msg_count,
561: x_msg_data => x_msg_data,
562: p_api_type => '_PVT');
563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

559: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
560: x_msg_count => x_msg_count,
561: x_msg_data => x_msg_data,
562: p_api_type => '_PVT');
563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
565: p_pkg_name => G_PKG_NAME,
566: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
567: x_msg_count => x_msg_count,

Line 564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

560: x_msg_count => x_msg_count,
561: x_msg_data => x_msg_data,
562: p_api_type => '_PVT');
563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
565: p_pkg_name => G_PKG_NAME,
566: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
567: x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data,

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

562: p_api_type => '_PVT');
563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
565: p_pkg_name => G_PKG_NAME,
566: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
567: x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data,
569: p_api_type => '_PVT');
570: WHEN OTHERS THEN

Line 571: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

567: x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data,
569: p_api_type => '_PVT');
570: WHEN OTHERS THEN
571: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
572: p_pkg_name => G_PKG_NAME,
573: p_exc_name => 'OTHERS',
574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,