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_INTERNAL_TO_EXTERNAL dependencies on OKL_API

Line 151: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

147: ,p_commit IN VARCHAR2
148: ) IS
149:
150: l_api_name CONSTANT VARCHAR2(30) := 'BULK_PROCESS';
151: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
152: l_api_version CONSTANT NUMBER := 1;
153:
154: i NUMBER := 0;
155: j NUMBER := 0;

Line 184: l_return_status := Okl_Api.START_ACTIVITY(

180: -- Print Input variables
181: -- ------------------------
182: PRINT_TO_LOG('BULK p_commit '||p_commit);
183:
184: l_return_status := Okl_Api.START_ACTIVITY(
185: p_api_name => l_api_name,
186: p_pkg_name => G_PKG_NAME,
187: p_init_msg_list => p_init_msg_list,
188: l_api_version => l_api_version,

Line 450: Okl_Api.END_ACTIVITY (

446: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
447: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external','End(-)');
448: END IF;
449:
450: Okl_Api.END_ACTIVITY (
451: x_msg_count => x_msg_count,
452: x_msg_data => x_msg_data);
453:
454: EXCEPTION

Line 460: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

456: ------------------------------------------------------------
457: -- Exception handling
458: ------------------------------------------------------------
459:
460: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
462:
463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',

Line 465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
462:
463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
466: END IF;
467:
468: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
469: p_api_name => l_api_name,

Line 468: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
466: END IF;
467:
468: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
469: p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
472: x_msg_count => x_msg_count,

Line 471: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

467:
468: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
469: p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data,
474: p_api_type => '_PVT');
475:

Line 476: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data,
474: p_api_type => '_PVT');
475:
476: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
478:
479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',

Line 481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
478:
479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
482: END IF;
483:
484: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
485: p_api_name => l_api_name,

Line 484: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
482: END IF;
483:
484: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
485: p_api_name => l_api_name,
486: p_pkg_name => G_PKG_NAME,
487: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
488: x_msg_count => x_msg_count,

Line 487: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

483:
484: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
485: p_api_name => l_api_name,
486: p_pkg_name => G_PKG_NAME,
487: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
488: x_msg_count => x_msg_count,
489: x_msg_data => x_msg_data,
490: p_api_type => '_PVT');
491:

Line 500: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

496: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
497: 'EXCEPTION :'||'OTHERS');
498: END IF;
499:
500: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
501: p_api_name => l_api_name,
502: p_pkg_name => G_PKG_NAME,
503: p_exc_name => 'OTHERS',
504: x_msg_count => x_msg_count,

Line 586: type int_hdr_rec_type IS record(tai_id NUMBER := okl_api.g_miss_num, return_status VARCHAR2(1));

582: i NUMBER;
583: l_recv_inv_id NUMBER;
584: tab_cntr NUMBER;
585:
586: type int_hdr_rec_type IS record(tai_id NUMBER := okl_api.g_miss_num, return_status VARCHAR2(1));
587:
588: type int_hdr_tbl_type IS TABLE OF int_hdr_rec_type INDEX BY binary_integer;
589:
590: int_hdr_status int_hdr_tbl_type;

Line 963: l_return_status := Okl_Api.START_ACTIVITY(

959: -- End : Bug#5964007 : PRASJAIN
960:
961: BEGIN
962:
963: l_return_status := Okl_Api.START_ACTIVITY(
964: p_api_name => l_api_name,
965: p_pkg_name => G_PKG_NAME,
966: p_init_msg_list => p_init_msg_list,
967: l_api_version => l_api_version,

Line 972: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

968: p_api_version => p_api_version,
969: p_api_type => '_PVT',
970: x_return_status => l_return_status);
971:
972: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
973:
974: IF(Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
975: Fnd_Log.string(Fnd_Log.level_procedure, 'process_ie_tbl', 'Begin(+)');
976: END IF;

Line 1153: IF (p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

1149: l_jtot_object2_code := NULL;
1150:
1151: i := i + 1;
1152: -- for LE Uptake project 08-11-2006
1153: IF (p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
1154: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_ie_tbl1(k).contract_id);
1155: ELSE l_legal_entity_id := p_ie_tbl1(k).legal_entity_id;
1156: END IF;
1157: xsi_tbl(l_xsi_cnt).legal_entity_id := l_legal_entity_id;

Line 1334: IF ( p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

1330: --l_xsiv_rec.ORG_ID := ln_dtls_rec.ORG_ID; --TAI
1331: xsi_tbl(l_xsi_cnt).org_id := NULL;
1332: END IF;
1333: -- for LE Uptake project 08-11-2006
1334: IF ( p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
1335: --d*bms_output.put_line ('LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL!');
1336: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');
1337: ELSE
1338: xsi_tbl(l_xsi_cnt).legal_entity_id := p_ie_tbl1(k).legal_entity_id;

Line 2187: IF l_return_status = Okl_Api.g_ret_sts_success THEN

2183: l_populate_pmnt_method := 'Y';
2184: --get primary stream type for remarketing stream
2185: Okl_Streams_Util.get_primary_stream_type(p_ie_tbl2(h).contract_id, 'ASSET_SALE_RECEIVABLE', l_return_status, lx_remrkt_sty_id);
2186:
2187: IF l_return_status = Okl_Api.g_ret_sts_success THEN
2188:
2189: IF(lx_remrkt_sty_id = p_ie_tbl2(h).sty_id) THEN
2190:
2191: IF p_ie_tbl2(h).bank_acct_id IS NULL THEN

Line 2430: IF (p_ie_tbl2(h).legal_entity_id IS NULL OR (p_ie_tbl2(h).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

2426: --l_xsiv_rec.ORG_ID := ln_no_dtls_rec.ORG_ID; --TAI
2427: xsi_tbl(l_xsi_cnt).org_id := NULL;
2428: END IF;
2429: -- for LE Uptake project 08-11-2006
2430: IF (p_ie_tbl2(h).legal_entity_id IS NULL OR (p_ie_tbl2(h).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
2431: --d*bms_output.put_line ('LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL!');
2432: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');
2433: ELSE
2434: xsi_tbl(l_xsi_cnt).legal_entity_id := p_ie_tbl2(h).legal_entity_id;

Line 3010: Okl_Api.END_ACTIVITY (

3006: PRINT_TO_LOG('TBL End time process_id_tbl : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));
3007:
3008: PRINT_TO_LOG('TBL End process_id_tbl (-)');
3009:
3010: Okl_Api.END_ACTIVITY (
3011: x_msg_count => x_msg_count,
3012: x_msg_data => x_msg_data);
3013:
3014: /*

Line 3219: okl_api.end_activity(x_msg_count => x_msg_count, x_msg_data => x_msg_data);*/

3215: ------------------------------------------------------------
3216: -- End processing
3217: ------------------------------------------------------------
3218:
3219: okl_api.end_activity(x_msg_count => x_msg_count, x_msg_data => x_msg_data);*/
3220:
3221: EXCEPTION
3222: WHEN OTHERS THEN
3223:

Line 3244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

3240: ,p_assigned_process IN VARCHAR2
3241: ) IS
3242:
3243: l_api_name CONSTANT VARCHAR2(30) := 'INTERNAL_TO_EXTERNAL';
3244: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3245: l_api_version CONSTANT NUMBER := 1;
3246:
3247:
3248: -- Cursor picks lines with detail records

Line 3500: l_return_status := Okl_Api.START_ACTIVITY(

3496: submitted_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3497: l_end_of_records VARCHAR2(1);
3498:
3499: BEGIN
3500: l_return_status := Okl_Api.START_ACTIVITY(
3501: p_api_name => l_api_name,
3502: p_pkg_name => G_PKG_NAME,
3503: p_init_msg_list => p_init_msg_list,
3504: l_api_version => l_api_version,

Line 3757: Okl_Api.END_ACTIVITY (

3753: COMMIT;
3754:
3755: END IF;
3756:
3757: Okl_Api.END_ACTIVITY (
3758: x_msg_count => x_msg_count,
3759: x_msg_data => x_msg_data);
3760: PRINT_TO_LOG('IE End time internal_to_external : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));
3761:

Line 3771: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3767: EXCEPTION
3768: ------------------------------------------------------------
3769: -- Exception handling
3770: ------------------------------------------------------------
3771: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3773:
3774: IF p_assigned_process IS NOT NULL THEN
3775: DELETE OKL_PARALLEL_PROCESSES

Line 3782: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

3778: END IF;
3779:
3780: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3781: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3782: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3783: END IF;
3784:
3785: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3786: p_api_name => l_api_name,

Line 3785: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3781: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3782: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3783: END IF;
3784:
3785: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3786: p_api_name => l_api_name,
3787: p_pkg_name => G_PKG_NAME,
3788: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3789: x_msg_count => x_msg_count,

Line 3788: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

3784:
3785: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3786: p_api_name => l_api_name,
3787: p_pkg_name => G_PKG_NAME,
3788: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3789: x_msg_count => x_msg_count,
3790: x_msg_data => x_msg_data,
3791: p_api_type => '_PVT');
3792:

Line 3793: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3789: x_msg_count => x_msg_count,
3790: x_msg_data => x_msg_data,
3791: p_api_type => '_PVT');
3792:
3793: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3794: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3795:
3796: IF p_assigned_process IS NOT NULL THEN
3797: DELETE OKL_PARALLEL_PROCESSES

Line 3804: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

3800: END IF;
3801:
3802: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3803: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3804: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3805: END IF;
3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3807: p_api_name => l_api_name,
3808: p_pkg_name => G_PKG_NAME,

Line 3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3802: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3803: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3804: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3805: END IF;
3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3807: p_api_name => l_api_name,
3808: p_pkg_name => G_PKG_NAME,
3809: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3810: x_msg_count => x_msg_count,

Line 3809: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

3805: END IF;
3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3807: p_api_name => l_api_name,
3808: p_pkg_name => G_PKG_NAME,
3809: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3810: x_msg_count => x_msg_count,
3811: x_msg_data => x_msg_data,
3812: p_api_type => '_PVT');
3813:

Line 3827: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3823: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3824: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3825: 'EXCEPTION :'||'OTHERS');
3826: END IF;
3827: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3828: p_api_name => l_api_name,
3829: p_pkg_name => G_PKG_NAME,
3830: p_exc_name => 'OTHERS',
3831: x_msg_count => x_msg_count,