APPS.OKL_K_LINE_FIN_EXT_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:
90: l_row_count NUMBER;
91:

Line 94: l_return_status := Okl_Api.START_ACTIVITY(

90: l_row_count NUMBER;
91:
92: BEGIN
93:
94: l_return_status := Okl_Api.START_ACTIVITY(
95: p_api_name => l_api_name,
96: p_pkg_name => G_PKG_NAME,
97: p_init_msg_list => p_init_msg_list,
98: l_api_version => l_api_version,

Line 6264: Okl_Api.END_ACTIVITY (

6260: x_row_count := to_char(l_row_count);
6261:
6262:
6263:
6264: Okl_Api.END_ACTIVITY (
6265: x_msg_count => x_msg_count,
6266: x_msg_data => x_msg_data);
6267: EXCEPTION
6268: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

6292: WHEN OTHERS THEN
6293:
6294: write_to_log('Unhandled Exception '||sqlcode||':'||sqlerrm);
6295:
6296: okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
6297: p_msg_name => G_UNEXPECTED_ERROR,
6298: p_token1 => G_SQLCODE_TOKEN,
6299: p_token1_value => SQLCODE,
6300: p_token2 => G_SQLERRM_TOKEN,

Line 6355: lx_error_rec OKL_API.error_rec_type;

6351:
6352: l_request_id NUMBER;
6353: l_row_count NUMBER;
6354: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
6355: lx_error_rec OKL_API.error_rec_type;
6356:
6357: CURSOR req_id_csr IS
6358: SELECT
6359: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)

Line 6431: p_init_msg_list => Okl_Api.G_FALSE,

6427:
6428:
6429: pull_extract_data (
6430: p_api_version => l_api_version,
6431: p_init_msg_list => Okl_Api.G_FALSE,
6432: x_return_status => lx_return_status,
6433: x_msg_count => lx_msg_count,
6434: x_msg_data => errbuf,
6435: x_row_count => l_row_count,

Line 6496: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

6492: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
6493: COMMIT;
6494:
6495: retcode := 2;
6496: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
6497: -- purge data
6498: IF p_assigned_process IS NOT NULL THEN
6499:
6500: DELETE OKL_PARALLEL_PROCESSES

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

6535:
6536:
6537: END IF;
6538:
6539: OKL_API.set_message(p_app_name => 'OKC',
6540: p_msg_name => g_unexpected_error,
6541: p_token1 => g_sqlcode_token,
6542: p_token1_value => sqlcode,
6543: p_token2 => g_sqlerrm_token,

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

6614:
6615: EXCEPTION
6616:
6617: WHEN OTHERS THEN
6618: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
6619: p_msg_name => G_UNEXPECTED_ERROR,
6620: p_token1 => G_SQLCODE_TOKEN,
6621: p_token1_value => SQLCODE,
6622: p_token2 => G_SQLERRM_TOKEN,