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 2263: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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
2264:
2265: write_to_log('G_EXCEPTION_ERROR was raised..');
2266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2267: (

Line 2266: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2262: EXCEPTION
2263: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2264:
2265: write_to_log('G_EXCEPTION_ERROR was raised..');
2266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2267: (
2268: l_api_name,
2269: G_PKG_NAME,
2270: 'OKC_API.G_RET_STS_ERROR',

Line 2270: 'OKC_API.G_RET_STS_ERROR',

2266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2267: (
2268: l_api_name,
2269: G_PKG_NAME,
2270: 'OKC_API.G_RET_STS_ERROR',
2271: x_msg_count,
2272: x_msg_data,
2273: '_PVT'
2274: );

Line 2276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2272: x_msg_data,
2273: '_PVT'
2274: );
2275:
2276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2277: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
2278: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2279: (
2280: l_api_name,

Line 2278: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2274: );
2275:
2276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2277: write_to_log('G_EXCEPTION_UNEXPECTED_ERROR was raised..');
2278: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2279: (
2280: l_api_name,
2281: G_PKG_NAME,
2282: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2282: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2278: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2279: (
2280: l_api_name,
2281: G_PKG_NAME,
2282: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2283: x_msg_count,
2284: x_msg_data,
2285: '_PVT'
2286: );

Line 2298: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2294: p_token1_value => SQLCODE,
2295: p_token2 => G_SQLERRM_TOKEN,
2296: p_token2_value => SQLERRM);
2297:
2298: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2299: (
2300: l_api_name,
2301: G_PKG_NAME,
2302: 'OTHERS',

Line 2497: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2493: END LOOP;
2494:
2495: fnd_file.new_line(fnd_file.log,2);
2496:
2497: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2498: write_to_log('Extraction failed for Contract Financial Extract.');
2499:
2500: DELETE OKL_PARALLEL_PROCESSES
2501: WHERE assigned_process = p_assigned_process;