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

Line 570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

566: OPEN orig_csr(p_chr_id);
567: FETCH orig_csr INTO l_orig_contract_number;
568:
569: IF orig_csr%NOTFOUND THEN
570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: END IF;
572:
573: CLOSE orig_csr;
574: l_new_contract_number := l_orig_contract_number||'-LR'||l_seq_no;

Line 578: p_init_msg_list => OKC_API.G_FALSE,

574: l_new_contract_number := l_orig_contract_number||'-LR'||l_seq_no;
575:
576: okl_copy_contract_pub.copy_lease_contract(
577: p_api_version => 1.0,
578: p_init_msg_list => OKC_API.G_FALSE,
579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data,
582: p_chr_id => p_chr_id,

Line 590: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

586: p_trans_type => 'CRB',
587: x_chr_id => x_chr_id
588: );
589:
590: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
591: RAISE OKC_API.G_EXCEPTION_ERROR;
592: END IF;
593: --
594: -- Update Rebook Contract Status to 'NEW'

Line 591: RAISE OKC_API.G_EXCEPTION_ERROR;

587: x_chr_id => x_chr_id
588: );
589:
590: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
591: RAISE OKC_API.G_EXCEPTION_ERROR;
592: END IF;
593: --
594: -- Update Rebook Contract Status to 'NEW'
595: -- and source to 'OKL_REBOOK'

Line 607: p_restricted_update => OKC_API.G_FALSE,

603: p_init_msg_list => p_init_msg_list,
604: x_return_status => x_return_status,
605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data,
607: p_restricted_update => OKC_API.G_FALSE,
608: p_chrv_rec => l_chrv_rec,
609: p_khrv_rec => l_khrv_rec,
610: x_chrv_rec => x_chrv_rec,
611: x_khrv_rec => x_khrv_rec

Line 615: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

611: x_khrv_rec => x_khrv_rec
612: );
613:
614:
615: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;
618:
619: --**********************************************************

Line 616: RAISE OKC_API.G_EXCEPTION_ERROR;

612: );
613:
614:
615: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;
618:
619: --**********************************************************
620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 622: if p_commit= OKC_API.G_TRUE then

618:
619: --**********************************************************
620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
621: x_msg_data => x_msg_data);
622: if p_commit= OKC_API.G_TRUE then
623: commit;
624: end if;
625:
626: EXCEPTION

Line 627: when OKC_API.G_EXCEPTION_ERROR then

623: commit;
624: end if;
625:
626: EXCEPTION
627: when OKC_API.G_EXCEPTION_ERROR then
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => G_PKG_NAME,
631: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 628: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

624: end if;
625:
626: EXCEPTION
627: when OKC_API.G_EXCEPTION_ERROR then
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => G_PKG_NAME,
631: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count => x_msg_count,

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

627: when OKC_API.G_EXCEPTION_ERROR then
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => G_PKG_NAME,
631: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,
634: p_api_type => '_PVT');
635:

Line 636: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,
634: p_api_type => '_PVT');
635:
636: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => G_PKG_NAME,
640: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 637: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

633: x_msg_data => x_msg_data,
634: p_api_type => '_PVT');
635:
636: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => G_PKG_NAME,
640: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
641: x_msg_count => x_msg_count,

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

636: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => G_PKG_NAME,
640: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
641: x_msg_count => x_msg_count,
642: x_msg_data => x_msg_data,
643: p_api_type => '_PVT');
644:

Line 646: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

642: x_msg_data => x_msg_data,
643: p_api_type => '_PVT');
644:
645: when OTHERS then
646: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
647: p_api_name => l_api_name,
648: p_pkg_name => G_PKG_NAME,
649: p_exc_name => 'OTHERS',
650: x_msg_count => x_msg_count,

Line 678: x_return_status := OKC_API.G_RET_STS_SUCCESS;

674: x_chrv_rec chrv_rec_type;
675:
676: update_failed EXCEPTION;
677: BEGIN
678: x_return_status := OKC_API.G_RET_STS_SUCCESS;
679: l_khrv_rec := get_khrv_rec(
680: p_khr_id => p_working_copy_chr_id,
681: x_return_status => x_return_status
682: );

Line 703: p_init_msg_list => OKC_API.G_FALSE,

699: l_chrv_rec.end_date := p_end_date;
700:
701: okl_contract_pub.update_contract_header(
702: p_api_version => 1.0,
703: p_init_msg_list => OKC_API.G_FALSE,
704: x_return_status => x_return_status,
705: x_msg_count => x_msg_count,
706: x_msg_data => x_msg_data,
707: p_restricted_update => OKC_API.G_FALSE,

Line 707: p_restricted_update => OKC_API.G_FALSE,

703: p_init_msg_list => OKC_API.G_FALSE,
704: x_return_status => x_return_status,
705: x_msg_count => x_msg_count,
706: x_msg_data => x_msg_data,
707: p_restricted_update => OKC_API.G_FALSE,
708: p_chrv_rec => l_chrv_rec,
709: p_khrv_rec => l_khrv_rec,
710: x_chrv_rec => x_chrv_rec,
711: x_khrv_rec => x_khrv_rec

Line 713: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

709: p_khrv_rec => l_khrv_rec,
710: x_chrv_rec => x_chrv_rec,
711: x_khrv_rec => x_khrv_rec
712: );
713: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
714: x_return_status := Okc_Api.G_RET_STS_ERROR;
715: RAISE update_failed;
716: END IF;
717:

Line 714: x_return_status := Okc_Api.G_RET_STS_ERROR;

710: x_chrv_rec => x_chrv_rec,
711: x_khrv_rec => x_khrv_rec
712: );
713: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
714: x_return_status := Okc_Api.G_RET_STS_ERROR;
715: RAISE update_failed;
716: END IF;
717:
718: --END LOOP;

Line 724: x_return_status := OKC_API.G_RET_STS_ERROR;

720: --RETURN;
721:
722: EXCEPTION
723: WHEN update_failed THEN
724: x_return_status := OKC_API.G_RET_STS_ERROR;
725: END update_hdr_info;
726:
727: -------------------------------------------------------------
728: --API to update the residual values for all the assets by a %

Line 805: p_init_msg_list => OKC_API.G_FALSE,

801: END LOOP;
802:
803: okl_contract_pub.update_contract_line(
804: p_api_version => 1.0,
805: p_init_msg_list => OKC_API.G_FALSE,
806: x_return_status => x_return_status,
807: x_msg_count => x_msg_count,
808: x_msg_data => x_msg_data,
809: p_clev_tbl => l_clev_tbl,

Line 1110: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1106: END calculate;
1107:
1108: PROCEDURE update_lrnw_request(
1109: p_api_version IN NUMBER
1110: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1111: ,x_return_status OUT NOCOPY VARCHAR2
1112: ,x_msg_count OUT NOCOPY NUMBER
1113: ,x_msg_data OUT NOCOPY VARCHAR2
1114: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type