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 19608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

19604: x_trans_status OUT NOCOPY VARCHAR2) AS
19605:
19606: l_api_name CONSTANT VARCHAR2(30) := 'MAP_AND_GEN_STREAMS';
19607: l_api_version CONSTANT NUMBER := 1;
19608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
19609: l_fnd_rec fnd_lookups_csr%ROWTYPE;
19610: lv_stream VARCHAR2(200) := null;
19611:
19612: l_isStrmGenAllowed BOOLEAN := TRUE;

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

19740: p_rulv_rec => l_rulv_rec );
19741:
19742:
19743: -- check if activity started successfully
19744: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
19745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
19746: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
19747: raise OKC_API.G_EXCEPTION_ERROR;
19748: End If;

Line 19745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

19741:
19742:
19743: -- check if activity started successfully
19744: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
19745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
19746: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
19747: raise OKC_API.G_EXCEPTION_ERROR;
19748: End If;
19749:

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

19742:
19743: -- check if activity started successfully
19744: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
19745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
19746: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
19747: raise OKC_API.G_EXCEPTION_ERROR;
19748: End If;
19749:
19750: END LOOP;

Line 19747: raise OKC_API.G_EXCEPTION_ERROR;

19743: -- check if activity started successfully
19744: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
19745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
19746: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
19747: raise OKC_API.G_EXCEPTION_ERROR;
19748: End If;
19749:
19750: END LOOP;
19751:

Line 20018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

20014:
20015:
20016: Procedure generate_internal_streams(
20017: p_api_version IN NUMBER,
20018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20019: p_chr_id IN NUMBER,
20020: p_line_id IN NUMBER,
20021: x_return_status OUT NOCOPY VARCHAR2,
20022: x_msg_count OUT NOCOPY NUMBER,

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

20023: x_msg_data OUT NOCOPY VARCHAR2) IS
20024:
20025: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAMS';
20026: l_api_version CONSTANT NUMBER := 1.0;
20027: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20028:
20029: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
20030: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
20031: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 20087: x_return_status := OKC_API.START_ACTIVITY(

20083: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
20084:
20085: BEGIN
20086:
20087: x_return_status := OKC_API.START_ACTIVITY(
20088: p_api_name => l_api_name,
20089: p_pkg_name => g_pkg_name,
20090: p_init_msg_list => p_init_msg_list,
20091: l_api_version => l_api_version,

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

20093: p_api_type => G_API_TYPE,
20094: x_return_status => x_return_status);
20095:
20096: -- check if activity started successfully
20097: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20098: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20099: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20100: raise OKC_API.G_EXCEPTION_ERROR;
20101: End If;

Line 20098: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20094: x_return_status => x_return_status);
20095:
20096: -- check if activity started successfully
20097: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20098: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20099: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20100: raise OKC_API.G_EXCEPTION_ERROR;
20101: End If;
20102:

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

20095:
20096: -- check if activity started successfully
20097: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20098: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20099: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20100: raise OKC_API.G_EXCEPTION_ERROR;
20101: End If;
20102:
20103:

Line 20100: raise OKC_API.G_EXCEPTION_ERROR;

20096: -- check if activity started successfully
20097: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20098: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20099: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20100: raise OKC_API.G_EXCEPTION_ERROR;
20101: End If;
20102:
20103:
20104: FOR l_nullrl_rec in l_nullrl_csr ( 'LALEVL', 'LASLL', p_chr_id, p_line_id )

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

20115: p_rulv_rec => l_rulv_rec );
20116:
20117:
20118: -- check if activity started successfully
20119: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20120: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20121: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20122: raise OKC_API.G_EXCEPTION_ERROR;
20123: End If;

Line 20120: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20116:
20117:
20118: -- check if activity started successfully
20119: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20120: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20121: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20122: raise OKC_API.G_EXCEPTION_ERROR;
20123: End If;
20124:

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

20117:
20118: -- check if activity started successfully
20119: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20120: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20121: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20122: raise OKC_API.G_EXCEPTION_ERROR;
20123: End If;
20124:
20125: END LOOP;

Line 20122: raise OKC_API.G_EXCEPTION_ERROR;

20118: -- check if activity started successfully
20119: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20120: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20121: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20122: raise OKC_API.G_EXCEPTION_ERROR;
20123: End If;
20124:
20125: END LOOP;
20126:

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

20138: p_rulv_rec => l_rulv_rec );
20139:
20140:
20141: -- check if activity started successfully
20142: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20143: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20144: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20145: raise OKC_API.G_EXCEPTION_ERROR;
20146: End If;

Line 20143: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20139:
20140:
20141: -- check if activity started successfully
20142: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20143: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20144: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20145: raise OKC_API.G_EXCEPTION_ERROR;
20146: End If;
20147:

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

20140:
20141: -- check if activity started successfully
20142: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20143: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20144: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20145: raise OKC_API.G_EXCEPTION_ERROR;
20146: End If;
20147:
20148: END LOOP;

Line 20145: raise OKC_API.G_EXCEPTION_ERROR;

20141: -- check if activity started successfully
20142: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20143: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20144: ElSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
20145: raise OKC_API.G_EXCEPTION_ERROR;
20146: End If;
20147:
20148: END LOOP;
20149:

Line 20153: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20149:
20150: OPEN l_rl_csr ( 'LALEVL', 'LASLH', p_chr_id, p_line_id );
20151: FETCH l_rl_csr INTO l_rl_rec1;
20152: If ( l_rl_csr%NOTFOUND ) Then
20153: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20154: End If;
20155: CLOSE l_rl_csr;
20156:
20157: l_stmv_rec.sty_id := TO_NUMBER(l_rl_rec1.object1_id1);

Line 20213: when OKC_API.G_EXCEPTION_ERROR then

20209:
20210: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
20211:
20212: Exception
20213: when OKC_API.G_EXCEPTION_ERROR then
20214: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20215: p_api_name => l_api_name,
20216: p_pkg_name => g_pkg_name,
20217: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 20214: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20210: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
20211:
20212: Exception
20213: when OKC_API.G_EXCEPTION_ERROR then
20214: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20215: p_api_name => l_api_name,
20216: p_pkg_name => g_pkg_name,
20217: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
20218: x_msg_count => x_msg_count,

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

20213: when OKC_API.G_EXCEPTION_ERROR then
20214: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20215: p_api_name => l_api_name,
20216: p_pkg_name => g_pkg_name,
20217: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
20218: x_msg_count => x_msg_count,
20219: x_msg_data => x_msg_data,
20220: p_api_type => g_api_type);
20221:

Line 20222: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

20218: x_msg_count => x_msg_count,
20219: x_msg_data => x_msg_data,
20220: p_api_type => g_api_type);
20221:
20222: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20223: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20224: p_api_name => l_api_name,
20225: p_pkg_name => g_pkg_name,
20226: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 20223: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20219: x_msg_data => x_msg_data,
20220: p_api_type => g_api_type);
20221:
20222: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20223: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20224: p_api_name => l_api_name,
20225: p_pkg_name => g_pkg_name,
20226: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
20227: x_msg_count => x_msg_count,

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

20222: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20223: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20224: p_api_name => l_api_name,
20225: p_pkg_name => g_pkg_name,
20226: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
20227: x_msg_count => x_msg_count,
20228: x_msg_data => x_msg_data,
20229: p_api_type => g_api_type);
20230:

Line 20232: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20228: x_msg_data => x_msg_data,
20229: p_api_type => g_api_type);
20230:
20231: when OTHERS then
20232: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20233: p_api_name => l_api_name,
20234: p_pkg_name => g_pkg_name,
20235: p_exc_name => 'OTHERS',
20236: x_msg_count => x_msg_count,

Line 20245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

20241: END generate_internal_streams;
20242:
20243: Procedure generate_internal_streams(
20244: p_api_version IN NUMBER,
20245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20246: p_chr_id IN NUMBER,
20247: x_return_status OUT NOCOPY VARCHAR2,
20248: x_msg_count OUT NOCOPY NUMBER,
20249: x_msg_data OUT NOCOPY VARCHAR2) IS

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

20249: x_msg_data OUT NOCOPY VARCHAR2) IS
20250:
20251: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAMS';
20252: l_api_version CONSTANT NUMBER := 1.0;
20253: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20254:
20255: pl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
20256: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
20257: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 20267: l_return_status := OKC_API.START_ACTIVITY(

20263:
20264:
20265: BEGIN
20266:
20267: l_return_status := OKC_API.START_ACTIVITY(
20268: p_api_name => l_api_name,
20269: p_pkg_name => g_pkg_name,
20270: p_init_msg_list => p_init_msg_list,
20271: l_api_version => l_api_version,

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

20273: p_api_type => G_API_TYPE,
20274: x_return_status => l_return_status);
20275:
20276: -- check if activity started successfully
20277: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20279: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
20280: raise OKC_API.G_EXCEPTION_ERROR;
20281: End If;

Line 20278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20274: x_return_status => l_return_status);
20275:
20276: -- check if activity started successfully
20277: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20279: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
20280: raise OKC_API.G_EXCEPTION_ERROR;
20281: End If;
20282: okl_contract_status_pub.update_contract_status(

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

20275:
20276: -- check if activity started successfully
20277: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20279: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
20280: raise OKC_API.G_EXCEPTION_ERROR;
20281: End If;
20282: okl_contract_status_pub.update_contract_status(
20283: l_api_version,

Line 20280: raise OKC_API.G_EXCEPTION_ERROR;

20276: -- check if activity started successfully
20277: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
20278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
20279: ElSIF (l_return_status = OKC_API.G_RET_STS_ERROR) then
20280: raise OKC_API.G_EXCEPTION_ERROR;
20281: End If;
20282: okl_contract_status_pub.update_contract_status(
20283: l_api_version,
20284: p_init_msg_list,

Line 20315: when OKC_API.G_EXCEPTION_ERROR then

20311:
20312: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
20313:
20314: Exception
20315: when OKC_API.G_EXCEPTION_ERROR then
20316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20317: p_api_name => l_api_name,
20318: p_pkg_name => g_pkg_name,
20319: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 20316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20312: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
20313:
20314: Exception
20315: when OKC_API.G_EXCEPTION_ERROR then
20316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20317: p_api_name => l_api_name,
20318: p_pkg_name => g_pkg_name,
20319: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
20320: x_msg_count => x_msg_count,

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

20315: when OKC_API.G_EXCEPTION_ERROR then
20316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20317: p_api_name => l_api_name,
20318: p_pkg_name => g_pkg_name,
20319: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
20320: x_msg_count => x_msg_count,
20321: x_msg_data => x_msg_data,
20322: p_api_type => g_api_type);
20323:

Line 20324: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

20320: x_msg_count => x_msg_count,
20321: x_msg_data => x_msg_data,
20322: p_api_type => g_api_type);
20323:
20324: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20326: p_api_name => l_api_name,
20327: p_pkg_name => g_pkg_name,
20328: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 20325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20321: x_msg_data => x_msg_data,
20322: p_api_type => g_api_type);
20323:
20324: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20326: p_api_name => l_api_name,
20327: p_pkg_name => g_pkg_name,
20328: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
20329: x_msg_count => x_msg_count,

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

20324: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
20325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20326: p_api_name => l_api_name,
20327: p_pkg_name => g_pkg_name,
20328: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
20329: x_msg_count => x_msg_count,
20330: x_msg_data => x_msg_data,
20331: p_api_type => g_api_type);
20332:

Line 20334: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

20330: x_msg_data => x_msg_data,
20331: p_api_type => g_api_type);
20332:
20333: when OTHERS then
20334: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
20335: p_api_name => l_api_name,
20336: p_pkg_name => g_pkg_name,
20337: p_exc_name => 'OTHERS',
20338: x_msg_count => x_msg_count,

Line 20347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

20343: END generate_internal_streams;
20344:
20345: PROCEDURE GEN_INTR_EXTR_STREAM (
20346: p_api_version IN NUMBER,
20347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20348: x_return_status OUT NOCOPY VARCHAR2,
20349: x_msg_count OUT NOCOPY NUMBER,
20350: x_msg_data OUT NOCOPY VARCHAR2,
20351: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,