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

Line 82: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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;

Line 134: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 135: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 143: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 144: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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;

Line 468: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 477: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 487: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 512: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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;

Line 554: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 555: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 563: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,