APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKC_API

Line 50: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

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

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

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

Line 106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 108: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 2249: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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
2250:
2251: write_to_log('G_EXCEPTION_ERROR was raised..');
2252: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2253: (

Line 2252: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2248: EXCEPTION
2249: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2250:
2251: write_to_log('G_EXCEPTION_ERROR was raised..');
2252: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2253: (
2254: l_api_name,
2255: G_PKG_NAME,
2256: 'OKC_API.G_RET_STS_ERROR',

Line 2256: 'OKC_API.G_RET_STS_ERROR',

2252: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2253: (
2254: l_api_name,
2255: G_PKG_NAME,
2256: 'OKC_API.G_RET_STS_ERROR',
2257: x_msg_count,
2258: x_msg_data,
2259: '_PVT'
2260: );

Line 2262: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2258: x_msg_data,
2259: '_PVT'
2260: );
2261:
2262: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2263: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
2264: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2265: (
2266: l_api_name,

Line 2264: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2260: );
2261:
2262: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2263: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
2264: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2265: (
2266: l_api_name,
2267: G_PKG_NAME,
2268: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2268: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2264: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2265: (
2266: l_api_name,
2267: G_PKG_NAME,
2268: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2269: x_msg_count,
2270: x_msg_data,
2271: '_PVT'
2272: );

Line 2284: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2280: p_token1_value => SQLCODE,
2281: p_token2 => G_SQLERRM_TOKEN,
2282: p_token2_value => SQLERRM);
2283:
2284: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2285: (
2286: l_api_name,
2287: G_PKG_NAME,
2288: 'OTHERS',

Line 2483: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2479: END LOOP;
2480:
2481: fnd_file.new_line(fnd_file.log,2);
2482:
2483: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2484: write_to_log('Extraction failed for Contract Financial Extract.');
2485:
2486: DELETE OKL_PARALLEL_PROCESSES
2487: WHERE assigned_process = p_assigned_process;