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

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

22397: x_trans_status OUT NOCOPY VARCHAR2) AS
22398:
22399: l_api_name CONSTANT VARCHAR2(30) := 'MAP_AND_GEN_STREAMS';
22400: l_api_version CONSTANT NUMBER := 1;
22401: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22402: l_fnd_rec fnd_lookups_csr%ROWTYPE;
22403: lv_stream VARCHAR2(200) := null;
22404:
22405: l_isStrmGenAllowed BOOLEAN := TRUE;

Line 22537: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

22533: p_rulv_rec => l_rulv_rec );
22534:
22535:
22536: -- check if activity started successfully
22537: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22538: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22539: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22540: raise OKC_API.G_EXCEPTION_ERROR;
22541: End If;

Line 22538: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22534:
22535:
22536: -- check if activity started successfully
22537: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22538: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22539: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22540: raise OKC_API.G_EXCEPTION_ERROR;
22541: End If;
22542:

Line 22539: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

22535:
22536: -- check if activity started successfully
22537: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22538: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22539: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22540: raise OKC_API.G_EXCEPTION_ERROR;
22541: End If;
22542:
22543: END LOOP;

Line 22540: raise OKC_API.G_EXCEPTION_ERROR;

22536: -- check if activity started successfully
22537: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22538: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22539: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22540: raise OKC_API.G_EXCEPTION_ERROR;
22541: End If;
22542:
22543: END LOOP;
22544:

Line 22826: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

22822:
22823:
22824: Procedure generate_internal_streams(
22825: p_api_version IN NUMBER,
22826: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
22827: p_chr_id IN NUMBER,
22828: p_line_id IN NUMBER,
22829: x_return_status OUT NOCOPY VARCHAR2,
22830: x_msg_count OUT NOCOPY NUMBER,

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

22831: x_msg_data OUT NOCOPY VARCHAR2) IS
22832:
22833: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAMS';
22834: l_api_version CONSTANT NUMBER := 1.0;
22835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22836:
22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 22895: x_return_status := OKC_API.START_ACTIVITY(

22891: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
22892:
22893: BEGIN
22894:
22895: x_return_status := OKC_API.START_ACTIVITY(
22896: p_api_name => l_api_name,
22897: p_pkg_name => g_pkg_name,
22898: p_init_msg_list => p_init_msg_list,
22899: l_api_version => l_api_version,

Line 22905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

22901: p_api_type => G_API_TYPE,
22902: x_return_status => x_return_status);
22903:
22904: -- check if activity started successfully
22905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22907: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22908: raise OKC_API.G_EXCEPTION_ERROR;
22909: End If;

Line 22906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22902: x_return_status => x_return_status);
22903:
22904: -- check if activity started successfully
22905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22907: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22908: raise OKC_API.G_EXCEPTION_ERROR;
22909: End If;
22910:

Line 22907: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

22903:
22904: -- check if activity started successfully
22905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22907: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22908: raise OKC_API.G_EXCEPTION_ERROR;
22909: End If;
22910:
22911:

Line 22908: raise OKC_API.G_EXCEPTION_ERROR;

22904: -- check if activity started successfully
22905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22907: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22908: raise OKC_API.G_EXCEPTION_ERROR;
22909: End If;
22910:
22911:
22912: FOR l_nullrl_rec in l_nullrl_csr ( 'LALEVL', 'LASLL', p_chr_id, p_line_id )

Line 22927: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

22923: p_rulv_rec => l_rulv_rec );
22924:
22925:
22926: -- check if activity started successfully
22927: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22928: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22929: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22930: raise OKC_API.G_EXCEPTION_ERROR;
22931: End If;

Line 22928: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22924:
22925:
22926: -- check if activity started successfully
22927: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22928: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22929: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22930: raise OKC_API.G_EXCEPTION_ERROR;
22931: End If;
22932:

Line 22929: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

22925:
22926: -- check if activity started successfully
22927: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22928: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22929: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22930: raise OKC_API.G_EXCEPTION_ERROR;
22931: End If;
22932:
22933: END LOOP;

Line 22930: raise OKC_API.G_EXCEPTION_ERROR;

22926: -- check if activity started successfully
22927: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22928: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22929: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22930: raise OKC_API.G_EXCEPTION_ERROR;
22931: End If;
22932:
22933: END LOOP;
22934:

Line 22950: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

22946: p_rulv_rec => l_rulv_rec );
22947:
22948:
22949: -- check if activity started successfully
22950: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22951: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22952: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22953: raise OKC_API.G_EXCEPTION_ERROR;
22954: End If;

Line 22951: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22947:
22948:
22949: -- check if activity started successfully
22950: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22951: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22952: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22953: raise OKC_API.G_EXCEPTION_ERROR;
22954: End If;
22955:

Line 22952: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

22948:
22949: -- check if activity started successfully
22950: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22951: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22952: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22953: raise OKC_API.G_EXCEPTION_ERROR;
22954: End If;
22955:
22956: END LOOP;

Line 22953: raise OKC_API.G_EXCEPTION_ERROR;

22949: -- check if activity started successfully
22950: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
22951: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22952: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
22953: raise OKC_API.G_EXCEPTION_ERROR;
22954: End If;
22955:
22956: END LOOP;
22957:

Line 22961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22957:
22958: OPEN l_rl_csr ( 'LALEVL', 'LASLH', p_chr_id, p_line_id );
22959: FETCH l_rl_csr INTO l_rl_rec1;
22960: If ( l_rl_csr%NOTFOUND ) Then
22961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22962: End If;
22963: CLOSE l_rl_csr;
22964:
22965: l_stmv_rec.sty_id := TO_NUMBER(l_rl_rec1.object1_id1);

Line 23021: when OKC_API.G_EXCEPTION_ERROR then

23017:
23018: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
23019:
23020: Exception
23021: when OKC_API.G_EXCEPTION_ERROR then
23022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23023: p_api_name => l_api_name,
23024: p_pkg_name => g_pkg_name,
23025: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 23022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23018: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
23019:
23020: Exception
23021: when OKC_API.G_EXCEPTION_ERROR then
23022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23023: p_api_name => l_api_name,
23024: p_pkg_name => g_pkg_name,
23025: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
23026: x_msg_count => x_msg_count,

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

23021: when OKC_API.G_EXCEPTION_ERROR then
23022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23023: p_api_name => l_api_name,
23024: p_pkg_name => g_pkg_name,
23025: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
23026: x_msg_count => x_msg_count,
23027: x_msg_data => x_msg_data,
23028: p_api_type => g_api_type);
23029:

Line 23030: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

23026: x_msg_count => x_msg_count,
23027: x_msg_data => x_msg_data,
23028: p_api_type => g_api_type);
23029:
23030: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23031: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23032: p_api_name => l_api_name,
23033: p_pkg_name => g_pkg_name,
23034: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 23031: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23027: x_msg_data => x_msg_data,
23028: p_api_type => g_api_type);
23029:
23030: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23031: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23032: p_api_name => l_api_name,
23033: p_pkg_name => g_pkg_name,
23034: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
23035: x_msg_count => x_msg_count,

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

23030: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23031: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23032: p_api_name => l_api_name,
23033: p_pkg_name => g_pkg_name,
23034: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
23035: x_msg_count => x_msg_count,
23036: x_msg_data => x_msg_data,
23037: p_api_type => g_api_type);
23038:

Line 23040: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23036: x_msg_data => x_msg_data,
23037: p_api_type => g_api_type);
23038:
23039: when OTHERS then
23040: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23041: p_api_name => l_api_name,
23042: p_pkg_name => g_pkg_name,
23043: p_exc_name => 'OTHERS',
23044: x_msg_count => x_msg_count,

Line 23053: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

23049: END generate_internal_streams;
23050:
23051: Procedure generate_internal_streams(
23052: p_api_version IN NUMBER,
23053: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
23054: p_chr_id IN NUMBER,
23055: x_return_status OUT NOCOPY VARCHAR2,
23056: x_msg_count OUT NOCOPY NUMBER,
23057: x_msg_data OUT NOCOPY VARCHAR2) IS

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

23057: x_msg_data OUT NOCOPY VARCHAR2) IS
23058:
23059: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAMS';
23060: l_api_version CONSTANT NUMBER := 1.0;
23061: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
23062:
23063: pl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
23064: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
23065: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 23075: l_return_status := OKC_API.START_ACTIVITY(

23071:
23072:
23073: BEGIN
23074:
23075: l_return_status := OKC_API.START_ACTIVITY(
23076: p_api_name => l_api_name,
23077: p_pkg_name => g_pkg_name,
23078: p_init_msg_list => p_init_msg_list,
23079: l_api_version => l_api_version,

Line 23085: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

23081: p_api_type => G_API_TYPE,
23082: x_return_status => l_return_status);
23083:
23084: -- check if activity started successfully
23085: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
23086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23087: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
23088: raise OKC_API.G_EXCEPTION_ERROR;
23089: End If;

Line 23086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

23082: x_return_status => l_return_status);
23083:
23084: -- check if activity started successfully
23085: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
23086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23087: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
23088: raise OKC_API.G_EXCEPTION_ERROR;
23089: End If;
23090: okl_contract_status_pub.update_contract_status(

Line 23087: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then

23083:
23084: -- check if activity started successfully
23085: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
23086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23087: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
23088: raise OKC_API.G_EXCEPTION_ERROR;
23089: End If;
23090: okl_contract_status_pub.update_contract_status(
23091: l_api_version,

Line 23088: raise OKC_API.G_EXCEPTION_ERROR;

23084: -- check if activity started successfully
23085: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
23086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23087: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
23088: raise OKC_API.G_EXCEPTION_ERROR;
23089: End If;
23090: okl_contract_status_pub.update_contract_status(
23091: l_api_version,
23092: p_init_msg_list,

Line 23123: when OKC_API.G_EXCEPTION_ERROR then

23119:
23120: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
23121:
23122: Exception
23123: when OKC_API.G_EXCEPTION_ERROR then
23124: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23125: p_api_name => l_api_name,
23126: p_pkg_name => g_pkg_name,
23127: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 23124: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23120: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
23121:
23122: Exception
23123: when OKC_API.G_EXCEPTION_ERROR then
23124: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23125: p_api_name => l_api_name,
23126: p_pkg_name => g_pkg_name,
23127: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
23128: x_msg_count => x_msg_count,

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

23123: when OKC_API.G_EXCEPTION_ERROR then
23124: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23125: p_api_name => l_api_name,
23126: p_pkg_name => g_pkg_name,
23127: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
23128: x_msg_count => x_msg_count,
23129: x_msg_data => x_msg_data,
23130: p_api_type => g_api_type);
23131:

Line 23132: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

23128: x_msg_count => x_msg_count,
23129: x_msg_data => x_msg_data,
23130: p_api_type => g_api_type);
23131:
23132: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23134: p_api_name => l_api_name,
23135: p_pkg_name => g_pkg_name,
23136: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 23133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23129: x_msg_data => x_msg_data,
23130: p_api_type => g_api_type);
23131:
23132: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23134: p_api_name => l_api_name,
23135: p_pkg_name => g_pkg_name,
23136: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
23137: x_msg_count => x_msg_count,

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

23132: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
23133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23134: p_api_name => l_api_name,
23135: p_pkg_name => g_pkg_name,
23136: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
23137: x_msg_count => x_msg_count,
23138: x_msg_data => x_msg_data,
23139: p_api_type => g_api_type);
23140:

Line 23142: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

23138: x_msg_data => x_msg_data,
23139: p_api_type => g_api_type);
23140:
23141: when OTHERS then
23142: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
23143: p_api_name => l_api_name,
23144: p_pkg_name => g_pkg_name,
23145: p_exc_name => 'OTHERS',
23146: x_msg_count => x_msg_count,

Line 23155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

23151: END generate_internal_streams;
23152:
23153: PROCEDURE GEN_INTR_EXTR_STREAM (
23154: p_api_version IN NUMBER,
23155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
23156: x_return_status OUT NOCOPY VARCHAR2,
23157: x_msg_count OUT NOCOPY NUMBER,
23158: x_msg_data OUT NOCOPY VARCHAR2,
23159: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

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

26525: ,x_rep_trans_status OUT NOCOPY VARCHAR2 )
26526: AS
26527: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_ESG_KHR_FOR_PRB';
26528: l_api_version CONSTANT NUMBER := 1;
26529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
26530: l_init_msg_list VARCHAR2(1) := OKL_API.G_TRUE;
26531:
26532: l_hdr_rec l_hdr_csr%ROWTYPE;
26533: -- Record Structures required for the Lease Contracts