DBA Data[Home] [Help]

APPS.OKL_FA_AMOUNTS_PVT dependencies on OKL_API

Line 33: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

29: x_salvage_value OUT NOCOPY NUMBER,
30: x_recoverable_cost OUT NOCOPY NUMBER,
31: x_adj_recoverable_cost OUT NOCOPY NUMBER) is
32:
33: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
34: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
35: l_api_version CONSTANT NUMBER := 1.0;
36:
37:

Line 91: x_return_status := OKL_API.G_RET_STS_SUCCESS;

87: l_adj_recoverable_cost NUMBER;
88:
89: l_inv_conv_rate NUMBER;
90: begin
91: x_return_status := OKL_API.G_RET_STS_SUCCESS;
92: -- Call start_activity to create savepoint, check compatibility
93: -- and initialize message list
94: x_return_status := OKL_API.START_ACTIVITY (
95: l_api_name

Line 94: x_return_status := OKL_API.START_ACTIVITY (

90: begin
91: x_return_status := OKL_API.G_RET_STS_SUCCESS;
92: -- Call start_activity to create savepoint, check compatibility
93: -- and initialize message list
94: x_return_status := OKL_API.START_ACTIVITY (
95: l_api_name
96: ,p_init_msg_list
97: ,'_PVT'
98: ,x_return_status);

Line 100: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

96: ,p_init_msg_list
97: ,'_PVT'
98: ,x_return_status);
99: -- Check if activity started successfully
100: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104: END IF;

Line 101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

97: ,'_PVT'
98: ,x_return_status);
99: -- Check if activity started successfully
100: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104: END IF;
105:

Line 102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

98: ,x_return_status);
99: -- Check if activity started successfully
100: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104: END IF;
105:
106: open conv_params_csr(p_asset_id);

Line 103: RAISE OKL_API.G_EXCEPTION_ERROR;

99: -- Check if activity started successfully
100: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104: END IF;
105:
106: open conv_params_csr(p_asset_id);
107: Fetch conv_params_csr into l_conv_params_rec;

Line 204: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

200: x_salvage_value := l_salvage_value;
201: x_recoverable_cost := l_recoverable_cost;
202: x_adj_recoverable_cost := l_adj_recoverable_cost;
203:
204: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
205: EXCEPTION
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
208: l_api_name,

Line 206: WHEN OKL_API.G_EXCEPTION_ERROR THEN

202: x_adj_recoverable_cost := l_adj_recoverable_cost;
203:
204: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
205: EXCEPTION
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
208: l_api_name,
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_ERROR',

Line 207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

203:
204: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
205: EXCEPTION
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
208: l_api_name,
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_ERROR',
211: x_msg_count,

Line 210: 'OKL_API.G_RET_STS_ERROR',

206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
208: l_api_name,
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_ERROR',
211: x_msg_count,
212: x_msg_data,
213: '_PVT');
214: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 214: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

210: 'OKL_API.G_RET_STS_ERROR',
211: x_msg_count,
212: x_msg_data,
213: '_PVT');
214: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
216: l_api_name,
217: G_PKG_NAME,
218: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

211: x_msg_count,
212: x_msg_data,
213: '_PVT');
214: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
216: l_api_name,
217: G_PKG_NAME,
218: 'OKL_API.G_RET_STS_UNEXP_ERROR',
219: x_msg_count,

Line 218: 'OKL_API.G_RET_STS_UNEXP_ERROR',

214: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
216: l_api_name,
217: G_PKG_NAME,
218: 'OKL_API.G_RET_STS_UNEXP_ERROR',
219: x_msg_count,
220: x_msg_data,
221: '_PVT');
222: WHEN OTHERS THEN

Line 223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

219: x_msg_count,
220: x_msg_data,
221: '_PVT');
222: WHEN OTHERS THEN
223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
224: l_api_name,
225: G_PKG_NAME,
226: 'OTHERS',
227: x_msg_count,

Line 260: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

256: x_salvage_value OUT NOCOPY NUMBER,
257: x_recoverable_cost OUT NOCOPY NUMBER,
258: x_adj_recoverable_cost OUT NOCOPY NUMBER) is
259:
260: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
261: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
262: l_api_version CONSTANT NUMBER := 1.0;
263:
264:

Line 299: x_return_status := OKL_API.G_RET_STS_SUCCESS;

295: l_recoverable_cost NUMBER;
296: l_adj_recoverable_cost NUMBER;
297:
298: Begin
299: x_return_status := OKL_API.G_RET_STS_SUCCESS;
300: -- Call start_activity to create savepoint, check compatibility
301: -- and initialize message list
302: x_return_status := OKL_API.START_ACTIVITY (
303: l_api_name

Line 302: x_return_status := OKL_API.START_ACTIVITY (

298: Begin
299: x_return_status := OKL_API.G_RET_STS_SUCCESS;
300: -- Call start_activity to create savepoint, check compatibility
301: -- and initialize message list
302: x_return_status := OKL_API.START_ACTIVITY (
303: l_api_name
304: ,p_init_msg_list
305: ,'_PVT'
306: ,x_return_status);

Line 308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

304: ,p_init_msg_list
305: ,'_PVT'
306: ,x_return_status);
307: -- Check if activity started successfully
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;

Line 309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

305: ,'_PVT'
306: ,x_return_status);
307: -- Check if activity started successfully
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:

Line 310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

306: ,x_return_status);
307: -- Check if activity started successfully
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314: --get fixed asset

Line 311: RAISE OKL_API.G_EXCEPTION_ERROR;

307: -- Check if activity started successfully
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314: --get fixed asset
315: Open fixed_Ast_csr(p_fin_ast_id);

Line 346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

342: x_salvage_value => l_salvage_value,
343: x_recoverable_cost => l_recoverable_cost,
344: x_adj_recoverable_cost => l_adj_recoverable_cost);
345: -- Check if activity started successfully
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;

Line 347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

343: x_recoverable_cost => l_recoverable_cost,
344: x_adj_recoverable_cost => l_adj_recoverable_cost);
345: -- Check if activity started successfully
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:

Line 348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

344: x_adj_recoverable_cost => l_adj_recoverable_cost);
345: -- Check if activity started successfully
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: x_cost := l_cost;

Line 349: RAISE OKL_API.G_EXCEPTION_ERROR;

345: -- Check if activity started successfully
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: x_cost := l_cost;
353: x_adj_cost := l_adj_cost;

Line 359: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

355: x_salvage_value := l_salvage_value;
356: x_recoverable_cost := l_recoverable_cost;
357: x_adj_recoverable_cost := l_adj_recoverable_cost;
358:
359: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
360: EXCEPTION
361: WHEN OKL_API.G_EXCEPTION_ERROR THEN
362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
363: l_api_name,

Line 361: WHEN OKL_API.G_EXCEPTION_ERROR THEN

357: x_adj_recoverable_cost := l_adj_recoverable_cost;
358:
359: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
360: EXCEPTION
361: WHEN OKL_API.G_EXCEPTION_ERROR THEN
362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
363: l_api_name,
364: G_PKG_NAME,
365: 'OKL_API.G_RET_STS_ERROR',

Line 362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

358:
359: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
360: EXCEPTION
361: WHEN OKL_API.G_EXCEPTION_ERROR THEN
362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
363: l_api_name,
364: G_PKG_NAME,
365: 'OKL_API.G_RET_STS_ERROR',
366: x_msg_count,

Line 365: 'OKL_API.G_RET_STS_ERROR',

361: WHEN OKL_API.G_EXCEPTION_ERROR THEN
362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
363: l_api_name,
364: G_PKG_NAME,
365: 'OKL_API.G_RET_STS_ERROR',
366: x_msg_count,
367: x_msg_data,
368: '_PVT');
369: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 369: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

365: 'OKL_API.G_RET_STS_ERROR',
366: x_msg_count,
367: x_msg_data,
368: '_PVT');
369: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
370: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
371: l_api_name,
372: G_PKG_NAME,
373: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 370: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

366: x_msg_count,
367: x_msg_data,
368: '_PVT');
369: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
370: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
371: l_api_name,
372: G_PKG_NAME,
373: 'OKL_API.G_RET_STS_UNEXP_ERROR',
374: x_msg_count,

Line 373: 'OKL_API.G_RET_STS_UNEXP_ERROR',

369: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
370: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
371: l_api_name,
372: G_PKG_NAME,
373: 'OKL_API.G_RET_STS_UNEXP_ERROR',
374: x_msg_count,
375: x_msg_data,
376: '_PVT');
377: WHEN OTHERS THEN

Line 378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

374: x_msg_count,
375: x_msg_data,
376: '_PVT');
377: WHEN OTHERS THEN
378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
379: l_api_name,
380: G_PKG_NAME,
381: 'OTHERS',
382: x_msg_count,

Line 413: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

409: p_okl_salvage_value IN NUMBER,
410: x_fa_cost OUT NOCOPY NUMBER,
411: x_fa_salvage_value OUT NOCOPY NUMBER) is
412:
413: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
414: l_api_name CONSTANT varchar2(30) := 'CONVERT_OKL_AMOUNTS';
415: l_api_version CONSTANT NUMBER := 1.0;
416:
417: Cursor conv_params_csr(finassetid NUMBER) is

Line 456: x_return_status := OKL_API.G_RET_STS_SUCCESS;

452:
453: l_fa_cost NUMBER;
454: l_fa_salvage_value NUMBER;
455: begin
456: x_return_status := OKL_API.G_RET_STS_SUCCESS;
457: -- Call start_activity to create savepoint, check compatibility
458: -- and initialize message list
459: x_return_status := OKL_API.START_ACTIVITY (
460: l_api_name

Line 459: x_return_status := OKL_API.START_ACTIVITY (

455: begin
456: x_return_status := OKL_API.G_RET_STS_SUCCESS;
457: -- Call start_activity to create savepoint, check compatibility
458: -- and initialize message list
459: x_return_status := OKL_API.START_ACTIVITY (
460: l_api_name
461: ,p_init_msg_list
462: ,'_PVT'
463: ,x_return_status);

Line 465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

461: ,p_init_msg_list
462: ,'_PVT'
463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;

Line 466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

462: ,'_PVT'
463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:

Line 467: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:
471: open conv_params_csr(p_fin_ast_id);

Line 468: RAISE OKL_API.G_EXCEPTION_ERROR;

464: -- Check if activity started successfully
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:
471: open conv_params_csr(p_fin_ast_id);
472: Fetch conv_params_csr into l_conv_params_rec;

Line 549: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

545:
546: x_fa_cost := l_fa_cost;
547: x_fa_salvage_value := l_fa_salvage_value;
548:
549: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
550: EXCEPTION
551: WHEN OKL_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
553: l_api_name,

Line 551: WHEN OKL_API.G_EXCEPTION_ERROR THEN

547: x_fa_salvage_value := l_fa_salvage_value;
548:
549: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
550: EXCEPTION
551: WHEN OKL_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
553: l_api_name,
554: G_PKG_NAME,
555: 'OKL_API.G_RET_STS_ERROR',

Line 552: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

548:
549: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
550: EXCEPTION
551: WHEN OKL_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
553: l_api_name,
554: G_PKG_NAME,
555: 'OKL_API.G_RET_STS_ERROR',
556: x_msg_count,

Line 555: 'OKL_API.G_RET_STS_ERROR',

551: WHEN OKL_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
553: l_api_name,
554: G_PKG_NAME,
555: 'OKL_API.G_RET_STS_ERROR',
556: x_msg_count,
557: x_msg_data,
558: '_PVT');
559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

555: 'OKL_API.G_RET_STS_ERROR',
556: x_msg_count,
557: x_msg_data,
558: '_PVT');
559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
561: l_api_name,
562: G_PKG_NAME,
563: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

556: x_msg_count,
557: x_msg_data,
558: '_PVT');
559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
561: l_api_name,
562: G_PKG_NAME,
563: 'OKL_API.G_RET_STS_UNEXP_ERROR',
564: x_msg_count,

Line 563: 'OKL_API.G_RET_STS_UNEXP_ERROR',

559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
561: l_api_name,
562: G_PKG_NAME,
563: 'OKL_API.G_RET_STS_UNEXP_ERROR',
564: x_msg_count,
565: x_msg_data,
566: '_PVT');
567: WHEN OTHERS THEN

Line 568: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

564: x_msg_count,
565: x_msg_data,
566: '_PVT');
567: WHEN OTHERS THEN
568: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
569: l_api_name,
570: G_PKG_NAME,
571: 'OTHERS',
572: x_msg_count,