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; sechawla 25-sep-09 8890513
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 2259: Okl_Api.END_ACTIVITY (

2255: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T .');
2256: END IF;
2257:
2258:
2259: Okl_Api.END_ACTIVITY (
2260: x_msg_count => x_msg_count,
2261: x_msg_data => x_msg_data);
2262: EXCEPTION
2263: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2287: WHEN OTHERS THEN
2288:
2289: write_to_log('Unhandled Exception '||sqlcode||':'||sqlerrm);
2290:
2291: okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2292: p_msg_name => G_UNEXPECTED_ERROR,
2293: p_token1 => G_SQLCODE_TOKEN,
2294: p_token1_value => SQLCODE,
2295: p_token2 => G_SQLERRM_TOKEN,

Line 2353: lx_error_rec OKL_API.error_rec_type;

2349:
2350: l_request_id NUMBER;
2351: l_row_count NUMBER;
2352: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
2353: lx_error_rec OKL_API.error_rec_type;
2354:
2355: CURSOR req_id_csr IS
2356: SELECT
2357: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID) --sechawla : why Null if -1 ?

Line 2440: p_init_msg_list => Okl_Api.G_FALSE,

2436: write_to_log('p_assigned_process = '||p_assigned_process);
2437:
2438: pull_extract_data (
2439: p_api_version => l_api_version,
2440: p_init_msg_list => Okl_Api.G_FALSE,
2441: x_return_status => lx_return_status,
2442: x_msg_count => lx_msg_count,
2443: x_msg_data => errbuf,
2444: x_row_count => l_row_count,

Line 2509: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

2505: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2506: COMMIT;
2507:
2508: retcode := 2;
2509: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
2510: -- purge data
2511: IF p_assigned_process IS NOT NULL THEN
2512:
2513: DELETE OKL_PARALLEL_PROCESSES

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

2548:
2549:
2550: END IF;
2551:
2552: OKL_API.set_message(p_app_name => 'OKC',
2553: p_msg_name => g_unexpected_error,
2554: p_token1 => g_sqlcode_token,
2555: p_token1_value => sqlcode,
2556: p_token2 => g_sqlerrm_token,

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

2578: RETURN NUMBER IS
2579:
2580: l_api_name CONSTANT VARCHAR2(60) := 'AMOUNT_DUE_REMAINING';
2581: l_api_version CONSTANT NUMBER := 1;
2582: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2583: x_msg_count NUMBER;
2584: x_msg_data VARCHAR2(256);
2585: -- Start fix for Bug 7586827
2586: /*

Line 2631: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2627:
2628: BEGIN
2629:
2630: IF (p_CONTRACT_NUMBER IS NULL OR p_from_days IS NULL OR p_to_days IS NULL) THEN
2631: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2632: END IF;
2633:
2634:
2635: OPEN l_AMOUNT_DUE_REMAINING_csr (p_CONTRACT_NUMBER, p_from_days, p_to_days);

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

2650: IF l_AMOUNT_DUE_REMAINING_csr%ISOPEN THEN
2651: CLOSE l_AMOUNT_DUE_REMAINING_csr;
2652: END IF;
2653:
2654: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2655: p_msg_name => G_UNEXPECTED_ERROR,
2656: p_token1 => G_SQLCODE_TOKEN,
2657: p_token1_value => SQLCODE,
2658: p_token2 => G_SQLERRM_TOKEN,

Line 2680: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2676:
2677: BEGIN
2678:
2679: IF (p_chr_id IS NULL) THEN
2680: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2681: END IF;
2682:
2683: --Each time contract is Rebooked, a Booking transaction is created again. Hence
2684: --This cursor may return multiple rows. The first row identifies the first Booking transaction.

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

2695: IF l_okl_trx_contracts_csr%ISOPEN THEN
2696: CLOSE l_okl_trx_contracts_csr;
2697: END IF;
2698:
2699: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2700: p_msg_name => G_UNEXPECTED_ERROR,
2701: p_token1 => G_SQLCODE_TOKEN,
2702: p_token1_value => SQLCODE,
2703: p_token2 => G_SQLERRM_TOKEN,

Line 2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2747:
2748: BEGIN
2749:
2750: IF (p_chr_id IS NULL) THEN
2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2752: END IF;
2753:
2754:
2755: OPEN accrual_status_csr (p_chr_id );

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

2772: IF accrual_status_csr%ISOPEN THEN
2773: CLOSE accrual_status_csr;
2774: END IF;
2775:
2776: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2777: p_msg_name => G_UNEXPECTED_ERROR,
2778: p_token1 => G_SQLCODE_TOKEN,
2779: p_token1_value => SQLCODE,
2780: p_token2 => G_SQLERRM_TOKEN,