APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_API

Line 36: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

32: RETURN d;
33: END;
34:
35: PROCEDURE get_std_rate_tmpl(p_api_version IN NUMBER
36: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ,p_srt_id IN NUMBER

Line 133: x_return_status := okl_api.start_activity(l_api_name

129: l_api_name VARCHAR2(40) := 'get_std_rate_tmpl';
130: l_api_version NUMBER := 1.0;
131:
132: BEGIN
133: x_return_status := okl_api.start_activity(l_api_name
134: ,g_pkg_name
135: ,p_init_msg_list
136: ,l_api_version
137: ,p_api_version

Line 156: okl_api.end_activity(x_msg_count

152: CLOSE srt_version_csr;
153:
154: --end activity
155:
156: okl_api.end_activity(x_msg_count
157: ,x_msg_data);
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := okl_api.handle_exceptions(l_api_name

Line 160: x_return_status := okl_api.handle_exceptions(l_api_name

156: okl_api.end_activity(x_msg_count
157: ,x_msg_data);
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := okl_api.handle_exceptions(l_api_name
161: ,g_pkg_name
162: ,'OTHERS'
163: ,x_msg_count
164: ,x_msg_data

Line 169: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

165: ,'_PVT');
166: END get_std_rate_tmpl;
167:
168: PROCEDURE get_eligibility_criteria(p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
170: ,x_return_status OUT NOCOPY VARCHAR2
171: ,x_msg_count OUT NOCOPY NUMBER
172: ,x_msg_data OUT NOCOPY VARCHAR2
173: ,source_id IN NUMBER

Line 262: x_return_status := okl_api.start_activity(l_api_name

258: j NUMBER := 1;
259: data_type VARCHAR2(30);
260:
261: BEGIN
262: x_return_status := okl_api.start_activity(l_api_name
263: ,g_pkg_name
264: ,p_init_msg_list
265: ,l_api_version
266: ,p_api_version

Line 347: okl_api.end_activity(x_msg_count

343: END LOOP;
344:
345: --end activity
346:
347: okl_api.end_activity(x_msg_count
348: ,x_msg_data);
349: EXCEPTION
350: WHEN OTHERS THEN
351: x_return_status := okl_api.handle_exceptions(l_api_name

Line 351: x_return_status := okl_api.handle_exceptions(l_api_name

347: okl_api.end_activity(x_msg_count
348: ,x_msg_data);
349: EXCEPTION
350: WHEN OTHERS THEN
351: x_return_status := okl_api.handle_exceptions(l_api_name
352: ,g_pkg_name
353: ,'OTHERS'
354: ,x_msg_count
355: ,x_msg_data

Line 363: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

359: -- procedure to give the details of the Standard Rate Template given the Standard
360: -- Rate Template id and the version number
361:
362: PROCEDURE get_version(p_api_version IN NUMBER
363: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
364: ,x_return_status OUT NOCOPY VARCHAR2
365: ,x_msg_count OUT NOCOPY NUMBER
366: ,x_msg_data OUT NOCOPY VARCHAR2
367: ,p_srt_id IN NUMBER

Line 376: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

372: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
373: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl) IS
374: l_api_name VARCHAR2(40) := 'get_version';
375: l_api_version NUMBER := 1.0;
376: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
377:
378: BEGIN
379: l_return_status := okl_api.start_activity(l_api_name
380: ,g_pkg_name

Line 379: l_return_status := okl_api.start_activity(l_api_name

375: l_api_version NUMBER := 1.0;
376: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
377:
378: BEGIN
379: l_return_status := okl_api.start_activity(l_api_name
380: ,g_pkg_name
381: ,p_init_msg_list
382: ,l_api_version
383: ,p_api_version

Line 387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

383: ,p_api_version
384: ,'_PVT'
385: ,x_return_status);
386:
387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
388: RAISE okl_api.g_exception_unexpected_error;
389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
390: RAISE okl_api.g_exception_error;
391: END IF;

Line 388: RAISE okl_api.g_exception_unexpected_error;

384: ,'_PVT'
385: ,x_return_status);
386:
387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
388: RAISE okl_api.g_exception_unexpected_error;
389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
390: RAISE okl_api.g_exception_error;
391: END IF;
392: get_std_rate_tmpl(p_api_version

Line 389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

385: ,x_return_status);
386:
387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
388: RAISE okl_api.g_exception_unexpected_error;
389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
390: RAISE okl_api.g_exception_error;
391: END IF;
392: get_std_rate_tmpl(p_api_version
393: ,p_init_msg_list

Line 390: RAISE okl_api.g_exception_error;

386:
387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
388: RAISE okl_api.g_exception_unexpected_error;
389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
390: RAISE okl_api.g_exception_error;
391: END IF;
392: get_std_rate_tmpl(p_api_version
393: ,p_init_msg_list
394: ,x_return_status

Line 402: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

398: ,p_version_number
399: ,x_srtv_rec
400: ,x_srv_rec);
401:
402: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
403: RAISE okl_api.g_exception_unexpected_error;
404: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
405: RAISE okl_api.g_exception_error;
406: END IF;

Line 403: RAISE okl_api.g_exception_unexpected_error;

399: ,x_srtv_rec
400: ,x_srv_rec);
401:
402: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
403: RAISE okl_api.g_exception_unexpected_error;
404: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
405: RAISE okl_api.g_exception_error;
406: END IF;
407: get_eligibility_criteria(p_api_version

Line 404: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

400: ,x_srv_rec);
401:
402: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
403: RAISE okl_api.g_exception_unexpected_error;
404: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
405: RAISE okl_api.g_exception_error;
406: END IF;
407: get_eligibility_criteria(p_api_version
408: ,p_init_msg_list

Line 405: RAISE okl_api.g_exception_error;

401:
402: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
403: RAISE okl_api.g_exception_unexpected_error;
404: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
405: RAISE okl_api.g_exception_error;
406: END IF;
407: get_eligibility_criteria(p_api_version
408: ,p_init_msg_list
409: ,x_return_status

Line 417: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

413: ,x_ech_rec
414: ,x_ecl_tbl
415: ,x_ecv_tbl);
416:
417: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
418: RAISE okl_api.g_exception_unexpected_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
420: RAISE okl_api.g_exception_error;
421: END IF;

Line 418: RAISE okl_api.g_exception_unexpected_error;

414: ,x_ecl_tbl
415: ,x_ecv_tbl);
416:
417: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
418: RAISE okl_api.g_exception_unexpected_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
420: RAISE okl_api.g_exception_error;
421: END IF;
422:

Line 419: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

415: ,x_ecv_tbl);
416:
417: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
418: RAISE okl_api.g_exception_unexpected_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
420: RAISE okl_api.g_exception_error;
421: END IF;
422:
423: --end activity

Line 420: RAISE okl_api.g_exception_error;

416:
417: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
418: RAISE okl_api.g_exception_unexpected_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
420: RAISE okl_api.g_exception_error;
421: END IF;
422:
423: --end activity
424:

Line 425: okl_api.end_activity(x_msg_count

421: END IF;
422:
423: --end activity
424:
425: okl_api.end_activity(x_msg_count
426: ,x_msg_data);
427: x_return_status := l_return_status;
428: EXCEPTION
429: WHEN okl_api.g_exception_error THEN

Line 429: WHEN okl_api.g_exception_error THEN

425: okl_api.end_activity(x_msg_count
426: ,x_msg_data);
427: x_return_status := l_return_status;
428: EXCEPTION
429: WHEN okl_api.g_exception_error THEN
430: x_return_status := okl_api.handle_exceptions(l_api_name
431: ,g_pkg_name
432: ,'OKL_API.G_RET_STS_ERROR'
433: ,x_msg_count

Line 430: x_return_status := okl_api.handle_exceptions(l_api_name

426: ,x_msg_data);
427: x_return_status := l_return_status;
428: EXCEPTION
429: WHEN okl_api.g_exception_error THEN
430: x_return_status := okl_api.handle_exceptions(l_api_name
431: ,g_pkg_name
432: ,'OKL_API.G_RET_STS_ERROR'
433: ,x_msg_count
434: ,x_msg_data

Line 432: ,'OKL_API.G_RET_STS_ERROR'

428: EXCEPTION
429: WHEN okl_api.g_exception_error THEN
430: x_return_status := okl_api.handle_exceptions(l_api_name
431: ,g_pkg_name
432: ,'OKL_API.G_RET_STS_ERROR'
433: ,x_msg_count
434: ,x_msg_data
435: ,'_PVT');
436: WHEN okl_api.g_exception_unexpected_error THEN

Line 436: WHEN okl_api.g_exception_unexpected_error THEN

432: ,'OKL_API.G_RET_STS_ERROR'
433: ,x_msg_count
434: ,x_msg_data
435: ,'_PVT');
436: WHEN okl_api.g_exception_unexpected_error THEN
437: x_return_status := okl_api.handle_exceptions(l_api_name
438: ,g_pkg_name
439: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
440: ,x_msg_count

Line 437: x_return_status := okl_api.handle_exceptions(l_api_name

433: ,x_msg_count
434: ,x_msg_data
435: ,'_PVT');
436: WHEN okl_api.g_exception_unexpected_error THEN
437: x_return_status := okl_api.handle_exceptions(l_api_name
438: ,g_pkg_name
439: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
440: ,x_msg_count
441: ,x_msg_data

Line 439: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

435: ,'_PVT');
436: WHEN okl_api.g_exception_unexpected_error THEN
437: x_return_status := okl_api.handle_exceptions(l_api_name
438: ,g_pkg_name
439: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
440: ,x_msg_count
441: ,x_msg_data
442: ,'_PVT');
443: WHEN OTHERS THEN

Line 444: x_return_status := okl_api.handle_exceptions(l_api_name

440: ,x_msg_count
441: ,x_msg_data
442: ,'_PVT');
443: WHEN OTHERS THEN
444: x_return_status := okl_api.handle_exceptions(l_api_name
445: ,g_pkg_name
446: ,'OTHERS'
447: ,x_msg_count
448: ,x_msg_data

Line 456: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

452: -- procedure to give the details of the latest version of Standard Rate Template
453: -- given the Standard Rate Template id
454:
455: PROCEDURE get_version(p_api_version IN NUMBER
456: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
457: ,x_return_status OUT NOCOPY VARCHAR2
458: ,x_msg_count OUT NOCOPY NUMBER
459: ,x_msg_data OUT NOCOPY VARCHAR2
460: ,p_srt_id IN NUMBER

Line 474: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

470: WHERE std_rate_tmpl_id = p_srt_id;
471: l_version_number VARCHAR2(24);
472: l_api_name VARCHAR2(40) := 'get_version';
473: l_api_version NUMBER := 1.0;
474: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
475:
476: BEGIN
477: l_return_status := okl_api.start_activity(l_api_name
478: ,g_pkg_name

Line 477: l_return_status := okl_api.start_activity(l_api_name

473: l_api_version NUMBER := 1.0;
474: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
475:
476: BEGIN
477: l_return_status := okl_api.start_activity(l_api_name
478: ,g_pkg_name
479: ,p_init_msg_list
480: ,l_api_version
481: ,p_api_version

Line 485: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

481: ,p_api_version
482: ,'_PVT'
483: ,x_return_status);
484:
485: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
486: RAISE okl_api.g_exception_unexpected_error;
487: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
488: RAISE okl_api.g_exception_error;
489: END IF;

Line 486: RAISE okl_api.g_exception_unexpected_error;

482: ,'_PVT'
483: ,x_return_status);
484:
485: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
486: RAISE okl_api.g_exception_unexpected_error;
487: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
488: RAISE okl_api.g_exception_error;
489: END IF;
490: OPEN get_version_number(p_srt_id);

Line 487: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

483: ,x_return_status);
484:
485: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
486: RAISE okl_api.g_exception_unexpected_error;
487: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
488: RAISE okl_api.g_exception_error;
489: END IF;
490: OPEN get_version_number(p_srt_id);
491: FETCH get_version_number INTO l_version_number ;

Line 488: RAISE okl_api.g_exception_error;

484:
485: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
486: RAISE okl_api.g_exception_unexpected_error;
487: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
488: RAISE okl_api.g_exception_error;
489: END IF;
490: OPEN get_version_number(p_srt_id);
491: FETCH get_version_number INTO l_version_number ;
492: CLOSE get_version_number;

Line 503: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

499: ,l_version_number
500: ,x_srtv_rec
501: ,x_srv_rec);
502:
503: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
504: RAISE okl_api.g_exception_unexpected_error;
505: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
506: RAISE okl_api.g_exception_error;
507: END IF;

Line 504: RAISE okl_api.g_exception_unexpected_error;

500: ,x_srtv_rec
501: ,x_srv_rec);
502:
503: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
504: RAISE okl_api.g_exception_unexpected_error;
505: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
506: RAISE okl_api.g_exception_error;
507: END IF;
508: get_eligibility_criteria(p_api_version

Line 505: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

501: ,x_srv_rec);
502:
503: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
504: RAISE okl_api.g_exception_unexpected_error;
505: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
506: RAISE okl_api.g_exception_error;
507: END IF;
508: get_eligibility_criteria(p_api_version
509: ,p_init_msg_list

Line 506: RAISE okl_api.g_exception_error;

502:
503: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
504: RAISE okl_api.g_exception_unexpected_error;
505: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
506: RAISE okl_api.g_exception_error;
507: END IF;
508: get_eligibility_criteria(p_api_version
509: ,p_init_msg_list
510: ,x_return_status

Line 518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

514: ,x_ech_rec
515: ,x_ecl_tbl
516: ,x_ecv_tbl);
517:
518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: RAISE okl_api.g_exception_error;
522: END IF;

Line 519: RAISE okl_api.g_exception_unexpected_error;

515: ,x_ecl_tbl
516: ,x_ecv_tbl);
517:
518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: RAISE okl_api.g_exception_error;
522: END IF;
523:

Line 520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

516: ,x_ecv_tbl);
517:
518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: RAISE okl_api.g_exception_error;
522: END IF;
523:
524: --end activity

Line 521: RAISE okl_api.g_exception_error;

517:
518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: RAISE okl_api.g_exception_error;
522: END IF;
523:
524: --end activity
525:

Line 526: okl_api.end_activity(x_msg_count

522: END IF;
523:
524: --end activity
525:
526: okl_api.end_activity(x_msg_count
527: ,x_msg_data);
528: x_return_status := l_return_status;
529: EXCEPTION
530: WHEN okl_api.g_exception_error THEN

Line 530: WHEN okl_api.g_exception_error THEN

526: okl_api.end_activity(x_msg_count
527: ,x_msg_data);
528: x_return_status := l_return_status;
529: EXCEPTION
530: WHEN okl_api.g_exception_error THEN
531: x_return_status := okl_api.handle_exceptions(l_api_name
532: ,g_pkg_name
533: ,'OKL_API.G_RET_STS_ERROR'
534: ,x_msg_count

Line 531: x_return_status := okl_api.handle_exceptions(l_api_name

527: ,x_msg_data);
528: x_return_status := l_return_status;
529: EXCEPTION
530: WHEN okl_api.g_exception_error THEN
531: x_return_status := okl_api.handle_exceptions(l_api_name
532: ,g_pkg_name
533: ,'OKL_API.G_RET_STS_ERROR'
534: ,x_msg_count
535: ,x_msg_data

Line 533: ,'OKL_API.G_RET_STS_ERROR'

529: EXCEPTION
530: WHEN okl_api.g_exception_error THEN
531: x_return_status := okl_api.handle_exceptions(l_api_name
532: ,g_pkg_name
533: ,'OKL_API.G_RET_STS_ERROR'
534: ,x_msg_count
535: ,x_msg_data
536: ,'_PVT');
537: WHEN okl_api.g_exception_unexpected_error THEN

Line 537: WHEN okl_api.g_exception_unexpected_error THEN

533: ,'OKL_API.G_RET_STS_ERROR'
534: ,x_msg_count
535: ,x_msg_data
536: ,'_PVT');
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := okl_api.handle_exceptions(l_api_name
539: ,g_pkg_name
540: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
541: ,x_msg_count

Line 538: x_return_status := okl_api.handle_exceptions(l_api_name

534: ,x_msg_count
535: ,x_msg_data
536: ,'_PVT');
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := okl_api.handle_exceptions(l_api_name
539: ,g_pkg_name
540: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
541: ,x_msg_count
542: ,x_msg_data

Line 540: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

536: ,'_PVT');
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := okl_api.handle_exceptions(l_api_name
539: ,g_pkg_name
540: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
541: ,x_msg_count
542: ,x_msg_data
543: ,'_PVT');
544: WHEN OTHERS THEN

Line 545: x_return_status := okl_api.handle_exceptions(l_api_name

541: ,x_msg_count
542: ,x_msg_data
543: ,'_PVT');
544: WHEN OTHERS THEN
545: x_return_status := okl_api.handle_exceptions(l_api_name
546: ,g_pkg_name
547: ,'OTHERS'
548: ,x_msg_count
549: ,x_msg_data

Line 556: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

552:
553: --procedure to create a Standard Rate Template with the associated Eligibility Criteria
554:
555: PROCEDURE insert_srt(p_api_version IN NUMBER
556: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
557: ,x_return_status OUT NOCOPY VARCHAR2
558: ,x_msg_count OUT NOCOPY NUMBER
559: ,x_msg_data OUT NOCOPY VARCHAR2
560: ,p_srtv_rec IN okl_srtv_rec

Line 569: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

565: l_srv_rec okl_srv_rec := p_srv_rec;
566: l_api_version NUMBER := 1.0;
567: l_api_name VARCHAR2(40) := 'INSERT_SRT';
568: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
569: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
570: l_dummy_var VARCHAR2(1):='?';
571:
572: CURSOR rate_csr(p_index_id IN NUMBER
573: ,p_eff_from IN DATE) IS

Line 585: l_return_status := okl_api.start_activity(l_api_name

581: SELECT 'x'
582: FROM okl_fe_std_rt_tmp_v
583: WHERE template_name = UPPER(p_name);
584: BEGIN
585: l_return_status := okl_api.start_activity(l_api_name
586: ,g_pkg_name
587: ,p_init_msg_list
588: ,l_api_version
589: ,p_api_version

Line 593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

589: ,p_api_version
590: ,'_PVT'
591: ,x_return_status);
592:
593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
594: RAISE okl_api.g_exception_unexpected_error;
595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
596: RAISE okl_api.g_exception_error;
597: END IF;

Line 594: RAISE okl_api.g_exception_unexpected_error;

590: ,'_PVT'
591: ,x_return_status);
592:
593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
594: RAISE okl_api.g_exception_unexpected_error;
595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
596: RAISE okl_api.g_exception_error;
597: END IF;
598:

Line 595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

591: ,x_return_status);
592:
593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
594: RAISE okl_api.g_exception_unexpected_error;
595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
596: RAISE okl_api.g_exception_error;
597: END IF;
598:
599: OPEN srt_unique_chk(l_srtv_rec.template_name);

Line 596: RAISE okl_api.g_exception_error;

592:
593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
594: RAISE okl_api.g_exception_unexpected_error;
595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
596: RAISE okl_api.g_exception_error;
597: END IF;
598:
599: OPEN srt_unique_chk(l_srtv_rec.template_name);
600: FETCH srt_unique_chk INTO l_dummy_var ;

Line 606: okl_api.set_message(p_app_name => g_app_name

602:
603: -- if l_dummy_var is 'x' then name already exists
604:
605: IF (l_dummy_var = 'x') THEN
606: okl_api.set_message(p_app_name => g_app_name
607: ,p_msg_name => 'OKL_DUPLICATE_NAME'
608: ,p_token1 => 'NAME'
609: ,p_token1_value => l_srtv_rec.template_name);
610: RAISE okl_api.g_exception_error;

Line 610: RAISE okl_api.g_exception_error;

606: okl_api.set_message(p_app_name => g_app_name
607: ,p_msg_name => 'OKL_DUPLICATE_NAME'
608: ,p_token1 => 'NAME'
609: ,p_token1_value => l_srtv_rec.template_name);
610: RAISE okl_api.g_exception_error;
611:
612: END IF;
613: -- fix for gmiss date
614:

Line 618: OR l_srv_rec.srt_rate = okl_api.g_miss_num)) THEN

614:
615: l_srv_rec.effective_to_date := rosetta_g_miss_date_in_map(l_srv_rec.effective_to_date);
616:
617: IF (l_srtv_rec.rate_type_code = 'BASE_RATE' AND (l_srv_rec.srt_rate IS NULL
618: OR l_srv_rec.srt_rate = okl_api.g_miss_num)) THEN
619: RAISE okl_api.g_exception_error;
620: END IF;
621:
622: IF (l_srtv_rec.rate_type_code = 'INDEX_RATE') THEN

Line 619: RAISE okl_api.g_exception_error;

615: l_srv_rec.effective_to_date := rosetta_g_miss_date_in_map(l_srv_rec.effective_to_date);
616:
617: IF (l_srtv_rec.rate_type_code = 'BASE_RATE' AND (l_srv_rec.srt_rate IS NULL
618: OR l_srv_rec.srt_rate = okl_api.g_miss_num)) THEN
619: RAISE okl_api.g_exception_error;
620: END IF;
621:
622: IF (l_srtv_rec.rate_type_code = 'INDEX_RATE') THEN
623: l_srv_rec.srt_rate := null;

Line 632: okl_api.set_message(p_app_name => g_app_name

628:
629: -- if l_srv_rec.srt_rate is null, then set the error message
630:
631: IF (l_srv_rec.SRT_RATE is null) THEN
632: okl_api.set_message(p_app_name => g_app_name
633: ,p_msg_name => 'OKL_SRT_INDEX_RATE_NOT_AVAIL'
634: );
635: RAISE okl_api.g_exception_error;
636: END IF;

Line 635: RAISE okl_api.g_exception_error;

631: IF (l_srv_rec.SRT_RATE is null) THEN
632: okl_api.set_message(p_app_name => g_app_name
633: ,p_msg_name => 'OKL_SRT_INDEX_RATE_NOT_AVAIL'
634: );
635: RAISE okl_api.g_exception_error;
636: END IF;
637: ELSE
638: l_srtv_rec.index_id:= null;
639:

Line 661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

657: ,x_msg_data
658: ,l_srtv_rec
659: ,x_srtv_rec);
660:
661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
662: RAISE okl_api.g_exception_unexpected_error;
663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
664: RAISE okl_api.g_exception_error;
665: END IF;

Line 662: RAISE okl_api.g_exception_unexpected_error;

658: ,l_srtv_rec
659: ,x_srtv_rec);
660:
661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
662: RAISE okl_api.g_exception_unexpected_error;
663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
664: RAISE okl_api.g_exception_error;
665: END IF;
666:

Line 663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

659: ,x_srtv_rec);
660:
661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
662: RAISE okl_api.g_exception_unexpected_error;
663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
664: RAISE okl_api.g_exception_error;
665: END IF;
666:
667: -- setting the version attributes

Line 664: RAISE okl_api.g_exception_error;

660:
661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
662: RAISE okl_api.g_exception_unexpected_error;
663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
664: RAISE okl_api.g_exception_error;
665: END IF;
666:
667: -- setting the version attributes
668:

Line 683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

679: ,x_msg_data
680: ,l_srv_rec
681: ,x_srv_rec);
682:
683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
684: RAISE okl_api.g_exception_unexpected_error;
685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
686: RAISE okl_api.g_exception_error;
687: END IF;

Line 684: RAISE okl_api.g_exception_unexpected_error;

680: ,l_srv_rec
681: ,x_srv_rec);
682:
683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
684: RAISE okl_api.g_exception_unexpected_error;
685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
686: RAISE okl_api.g_exception_error;
687: END IF;
688:

Line 685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

681: ,x_srv_rec);
682:
683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
684: RAISE okl_api.g_exception_unexpected_error;
685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
686: RAISE okl_api.g_exception_error;
687: END IF;
688:
689: --end activity

Line 686: RAISE okl_api.g_exception_error;

682:
683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
684: RAISE okl_api.g_exception_unexpected_error;
685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
686: RAISE okl_api.g_exception_error;
687: END IF;
688:
689: --end activity
690:

Line 691: okl_api.end_activity(x_msg_count

687: END IF;
688:
689: --end activity
690:
691: okl_api.end_activity(x_msg_count
692: ,x_msg_data);
693: x_return_status := l_return_status;
694: EXCEPTION
695: WHEN okl_api.g_exception_error THEN

Line 695: WHEN okl_api.g_exception_error THEN

691: okl_api.end_activity(x_msg_count
692: ,x_msg_data);
693: x_return_status := l_return_status;
694: EXCEPTION
695: WHEN okl_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count

Line 696: x_return_status := okl_api.handle_exceptions(l_api_name

692: ,x_msg_data);
693: x_return_status := l_return_status;
694: EXCEPTION
695: WHEN okl_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data

Line 698: ,'OKL_API.G_RET_STS_ERROR'

694: EXCEPTION
695: WHEN okl_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okl_api.g_exception_unexpected_error THEN

Line 702: WHEN okl_api.g_exception_unexpected_error THEN

698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okl_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count

Line 703: x_return_status := okl_api.handle_exceptions(l_api_name

699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okl_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count
707: ,x_msg_data

Line 705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

701: ,'_PVT');
702: WHEN okl_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count
707: ,x_msg_data
708: ,'_PVT');
709: WHEN OTHERS THEN

Line 710: x_return_status := okl_api.handle_exceptions(l_api_name

706: ,x_msg_count
707: ,x_msg_data
708: ,'_PVT');
709: WHEN OTHERS THEN
710: x_return_status := okl_api.handle_exceptions(l_api_name
711: ,g_pkg_name
712: ,'OTHERS'
713: ,x_msg_count
714: ,x_msg_data

Line 721: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

717:
718: -- procedure to update a particular version of the Standard Rate Template
719:
720: PROCEDURE update_srt(p_api_version IN NUMBER
721: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
722: ,x_return_status OUT NOCOPY VARCHAR2
723: ,x_msg_count OUT NOCOPY NUMBER
724: ,x_msg_data OUT NOCOPY VARCHAR2
725: ,p_srv_rec IN okl_srv_rec

Line 733: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

729: l_srv_rec okl_srv_rec := p_srv_rec;
730: l_api_version NUMBER := 1.0;
731: l_api_name VARCHAR2(40) := 'UPDATE_SRT';
732: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
733: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
734: l_eff_from DATE;
735: l_eff_to DATE;
736: l_max_date DATE;
737: cal_eff_from DATE;

Line 758: l_return_status := okl_api.start_activity(l_api_name

754: WHERE ecl.criteria_set_id = ech.criteria_set_id
755: AND ech.source_id = p_version_id AND source_object_code = 'SRT';
756:
757: BEGIN
758: l_return_status := okl_api.start_activity(l_api_name
759: ,g_pkg_name
760: ,l_init_msg_list
761: ,l_api_version
762: ,p_api_version

Line 766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

762: ,p_api_version
763: ,'_PVT'
764: ,x_return_status);
765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okl_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okl_api.g_exception_error;
770: END IF;

Line 767: RAISE okl_api.g_exception_unexpected_error;

763: ,'_PVT'
764: ,x_return_status);
765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okl_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okl_api.g_exception_error;
770: END IF;
771:

Line 768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

764: ,x_return_status);
765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okl_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okl_api.g_exception_error;
770: END IF;
771:
772: -- fix for gmiss date

Line 769: RAISE okl_api.g_exception_error;

765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okl_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okl_api.g_exception_error;
770: END IF;
771:
772: -- fix for gmiss date
773:

Line 793: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

789: ,x_msg_count
790: ,x_msg_data
791: ,l_srtv_rec
792: ,x_srtv_rec);
793: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
794: RAISE okl_api.g_exception_unexpected_error;
795: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
796: RAISE okl_api.g_exception_error;
797: END IF;

Line 794: RAISE okl_api.g_exception_unexpected_error;

790: ,x_msg_data
791: ,l_srtv_rec
792: ,x_srtv_rec);
793: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
794: RAISE okl_api.g_exception_unexpected_error;
795: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
796: RAISE okl_api.g_exception_error;
797: END IF;
798: ELSIF (l_srv_rec.sts_code = 'ACTIVE') THEN

Line 795: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

791: ,l_srtv_rec
792: ,x_srtv_rec);
793: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
794: RAISE okl_api.g_exception_unexpected_error;
795: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
796: RAISE okl_api.g_exception_error;
797: END IF;
798: ELSIF (l_srv_rec.sts_code = 'ACTIVE') THEN
799: l_srtv_rec.std_rate_tmpl_id := l_srv_rec.std_rate_tmpl_id;

Line 796: RAISE okl_api.g_exception_error;

792: ,x_srtv_rec);
793: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
794: RAISE okl_api.g_exception_unexpected_error;
795: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
796: RAISE okl_api.g_exception_error;
797: END IF;
798: ELSIF (l_srv_rec.sts_code = 'ACTIVE') THEN
799: l_srtv_rec.std_rate_tmpl_id := l_srv_rec.std_rate_tmpl_id;
800:

Line 811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

807: ,x_msg_data
808: ,l_srv_rec
809: ,cal_eff_from);
810:
811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;

Line 812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

808: ,l_srv_rec
809: ,cal_eff_from);
810:
811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;
816:

Line 813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

809: ,cal_eff_from);
810:
811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;
816:
817: OPEN get_elig_crit_start_date(l_srv_rec.std_rate_tmpl_ver_id);

Line 814: RAISE OKL_API.G_EXCEPTION_ERROR;

810:
811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;
816:
817: OPEN get_elig_crit_start_date(l_srv_rec.std_rate_tmpl_ver_id);
818: FETCH get_elig_crit_start_date INTO l_max_date;

Line 827: IF (cal_eff_from <> okl_api.g_miss_date AND l_srv_rec.effective_to_date < (cal_eff_from-1) and cal_eff_from<>okl_api.g_miss_date) THEN

823: cal_eff_from:= l_max_date +1;
824: END IF;
825:
826: -- viselvar Bug#4907469 modified
827: IF (cal_eff_from <> okl_api.g_miss_date AND l_srv_rec.effective_to_date < (cal_eff_from-1) and cal_eff_from<>okl_api.g_miss_date) THEN
828: okl_api.set_message(
829: p_app_name => g_app_name
830: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO_DATE'
831: ,p_token1 => 'DATE'

Line 828: okl_api.set_message(

824: END IF;
825:
826: -- viselvar Bug#4907469 modified
827: IF (cal_eff_from <> okl_api.g_miss_date AND l_srv_rec.effective_to_date < (cal_eff_from-1) and cal_eff_from<>okl_api.g_miss_date) THEN
828: okl_api.set_message(
829: p_app_name => g_app_name
830: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO_DATE'
831: ,p_token1 => 'DATE'
832: ,p_token1_value => cal_eff_from-1);

Line 833: RAISE okl_api.g_exception_error;

829: p_app_name => g_app_name
830: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO_DATE'
831: ,p_token1 => 'DATE'
832: ,p_token1_value => cal_eff_from-1);
833: RAISE okl_api.g_exception_error;
834: END IF;
835:
836: l_srtv_rec.effective_to_date := l_srv_rec.effective_to_date;
837: l_srtv_rec.srt_rate := l_srv_rec.srt_rate;

Line 848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

844: ,x_msg_count
845: ,x_msg_data
846: ,l_srtv_rec
847: ,x_srtv_rec);
848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
849: RAISE okl_api.g_exception_unexpected_error;
850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
851: RAISE okl_api.g_exception_error;
852: END IF;

Line 849: RAISE okl_api.g_exception_unexpected_error;

845: ,x_msg_data
846: ,l_srtv_rec
847: ,x_srtv_rec);
848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
849: RAISE okl_api.g_exception_unexpected_error;
850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
851: RAISE okl_api.g_exception_error;
852: END IF;
853: IF (l_srv_rec.effective_to_date IS NOT NULL AND l_srv_rec.effective_to_date <> okl_api.g_miss_date) THEN

Line 850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

846: ,l_srtv_rec
847: ,x_srtv_rec);
848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
849: RAISE okl_api.g_exception_unexpected_error;
850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
851: RAISE okl_api.g_exception_error;
852: END IF;
853: IF (l_srv_rec.effective_to_date IS NOT NULL AND l_srv_rec.effective_to_date <> okl_api.g_miss_date) THEN
854:

Line 851: RAISE okl_api.g_exception_error;

847: ,x_srtv_rec);
848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
849: RAISE okl_api.g_exception_unexpected_error;
850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
851: RAISE okl_api.g_exception_error;
852: END IF;
853: IF (l_srv_rec.effective_to_date IS NOT NULL AND l_srv_rec.effective_to_date <> okl_api.g_miss_date) THEN
854:
855: -- put an end date to the previous version of the eligibility criteria

Line 853: IF (l_srv_rec.effective_to_date IS NOT NULL AND l_srv_rec.effective_to_date <> okl_api.g_miss_date) THEN

849: RAISE okl_api.g_exception_unexpected_error;
850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
851: RAISE okl_api.g_exception_error;
852: END IF;
853: IF (l_srv_rec.effective_to_date IS NOT NULL AND l_srv_rec.effective_to_date <> okl_api.g_miss_date) THEN
854:
855: -- put an end date to the previous version of the eligibility criteria
856:
857: okl_ecc_values_pvt.end_date_eligibility_criteria(p_api_version => l_api_version

Line 901: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

897: ,x_msg_data
898: ,l_srv_rec
899: ,x_srv_rec);
900:
901: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
902: RAISE okl_api.g_exception_unexpected_error;
903: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
904: RAISE okl_api.g_exception_error;
905: END IF;

Line 902: RAISE okl_api.g_exception_unexpected_error;

898: ,l_srv_rec
899: ,x_srv_rec);
900:
901: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
902: RAISE okl_api.g_exception_unexpected_error;
903: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
904: RAISE okl_api.g_exception_error;
905: END IF;
906:

Line 903: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

899: ,x_srv_rec);
900:
901: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
902: RAISE okl_api.g_exception_unexpected_error;
903: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
904: RAISE okl_api.g_exception_error;
905: END IF;
906:
907: --end activity

Line 904: RAISE okl_api.g_exception_error;

900:
901: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
902: RAISE okl_api.g_exception_unexpected_error;
903: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
904: RAISE okl_api.g_exception_error;
905: END IF;
906:
907: --end activity
908:

Line 909: okl_api.end_activity(x_msg_count

905: END IF;
906:
907: --end activity
908:
909: okl_api.end_activity(x_msg_count
910: ,x_msg_data);
911: x_return_status := l_return_status;
912: EXCEPTION
913: WHEN okl_api.g_exception_error THEN

Line 913: WHEN okl_api.g_exception_error THEN

909: okl_api.end_activity(x_msg_count
910: ,x_msg_data);
911: x_return_status := l_return_status;
912: EXCEPTION
913: WHEN okl_api.g_exception_error THEN
914: x_return_status := okl_api.handle_exceptions(l_api_name
915: ,g_pkg_name
916: ,'OKL_API.G_RET_STS_ERROR'
917: ,x_msg_count

Line 914: x_return_status := okl_api.handle_exceptions(l_api_name

910: ,x_msg_data);
911: x_return_status := l_return_status;
912: EXCEPTION
913: WHEN okl_api.g_exception_error THEN
914: x_return_status := okl_api.handle_exceptions(l_api_name
915: ,g_pkg_name
916: ,'OKL_API.G_RET_STS_ERROR'
917: ,x_msg_count
918: ,x_msg_data

Line 916: ,'OKL_API.G_RET_STS_ERROR'

912: EXCEPTION
913: WHEN okl_api.g_exception_error THEN
914: x_return_status := okl_api.handle_exceptions(l_api_name
915: ,g_pkg_name
916: ,'OKL_API.G_RET_STS_ERROR'
917: ,x_msg_count
918: ,x_msg_data
919: ,'_PVT');
920: WHEN okl_api.g_exception_unexpected_error THEN

Line 920: WHEN okl_api.g_exception_unexpected_error THEN

916: ,'OKL_API.G_RET_STS_ERROR'
917: ,x_msg_count
918: ,x_msg_data
919: ,'_PVT');
920: WHEN okl_api.g_exception_unexpected_error THEN
921: x_return_status := okl_api.handle_exceptions(l_api_name
922: ,g_pkg_name
923: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
924: ,x_msg_count

Line 921: x_return_status := okl_api.handle_exceptions(l_api_name

917: ,x_msg_count
918: ,x_msg_data
919: ,'_PVT');
920: WHEN okl_api.g_exception_unexpected_error THEN
921: x_return_status := okl_api.handle_exceptions(l_api_name
922: ,g_pkg_name
923: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
924: ,x_msg_count
925: ,x_msg_data

Line 923: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

919: ,'_PVT');
920: WHEN okl_api.g_exception_unexpected_error THEN
921: x_return_status := okl_api.handle_exceptions(l_api_name
922: ,g_pkg_name
923: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
924: ,x_msg_count
925: ,x_msg_data
926: ,'_PVT');
927: WHEN OTHERS THEN

Line 928: x_return_status := okl_api.handle_exceptions(l_api_name

924: ,x_msg_count
925: ,x_msg_data
926: ,'_PVT');
927: WHEN OTHERS THEN
928: x_return_status := okl_api.handle_exceptions(l_api_name
929: ,g_pkg_name
930: ,'OTHERS'
931: ,x_msg_count
932: ,x_msg_data

Line 939: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

935:
936: -- procedure to create a new version of the Standard Rate Template
937:
938: PROCEDURE create_version(p_api_version IN NUMBER
939: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
940: ,x_return_status OUT NOCOPY VARCHAR2
941: ,x_msg_count OUT NOCOPY NUMBER
942: ,x_msg_data OUT NOCOPY VARCHAR2
943: ,p_srv_rec IN okl_srv_rec

Line 952: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

948: l_srv_rec okl_srv_rec := p_srv_rec;
949: l_api_version NUMBER := 1.0;
950: l_api_name VARCHAR2(40) := 'CREATE_VERSION';
951: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
952: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
953: cal_eff_from DATE;
954:
955: BEGIN
956: l_return_status := okl_api.start_activity(l_api_name

Line 956: l_return_status := okl_api.start_activity(l_api_name

952: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
953: cal_eff_from DATE;
954:
955: BEGIN
956: l_return_status := okl_api.start_activity(l_api_name
957: ,g_pkg_name
958: ,l_init_msg_list
959: ,l_api_version
960: ,p_api_version

Line 964: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

960: ,p_api_version
961: ,'_PVT'
962: ,x_return_status);
963:
964: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
965: RAISE okl_api.g_exception_unexpected_error;
966: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
967: RAISE okl_api.g_exception_error;
968: END IF;

Line 965: RAISE okl_api.g_exception_unexpected_error;

961: ,'_PVT'
962: ,x_return_status);
963:
964: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
965: RAISE okl_api.g_exception_unexpected_error;
966: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
967: RAISE okl_api.g_exception_error;
968: END IF;
969:

Line 966: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

962: ,x_return_status);
963:
964: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
965: RAISE okl_api.g_exception_unexpected_error;
966: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
967: RAISE okl_api.g_exception_error;
968: END IF;
969:
970: -- fix for gmiss date

Line 967: RAISE okl_api.g_exception_error;

963:
964: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
965: RAISE okl_api.g_exception_unexpected_error;
966: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
967: RAISE okl_api.g_exception_error;
968: END IF;
969:
970: -- fix for gmiss date
971:

Line 989: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

985: ,x_msg_data
986: ,l_srtv_rec
987: ,x_srtv_rec);
988:
989: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
990: RAISE okl_api.g_exception_unexpected_error;
991: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
992: RAISE okl_api.g_exception_error;
993: END IF;

Line 990: RAISE okl_api.g_exception_unexpected_error;

986: ,l_srtv_rec
987: ,x_srtv_rec);
988:
989: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
990: RAISE okl_api.g_exception_unexpected_error;
991: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
992: RAISE okl_api.g_exception_error;
993: END IF;
994:

Line 991: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

987: ,x_srtv_rec);
988:
989: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
990: RAISE okl_api.g_exception_unexpected_error;
991: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
992: RAISE okl_api.g_exception_error;
993: END IF;
994:
995: -- Check if user entered start date > the calculated start date

Line 992: RAISE okl_api.g_exception_error;

988:
989: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
990: RAISE okl_api.g_exception_unexpected_error;
991: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
992: RAISE okl_api.g_exception_error;
993: END IF;
994:
995: -- Check if user entered start date > the calculated start date
996: -- else raise an exception

Line 1008: okl_api.set_message(p_app_name => g_app_name

1004: ,cal_eff_from);
1005:
1006: IF (l_srv_rec.effective_from_date < cal_eff_from) THEN
1007: -- viselvar modified Bug#4907469
1008: okl_api.set_message(p_app_name => g_app_name
1009: ,p_msg_name => 'OKL_INVALID_EFF_FROM'
1010: ,p_token1 => 'DATE'
1011: ,p_token1_value => cal_eff_from);
1012: RAISE okl_api.g_exception_error;

Line 1012: RAISE okl_api.g_exception_error;

1008: okl_api.set_message(p_app_name => g_app_name
1009: ,p_msg_name => 'OKL_INVALID_EFF_FROM'
1010: ,p_token1 => 'DATE'
1011: ,p_token1_value => cal_eff_from);
1012: RAISE okl_api.g_exception_error;
1013: END IF;
1014:
1015: -- insert the version record into the table
1016:

Line 1025: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1021: ,x_msg_data
1022: ,l_srv_rec
1023: ,x_srv_rec);
1024:
1025: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1026: RAISE okl_api.g_exception_unexpected_error;
1027: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1028: RAISE okl_api.g_exception_error;
1029: END IF;

Line 1026: RAISE okl_api.g_exception_unexpected_error;

1022: ,l_srv_rec
1023: ,x_srv_rec);
1024:
1025: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1026: RAISE okl_api.g_exception_unexpected_error;
1027: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1028: RAISE okl_api.g_exception_error;
1029: END IF;
1030:

Line 1027: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1023: ,x_srv_rec);
1024:
1025: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1026: RAISE okl_api.g_exception_unexpected_error;
1027: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1028: RAISE okl_api.g_exception_error;
1029: END IF;
1030:
1031: --end activity

Line 1028: RAISE okl_api.g_exception_error;

1024:
1025: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1026: RAISE okl_api.g_exception_unexpected_error;
1027: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1028: RAISE okl_api.g_exception_error;
1029: END IF;
1030:
1031: --end activity
1032:

Line 1033: okl_api.end_activity(x_msg_count

1029: END IF;
1030:
1031: --end activity
1032:
1033: okl_api.end_activity(x_msg_count
1034: ,x_msg_data);
1035: x_return_status := l_return_status;
1036: EXCEPTION
1037: WHEN okl_api.g_exception_error THEN

Line 1037: WHEN okl_api.g_exception_error THEN

1033: okl_api.end_activity(x_msg_count
1034: ,x_msg_data);
1035: x_return_status := l_return_status;
1036: EXCEPTION
1037: WHEN okl_api.g_exception_error THEN
1038: x_return_status := okl_api.handle_exceptions(l_api_name
1039: ,g_pkg_name
1040: ,'OKL_API.G_RET_STS_ERROR'
1041: ,x_msg_count

Line 1038: x_return_status := okl_api.handle_exceptions(l_api_name

1034: ,x_msg_data);
1035: x_return_status := l_return_status;
1036: EXCEPTION
1037: WHEN okl_api.g_exception_error THEN
1038: x_return_status := okl_api.handle_exceptions(l_api_name
1039: ,g_pkg_name
1040: ,'OKL_API.G_RET_STS_ERROR'
1041: ,x_msg_count
1042: ,x_msg_data

Line 1040: ,'OKL_API.G_RET_STS_ERROR'

1036: EXCEPTION
1037: WHEN okl_api.g_exception_error THEN
1038: x_return_status := okl_api.handle_exceptions(l_api_name
1039: ,g_pkg_name
1040: ,'OKL_API.G_RET_STS_ERROR'
1041: ,x_msg_count
1042: ,x_msg_data
1043: ,'_PVT');
1044: WHEN okl_api.g_exception_unexpected_error THEN

Line 1044: WHEN okl_api.g_exception_unexpected_error THEN

1040: ,'OKL_API.G_RET_STS_ERROR'
1041: ,x_msg_count
1042: ,x_msg_data
1043: ,'_PVT');
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := okl_api.handle_exceptions(l_api_name
1046: ,g_pkg_name
1047: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1048: ,x_msg_count

Line 1045: x_return_status := okl_api.handle_exceptions(l_api_name

1041: ,x_msg_count
1042: ,x_msg_data
1043: ,'_PVT');
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := okl_api.handle_exceptions(l_api_name
1046: ,g_pkg_name
1047: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1048: ,x_msg_count
1049: ,x_msg_data

Line 1047: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1043: ,'_PVT');
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := okl_api.handle_exceptions(l_api_name
1046: ,g_pkg_name
1047: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1048: ,x_msg_count
1049: ,x_msg_data
1050: ,'_PVT');
1051: WHEN OTHERS THEN

Line 1052: x_return_status := okl_api.handle_exceptions(l_api_name

1048: ,x_msg_count
1049: ,x_msg_data
1050: ,'_PVT');
1051: WHEN OTHERS THEN
1052: x_return_status := okl_api.handle_exceptions(l_api_name
1053: ,g_pkg_name
1054: ,'OTHERS'
1055: ,x_msg_count
1056: ,x_msg_data

Line 1063: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1059:
1060: -- procedure to raise the workflow which submits the record and changes the status.
1061:
1062: PROCEDURE submit_srt(p_api_version IN NUMBER
1063: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1064: ,x_return_status OUT NOCOPY VARCHAR2
1065: ,x_msg_count OUT NOCOPY NUMBER
1066: ,x_msg_data OUT NOCOPY VARCHAR2
1067: ,p_version_id IN NUMBER) IS

Line 1073: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1069: x_srv_rec okl_srv_rec;
1070: l_api_version NUMBER := 1.0;
1071: l_api_name VARCHAR2(40) := 'SUBMIT_SRT';
1072: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1073: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1074: l_parameter_list wf_parameter_list_t;
1075: p_event_name VARCHAR2(240) := 'oracle.apps.okl.fe.srtapproval';
1076: l_profile_value VARCHAR2(30);
1077:

Line 1079: l_return_status := okl_api.start_activity(l_api_name

1075: p_event_name VARCHAR2(240) := 'oracle.apps.okl.fe.srtapproval';
1076: l_profile_value VARCHAR2(30);
1077:
1078: BEGIN
1079: l_return_status := okl_api.start_activity(l_api_name
1080: ,g_pkg_name
1081: ,l_init_msg_list
1082: ,l_api_version
1083: ,p_api_version

Line 1087: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1083: ,p_api_version
1084: ,'_PVT'
1085: ,x_return_status);
1086:
1087: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1090: RAISE okl_api.g_exception_error;
1091: END IF;

Line 1088: RAISE okl_api.g_exception_unexpected_error;

1084: ,'_PVT'
1085: ,x_return_status);
1086:
1087: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1090: RAISE okl_api.g_exception_error;
1091: END IF;
1092: l_srv_rec.std_rate_tmpl_ver_id := p_version_id;

Line 1089: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1085: ,x_return_status);
1086:
1087: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1090: RAISE okl_api.g_exception_error;
1091: END IF;
1092: l_srv_rec.std_rate_tmpl_ver_id := p_version_id;
1093: l_srv_rec.sts_code := 'SUBMITTED';

Line 1090: RAISE okl_api.g_exception_error;

1086:
1087: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1090: RAISE okl_api.g_exception_error;
1091: END IF;
1092: l_srv_rec.std_rate_tmpl_ver_id := p_version_id;
1093: l_srv_rec.sts_code := 'SUBMITTED';
1094: okl_srv_pvt.update_row(l_api_version

Line 1102: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1098: ,x_msg_data
1099: ,l_srv_rec
1100: ,x_srv_rec);
1101:
1102: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1103: RAISE okl_api.g_exception_unexpected_error;
1104: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1105: RAISE okl_api.g_exception_error;
1106: END IF;

Line 1103: RAISE okl_api.g_exception_unexpected_error;

1099: ,l_srv_rec
1100: ,x_srv_rec);
1101:
1102: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1103: RAISE okl_api.g_exception_unexpected_error;
1104: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1105: RAISE okl_api.g_exception_error;
1106: END IF;
1107: fnd_profile.get('OKL_PE_APPROVAL_PROCESS'

Line 1104: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1100: ,x_srv_rec);
1101:
1102: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1103: RAISE okl_api.g_exception_unexpected_error;
1104: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1105: RAISE okl_api.g_exception_error;
1106: END IF;
1107: fnd_profile.get('OKL_PE_APPROVAL_PROCESS'
1108: ,l_profile_value);

Line 1105: RAISE okl_api.g_exception_error;

1101:
1102: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1103: RAISE okl_api.g_exception_unexpected_error;
1104: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1105: RAISE okl_api.g_exception_error;
1106: END IF;
1107: fnd_profile.get('OKL_PE_APPROVAL_PROCESS'
1108: ,l_profile_value);
1109:

Line 1136: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1132: ,p_event_name => p_event_name
1133: ,p_parameters => l_parameter_list);
1134: END IF;
1135:
1136: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1137: RAISE okl_api.g_exception_unexpected_error;
1138: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1139: RAISE okl_api.g_exception_error;
1140: END IF;

Line 1137: RAISE okl_api.g_exception_unexpected_error;

1133: ,p_parameters => l_parameter_list);
1134: END IF;
1135:
1136: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1137: RAISE okl_api.g_exception_unexpected_error;
1138: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1139: RAISE okl_api.g_exception_error;
1140: END IF;
1141:

Line 1138: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1134: END IF;
1135:
1136: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1137: RAISE okl_api.g_exception_unexpected_error;
1138: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1139: RAISE okl_api.g_exception_error;
1140: END IF;
1141:
1142: --end activity

Line 1139: RAISE okl_api.g_exception_error;

1135:
1136: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1137: RAISE okl_api.g_exception_unexpected_error;
1138: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1139: RAISE okl_api.g_exception_error;
1140: END IF;
1141:
1142: --end activity
1143:

Line 1144: okl_api.end_activity(x_msg_count

1140: END IF;
1141:
1142: --end activity
1143:
1144: okl_api.end_activity(x_msg_count
1145: ,x_msg_data);
1146: x_return_status := l_return_status;
1147: EXCEPTION
1148: WHEN okl_api.g_exception_error THEN

Line 1148: WHEN okl_api.g_exception_error THEN

1144: okl_api.end_activity(x_msg_count
1145: ,x_msg_data);
1146: x_return_status := l_return_status;
1147: EXCEPTION
1148: WHEN okl_api.g_exception_error THEN
1149: x_return_status := okl_api.handle_exceptions(l_api_name
1150: ,g_pkg_name
1151: ,'OKL_API.G_RET_STS_ERROR'
1152: ,x_msg_count

Line 1149: x_return_status := okl_api.handle_exceptions(l_api_name

1145: ,x_msg_data);
1146: x_return_status := l_return_status;
1147: EXCEPTION
1148: WHEN okl_api.g_exception_error THEN
1149: x_return_status := okl_api.handle_exceptions(l_api_name
1150: ,g_pkg_name
1151: ,'OKL_API.G_RET_STS_ERROR'
1152: ,x_msg_count
1153: ,x_msg_data

Line 1151: ,'OKL_API.G_RET_STS_ERROR'

1147: EXCEPTION
1148: WHEN okl_api.g_exception_error THEN
1149: x_return_status := okl_api.handle_exceptions(l_api_name
1150: ,g_pkg_name
1151: ,'OKL_API.G_RET_STS_ERROR'
1152: ,x_msg_count
1153: ,x_msg_data
1154: ,'_PVT');
1155: WHEN okl_api.g_exception_unexpected_error THEN

Line 1155: WHEN okl_api.g_exception_unexpected_error THEN

1151: ,'OKL_API.G_RET_STS_ERROR'
1152: ,x_msg_count
1153: ,x_msg_data
1154: ,'_PVT');
1155: WHEN okl_api.g_exception_unexpected_error THEN
1156: x_return_status := okl_api.handle_exceptions(l_api_name
1157: ,g_pkg_name
1158: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1159: ,x_msg_count

Line 1156: x_return_status := okl_api.handle_exceptions(l_api_name

1152: ,x_msg_count
1153: ,x_msg_data
1154: ,'_PVT');
1155: WHEN okl_api.g_exception_unexpected_error THEN
1156: x_return_status := okl_api.handle_exceptions(l_api_name
1157: ,g_pkg_name
1158: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1159: ,x_msg_count
1160: ,x_msg_data

Line 1158: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1154: ,'_PVT');
1155: WHEN okl_api.g_exception_unexpected_error THEN
1156: x_return_status := okl_api.handle_exceptions(l_api_name
1157: ,g_pkg_name
1158: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1159: ,x_msg_count
1160: ,x_msg_data
1161: ,'_PVT');
1162: WHEN OTHERS THEN

Line 1163: x_return_status := okl_api.handle_exceptions(l_api_name

1159: ,x_msg_count
1160: ,x_msg_data
1161: ,'_PVT');
1162: WHEN OTHERS THEN
1163: x_return_status := okl_api.handle_exceptions(l_api_name
1164: ,g_pkg_name
1165: ,'OTHERS'
1166: ,x_msg_count
1167: ,x_msg_data

Line 1174: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1170:
1171: -- procedure to handle when the process is going through the process of approval
1172:
1173: PROCEDURE handle_approval(p_api_version IN NUMBER
1174: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1175: ,x_return_status OUT NOCOPY VARCHAR2
1176: ,x_msg_count OUT NOCOPY NUMBER
1177: ,x_msg_data OUT NOCOPY VARCHAR2
1178: ,p_version_id IN NUMBER) IS

Line 1234: x_return_status := okl_api.start_activity(l_api_name

1230: l_api_version NUMBER := 1.0;
1231: l_api_name VARCHAR2(40) := 'handle_approval';
1232:
1233: BEGIN
1234: x_return_status := okl_api.start_activity(l_api_name
1235: ,g_pkg_name
1236: ,p_init_msg_list
1237: ,l_api_version
1238: ,p_api_version

Line 1242: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1238: ,p_api_version
1239: ,'_PVT'
1240: ,x_return_status);
1241:
1242: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1243: RAISE okl_api.g_exception_unexpected_error;
1244: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1245: RAISE okl_api.g_exception_error;
1246: END IF;

Line 1243: RAISE okl_api.g_exception_unexpected_error;

1239: ,'_PVT'
1240: ,x_return_status);
1241:
1242: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1243: RAISE okl_api.g_exception_unexpected_error;
1244: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1245: RAISE okl_api.g_exception_error;
1246: END IF;
1247:

Line 1244: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1240: ,x_return_status);
1241:
1242: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1243: RAISE okl_api.g_exception_unexpected_error;
1244: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1245: RAISE okl_api.g_exception_error;
1246: END IF;
1247:
1248: -- if it is the first version,

Line 1245: RAISE okl_api.g_exception_error;

1241:
1242: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1243: RAISE okl_api.g_exception_unexpected_error;
1244: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1245: RAISE okl_api.g_exception_error;
1246: END IF;
1247:
1248: -- if it is the first version,
1249: -- change the header status and the end date of the header as the version end date

Line 1277: l_srtv_rec.effective_to_date := okl_api.g_miss_date;

1273: l_srtv_rec.sts_code := 'ACTIVE';
1274: IF (l_effective_to IS NOT NULL) THEN
1275: l_srtv_rec.effective_to_date := l_effective_to;
1276: ELSE
1277: l_srtv_rec.effective_to_date := okl_api.g_miss_date;
1278: END IF;
1279:
1280: ELSIF (l_version_number = l_max_version) THEN
1281:

Line 1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1298: x_msg_data ,
1299: lp_srv_rec ,
1300: l_cal_end_date );
1301:
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1303: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1305: raise OKL_API.G_EXCEPTION_ERROR;
1306: END IF;

Line 1303: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1299: lp_srv_rec ,
1300: l_cal_end_date );
1301:
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1303: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1305: raise OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:

Line 1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1300: l_cal_end_date );
1301:
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1303: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1305: raise OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: IF (lp_srv_rec.effective_from_date < l_cal_end_date ) THEN

Line 1305: raise OKL_API.G_EXCEPTION_ERROR;

1301:
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1303: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1305: raise OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: IF (lp_srv_rec.effective_from_date < l_cal_end_date ) THEN
1309: RAISE okl_api.g_exception_error;

Line 1309: RAISE okl_api.g_exception_error;

1305: raise OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: IF (lp_srv_rec.effective_from_date < l_cal_end_date ) THEN
1309: RAISE okl_api.g_exception_error;
1310: END IF;
1311: l_cal_end_date:= lp_srv_rec.effective_from_date -1;
1312:
1313: l_srtv_rec.std_rate_tmpl_id := l_srt_id;

Line 1318: l_srtv_rec.effective_to_date := okl_api.g_miss_date;

1314: l_srtv_rec.sts_code := 'ACTIVE';
1315: IF (l_effective_to IS NOT NULL) THEN
1316: l_srtv_rec.effective_to_date := l_effective_to;
1317: ELSE
1318: l_srtv_rec.effective_to_date := okl_api.g_miss_date;
1319: END IF;
1320:
1321: IF (l_cal_end_date IS NOT NULL) THEN
1322:

Line 1349: ,okl_api.g_miss_date) <> l_cal_end_date) THEN

1345: END IF;
1346: -- update the previous version effective to
1347:
1348: IF (NVL(l_eff_prev_ver
1349: ,okl_api.g_miss_date) <> l_cal_end_date) THEN
1350: l_srv_rec.std_rate_tmpl_ver_id := l_srt_ver_id;
1351: l_srv_rec.effective_to_date := l_cal_end_date;
1352: okl_srv_pvt.update_row(l_api_version
1353: ,p_init_msg_list

Line 1386: IF (l_index_id IS NOT NULL AND l_index_id <> okl_api.g_miss_num) THEN

1382: OPEN index_id_csr(l_srt_id);
1383: FETCH index_id_csr INTO l_index_id ;
1384: CLOSE index_id_csr;
1385:
1386: IF (l_index_id IS NOT NULL AND l_index_id <> okl_api.g_miss_num) THEN
1387: OPEN cal_rate_csr(l_index_id
1388: ,l_effective_from);
1389: FETCH cal_rate_csr INTO l_srt_rate ;
1390: CLOSE cal_rate_csr;

Line 1392: okl_api.set_message(p_app_name => g_app_name

1388: ,l_effective_from);
1389: FETCH cal_rate_csr INTO l_srt_rate ;
1390: CLOSE cal_rate_csr;
1391: IF (l_srt_rate IS NULL) THEN
1392: okl_api.set_message(p_app_name => g_app_name
1393: ,p_msg_name => 'OKL_SRT_INDEX_RATE_NOT_AVAIL'
1394: );
1395: RAISE okl_api.g_exception_error;
1396: ELSE

Line 1395: RAISE okl_api.g_exception_error;

1391: IF (l_srt_rate IS NULL) THEN
1392: okl_api.set_message(p_app_name => g_app_name
1393: ,p_msg_name => 'OKL_SRT_INDEX_RATE_NOT_AVAIL'
1394: );
1395: RAISE okl_api.g_exception_error;
1396: ELSE
1397: l_srv_rec.srt_rate := l_srt_rate;
1398: l_srtv_rec.srt_rate := l_rate;
1399: END IF;

Line 1412: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1408: ,x_msg_data
1409: ,l_srv_rec
1410: ,x_srv_rec);
1411:
1412: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1413: RAISE okl_api.g_exception_unexpected_error;
1414: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1415: RAISE okl_api.g_exception_error;
1416: END IF;

Line 1413: RAISE okl_api.g_exception_unexpected_error;

1409: ,l_srv_rec
1410: ,x_srv_rec);
1411:
1412: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1413: RAISE okl_api.g_exception_unexpected_error;
1414: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1415: RAISE okl_api.g_exception_error;
1416: END IF;
1417: okl_srt_pvt.update_row(l_api_version

Line 1414: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1410: ,x_srv_rec);
1411:
1412: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1413: RAISE okl_api.g_exception_unexpected_error;
1414: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1415: RAISE okl_api.g_exception_error;
1416: END IF;
1417: okl_srt_pvt.update_row(l_api_version
1418: ,p_init_msg_list

Line 1415: RAISE okl_api.g_exception_error;

1411:
1412: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1413: RAISE okl_api.g_exception_unexpected_error;
1414: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1415: RAISE okl_api.g_exception_error;
1416: END IF;
1417: okl_srt_pvt.update_row(l_api_version
1418: ,p_init_msg_list
1419: ,x_return_status

Line 1425: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1421: ,x_msg_data
1422: ,l_srtv_rec
1423: ,x_srtv_rec);
1424:
1425: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okl_api.g_exception_unexpected_error;
1427: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okl_api.g_exception_error;
1429: END IF;

Line 1426: RAISE okl_api.g_exception_unexpected_error;

1422: ,l_srtv_rec
1423: ,x_srtv_rec);
1424:
1425: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okl_api.g_exception_unexpected_error;
1427: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okl_api.g_exception_error;
1429: END IF;
1430:

Line 1427: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1423: ,x_srtv_rec);
1424:
1425: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okl_api.g_exception_unexpected_error;
1427: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okl_api.g_exception_error;
1429: END IF;
1430:
1431: EXCEPTION

Line 1428: RAISE okl_api.g_exception_error;

1424:
1425: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okl_api.g_exception_unexpected_error;
1427: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okl_api.g_exception_error;
1429: END IF;
1430:
1431: EXCEPTION
1432: WHEN okl_api.g_exception_error THEN

Line 1432: WHEN okl_api.g_exception_error THEN

1428: RAISE okl_api.g_exception_error;
1429: END IF;
1430:
1431: EXCEPTION
1432: WHEN okl_api.g_exception_error THEN
1433: x_return_status := okl_api.handle_exceptions(l_api_name
1434: ,g_pkg_name
1435: ,'OKL_API.G_RET_STS_ERROR'
1436: ,x_msg_count

Line 1433: x_return_status := okl_api.handle_exceptions(l_api_name

1429: END IF;
1430:
1431: EXCEPTION
1432: WHEN okl_api.g_exception_error THEN
1433: x_return_status := okl_api.handle_exceptions(l_api_name
1434: ,g_pkg_name
1435: ,'OKL_API.G_RET_STS_ERROR'
1436: ,x_msg_count
1437: ,x_msg_data

Line 1435: ,'OKL_API.G_RET_STS_ERROR'

1431: EXCEPTION
1432: WHEN okl_api.g_exception_error THEN
1433: x_return_status := okl_api.handle_exceptions(l_api_name
1434: ,g_pkg_name
1435: ,'OKL_API.G_RET_STS_ERROR'
1436: ,x_msg_count
1437: ,x_msg_data
1438: ,'_PVT');
1439: WHEN okl_api.g_exception_unexpected_error THEN

Line 1439: WHEN okl_api.g_exception_unexpected_error THEN

1435: ,'OKL_API.G_RET_STS_ERROR'
1436: ,x_msg_count
1437: ,x_msg_data
1438: ,'_PVT');
1439: WHEN okl_api.g_exception_unexpected_error THEN
1440: x_return_status := okl_api.handle_exceptions(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count

Line 1440: x_return_status := okl_api.handle_exceptions(l_api_name

1436: ,x_msg_count
1437: ,x_msg_data
1438: ,'_PVT');
1439: WHEN okl_api.g_exception_unexpected_error THEN
1440: x_return_status := okl_api.handle_exceptions(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count
1444: ,x_msg_data

Line 1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1438: ,'_PVT');
1439: WHEN okl_api.g_exception_unexpected_error THEN
1440: x_return_status := okl_api.handle_exceptions(l_api_name
1441: ,g_pkg_name
1442: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1443: ,x_msg_count
1444: ,x_msg_data
1445: ,'_PVT');
1446: WHEN OTHERS THEN

Line 1451: x_return_status := okl_api.handle_exceptions(l_api_name

1447:
1448: IF srt_version_csr%ISOPEN THEN
1449: CLOSE srt_version_csr;
1450: END IF;
1451: x_return_status := okl_api.handle_exceptions(l_api_name
1452: ,g_pkg_name
1453: ,'OTHERS'
1454: ,x_msg_count
1455: ,x_msg_data

Line 1462: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1458:
1459: -- procedure to set the default Standard Rate Template
1460:
1461: PROCEDURE update_default(p_api_version IN NUMBER
1462: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1463: ,x_return_status OUT NOCOPY VARCHAR2
1464: ,x_msg_count OUT NOCOPY NUMBER
1465: ,x_msg_data OUT NOCOPY VARCHAR2
1466: ,p_srt_id IN NUMBER) AS

Line 1478: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1474: l_srt_id NUMBER;
1475: l_api_version NUMBER := 1.0;
1476: l_api_name VARCHAR2(40) := 'update_default';
1477: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1478: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1479:
1480: BEGIN
1481: l_return_status := okl_api.start_activity(l_api_name
1482: ,g_pkg_name

Line 1481: l_return_status := okl_api.start_activity(l_api_name

1477: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1478: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1479:
1480: BEGIN
1481: l_return_status := okl_api.start_activity(l_api_name
1482: ,g_pkg_name
1483: ,l_init_msg_list
1484: ,l_api_version
1485: ,p_api_version

Line 1489: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1485: ,p_api_version
1486: ,'_PVT'
1487: ,x_return_status);
1488:
1489: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;

Line 1490: RAISE okl_api.g_exception_unexpected_error;

1486: ,'_PVT'
1487: ,x_return_status);
1488:
1489: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: OPEN default_yn_csr;

Line 1491: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1487: ,x_return_status);
1488:
1489: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: OPEN default_yn_csr;
1495: FETCH default_yn_csr INTO l_srt_id ;

Line 1492: RAISE okl_api.g_exception_error;

1488:
1489: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: OPEN default_yn_csr;
1495: FETCH default_yn_csr INTO l_srt_id ;
1496: CLOSE default_yn_csr;

Line 1513: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1509: ,x_msg_count
1510: ,x_msg_data
1511: ,l_srtv_rec
1512: ,x_srtv_rec);
1513: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1514: RAISE okl_api.g_exception_unexpected_error;
1515: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1516: RAISE okl_api.g_exception_error;
1517: END IF;

Line 1514: RAISE okl_api.g_exception_unexpected_error;

1510: ,x_msg_data
1511: ,l_srtv_rec
1512: ,x_srtv_rec);
1513: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1514: RAISE okl_api.g_exception_unexpected_error;
1515: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1516: RAISE okl_api.g_exception_error;
1517: END IF;
1518: END IF;

Line 1515: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1511: ,l_srtv_rec
1512: ,x_srtv_rec);
1513: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1514: RAISE okl_api.g_exception_unexpected_error;
1515: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1516: RAISE okl_api.g_exception_error;
1517: END IF;
1518: END IF;
1519:

Line 1516: RAISE okl_api.g_exception_error;

1512: ,x_srtv_rec);
1513: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1514: RAISE okl_api.g_exception_unexpected_error;
1515: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1516: RAISE okl_api.g_exception_error;
1517: END IF;
1518: END IF;
1519:
1520: -- change the default yn flag to Y for the required one

Line 1535: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1531: ,x_msg_data
1532: ,l_srtv_rec
1533: ,x_srtv_rec);
1534:
1535: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;

Line 1536: RAISE okl_api.g_exception_unexpected_error;

1532: ,l_srtv_rec
1533: ,x_srtv_rec);
1534:
1535: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540:

Line 1537: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1533: ,x_srtv_rec);
1534:
1535: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540:
1541: --end activity

Line 1538: RAISE okl_api.g_exception_error;

1534:
1535: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540:
1541: --end activity
1542:

Line 1543: okl_api.end_activity(x_msg_count

1539: END IF;
1540:
1541: --end activity
1542:
1543: okl_api.end_activity(x_msg_count
1544: ,x_msg_data);
1545: x_return_status := l_return_status;
1546: EXCEPTION
1547: WHEN okl_api.g_exception_error THEN

Line 1547: WHEN okl_api.g_exception_error THEN

1543: okl_api.end_activity(x_msg_count
1544: ,x_msg_data);
1545: x_return_status := l_return_status;
1546: EXCEPTION
1547: WHEN okl_api.g_exception_error THEN
1548: x_return_status := okl_api.handle_exceptions(l_api_name
1549: ,g_pkg_name
1550: ,'OKL_API.G_RET_STS_ERROR'
1551: ,x_msg_count

Line 1548: x_return_status := okl_api.handle_exceptions(l_api_name

1544: ,x_msg_data);
1545: x_return_status := l_return_status;
1546: EXCEPTION
1547: WHEN okl_api.g_exception_error THEN
1548: x_return_status := okl_api.handle_exceptions(l_api_name
1549: ,g_pkg_name
1550: ,'OKL_API.G_RET_STS_ERROR'
1551: ,x_msg_count
1552: ,x_msg_data

Line 1550: ,'OKL_API.G_RET_STS_ERROR'

1546: EXCEPTION
1547: WHEN okl_api.g_exception_error THEN
1548: x_return_status := okl_api.handle_exceptions(l_api_name
1549: ,g_pkg_name
1550: ,'OKL_API.G_RET_STS_ERROR'
1551: ,x_msg_count
1552: ,x_msg_data
1553: ,'_PVT');
1554: WHEN okl_api.g_exception_unexpected_error THEN

Line 1554: WHEN okl_api.g_exception_unexpected_error THEN

1550: ,'OKL_API.G_RET_STS_ERROR'
1551: ,x_msg_count
1552: ,x_msg_data
1553: ,'_PVT');
1554: WHEN okl_api.g_exception_unexpected_error THEN
1555: x_return_status := okl_api.handle_exceptions(l_api_name
1556: ,g_pkg_name
1557: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1558: ,x_msg_count

Line 1555: x_return_status := okl_api.handle_exceptions(l_api_name

1551: ,x_msg_count
1552: ,x_msg_data
1553: ,'_PVT');
1554: WHEN okl_api.g_exception_unexpected_error THEN
1555: x_return_status := okl_api.handle_exceptions(l_api_name
1556: ,g_pkg_name
1557: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1558: ,x_msg_count
1559: ,x_msg_data

Line 1557: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1553: ,'_PVT');
1554: WHEN okl_api.g_exception_unexpected_error THEN
1555: x_return_status := okl_api.handle_exceptions(l_api_name
1556: ,g_pkg_name
1557: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1558: ,x_msg_count
1559: ,x_msg_data
1560: ,'_PVT');
1561: WHEN OTHERS THEN

Line 1562: x_return_status := okl_api.handle_exceptions(l_api_name

1558: ,x_msg_count
1559: ,x_msg_data
1560: ,'_PVT');
1561: WHEN OTHERS THEN
1562: x_return_status := okl_api.handle_exceptions(l_api_name
1563: ,g_pkg_name
1564: ,'OTHERS'
1565: ,x_msg_count
1566: ,x_msg_data

Line 1573: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1569:
1570: -- to find the list of all the invalid object refernces
1571:
1572: PROCEDURE invalid_objects(p_api_version IN NUMBER
1573: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1574: ,x_return_status OUT NOCOPY VARCHAR2
1575: ,x_msg_count OUT NOCOPY NUMBER
1576: ,x_msg_data OUT NOCOPY VARCHAR2
1577: ,p_version_id IN NUMBER

Line 1595: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1591: l_version_id NUMBER := p_version_id;
1592: i NUMBER := 1;
1593: l_api_version NUMBER := 1.0;
1594: l_api_name VARCHAR2(40) := 'invalid_objects';
1595: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1596:
1597: BEGIN
1598: x_return_status := okl_api.start_activity(l_api_name
1599: ,g_pkg_name

Line 1598: x_return_status := okl_api.start_activity(l_api_name

1594: l_api_name VARCHAR2(40) := 'invalid_objects';
1595: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1596:
1597: BEGIN
1598: x_return_status := okl_api.start_activity(l_api_name
1599: ,g_pkg_name
1600: ,p_init_msg_list
1601: ,l_api_version
1602: ,p_api_version

Line 1606: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1602: ,p_api_version
1603: ,'_PVT'
1604: ,x_return_status);
1605:
1606: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1607: RAISE okl_api.g_exception_unexpected_error;
1608: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1609: RAISE okl_api.g_exception_error;
1610: END IF;

Line 1607: RAISE okl_api.g_exception_unexpected_error;

1603: ,'_PVT'
1604: ,x_return_status);
1605:
1606: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1607: RAISE okl_api.g_exception_unexpected_error;
1608: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1609: RAISE okl_api.g_exception_error;
1610: END IF;
1611:

Line 1608: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1604: ,x_return_status);
1605:
1606: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1607: RAISE okl_api.g_exception_unexpected_error;
1608: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1609: RAISE okl_api.g_exception_error;
1610: END IF;
1611:
1612: FOR lrs_invalid_record IN lrs_invalids_csr(p_version_id) LOOP

Line 1609: RAISE okl_api.g_exception_error;

1605:
1606: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1607: RAISE okl_api.g_exception_unexpected_error;
1608: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1609: RAISE okl_api.g_exception_error;
1610: END IF;
1611:
1612: FOR lrs_invalid_record IN lrs_invalids_csr(p_version_id) LOOP
1613: x_obj_tbl(i).obj_id := lrs_invalid_record.id;

Line 1622: okl_api.end_activity(x_msg_count

1618: END LOOP;
1619:
1620: --end activity
1621:
1622: okl_api.end_activity(x_msg_count
1623: ,x_msg_data);
1624: x_return_status := l_return_status;
1625: EXCEPTION
1626: WHEN okl_api.g_exception_error THEN

Line 1626: WHEN okl_api.g_exception_error THEN

1622: okl_api.end_activity(x_msg_count
1623: ,x_msg_data);
1624: x_return_status := l_return_status;
1625: EXCEPTION
1626: WHEN okl_api.g_exception_error THEN
1627: x_return_status := okl_api.handle_exceptions(l_api_name
1628: ,g_pkg_name
1629: ,'OKL_API.G_RET_STS_ERROR'
1630: ,x_msg_count

Line 1627: x_return_status := okl_api.handle_exceptions(l_api_name

1623: ,x_msg_data);
1624: x_return_status := l_return_status;
1625: EXCEPTION
1626: WHEN okl_api.g_exception_error THEN
1627: x_return_status := okl_api.handle_exceptions(l_api_name
1628: ,g_pkg_name
1629: ,'OKL_API.G_RET_STS_ERROR'
1630: ,x_msg_count
1631: ,x_msg_data

Line 1629: ,'OKL_API.G_RET_STS_ERROR'

1625: EXCEPTION
1626: WHEN okl_api.g_exception_error THEN
1627: x_return_status := okl_api.handle_exceptions(l_api_name
1628: ,g_pkg_name
1629: ,'OKL_API.G_RET_STS_ERROR'
1630: ,x_msg_count
1631: ,x_msg_data
1632: ,'_PVT');
1633: WHEN okl_api.g_exception_unexpected_error THEN

Line 1633: WHEN okl_api.g_exception_unexpected_error THEN

1629: ,'OKL_API.G_RET_STS_ERROR'
1630: ,x_msg_count
1631: ,x_msg_data
1632: ,'_PVT');
1633: WHEN okl_api.g_exception_unexpected_error THEN
1634: x_return_status := okl_api.handle_exceptions(l_api_name
1635: ,g_pkg_name
1636: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1637: ,x_msg_count

Line 1634: x_return_status := okl_api.handle_exceptions(l_api_name

1630: ,x_msg_count
1631: ,x_msg_data
1632: ,'_PVT');
1633: WHEN okl_api.g_exception_unexpected_error THEN
1634: x_return_status := okl_api.handle_exceptions(l_api_name
1635: ,g_pkg_name
1636: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1637: ,x_msg_count
1638: ,x_msg_data

Line 1636: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1632: ,'_PVT');
1633: WHEN okl_api.g_exception_unexpected_error THEN
1634: x_return_status := okl_api.handle_exceptions(l_api_name
1635: ,g_pkg_name
1636: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1637: ,x_msg_count
1638: ,x_msg_data
1639: ,'_PVT');
1640: WHEN OTHERS THEN

Line 1641: x_return_status := okl_api.handle_exceptions(l_api_name

1637: ,x_msg_count
1638: ,x_msg_data
1639: ,'_PVT');
1640: WHEN OTHERS THEN
1641: x_return_status := okl_api.handle_exceptions(l_api_name
1642: ,g_pkg_name
1643: ,'OTHERS'
1644: ,x_msg_count
1645: ,x_msg_data

Line 1652: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1648:
1649: -- to calculate the start date of the new version
1650:
1651: PROCEDURE calc_start_date(p_api_version IN NUMBER
1652: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1653: ,x_return_status OUT NOCOPY VARCHAR2
1654: ,x_msg_count OUT NOCOPY NUMBER
1655: ,x_msg_data OUT NOCOPY VARCHAR2
1656: ,p_srv_rec IN okl_srv_rec

Line 1665: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1661: l_api_version NUMBER := 1.0;
1662: l_srv_rec okl_srv_rec := p_srv_rec;
1663: l_eff_from DATE;
1664: l_eff_to DATE;
1665: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1666: l_start_date l_start_date_type;
1667: l_max_start_date DATE;
1668: i NUMBER;
1669:

Line 1722: l_return_status := okl_api.start_activity(l_api_name

1718: ,okl_fe_criteria ecl
1719: WHERE ecl.criteria_set_id = ech.criteria_set_id
1720: AND ech.source_id = p_version_id AND source_object_code = 'SRT';
1721: BEGIN
1722: l_return_status := okl_api.start_activity(l_api_name
1723: ,g_pkg_name
1724: ,p_init_msg_list
1725: ,l_api_version
1726: ,p_api_version

Line 1730: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1726: ,p_api_version
1727: ,'_PVT'
1728: ,x_return_status);
1729:
1730: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1731: RAISE okl_api.g_exception_unexpected_error;
1732: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1733: RAISE okl_api.g_exception_error;
1734: END IF;

Line 1731: RAISE okl_api.g_exception_unexpected_error;

1727: ,'_PVT'
1728: ,x_return_status);
1729:
1730: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1731: RAISE okl_api.g_exception_unexpected_error;
1732: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1733: RAISE okl_api.g_exception_error;
1734: END IF;
1735:

Line 1732: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1728: ,x_return_status);
1729:
1730: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1731: RAISE okl_api.g_exception_unexpected_error;
1732: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1733: RAISE okl_api.g_exception_error;
1734: END IF;
1735:
1736: --fetch the data from the different cursors

Line 1733: RAISE okl_api.g_exception_error;

1729:
1730: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1731: RAISE okl_api.g_exception_unexpected_error;
1732: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1733: RAISE okl_api.g_exception_error;
1734: END IF;
1735:
1736: --fetch the data from the different cursors
1737:

Line 1751: l_max_start_date:= okl_api.g_miss_date;

1747: ELSE
1748: l_max_start_date := l_eff_from + 1;
1749: END IF;
1750: ELSE
1751: l_max_start_date:= okl_api.g_miss_date;
1752: END IF;
1753: CLOSE prev_ver_csr;
1754:
1755: IF (l_eff_to IS NULL) THEN

Line 1794: okl_api.end_activity(x_msg_count

1790: x_cal_eff_from := l_max_start_date;
1791:
1792: --end activity
1793:
1794: okl_api.end_activity(x_msg_count
1795: ,x_msg_data);
1796: x_return_status := l_return_status;
1797: EXCEPTION
1798: WHEN okl_api.g_exception_error THEN

Line 1798: WHEN okl_api.g_exception_error THEN

1794: okl_api.end_activity(x_msg_count
1795: ,x_msg_data);
1796: x_return_status := l_return_status;
1797: EXCEPTION
1798: WHEN okl_api.g_exception_error THEN
1799: x_return_status := okl_api.handle_exceptions(l_api_name
1800: ,g_pkg_name
1801: ,'OKL_API.G_RET_STS_ERROR'
1802: ,x_msg_count

Line 1799: x_return_status := okl_api.handle_exceptions(l_api_name

1795: ,x_msg_data);
1796: x_return_status := l_return_status;
1797: EXCEPTION
1798: WHEN okl_api.g_exception_error THEN
1799: x_return_status := okl_api.handle_exceptions(l_api_name
1800: ,g_pkg_name
1801: ,'OKL_API.G_RET_STS_ERROR'
1802: ,x_msg_count
1803: ,x_msg_data

Line 1801: ,'OKL_API.G_RET_STS_ERROR'

1797: EXCEPTION
1798: WHEN okl_api.g_exception_error THEN
1799: x_return_status := okl_api.handle_exceptions(l_api_name
1800: ,g_pkg_name
1801: ,'OKL_API.G_RET_STS_ERROR'
1802: ,x_msg_count
1803: ,x_msg_data
1804: ,'_PVT');
1805: WHEN okl_api.g_exception_unexpected_error THEN

Line 1805: WHEN okl_api.g_exception_unexpected_error THEN

1801: ,'OKL_API.G_RET_STS_ERROR'
1802: ,x_msg_count
1803: ,x_msg_data
1804: ,'_PVT');
1805: WHEN okl_api.g_exception_unexpected_error THEN
1806: x_return_status := okl_api.handle_exceptions(l_api_name
1807: ,g_pkg_name
1808: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1809: ,x_msg_count

Line 1806: x_return_status := okl_api.handle_exceptions(l_api_name

1802: ,x_msg_count
1803: ,x_msg_data
1804: ,'_PVT');
1805: WHEN okl_api.g_exception_unexpected_error THEN
1806: x_return_status := okl_api.handle_exceptions(l_api_name
1807: ,g_pkg_name
1808: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1809: ,x_msg_count
1810: ,x_msg_data

Line 1808: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1804: ,'_PVT');
1805: WHEN okl_api.g_exception_unexpected_error THEN
1806: x_return_status := okl_api.handle_exceptions(l_api_name
1807: ,g_pkg_name
1808: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1809: ,x_msg_count
1810: ,x_msg_data
1811: ,'_PVT');
1812: WHEN OTHERS THEN

Line 1813: x_return_status := okl_api.handle_exceptions(l_api_name

1809: ,x_msg_count
1810: ,x_msg_data
1811: ,'_PVT');
1812: WHEN OTHERS THEN
1813: x_return_status := okl_api.handle_exceptions(l_api_name
1814: ,g_pkg_name
1815: ,'OTHERS'
1816: ,x_msg_count
1817: ,x_msg_data

Line 1824: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1820:
1821: --this api should be called to end date any ACTIVE srt version
1822:
1823: PROCEDURE enddate_std_rate_tmpl(p_api_version IN NUMBER
1824: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1825: ,x_return_status OUT NOCOPY VARCHAR2
1826: ,x_msg_count OUT NOCOPY NUMBER
1827: ,x_msg_data OUT NOCOPY VARCHAR2
1828: ,p_srv_id_tbl IN okl_number_table

Line 1883: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1879: l_sts_code VARCHAR2(30);
1880: l_srt_id NUMBER;
1881: l_api_name CONSTANT VARCHAR2(30) := 'enddate_std_rate_tmpl';
1882: l_api_version CONSTANT NUMBER := 1.0;
1883: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1884: l_dummy VARCHAR2(1) := '?';
1885: lp_lrtv_tbl okl_lrs_id_tbl;
1886: n NUMBER :=1;
1887:

Line 1893: l_return_status := okl_api.start_activity(l_api_name

1889:
1890: -- call START_ACTIVITY to create savepoint, check compatibility
1891: -- and initialize message list
1892:
1893: l_return_status := okl_api.start_activity(l_api_name
1894: ,g_pkg_name
1895: ,p_init_msg_list
1896: ,l_api_version
1897: ,p_api_version

Line 1903: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1899: ,x_return_status);
1900:
1901: -- check if activity started successfully
1902:
1903: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1904: RAISE okl_api.g_exception_unexpected_error;
1905: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1906: RAISE okl_api.g_exception_error;
1907: END IF;

Line 1904: RAISE okl_api.g_exception_unexpected_error;

1900:
1901: -- check if activity started successfully
1902:
1903: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1904: RAISE okl_api.g_exception_unexpected_error;
1905: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1906: RAISE okl_api.g_exception_error;
1907: END IF;
1908:

Line 1905: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1901: -- check if activity started successfully
1902:
1903: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1904: RAISE okl_api.g_exception_unexpected_error;
1905: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1906: RAISE okl_api.g_exception_error;
1907: END IF;
1908:
1909: FOR i IN p_srv_id_tbl.FIRST..p_srv_id_tbl.LAST LOOP

Line 1906: RAISE okl_api.g_exception_error;

1902:
1903: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1904: RAISE okl_api.g_exception_unexpected_error;
1905: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1906: RAISE okl_api.g_exception_error;
1907: END IF;
1908:
1909: FOR i IN p_srv_id_tbl.FIRST..p_srv_id_tbl.LAST LOOP
1910: OPEN get_effective_dates_csr(p_srv_id_tbl(i));

Line 2001: IF l_return_status = okl_api.g_ret_sts_error THEN

1997: ,x_msg_count
1998: ,x_msg_data
1999: ,lp_srv_rec
2000: ,lx_srv_rec);
2001: IF l_return_status = okl_api.g_ret_sts_error THEN
2002: RAISE okl_api.g_exception_error;
2003: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2004: RAISE okl_api.g_exception_unexpected_error;
2005: END IF;

Line 2002: RAISE okl_api.g_exception_error;

1998: ,x_msg_data
1999: ,lp_srv_rec
2000: ,lx_srv_rec);
2001: IF l_return_status = okl_api.g_ret_sts_error THEN
2002: RAISE okl_api.g_exception_error;
2003: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2004: RAISE okl_api.g_exception_unexpected_error;
2005: END IF;
2006: END IF;

Line 2003: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN

1999: ,lp_srv_rec
2000: ,lx_srv_rec);
2001: IF l_return_status = okl_api.g_ret_sts_error THEN
2002: RAISE okl_api.g_exception_error;
2003: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2004: RAISE okl_api.g_exception_unexpected_error;
2005: END IF;
2006: END IF;
2007:

Line 2004: RAISE okl_api.g_exception_unexpected_error;

2000: ,lx_srv_rec);
2001: IF l_return_status = okl_api.g_ret_sts_error THEN
2002: RAISE okl_api.g_exception_error;
2003: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2004: RAISE okl_api.g_exception_unexpected_error;
2005: END IF;
2006: END IF;
2007:
2008: --update the header

Line 2018: IF l_return_status = okl_api.g_ret_sts_error THEN

2014: ,x_msg_count
2015: ,x_msg_data
2016: ,lp_srtv_rec
2017: ,lx_srtv_rec);
2018: IF l_return_status = okl_api.g_ret_sts_error THEN
2019: RAISE okl_api.g_exception_error;
2020: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2021: RAISE okl_api.g_exception_unexpected_error;
2022: END IF;

Line 2019: RAISE okl_api.g_exception_error;

2015: ,x_msg_data
2016: ,lp_srtv_rec
2017: ,lx_srtv_rec);
2018: IF l_return_status = okl_api.g_ret_sts_error THEN
2019: RAISE okl_api.g_exception_error;
2020: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2021: RAISE okl_api.g_exception_unexpected_error;
2022: END IF;
2023: END IF;

Line 2020: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN

2016: ,lp_srtv_rec
2017: ,lx_srtv_rec);
2018: IF l_return_status = okl_api.g_ret_sts_error THEN
2019: RAISE okl_api.g_exception_error;
2020: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2021: RAISE okl_api.g_exception_unexpected_error;
2022: END IF;
2023: END IF;
2024:

Line 2021: RAISE okl_api.g_exception_unexpected_error;

2017: ,lx_srtv_rec);
2018: IF l_return_status = okl_api.g_ret_sts_error THEN
2019: RAISE okl_api.g_exception_error;
2020: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
2021: RAISE okl_api.g_exception_unexpected_error;
2022: END IF;
2023: END IF;
2024:
2025: END LOOP;

Line 2027: okl_api.end_activity(x_msg_count => x_msg_count

2023: END IF;
2024:
2025: END LOOP;
2026: x_return_status := l_return_status;
2027: okl_api.end_activity(x_msg_count => x_msg_count
2028: ,x_msg_data => x_msg_data);
2029: EXCEPTION
2030: WHEN okl_api.g_exception_error THEN
2031: x_return_status := okl_api.handle_exceptions(l_api_name

Line 2030: WHEN okl_api.g_exception_error THEN

2026: x_return_status := l_return_status;
2027: okl_api.end_activity(x_msg_count => x_msg_count
2028: ,x_msg_data => x_msg_data);
2029: EXCEPTION
2030: WHEN okl_api.g_exception_error THEN
2031: x_return_status := okl_api.handle_exceptions(l_api_name
2032: ,g_pkg_name
2033: ,'OKL_API.G_RET_STS_ERROR'
2034: ,x_msg_count

Line 2031: x_return_status := okl_api.handle_exceptions(l_api_name

2027: okl_api.end_activity(x_msg_count => x_msg_count
2028: ,x_msg_data => x_msg_data);
2029: EXCEPTION
2030: WHEN okl_api.g_exception_error THEN
2031: x_return_status := okl_api.handle_exceptions(l_api_name
2032: ,g_pkg_name
2033: ,'OKL_API.G_RET_STS_ERROR'
2034: ,x_msg_count
2035: ,x_msg_data

Line 2033: ,'OKL_API.G_RET_STS_ERROR'

2029: EXCEPTION
2030: WHEN okl_api.g_exception_error THEN
2031: x_return_status := okl_api.handle_exceptions(l_api_name
2032: ,g_pkg_name
2033: ,'OKL_API.G_RET_STS_ERROR'
2034: ,x_msg_count
2035: ,x_msg_data
2036: ,'_PVT');
2037: WHEN okl_api.g_exception_unexpected_error THEN

Line 2037: WHEN okl_api.g_exception_unexpected_error THEN

2033: ,'OKL_API.G_RET_STS_ERROR'
2034: ,x_msg_count
2035: ,x_msg_data
2036: ,'_PVT');
2037: WHEN okl_api.g_exception_unexpected_error THEN
2038: x_return_status := okl_api.handle_exceptions(l_api_name
2039: ,g_pkg_name
2040: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2041: ,x_msg_count

Line 2038: x_return_status := okl_api.handle_exceptions(l_api_name

2034: ,x_msg_count
2035: ,x_msg_data
2036: ,'_PVT');
2037: WHEN okl_api.g_exception_unexpected_error THEN
2038: x_return_status := okl_api.handle_exceptions(l_api_name
2039: ,g_pkg_name
2040: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2041: ,x_msg_count
2042: ,x_msg_data

Line 2040: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2036: ,'_PVT');
2037: WHEN okl_api.g_exception_unexpected_error THEN
2038: x_return_status := okl_api.handle_exceptions(l_api_name
2039: ,g_pkg_name
2040: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2041: ,x_msg_count
2042: ,x_msg_data
2043: ,'_PVT');
2044: WHEN OTHERS THEN

Line 2045: x_return_status := okl_api.handle_exceptions(l_api_name

2041: ,x_msg_count
2042: ,x_msg_data
2043: ,'_PVT');
2044: WHEN OTHERS THEN
2045: x_return_status := okl_api.handle_exceptions(l_api_name
2046: ,g_pkg_name
2047: ,'OTHERS'
2048: ,x_msg_count
2049: ,x_msg_data