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

Line 9: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5: G_API_TYPE VARCHAR2(3) := 'PVT';
6:
7: PROCEDURE create_rule_group(
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_rgpv_rec IN rgpv_rec_type,

Line 42: OKC_API.set_message(

38: CLOSE csr_chr_rg_cnt;
39:
40: IF l_cnt_rg <> 0 THEN
41: --set error message
42: OKC_API.set_message(
43: p_app_name => G_APP_NAME,
44: p_msg_name => 'OKL_DUP_TERMS_AND_COND',
45: p_token1 => 'RULEGROUP',
46: p_token1_value => p_rgpv_rec.rgd_code);

Line 49: x_return_status := OKC_API.G_RET_STS_ERROR;

45: p_token1 => 'RULEGROUP',
46: p_token1_value => p_rgpv_rec.rgd_code);
47:
48: -- notify caller of an error
49: x_return_status := OKC_API.G_RET_STS_ERROR;
50: -- halt validation
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;
53: END IF;

Line 86: x_return_status := OKC_API.G_RET_STS_ERROR;

82: END IF;
83:
84: EXCEPTION
85: WHEN OKL_API.G_EXCEPTION_ERROR THEN
86: x_return_status := OKC_API.G_RET_STS_ERROR;
87: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS
88: (p_api_name => l_api_name
89: ,p_pkg_name => G_PKG_NAME
90: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

Line 98: OKC_API.SET_MESSAGE(

94: );
95: */
96: WHEN OTHERS THEN
97: -- store SQL error message on message stack
98: OKC_API.SET_MESSAGE(
99: p_app_name => G_APP_NAME,
100: p_msg_name => G_UNEXPECTED_ERROR,
101: p_token1 => G_SQLCODE_TOKEN,
102: p_token1_value => SQLCODE,

Line 106: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

102: p_token1_value => SQLCODE,
103: p_token2 => G_SQLERRM_TOKEN,
104: p_token2_value => SQLERRM);
105: -- notify caller of an error as UNEXPETED error
106: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
107: END create_rule_group;
108:
109: PROCEDURE update_rule_group(
110: p_api_version IN NUMBER,

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

107: END create_rule_group;
108:
109: PROCEDURE update_rule_group(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_rgpv_rec IN rgpv_rec_type,

Line 191: x_return_status := OKC_API.G_RET_STS_ERROR;

187: END IF;
188:
189: EXCEPTION
190: WHEN OKL_API.G_EXCEPTION_ERROR THEN
191: x_return_status := OKC_API.G_RET_STS_ERROR;
192:
193: WHEN OTHERS THEN
194: -- store SQL error message on message stack
195: OKC_API.SET_MESSAGE(

Line 195: OKC_API.SET_MESSAGE(

191: x_return_status := OKC_API.G_RET_STS_ERROR;
192:
193: WHEN OTHERS THEN
194: -- store SQL error message on message stack
195: OKC_API.SET_MESSAGE(
196: p_app_name => G_APP_NAME,
197: p_msg_name => G_UNEXPECTED_ERROR,
198: p_token1 => G_SQLCODE_TOKEN,
199: p_token1_value => SQLCODE,

Line 203: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

199: p_token1_value => SQLCODE,
200: p_token2 => G_SQLERRM_TOKEN,
201: p_token2_value => SQLERRM);
202: -- notify caller of an error as UNEXPETED error
203: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
204: END update_rule_group;
205:
206: PROCEDURE delete_rule_group(
207: p_api_version IN NUMBER,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: END update_rule_group;
205:
206: PROCEDURE delete_rule_group(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_rgpv_rec IN rgpv_rec_type) IS

Line 262: OKC_API.SET_MESSAGE(

258:
259: EXCEPTION
260: WHEN G_EXCEPTION_CANNOT_DELETE THEN
261: -- store SQL error message on message stack
262: OKC_API.SET_MESSAGE(
263: p_app_name => G_APP_NAME,
264: p_msg_name => G_CANNOT_DELETE_MASTER);
265: -- notify caller of an error
266: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 266: x_return_status := OKC_API.G_RET_STS_ERROR;

262: OKC_API.SET_MESSAGE(
263: p_app_name => G_APP_NAME,
264: p_msg_name => G_CANNOT_DELETE_MASTER);
265: -- notify caller of an error
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267:
268: WHEN OKL_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.G_RET_STS_ERROR;
270:

Line 269: x_return_status := OKC_API.G_RET_STS_ERROR;

265: -- notify caller of an error
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267:
268: WHEN OKL_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.G_RET_STS_ERROR;
270:
271: WHEN OTHERS THEN
272: -- store SQL error message on message stack
273: OKC_API.SET_MESSAGE(

Line 273: OKC_API.SET_MESSAGE(

269: x_return_status := OKC_API.G_RET_STS_ERROR;
270:
271: WHEN OTHERS THEN
272: -- store SQL error message on message stack
273: OKC_API.SET_MESSAGE(
274: p_app_name => G_APP_NAME,
275: p_msg_name => G_UNEXPECTED_ERROR,
276: p_token1 => G_SQLCODE_TOKEN,
277: p_token1_value => SQLCODE,

Line 281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

277: p_token1_value => SQLCODE,
278: p_token2 => G_SQLERRM_TOKEN,
279: p_token2_value => SQLERRM);
280: -- notify caller of an error as UNEXPETED error
281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
282:
283: END delete_rule_group;
284:
285: PROCEDURE process_vrs_rules(

Line 287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

283: END delete_rule_group;
284:
285: PROCEDURE process_vrs_rules(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_chr_id IN NUMBER,

Line 329: x_return_status := OKC_API.START_ACTIVITY(

325: WHERE ID = TO_NUMBER(P_CPL_ID);
326:
327: BEGIN
328:
329: x_return_status := OKC_API.START_ACTIVITY(
330: p_api_name => l_api_name,
331: p_pkg_name => g_pkg_name,
332: p_init_msg_list => p_init_msg_list,
333: l_api_version => l_api_version,

Line 339: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

335: p_api_type => g_api_type,
336: x_return_status => x_return_status);
337:
338: -- check if activity started successfully
339: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
341: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
342: RAISE OKC_API.G_EXCEPTION_ERROR;
343: END IF;

Line 340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

336: x_return_status => x_return_status);
337:
338: -- check if activity started successfully
339: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
341: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
342: RAISE OKC_API.G_EXCEPTION_ERROR;
343: END IF;
344:

Line 341: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

337:
338: -- check if activity started successfully
339: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
341: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
342: RAISE OKC_API.G_EXCEPTION_ERROR;
343: END IF;
344:
345: l_rgp_id := null;

Line 342: RAISE OKC_API.G_EXCEPTION_ERROR;

338: -- check if activity started successfully
339: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
341: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
342: RAISE OKC_API.G_EXCEPTION_ERROR;
343: END IF;
344:
345: l_rgp_id := null;
346: open RULE_GROUP_CSR(p_chr_id,'VGLRS');

Line 367: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

363: x_msg_data => x_msg_data,
364: p_rgpv_rec => lp_vrs_rgpv_rec,
365: x_rgpv_rec => lx_vrs_rgpv_rec);
366:
367: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
370: RAISE OKC_API.G_EXCEPTION_ERROR;
371: END IF;

Line 368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

364: p_rgpv_rec => lp_vrs_rgpv_rec,
365: x_rgpv_rec => lx_vrs_rgpv_rec);
366:
367: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
370: RAISE OKC_API.G_EXCEPTION_ERROR;
371: END IF;
372:

Line 369: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

365: x_rgpv_rec => lx_vrs_rgpv_rec);
366:
367: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
370: RAISE OKC_API.G_EXCEPTION_ERROR;
371: END IF;
372:
373: l_rgp_id := lx_vrs_rgpv_rec.id;

Line 370: RAISE OKC_API.G_EXCEPTION_ERROR;

366:
367: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
370: RAISE OKC_API.G_EXCEPTION_ERROR;
371: END IF;
372:
373: l_rgp_id := lx_vrs_rgpv_rec.id;
374:

Line 407: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

403: x_msg_data => x_msg_data,
404: p_rulv_rec => lp_vrs_rulv_rec,
405: x_rulv_rec => lx_vrs_rulv_rec);
406:
407: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
410: RAISE OKC_API.G_EXCEPTION_ERROR;
411: END IF;

Line 408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

404: p_rulv_rec => lp_vrs_rulv_rec,
405: x_rulv_rec => lx_vrs_rulv_rec);
406:
407: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
410: RAISE OKC_API.G_EXCEPTION_ERROR;
411: END IF;
412:

Line 409: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

405: x_rulv_rec => lx_vrs_rulv_rec);
406:
407: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
410: RAISE OKC_API.G_EXCEPTION_ERROR;
411: END IF;
412:
413: lx_vrs_rulv_rec.id := lx_vrs_rulv_rec.id;

Line 410: RAISE OKC_API.G_EXCEPTION_ERROR;

406:
407: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
410: RAISE OKC_API.G_EXCEPTION_ERROR;
411: END IF;
412:
413: lx_vrs_rulv_rec.id := lx_vrs_rulv_rec.id;
414:

Line 431: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

427: END IF;
428:
429: IF(l_rle_code IS NOT NULL AND l_rle_code = 'LESSOR') THEN
430: IF(p_vrs_tbl(i).rle_code <> 'LESSOR' ) THEN
431: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
432: p_msg_name => 'OKL_INVALID_ROLE_UPDATE');
433: x_return_status := OKC_API.g_ret_sts_error;
434: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: END IF;

Line 433: x_return_status := OKC_API.g_ret_sts_error;

429: IF(l_rle_code IS NOT NULL AND l_rle_code = 'LESSOR') THEN
430: IF(p_vrs_tbl(i).rle_code <> 'LESSOR' ) THEN
431: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
432: p_msg_name => 'OKL_INVALID_ROLE_UPDATE');
433: x_return_status := OKC_API.g_ret_sts_error;
434: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: END IF;
436: END IF;
437:

Line 434: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

430: IF(p_vrs_tbl(i).rle_code <> 'LESSOR' ) THEN
431: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
432: p_msg_name => 'OKL_INVALID_ROLE_UPDATE');
433: x_return_status := OKC_API.g_ret_sts_error;
434: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: END IF;
436: END IF;
437:
438: lp_vrs_rulv_rec.id := p_vrs_tbl(i).rul_id;

Line 456: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

452: x_msg_data => x_msg_data,
453: p_rulv_rec => lp_vrs_rulv_rec,
454: x_rulv_rec => lx_vrs_rulv_rec);
455:
456: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_ERROR;
460: END IF;

Line 457: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

453: p_rulv_rec => lp_vrs_rulv_rec,
454: x_rulv_rec => lx_vrs_rulv_rec);
455:
456: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_ERROR;
460: END IF;
461:

Line 458: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

454: x_rulv_rec => lx_vrs_rulv_rec);
455:
456: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_ERROR;
460: END IF;
461:
462: END IF;

Line 459: RAISE OKC_API.G_EXCEPTION_ERROR;

455:
456: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_ERROR;
460: END IF;
461:
462: END IF;
463:

Line 472: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

468:
469:
470: END IF;
471:
472: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
473:
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 475: WHEN OKC_API.G_EXCEPTION_ERROR THEN

471:
472: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
473:
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
477: p_api_name => l_api_name,
478: p_pkg_name => g_pkg_name,
479: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 476: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

472: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
473:
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
477: p_api_name => l_api_name,
478: p_pkg_name => g_pkg_name,
479: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
480: x_msg_count => x_msg_count,

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

475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
477: p_api_name => l_api_name,
478: p_pkg_name => g_pkg_name,
479: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
482: p_api_type => g_api_type);
483:

Line 484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
482: p_api_type => g_api_type);
483:
484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
485: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
486: p_api_name => l_api_name,
487: p_pkg_name => g_pkg_name,
488: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 485: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

481: x_msg_data => x_msg_data,
482: p_api_type => g_api_type);
483:
484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
485: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
486: p_api_name => l_api_name,
487: p_pkg_name => g_pkg_name,
488: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
489: x_msg_count => x_msg_count,

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

484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
485: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
486: p_api_name => l_api_name,
487: p_pkg_name => g_pkg_name,
488: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
489: x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data,
491: p_api_type => g_api_type);
492:

Line 494: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

490: x_msg_data => x_msg_data,
491: p_api_type => g_api_type);
492:
493: WHEN OTHERS THEN
494: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => g_pkg_name,
497: p_exc_name => 'OTHERS',
498: x_msg_count => x_msg_count,

Line 505: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

501: END;
502:
503: PROCEDURE delete_vrs_rule(
504: p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
506: x_return_status OUT NOCOPY VARCHAR2,
507: x_msg_count OUT NOCOPY NUMBER,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: p_chr_id IN NUMBER,

Line 533: x_return_status := OKC_API.START_ACTIVITY(

529: WHERE ID = TO_NUMBER(P_CPL_ID);
530:
531: BEGIN
532:
533: x_return_status := OKC_API.START_ACTIVITY(
534: p_api_name => l_api_name,
535: p_pkg_name => g_pkg_name,
536: p_init_msg_list => p_init_msg_list,
537: l_api_version => l_api_version,

Line 543: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

539: p_api_type => g_api_type,
540: x_return_status => x_return_status);
541:
542: -- check if activity started successfully
543: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
546: RAISE OKC_API.G_EXCEPTION_ERROR;
547: END IF;

Line 544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

540: x_return_status => x_return_status);
541:
542: -- check if activity started successfully
543: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
546: RAISE OKC_API.G_EXCEPTION_ERROR;
547: END IF;
548:

Line 545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

541:
542: -- check if activity started successfully
543: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
546: RAISE OKC_API.G_EXCEPTION_ERROR;
547: END IF;
548:
549: l_cpl_id := null;

Line 546: RAISE OKC_API.G_EXCEPTION_ERROR;

542: -- check if activity started successfully
543: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
546: RAISE OKC_API.G_EXCEPTION_ERROR;
547: END IF;
548:
549: l_cpl_id := null;
550: OPEN RULE_CSR(p_rul_id);

Line 562: x_return_status := OKC_API.g_ret_sts_error;

558: CLOSE RLE_CSR;
559: END IF;
560:
561: IF(l_rle_code IS NOT NULL AND l_rle_code = 'LESSOR') THEN
562: x_return_status := OKC_API.g_ret_sts_error;
563: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
564: p_msg_name => 'OKL_INVALID_ROLE_DELETE');
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;

Line 563: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

559: END IF;
560:
561: IF(l_rle_code IS NOT NULL AND l_rle_code = 'LESSOR') THEN
562: x_return_status := OKC_API.g_ret_sts_error;
563: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
564: p_msg_name => 'OKL_INVALID_ROLE_DELETE');
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:

Line 565: RAISE OKC_API.G_EXCEPTION_ERROR;

561: IF(l_rle_code IS NOT NULL AND l_rle_code = 'LESSOR') THEN
562: x_return_status := OKC_API.g_ret_sts_error;
563: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
564: p_msg_name => 'OKL_INVALID_ROLE_DELETE');
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: lp_vrs_rulv_rec.id := p_rul_id;
569:

Line 579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

575: x_msg_data => x_msg_data,
576: p_rulv_rec => lp_vrs_rulv_rec
577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;

Line 580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

576: p_rulv_rec => lp_vrs_rulv_rec
577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:

Line 581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585:

Line 582: RAISE OKC_API.G_EXCEPTION_ERROR;

578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585:
586: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 586: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585:
586: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
587:
588: EXCEPTION
589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 589: WHEN OKC_API.G_EXCEPTION_ERROR THEN

585:
586: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
587:
588: EXCEPTION
589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 590: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

586: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
587:
588: EXCEPTION
589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
594: x_msg_count => x_msg_count,

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

589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
594: x_msg_count => x_msg_count,
595: x_msg_data => x_msg_data,
596: p_api_type => g_api_type);
597:

Line 598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

594: x_msg_count => x_msg_count,
595: x_msg_data => x_msg_data,
596: p_api_type => g_api_type);
597:
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
600: p_api_name => l_api_name,
601: p_pkg_name => g_pkg_name,
602: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

595: x_msg_data => x_msg_data,
596: p_api_type => g_api_type);
597:
598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
600: p_api_name => l_api_name,
601: p_pkg_name => g_pkg_name,
602: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
603: x_msg_count => x_msg_count,

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

598: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
600: p_api_name => l_api_name,
601: p_pkg_name => g_pkg_name,
602: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
603: x_msg_count => x_msg_count,
604: x_msg_data => x_msg_data,
605: p_api_type => g_api_type);
606:

Line 608: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

604: x_msg_data => x_msg_data,
605: p_api_type => g_api_type);
606:
607: WHEN OTHERS THEN
608: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
609: p_api_name => l_api_name,
610: p_pkg_name => g_pkg_name,
611: p_exc_name => 'OTHERS',
612: x_msg_count => x_msg_count,

Line 619: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

615: END;
616:
617: PROCEDURE validate_vrs_percent(
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_chr_id IN NUMBER

Line 641: x_return_status := OKC_API.START_ACTIVITY(

637: AND rgp.chr_id = p_chr_id;
638:
639: BEGIN
640:
641: x_return_status := OKC_API.START_ACTIVITY(
642: p_api_name => l_api_name,
643: p_pkg_name => g_pkg_name,
644: p_init_msg_list => p_init_msg_list,
645: l_api_version => l_api_version,

Line 651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

647: p_api_type => g_api_type,
648: x_return_status => x_return_status);
649:
650: -- check if activity started successfully
651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;

Line 652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

648: x_return_status => x_return_status);
649:
650: -- check if activity started successfully
651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;
656:

Line 653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

649:
650: -- check if activity started successfully
651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: l_percent := null;

Line 654: RAISE OKC_API.G_EXCEPTION_ERROR;

650: -- check if activity started successfully
651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: l_percent := null;
658: OPEN RESI_PERCENT_CSR;

Line 663: x_return_status := OKC_API.g_ret_sts_error;

659: FETCH RESI_PERCENT_CSR into l_percent;
660: CLOSE RESI_PERCENT_CSR;
661:
662: IF(l_percent IS NULL OR l_percent <> 100) THEN
663: x_return_status := OKC_API.g_ret_sts_error;
664: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
665: p_msg_name => 'OKL_VN_INCORRECT_RESIDUAL');
666: RAISE OKC_API.G_EXCEPTION_ERROR;
667: END IF;

Line 664: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

660: CLOSE RESI_PERCENT_CSR;
661:
662: IF(l_percent IS NULL OR l_percent <> 100) THEN
663: x_return_status := OKC_API.g_ret_sts_error;
664: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
665: p_msg_name => 'OKL_VN_INCORRECT_RESIDUAL');
666: RAISE OKC_API.G_EXCEPTION_ERROR;
667: END IF;
668:

Line 666: RAISE OKC_API.G_EXCEPTION_ERROR;

662: IF(l_percent IS NULL OR l_percent <> 100) THEN
663: x_return_status := OKC_API.g_ret_sts_error;
664: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
665: p_msg_name => 'OKL_VN_INCORRECT_RESIDUAL');
666: RAISE OKC_API.G_EXCEPTION_ERROR;
667: END IF;
668:
669: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
670:

Line 669: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

665: p_msg_name => 'OKL_VN_INCORRECT_RESIDUAL');
666: RAISE OKC_API.G_EXCEPTION_ERROR;
667: END IF;
668:
669: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
670:
671: EXCEPTION
672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
673: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 672: WHEN OKC_API.G_EXCEPTION_ERROR THEN

668:
669: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
670:
671: EXCEPTION
672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
673: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
674: p_api_name => l_api_name,
675: p_pkg_name => g_pkg_name,
676: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 673: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

669: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
670:
671: EXCEPTION
672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
673: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
674: p_api_name => l_api_name,
675: p_pkg_name => g_pkg_name,
676: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
677: x_msg_count => x_msg_count,

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

672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
673: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
674: p_api_name => l_api_name,
675: p_pkg_name => g_pkg_name,
676: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
677: x_msg_count => x_msg_count,
678: x_msg_data => x_msg_data,
679: p_api_type => g_api_type);
680:

Line 681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

677: x_msg_count => x_msg_count,
678: x_msg_data => x_msg_data,
679: p_api_type => g_api_type);
680:
681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 682: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

678: x_msg_data => x_msg_data,
679: p_api_type => g_api_type);
680:
681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
686: x_msg_count => x_msg_count,

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

681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
686: x_msg_count => x_msg_count,
687: x_msg_data => x_msg_data,
688: p_api_type => g_api_type);
689:

Line 691: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

687: x_msg_data => x_msg_data,
688: p_api_type => g_api_type);
689:
690: WHEN OTHERS THEN
691: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
692: p_api_name => l_api_name,
693: p_pkg_name => g_pkg_name,
694: p_exc_name => 'OTHERS',
695: x_msg_count => x_msg_count,