APPS.OKL_ITEM_RESIDUALS_PVT dependencies on OKL_API

Line 58: OKL_API.set_message(p_app_name => G_APP_NAME,

54: BEGIN
55: FOR i IN p_irv_tbl.FIRST..p_irv_tbl.LAST
56: LOOP
57: IF p_irv_tbl(i).residual_value > 100 THEN
58: OKL_API.set_message(p_app_name => G_APP_NAME,
59: p_msg_name => 'OKL_INVALID_VALUE',
60: p_token1 => G_COL_NAME_TOKEN,
61: p_token1_value => 'Term ' || p_irv_tbl(i).term_in_months );
62: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 62: RAISE OKL_API.G_EXCEPTION_ERROR;

58: OKL_API.set_message(p_app_name => G_APP_NAME,
59: p_msg_name => 'OKL_INVALID_VALUE',
60: p_token1 => G_COL_NAME_TOKEN,
61: p_token1_value => 'Term ' || p_irv_tbl(i).term_in_months );
62: RAISE OKL_API.G_EXCEPTION_ERROR;
63:
64: END IF;
65: END LOOP;
66: END;

Line 91: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

87: CLOSE prev_effective_dates;
88:
89: IF l_ver_rec.START_DATE >= p_effective_from AND l_ver_rec.END_DATE IS NULL THEN
90: return_bool := FALSE;
91: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
92: p_msg_name => 'OKL_ST_INVALID_EFFECTIVE_FROM',
93: p_token1 => 'EFF_DATE',
94: p_token1_value => l_ver_rec.START_DATE+1);
95: ELSIF l_ver_rec.END_DATE >= p_effective_from THEN

Line 97: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

93: p_token1 => 'EFF_DATE',
94: p_token1_value => l_ver_rec.START_DATE+1);
95: ELSIF l_ver_rec.END_DATE >= p_effective_from THEN
96: return_bool := FALSE;
97: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
98: p_msg_name => 'OKL_ST_INVALID_EFFECTIVE_FROM',
99: p_token1 => 'EFF_DATE',
100: p_token1_value => l_ver_rec.END_DATE+1);
101: END IF;

Line 112: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

108: END valid_version_effective_date;
109:
110: PROCEDURE get_effective_date(
111: p_api_version IN NUMBER
112: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
113: , x_return_status OUT NOCOPY VARCHAR2
114: , x_msg_count OUT NOCOPY NUMBER
115: , x_msg_data OUT NOCOPY VARCHAR2
116: , p_item_resdl_ver_id IN NUMBER

Line 124: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

120: l_api_version CONSTANT NUMBER := p_api_version;
121: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
122: l_msg_count NUMBER := x_msg_count ;
123: l_msg_data VARCHAR2(2000);
124: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
125:
126: l_calc_date DATE := NULL;
127: l_calc_date1 DATE := NULL;
128: l_calc_date2 DATE := NULL;

Line 285: l_return_status := OKL_API.start_activity(l_api_name

281: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
282: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call get_effective_date');
283: END IF;
284:
285: l_return_status := OKL_API.start_activity(l_api_name
286: ,G_PKG_NAME
287: ,p_init_msg_list
288: ,l_api_version
289: ,p_api_version

Line 292: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

288: ,l_api_version
289: ,p_api_version
290: ,'_PVT'
291: ,x_return_status);
292: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;

Line 293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

289: ,p_api_version
290: ,'_PVT'
291: ,x_return_status);
292: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297:

Line 294: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

290: ,'_PVT'
291: ,x_return_status);
292: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297:
298: -- Get the end date of the version.

Line 295: RAISE OKL_API.G_EXCEPTION_ERROR;

291: ,x_return_status);
292: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297:
298: -- Get the end date of the version.
299: OPEN get_version_dtls(p_item_resdl_ver_id);

Line 359: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

355: END IF;
356:
357: x_calc_date := l_calc_date;
358: x_return_status := l_return_status;
359: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
360:
361: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call get_effective_date');
363: END IF;

Line 366: WHEN OKL_API.G_EXCEPTION_ERROR THEN

362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call get_effective_date');
363: END IF;
364:
365: EXCEPTION
366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
367:
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
369: (
370: l_api_name,

Line 368: x_return_status := OKL_API.HANDLE_EXCEPTIONS

364:
365: EXCEPTION
366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
367:
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
369: (
370: l_api_name,
371: G_PKG_NAME,
372: 'OKL_API.G_RET_STS_ERROR',

Line 372: 'OKL_API.G_RET_STS_ERROR',

368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
369: (
370: l_api_name,
371: G_PKG_NAME,
372: 'OKL_API.G_RET_STS_ERROR',
373: x_msg_count,
374: x_msg_data,
375: '_PVT'
376: );

Line 378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

374: x_msg_data,
375: '_PVT'
376: );
377:
378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
379:
380: x_return_status := OKL_API.HANDLE_EXCEPTIONS
381: (
382: l_api_name,

Line 380: x_return_status := OKL_API.HANDLE_EXCEPTIONS

376: );
377:
378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
379:
380: x_return_status := OKL_API.HANDLE_EXCEPTIONS
381: (
382: l_api_name,
383: G_PKG_NAME,
384: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 384: 'OKL_API.G_RET_STS_UNEXP_ERROR',

380: x_return_status := OKL_API.HANDLE_EXCEPTIONS
381: (
382: l_api_name,
383: G_PKG_NAME,
384: 'OKL_API.G_RET_STS_UNEXP_ERROR',
385: x_msg_count,
386: x_msg_data,
387: '_PVT'
388: );

Line 392: x_return_status := OKL_API.HANDLE_EXCEPTIONS

388: );
389:
390: WHEN OTHERS THEN
391:
392: x_return_status := OKL_API.HANDLE_EXCEPTIONS
393: (
394: l_api_name,
395: G_PKG_NAME,
396: 'OTHERS',

Line 404: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

400: );
401: END get_effective_date;
402: PROCEDURE create_irs (
403: p_api_version IN NUMBER
404: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
405: , x_return_status OUT NOCOPY VARCHAR2
406: , x_msg_count OUT NOCOPY NUMBER
407: , x_msg_data OUT NOCOPY VARCHAR2
408: , p_irhv_rec IN okl_irhv_rec

Line 419: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

415: l_api_version CONSTANT NUMBER := p_api_version;
416: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
417: l_msg_count NUMBER := x_msg_count ;
418: l_msg_data VARCHAR2(2000);
419: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
420:
421: lx_irv_tbl okl_irv_tbl;
422: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
423: lp_irv_tbl okl_irv_tbl := p_irv_tbl;

Line 436: l_return_status := OKL_API.start_activity(l_api_name

432: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
433: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs');
434: END IF;
435:
436: l_return_status := OKL_API.start_activity(l_api_name
437: ,G_PKG_NAME
438: ,p_init_msg_list
439: ,l_api_version
440: ,p_api_version

Line 443: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

439: ,l_api_version
440: ,p_api_version
441: ,'_PVT'
442: ,x_return_status);
443: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
445: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
446: RAISE OKL_API.G_EXCEPTION_ERROR;
447: END IF;

Line 444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

440: ,p_api_version
441: ,'_PVT'
442: ,x_return_status);
443: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
445: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
446: RAISE OKL_API.G_EXCEPTION_ERROR;
447: END IF;
448: -- Insert row into the header table

Line 445: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

441: ,'_PVT'
442: ,x_return_status);
443: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
445: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
446: RAISE OKL_API.G_EXCEPTION_ERROR;
447: END IF;
448: -- Insert row into the header table
449: OKL_IRH_PVT.insert_row(

Line 446: RAISE OKL_API.G_EXCEPTION_ERROR;

442: ,x_return_status);
443: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
445: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
446: RAISE OKL_API.G_EXCEPTION_ERROR;
447: END IF;
448: -- Insert row into the header table
449: OKL_IRH_PVT.insert_row(
450: p_api_version => p_api_version

Line 457: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

453: , x_msg_count => x_msg_count
454: , x_msg_data => x_msg_data
455: , p_irhv_rec => p_irhv_rec
456: , x_irhv_rec => x_irhv_rec);
457: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
460: RAISE OKL_API.G_EXCEPTION_ERROR;
461: END IF;

Line 458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

454: , x_msg_data => x_msg_data
455: , p_irhv_rec => p_irhv_rec
456: , x_irhv_rec => x_irhv_rec);
457: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
460: RAISE OKL_API.G_EXCEPTION_ERROR;
461: END IF;
462:

Line 459: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

455: , p_irhv_rec => p_irhv_rec
456: , x_irhv_rec => x_irhv_rec);
457: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
460: RAISE OKL_API.G_EXCEPTION_ERROR;
461: END IF;
462:
463: --Set the ITEM_RESIDUAL_ID in the versions table

Line 460: RAISE OKL_API.G_EXCEPTION_ERROR;

456: , x_irhv_rec => x_irhv_rec);
457: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
460: RAISE OKL_API.G_EXCEPTION_ERROR;
461: END IF;
462:
463: --Set the ITEM_RESIDUAL_ID in the versions table
464: lp_icpv_rec.item_residual_id := x_irhv_rec.item_residual_id;

Line 476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

472: , x_msg_count => x_msg_count
473: , x_msg_data => x_msg_data
474: , p_icpv_rec => lp_icpv_rec
475: , x_icpv_rec => x_icpv_rec);
476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;

Line 477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

473: , x_msg_data => x_msg_data
474: , p_icpv_rec => lp_icpv_rec
475: , x_icpv_rec => x_icpv_rec);
476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;
481:

Line 478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

474: , p_icpv_rec => lp_icpv_rec
475: , x_icpv_rec => x_icpv_rec);
476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482: IF lp_irv_tbl.COUNT > 0 THEN

Line 479: RAISE OKL_API.G_EXCEPTION_ERROR;

475: , x_icpv_rec => x_icpv_rec);
476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482: IF lp_irv_tbl.COUNT > 0 THEN
483: -- validate the Values of terms

Line 504: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

500: , x_msg_count => x_msg_count
501: , x_msg_data => x_msg_data
502: , p_irv_tbl => lp_irv_tbl
503: , x_irv_tbl => lx_irv_tbl );
504: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;

Line 505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

501: , x_msg_data => x_msg_data
502: , p_irv_tbl => lp_irv_tbl
503: , x_irv_tbl => lx_irv_tbl );
504: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: END IF; -- end of check for empty term- value pairs

Line 506: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

502: , p_irv_tbl => lp_irv_tbl
503: , x_irv_tbl => lx_irv_tbl );
504: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: END IF; -- end of check for empty term- value pairs
510:

Line 507: RAISE OKL_API.G_EXCEPTION_ERROR;

503: , x_irv_tbl => lx_irv_tbl );
504: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: END IF; -- end of check for empty term- value pairs
510:
511: x_return_status := l_return_status;

Line 512: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

508: END IF;
509: END IF; -- end of check for empty term- value pairs
510:
511: x_return_status := l_return_status;
512: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
513:
514: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
515: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs');
516: END IF;

Line 519: WHEN OKL_API.G_EXCEPTION_ERROR THEN

515: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs');
516: END IF;
517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520:
521: x_return_status := OKL_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,

Line 521: x_return_status := OKL_API.HANDLE_EXCEPTIONS

517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520:
521: x_return_status := OKL_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKL_API.G_RET_STS_ERROR',

Line 525: 'OKL_API.G_RET_STS_ERROR',

521: x_return_status := OKL_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKL_API.G_RET_STS_ERROR',
526: x_msg_count,
527: x_msg_data,
528: '_PVT'
529: );

Line 531: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

527: x_msg_data,
528: '_PVT'
529: );
530:
531: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
532:
533: x_return_status := OKL_API.HANDLE_EXCEPTIONS
534: (
535: l_api_name,

Line 533: x_return_status := OKL_API.HANDLE_EXCEPTIONS

529: );
530:
531: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
532:
533: x_return_status := OKL_API.HANDLE_EXCEPTIONS
534: (
535: l_api_name,
536: G_PKG_NAME,
537: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 537: 'OKL_API.G_RET_STS_UNEXP_ERROR',

533: x_return_status := OKL_API.HANDLE_EXCEPTIONS
534: (
535: l_api_name,
536: G_PKG_NAME,
537: 'OKL_API.G_RET_STS_UNEXP_ERROR',
538: x_msg_count,
539: x_msg_data,
540: '_PVT'
541: );

Line 545: x_return_status := OKL_API.HANDLE_EXCEPTIONS

541: );
542:
543: WHEN OTHERS THEN
544:
545: x_return_status := OKL_API.HANDLE_EXCEPTIONS
546: (
547: l_api_name,
548: G_PKG_NAME,
549: 'OTHERS',

Line 558: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

554: END create_irs;
555:
556: PROCEDURE update_version_irs (
557: p_api_version IN NUMBER
558: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
559: , x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_irhv_rec IN okl_irhv_rec

Line 573: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

569: l_api_version CONSTANT NUMBER := p_api_version;
570: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
571: l_msg_count NUMBER := x_msg_count ;
572: l_msg_data VARCHAR2(2000);
573: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
574: l_end_date DATE := NULL;
575: l_change_sts VARCHAR2(1) := 'n';
576: l_confirm_yn VARCHAR2(3) := 'yes';
577:

Line 616: l_return_status := OKL_API.start_activity(l_api_name

612: -- Initialize the OUT records
613: x_irhv_rec := p_irhv_rec;
614: x_icpv_rec := p_icpv_rec;
615:
616: l_return_status := OKL_API.start_activity(l_api_name
617: ,G_PKG_NAME
618: ,p_init_msg_list
619: ,l_api_version
620: ,p_api_version

Line 623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

619: ,l_api_version
620: ,p_api_version
621: ,'_PVT'
622: ,x_return_status);
623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
626: RAISE OKL_API.G_EXCEPTION_ERROR;
627: END IF;

Line 624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

620: ,p_api_version
621: ,'_PVT'
622: ,x_return_status);
623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
626: RAISE OKL_API.G_EXCEPTION_ERROR;
627: END IF;
628:

Line 625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

621: ,'_PVT'
622: ,x_return_status);
623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
626: RAISE OKL_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: /* Calculate the effective date */

Line 626: RAISE OKL_API.G_EXCEPTION_ERROR;

622: ,x_return_status);
623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
626: RAISE OKL_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: /* Calculate the effective date */
630: get_effective_date(

Line 639: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

635: , x_msg_data
636: , lp_icpv_rec.id
637: , l_calc_date
638: );
639: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
642: RAISE OKL_API.G_EXCEPTION_ERROR;
643: END IF;

Line 640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

636: , lp_icpv_rec.id
637: , l_calc_date
638: );
639: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
642: RAISE OKL_API.G_EXCEPTION_ERROR;
643: END IF;
644:

Line 641: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

637: , l_calc_date
638: );
639: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
642: RAISE OKL_API.G_EXCEPTION_ERROR;
643: END IF;
644:
645: OPEN get_version_details(lp_icpv_rec.id);

Line 642: RAISE OKL_API.G_EXCEPTION_ERROR;

638: );
639: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
642: RAISE OKL_API.G_EXCEPTION_ERROR;
643: END IF;
644:
645: OPEN get_version_details(lp_icpv_rec.id);
646: FETCH get_version_details INTO l_db_ver_end_date;

Line 651: lp_icpv_rec.end_date := OKL_API.G_MISS_DATE;

647: CLOSE get_version_details;
648:
649: -- Set for G_MISS_CHANGES. Set to G_MISS if null is to be updated
650: IF lp_icpv_rec.end_date IS NULL THEN
651: lp_icpv_rec.end_date := OKL_API.G_MISS_DATE;
652: END IF;
653:
654: OKL_ICP_PVT.update_row(
655: p_api_version => p_api_version

Line 662: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

658: , x_msg_count => x_msg_count
659: , x_msg_data => x_msg_data
660: , p_icpv_rec => lp_icpv_rec
661: , x_icpv_rec => x_icpv_rec);
662: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;

Line 663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

659: , x_msg_data => x_msg_data
660: , p_icpv_rec => lp_icpv_rec
661: , x_icpv_rec => x_icpv_rec);
662: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667:

Line 664: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

660: , p_icpv_rec => lp_icpv_rec
661: , x_icpv_rec => x_icpv_rec);
662: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667:
668: j := 1;

Line 665: RAISE OKL_API.G_EXCEPTION_ERROR;

661: , x_icpv_rec => x_icpv_rec);
662: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667:
668: j := 1;
669: k:=1;

Line 677: IF p_irv_tbl(i).item_resdl_value_id IS NULL OR p_irv_tbl(i).item_resdl_value_id = OKL_API.G_MISS_NUM THEN

673: validate_percent_values(p_irv_tbl);
674: END IF;
675: FOR i IN p_irv_tbl.FIRST..p_irv_tbl.LAST
676: LOOP
677: IF p_irv_tbl(i).item_resdl_value_id IS NULL OR p_irv_tbl(i).item_resdl_value_id = OKL_API.G_MISS_NUM THEN
678: lp_crt_irv_tbl(j) := p_irv_tbl(i);
679: lp_crt_irv_tbl(j).item_residual_id := x_icpv_rec.item_residual_id;
680: lp_crt_irv_tbl(j).item_resdl_version_id := x_icpv_rec.id;
681: j := j+1;

Line 701: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

697: , x_msg_count => x_msg_count
698: , x_msg_data => x_msg_data
699: , p_irv_tbl => lp_upd_irv_tbl
700: , x_irv_tbl => lx_upd_irv_tbl );
701: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
704: RAISE OKL_API.G_EXCEPTION_ERROR;
705: END IF;

Line 702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

698: , x_msg_data => x_msg_data
699: , p_irv_tbl => lp_upd_irv_tbl
700: , x_irv_tbl => lx_upd_irv_tbl );
701: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
704: RAISE OKL_API.G_EXCEPTION_ERROR;
705: END IF;
706: END IF;

Line 703: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

699: , p_irv_tbl => lp_upd_irv_tbl
700: , x_irv_tbl => lx_upd_irv_tbl );
701: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
704: RAISE OKL_API.G_EXCEPTION_ERROR;
705: END IF;
706: END IF;
707:

Line 704: RAISE OKL_API.G_EXCEPTION_ERROR;

700: , x_irv_tbl => lx_upd_irv_tbl );
701: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
704: RAISE OKL_API.G_EXCEPTION_ERROR;
705: END IF;
706: END IF;
707:
708: IF lp_crt_irv_tbl.COUNT >0 THEN

Line 717: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

713: , x_msg_count => x_msg_count
714: , x_msg_data => x_msg_data
715: , p_irv_tbl => lp_crt_irv_tbl
716: , x_irv_tbl => lx_crt_irv_tbl );
717: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
719: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
720: RAISE OKL_API.G_EXCEPTION_ERROR;
721: END IF;

Line 718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

714: , x_msg_data => x_msg_data
715: , p_irv_tbl => lp_crt_irv_tbl
716: , x_irv_tbl => lx_crt_irv_tbl );
717: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
719: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
720: RAISE OKL_API.G_EXCEPTION_ERROR;
721: END IF;
722: END IF;

Line 719: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

715: , p_irv_tbl => lp_crt_irv_tbl
716: , x_irv_tbl => lx_crt_irv_tbl );
717: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
719: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
720: RAISE OKL_API.G_EXCEPTION_ERROR;
721: END IF;
722: END IF;
723: END IF;

Line 720: RAISE OKL_API.G_EXCEPTION_ERROR;

716: , x_irv_tbl => lx_crt_irv_tbl );
717: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
719: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
720: RAISE OKL_API.G_EXCEPTION_ERROR;
721: END IF;
722: END IF;
723: END IF;
724:

Line 742: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

738: , x_msg_count => x_msg_count
739: , x_msg_data => x_msg_data
740: , p_irhv_rec => lp_irhv_rec
741: , x_irhv_rec => x_irhv_rec);
742: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_ERROR;
746: END IF;

Line 743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

739: , x_msg_data => x_msg_data
740: , p_irhv_rec => lp_irhv_rec
741: , x_irhv_rec => x_irhv_rec);
742: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_ERROR;
746: END IF;
747:

Line 744: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

740: , p_irhv_rec => lp_irhv_rec
741: , x_irhv_rec => x_irhv_rec);
742: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_ERROR;
746: END IF;
747:
748: -- Call the API to end date or abandon any Lease Rate Set referring to this item residual

Line 745: RAISE OKL_API.G_EXCEPTION_ERROR;

741: , x_irhv_rec => x_irhv_rec);
742: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_ERROR;
746: END IF;
747:
748: -- Call the API to end date or abandon any Lease Rate Set referring to this item residual
749: change_LRS_sts (

Line 760: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

756: , p_icpv_rec => x_icpv_rec
757: , x_lrs_list => l_lrs_list
758: , x_change_sts => l_change_sts
759: );
760: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;

Line 761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

757: , x_lrs_list => l_lrs_list
758: , x_change_sts => l_change_sts
759: );
760: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765: END IF; -- end of check for version end date change

Line 762: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

758: , x_change_sts => l_change_sts
759: );
760: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765: END IF; -- end of check for version end date change
766: END IF; -- end of check for latest version

Line 763: RAISE OKL_API.G_EXCEPTION_ERROR;

759: );
760: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765: END IF; -- end of check for version end date change
766: END IF; -- end of check for latest version
767:

Line 769: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

765: END IF; -- end of check for version end date change
766: END IF; -- end of check for latest version
767:
768: x_return_status := l_return_status;
769: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
770:
771: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
772: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs');
773: END IF;

Line 776: WHEN OKL_API.G_EXCEPTION_ERROR THEN

772: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs');
773: END IF;
774:
775: EXCEPTION
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777:
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS
779: (
780: l_api_name,

Line 778: x_return_status := OKL_API.HANDLE_EXCEPTIONS

774:
775: EXCEPTION
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777:
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS
779: (
780: l_api_name,
781: G_PKG_NAME,
782: 'OKL_API.G_RET_STS_ERROR',

Line 782: 'OKL_API.G_RET_STS_ERROR',

778: x_return_status := OKL_API.HANDLE_EXCEPTIONS
779: (
780: l_api_name,
781: G_PKG_NAME,
782: 'OKL_API.G_RET_STS_ERROR',
783: x_msg_count,
784: x_msg_data,
785: '_PVT'
786: );

Line 788: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

784: x_msg_data,
785: '_PVT'
786: );
787:
788: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
789:
790: x_return_status := OKL_API.HANDLE_EXCEPTIONS
791: (
792: l_api_name,

Line 790: x_return_status := OKL_API.HANDLE_EXCEPTIONS

786: );
787:
788: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
789:
790: x_return_status := OKL_API.HANDLE_EXCEPTIONS
791: (
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 794: 'OKL_API.G_RET_STS_UNEXP_ERROR',

790: x_return_status := OKL_API.HANDLE_EXCEPTIONS
791: (
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_UNEXP_ERROR',
795: x_msg_count,
796: x_msg_data,
797: '_PVT'
798: );

Line 802: x_return_status := OKL_API.HANDLE_EXCEPTIONS

798: );
799:
800: WHEN OTHERS THEN
801:
802: x_return_status := OKL_API.HANDLE_EXCEPTIONS
803: (
804: l_api_name,
805: G_PKG_NAME,
806: 'OTHERS',

Line 815: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

811: END update_version_irs;
812:
813: procedure create_version_irs (
814: p_api_version IN NUMBER
815: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
816: , x_return_status OUT NOCOPY VARCHAR2
817: , x_msg_count OUT NOCOPY NUMBER
818: , x_msg_data OUT NOCOPY VARCHAR2
819: , p_irhv_rec IN okl_irhv_rec

Line 830: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

826: l_api_version CONSTANT NUMBER := p_api_version;
827: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
828: l_msg_count NUMBER := x_msg_count ;
829: l_msg_data VARCHAR2(2000);
830: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
831:
832: lx_irv_tbl okl_irv_tbl;
833: lp_irhv_rec okl_irhv_rec := p_irhv_rec;
834: lp_icpv_rec okl_icpv_rec := p_icpv_rec;

Line 850: l_return_status := OKL_API.start_activity(l_api_name

846: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs');
848: END IF;
849:
850: l_return_status := OKL_API.start_activity(l_api_name
851: ,G_PKG_NAME
852: ,p_init_msg_list
853: ,l_api_version
854: ,p_api_version

Line 857: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

853: ,l_api_version
854: ,p_api_version
855: ,'_PVT'
856: ,x_return_status);
857: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
860: RAISE OKL_API.G_EXCEPTION_ERROR;
861: END IF;

Line 858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

854: ,p_api_version
855: ,'_PVT'
856: ,x_return_status);
857: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
860: RAISE OKL_API.G_EXCEPTION_ERROR;
861: END IF;
862:

Line 859: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

855: ,'_PVT'
856: ,x_return_status);
857: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
860: RAISE OKL_API.G_EXCEPTION_ERROR;
861: END IF;
862:
863: lp_icpv_rec.item_residual_id := lp_irhv_rec.item_residual_id;

Line 860: RAISE OKL_API.G_EXCEPTION_ERROR;

856: ,x_return_status);
857: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
860: RAISE OKL_API.G_EXCEPTION_ERROR;
861: END IF;
862:
863: lp_icpv_rec.item_residual_id := lp_irhv_rec.item_residual_id;
864:

Line 874: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

870: , x_msg_count => x_msg_count
871: , x_msg_data => x_msg_data
872: , p_icpv_rec => lp_icpv_rec
873: , x_icpv_rec => x_icpv_rec);
874: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
876: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
877: RAISE OKL_API.G_EXCEPTION_ERROR;
878: END IF;

Line 875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

871: , x_msg_data => x_msg_data
872: , p_icpv_rec => lp_icpv_rec
873: , x_icpv_rec => x_icpv_rec);
874: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
876: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
877: RAISE OKL_API.G_EXCEPTION_ERROR;
878: END IF;
879:

Line 876: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

872: , p_icpv_rec => lp_icpv_rec
873: , x_icpv_rec => x_icpv_rec);
874: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
876: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
877: RAISE OKL_API.G_EXCEPTION_ERROR;
878: END IF;
879:
880: IF lp_irv_tbl.COUNT > 0 THEN

Line 877: RAISE OKL_API.G_EXCEPTION_ERROR;

873: , x_icpv_rec => x_icpv_rec);
874: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
876: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
877: RAISE OKL_API.G_EXCEPTION_ERROR;
878: END IF;
879:
880: IF lp_irv_tbl.COUNT > 0 THEN
881: -- validate the Values of terms

Line 901: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

897: , x_msg_count => x_msg_count
898: , x_msg_data => x_msg_data
899: , p_irv_tbl => lp_irv_tbl
900: , x_irv_tbl => lx_irv_tbl );
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: , x_msg_data => x_msg_data
899: , p_irv_tbl => lp_irv_tbl
900: , x_irv_tbl => lx_irv_tbl );
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: END IF;

Line 903: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

899: , p_irv_tbl => lp_irv_tbl
900: , x_irv_tbl => lx_irv_tbl );
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: END IF;
907:

Line 904: RAISE OKL_API.G_EXCEPTION_ERROR;

900: , x_irv_tbl => lx_irv_tbl );
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: END IF;
907:
908: -- Update the header record with the Under revision status

Line 919: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

915: , x_msg_count => x_msg_count
916: , x_msg_data => x_msg_data
917: , p_irhv_rec => lp_irhv_rec
918: , x_irhv_rec => x_irhv_rec);
919: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;

Line 920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

916: , x_msg_data => x_msg_data
917: , p_irhv_rec => lp_irhv_rec
918: , x_irhv_rec => x_irhv_rec);
919: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924:

Line 921: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

917: , p_irhv_rec => lp_irhv_rec
918: , x_irhv_rec => x_irhv_rec);
919: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924:
925: x_return_status := l_return_status;

Line 922: RAISE OKL_API.G_EXCEPTION_ERROR;

918: , x_irhv_rec => x_irhv_rec);
919: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924:
925: x_return_status := l_return_status;
926: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 926: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924:
925: x_return_status := l_return_status;
926: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
927: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
928: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs');
929: END IF;
930:

Line 932: WHEN OKL_API.G_EXCEPTION_ERROR THEN

928: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs');
929: END IF;
930:
931: EXCEPTION
932: WHEN OKL_API.G_EXCEPTION_ERROR THEN
933:
934: x_return_status := OKL_API.HANDLE_EXCEPTIONS
935: (
936: l_api_name,

Line 934: x_return_status := OKL_API.HANDLE_EXCEPTIONS

930:
931: EXCEPTION
932: WHEN OKL_API.G_EXCEPTION_ERROR THEN
933:
934: x_return_status := OKL_API.HANDLE_EXCEPTIONS
935: (
936: l_api_name,
937: G_PKG_NAME,
938: 'OKL_API.G_RET_STS_ERROR',

Line 938: 'OKL_API.G_RET_STS_ERROR',

934: x_return_status := OKL_API.HANDLE_EXCEPTIONS
935: (
936: l_api_name,
937: G_PKG_NAME,
938: 'OKL_API.G_RET_STS_ERROR',
939: x_msg_count,
940: x_msg_data,
941: '_PVT'
942: );

Line 944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

940: x_msg_data,
941: '_PVT'
942: );
943:
944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945:
946: x_return_status := OKL_API.HANDLE_EXCEPTIONS
947: (
948: l_api_name,

Line 946: x_return_status := OKL_API.HANDLE_EXCEPTIONS

942: );
943:
944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945:
946: x_return_status := OKL_API.HANDLE_EXCEPTIONS
947: (
948: l_api_name,
949: G_PKG_NAME,
950: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 950: 'OKL_API.G_RET_STS_UNEXP_ERROR',

946: x_return_status := OKL_API.HANDLE_EXCEPTIONS
947: (
948: l_api_name,
949: G_PKG_NAME,
950: 'OKL_API.G_RET_STS_UNEXP_ERROR',
951: x_msg_count,
952: x_msg_data,
953: '_PVT'
954: );

Line 957: x_return_status := OKL_API.HANDLE_EXCEPTIONS

953: '_PVT'
954: );
955: WHEN OTHERS THEN
956:
957: x_return_status := OKL_API.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,
961: 'OTHERS',

Line 970: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

966: END create_version_irs;
967:
968: PROCEDURE change_LRS_sts (
969: p_api_version IN NUMBER
970: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
971: , x_return_status OUT NOCOPY VARCHAR2
972: , x_msg_count OUT NOCOPY NUMBER
973: , x_msg_data OUT NOCOPY VARCHAR2
974: , p_confirm_yn IN VARCHAR2

Line 984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

980: l_api_version CONSTANT NUMBER := p_api_version;
981: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
982: l_msg_count NUMBER := x_msg_count ;
983: l_msg_data VARCHAR2(2000);
984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
985: l_lrs_list lrs_ref_tbl;
986: lp_lrtv_tbl okl_lrs_id_tbl;
987:
988: l_src_code VARCHAR2(30) := NULL;

Line 1107: l_return_status := OKL_API.start_activity(l_api_name

1103: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call change_LRS_sts');
1104: END IF;
1105:
1106:
1107: l_return_status := OKL_API.start_activity(l_api_name
1108: ,G_PKG_NAME
1109: ,p_init_msg_list
1110: ,l_api_version
1111: ,p_api_version

Line 1114: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1110: ,l_api_version
1111: ,p_api_version
1112: ,'_PVT'
1113: ,x_return_status);
1114: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1117: RAISE OKL_API.G_EXCEPTION_ERROR;
1118: END IF;

Line 1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1111: ,p_api_version
1112: ,'_PVT'
1113: ,x_return_status);
1114: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1117: RAISE OKL_API.G_EXCEPTION_ERROR;
1118: END IF;
1119:

Line 1116: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1112: ,'_PVT'
1113: ,x_return_status);
1114: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1117: RAISE OKL_API.G_EXCEPTION_ERROR;
1118: END IF;
1119:
1120: /*

Line 1117: RAISE OKL_API.G_EXCEPTION_ERROR;

1113: ,x_return_status);
1114: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1117: RAISE OKL_API.G_EXCEPTION_ERROR;
1118: END IF;
1119:
1120: /*
1121: Select the category type of the item residual.

Line 1195: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1191: , p_lrv_id_tbl => lp_lrtv_tbl
1192: , p_end_date => p_icpv_rec.end_date
1193: );
1194:
1195: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;

Line 1196: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1192: , p_end_date => p_icpv_rec.end_date
1193: );
1194:
1195: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: END IF;

Line 1197: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1193: );
1194:
1195: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: END IF;
1201: END IF; -- End of confirmation check

Line 1198: RAISE OKL_API.G_EXCEPTION_ERROR;

1194:
1195: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: END IF;
1201: END IF; -- End of confirmation check
1202:

Line 1204: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1200: END IF;
1201: END IF; -- End of confirmation check
1202:
1203: x_return_status := l_return_status;
1204: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1205:
1206: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call change_LRS_sts');
1208: END IF;

Line 1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call change_LRS_sts');
1208: END IF;
1209:
1210: EXCEPTION
1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1212:
1213: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,

Line 1213: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1209:
1210: EXCEPTION
1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1212:
1213: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,
1217: 'OKL_API.G_RET_STS_ERROR',

Line 1217: 'OKL_API.G_RET_STS_ERROR',

1213: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,
1217: 'OKL_API.G_RET_STS_ERROR',
1218: x_msg_count,
1219: x_msg_data,
1220: '_PVT'
1221: );

Line 1223: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1219: x_msg_data,
1220: '_PVT'
1221: );
1222:
1223: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1224:
1225: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1226: (
1227: l_api_name,

Line 1225: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1221: );
1222:
1223: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1224:
1225: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1226: (
1227: l_api_name,
1228: G_PKG_NAME,
1229: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1229: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1225: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1226: (
1227: l_api_name,
1228: G_PKG_NAME,
1229: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1230: x_msg_count,
1231: x_msg_data,
1232: '_PVT'
1233: );

Line 1236: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1232: '_PVT'
1233: );
1234: WHEN OTHERS THEN
1235:
1236: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1237: (
1238: l_api_name,
1239: G_PKG_NAME,
1240: 'OTHERS',

Line 1284: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1280: END get_header_status;
1281:
1282: PROCEDURE activate_item_residual(
1283: p_api_version IN NUMBER
1284: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1285: , x_return_status OUT NOCOPY VARCHAR2
1286: , x_msg_count OUT NOCOPY NUMBER
1287: , x_msg_data OUT NOCOPY VARCHAR2
1288: , p_item_resdl_version_id IN NUMBER ) IS

Line 1294: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1290: l_api_version CONSTANT NUMBER := p_api_version;
1291: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1292: l_msg_count NUMBER := x_msg_count ;
1293: l_msg_data VARCHAR2(2000);
1294: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1295:
1296: l_version_no VARCHAR2(30) ;
1297: l_residual_id NUMBER;
1298: l_change_sts VARCHAR2(1) := 'n';

Line 1354: l_return_status := OKL_API.start_activity(l_api_name

1350: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call activate_item_residual');
1352: END IF;
1353:
1354: l_return_status := OKL_API.start_activity(l_api_name
1355: ,G_PKG_NAME
1356: ,p_init_msg_list
1357: ,l_api_version
1358: ,p_api_version

Line 1361: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1357: ,l_api_version
1358: ,p_api_version
1359: ,'_PVT'
1360: ,x_return_status);
1361: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_ERROR;
1365: END IF;

Line 1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1358: ,p_api_version
1359: ,'_PVT'
1360: ,x_return_status);
1361: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_ERROR;
1365: END IF;
1366:

Line 1363: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1359: ,'_PVT'
1360: ,x_return_status);
1361: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_ERROR;
1365: END IF;
1366:
1367: -- Get the residual id and the version number of the version to be approved

Line 1364: RAISE OKL_API.G_EXCEPTION_ERROR;

1360: ,x_return_status);
1361: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_ERROR;
1365: END IF;
1366:
1367: -- Get the residual id and the version number of the version to be approved
1368: OPEN get_version_details(p_item_resdl_version_id);

Line 1398: lp_irhv_rec.effective_to_date := OKL_API.G_MISS_DATE;

1394: IF lp_icpv_curr_rec.end_date IS NOT NULL THEN
1395: lp_irhv_rec.effective_to_date := lp_icpv_curr_rec.end_date;
1396: ELSE
1397: -- If it is null, expilcitly assign G_MISS_DATE to update null in table
1398: lp_irhv_rec.effective_to_date := OKL_API.G_MISS_DATE;
1399: END IF;
1400: END IF;
1401:
1402: --3.if this is the first version then dont do the effective_from validation

Line 1425: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1421: , x_msg_count => x_msg_count
1422: , x_msg_data => x_msg_data
1423: , p_icpv_rec => lp_icpv_prev_rec
1424: , x_icpv_rec => lx_icpv_prev_rec);
1425: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF l_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: , x_msg_data => x_msg_data
1423: , p_icpv_rec => lp_icpv_prev_rec
1424: , x_icpv_rec => lx_icpv_prev_rec);
1425: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: END IF; -- end of check for no change in effective TO date

Line 1427: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1423: , p_icpv_rec => lp_icpv_prev_rec
1424: , x_icpv_rec => lx_icpv_prev_rec);
1425: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: END IF; -- end of check for no change in effective TO date
1431:

Line 1428: RAISE OKL_API.G_EXCEPTION_ERROR;

1424: , x_icpv_rec => lx_icpv_prev_rec);
1425: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: END IF; -- end of check for no change in effective TO date
1431:
1432: -- Check if the effective to date is already present for the previous version

Line 1459: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1455: , x_msg_count => x_msg_count
1456: , x_msg_data => x_msg_data
1457: , p_icpv_rec => lp_icpv_curr_rec
1458: , x_icpv_rec => lx_icpv_curr_rec);
1459: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_ERROR;
1463: END IF;

Line 1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1456: , x_msg_data => x_msg_data
1457: , p_icpv_rec => lp_icpv_curr_rec
1458: , x_icpv_rec => lx_icpv_curr_rec);
1459: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --4.Set the header status

Line 1461: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1457: , p_icpv_rec => lp_icpv_curr_rec
1458: , x_icpv_rec => lx_icpv_curr_rec);
1459: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --4.Set the header status
1465: lp_irhv_rec.sts_code := get_header_status(l_residual_id);

Line 1462: RAISE OKL_API.G_EXCEPTION_ERROR;

1458: , x_icpv_rec => lx_icpv_curr_rec);
1459: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --4.Set the header status
1465: lp_irhv_rec.sts_code := get_header_status(l_residual_id);
1466:

Line 1476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1472: , x_msg_count => x_msg_count
1473: , x_msg_data => x_msg_data
1474: , p_irhv_rec => lp_irhv_rec
1475: , x_irhv_rec => lx_irhv_rec);
1476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;

Line 1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1473: , x_msg_data => x_msg_data
1474: , p_irhv_rec => lp_irhv_rec
1475: , x_irhv_rec => lx_irhv_rec);
1476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: x_return_status := l_return_status;

Line 1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1474: , p_irhv_rec => lp_irhv_rec
1475: , x_irhv_rec => lx_irhv_rec);
1476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: x_return_status := l_return_status;
1482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1479: RAISE OKL_API.G_EXCEPTION_ERROR;

1475: , x_irhv_rec => lx_irhv_rec);
1476: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: x_return_status := l_return_status;
1482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1483:

Line 1482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1478: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: x_return_status := l_return_status;
1482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1483:
1484: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls.pls call activate_item_residual');
1486: END IF;

Line 1489: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls.pls call activate_item_residual');
1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1490:
1491: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,

Line 1491: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1487:
1488: EXCEPTION
1489: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1490:
1491: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,
1495: 'OKL_API.G_RET_STS_ERROR',

Line 1495: 'OKL_API.G_RET_STS_ERROR',

1491: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,
1495: 'OKL_API.G_RET_STS_ERROR',
1496: x_msg_count,
1497: x_msg_data,
1498: '_PVT'
1499: );

Line 1501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1497: x_msg_data,
1498: '_PVT'
1499: );
1500:
1501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1502:
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,

Line 1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1499: );
1500:
1501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1502:
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,
1506: G_PKG_NAME,
1507: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1507: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,
1506: G_PKG_NAME,
1507: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1508: x_msg_count,
1509: x_msg_data,
1510: '_PVT'
1511: );

Line 1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1510: '_PVT'
1511: );
1512: WHEN OTHERS THEN
1513:
1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1515: (
1516: l_api_name,
1517: G_PKG_NAME,
1518: 'OTHERS',

Line 1527: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1523: END activate_item_residual;
1524:
1525: PROCEDURE submit_item_residual(
1526: p_api_version IN NUMBER,
1527: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1528: x_return_status OUT NOCOPY VARCHAR2,
1529: x_msg_count OUT NOCOPY NUMBER,
1530: x_msg_data OUT NOCOPY VARCHAR2,
1531: p_itm_rsdl_version_id IN OKL_ITM_CAT_RV_PRCS_V.ID%TYPE

Line 1588: lx_return_status := OKL_API.start_activity(l_api_name

1584: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1585: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call submit_item_residual');
1586: END IF;
1587:
1588: lx_return_status := OKL_API.start_activity(l_api_name
1589: ,G_PKG_NAME
1590: ,p_init_msg_list
1591: ,l_api_version
1592: ,p_api_version

Line 1595: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1591: ,l_api_version
1592: ,p_api_version
1593: ,'_PVT'
1594: ,x_return_status);
1595: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;

Line 1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1592: ,p_api_version
1593: ,'_PVT'
1594: ,x_return_status);
1595: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:

Line 1597: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

1593: ,'_PVT'
1594: ,x_return_status);
1595: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:
1601: -- Check if all the Residual category sets of this Item Residual are Active at the time of Submission

Line 1598: RAISE OKL_API.G_EXCEPTION_ERROR;

1594: ,x_return_status);
1595: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:
1601: -- Check if all the Residual category sets of this Item Residual are Active at the time of Submission
1602: OPEN get_residual_id(p_itm_rsdl_version_id);

Line 1615: OKL_API.set_message(p_app_name => G_APP_NAME,

1611: OPEN check_active_resi_cat_sets(l_item_residual_id,G_STS_ACTIVE);
1612: FETCH check_active_resi_cat_sets INTO l_rcs_rec;
1613: IF check_active_resi_cat_sets%FOUND THEN
1614: LOOP
1615: OKL_API.set_message(p_app_name => G_APP_NAME,
1616: p_msg_name => 'OKL_RCS_STS_INACTIVE',
1617: p_token1 => G_COL_NAME_TOKEN,
1618: p_token1_value => l_rcs_rec.name);
1619: FETCH check_active_resi_cat_sets INTO l_rcs_rec;

Line 1622: RAISE OKL_API.G_EXCEPTION_ERROR;

1618: p_token1_value => l_rcs_rec.name);
1619: FETCH check_active_resi_cat_sets INTO l_rcs_rec;
1620: EXIT WHEN check_active_resi_cat_sets%NOTFOUND;
1621: END LOOP;
1622: RAISE OKL_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: CLOSE check_active_resi_cat_sets;
1625: END IF;
1626: --raise workflow submit event

Line 1636: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

1632:
1633: -- Check for the AME approval process
1634: IF NVL(FND_PROFILE.VALUE('OKL_PE_APPROVAL_PROCESS'),'NONE') = 'NONE' THEN
1635: activate_item_residual(p_api_version,p_init_msg_list,lx_return_status,x_msg_count,x_msg_data,p_itm_rsdl_version_id);
1636: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1637: RAISE OKL_API.G_EXCEPTION_ERROR;
1638: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: END IF;

Line 1637: RAISE OKL_API.G_EXCEPTION_ERROR;

1633: -- Check for the AME approval process
1634: IF NVL(FND_PROFILE.VALUE('OKL_PE_APPROVAL_PROCESS'),'NONE') = 'NONE' THEN
1635: activate_item_residual(p_api_version,p_init_msg_list,lx_return_status,x_msg_count,x_msg_data,p_itm_rsdl_version_id);
1636: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1637: RAISE OKL_API.G_EXCEPTION_ERROR;
1638: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: END IF;
1641:

Line 1638: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1634: IF NVL(FND_PROFILE.VALUE('OKL_PE_APPROVAL_PROCESS'),'NONE') = 'NONE' THEN
1635: activate_item_residual(p_api_version,p_init_msg_list,lx_return_status,x_msg_count,x_msg_data,p_itm_rsdl_version_id);
1636: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1637: RAISE OKL_API.G_EXCEPTION_ERROR;
1638: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: END IF;
1641:
1642: ELSE

Line 1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1635: activate_item_residual(p_api_version,p_init_msg_list,lx_return_status,x_msg_count,x_msg_data,p_itm_rsdl_version_id);
1636: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1637: RAISE OKL_API.G_EXCEPTION_ERROR;
1638: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: END IF;
1641:
1642: ELSE
1643: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 1650: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1646: x_msg_count => x_msg_count,
1647: x_msg_data => x_msg_data,
1648: p_event_name => l_event_name,
1649: p_parameters => l_parameter_list);
1650: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1652: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1653: RAISE OKL_API.G_EXCEPTION_ERROR;
1654: END IF;

Line 1651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1647: x_msg_data => x_msg_data,
1648: p_event_name => l_event_name,
1649: p_parameters => l_parameter_list);
1650: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1652: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1653: RAISE OKL_API.G_EXCEPTION_ERROR;
1654: END IF;
1655: END IF;

Line 1652: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

1648: p_event_name => l_event_name,
1649: p_parameters => l_parameter_list);
1650: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1652: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1653: RAISE OKL_API.G_EXCEPTION_ERROR;
1654: END IF;
1655: END IF;
1656: x_return_status := lx_return_status;

Line 1653: RAISE OKL_API.G_EXCEPTION_ERROR;

1649: p_parameters => l_parameter_list);
1650: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1652: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1653: RAISE OKL_API.G_EXCEPTION_ERROR;
1654: END IF;
1655: END IF;
1656: x_return_status := lx_return_status;
1657: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1657: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1653: RAISE OKL_API.G_EXCEPTION_ERROR;
1654: END IF;
1655: END IF;
1656: x_return_status := lx_return_status;
1657: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1658:
1659: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1660: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call submit_item_residual');
1661: END IF;

Line 1664: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1660: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call submit_item_residual');
1661: END IF;
1662:
1663: EXCEPTION
1664: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1665:
1666: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,

Line 1666: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1662:
1663: EXCEPTION
1664: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1665:
1666: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,
1670: 'OKL_API.G_RET_STS_ERROR',

Line 1670: 'OKL_API.G_RET_STS_ERROR',

1666: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,
1670: 'OKL_API.G_RET_STS_ERROR',
1671: x_msg_count,
1672: x_msg_data,
1673: '_PVT'
1674: );

Line 1676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1672: x_msg_data,
1673: '_PVT'
1674: );
1675:
1676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1677:
1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,

Line 1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1674: );
1675:
1676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1677:
1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,
1682: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1682: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,
1682: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1683: x_msg_count,
1684: x_msg_data,
1685: '_PVT'
1686: );

Line 1690: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1686: );
1687:
1688: WHEN OTHERS THEN
1689:
1690: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1691: (
1692: l_api_name,
1693: G_PKG_NAME,
1694: 'OTHERS',

Line 1703: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1699: END submit_item_residual;
1700:
1701: PROCEDURE create_irs_submit (
1702: p_api_version IN NUMBER
1703: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1704: , x_return_status OUT NOCOPY VARCHAR2
1705: , x_msg_count OUT NOCOPY NUMBER
1706: , x_msg_data OUT NOCOPY VARCHAR2
1707: , p_irhv_rec IN okl_irhv_rec

Line 1718: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1714: l_api_version CONSTANT NUMBER := p_api_version;
1715: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1716: l_msg_count NUMBER := x_msg_count ;
1717: l_msg_data VARCHAR2(2000);
1718: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1719:
1720: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
1721:
1722: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_irs_submit';

Line 1734: l_return_status := OKL_API.start_activity(l_api_name

1730: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1731: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs_submit');
1732: END IF;
1733:
1734: l_return_status := OKL_API.start_activity(l_api_name
1735: ,G_PKG_NAME
1736: ,p_init_msg_list
1737: ,l_api_version
1738: ,p_api_version

Line 1741: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1737: ,l_api_version
1738: ,p_api_version
1739: ,'_PVT'
1740: ,x_return_status);
1741: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_ERROR;
1745: END IF;

Line 1742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1738: ,p_api_version
1739: ,'_PVT'
1740: ,x_return_status);
1741: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_ERROR;
1745: END IF;
1746: -- Set the status changes for the version record.

Line 1743: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1739: ,'_PVT'
1740: ,x_return_status);
1741: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_ERROR;
1745: END IF;
1746: -- Set the status changes for the version record.
1747: lp_icpv_rec.sts_code := G_STS_SUBMITTED;

Line 1744: RAISE OKL_API.G_EXCEPTION_ERROR;

1740: ,x_return_status);
1741: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_ERROR;
1745: END IF;
1746: -- Set the status changes for the version record.
1747: lp_icpv_rec.sts_code := G_STS_SUBMITTED;
1748:

Line 1753: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1749: /* Check if there is atleast one item or item category or residual category set
1750: * associated with this item residual.
1751: */
1752: IF p_irv_tbl.COUNT = 0 THEN
1753: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1754: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
1755: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;
1756:
1757:

Line 1755: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;

1751: */
1752: IF p_irv_tbl.COUNT = 0 THEN
1753: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1754: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
1755: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;
1756:
1757:
1758: -- Call the create_irs procedure to create the item residual
1759: create_irs (

Line 1771: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1767: , p_irv_tbl => p_irv_tbl
1768: , x_irhv_rec => x_irhv_rec
1769: , x_icpv_rec => x_icpv_rec
1770: );
1771: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1774: RAISE OKL_API.G_EXCEPTION_ERROR;
1775: END IF;

Line 1772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1768: , x_irhv_rec => x_irhv_rec
1769: , x_icpv_rec => x_icpv_rec
1770: );
1771: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1774: RAISE OKL_API.G_EXCEPTION_ERROR;
1775: END IF;
1776:

Line 1773: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1769: , x_icpv_rec => x_icpv_rec
1770: );
1771: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1774: RAISE OKL_API.G_EXCEPTION_ERROR;
1775: END IF;
1776:
1777: -- submit for approval

Line 1774: RAISE OKL_API.G_EXCEPTION_ERROR;

1770: );
1771: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1774: RAISE OKL_API.G_EXCEPTION_ERROR;
1775: END IF;
1776:
1777: -- submit for approval
1778: submit_item_residual(

Line 1785: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1781: , x_return_status => l_return_status
1782: , x_msg_count => l_msg_count
1783: , x_msg_data => l_msg_data
1784: , p_itm_rsdl_version_id => x_icpv_rec.id );
1785: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1788: RAISE OKL_API.G_EXCEPTION_ERROR;
1789: END IF;

Line 1786: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1782: , x_msg_count => l_msg_count
1783: , x_msg_data => l_msg_data
1784: , p_itm_rsdl_version_id => x_icpv_rec.id );
1785: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1788: RAISE OKL_API.G_EXCEPTION_ERROR;
1789: END IF;
1790:

Line 1787: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1783: , x_msg_data => l_msg_data
1784: , p_itm_rsdl_version_id => x_icpv_rec.id );
1785: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1788: RAISE OKL_API.G_EXCEPTION_ERROR;
1789: END IF;
1790:
1791: x_return_status := l_return_status;

Line 1788: RAISE OKL_API.G_EXCEPTION_ERROR;

1784: , p_itm_rsdl_version_id => x_icpv_rec.id );
1785: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1788: RAISE OKL_API.G_EXCEPTION_ERROR;
1789: END IF;
1790:
1791: x_return_status := l_return_status;
1792: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1792: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1788: RAISE OKL_API.G_EXCEPTION_ERROR;
1789: END IF;
1790:
1791: x_return_status := l_return_status;
1792: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1793:
1794: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1795: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs_submit');
1796: END IF;

Line 1799: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1795: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs_submit');
1796: END IF;
1797:
1798: EXCEPTION
1799: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1800:
1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,

Line 1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1797:
1798: EXCEPTION
1799: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1800:
1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,
1805: 'OKL_API.G_RET_STS_ERROR',

Line 1805: 'OKL_API.G_RET_STS_ERROR',

1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,
1805: 'OKL_API.G_RET_STS_ERROR',
1806: x_msg_count,
1807: x_msg_data,
1808: '_PVT'
1809: );

Line 1811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1807: x_msg_data,
1808: '_PVT'
1809: );
1810:
1811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1812:
1813: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,

Line 1813: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1809: );
1810:
1811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1812:
1813: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,
1816: G_PKG_NAME,
1817: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1817: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1813: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,
1816: G_PKG_NAME,
1817: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1818: x_msg_count,
1819: x_msg_data,
1820: '_PVT'
1821: );

Line 1825: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1821: );
1822:
1823: WHEN OTHERS THEN
1824:
1825: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1826: (
1827: l_api_name,
1828: G_PKG_NAME,
1829: 'OTHERS',

Line 1838: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1834: END create_irs_submit;
1835:
1836: PROCEDURE update_version_irs_submit (
1837: p_api_version IN NUMBER
1838: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1839: , x_return_status OUT NOCOPY VARCHAR2
1840: , x_msg_count OUT NOCOPY NUMBER
1841: , x_msg_data OUT NOCOPY VARCHAR2
1842: , p_irhv_rec IN okl_irhv_rec

Line 1853: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1849: l_api_version CONSTANT NUMBER := p_api_version;
1850: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1851: l_msg_count NUMBER := x_msg_count ;
1852: l_msg_data VARCHAR2(2000);
1853: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1854:
1855: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
1856:
1857: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.update_version_irs_submit';

Line 1868: l_return_status := OKL_API.start_activity(l_api_name

1864: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1865: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs_submit');
1866: END IF;
1867:
1868: l_return_status := OKL_API.start_activity(l_api_name
1869: ,G_PKG_NAME
1870: ,p_init_msg_list
1871: ,l_api_version
1872: ,p_api_version

Line 1875: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1871: ,l_api_version
1872: ,p_api_version
1873: ,'_PVT'
1874: ,x_return_status);
1875: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;

Line 1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1872: ,p_api_version
1873: ,'_PVT'
1874: ,x_return_status);
1875: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:

Line 1877: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1873: ,'_PVT'
1874: ,x_return_status);
1875: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:
1881: -- Set the status changes for the version record.

Line 1878: RAISE OKL_API.G_EXCEPTION_ERROR;

1874: ,x_return_status);
1875: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:
1881: -- Set the status changes for the version record.
1882: lp_icpv_rec.sts_code := G_STS_SUBMITTED;

Line 1886: RAISE OKL_API.G_EXCEPTION_ERROR;

1882: lp_icpv_rec.sts_code := G_STS_SUBMITTED;
1883:
1884: -- Effective From validation
1885: IF NOT valid_version_effective_date(lp_icpv_rec.START_DATE, p_irhv_rec.item_residual_id, lp_icpv_rec.version_number) THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:
1889: /* Check if there is atleast one item or item category or residual category set
1890: * associated with this item residual.

Line 1893: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1889: /* Check if there is atleast one item or item category or residual category set
1890: * associated with this item residual.
1891: */
1892: IF p_irv_tbl.COUNT = 0 THEN
1893: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1894: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
1895: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;
1896:
1897: -- Call the update_version_irs procedure to create the item residual

Line 1895: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;

1891: */
1892: IF p_irv_tbl.COUNT = 0 THEN
1893: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1894: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
1895: RAISE OKL_API.G_EXCEPTION_ERROR; END IF;
1896:
1897: -- Call the update_version_irs procedure to create the item residual
1898: update_version_irs (
1899: p_api_version => l_api_version

Line 1910: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1906: , p_irv_tbl => p_irv_tbl
1907: , x_irhv_rec => x_irhv_rec
1908: , x_icpv_rec => x_icpv_rec
1909: );
1910: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1912: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1913: RAISE OKL_API.G_EXCEPTION_ERROR;
1914: END IF;

Line 1911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1907: , x_irhv_rec => x_irhv_rec
1908: , x_icpv_rec => x_icpv_rec
1909: );
1910: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1912: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1913: RAISE OKL_API.G_EXCEPTION_ERROR;
1914: END IF;
1915: -- submit for approval

Line 1912: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1908: , x_icpv_rec => x_icpv_rec
1909: );
1910: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1912: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1913: RAISE OKL_API.G_EXCEPTION_ERROR;
1914: END IF;
1915: -- submit for approval
1916: submit_item_residual(

Line 1913: RAISE OKL_API.G_EXCEPTION_ERROR;

1909: );
1910: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1912: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1913: RAISE OKL_API.G_EXCEPTION_ERROR;
1914: END IF;
1915: -- submit for approval
1916: submit_item_residual(
1917: p_api_version => l_api_version

Line 1923: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1919: , x_return_status => l_return_status
1920: , x_msg_count => l_msg_count
1921: , x_msg_data => l_msg_data
1922: , p_itm_rsdl_version_id => x_icpv_rec.id );
1923: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1926: RAISE OKL_API.G_EXCEPTION_ERROR;
1927: END IF;

Line 1924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1920: , x_msg_count => l_msg_count
1921: , x_msg_data => l_msg_data
1922: , p_itm_rsdl_version_id => x_icpv_rec.id );
1923: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1926: RAISE OKL_API.G_EXCEPTION_ERROR;
1927: END IF;
1928: x_return_status := l_return_status;

Line 1925: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1921: , x_msg_data => l_msg_data
1922: , p_itm_rsdl_version_id => x_icpv_rec.id );
1923: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1926: RAISE OKL_API.G_EXCEPTION_ERROR;
1927: END IF;
1928: x_return_status := l_return_status;
1929:

Line 1926: RAISE OKL_API.G_EXCEPTION_ERROR;

1922: , p_itm_rsdl_version_id => x_icpv_rec.id );
1923: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1926: RAISE OKL_API.G_EXCEPTION_ERROR;
1927: END IF;
1928: x_return_status := l_return_status;
1929:
1930: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1930: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1926: RAISE OKL_API.G_EXCEPTION_ERROR;
1927: END IF;
1928: x_return_status := l_return_status;
1929:
1930: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1931:
1932: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs_submit');
1934: END IF;

Line 1937: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs_submit');
1934: END IF;
1935:
1936: EXCEPTION
1937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1938:
1939: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1940: (
1941: l_api_name,

Line 1939: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1935:
1936: EXCEPTION
1937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1938:
1939: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1940: (
1941: l_api_name,
1942: G_PKG_NAME,
1943: 'OKL_API.G_RET_STS_ERROR',

Line 1943: 'OKL_API.G_RET_STS_ERROR',

1939: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1940: (
1941: l_api_name,
1942: G_PKG_NAME,
1943: 'OKL_API.G_RET_STS_ERROR',
1944: x_msg_count,
1945: x_msg_data,
1946: '_PVT'
1947: );

Line 1949: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1945: x_msg_data,
1946: '_PVT'
1947: );
1948:
1949: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1950:
1951: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1952: (
1953: l_api_name,

Line 1951: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1947: );
1948:
1949: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1950:
1951: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1952: (
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1955: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1951: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1952: (
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1956: x_msg_count,
1957: x_msg_data,
1958: '_PVT'
1959: );

Line 1963: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1959: );
1960:
1961: WHEN OTHERS THEN
1962:
1963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1964: (
1965: l_api_name,
1966: G_PKG_NAME,
1967: 'OTHERS',

Line 1976: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1972: END update_version_irs_submit;
1973:
1974: PROCEDURE create_version_irs_submit (
1975: p_api_version IN NUMBER
1976: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1977: , x_return_status OUT NOCOPY VARCHAR2
1978: , x_msg_count OUT NOCOPY NUMBER
1979: , x_msg_data OUT NOCOPY VARCHAR2
1980: , p_irhv_rec IN okl_irhv_rec

Line 1991: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1987: l_api_version CONSTANT NUMBER := p_api_version;
1988: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
1989: l_msg_count NUMBER := x_msg_count ;
1990: l_msg_data VARCHAR2(2000);
1991: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1992:
1993: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
1994: l_calc_date DATE := NULL;
1995: l_prev_ver_id NUMBER;

Line 2018: l_return_status := OKL_API.start_activity(l_api_name

2014: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2015: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs_submit');
2016: END IF;
2017:
2018: l_return_status := OKL_API.start_activity(l_api_name
2019: ,G_PKG_NAME
2020: ,p_init_msg_list
2021: ,l_api_version
2022: ,p_api_version

Line 2025: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

2021: ,l_api_version
2022: ,p_api_version
2023: ,'_PVT'
2024: ,x_return_status);
2025: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;

Line 2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2022: ,p_api_version
2023: ,'_PVT'
2024: ,x_return_status);
2025: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030:

Line 2027: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2023: ,'_PVT'
2024: ,x_return_status);
2025: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030:
2031: -- Set the status changes for the version record.

Line 2028: RAISE OKL_API.G_EXCEPTION_ERROR;

2024: ,x_return_status);
2025: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030:
2031: -- Set the status changes for the version record.
2032: lp_icpv_rec.sts_code := G_STS_SUBMITTED;

Line 2036: RAISE OKL_API.G_EXCEPTION_ERROR;

2032: lp_icpv_rec.sts_code := G_STS_SUBMITTED;
2033:
2034: -- Effective From validation
2035: IF NOT valid_version_effective_date(lp_icpv_rec.START_DATE, p_irhv_rec.item_residual_id, lp_icpv_rec.version_number) THEN
2036: RAISE OKL_API.G_EXCEPTION_ERROR;
2037: END IF;
2038:
2039:
2040: IF lp_icpv_rec.version_number > 1 THEN

Line 2056: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

2052: , l_prev_ver_id
2053: , l_calc_date
2054: );
2055:
2056: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2059: RAISE OKL_API.G_EXCEPTION_ERROR;
2060: END IF;

Line 2057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2053: , l_calc_date
2054: );
2055:
2056: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2059: RAISE OKL_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: /*

Line 2058: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2054: );
2055:
2056: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2059: RAISE OKL_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: /*
2062: * Check if end dating the previous version is valid

Line 2059: RAISE OKL_API.G_EXCEPTION_ERROR;

2055:
2056: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2059: RAISE OKL_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: /*
2062: * Check if end dating the previous version is valid
2063: * by checking the calculated date with the new version's start date.

Line 2066: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

2062: * Check if end dating the previous version is valid
2063: * by checking the calculated date with the new version's start date.
2064: */
2065: IF l_calc_date > lp_icpv_rec.start_date THEN
2066: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2067: p_msg_name => 'OKL_PRIOR_EFFECTIVE_FROM',
2068: p_token1 => 'EFF_FROM',
2069: p_token1_value => l_calc_date);
2070: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2070: RAISE OKL_API.G_EXCEPTION_ERROR;

2066: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2067: p_msg_name => 'OKL_PRIOR_EFFECTIVE_FROM',
2068: p_token1 => 'EFF_FROM',
2069: p_token1_value => l_calc_date);
2070: RAISE OKL_API.G_EXCEPTION_ERROR;
2071: END IF;
2072: END IF; -- end of version check
2073:
2074: /* Check if there is atleast one item or item category or residual category set

Line 2078: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

2074: /* Check if there is atleast one item or item category or residual category set
2075: * associated with this item residual.
2076: */
2077: IF p_irv_tbl.COUNT = 0 THEN
2078: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2079: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
2080: RAISE OKL_API.G_EXCEPTION_ERROR;
2081: END IF;
2082:

Line 2080: RAISE OKL_API.G_EXCEPTION_ERROR;

2076: */
2077: IF p_irv_tbl.COUNT = 0 THEN
2078: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2079: p_msg_name => 'OKL_ST_IRS_RESIDUALS_MISSING');
2080: RAISE OKL_API.G_EXCEPTION_ERROR;
2081: END IF;
2082:
2083: -- Call the update_version_irs procedure to create the item residual
2084: create_version_irs (

Line 2096: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

2092: , p_irv_tbl => p_irv_tbl
2093: , x_irhv_rec => x_irhv_rec
2094: , x_icpv_rec => x_icpv_rec
2095: );
2096: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2099: RAISE OKL_API.G_EXCEPTION_ERROR;
2100: END IF;

Line 2097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2093: , x_irhv_rec => x_irhv_rec
2094: , x_icpv_rec => x_icpv_rec
2095: );
2096: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2099: RAISE OKL_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: -- submit for approval

Line 2098: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2094: , x_icpv_rec => x_icpv_rec
2095: );
2096: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2099: RAISE OKL_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: -- submit for approval
2102: submit_item_residual(

Line 2099: RAISE OKL_API.G_EXCEPTION_ERROR;

2095: );
2096: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2099: RAISE OKL_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: -- submit for approval
2102: submit_item_residual(
2103: p_api_version => l_api_version

Line 2109: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

2105: , x_return_status => l_return_status
2106: , x_msg_count => l_msg_count
2107: , x_msg_data => l_msg_data
2108: , p_itm_rsdl_version_id => x_icpv_rec.id );
2109: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;

Line 2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2106: , x_msg_count => l_msg_count
2107: , x_msg_data => l_msg_data
2108: , p_itm_rsdl_version_id => x_icpv_rec.id );
2109: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;
2114:

Line 2111: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2107: , x_msg_data => l_msg_data
2108: , p_itm_rsdl_version_id => x_icpv_rec.id );
2109: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;
2114:
2115: x_return_status := l_return_status;

Line 2112: RAISE OKL_API.G_EXCEPTION_ERROR;

2108: , p_itm_rsdl_version_id => x_icpv_rec.id );
2109: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;
2114:
2115: x_return_status := l_return_status;
2116:

Line 2117: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2113: END IF;
2114:
2115: x_return_status := l_return_status;
2116:
2117: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2118:
2119: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2120: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs_submit');
2121: END IF;

Line 2123: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2119: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2120: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs_submit');
2121: END IF;
2122: EXCEPTION
2123: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2124:
2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2126: (
2127: l_api_name,

Line 2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2121: END IF;
2122: EXCEPTION
2123: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2124:
2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2126: (
2127: l_api_name,
2128: G_PKG_NAME,
2129: 'OKL_API.G_RET_STS_ERROR',

Line 2129: 'OKL_API.G_RET_STS_ERROR',

2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2126: (
2127: l_api_name,
2128: G_PKG_NAME,
2129: 'OKL_API.G_RET_STS_ERROR',
2130: x_msg_count,
2131: x_msg_data,
2132: '_PVT'
2133: );

Line 2135: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2131: x_msg_data,
2132: '_PVT'
2133: );
2134:
2135: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2136:
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,

Line 2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2133: );
2134:
2135: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2136:
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,
2141: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2141: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,
2141: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2142: x_msg_count,
2143: x_msg_data,
2144: '_PVT'
2145: );

Line 2149: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2145: );
2146:
2147: WHEN OTHERS THEN
2148:
2149: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2150: (
2151: l_api_name,
2152: G_PKG_NAME,
2153: 'OTHERS',

Line 2162: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2158: END create_version_irs_submit;
2159:
2160: PROCEDURE remove_terms(
2161: p_api_version IN NUMBER
2162: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2163: , x_return_status OUT NOCOPY VARCHAR2
2164: , x_msg_count OUT NOCOPY NUMBER
2165: , x_msg_data OUT NOCOPY VARCHAR2
2166: , p_irv_tbl IN okl_irv_tbl) IS

Line 2184: l_return_status := OKL_API.start_activity(l_api_name

2180: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2181: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call remove_terms');
2182: END IF;
2183:
2184: l_return_status := OKL_API.start_activity(l_api_name
2185: ,G_PKG_NAME
2186: ,p_init_msg_list
2187: ,l_api_version
2188: ,p_api_version

Line 2191: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

2187: ,l_api_version
2188: ,p_api_version
2189: ,'_PVT'
2190: ,x_return_status);
2191: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2194: RAISE OKL_API.G_EXCEPTION_ERROR;
2195: END IF;

Line 2192: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2188: ,p_api_version
2189: ,'_PVT'
2190: ,x_return_status);
2191: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2194: RAISE OKL_API.G_EXCEPTION_ERROR;
2195: END IF;
2196:

Line 2193: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2189: ,'_PVT'
2190: ,x_return_status);
2191: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2194: RAISE OKL_API.G_EXCEPTION_ERROR;
2195: END IF;
2196:
2197: OKL_IRV_PVT.delete_row(

Line 2194: RAISE OKL_API.G_EXCEPTION_ERROR;

2190: ,x_return_status);
2191: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2194: RAISE OKL_API.G_EXCEPTION_ERROR;
2195: END IF;
2196:
2197: OKL_IRV_PVT.delete_row(
2198: p_api_version => l_api_version,

Line 2207: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2203: p_irv_tbl => p_irv_tbl);
2204:
2205: x_return_status := l_return_status;
2206:
2207: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2208:
2209: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2210: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call remove_terms');
2211: END IF;

Line 2214: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2210: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call remove_terms');
2211: END IF;
2212:
2213: EXCEPTION
2214: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2215:
2216: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,

Line 2216: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2212:
2213: EXCEPTION
2214: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2215:
2216: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,
2219: G_PKG_NAME,
2220: 'OKL_API.G_RET_STS_ERROR',

Line 2220: 'OKL_API.G_RET_STS_ERROR',

2216: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,
2219: G_PKG_NAME,
2220: 'OKL_API.G_RET_STS_ERROR',
2221: x_msg_count,
2222: x_msg_data,
2223: '_PVT'
2224: );

Line 2226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2222: x_msg_data,
2223: '_PVT'
2224: );
2225:
2226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2227:
2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2229: (
2230: l_api_name,

Line 2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2224: );
2225:
2226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2227:
2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2229: (
2230: l_api_name,
2231: G_PKG_NAME,
2232: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2232: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2229: (
2230: l_api_name,
2231: G_PKG_NAME,
2232: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2233: x_msg_count,
2234: x_msg_data,
2235: '_PVT'
2236: );

Line 2240: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2236: );
2237:
2238: WHEN OTHERS THEN
2239:
2240: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2241: (
2242: l_api_name,
2243: G_PKG_NAME,
2244: 'OTHERS',