78: l_trm_rec TERMS_CONDS_CSR%RowType;
79:
80: l_trm_tbl trm_tbl_type;
81:
82: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
83: l_api_name CONSTANT VARCHAR2(30) := 'GET_SEC_TERMS_CONDITIONS';
84: l_api_version CONSTANT NUMBER := 1.0;
85:
86: i NUMBER := 0;
130: x_msg_data => x_msg_data);
131:
132:
133: EXCEPTION
134: when OKC_API.G_EXCEPTION_ERROR then
135: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
136: p_api_name => l_api_name,
137: p_pkg_name => G_PKG_NAME,
138: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
131:
132:
133: EXCEPTION
134: when OKC_API.G_EXCEPTION_ERROR then
135: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
136: p_api_name => l_api_name,
137: p_pkg_name => G_PKG_NAME,
138: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
139: x_msg_count => x_msg_count,
134: when OKC_API.G_EXCEPTION_ERROR then
135: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
136: p_api_name => l_api_name,
137: p_pkg_name => G_PKG_NAME,
138: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data,
141: p_api_type => G_API_TYPE);
142:
139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data,
141: p_api_type => G_API_TYPE);
142:
143: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
140: x_msg_data => x_msg_data,
141: p_api_type => G_API_TYPE);
142:
143: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
148: x_msg_count => x_msg_count,
143: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data,
150: p_api_type => G_API_TYPE);
151:
149: x_msg_data => x_msg_data,
150: p_api_type => G_API_TYPE);
151:
152: when OTHERS then
153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
154: p_api_name => l_api_name,
155: p_pkg_name => G_PKG_NAME,
156: p_exc_name => 'OTHERS',
157: x_msg_count => x_msg_count,
412: l_trm_rec TERMS_CONDS_CSR%RowType;
413:
414: l_trm_tbl trm_tbl_type;
415:
416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
417: l_api_name CONSTANT VARCHAR2(30) := 'GET_LEASE_TERMS_CONDITIONS';
418: l_api_version CONSTANT NUMBER := 1.0;
419:
420: i NUMBER := 0;
464: x_msg_data => x_msg_data);
465:
466:
467: EXCEPTION
468: when OKC_API.G_EXCEPTION_ERROR then
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
465:
466:
467: EXCEPTION
468: when OKC_API.G_EXCEPTION_ERROR then
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
473: x_msg_count => x_msg_count,
468: when OKC_API.G_EXCEPTION_ERROR then
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data,
475: p_api_type => G_API_TYPE);
476:
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data,
475: p_api_type => G_API_TYPE);
476:
477: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
479: p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
474: x_msg_data => x_msg_data,
475: p_api_type => G_API_TYPE);
476:
477: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
479: p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
482: x_msg_count => x_msg_count,
477: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
479: p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
482: x_msg_count => x_msg_count,
483: x_msg_data => x_msg_data,
484: p_api_type => G_API_TYPE);
485:
483: x_msg_data => x_msg_data,
484: p_api_type => G_API_TYPE);
485:
486: when OTHERS then
487: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
488: p_api_name => l_api_name,
489: p_pkg_name => G_PKG_NAME,
490: p_exc_name => 'OTHERS',
491: x_msg_count => x_msg_count,
508:
509:
510: l_trm_tbl trm_tbl_type;
511:
512: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
513: l_api_name CONSTANT VARCHAR2(30) := 'GET_TERMS_CONDITIONS';
514: l_api_version CONSTANT NUMBER := 1.0;
515:
516: i NUMBER := 0;
550: x_msg_data => x_msg_data);
551:
552:
553: EXCEPTION
554: when OKC_API.G_EXCEPTION_ERROR then
555: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
551:
552:
553: EXCEPTION
554: when OKC_API.G_EXCEPTION_ERROR then
555: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,
554: when OKC_API.G_EXCEPTION_ERROR then
555: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => G_API_TYPE);
562:
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => G_API_TYPE);
562:
563: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
565: p_api_name => l_api_name,
566: p_pkg_name => G_PKG_NAME,
567: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
560: x_msg_data => x_msg_data,
561: p_api_type => G_API_TYPE);
562:
563: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
565: p_api_name => l_api_name,
566: p_pkg_name => G_PKG_NAME,
567: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
568: x_msg_count => x_msg_count,
563: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
565: p_api_name => l_api_name,
566: p_pkg_name => G_PKG_NAME,
567: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data,
570: p_api_type => G_API_TYPE);
571:
569: x_msg_data => x_msg_data,
570: p_api_type => G_API_TYPE);
571:
572: when OTHERS then
573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
574: p_api_name => l_api_name,
575: p_pkg_name => G_PKG_NAME,
576: p_exc_name => 'OTHERS',
577: x_msg_count => x_msg_count,