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 6265: Okl_Api.END_ACTIVITY (

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

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

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

Line 6356: lx_error_rec OKL_API.error_rec_type;

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

Line 6432: p_init_msg_list => Okl_Api.G_FALSE,

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

Line 6497: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

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

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

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

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

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