eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_API

Line 6: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

2: /* $Header: OKLRASCB.pls 120.19.12020000.4 2012/10/17 11:33:48 vloomba ship $ */
3: ------------------------------------------------------------------------------------
4: -- GLOBAL OKL MESSAGES
5: ------------------------------------------------------------------------------------
6: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
10: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';

Line 385: x_return_status := OKL_API.G_RET_STS_SUCCESS;

381: l_api_version CONSTANT NUMBER := 1.0;
382: l_rep_id_tbl okl_streams_util.NumberTabTyp;
383:
384: BEGIN
385: x_return_status := OKL_API.G_RET_STS_SUCCESS;
386: -- Call start_activity to create savepoint, check compatibility
387: -- and initialize message list
388: x_return_status := OKL_API.START_ACTIVITY (
389: l_api_name

Line 388: x_return_status := OKL_API.START_ACTIVITY (

384: BEGIN
385: x_return_status := OKL_API.G_RET_STS_SUCCESS;
386: -- Call start_activity to create savepoint, check compatibility
387: -- and initialize message list
388: x_return_status := OKL_API.START_ACTIVITY (
389: l_api_name
390: ,p_init_msg_list
391: ,'_PVT'
392: ,x_return_status);

Line 394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

390: ,p_init_msg_list
391: ,'_PVT'
392: ,x_return_status);
393: -- Check if activity started successfully
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;

Line 395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

391: ,'_PVT'
392: ,x_return_status);
393: -- Check if activity started successfully
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399: -- validate in parameters

Line 396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

392: ,x_return_status);
393: -- Check if activity started successfully
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399: -- validate in parameters
400: IF p_khr_id IS NULL OR

Line 397: RAISE OKL_API.G_EXCEPTION_ERROR;

393: -- Check if activity started successfully
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399: -- validate in parameters
400: IF p_khr_id IS NULL OR
401: p_khr_id = OKL_API.G_MISS_NUM THEN

Line 401: p_khr_id = OKL_API.G_MISS_NUM THEN

397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399: -- validate in parameters
400: IF p_khr_id IS NULL OR
401: p_khr_id = OKL_API.G_MISS_NUM THEN
402: -- store SQL error message on message stack for caller
403: okl_api.set_message(p_app_name => G_APP_NAME,
404: p_msg_name => G_REQUIRED_VALUE,
405: p_token1 => G_COL_NAME_TOKEN,

Line 403: okl_api.set_message(p_app_name => G_APP_NAME,

399: -- validate in parameters
400: IF p_khr_id IS NULL OR
401: p_khr_id = OKL_API.G_MISS_NUM THEN
402: -- store SQL error message on message stack for caller
403: okl_api.set_message(p_app_name => G_APP_NAME,
404: p_msg_name => G_REQUIRED_VALUE,
405: p_token1 => G_COL_NAME_TOKEN,
406: p_token1_value => 'p_khr_id');
407: RAISE okl_api.g_exception_error;

Line 407: RAISE okl_api.g_exception_error;

403: okl_api.set_message(p_app_name => G_APP_NAME,
404: p_msg_name => G_REQUIRED_VALUE,
405: p_token1 => G_COL_NAME_TOKEN,
406: p_token1_value => 'p_khr_id');
407: RAISE okl_api.g_exception_error;
408: END IF;
409: -- cursor to get investor Agreement contract id
410: -- for a given Lease contract id
411: /* sosharma ,14-12-2007

Line 430: okl_api.set_message(p_app_name => G_APP_NAME,

426: OPEN get_inv_csr (p_khr_id => p_khr_id); --ID of lease contract
427: FETCH get_inv_csr INTO l_inv_id; --sechawla : ID if Investor Agreement
428: IF get_inv_csr%NOTFOUND THEN
429: -- store SQL error message on message stack for caller
430: okl_api.set_message(p_app_name => G_APP_NAME,
431: p_msg_name => G_NO_MATCHING_RECORD,
432: p_token1 => G_COL_NAME_TOKEN,
433: p_token1_value => 'p_khr_id');
434: RAISE okl_api.g_exception_error;

Line 434: RAISE okl_api.g_exception_error;

430: okl_api.set_message(p_app_name => G_APP_NAME,
431: p_msg_name => G_NO_MATCHING_RECORD,
432: p_token1 => G_COL_NAME_TOKEN,
433: p_token1_value => 'p_khr_id');
434: RAISE okl_api.g_exception_error;
435: END IF;
436: CLOSE get_inv_csr;
437: ELSE
438: OPEN get_inv_pend_csr (p_khr_id => p_khr_id); --ID of lease contract

Line 442: okl_api.set_message(p_app_name => G_APP_NAME,

438: OPEN get_inv_pend_csr (p_khr_id => p_khr_id); --ID of lease contract
439: FETCH get_inv_pend_csr INTO l_inv_id; --sechawla : ID if Investor Agreement
440: IF get_inv_pend_csr%NOTFOUND THEN
441: -- store SQL error message on message stack for caller
442: okl_api.set_message(p_app_name => G_APP_NAME,
443: p_msg_name => G_NO_MATCHING_RECORD,
444: p_token1 => G_COL_NAME_TOKEN,
445: p_token1_value => 'p_khr_id');
446: RAISE okl_api.g_exception_error;

Line 446: RAISE okl_api.g_exception_error;

442: okl_api.set_message(p_app_name => G_APP_NAME,
443: p_msg_name => G_NO_MATCHING_RECORD,
444: p_token1 => G_COL_NAME_TOKEN,
445: p_token1_value => 'p_khr_id');
446: RAISE okl_api.g_exception_error;
447: END IF;
448: CLOSE get_inv_pend_csr;
449: END IF;
450:

Line 462: okl_api.set_message(p_app_name => g_app_name,

458: OPEN securitized_contracts_csr (l_inv_id,
459: p_khr_id);
460: FETCH securitized_contracts_csr INTO l_contracts_csr;
461: IF securitized_contracts_csr%NOTFOUND THEN
462: okl_api.set_message(p_app_name => g_app_name,
463: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
464: RAISE okl_api.G_EXCEPTION_ERROR;
465: END IF;
466: CLOSE securitized_contracts_csr;

Line 464: RAISE okl_api.G_EXCEPTION_ERROR;

460: FETCH securitized_contracts_csr INTO l_contracts_csr;
461: IF securitized_contracts_csr%NOTFOUND THEN
462: okl_api.set_message(p_app_name => g_app_name,
463: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
464: RAISE okl_api.G_EXCEPTION_ERROR;
465: END IF;
466: CLOSE securitized_contracts_csr;
467: ELSE
468: OPEN securitized_contracts_pend_csr (l_inv_id,

Line 472: okl_api.set_message(p_app_name => g_app_name,

468: OPEN securitized_contracts_pend_csr (l_inv_id,
469: p_khr_id);
470: FETCH securitized_contracts_pend_csr INTO l_contracts_csr;
471: IF securitized_contracts_pend_csr%NOTFOUND THEN
472: okl_api.set_message(p_app_name => g_app_name,
473: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
474: RAISE okl_api.G_EXCEPTION_ERROR;
475: END IF;
476: CLOSE securitized_contracts_pend_csr;

Line 474: RAISE okl_api.G_EXCEPTION_ERROR;

470: FETCH securitized_contracts_pend_csr INTO l_contracts_csr;
471: IF securitized_contracts_pend_csr%NOTFOUND THEN
472: okl_api.set_message(p_app_name => g_app_name,
473: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
474: RAISE okl_api.G_EXCEPTION_ERROR;
475: END IF;
476: CLOSE securitized_contracts_pend_csr;
477: END IF;
478: /* sosharma end changes */

Line 515: okl_api.set_message(p_app_name => G_APP_NAME,

511: BEGIN
512: OPEN contract_number_csr(l_contracts_csr.khr_id);
513: FETCH contract_number_csr INTO l_contract_number; --lease contract
514: IF contract_number_csr%NOTFOUND THEN
515: okl_api.set_message(p_app_name => G_APP_NAME,
516: p_msg_name => G_NO_MATCHING_RECORD,
517: p_token1 => G_COL_NAME_TOKEN,
518: p_token1_value => 'Lease Contract id');
519: RAISE okl_api.g_exception_error;

Line 519: RAISE okl_api.g_exception_error;

515: okl_api.set_message(p_app_name => G_APP_NAME,
516: p_msg_name => G_NO_MATCHING_RECORD,
517: p_token1 => G_COL_NAME_TOKEN,
518: p_token1_value => 'Lease Contract id');
519: RAISE okl_api.g_exception_error;
520: END IF;
521: CLOSE contract_number_csr;
522:
523: /* sosharma ,14-12-2007

Line 531: okl_api.set_message(p_app_name => G_APP_NAME,

527: IF p_mode IS NULL THEN
528: OPEN get_kle_id_csr(l_contracts_csr.khr_id);
529: FETCH get_kle_id_csr INTO l_kle_id, l_start_date;
530: IF get_kle_id_csr%NOTFOUND THEN
531: okl_api.set_message(p_app_name => G_APP_NAME,
532: p_msg_name => G_NO_MATCHING_RECORD,
533: p_token1 => G_COL_NAME_TOKEN,
534: p_token1_value => 'Lease contract id');
535: RAISE okl_api.g_exception_error;

Line 535: RAISE okl_api.g_exception_error;

531: okl_api.set_message(p_app_name => G_APP_NAME,
532: p_msg_name => G_NO_MATCHING_RECORD,
533: p_token1 => G_COL_NAME_TOKEN,
534: p_token1_value => 'Lease contract id');
535: RAISE okl_api.g_exception_error;
536: END IF;
537: CLOSE get_kle_id_csr;
538: ELSE
539: OPEN get_kle_id_pend_csr(l_contracts_csr.khr_id);

Line 542: okl_api.set_message(p_app_name => G_APP_NAME,

538: ELSE
539: OPEN get_kle_id_pend_csr(l_contracts_csr.khr_id);
540: FETCH get_kle_id_pend_csr INTO l_kle_id, l_start_date;
541: IF get_kle_id_pend_csr%NOTFOUND THEN
542: okl_api.set_message(p_app_name => G_APP_NAME,
543: p_msg_name => G_NO_MATCHING_RECORD,
544: p_token1 => G_COL_NAME_TOKEN,
545: p_token1_value => 'Lease contract id');
546: RAISE okl_api.g_exception_error;

Line 546: RAISE okl_api.g_exception_error;

542: okl_api.set_message(p_app_name => G_APP_NAME,
543: p_msg_name => G_NO_MATCHING_RECORD,
544: p_token1 => G_COL_NAME_TOKEN,
545: p_token1_value => 'Lease contract id');
546: RAISE okl_api.g_exception_error;
547: END IF;
548: CLOSE get_kle_id_pend_csr;
549: END IF;
550: /* sosharma end changes */

Line 553: l_kle_id = OKL_API.G_MISS_NUM THEN

549: END IF;
550: /* sosharma end changes */
551:
552: IF l_kle_id IS NULL OR
553: l_kle_id = OKL_API.G_MISS_NUM THEN
554: okl_api.set_message(p_app_name => g_app_name,
555: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
556: p_token1 => g_contract_number_token,
557: p_token1_value => l_contract_number);

Line 554: okl_api.set_message(p_app_name => g_app_name,

550: /* sosharma end changes */
551:
552: IF l_kle_id IS NULL OR
553: l_kle_id = OKL_API.G_MISS_NUM THEN
554: okl_api.set_message(p_app_name => g_app_name,
555: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
556: p_token1 => g_contract_number_token,
557: p_token1_value => l_contract_number);
558: RAISE okl_api.g_exception_error;

Line 558: RAISE okl_api.g_exception_error;

554: okl_api.set_message(p_app_name => g_app_name,
555: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
556: p_token1 => g_contract_number_token,
557: p_token1_value => l_contract_number);
558: RAISE okl_api.g_exception_error;
559: END IF;
560: IF l_start_date IS NULL OR
561: l_start_date = okl_api.g_miss_date THEN
562: okl_api.set_message(p_app_name => g_app_name,

Line 561: l_start_date = okl_api.g_miss_date THEN

557: p_token1_value => l_contract_number);
558: RAISE okl_api.g_exception_error;
559: END IF;
560: IF l_start_date IS NULL OR
561: l_start_date = okl_api.g_miss_date THEN
562: okl_api.set_message(p_app_name => g_app_name,
563: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
564: RAISE okl_api.g_exception_error;
565: END IF;

Line 562: okl_api.set_message(p_app_name => g_app_name,

558: RAISE okl_api.g_exception_error;
559: END IF;
560: IF l_start_date IS NULL OR
561: l_start_date = okl_api.g_miss_date THEN
562: okl_api.set_message(p_app_name => g_app_name,
563: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
564: RAISE okl_api.g_exception_error;
565: END IF;
566: OPEN get_adv_arr_csr(l_contracts_csr.khr_id, l_kle_id);

Line 564: RAISE okl_api.g_exception_error;

560: IF l_start_date IS NULL OR
561: l_start_date = okl_api.g_miss_date THEN
562: okl_api.set_message(p_app_name => g_app_name,
563: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
564: RAISE okl_api.g_exception_error;
565: END IF;
566: OPEN get_adv_arr_csr(l_contracts_csr.khr_id, l_kle_id);
567: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;
568: IF get_adv_arr_csr%NOTFOUND THEN

Line 569: okl_api.set_message(p_app_name => G_APP_NAME,

565: END IF;
566: OPEN get_adv_arr_csr(l_contracts_csr.khr_id, l_kle_id);
567: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;
568: IF get_adv_arr_csr%NOTFOUND THEN
569: okl_api.set_message(p_app_name => G_APP_NAME,
570: p_msg_name => G_NO_MATCHING_RECORD,
571: p_token1 => G_COL_NAME_TOKEN,
572: p_token1_value => 'Lease Contract id and contract Line id');
573: RAISE okl_api.g_exception_error;

Line 573: RAISE okl_api.g_exception_error;

569: okl_api.set_message(p_app_name => G_APP_NAME,
570: p_msg_name => G_NO_MATCHING_RECORD,
571: p_token1 => G_COL_NAME_TOKEN,
572: p_token1_value => 'Lease Contract id and contract Line id');
573: RAISE okl_api.g_exception_error;
574: END IF;
575: CLOSE get_adv_arr_csr;
576: IF l_frequency IS NULL THEN
577: okl_api.set_message(p_app_name => g_app_name,

Line 577: okl_api.set_message(p_app_name => g_app_name,

573: RAISE okl_api.g_exception_error;
574: END IF;
575: CLOSE get_adv_arr_csr;
576: IF l_frequency IS NULL THEN
577: okl_api.set_message(p_app_name => g_app_name,
578: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
579: p_token1 => g_contract_number_token,
580: p_token1_value => l_contract_number);
581: RAISE okl_api.g_exception_error;

Line 581: RAISE okl_api.g_exception_error;

577: okl_api.set_message(p_app_name => g_app_name,
578: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
579: p_token1 => g_contract_number_token,
580: p_token1_value => l_contract_number);
581: RAISE okl_api.g_exception_error;
582: END IF;
583: IF l_arrears = 'Y' THEN
584: ln_days := OKL_STREAM_GENERATOR_PVT.get_day_count (
585: p_start_date => ADD_MONTHS(l_start_date, -l_frequency),

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

585: p_start_date => ADD_MONTHS(l_start_date, -l_frequency),
586: p_end_date => l_start_date,
587: p_arrears => l_arrears,
588: x_return_status => x_return_status);
589: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
590: RAISE okl_api.g_exception_unexpected_error;
591: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
592: RAISE okl_api.g_exception_error;
593: END IF;

Line 590: RAISE okl_api.g_exception_unexpected_error;

586: p_end_date => l_start_date,
587: p_arrears => l_arrears,
588: x_return_status => x_return_status);
589: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
590: RAISE okl_api.g_exception_unexpected_error;
591: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
592: RAISE okl_api.g_exception_error;
593: END IF;
594: l_final_start_date := l_start_date - ln_days;

Line 591: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN

587: p_arrears => l_arrears,
588: x_return_status => x_return_status);
589: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
590: RAISE okl_api.g_exception_unexpected_error;
591: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
592: RAISE okl_api.g_exception_error;
593: END IF;
594: l_final_start_date := l_start_date - ln_days;
595: ELSIF NVL(l_arrears,'N') = 'N' THEN

Line 592: RAISE okl_api.g_exception_error;

588: x_return_status => x_return_status);
589: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
590: RAISE okl_api.g_exception_unexpected_error;
591: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
592: RAISE okl_api.g_exception_error;
593: END IF;
594: l_final_start_date := l_start_date - ln_days;
595: ELSIF NVL(l_arrears,'N') = 'N' THEN
596: l_final_start_date := l_start_date;

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

631: x_rep_product => lx_rep_product,
632: x_rep_product_id => lx_rep_product_id,
633: x_rep_deal_type => lx_rep_deal_type);
634:
635: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_ERROR;
639: END IF;

Line 636: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

632: x_rep_product_id => lx_rep_product_id,
633: x_rep_deal_type => lx_rep_deal_type);
634:
635: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_ERROR;
639: END IF;
640:

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

633: x_rep_deal_type => lx_rep_deal_type);
634:
635: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_ERROR;
639: END IF;
640:
641: /* --Check the secondary_rep_method

Line 638: RAISE OKL_API.G_EXCEPTION_ERROR;

634:
635: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_ERROR;
639: END IF;
640:
641: /* --Check the secondary_rep_method
642: OPEN l_sec_rep_method_csr ;

Line 645: okl_api.set_message(p_app_name => g_app_name,

641: /* --Check the secondary_rep_method
642: OPEN l_sec_rep_method_csr ;
643: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
644: IF l_sec_rep_method_csr%NOTFOUND THEN
645: okl_api.set_message(p_app_name => g_app_name,
646: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
647: );
648: RAISE okl_api.g_exception_error;
649: END IF;

Line 648: RAISE okl_api.g_exception_error;

644: IF l_sec_rep_method_csr%NOTFOUND THEN
645: okl_api.set_message(p_app_name => g_app_name,
646: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
647: );
648: RAISE okl_api.g_exception_error;
649: END IF;
650: CLOSE l_sec_rep_method_csr ;
651: */
652: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------

Line 664: okl_api.set_message(p_app_name => g_app_name,

660: x_return_status => l_return_status,
661: x_primary_sty_id => l_sty_id
662: );
663: IF l_return_status <> 'S' THEN
664: okl_api.set_message(p_app_name => g_app_name,
665: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
666: p_token1 => 'STREAM_NAME',
667: p_token1_value => l_investor_rental_accrual);
668: RAISE okl_api.g_exception_error;

Line 668: RAISE okl_api.g_exception_error;

664: okl_api.set_message(p_app_name => g_app_name,
665: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
666: p_token1 => 'STREAM_NAME',
667: p_token1_value => l_investor_rental_accrual);
668: RAISE okl_api.g_exception_error;
669: END IF;
670: -- calculate total revenue share
671: FOR get_revenue_share_rec IN get_revenue_share_csr(l_inv_id, 'RENT') LOOP
672: l_revenue_share := l_revenue_share + get_revenue_share_rec.percent_stake;

Line 677: okl_api.set_message(p_app_name => g_app_name,

673: END LOOP;
674: IF l_revenue_share IS NULL OR
675: l_revenue_share = 0 THEN
676: -- store SQL error message on message stack for caller
677: okl_api.set_message(p_app_name => g_app_name,
678: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;
681: stream_type_purpose := l_rental_accrual; ---- Rental Accrual for primary product

Line 679: RAISE okl_api.G_EXCEPTION_ERROR;

675: l_revenue_share = 0 THEN
676: -- store SQL error message on message stack for caller
677: okl_api.set_message(p_app_name => g_app_name,
678: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
679: RAISE okl_api.G_EXCEPTION_ERROR;
680: END IF;
681: stream_type_purpose := l_rental_accrual; ---- Rental Accrual for primary product
682: -- sechawla : This is the 'Rental Accrual' stream, generated when OP lease contract is first Booked
683: -- sechawla : This stream is used to generate Investor Rental Accrual Stream, upon rebook

Line 700: okl_api.set_message(p_app_name => g_app_name,

696: x_return_status => l_return_status,
697: x_primary_sty_id => l_rep_sty_id
698: );
699: IF l_return_status <> 'S' THEN
700: okl_api.set_message(p_app_name => g_app_name,
701: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
702: p_token1 => 'STREAM_NAME',
703: p_token1_value => l_investor_rental_accrual);
704: RAISE okl_api.g_exception_error;

Line 704: RAISE okl_api.g_exception_error;

700: okl_api.set_message(p_app_name => g_app_name,
701: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
702: p_token1 => 'STREAM_NAME',
703: p_token1_value => l_investor_rental_accrual);
704: RAISE okl_api.g_exception_error;
705:
706: END IF;
707:
708: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 723: okl_api.set_message(p_app_name => g_app_name,

719: x_primary_sty_id => l_rep_sty_id
720: );
721:
722: IF l_return_status <> 'S' THEN
723: okl_api.set_message(p_app_name => g_app_name,
724: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
725: p_token1 => 'STREAM_NAME',
726: p_token1_value => l_investor_pre_tax_income);
727: RAISE okl_api.g_exception_error;

Line 727: RAISE okl_api.g_exception_error;

723: okl_api.set_message(p_app_name => g_app_name,
724: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
725: p_token1 => 'STREAM_NAME',
726: p_token1_value => l_investor_pre_tax_income);
727: RAISE okl_api.g_exception_error;
728: END IF;
729:
730: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
731: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 749: okl_api.set_message(p_app_name => g_app_name,

745: x_return_status => l_return_status,
746: x_primary_sty_id => l_sty_id
747: );
748: IF l_return_status <> 'S' THEN
749: okl_api.set_message(p_app_name => g_app_name,
750: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
751: p_token1 => 'STREAM_NAME',
752: p_token1_value => l_investor_pre_tax_income);
753: RAISE okl_api.g_exception_error;

Line 753: RAISE okl_api.g_exception_error;

749: okl_api.set_message(p_app_name => g_app_name,
750: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
751: p_token1 => 'STREAM_NAME',
752: p_token1_value => l_investor_pre_tax_income);
753: RAISE okl_api.g_exception_error;
754: END IF;
755: -- calculate total revenue share
756: FOR get_revenue_share_rec IN get_revenue_share_csr(l_inv_id, 'RENT') LOOP
757: l_revenue_share := l_revenue_share + get_revenue_share_rec.percent_stake;

Line 762: okl_api.set_message(p_app_name => g_app_name,

758: END LOOP;
759: IF l_revenue_share IS NULL OR
760: l_revenue_share = 0 THEN
761: -- store SQL error message on message stack for caller
762: okl_api.set_message(p_app_name => g_app_name,
763: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
764: RAISE okl_api.G_EXCEPTION_ERROR;
765: END IF;
766: stream_type_purpose := l_pre_tax_income;--Pre Tax Income for Primary product

Line 764: RAISE okl_api.G_EXCEPTION_ERROR;

760: l_revenue_share = 0 THEN
761: -- store SQL error message on message stack for caller
762: okl_api.set_message(p_app_name => g_app_name,
763: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
764: RAISE okl_api.G_EXCEPTION_ERROR;
765: END IF;
766: stream_type_purpose := l_pre_tax_income;--Pre Tax Income for Primary product
767: -- sechawla : This is the 'Pre Tax Income' stream, generated when DF/ST lease contract is Booked
768: -- sechawla : This stream is used to generate Investor Pre Tax Income Stream, upon rebook

Line 785: okl_api.set_message(p_app_name => g_app_name,

781: x_return_status => l_return_status,
782: x_primary_sty_id => l_rep_sty_id
783: );
784: IF l_return_status <> 'S' THEN
785: okl_api.set_message(p_app_name => g_app_name,
786: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
787: p_token1 => 'STREAM_NAME',
788: p_token1_value => l_investor_rental_accrual);
789: RAISE okl_api.g_exception_error;

Line 789: RAISE okl_api.g_exception_error;

785: okl_api.set_message(p_app_name => g_app_name,
786: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
787: p_token1 => 'STREAM_NAME',
788: p_token1_value => l_investor_rental_accrual);
789: RAISE okl_api.g_exception_error;
790:
791: END IF;
792:
793: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 808: okl_api.set_message(p_app_name => g_app_name,

804: x_primary_sty_id => l_rep_sty_id
805: );
806:
807: IF l_return_status <> 'S' THEN
808: okl_api.set_message(p_app_name => g_app_name,
809: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
810: p_token1 => 'STREAM_NAME',
811: p_token1_value => l_investor_pre_tax_income);
812: RAISE okl_api.g_exception_error;

Line 812: RAISE okl_api.g_exception_error;

808: okl_api.set_message(p_app_name => g_app_name,
809: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
810: p_token1 => 'STREAM_NAME',
811: p_token1_value => l_investor_pre_tax_income);
812: RAISE okl_api.g_exception_error;
813: END IF;
814:
815: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
816: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 840: okl_api.set_message(p_app_name => g_app_name,

836: x_return_status => l_return_status,
837: x_primary_sty_id => l_sty_id
838: );
839: IF l_return_status <> 'S' THEN
840: okl_api.set_message(p_app_name => g_app_name,
841: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
842: p_token1 => 'STREAM_NAME',
843: p_token1_value => l_inv_interest_income_accrual);
844: RAISE okl_api.g_exception_error;

Line 844: RAISE okl_api.g_exception_error;

840: okl_api.set_message(p_app_name => g_app_name,
841: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
842: p_token1 => 'STREAM_NAME',
843: p_token1_value => l_inv_interest_income_accrual);
844: RAISE okl_api.g_exception_error;
845: END IF;
846: -- calculate total revenue share
847: FOR get_revenue_share_rec IN get_revenue_share_csr(l_inv_id, 'LOAN_PAYMENT') LOOP
848: l_revenue_share := l_revenue_share + get_revenue_share_rec.percent_stake;

Line 853: okl_api.set_message(p_app_name => g_app_name,

849: END LOOP;
850: IF l_revenue_share IS NULL OR
851: l_revenue_share = 0 THEN
852: -- store SQL error message on message stack for caller
853: okl_api.set_message(p_app_name => g_app_name,
854: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
855: RAISE okl_api.G_EXCEPTION_ERROR;
856: END IF;
857: stream_type_purpose := l_interest_income;

Line 855: RAISE okl_api.G_EXCEPTION_ERROR;

851: l_revenue_share = 0 THEN
852: -- store SQL error message on message stack for caller
853: okl_api.set_message(p_app_name => g_app_name,
854: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
855: RAISE okl_api.G_EXCEPTION_ERROR;
856: END IF;
857: stream_type_purpose := l_interest_income;
858: /* ankushar , 16-01-2008 Bug 6691554
859: End Changes

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

951: p_stmv_rec => l_stmv_rec,
952: p_selv_tbl => l_selv_tbl,
953: x_stmv_rec => x_stmv_rec,
954: x_selv_tbl => x_selv_tbl);
955: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
956: RAISE okl_api.g_exception_unexpected_error;
957: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
958: RAISE okl_api.g_exception_error;
959: END IF;

Line 956: RAISE okl_api.g_exception_unexpected_error;

952: p_selv_tbl => l_selv_tbl,
953: x_stmv_rec => x_stmv_rec,
954: x_selv_tbl => x_selv_tbl);
955: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
956: RAISE okl_api.g_exception_unexpected_error;
957: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
958: RAISE okl_api.g_exception_error;
959: END IF;
960: END IF;

Line 957: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN

953: x_stmv_rec => x_stmv_rec,
954: x_selv_tbl => x_selv_tbl);
955: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
956: RAISE okl_api.g_exception_unexpected_error;
957: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
958: RAISE okl_api.g_exception_error;
959: END IF;
960: END IF;
961: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------

Line 958: RAISE okl_api.g_exception_error;

954: x_selv_tbl => x_selv_tbl);
955: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
956: RAISE okl_api.g_exception_unexpected_error;
957: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
958: RAISE okl_api.g_exception_error;
959: END IF;
960: END IF;
961: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------
962:

Line 1018: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1014: ,p_stmv_rec => l_rep_stmv_rec
1015: ,p_selv_tbl => l_rep_selv_tbl
1016: ,x_stmv_rec => x_rep_stmv_rec
1017: ,x_selv_tbl => x_rep_selv_tbl );
1018: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1021: RAISE Okl_Api.G_EXCEPTION_ERROR;
1022: END IF;

Line 1019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1015: ,p_selv_tbl => l_rep_selv_tbl
1016: ,x_stmv_rec => x_rep_stmv_rec
1017: ,x_selv_tbl => x_rep_selv_tbl );
1018: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1021: RAISE Okl_Api.G_EXCEPTION_ERROR;
1022: END IF;
1023: END IF;

Line 1020: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1016: ,x_stmv_rec => x_rep_stmv_rec
1017: ,x_selv_tbl => x_rep_selv_tbl );
1018: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1021: RAISE Okl_Api.G_EXCEPTION_ERROR;
1022: END IF;
1023: END IF;
1024:

Line 1021: RAISE Okl_Api.G_EXCEPTION_ERROR;

1017: ,x_selv_tbl => x_rep_selv_tbl );
1018: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1021: RAISE Okl_Api.G_EXCEPTION_ERROR;
1022: END IF;
1023: END IF;
1024:
1025: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------

Line 1039: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1035: ,x_msg_count => x_msg_count
1036: ,x_msg_data => x_msg_data
1037: ,p_khr_id =>l_contracts_csr.khr_id
1038: );
1039: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;

Line 1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1036: ,x_msg_data => x_msg_data
1037: ,p_khr_id =>l_contracts_csr.khr_id
1038: );
1039: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:

Line 1041: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1037: ,p_khr_id =>l_contracts_csr.khr_id
1038: );
1039: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:
1045: -- Update the status of primary streams from 'CURR' to 'HIST'

Line 1042: RAISE Okl_Api.G_EXCEPTION_ERROR;

1038: );
1039: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:
1045: -- Update the status of primary streams from 'CURR' to 'HIST'
1046:

Line 1075: okl_api.set_message (p_app_name => G_APP_NAME,

1071: WHERE ID = l_id_tbl(i);
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: okl_api.set_message (p_app_name => G_APP_NAME,
1076: p_msg_name => G_DB_ERROR,
1077: p_token1 => G_PROG_NAME_TOKEN,
1078: p_token1_value => l_api_name,
1079: p_token2 => G_SQLCODE_TOKEN,

Line 1083: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1079: p_token2 => G_SQLCODE_TOKEN,
1080: p_token2_value => sqlcode,
1081: p_token3 => G_SQLERRM_TOKEN,
1082: p_token3_value => sqlerrm);
1083: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1084: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END;
1086: END IF;
1087:

Line 1084: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1080: p_token2_value => sqlcode,
1081: p_token3 => G_SQLERRM_TOKEN,
1082: p_token3_value => sqlerrm);
1083: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1084: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END;
1086: END IF;
1087:
1088: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin

Line 1119: okl_api.set_message (p_app_name => G_APP_NAME,

1115: WHERE ID = l_rep_id_tbl(i);
1116:
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: okl_api.set_message (p_app_name => G_APP_NAME,
1120: p_msg_name => G_DB_ERROR,
1121: p_token1 => G_PROG_NAME_TOKEN,
1122: p_token1_value => l_api_name,
1123: p_token2 => G_SQLCODE_TOKEN,

Line 1127: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1123: p_token2 => G_SQLCODE_TOKEN,
1124: p_token2_value => sqlcode,
1125: p_token3 => G_SQLERRM_TOKEN,
1126: p_token3_value => sqlerrm);
1127: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1128: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1129: END;
1130: END IF;
1131: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end

Line 1128: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1124: p_token2_value => sqlcode,
1125: p_token3 => G_SQLERRM_TOKEN,
1126: p_token3_value => sqlerrm);
1127: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1128: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1129: END;
1130: END IF;
1131: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end
1132:

Line 1163: okl_api.set_message (p_app_name => G_APP_NAME,

1159: WHERE ID = l_id_tbl(i);
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: okl_api.set_message (p_app_name => G_APP_NAME,
1164: p_msg_name => G_DB_ERROR,
1165: p_token1 => G_PROG_NAME_TOKEN,
1166: p_token1_value => l_api_name,
1167: p_token2 => G_SQLCODE_TOKEN,

Line 1171: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1167: p_token2 => G_SQLCODE_TOKEN,
1168: p_token2_value => sqlcode,
1169: p_token3 => G_SQLERRM_TOKEN,
1170: p_token3_value => sqlerrm);
1171: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1172: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: END;
1174: END IF;
1175:

Line 1172: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1168: p_token2_value => sqlcode,
1169: p_token3 => G_SQLERRM_TOKEN,
1170: p_token3_value => sqlerrm);
1171: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1172: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: END;
1174: END IF;
1175:
1176:

Line 1209: okl_api.set_message (p_app_name => G_APP_NAME,

1205: WHERE ID = l_rep_id_tbl(i);
1206:
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: okl_api.set_message (p_app_name => G_APP_NAME,
1210: p_msg_name => G_DB_ERROR,
1211: p_token1 => G_PROG_NAME_TOKEN,
1212: p_token1_value => l_api_name,
1213: p_token2 => G_SQLCODE_TOKEN,

Line 1217: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1213: p_token2 => G_SQLCODE_TOKEN,
1214: p_token2_value => sqlcode,
1215: p_token3 => G_SQLERRM_TOKEN,
1216: p_token3_value => sqlerrm);
1217: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1218: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: END;
1220: END IF;
1221:

Line 1218: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1214: p_token2_value => sqlcode,
1215: p_token3 => G_SQLERRM_TOKEN,
1216: p_token3_value => sqlerrm);
1217: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1218: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: END;
1220: END IF;
1221:
1222:

Line 1226: WHEN okl_api.g_exception_error THEN

1222:
1223:
1224:
1225: EXCEPTION
1226: WHEN okl_api.g_exception_error THEN
1227: IF contract_number_csr%ISOPEN THEN
1228: CLOSE contract_number_csr;
1229: END IF;
1230: IF get_kle_id_csr%ISOPEN THEN

Line 1242: x_return_status := okl_api.handle_exceptions(l_api_name,

1238: END IF;
1239: IF strm_csr%ISOPEN THEN
1240: CLOSE strm_csr;
1241: END IF;
1242: x_return_status := okl_api.handle_exceptions(l_api_name,
1243: g_pkg_name,
1244: 'OKL_API.G_RET_STS_ERROR',
1245: x_msg_count,
1246: x_msg_data,

Line 1244: 'OKL_API.G_RET_STS_ERROR',

1240: CLOSE strm_csr;
1241: END IF;
1242: x_return_status := okl_api.handle_exceptions(l_api_name,
1243: g_pkg_name,
1244: 'OKL_API.G_RET_STS_ERROR',
1245: x_msg_count,
1246: x_msg_data,
1247: '_PVT');
1248: WHEN okl_api.g_exception_unexpected_error THEN

Line 1248: WHEN okl_api.g_exception_unexpected_error THEN

1244: 'OKL_API.G_RET_STS_ERROR',
1245: x_msg_count,
1246: x_msg_data,
1247: '_PVT');
1248: WHEN okl_api.g_exception_unexpected_error THEN
1249: IF contract_number_csr%ISOPEN THEN
1250: CLOSE contract_number_csr;
1251: END IF;
1252: IF get_kle_id_csr%ISOPEN THEN

Line 1264: x_return_status := okl_api.handle_exceptions(l_api_name,

1260: END IF;
1261: IF strm_csr%ISOPEN THEN
1262: CLOSE strm_csr;
1263: END IF;
1264: x_return_status := okl_api.handle_exceptions(l_api_name,
1265: g_pkg_name,
1266: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1267: x_msg_count,
1268: x_msg_data,

Line 1266: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1262: CLOSE strm_csr;
1263: END IF;
1264: x_return_status := okl_api.handle_exceptions(l_api_name,
1265: g_pkg_name,
1266: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1267: x_msg_count,
1268: x_msg_data,
1269: '_PVT');
1270: WHEN OTHERS THEN

Line 1286: x_return_status := okl_api.handle_exceptions(l_api_name,

1282: END IF;
1283: IF strm_csr%ISOPEN THEN
1284: CLOSE strm_csr;
1285: END IF;
1286: x_return_status := okl_api.handle_exceptions(l_api_name,
1287: g_pkg_name,
1288: 'OTHERS',
1289: x_msg_count,
1290: x_msg_data,

Line 1293: OKL_API.END_ACTIVITY (x_msg_count,

1289: x_msg_count,
1290: x_msg_data,
1291: '_PVT');
1292: END;
1293: OKL_API.END_ACTIVITY (x_msg_count,
1294: x_msg_data );
1295: EXCEPTION
1296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1297: IF contract_number_csr%ISOPEN THEN

Line 1296: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1292: END;
1293: OKL_API.END_ACTIVITY (x_msg_count,
1294: x_msg_data );
1295: EXCEPTION
1296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1297: IF contract_number_csr%ISOPEN THEN
1298: CLOSE contract_number_csr;
1299: END IF;
1300: IF get_kle_id_csr%ISOPEN THEN

Line 1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1314: END IF;
1315: IF get_inv_csr%ISOPEN THEN
1316: CLOSE get_inv_csr;
1317: END IF;
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1319: l_api_name,
1320: G_PKG_NAME,
1321: 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count,

Line 1321: 'OKL_API.G_RET_STS_ERROR',

1317: END IF;
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1319: l_api_name,
1320: G_PKG_NAME,
1321: 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count,
1323: x_msg_data,
1324: '_PVT');
1325: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1325: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1321: 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count,
1323: x_msg_data,
1324: '_PVT');
1325: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1326: IF contract_number_csr%ISOPEN THEN
1327: CLOSE contract_number_csr;
1328: END IF;
1329: IF get_kle_id_csr%ISOPEN THEN

Line 1347: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1343: END IF;
1344: IF get_inv_csr%ISOPEN THEN
1345: CLOSE get_inv_csr;
1346: END IF;
1347: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1348: l_api_name,
1349: G_PKG_NAME,
1350: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1351: x_msg_count,

Line 1350: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1346: END IF;
1347: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1348: l_api_name,
1349: G_PKG_NAME,
1350: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1351: x_msg_count,
1352: x_msg_data,
1353: '_PVT');
1354: WHEN OTHERS THEN

Line 1376: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1372: END IF;
1373: IF get_inv_csr%ISOPEN THEN
1374: CLOSE get_inv_csr;
1375: END IF;
1376: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1377: l_api_name,
1378: G_PKG_NAME,
1379: 'OTHERS',
1380: x_msg_count,

Line 1398: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;

1394:
1395: l_count NUMBER := 1;
1396: l_api_version CONSTANT NUMBER := 1.0;
1397: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STREAMS';
1398: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
1399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1400: l_msg_count NUMBER;
1401: l_msg_data VARCHAR2(2000);
1402: l_period_end_date DATE;

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

1395: l_count NUMBER := 1;
1396: l_api_version CONSTANT NUMBER := 1.0;
1397: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STREAMS';
1398: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
1399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1400: l_msg_count NUMBER;
1401: l_msg_data VARCHAR2(2000);
1402: l_period_end_date DATE;
1403: l_total_records NUMBER;

Line 1633: l_return_status := OKL_API.START_ACTIVITY(

1629: ORDER BY ste.stream_element_date;
1630:
1631: BEGIN
1632: -- Set save point
1633: l_return_status := OKL_API.START_ACTIVITY(
1634: p_api_name => l_api_name,
1635: p_pkg_name => G_PKG_NAME,
1636: p_init_msg_list => p_init_msg_list,
1637: l_api_version => l_api_version,

Line 1641: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1637: l_api_version => l_api_version,
1638: p_api_version => p_api_version,
1639: p_api_type => '_PVT',
1640: x_return_status => l_return_status);
1641: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okl_Api.G_EXCEPTION_ERROR;
1645: END IF;

Line 1642: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1638: p_api_version => p_api_version,
1639: p_api_type => '_PVT',
1640: x_return_status => l_return_status);
1641: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okl_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646:

Line 1643: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1639: p_api_type => '_PVT',
1640: x_return_status => l_return_status);
1641: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okl_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646:
1647: OPEN contract_number_csr(p_khr_id);

Line 1644: RAISE Okl_Api.G_EXCEPTION_ERROR;

1640: x_return_status => l_return_status);
1641: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okl_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646:
1647: OPEN contract_number_csr(p_khr_id);
1648: FETCH contract_number_csr INTO l_khr_num,

Line 1669: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1665: x_msg_count => x_msg_count,
1666: x_msg_data => x_msg_data,
1667: p_khr_id => p_khr_id,
1668: p_mode => p_mode);
1669: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673: END IF;

Line 1670: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1666: x_msg_data => x_msg_data,
1667: p_khr_id => p_khr_id,
1668: p_mode => p_mode);
1669: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673: END IF;
1674: -- If the contract is Investor contract then we call the below

Line 1671: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1667: p_khr_id => p_khr_id,
1668: p_mode => p_mode);
1669: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673: END IF;
1674: -- If the contract is Investor contract then we call the below
1675: ELSIF l_scs_code = 'INVESTOR' THEN

Line 1672: RAISE Okl_Api.G_EXCEPTION_ERROR;

1668: p_mode => p_mode);
1669: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673: END IF;
1674: -- If the contract is Investor contract then we call the below
1675: ELSIF l_scs_code = 'INVESTOR' THEN
1676: -- validate in parameters

Line 1678: p_khr_id = OKL_API.G_MISS_NUM THEN

1674: -- If the contract is Investor contract then we call the below
1675: ELSIF l_scs_code = 'INVESTOR' THEN
1676: -- validate in parameters
1677: IF p_khr_id IS NULL OR
1678: p_khr_id = OKL_API.G_MISS_NUM THEN
1679: -- store SQL error message on message stack for caller
1680: Okl_Api.set_message(p_app_name => g_app_name,
1681: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
1682: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1680: Okl_Api.set_message(p_app_name => g_app_name,

1676: -- validate in parameters
1677: IF p_khr_id IS NULL OR
1678: p_khr_id = OKL_API.G_MISS_NUM THEN
1679: -- store SQL error message on message stack for caller
1680: Okl_Api.set_message(p_app_name => g_app_name,
1681: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
1682: RAISE Okl_Api.G_EXCEPTION_ERROR;
1683: END IF;
1684:

Line 1682: RAISE Okl_Api.G_EXCEPTION_ERROR;

1678: p_khr_id = OKL_API.G_MISS_NUM THEN
1679: -- store SQL error message on message stack for caller
1680: Okl_Api.set_message(p_app_name => g_app_name,
1681: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
1682: RAISE Okl_Api.G_EXCEPTION_ERROR;
1683: END IF;
1684:
1685:
1686:

Line 1740: l_kle_id = OKL_API.G_MISS_NUM THEN

1736: FETCH get_kle_id_csr INTO l_kle_id, l_start_date;
1737: CLOSE get_kle_id_csr;
1738:
1739: IF l_kle_id IS NULL OR
1740: l_kle_id = OKL_API.G_MISS_NUM THEN
1741: Okl_Api.set_message(p_app_name => g_app_name,
1742: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
1743: p_token1 => g_contract_number_token,
1744: p_token1_value => l_contract_number);

Line 1741: Okl_Api.set_message(p_app_name => g_app_name,

1737: CLOSE get_kle_id_csr;
1738:
1739: IF l_kle_id IS NULL OR
1740: l_kle_id = OKL_API.G_MISS_NUM THEN
1741: Okl_Api.set_message(p_app_name => g_app_name,
1742: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
1743: p_token1 => g_contract_number_token,
1744: p_token1_value => l_contract_number);
1745: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1745: RAISE OKL_API.G_EXCEPTION_ERROR;

1741: Okl_Api.set_message(p_app_name => g_app_name,
1742: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
1743: p_token1 => g_contract_number_token,
1744: p_token1_value => l_contract_number);
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747:
1748: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
1749: Okl_Api.set_message(p_app_name => g_app_name,

Line 1748: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN

1744: p_token1_value => l_contract_number);
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747:
1748: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
1749: Okl_Api.set_message(p_app_name => g_app_name,
1750: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
1751: RAISE OKL_API.G_EXCEPTION_ERROR;
1752: END IF;

Line 1749: Okl_Api.set_message(p_app_name => g_app_name,

1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747:
1748: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
1749: Okl_Api.set_message(p_app_name => g_app_name,
1750: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
1751: RAISE OKL_API.G_EXCEPTION_ERROR;
1752: END IF;
1753:

Line 1751: RAISE OKL_API.G_EXCEPTION_ERROR;

1747:
1748: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
1749: Okl_Api.set_message(p_app_name => g_app_name,
1750: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
1751: RAISE OKL_API.G_EXCEPTION_ERROR;
1752: END IF;
1753:
1754: OPEN get_adv_arr_csr(l_contracts_csr.khr_id, l_kle_id);
1755: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;

Line 1759: Okl_Api.set_message(p_app_name => g_app_name,

1755: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;
1756: CLOSE get_adv_arr_csr;
1757:
1758: IF l_frequency IS NULL THEN
1759: Okl_Api.set_message(p_app_name => g_app_name,
1760: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
1761: p_token1 => g_contract_number_token,
1762: p_token1_value => l_contract_number);
1763: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1763: RAISE OKL_API.G_EXCEPTION_ERROR;

1759: Okl_Api.set_message(p_app_name => g_app_name,
1760: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
1761: p_token1 => g_contract_number_token,
1762: p_token1_value => l_contract_number);
1763: RAISE OKL_API.G_EXCEPTION_ERROR;
1764: END IF;
1765:
1766: IF l_arrears = 'Y' THEN
1767: ln_days := okl_stream_generator_pvt.get_day_count (

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

1768: p_start_date => ADD_MONTHS(l_start_date, -l_frequency),
1769: p_end_date => l_start_date,
1770: p_arrears => l_arrears,
1771: x_return_status => l_return_status);
1772: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1773: RAISE okl_api.g_exception_unexpected_error;
1774: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
1775: RAISE okl_api.g_exception_error;
1776: END IF;

Line 1773: RAISE okl_api.g_exception_unexpected_error;

1769: p_end_date => l_start_date,
1770: p_arrears => l_arrears,
1771: x_return_status => l_return_status);
1772: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1773: RAISE okl_api.g_exception_unexpected_error;
1774: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
1775: RAISE okl_api.g_exception_error;
1776: END IF;
1777: l_final_start_date := l_start_date - ln_days;

Line 1774: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN

1770: p_arrears => l_arrears,
1771: x_return_status => l_return_status);
1772: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1773: RAISE okl_api.g_exception_unexpected_error;
1774: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
1775: RAISE okl_api.g_exception_error;
1776: END IF;
1777: l_final_start_date := l_start_date - ln_days;
1778: ELSIF NVL(l_arrears,'N') = 'N' THEN

Line 1775: RAISE okl_api.g_exception_error;

1771: x_return_status => l_return_status);
1772: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1773: RAISE okl_api.g_exception_unexpected_error;
1774: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
1775: RAISE okl_api.g_exception_error;
1776: END IF;
1777: l_final_start_date := l_start_date - ln_days;
1778: ELSIF NVL(l_arrears,'N') = 'N' THEN
1779: l_final_start_date := l_start_date;

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

1790: x_rep_product => lx_rep_product,
1791: x_rep_product_id => lx_rep_product_id,
1792: x_rep_deal_type => lx_rep_deal_type);
1793:
1794: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1796: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1797: RAISE OKL_API.G_EXCEPTION_ERROR;
1798: END IF;

Line 1795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1791: x_rep_product_id => lx_rep_product_id,
1792: x_rep_deal_type => lx_rep_deal_type);
1793:
1794: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1796: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1797: RAISE OKL_API.G_EXCEPTION_ERROR;
1798: END IF;
1799:

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

1792: x_rep_deal_type => lx_rep_deal_type);
1793:
1794: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1796: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1797: RAISE OKL_API.G_EXCEPTION_ERROR;
1798: END IF;
1799:
1800: /*

Line 1797: RAISE OKL_API.G_EXCEPTION_ERROR;

1793:
1794: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1796: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1797: RAISE OKL_API.G_EXCEPTION_ERROR;
1798: END IF;
1799:
1800: /*
1801: --Check the secondary_rep_method

Line 1805: okl_api.set_message(p_app_name => g_app_name,

1801: --Check the secondary_rep_method
1802: OPEN l_sec_rep_method_csr ;
1803: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
1804: IF l_sec_rep_method_csr%NOTFOUND THEN
1805: okl_api.set_message(p_app_name => g_app_name,
1806: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
1807: );
1808: RAISE okl_api.g_exception_error;
1809: END IF;

Line 1808: RAISE okl_api.g_exception_error;

1804: IF l_sec_rep_method_csr%NOTFOUND THEN
1805: okl_api.set_message(p_app_name => g_app_name,
1806: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
1807: );
1808: RAISE okl_api.g_exception_error;
1809: END IF;
1810: CLOSE l_sec_rep_method_csr ;
1811: */
1812: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------

Line 1851: okl_api.set_message(p_app_name => g_app_name,

1847: x_return_status => l_return_status,
1848: x_primary_sty_id => l_sty_id
1849: );
1850: IF l_return_status <> 'S' THEN
1851: okl_api.set_message(p_app_name => g_app_name,
1852: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1853: p_token1 => 'STREAM_NAME',
1854: p_token1_value => l_investor_rental_accrual);
1855: RAISE okl_api.g_exception_error;

Line 1855: RAISE okl_api.g_exception_error;

1851: okl_api.set_message(p_app_name => g_app_name,
1852: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1853: p_token1 => 'STREAM_NAME',
1854: p_token1_value => l_investor_rental_accrual);
1855: RAISE okl_api.g_exception_error;
1856:
1857: END IF;
1858:
1859: -- calculate total revenue share

Line 1868: Okl_Api.set_message(p_app_name => g_app_name,

1864: END LOOP;
1865:
1866: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
1867: -- store SQL error message on message stack for caller
1868: Okl_Api.set_message(p_app_name => g_app_name,
1869: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
1870: RAISE Okl_Api.G_EXCEPTION_ERROR;
1871: END IF;
1872: --Modified by kthiruva on 19-Oct-2005 . The stream type purpose needs to be bound instead

Line 1870: RAISE Okl_Api.G_EXCEPTION_ERROR;

1866: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
1867: -- store SQL error message on message stack for caller
1868: Okl_Api.set_message(p_app_name => g_app_name,
1869: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
1870: RAISE Okl_Api.G_EXCEPTION_ERROR;
1871: END IF;
1872: --Modified by kthiruva on 19-Oct-2005 . The stream type purpose needs to be bound instead
1873: --of the stream type code
1874: --Bug 4228708 - Start of Changes

Line 1897: okl_api.set_message(p_app_name => g_app_name,

1893: x_return_status => l_return_status,
1894: x_primary_sty_id => l_rep_sty_id
1895: );
1896: IF l_return_status <> 'S' THEN
1897: okl_api.set_message(p_app_name => g_app_name,
1898: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1899: p_token1 => 'STREAM_NAME',
1900: p_token1_value => l_investor_rental_accrual);
1901: RAISE okl_api.g_exception_error;

Line 1901: RAISE okl_api.g_exception_error;

1897: okl_api.set_message(p_app_name => g_app_name,
1898: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1899: p_token1 => 'STREAM_NAME',
1900: p_token1_value => l_investor_rental_accrual);
1901: RAISE okl_api.g_exception_error;
1902:
1903: END IF;
1904:
1905: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 1920: okl_api.set_message(p_app_name => g_app_name,

1916: x_primary_sty_id => l_rep_sty_id
1917: );
1918:
1919: IF l_return_status <> 'S' THEN
1920: okl_api.set_message(p_app_name => g_app_name,
1921: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1922: p_token1 => 'STREAM_NAME',
1923: p_token1_value => l_investor_pre_tax_income);
1924: RAISE okl_api.g_exception_error;

Line 1924: RAISE okl_api.g_exception_error;

1920: okl_api.set_message(p_app_name => g_app_name,
1921: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1922: p_token1 => 'STREAM_NAME',
1923: p_token1_value => l_investor_pre_tax_income);
1924: RAISE okl_api.g_exception_error;
1925: END IF;
1926:
1927: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
1928: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 1948: okl_api.set_message(p_app_name => g_app_name,

1944: x_primary_sty_id => l_sty_id
1945: );
1946:
1947: IF l_return_status <> 'S' THEN
1948: okl_api.set_message(p_app_name => g_app_name,
1949: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1950: p_token1 => 'STREAM_NAME',
1951: p_token1_value => l_investor_pre_tax_income);
1952: RAISE okl_api.g_exception_error;

Line 1952: RAISE okl_api.g_exception_error;

1948: okl_api.set_message(p_app_name => g_app_name,
1949: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1950: p_token1 => 'STREAM_NAME',
1951: p_token1_value => l_investor_pre_tax_income);
1952: RAISE okl_api.g_exception_error;
1953: END IF;
1954:
1955: -- calculate total revenue share
1956: FOR x IN get_investors_csr(p_khr_id) LOOP

Line 1964: Okl_Api.set_message(p_app_name => g_app_name,

1960: END LOOP;
1961:
1962: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
1963: -- store SQL error message on message stack for caller
1964: Okl_Api.set_message(p_app_name => g_app_name,
1965: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
1966: RAISE Okl_Api.G_EXCEPTION_ERROR;
1967: END IF;
1968: stream_type_purpose := l_pre_tax_income; --Pre Tax Income for Primary product

Line 1966: RAISE Okl_Api.G_EXCEPTION_ERROR;

1962: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
1963: -- store SQL error message on message stack for caller
1964: Okl_Api.set_message(p_app_name => g_app_name,
1965: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
1966: RAISE Okl_Api.G_EXCEPTION_ERROR;
1967: END IF;
1968: stream_type_purpose := l_pre_tax_income; --Pre Tax Income for Primary product
1969: -- sechawla : This is the 'Pre Tax Income' stream, generated when DF/ST lease contract is Booked
1970: -- sechawla : This stream is used to generate Investor Pre Tax Income Stream, upon IA activation

Line 1987: okl_api.set_message(p_app_name => g_app_name,

1983: x_return_status => l_return_status,
1984: x_primary_sty_id => l_rep_sty_id
1985: );
1986: IF l_return_status <> 'S' THEN
1987: okl_api.set_message(p_app_name => g_app_name,
1988: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1989: p_token1 => 'STREAM_NAME',
1990: p_token1_value => l_investor_rental_accrual);
1991: RAISE okl_api.g_exception_error;

Line 1991: RAISE okl_api.g_exception_error;

1987: okl_api.set_message(p_app_name => g_app_name,
1988: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
1989: p_token1 => 'STREAM_NAME',
1990: p_token1_value => l_investor_rental_accrual);
1991: RAISE okl_api.g_exception_error;
1992:
1993: END IF;
1994:
1995: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 2010: okl_api.set_message(p_app_name => g_app_name,

2006: x_primary_sty_id => l_rep_sty_id
2007: );
2008:
2009: IF l_return_status <> 'S' THEN
2010: okl_api.set_message(p_app_name => g_app_name,
2011: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2012: p_token1 => 'STREAM_NAME',
2013: p_token1_value => l_investor_pre_tax_income);
2014: RAISE okl_api.g_exception_error;

Line 2014: RAISE okl_api.g_exception_error;

2010: okl_api.set_message(p_app_name => g_app_name,
2011: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2012: p_token1 => 'STREAM_NAME',
2013: p_token1_value => l_investor_pre_tax_income);
2014: RAISE okl_api.g_exception_error;
2015: END IF;
2016:
2017: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
2018: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 2041: okl_api.set_message(p_app_name => g_app_name,

2037: x_return_status => l_return_status,
2038: x_primary_sty_id => l_sty_id
2039: );
2040: IF l_return_status <> 'S' THEN
2041: okl_api.set_message(p_app_name => g_app_name,
2042: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2043: p_token1 => 'STREAM_NAME',
2044: p_token1_value => l_inv_interest_income_accrual);
2045: RAISE okl_api.g_exception_error;

Line 2045: RAISE okl_api.g_exception_error;

2041: okl_api.set_message(p_app_name => g_app_name,
2042: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2043: p_token1 => 'STREAM_NAME',
2044: p_token1_value => l_inv_interest_income_accrual);
2045: RAISE okl_api.g_exception_error;
2046: END IF;
2047:
2048: -- calculate total revenue share
2049: FOR x IN get_investors_csr(p_khr_id) LOOP

Line 2057: Okl_Api.set_message(p_app_name => g_app_name,

2053: END LOOP;
2054:
2055: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2056: -- store SQL error message on message stack for caller
2057: Okl_Api.set_message(p_app_name => g_app_name,
2058: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;
2061:

Line 2059: RAISE Okl_Api.G_EXCEPTION_ERROR;

2055: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2056: -- store SQL error message on message stack for caller
2057: Okl_Api.set_message(p_app_name => g_app_name,
2058: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;
2061:
2062: stream_type_purpose := l_interest_income;
2063: /* ankushar , 16-01-2008 Bug 6740000

Line 2156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2152: ,p_stmv_rec => l_stmv_rec
2153: ,p_selv_tbl => l_selv_tbl
2154: ,x_stmv_rec => x_stmv_rec
2155: ,x_selv_tbl => x_selv_tbl );
2156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;

Line 2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2153: ,p_selv_tbl => l_selv_tbl
2154: ,x_stmv_rec => x_stmv_rec
2155: ,x_selv_tbl => x_selv_tbl );
2156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161: END IF;

Line 2158: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2154: ,x_stmv_rec => x_stmv_rec
2155: ,x_selv_tbl => x_selv_tbl );
2156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161: END IF;
2162:

Line 2159: RAISE Okl_Api.G_EXCEPTION_ERROR;

2155: ,x_selv_tbl => x_selv_tbl );
2156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161: END IF;
2162:
2163: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------

Line 2215: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2211: ,p_stmv_rec => l_rep_stmv_rec
2212: ,p_selv_tbl => l_rep_selv_tbl
2213: ,x_stmv_rec => x_rep_stmv_rec
2214: ,x_selv_tbl => x_rep_selv_tbl );
2215: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2216: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2217: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2218: RAISE Okl_Api.G_EXCEPTION_ERROR;
2219: END IF;

Line 2216: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2212: ,p_selv_tbl => l_rep_selv_tbl
2213: ,x_stmv_rec => x_rep_stmv_rec
2214: ,x_selv_tbl => x_rep_selv_tbl );
2215: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2216: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2217: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2218: RAISE Okl_Api.G_EXCEPTION_ERROR;
2219: END IF;
2220: END IF;

Line 2217: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2213: ,x_stmv_rec => x_rep_stmv_rec
2214: ,x_selv_tbl => x_rep_selv_tbl );
2215: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2216: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2217: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2218: RAISE Okl_Api.G_EXCEPTION_ERROR;
2219: END IF;
2220: END IF;
2221:

Line 2218: RAISE Okl_Api.G_EXCEPTION_ERROR;

2214: ,x_selv_tbl => x_rep_selv_tbl );
2215: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2216: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2217: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2218: RAISE Okl_Api.G_EXCEPTION_ERROR;
2219: END IF;
2220: END IF;
2221:
2222: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------

Line 2224: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2220: END IF;
2221:
2222: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------
2223: EXCEPTION
2224: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2225: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count

Line 2225: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2221:
2222: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------
2223: EXCEPTION
2224: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2225: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data

Line 2227: ,'OKL_API.G_RET_STS_ERROR'

2223: EXCEPTION
2224: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2225: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2231: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count

Line 2232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count
2236: ,x_msg_data

Line 2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2230: ,'_PVT');
2231: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count
2236: ,x_msg_data
2237: ,'_PVT');
2238: WHEN OTHERS THEN

Line 2253: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,

2249:
2250: IF strm_csr%ISOPEN THEN
2251: CLOSE strm_csr;
2252: END IF;
2253: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,
2254: G_PKG_NAME,
2255: 'OTHERS',
2256: x_msg_count,
2257: x_msg_data,

Line 2311: l_kle_id = OKL_API.G_MISS_NUM THEN

2307: FETCH get_kle_id_pend_csr INTO l_kle_id, l_start_date;
2308: CLOSE get_kle_id_pend_csr;
2309:
2310: IF l_kle_id IS NULL OR
2311: l_kle_id = OKL_API.G_MISS_NUM THEN
2312: Okl_Api.set_message(p_app_name => g_app_name,
2313: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
2314: p_token1 => g_contract_number_token,
2315: p_token1_value => l_contract_number);

Line 2312: Okl_Api.set_message(p_app_name => g_app_name,

2308: CLOSE get_kle_id_pend_csr;
2309:
2310: IF l_kle_id IS NULL OR
2311: l_kle_id = OKL_API.G_MISS_NUM THEN
2312: Okl_Api.set_message(p_app_name => g_app_name,
2313: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
2314: p_token1 => g_contract_number_token,
2315: p_token1_value => l_contract_number);
2316: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2316: RAISE OKL_API.G_EXCEPTION_ERROR;

2312: Okl_Api.set_message(p_app_name => g_app_name,
2313: p_msg_name => 'OKL_ASC_KLE_ID_ERROR',
2314: p_token1 => g_contract_number_token,
2315: p_token1_value => l_contract_number);
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
2320: Okl_Api.set_message(p_app_name => g_app_name,

Line 2319: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN

2315: p_token1_value => l_contract_number);
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
2320: Okl_Api.set_message(p_app_name => g_app_name,
2321: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
2322: RAISE OKL_API.G_EXCEPTION_ERROR;
2323: END IF;

Line 2320: Okl_Api.set_message(p_app_name => g_app_name,

2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
2320: Okl_Api.set_message(p_app_name => g_app_name,
2321: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
2322: RAISE OKL_API.G_EXCEPTION_ERROR;
2323: END IF;
2324:

Line 2322: RAISE OKL_API.G_EXCEPTION_ERROR;

2318:
2319: IF l_start_date IS NULL OR l_start_date = OKL_API.G_MISS_DATE THEN
2320: Okl_Api.set_message(p_app_name => g_app_name,
2321: p_msg_name => 'OKL_ASC_START_DATE_ERROR');
2322: RAISE OKL_API.G_EXCEPTION_ERROR;
2323: END IF;
2324:
2325: OPEN get_adv_arr_csr(l_contracts_csr.khr_id, l_kle_id);
2326: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;

Line 2330: Okl_Api.set_message(p_app_name => g_app_name,

2326: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;
2327: CLOSE get_adv_arr_csr;
2328:
2329: IF l_frequency IS NULL THEN
2330: Okl_Api.set_message(p_app_name => g_app_name,
2331: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
2332: p_token1 => g_contract_number_token,
2333: p_token1_value => l_contract_number);
2334: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2334: RAISE OKL_API.G_EXCEPTION_ERROR;

2330: Okl_Api.set_message(p_app_name => g_app_name,
2331: p_msg_name => 'OKL_ASC_FREQUENCY_ERROR',
2332: p_token1 => g_contract_number_token,
2333: p_token1_value => l_contract_number);
2334: RAISE OKL_API.G_EXCEPTION_ERROR;
2335: END IF;
2336:
2337: IF l_arrears = 'Y' THEN
2338: ln_days := okl_stream_generator_pvt.get_day_count (

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

2339: p_start_date => ADD_MONTHS(l_start_date, -l_frequency),
2340: p_end_date => l_start_date,
2341: p_arrears => l_arrears,
2342: x_return_status => l_return_status);
2343: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2344: RAISE okl_api.g_exception_unexpected_error;
2345: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
2346: RAISE okl_api.g_exception_error;
2347: END IF;

Line 2344: RAISE okl_api.g_exception_unexpected_error;

2340: p_end_date => l_start_date,
2341: p_arrears => l_arrears,
2342: x_return_status => l_return_status);
2343: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2344: RAISE okl_api.g_exception_unexpected_error;
2345: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
2346: RAISE okl_api.g_exception_error;
2347: END IF;
2348: l_final_start_date := l_start_date - ln_days;

Line 2345: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN

2341: p_arrears => l_arrears,
2342: x_return_status => l_return_status);
2343: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2344: RAISE okl_api.g_exception_unexpected_error;
2345: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
2346: RAISE okl_api.g_exception_error;
2347: END IF;
2348: l_final_start_date := l_start_date - ln_days;
2349: ELSIF NVL(l_arrears,'N') = 'N' THEN

Line 2346: RAISE okl_api.g_exception_error;

2342: x_return_status => l_return_status);
2343: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2344: RAISE okl_api.g_exception_unexpected_error;
2345: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
2346: RAISE okl_api.g_exception_error;
2347: END IF;
2348: l_final_start_date := l_start_date - ln_days;
2349: ELSIF NVL(l_arrears,'N') = 'N' THEN
2350: l_final_start_date := l_start_date;

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

2361: x_rep_product => lx_rep_product,
2362: x_rep_product_id => lx_rep_product_id,
2363: x_rep_deal_type => lx_rep_deal_type);
2364:
2365: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;

Line 2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2362: x_rep_product_id => lx_rep_product_id,
2363: x_rep_deal_type => lx_rep_deal_type);
2364:
2365: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:

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

2363: x_rep_deal_type => lx_rep_deal_type);
2364:
2365: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: /*

Line 2368: RAISE OKL_API.G_EXCEPTION_ERROR;

2364:
2365: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: /*
2372: --Check the secondary_rep_method

Line 2376: okl_api.set_message(p_app_name => g_app_name,

2372: --Check the secondary_rep_method
2373: OPEN l_sec_rep_method_csr ;
2374: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
2375: IF l_sec_rep_method_csr%NOTFOUND THEN
2376: okl_api.set_message(p_app_name => g_app_name,
2377: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
2378: );
2379: RAISE okl_api.g_exception_error;
2380: END IF;

Line 2379: RAISE okl_api.g_exception_error;

2375: IF l_sec_rep_method_csr%NOTFOUND THEN
2376: okl_api.set_message(p_app_name => g_app_name,
2377: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
2378: );
2379: RAISE okl_api.g_exception_error;
2380: END IF;
2381: CLOSE l_sec_rep_method_csr ;
2382: */
2383: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------

Line 2407: okl_api.set_message(p_app_name => g_app_name,

2403: x_return_status => l_return_status,
2404: x_primary_sty_id => l_sty_id
2405: );
2406: IF l_return_status <> 'S' THEN
2407: okl_api.set_message(p_app_name => g_app_name,
2408: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2409: p_token1 => 'STREAM_NAME',
2410: p_token1_value => l_investor_rental_accrual);
2411: RAISE okl_api.g_exception_error;

Line 2411: RAISE okl_api.g_exception_error;

2407: okl_api.set_message(p_app_name => g_app_name,
2408: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2409: p_token1 => 'STREAM_NAME',
2410: p_token1_value => l_investor_rental_accrual);
2411: RAISE okl_api.g_exception_error;
2412:
2413: END IF;
2414: -- calculate total revenue share
2415: FOR x IN get_investors_csr(p_khr_id) LOOP

Line 2423: Okl_Api.set_message(p_app_name => g_app_name,

2419: END LOOP;
2420:
2421: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2422: -- store SQL error message on message stack for caller
2423: Okl_Api.set_message(p_app_name => g_app_name,
2424: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2425: RAISE Okl_Api.G_EXCEPTION_ERROR;
2426: END IF;
2427: --Modified by kthiruva on 19-Oct-2005 . The stream type purpose needs to be bound instead

Line 2425: RAISE Okl_Api.G_EXCEPTION_ERROR;

2421: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2422: -- store SQL error message on message stack for caller
2423: Okl_Api.set_message(p_app_name => g_app_name,
2424: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2425: RAISE Okl_Api.G_EXCEPTION_ERROR;
2426: END IF;
2427: --Modified by kthiruva on 19-Oct-2005 . The stream type purpose needs to be bound instead
2428: --of the stream type code
2429: --Bug 4228708 - Start of Changes

Line 2453: okl_api.set_message(p_app_name => g_app_name,

2449: x_return_status => l_return_status,
2450: x_primary_sty_id => l_rep_sty_id
2451: );
2452: IF l_return_status <> 'S' THEN
2453: okl_api.set_message(p_app_name => g_app_name,
2454: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2455: p_token1 => 'STREAM_NAME',
2456: p_token1_value => l_investor_rental_accrual);
2457: RAISE okl_api.g_exception_error;

Line 2457: RAISE okl_api.g_exception_error;

2453: okl_api.set_message(p_app_name => g_app_name,
2454: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2455: p_token1 => 'STREAM_NAME',
2456: p_token1_value => l_investor_rental_accrual);
2457: RAISE okl_api.g_exception_error;
2458:
2459: END IF;
2460:
2461: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 2476: okl_api.set_message(p_app_name => g_app_name,

2472: x_primary_sty_id => l_rep_sty_id
2473: );
2474:
2475: IF l_return_status <> 'S' THEN
2476: okl_api.set_message(p_app_name => g_app_name,
2477: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2478: p_token1 => 'STREAM_NAME',
2479: p_token1_value => l_investor_pre_tax_income);
2480: RAISE okl_api.g_exception_error;

Line 2480: RAISE okl_api.g_exception_error;

2476: okl_api.set_message(p_app_name => g_app_name,
2477: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2478: p_token1 => 'STREAM_NAME',
2479: p_token1_value => l_investor_pre_tax_income);
2480: RAISE okl_api.g_exception_error;
2481: END IF;
2482:
2483: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
2484: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 2502: okl_api.set_message(p_app_name => g_app_name,

2498: x_primary_sty_id => l_sty_id
2499: );
2500:
2501: IF l_return_status <> 'S' THEN
2502: okl_api.set_message(p_app_name => g_app_name,
2503: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2504: p_token1 => 'STREAM_NAME',
2505: p_token1_value => l_investor_pre_tax_income);
2506: RAISE okl_api.g_exception_error;

Line 2506: RAISE okl_api.g_exception_error;

2502: okl_api.set_message(p_app_name => g_app_name,
2503: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2504: p_token1 => 'STREAM_NAME',
2505: p_token1_value => l_investor_pre_tax_income);
2506: RAISE okl_api.g_exception_error;
2507: END IF;
2508:
2509: -- calculate total revenue share
2510: FOR x IN get_investors_csr(p_khr_id) LOOP

Line 2518: Okl_Api.set_message(p_app_name => g_app_name,

2514: END LOOP;
2515:
2516: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2517: -- store SQL error message on message stack for caller
2518: Okl_Api.set_message(p_app_name => g_app_name,
2519: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2520: RAISE Okl_Api.G_EXCEPTION_ERROR;
2521: END IF;
2522: stream_type_purpose := l_pre_tax_income;--Pre Tax Income for Primary product

Line 2520: RAISE Okl_Api.G_EXCEPTION_ERROR;

2516: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2517: -- store SQL error message on message stack for caller
2518: Okl_Api.set_message(p_app_name => g_app_name,
2519: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2520: RAISE Okl_Api.G_EXCEPTION_ERROR;
2521: END IF;
2522: stream_type_purpose := l_pre_tax_income;--Pre Tax Income for Primary product
2523: -- sechawla : This is the 'Pre Tax Income' stream, generated when DF/ST lease contract is Booked
2524: -- sechawla : This stream is used to generate Investor Pre Tax Income Stream, upon IA activation

Line 2542: okl_api.set_message(p_app_name => g_app_name,

2538: x_return_status => l_return_status,
2539: x_primary_sty_id => l_rep_sty_id
2540: );
2541: IF l_return_status <> 'S' THEN
2542: okl_api.set_message(p_app_name => g_app_name,
2543: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2544: p_token1 => 'STREAM_NAME',
2545: p_token1_value => l_investor_rental_accrual);
2546: RAISE okl_api.g_exception_error;

Line 2546: RAISE okl_api.g_exception_error;

2542: okl_api.set_message(p_app_name => g_app_name,
2543: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2544: p_token1 => 'STREAM_NAME',
2545: p_token1_value => l_investor_rental_accrual);
2546: RAISE okl_api.g_exception_error;
2547:
2548: END IF;
2549:
2550: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product

Line 2565: okl_api.set_message(p_app_name => g_app_name,

2561: x_primary_sty_id => l_rep_sty_id
2562: );
2563:
2564: IF l_return_status <> 'S' THEN
2565: okl_api.set_message(p_app_name => g_app_name,
2566: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2567: p_token1 => 'STREAM_NAME',
2568: p_token1_value => l_investor_pre_tax_income);
2569: RAISE okl_api.g_exception_error;

Line 2569: RAISE okl_api.g_exception_error;

2565: okl_api.set_message(p_app_name => g_app_name,
2566: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR_REP', --> seed this
2567: p_token1 => 'STREAM_NAME',
2568: p_token1_value => l_investor_pre_tax_income);
2569: RAISE okl_api.g_exception_error;
2570: END IF;
2571:
2572: rep_stream_type_purpose := l_pre_tax_income; -- Pre Tax Income for reporting product
2573: --Pre Tax income stream is also generated for the reporting product (if DF/ST Lease), when contract

Line 2597: okl_api.set_message(p_app_name => g_app_name,

2593: x_return_status => l_return_status,
2594: x_primary_sty_id => l_sty_id
2595: );
2596: IF l_return_status <> 'S' THEN
2597: okl_api.set_message(p_app_name => g_app_name,
2598: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2599: p_token1 => 'STREAM_NAME',
2600: p_token1_value => l_inv_interest_income_accrual);
2601: RAISE okl_api.g_exception_error;

Line 2601: RAISE okl_api.g_exception_error;

2597: okl_api.set_message(p_app_name => g_app_name,
2598: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
2599: p_token1 => 'STREAM_NAME',
2600: p_token1_value => l_inv_interest_income_accrual);
2601: RAISE okl_api.g_exception_error;
2602: END IF;
2603:
2604: -- calculate total revenue share
2605: FOR x IN get_investors_csr(p_khr_id) LOOP

Line 2613: Okl_Api.set_message(p_app_name => g_app_name,

2609: END LOOP;
2610:
2611: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2612: -- store SQL error message on message stack for caller
2613: Okl_Api.set_message(p_app_name => g_app_name,
2614: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2615: RAISE Okl_Api.G_EXCEPTION_ERROR;
2616: END IF;
2617:

Line 2615: RAISE Okl_Api.G_EXCEPTION_ERROR;

2611: IF l_revenue_share IS NULL OR l_revenue_share = 0 THEN
2612: -- store SQL error message on message stack for caller
2613: Okl_Api.set_message(p_app_name => g_app_name,
2614: p_msg_name => 'OKL_ASC_REV_SHARE_ERROR');
2615: RAISE Okl_Api.G_EXCEPTION_ERROR;
2616: END IF;
2617:
2618: stream_type_purpose := l_interest_income;
2619: /* ankushar , 16-01-2008 Bug 6740000

Line 2709: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2705: ,p_stmv_rec => l_stmv_rec
2706: ,p_selv_tbl => l_selv_tbl
2707: ,x_stmv_rec => x_stmv_rec
2708: ,x_selv_tbl => x_selv_tbl );
2709: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2710: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2711: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2712: RAISE Okl_Api.G_EXCEPTION_ERROR;
2713: END IF;

Line 2710: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2706: ,p_selv_tbl => l_selv_tbl
2707: ,x_stmv_rec => x_stmv_rec
2708: ,x_selv_tbl => x_selv_tbl );
2709: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2710: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2711: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2712: RAISE Okl_Api.G_EXCEPTION_ERROR;
2713: END IF;
2714: END IF;

Line 2711: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2707: ,x_stmv_rec => x_stmv_rec
2708: ,x_selv_tbl => x_selv_tbl );
2709: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2710: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2711: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2712: RAISE Okl_Api.G_EXCEPTION_ERROR;
2713: END IF;
2714: END IF;
2715:

Line 2712: RAISE Okl_Api.G_EXCEPTION_ERROR;

2708: ,x_selv_tbl => x_selv_tbl );
2709: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2710: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2711: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2712: RAISE Okl_Api.G_EXCEPTION_ERROR;
2713: END IF;
2714: END IF;
2715:
2716: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------

Line 2768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2764: ,p_stmv_rec => l_rep_stmv_rec
2765: ,p_selv_tbl => l_rep_selv_tbl
2766: ,x_stmv_rec => x_rep_stmv_rec
2767: ,x_selv_tbl => x_rep_selv_tbl );
2768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2770: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_ERROR;
2772: END IF;

Line 2769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2765: ,p_selv_tbl => l_rep_selv_tbl
2766: ,x_stmv_rec => x_rep_stmv_rec
2767: ,x_selv_tbl => x_rep_selv_tbl );
2768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2770: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_ERROR;
2772: END IF;
2773: END IF;

Line 2770: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2766: ,x_stmv_rec => x_rep_stmv_rec
2767: ,x_selv_tbl => x_rep_selv_tbl );
2768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2770: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_ERROR;
2772: END IF;
2773: END IF;
2774:

Line 2771: RAISE Okl_Api.G_EXCEPTION_ERROR;

2767: ,x_selv_tbl => x_rep_selv_tbl );
2768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2770: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_ERROR;
2772: END IF;
2773: END IF;
2774:
2775: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------

Line 2778: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2774:
2775: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------
2776:
2777: EXCEPTION
2778: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2779: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2780: ,g_pkg_name
2781: ,'OKL_API.G_RET_STS_ERROR'
2782: ,x_msg_count

Line 2779: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2775: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ---------------
2776:
2777: EXCEPTION
2778: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2779: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2780: ,g_pkg_name
2781: ,'OKL_API.G_RET_STS_ERROR'
2782: ,x_msg_count
2783: ,x_msg_data

Line 2781: ,'OKL_API.G_RET_STS_ERROR'

2777: EXCEPTION
2778: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2779: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2780: ,g_pkg_name
2781: ,'OKL_API.G_RET_STS_ERROR'
2782: ,x_msg_count
2783: ,x_msg_data
2784: ,'_PVT');
2785: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2785: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2781: ,'OKL_API.G_RET_STS_ERROR'
2782: ,x_msg_count
2783: ,x_msg_data
2784: ,'_PVT');
2785: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2786: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2787: ,g_pkg_name
2788: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2789: ,x_msg_count

Line 2786: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2782: ,x_msg_count
2783: ,x_msg_data
2784: ,'_PVT');
2785: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2786: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2787: ,g_pkg_name
2788: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2789: ,x_msg_count
2790: ,x_msg_data

Line 2788: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2784: ,'_PVT');
2785: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2786: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2787: ,g_pkg_name
2788: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2789: ,x_msg_count
2790: ,x_msg_data
2791: ,'_PVT');
2792: WHEN OTHERS THEN

Line 2807: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,

2803:
2804: IF strm_csr%ISOPEN THEN
2805: CLOSE strm_csr;
2806: END IF;
2807: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,
2808: G_PKG_NAME,
2809: 'OTHERS',
2810: x_msg_count,
2811: x_msg_data,

Line 2819: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2815: CLOSE securitized_contracts_pend_csr;
2816:
2817: END IF;
2818: END IF;
2819: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2820: x_msg_data => x_msg_data);
2821: x_return_status := l_return_status;
2822:
2823: EXCEPTION

Line 2824: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2820: x_msg_data => x_msg_data);
2821: x_return_status := l_return_status;
2822:
2823: EXCEPTION
2824: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2825: /*
2826: --sechawla 9-mar-09
2827: IF l_sec_rep_method_csr%ISOPEN THEN
2828: CLOSE l_sec_rep_method_csr;

Line 2835: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2831: IF rep_strm_csr%ISOPEN THEN
2832: CLOSE rep_strm_csr;
2833: END IF;
2834:
2835: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2836: ,g_pkg_name
2837: ,'OKL_API.G_RET_STS_ERROR'
2838: ,x_msg_count
2839: ,x_msg_data

Line 2837: ,'OKL_API.G_RET_STS_ERROR'

2833: END IF;
2834:
2835: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2836: ,g_pkg_name
2837: ,'OKL_API.G_RET_STS_ERROR'
2838: ,x_msg_count
2839: ,x_msg_data
2840: ,'_PVT');
2841: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2841: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2837: ,'OKL_API.G_RET_STS_ERROR'
2838: ,x_msg_count
2839: ,x_msg_data
2840: ,'_PVT');
2841: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2842: /* --sechawla 9-mar-09
2843: IF l_sec_rep_method_csr%ISOPEN THEN
2844: CLOSE l_sec_rep_method_csr;
2845: END IF;

Line 2850: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2846: */
2847: IF rep_strm_csr%ISOPEN THEN
2848: CLOSE rep_strm_csr;
2849: END IF;
2850: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2851: ,g_pkg_name
2852: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2853: ,x_msg_count
2854: ,x_msg_data

Line 2852: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2848: CLOSE rep_strm_csr;
2849: END IF;
2850: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2851: ,g_pkg_name
2852: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2853: ,x_msg_count
2854: ,x_msg_data
2855: ,'_PVT');
2856: WHEN OTHERS THEN

Line 2868: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,

2864: */
2865: IF rep_strm_csr%ISOPEN THEN
2866: CLOSE rep_strm_csr;
2867: END IF;
2868: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name,
2869: G_PKG_NAME,
2870: 'OTHERS',
2871: x_msg_count,
2872: x_msg_data,

Line 2908: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;

2904: Added new Stream Type purpose for a Loan product
2905: */
2906: l_inv_interest_income_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR_INTEREST_INCOME';
2907:
2908: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
2909: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2910: l_msg_count NUMBER;
2911: l_msg_data VARCHAR2(2000);
2912: l_deal_type VARCHAR2(2000);

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

2905: */
2906: l_inv_interest_income_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR_INTEREST_INCOME';
2907:
2908: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
2909: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2910: l_msg_count NUMBER;
2911: l_msg_data VARCHAR2(2000);
2912: l_deal_type VARCHAR2(2000);
2913: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

Line 2986: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

2982:
2983: BEGIN
2984:
2985: -- Set save point
2986: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2987: p_pkg_name => G_PKG_NAME,
2988: p_init_msg_list => p_init_msg_list,
2989: l_api_version => l_api_version,
2990: p_api_version => p_api_version,

Line 2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2990: p_api_version => p_api_version,
2991: p_api_type => '_PVT',
2992: x_return_status => l_return_status);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;

Line 2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2991: p_api_type => '_PVT',
2992: x_return_status => l_return_status);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:

Line 2996: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2992: x_return_status => l_return_status);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:
3000: -- validate in parameters

Line 2997: RAISE Okl_Api.G_EXCEPTION_ERROR;

2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:
3000: -- validate in parameters
3001: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN

Line 3001: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN

2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:
3000: -- validate in parameters
3001: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
3002: -- store SQL error message on message stack for caller
3003: Okl_Api.set_message(p_app_name => g_app_name,
3004: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
3005: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 3003: Okl_Api.set_message(p_app_name => g_app_name,

2999:
3000: -- validate in parameters
3001: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
3002: -- store SQL error message on message stack for caller
3003: Okl_Api.set_message(p_app_name => g_app_name,
3004: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
3005: RAISE Okl_Api.G_EXCEPTION_ERROR;
3006: END IF;
3007:

Line 3005: RAISE Okl_Api.G_EXCEPTION_ERROR;

3001: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
3002: -- store SQL error message on message stack for caller
3003: Okl_Api.set_message(p_app_name => g_app_name,
3004: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
3005: RAISE Okl_Api.G_EXCEPTION_ERROR;
3006: END IF;
3007:
3008: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
3009: -- store SQL error message on message stack for caller

Line 3008: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN

3004: p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
3005: RAISE Okl_Api.G_EXCEPTION_ERROR;
3006: END IF;
3007:
3008: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
3009: -- store SQL error message on message stack for caller
3010: Okl_Api.set_message(p_app_name => g_app_name,
3011: p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
3012: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 3010: Okl_Api.set_message(p_app_name => g_app_name,

3006: END IF;
3007:
3008: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
3009: -- store SQL error message on message stack for caller
3010: Okl_Api.set_message(p_app_name => g_app_name,
3011: p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
3012: RAISE Okl_Api.G_EXCEPTION_ERROR;
3013: END IF;
3014:

Line 3012: RAISE Okl_Api.G_EXCEPTION_ERROR;

3008: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
3009: -- store SQL error message on message stack for caller
3010: Okl_Api.set_message(p_app_name => g_app_name,
3011: p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
3012: RAISE Okl_Api.G_EXCEPTION_ERROR;
3013: END IF;
3014:
3015: -- get deal type
3016: OPEN get_deal_type_csr(p_khr_id);

Line 3063: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3059: ,x_msg_count => l_msg_count
3060: ,x_msg_data => l_msg_data
3061: ,p_selv_tbl => l_selv_tbl
3062: ,x_selv_tbl => x_selv_tbl);
3063: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3064: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3065: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3066: RAISE Okl_Api.G_EXCEPTION_ERROR;
3067: END IF;

Line 3064: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3060: ,x_msg_data => l_msg_data
3061: ,p_selv_tbl => l_selv_tbl
3062: ,x_selv_tbl => x_selv_tbl);
3063: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3064: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3065: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3066: RAISE Okl_Api.G_EXCEPTION_ERROR;
3067: END IF;
3068:

Line 3065: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

3061: ,p_selv_tbl => l_selv_tbl
3062: ,x_selv_tbl => x_selv_tbl);
3063: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3064: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3065: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3066: RAISE Okl_Api.G_EXCEPTION_ERROR;
3067: END IF;
3068:
3069: END IF;

Line 3066: RAISE Okl_Api.G_EXCEPTION_ERROR;

3062: ,x_selv_tbl => x_selv_tbl);
3063: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3064: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3065: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3066: RAISE Okl_Api.G_EXCEPTION_ERROR;
3067: END IF;
3068:
3069: END IF;
3070:

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

3080: x_rep_product => lx_rep_product,
3081: x_rep_product_id => lx_rep_product_id,
3082: x_rep_deal_type => lx_rep_deal_type);
3083:
3084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3087: RAISE OKL_API.G_EXCEPTION_ERROR;
3088: END IF;

Line 3085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3081: x_rep_product_id => lx_rep_product_id,
3082: x_rep_deal_type => lx_rep_deal_type);
3083:
3084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3087: RAISE OKL_API.G_EXCEPTION_ERROR;
3088: END IF;
3089:

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

3082: x_rep_deal_type => lx_rep_deal_type);
3083:
3084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3087: RAISE OKL_API.G_EXCEPTION_ERROR;
3088: END IF;
3089:
3090: --Check the secondary_rep_method

Line 3087: RAISE OKL_API.G_EXCEPTION_ERROR;

3083:
3084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3087: RAISE OKL_API.G_EXCEPTION_ERROR;
3088: END IF;
3089:
3090: --Check the secondary_rep_method
3091: OPEN l_sec_rep_method_csr ;

Line 3094: okl_api.set_message(p_app_name => g_app_name,

3090: --Check the secondary_rep_method
3091: OPEN l_sec_rep_method_csr ;
3092: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
3093: IF l_sec_rep_method_csr%NOTFOUND THEN
3094: okl_api.set_message(p_app_name => g_app_name,
3095: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
3096: );
3097: RAISE okl_api.g_exception_error;
3098: END IF;

Line 3097: RAISE okl_api.g_exception_error;

3093: IF l_sec_rep_method_csr%NOTFOUND THEN
3094: okl_api.set_message(p_app_name => g_app_name,
3095: p_msg_name => 'OKL_NO_SEC_REP_METHOD' --> seed this ''Secondary rep method cursor did not return any records''
3096: );
3097: RAISE okl_api.g_exception_error;
3098: END IF;
3099: CLOSE l_sec_rep_method_csr ;
3100:
3101: IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN

Line 3137: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3133: ,x_msg_data => l_msg_data
3134: ,p_selv_tbl => l_rep_selv_tbl
3135: ,x_selv_tbl => x_rep_selv_tbl);
3136:
3137: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3140: RAISE Okl_Api.G_EXCEPTION_ERROR;
3141: END IF;

Line 3138: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3134: ,p_selv_tbl => l_rep_selv_tbl
3135: ,x_selv_tbl => x_rep_selv_tbl);
3136:
3137: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3140: RAISE Okl_Api.G_EXCEPTION_ERROR;
3141: END IF;
3142:

Line 3139: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

3135: ,x_selv_tbl => x_rep_selv_tbl);
3136:
3137: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3140: RAISE Okl_Api.G_EXCEPTION_ERROR;
3141: END IF;
3142:
3143: END IF;

Line 3140: RAISE Okl_Api.G_EXCEPTION_ERROR;

3136:
3137: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
3140: RAISE Okl_Api.G_EXCEPTION_ERROR;
3141: END IF;
3142:
3143: END IF;
3144:

Line 3151: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3147:
3148: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------
3149:
3150:
3151: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3152: x_msg_data => x_msg_data);
3153: x_return_status := l_return_status;
3154:
3155: EXCEPTION

Line 3156: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3152: x_msg_data => x_msg_data);
3153: x_return_status := l_return_status;
3154:
3155: EXCEPTION
3156: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3157:
3158: --sechawla 10-mar-09 MG Impact
3159: IF rep_non_accrued_streams_csr%ISOPEN THEN
3160: CLOSE rep_non_accrued_streams_csr;

Line 3167: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

3163: IF l_sec_rep_method_csr%ISOPEN THEN
3164: CLOSE l_sec_rep_method_csr;
3165: END IF;
3166:
3167: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
3168: ,g_pkg_name
3169: ,'OKL_API.G_RET_STS_ERROR'
3170: ,x_msg_count
3171: ,x_msg_data

Line 3169: ,'OKL_API.G_RET_STS_ERROR'

3165: END IF;
3166:
3167: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
3168: ,g_pkg_name
3169: ,'OKL_API.G_RET_STS_ERROR'
3170: ,x_msg_count
3171: ,x_msg_data
3172: ,'_PVT');
3173: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3173: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3169: ,'OKL_API.G_RET_STS_ERROR'
3170: ,x_msg_count
3171: ,x_msg_data
3172: ,'_PVT');
3173: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3174:
3175: --sechawla 10-mar-09 MG Impact
3176: IF rep_non_accrued_streams_csr%ISOPEN THEN
3177: CLOSE rep_non_accrued_streams_csr;

Line 3183: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

3179:
3180: IF l_sec_rep_method_csr%ISOPEN THEN
3181: CLOSE l_sec_rep_method_csr;
3182: END IF;
3183: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
3184: ,g_pkg_name
3185: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3186: ,x_msg_count
3187: ,x_msg_data

Line 3185: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

3181: CLOSE l_sec_rep_method_csr;
3182: END IF;
3183: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
3184: ,g_pkg_name
3185: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3186: ,x_msg_count
3187: ,x_msg_data
3188: ,'_PVT');
3189: WHEN OTHERS THEN

Line 3203: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

3199: IF l_sec_rep_method_csr%ISOPEN THEN
3200: CLOSE l_sec_rep_method_csr;
3201: END IF;
3202:
3203: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
3204: (l_api_name,
3205: G_PKG_NAME,
3206: 'OTHERS',
3207: x_msg_count,

Line 3215: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3211: END CANCEL_STREAMS;
3212: /*Commented as T_A requirement has changed
3213: PROCEDURE Create_Adjustment_Streams(
3214: p_api_version IN NUMBER
3215: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3216: ,x_return_status OUT NOCOPY VARCHAR2
3217: ,x_msg_count OUT NOCOPY NUMBER
3218: ,x_msg_data OUT NOCOPY VARCHAR2
3219: ,p_contract_id IN NUMBER

Line 3225: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3221: ,p_adjustment_date IN DATE) IS
3222: */
3223: PROCEDURE Get_Accrual_Adjustment(
3224: p_api_version IN NUMBER
3225: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3226: ,x_return_status OUT NOCOPY VARCHAR2
3227: ,x_msg_count OUT NOCOPY NUMBER
3228: ,x_msg_data OUT NOCOPY VARCHAR2
3229: ,p_contract_id IN NUMBER

Line 3492: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;

3488: l_exp_bill_amt NUMBER := 0;
3489:
3490: l_api_version CONSTANT NUMBER := 1.0;
3491: l_api_name CONSTANT VARCHAR2(30) := 'GET_ACCRUAL_ADJUSTMENT';
3492: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
3493: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3494: l_msg_count NUMBER;
3495: l_msg_data VARCHAR2(2000);
3496:

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

3489:
3490: l_api_version CONSTANT NUMBER := 1.0;
3491: l_api_name CONSTANT VARCHAR2(30) := 'GET_ACCRUAL_ADJUSTMENT';
3492: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
3493: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3494: l_msg_count NUMBER;
3495: l_msg_data VARCHAR2(2000);
3496:
3497:

Line 3500: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3496:
3497:
3498:
3499: BEGIN
3500: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3501: -- Call start_activity to create savepoint, check compatibility
3502: -- and initialize message list
3503: x_return_status := OKL_API.START_ACTIVITY (
3504: l_api_name

Line 3503: x_return_status := OKL_API.START_ACTIVITY (

3499: BEGIN
3500: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3501: -- Call start_activity to create savepoint, check compatibility
3502: -- and initialize message list
3503: x_return_status := OKL_API.START_ACTIVITY (
3504: l_api_name
3505: ,p_init_msg_list
3506: ,'_PVT'
3507: ,x_return_status);

Line 3509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3505: ,p_init_msg_list
3506: ,'_PVT'
3507: ,x_return_status);
3508: -- Check if activity started successfully
3509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3512: RAISE OKL_API.G_EXCEPTION_ERROR;
3513: END IF;

Line 3510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3506: ,'_PVT'
3507: ,x_return_status);
3508: -- Check if activity started successfully
3509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3512: RAISE OKL_API.G_EXCEPTION_ERROR;
3513: END IF;
3514:

Line 3511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3507: ,x_return_status);
3508: -- Check if activity started successfully
3509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3512: RAISE OKL_API.G_EXCEPTION_ERROR;
3513: END IF;
3514:
3515: -- Get the stream marked for accrual at product level

Line 3512: RAISE OKL_API.G_EXCEPTION_ERROR;

3508: -- Check if activity started successfully
3509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3512: RAISE OKL_API.G_EXCEPTION_ERROR;
3513: END IF;
3514:
3515: -- Get the stream marked for accrual at product level
3516: FOR l_pdt_accrual_rec IN l_pdt_accrual_csr(p_contract_id) LOOP

Line 3942: OKL_API.END_ACTIVITY (x_msg_count,

3938:
3939: END LOOP;
3940: END IF;
3941: --NULL;
3942: OKL_API.END_ACTIVITY (x_msg_count,
3943: x_msg_data );
3944: EXCEPTION
3945: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3946: IF l_line_rec_csr%ISOPEN THEN

Line 3945: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3941: --NULL;
3942: OKL_API.END_ACTIVITY (x_msg_count,
3943: x_msg_data );
3944: EXCEPTION
3945: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3946: IF l_line_rec_csr%ISOPEN THEN
3947: CLOSE l_line_rec_csr;
3948: END IF;
3949: IF l_strm_for_line_csr%ISOPEN THEN

Line 3973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3969: END IF;
3970: IF l_pdt_accrual_csr%ISOPEN THEN
3971: CLOSE l_pdt_accrual_csr;
3972: END IF;
3973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3974: l_api_name,
3975: G_PKG_NAME,
3976: 'OKL_API.G_RET_STS_ERROR',
3977: x_msg_count,

Line 3976: 'OKL_API.G_RET_STS_ERROR',

3972: END IF;
3973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3974: l_api_name,
3975: G_PKG_NAME,
3976: 'OKL_API.G_RET_STS_ERROR',
3977: x_msg_count,
3978: x_msg_data,
3979: '_PVT');
3980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3976: 'OKL_API.G_RET_STS_ERROR',
3977: x_msg_count,
3978: x_msg_data,
3979: '_PVT');
3980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3981: IF l_line_rec_csr%ISOPEN THEN
3982: CLOSE l_line_rec_csr;
3983: END IF;
3984: IF l_strm_for_line_csr%ISOPEN THEN

Line 4008: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

4004: END IF;
4005: IF l_pdt_accrual_csr%ISOPEN THEN
4006: CLOSE l_pdt_accrual_csr;
4007: END IF;
4008: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4009: l_api_name,
4010: G_PKG_NAME,
4011: 'OKL_API.G_RET_STS_UNEXP_ERROR',
4012: x_msg_count,

Line 4011: 'OKL_API.G_RET_STS_UNEXP_ERROR',

4007: END IF;
4008: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4009: l_api_name,
4010: G_PKG_NAME,
4011: 'OKL_API.G_RET_STS_UNEXP_ERROR',
4012: x_msg_count,
4013: x_msg_data,
4014: '_PVT');
4015: WHEN OTHERS THEN

Line 4043: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

4039: END IF;
4040: IF l_pdt_accrual_csr%ISOPEN THEN
4041: CLOSE l_pdt_accrual_csr;
4042: END IF;
4043: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4044: l_api_name,
4045: G_PKG_NAME,
4046: 'OTHERS',
4047: x_msg_count,

Line 4071: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;

4067: l_investor_pre_tax_income CONSTANT VARCHAR2(2000) := 'INVESTOR_PRETAX_INCOME';
4068: l_investor_interest_income CONSTANT VARCHAR2(2000) := 'GENERAL';
4069: l_investor_variable_interest CONSTANT VARCHAR2(2000) := 'INVESTOR_VARIABLE_INTEREST';
4070: l_inv_interest_income_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR_INTEREST_INCOME';
4071: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
4072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4073: l_msg_count NUMBER;
4074: l_msg_data VARCHAR2(2000);
4075: l_deal_type VARCHAR2(2000);

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

4068: l_investor_interest_income CONSTANT VARCHAR2(2000) := 'GENERAL';
4069: l_investor_variable_interest CONSTANT VARCHAR2(2000) := 'INVESTOR_VARIABLE_INTEREST';
4070: l_inv_interest_income_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR_INTEREST_INCOME';
4071: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
4072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4073: l_msg_count NUMBER;
4074: l_msg_data VARCHAR2(2000);
4075: l_deal_type VARCHAR2(2000);
4076: l_sec_rep_method VARCHAR2(30);

Line 4213: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

4209: AND ste.date_billed IS NULL ;
4210:
4211: BEGIN
4212: -- Set save point
4213: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
4214: p_pkg_name => G_PKG_NAME,
4215: p_init_msg_list => p_init_msg_list,
4216: l_api_version => l_api_version,
4217: p_api_version => p_api_version,

Line 4220: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4216: l_api_version => l_api_version,
4217: p_api_version => p_api_version,
4218: p_api_type => '_PVT',
4219: x_return_status => l_return_status);
4220: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4223: RAISE Okl_Api.G_EXCEPTION_ERROR;
4224: END IF;

Line 4221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

4217: p_api_version => p_api_version,
4218: p_api_type => '_PVT',
4219: x_return_status => l_return_status);
4220: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4223: RAISE Okl_Api.G_EXCEPTION_ERROR;
4224: END IF;
4225:

Line 4222: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

4218: p_api_type => '_PVT',
4219: x_return_status => l_return_status);
4220: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4223: RAISE Okl_Api.G_EXCEPTION_ERROR;
4224: END IF;
4225:
4226: -- validate in parameters

Line 4223: RAISE Okl_Api.G_EXCEPTION_ERROR;

4219: x_return_status => l_return_status);
4220: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4223: RAISE Okl_Api.G_EXCEPTION_ERROR;
4224: END IF;
4225:
4226: -- validate in parameters
4227: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN

Line 4227: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN

4223: RAISE Okl_Api.G_EXCEPTION_ERROR;
4224: END IF;
4225:
4226: -- validate in parameters
4227: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
4228: -- store SQL error message on message stack for caller
4229: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
4230: RAISE Okl_Api.G_EXCEPTION_ERROR;
4231: END IF;

Line 4229: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KHR_ID_ERROR');

4225:
4226: -- validate in parameters
4227: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
4228: -- store SQL error message on message stack for caller
4229: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
4230: RAISE Okl_Api.G_EXCEPTION_ERROR;
4231: END IF;
4232:
4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN

Line 4230: RAISE Okl_Api.G_EXCEPTION_ERROR;

4226: -- validate in parameters
4227: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
4228: -- store SQL error message on message stack for caller
4229: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
4230: RAISE Okl_Api.G_EXCEPTION_ERROR;
4231: END IF;
4232:
4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
4234: -- store SQL error message on message stack for caller

Line 4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN

4229: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KHR_ID_ERROR');
4230: RAISE Okl_Api.G_EXCEPTION_ERROR;
4231: END IF;
4232:
4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
4234: -- store SQL error message on message stack for caller
4235: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
4236: RAISE Okl_Api.G_EXCEPTION_ERROR;
4237: END IF;

Line 4235: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');

4231: END IF;
4232:
4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
4234: -- store SQL error message on message stack for caller
4235: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
4236: RAISE Okl_Api.G_EXCEPTION_ERROR;
4237: END IF;
4238:
4239:

Line 4236: RAISE Okl_Api.G_EXCEPTION_ERROR;

4232:
4233: IF p_cancel_date IS NULL OR p_cancel_date = OKL_API.G_MISS_DATE THEN
4234: -- store SQL error message on message stack for caller
4235: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_CANCEL_DATE_ERROR');
4236: RAISE Okl_Api.G_EXCEPTION_ERROR;
4237: END IF;
4238:
4239:
4240: OPEN get_kle_id_pend_csr(p_khr_id);

Line 4244: IF l_kle_id IS NULL OR l_kle_id = OKL_API.G_MISS_NUM THEN

4240: OPEN get_kle_id_pend_csr(p_khr_id);
4241: FETCH get_kle_id_pend_csr INTO l_kle_id, l_start_date;
4242: CLOSE get_kle_id_pend_csr;
4243:
4244: IF l_kle_id IS NULL OR l_kle_id = OKL_API.G_MISS_NUM THEN
4245: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KLE_ID_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);
4246: RAISE OKL_API.G_EXCEPTION_ERROR;
4247: END IF;
4248:

Line 4245: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KLE_ID_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);

4241: FETCH get_kle_id_pend_csr INTO l_kle_id, l_start_date;
4242: CLOSE get_kle_id_pend_csr;
4243:
4244: IF l_kle_id IS NULL OR l_kle_id = OKL_API.G_MISS_NUM THEN
4245: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KLE_ID_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);
4246: RAISE OKL_API.G_EXCEPTION_ERROR;
4247: END IF;
4248:
4249: OPEN get_adv_arr_csr(p_khr_id, l_kle_id);

Line 4246: RAISE OKL_API.G_EXCEPTION_ERROR;

4242: CLOSE get_kle_id_pend_csr;
4243:
4244: IF l_kle_id IS NULL OR l_kle_id = OKL_API.G_MISS_NUM THEN
4245: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_KLE_ID_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);
4246: RAISE OKL_API.G_EXCEPTION_ERROR;
4247: END IF;
4248:
4249: OPEN get_adv_arr_csr(p_khr_id, l_kle_id);
4250: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;

Line 4254: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_FREQUENCY_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);

4250: FETCH get_adv_arr_csr INTO l_arrears, l_frequency;
4251: CLOSE get_adv_arr_csr;
4252:
4253: IF l_frequency IS NULL THEN
4254: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_FREQUENCY_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);
4255: RAISE OKL_API.G_EXCEPTION_ERROR;
4256: END IF;
4257:
4258: -- get the next billable stream

Line 4255: RAISE OKL_API.G_EXCEPTION_ERROR;

4251: CLOSE get_adv_arr_csr;
4252:
4253: IF l_frequency IS NULL THEN
4254: Okl_Api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_ASC_FREQUENCY_ERROR', p_token1 => g_contract_number_token, p_token1_value => null);
4255: RAISE OKL_API.G_EXCEPTION_ERROR;
4256: END IF;
4257:
4258: -- get the next billable stream
4259: OPEN get_ear_billable_stream_csr (p_khr_id);

Line 4262: RAISE okl_api.g_exception_error;

4258: -- get the next billable stream
4259: OPEN get_ear_billable_stream_csr (p_khr_id);
4260: FETCH get_ear_billable_stream_csr INTO l_ear_stm_date;
4261: IF get_ear_billable_stream_csr%NOTFOUND then
4262: RAISE okl_api.g_exception_error;
4263: END IF;
4264: CLOSE get_ear_billable_stream_csr;
4265:
4266:

Line 4305: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4301: x_msg_count => l_msg_count ,
4302: x_msg_data => l_msg_data ,
4303: p_selv_tbl => l_selv_tbl);
4304:
4305: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4308: RAISE Okl_Api.G_EXCEPTION_ERROR;
4309: END IF;

Line 4306: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

4302: x_msg_data => l_msg_data ,
4303: p_selv_tbl => l_selv_tbl);
4304:
4305: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4308: RAISE Okl_Api.G_EXCEPTION_ERROR;
4309: END IF;
4310: END IF;

Line 4307: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

4303: p_selv_tbl => l_selv_tbl);
4304:
4305: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4308: RAISE Okl_Api.G_EXCEPTION_ERROR;
4309: END IF;
4310: END IF;
4311:

Line 4308: RAISE Okl_Api.G_EXCEPTION_ERROR;

4304:
4305: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4308: RAISE Okl_Api.G_EXCEPTION_ERROR;
4309: END IF;
4310: END IF;
4311:
4312: --Cancel streams (update accrual flag) on reporting streams as well

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

4320: x_rep_product => lx_rep_product,
4321: x_rep_product_id => lx_rep_product_id,
4322: x_rep_deal_type => lx_rep_deal_type);
4323:
4324: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4325: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4326: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4327: RAISE OKL_API.G_EXCEPTION_ERROR;
4328: END IF;

Line 4325: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4321: x_rep_product_id => lx_rep_product_id,
4322: x_rep_deal_type => lx_rep_deal_type);
4323:
4324: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4325: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4326: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4327: RAISE OKL_API.G_EXCEPTION_ERROR;
4328: END IF;
4329:

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

4322: x_rep_deal_type => lx_rep_deal_type);
4323:
4324: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4325: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4326: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4327: RAISE OKL_API.G_EXCEPTION_ERROR;
4328: END IF;
4329:
4330: --Check the secondary_rep_method

Line 4327: RAISE OKL_API.G_EXCEPTION_ERROR;

4323:
4324: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4325: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4326: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4327: RAISE OKL_API.G_EXCEPTION_ERROR;
4328: END IF;
4329:
4330: --Check the secondary_rep_method
4331: OPEN l_sec_rep_method_csr ;

Line 4334: okl_api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_NO_SEC_REP_METHOD' );

4330: --Check the secondary_rep_method
4331: OPEN l_sec_rep_method_csr ;
4332: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
4333: IF l_sec_rep_method_csr%NOTFOUND THEN
4334: okl_api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_NO_SEC_REP_METHOD' );
4335: RAISE okl_api.g_exception_error;
4336: END IF;
4337: CLOSE l_sec_rep_method_csr ;
4338:

Line 4335: RAISE okl_api.g_exception_error;

4331: OPEN l_sec_rep_method_csr ;
4332: FETCH l_sec_rep_method_csr INTO l_sec_rep_method;
4333: IF l_sec_rep_method_csr%NOTFOUND THEN
4334: okl_api.set_message(p_app_name => g_app_name, p_msg_name => 'OKL_NO_SEC_REP_METHOD' );
4335: RAISE okl_api.g_exception_error;
4336: END IF;
4337: CLOSE l_sec_rep_method_csr ;
4338:
4339: IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN

Line 4367: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4363: x_return_status => l_return_status ,
4364: x_msg_count => l_msg_count ,
4365: x_msg_data => l_msg_data ,
4366: p_selv_tbl => l_rep_selv_tbl);
4367: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4368: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4369: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4370: RAISE Okl_Api.G_EXCEPTION_ERROR;
4371: END IF;

Line 4368: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

4364: x_msg_count => l_msg_count ,
4365: x_msg_data => l_msg_data ,
4366: p_selv_tbl => l_rep_selv_tbl);
4367: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4368: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4369: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4370: RAISE Okl_Api.G_EXCEPTION_ERROR;
4371: END IF;
4372: END IF;

Line 4369: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

4365: x_msg_data => l_msg_data ,
4366: p_selv_tbl => l_rep_selv_tbl);
4367: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4368: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4369: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4370: RAISE Okl_Api.G_EXCEPTION_ERROR;
4371: END IF;
4372: END IF;
4373: END IF;

Line 4370: RAISE Okl_Api.G_EXCEPTION_ERROR;

4366: p_selv_tbl => l_rep_selv_tbl);
4367: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4368: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4369: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
4370: RAISE Okl_Api.G_EXCEPTION_ERROR;
4371: END IF;
4372: END IF;
4373: END IF;
4374:

Line 4375: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

4371: END IF;
4372: END IF;
4373: END IF;
4374:
4375: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
4376: x_return_status := l_return_status;
4377:
4378: EXCEPTION
4379: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 4379: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

4375: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
4376: x_return_status := l_return_status;
4377:
4378: EXCEPTION
4379: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
4380: --sechawla 10-mar-09 MG Impact
4381: IF rep_non_accrued_streams_csr%ISOPEN THEN
4382: CLOSE rep_non_accrued_streams_csr;
4383: END IF;

Line 4394: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name ,g_pkg_name ,'OKL_API.G_RET_STS_ERROR' ,x_msg_count ,x_msg_data ,'_PVT');

4390: IF get_adv_arr_csr%ISOPEN THEN
4391: CLOSE get_adv_arr_csr;
4392: END IF;
4393:
4394: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name ,g_pkg_name ,'OKL_API.G_RET_STS_ERROR' ,x_msg_count ,x_msg_data ,'_PVT');
4395: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
4396: --sechawla 10-mar-09 MG Impact
4397: IF rep_non_accrued_streams_csr%ISOPEN THEN
4398: CLOSE rep_non_accrued_streams_csr;

Line 4395: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

4391: CLOSE get_adv_arr_csr;
4392: END IF;
4393:
4394: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name ,g_pkg_name ,'OKL_API.G_RET_STS_ERROR' ,x_msg_count ,x_msg_data ,'_PVT');
4395: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
4396: --sechawla 10-mar-09 MG Impact
4397: IF rep_non_accrued_streams_csr%ISOPEN THEN
4398: CLOSE rep_non_accrued_streams_csr;
4399: END IF;

Line 4403: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name ,g_pkg_name ,'OKL_API.G_RET_STS_UNEXP_ERROR' ,x_msg_count ,x_msg_data ,'_PVT');

4399: END IF;
4400: IF l_sec_rep_method_csr%ISOPEN THEN
4401: CLOSE l_sec_rep_method_csr;
4402: END IF;
4403: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name ,g_pkg_name ,'OKL_API.G_RET_STS_UNEXP_ERROR' ,x_msg_count ,x_msg_data ,'_PVT');
4404: WHEN OTHERS THEN
4405: IF get_deal_type_csr%ISOPEN THEN
4406: CLOSE get_deal_type_csr;
4407: END IF;

Line 4415: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name, G_PKG_NAME, 'OTHERS', x_msg_count, x_msg_data, '_PVT');

4411: END IF;
4412: IF l_sec_rep_method_csr%ISOPEN THEN
4413: CLOSE l_sec_rep_method_csr;
4414: END IF;
4415: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS (l_api_name, G_PKG_NAME, 'OTHERS', x_msg_count, x_msg_data, '_PVT');
4416: END delete_STREAMS;
4417: -- VG---
4418:
4419: