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

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

83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;
85:
86: l_api_name CONSTANT VARCHAR2(30) := 'pull_extract_data';
87: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
88: l_api_version CONSTANT NUMBER := 1;
89: -- Start fix for bug 7646416
90: l_report_date DATE;
91: -- End fix for bug 7646416

Line 95: l_return_status := Okl_Api.START_ACTIVITY(

91: -- End fix for bug 7646416
92:
93: BEGIN
94:
95: l_return_status := Okl_Api.START_ACTIVITY(
96: p_api_name => l_api_name,
97: p_pkg_name => G_PKG_NAME,
98: p_init_msg_list => p_init_msg_list,
99: l_api_version => l_api_version,

Line 2245: Okl_Api.END_ACTIVITY (

2241: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T .');
2242: END IF;
2243:
2244:
2245: Okl_Api.END_ACTIVITY (
2246: x_msg_count => x_msg_count,
2247: x_msg_data => x_msg_data);
2248: EXCEPTION
2249: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2277: okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2273: WHEN OTHERS THEN
2274:
2275: write_to_log('Unhandled Exception '||sqlcode||':'||sqlerrm);
2276:
2277: okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2278: p_msg_name => G_UNEXPECTED_ERROR,
2279: p_token1 => G_SQLCODE_TOKEN,
2280: p_token1_value => SQLCODE,
2281: p_token2 => G_SQLERRM_TOKEN,

Line 2339: lx_error_rec OKL_API.error_rec_type;

2335:
2336: l_request_id NUMBER;
2337: l_row_count NUMBER;
2338: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
2339: lx_error_rec OKL_API.error_rec_type;
2340:
2341: CURSOR req_id_csr IS
2342: SELECT
2343: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID) --sechawla : why Null if -1 ?

Line 2426: p_init_msg_list => Okl_Api.G_FALSE,

2422: write_to_log('p_assigned_process = '||p_assigned_process);
2423:
2424: pull_extract_data (
2425: p_api_version => l_api_version,
2426: p_init_msg_list => Okl_Api.G_FALSE,
2427: x_return_status => lx_return_status,
2428: x_msg_count => lx_msg_count,
2429: x_msg_data => errbuf,
2430: x_row_count => l_row_count,

Line 2495: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

2491: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2492: COMMIT;
2493:
2494: retcode := 2;
2495: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
2496: -- purge data
2497: IF p_assigned_process IS NOT NULL THEN
2498:
2499: DELETE OKL_PARALLEL_PROCESSES

Line 2538: OKL_API.set_message(p_app_name => 'OKC',

2534:
2535:
2536: END IF;
2537:
2538: OKL_API.set_message(p_app_name => 'OKC',
2539: p_msg_name => g_unexpected_error,
2540: p_token1 => g_sqlcode_token,
2541: p_token1_value => sqlcode,
2542: p_token2 => g_sqlerrm_token,

Line 2568: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2564: RETURN NUMBER IS
2565:
2566: l_api_name CONSTANT VARCHAR2(60) := 'AMOUNT_DUE_REMAINING';
2567: l_api_version CONSTANT NUMBER := 1;
2568: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2569: x_msg_count NUMBER;
2570: x_msg_data VARCHAR2(256);
2571: -- Start fix for Bug 7586827
2572: /*

Line 2617: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2613:
2614: BEGIN
2615:
2616: IF (p_CONTRACT_NUMBER IS NULL OR p_from_days IS NULL OR p_to_days IS NULL) THEN
2617: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2618: END IF;
2619:
2620:
2621: OPEN l_AMOUNT_DUE_REMAINING_csr (p_CONTRACT_NUMBER, p_from_days, p_to_days);

Line 2640: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2636: IF l_AMOUNT_DUE_REMAINING_csr%ISOPEN THEN
2637: CLOSE l_AMOUNT_DUE_REMAINING_csr;
2638: END IF;
2639:
2640: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2641: p_msg_name => G_UNEXPECTED_ERROR,
2642: p_token1 => G_SQLCODE_TOKEN,
2643: p_token1_value => SQLCODE,
2644: p_token2 => G_SQLERRM_TOKEN,

Line 2666: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2662:
2663: BEGIN
2664:
2665: IF (p_chr_id IS NULL) THEN
2666: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2667: END IF;
2668:
2669: --Each time contract is Rebooked, a Booking transaction is created again. Hence
2670: --This cursor may return multiple rows. The first row identifies the first Booking transaction.

Line 2685: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2681: IF l_okl_trx_contracts_csr%ISOPEN THEN
2682: CLOSE l_okl_trx_contracts_csr;
2683: END IF;
2684:
2685: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2686: p_msg_name => G_UNEXPECTED_ERROR,
2687: p_token1 => G_SQLCODE_TOKEN,
2688: p_token1_value => SQLCODE,
2689: p_token2 => G_SQLERRM_TOKEN,

Line 2737: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2733:
2734: BEGIN
2735:
2736: IF (p_chr_id IS NULL) THEN
2737: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2738: END IF;
2739:
2740:
2741: OPEN accrual_status_csr (p_chr_id );

Line 2762: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2758: IF accrual_status_csr%ISOPEN THEN
2759: CLOSE accrual_status_csr;
2760: END IF;
2761:
2762: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2763: p_msg_name => G_UNEXPECTED_ERROR,
2764: p_token1 => G_SQLCODE_TOKEN,
2765: p_token1_value => SQLCODE,
2766: p_token2 => G_SQLERRM_TOKEN,