APPS.OKL_COPY_TEMPLATE_PVT dependencies on OKL_API

Line 25: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

21: l_api_version NUMBER := 1.0;
22:
23: i NUMBER := 0;
24:
25: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26:
27: l_avlv_rec_in AVLV_REC_TYPE;
28: l_avlv_rec_out AVLV_REC_TYPE;
29:

Line 124: x_return_status := OKL_API.G_RET_STS_SUCCESS;

120:
121:
122: BEGIN
123:
124: x_return_status := OKL_API.G_RET_STS_SUCCESS;
125:
126: FOR avl_rec IN avl_csr(p_aes_id_from)
127:
128: LOOP

Line 175: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

171: ,x_msg_data => l_msg_data
172: ,p_avlv_rec => l_avlv_rec_in
173: ,x_avlv_rec => l_avlv_rec_out);
174:
175: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
176:
177: -- Initialize the Variables
178:
179: i := 0;

Line 228: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

224:
225: END IF;
226:
227:
228: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
229:
230: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231:
232: l_overall_status := l_return_status;

Line 230: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

226:
227:
228: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
229:
230: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231:
232: l_overall_status := l_return_status;
233:
234: END IF;

Line 246: WHEN OKL_API.G_EXCEPTION_ERROR THEN

242:
243:
244: EXCEPTION
245:
246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247:
248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
249: ,g_pkg_name
250: ,'OKL_API.G_RET_STS_ERROR'

Line 248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

244: EXCEPTION
245:
246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247:
248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
249: ,g_pkg_name
250: ,'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count
252: ,x_msg_data

Line 250: ,'OKL_API.G_RET_STS_ERROR'

246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247:
248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
249: ,g_pkg_name
250: ,'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count
252: ,x_msg_data
253: ,'_PVT');
254:

Line 255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

251: ,x_msg_count
252: ,x_msg_data
253: ,'_PVT');
254:
255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256:
257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
258: ,g_pkg_name
259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

Line 257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

253: ,'_PVT');
254:
255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256:
257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
258: ,g_pkg_name
259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
260: ,x_msg_count
261: ,x_msg_data

Line 259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256:
257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
258: ,g_pkg_name
259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
260: ,x_msg_count
261: ,x_msg_data
262: ,'_PVT');
263:

Line 266: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

262: ,'_PVT');
263:
264: WHEN OTHERS THEN
265:
266: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
267: ,g_pkg_name
268: ,'OTHERS'
269: ,x_msg_count
270: ,x_msg_data