APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKC_API

Line 52: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

48: *=======================================================================*/
49:
50: PROCEDURE pull_extract_data (
51: p_api_version IN NUMBER
52: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
53: ,x_return_status OUT NOCOPY VARCHAR2
54: ,x_msg_count OUT NOCOPY NUMBER
55: ,x_msg_data OUT NOCOPY VARCHAR2,
56: x_row_count OUT NOCOPY VARCHAR2,

Line 104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

100: p_api_type => '_PVT',
101: x_return_status => x_return_status);
102:
103:
104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
107: RAISE OKC_API.G_EXCEPTION_ERROR;
108: END IF;

Line 105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

101: x_return_status => x_return_status);
102:
103:
104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
107: RAISE OKC_API.G_EXCEPTION_ERROR;
108: END IF;
109:

Line 106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

102:
103:
104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
107: RAISE OKC_API.G_EXCEPTION_ERROR;
108: END IF;
109:
110: write_to_log('Parameters in pull_extract_data ...');

Line 107: RAISE OKC_API.G_EXCEPTION_ERROR;

103:
104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
107: RAISE OKC_API.G_EXCEPTION_ERROR;
108: END IF;
109:
110: write_to_log('Parameters in pull_extract_data ...');
111: write_to_log('P_OPERATING_UNIT = '||P_OPERATING_UNIT);

Line 6268: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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
6269:
6270: write_to_log('G_EXCEPTION_ERROR was raised..');
6271: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6272: (

Line 6271: x_return_status := OKC_API.HANDLE_EXCEPTIONS

6267: EXCEPTION
6268: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6269:
6270: write_to_log('G_EXCEPTION_ERROR was raised..');
6271: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6272: (
6273: l_api_name,
6274: G_PKG_NAME,
6275: 'OKC_API.G_RET_STS_ERROR',

Line 6275: 'OKC_API.G_RET_STS_ERROR',

6271: x_return_status := OKC_API.HANDLE_EXCEPTIONS
6272: (
6273: l_api_name,
6274: G_PKG_NAME,
6275: 'OKC_API.G_RET_STS_ERROR',
6276: x_msg_count,
6277: x_msg_data,
6278: '_PVT'
6279: );

Line 6281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

6277: x_msg_data,
6278: '_PVT'
6279: );
6280:
6281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6282: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
6283: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
6284: (
6285: l_api_name,

Line 6283: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

6279: );
6280:
6281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6282: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
6283: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
6284: (
6285: l_api_name,
6286: G_PKG_NAME,
6287: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 6287: 'OKC_API.G_RET_STS_UNEXP_ERROR',

6283: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
6284: (
6285: l_api_name,
6286: G_PKG_NAME,
6287: 'OKC_API.G_RET_STS_UNEXP_ERROR',
6288: x_msg_count,
6289: x_msg_data,
6290: '_PVT'
6291: );

Line 6303: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

6299: p_token1_value => SQLCODE,
6300: p_token2 => G_SQLERRM_TOKEN,
6301: p_token2_value => SQLERRM);
6302:
6303: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
6304: (
6305: l_api_name,
6306: G_PKG_NAME,
6307: 'OTHERS',

Line 6484: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

6480: END LOOP;
6481:
6482: fnd_file.new_line(fnd_file.log,2);
6483:
6484: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6485: write_to_log('Extraction failed for Contract Line Financial Extract.');
6486:
6487: DELETE OKL_PARALLEL_PROCESSES
6488: WHERE assigned_process = p_assigned_process;