eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PERIOD_SWEEP_PVT dependencies on OKL_API

Line 183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

179: l_end_date DATE;
180: l_start_date DATE;
181: l_to_start_date DATE;
182: l_to_end_date DATE;
183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
184: l_api_version NUMBER := 1.0;
185: l_init_msg_list VARCHAR2(1);
186: l_msg_count NUMBER ;
187: l_msg_data VARCHAR2(2000);

Line 251: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

247:
248: BEGIN
249: p_retcode:=1;
250:
251: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
252: l_init_msg_list,
253: '_PVT',
254: x_return_status);
255:

Line 256: if (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) then

252: l_init_msg_list,
253: '_PVT',
254: x_return_status);
255:
256: if (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) then
257: raise Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
258: elsif (l_return_status = Okl_Api.G_RET_STS_ERROR) then
259: raise Okl_Api.G_EXCEPTION_ERROR;
260: end if;

Line 257: raise Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

253: '_PVT',
254: x_return_status);
255:
256: if (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) then
257: raise Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
258: elsif (l_return_status = Okl_Api.G_RET_STS_ERROR) then
259: raise Okl_Api.G_EXCEPTION_ERROR;
260: end if;
261:

Line 258: elsif (l_return_status = Okl_Api.G_RET_STS_ERROR) then

254: x_return_status);
255:
256: if (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) then
257: raise Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
258: elsif (l_return_status = Okl_Api.G_RET_STS_ERROR) then
259: raise Okl_Api.G_EXCEPTION_ERROR;
260: end if;
261:
262: --rkuttiya added for MUlti GAAP Project

Line 259: raise Okl_Api.G_EXCEPTION_ERROR;

255:
256: if (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) then
257: raise Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
258: elsif (l_return_status = Okl_Api.G_RET_STS_ERROR) then
259: raise Okl_Api.G_EXCEPTION_ERROR;
260: end if;
261:
262: --rkuttiya added for MUlti GAAP Project
263: IF p_representation_code IS NULL THEN

Line 264: OKL_API.set_message('OKC',

260: end if;
261:
262: --rkuttiya added for MUlti GAAP Project
263: IF p_representation_code IS NULL THEN
264: OKL_API.set_message('OKC',
265: G_REQUIRED_VALUE,
266: G_COL_NAME_TOKEN,
267: 'Representation Code');
268: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 268: RAISE OKL_API.G_EXCEPTION_ERROR;

264: OKL_API.set_message('OKC',
265: G_REQUIRED_VALUE,
266: G_COL_NAME_TOKEN,
267: 'Representation Code');
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;
270:
271:
272: --rkuttiya commenting out the following code for MultiGAAP Project

Line 293: OKL_API.set_message(p_app_name => G_APP_NAME,

289: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_ledger_id => l_ledger_id,
290: p_period_name => p_period_to);
291:
292: IF (l_period_status NOT IN ('O','F')) THEN
293: OKL_API.set_message(p_app_name => G_APP_NAME,
294: p_msg_name => 'OKL_PERIOD_NOT_OPEN',
295: p_token1 => 'PERIOD_NAME',
296: p_token1_value => p_period_to);
297: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 297: RAISE OKL_API.G_EXCEPTION_ERROR;

293: OKL_API.set_message(p_app_name => G_APP_NAME,
294: p_msg_name => 'OKL_PERIOD_NOT_OPEN',
295: p_token1 => 'PERIOD_NAME',
296: p_token1_value => p_period_to);
297: RAISE OKL_API.G_EXCEPTION_ERROR;
298: END IF;
299: --Bug 5707866 end
300: */
301:

Line 339: RAISE OKL_API.G_EXCEPTION_ERROR;

335: p_tabv_tbl => l_tabv_tbl,
336: x_tabv_tbl => x_tabv_tbl);
337: END IF;
338: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: END IF;
341:
342: j :=0;
343: IF (l_tcn_tbl.COUNT > 0) THEN

Line 355: RAISE OKL_API.G_EXCEPTION_ERROR;

351: ,p_event_id =>l_tcn_tbl(j).event_id
352: ,p_tcn_id =>l_tcn_tbl(j).tcn_id);
353:
354: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
355: RAISE OKL_API.G_EXCEPTION_ERROR;
356: END IF;
357:
358: IF l_tcn_tbl(j).trx_type_class = 'ACCRUAL' AND l_tcn_tbl(j).accrual_reversal_date IS NOT NULL THEN
359: l_tcnv_rec.id := l_tcn_tbl(j).tcn_id;

Line 372: RAISE OKL_API.G_EXCEPTION_ERROR;

368: p_tcnv_rec => l_tcnv_rec,
369: x_tcnv_rec => x_tcnv_rec);
370:
371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
372: RAISE OKL_API.G_EXCEPTION_ERROR;
373: END IF;
374: END IF;
375: END LOOP;
376: END IF;

Line 379: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

375: END LOOP;
376: END IF;
377: END IF;
378:
379: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
380:
381: EXCEPTION
382: WHEN OKL_API.G_EXCEPTION_ERROR THEN
383: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,

Line 382: WHEN OKL_API.G_EXCEPTION_ERROR THEN

378:
379: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
380:
381: EXCEPTION
382: WHEN OKL_API.G_EXCEPTION_ERROR THEN
383: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,
384: G_PKG_NAME,
385: 'OKl_API.G_RET_STS_ERROR',
386: x_msg_count,

Line 383: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,

379: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
380:
381: EXCEPTION
382: WHEN OKL_API.G_EXCEPTION_ERROR THEN
383: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,
384: G_PKG_NAME,
385: 'OKl_API.G_RET_STS_ERROR',
386: x_msg_count,
387: x_msg_data,

Line 385: 'OKl_API.G_RET_STS_ERROR',

381: EXCEPTION
382: WHEN OKL_API.G_EXCEPTION_ERROR THEN
383: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,
384: G_PKG_NAME,
385: 'OKl_API.G_RET_STS_ERROR',
386: x_msg_count,
387: x_msg_data,
388: '_PVT'
389: );

Line 396: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,

392: p_errbuf := SQLERRM;
393:
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
396: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,
397: G_PKG_NAME,
398: 'OKl_API.G_RET_STS_ERROR',
399: x_msg_count,
400: x_msg_data,

Line 398: 'OKl_API.G_RET_STS_ERROR',

394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
396: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name,
397: G_PKG_NAME,
398: 'OKl_API.G_RET_STS_ERROR',
399: x_msg_count,
400: x_msg_data,
401: '_PVT'
402: );

Line 421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

417: IS
418:
419: l_api_name VARCHAR2(30) := 'OKL_PERIOD_SWEEP_CON';
420: l_api_version NUMBER := 1.0;
421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
422: l_from_date VARCHAR2(20) ;
423: l_start_date_from DATE;
424: l_start_date_to DATE;
425: l_end_date_from DATE;

Line 461: x_return_status := OKL_API.G_RET_STS_SUCCESS;

457: l_ledger_id NUMBER;
458:
459: BEGIN
460:
461: x_return_status := OKL_API.G_RET_STS_SUCCESS;
462:
463: l_return_status := OKL_API.start_activity(l_api_name
464: ,G_PKG_NAME
465: ,p_init_msg_list

Line 463: l_return_status := OKL_API.start_activity(l_api_name

459: BEGIN
460:
461: x_return_status := OKL_API.G_RET_STS_SUCCESS;
462:
463: l_return_status := OKL_API.start_activity(l_api_name
464: ,G_PKG_NAME
465: ,p_init_msg_list
466: ,l_api_version
467: ,l_api_version

Line 471: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

467: ,l_api_version
468: ,'_PVT'
469: ,x_return_status);
470:
471: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
473: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
474: RAISE OKL_API.G_EXCEPTION_ERROR;
475: END IF;

Line 472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

468: ,'_PVT'
469: ,x_return_status);
470:
471: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
473: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
474: RAISE OKL_API.G_EXCEPTION_ERROR;
475: END IF;
476:

Line 473: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

469: ,x_return_status);
470:
471: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
473: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
474: RAISE OKL_API.G_EXCEPTION_ERROR;
475: END IF;
476:
477: -- rkuttiya 05-Aug-2008 MultiGAAP Project

Line 474: RAISE OKL_API.G_EXCEPTION_ERROR;

470:
471: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
473: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
474: RAISE OKL_API.G_EXCEPTION_ERROR;
475: END IF;
476:
477: -- rkuttiya 05-Aug-2008 MultiGAAP Project
478: l_representation_code := p_representation_code;

Line 492: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

488: CLOSE c_ledger_id;
489: --rkuttiya end
490:
491: IF (p_period_from IS NULL) THEN
492: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
493: okl_accounting_util.get_message_token('OKL_LP_SWEEP_PROGRAM','OKL_TRANSFER_FROM_PERIOD')
494: );
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;

Line 495: RAISE OKL_API.G_EXCEPTION_ERROR;

491: IF (p_period_from IS NULL) THEN
492: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
493: okl_accounting_util.get_message_token('OKL_LP_SWEEP_PROGRAM','OKL_TRANSFER_FROM_PERIOD')
494: );
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497:
498: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_period_from
499: ,l_ledger_id);

Line 502: OKL_API.set_message(p_app_name => G_APP_NAME,

498: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_period_from
499: ,l_ledger_id);
500:
501: IF (l_period_status IS NULL) THEN
502: OKL_API.set_message(p_app_name => G_APP_NAME,
503: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
504: p_token1 => 'PERIOD_NAME',
505: p_token1_value => p_period_from);
506:

Line 507: RAISE OKL_API.G_EXCEPTION_ERROR;

503: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
504: p_token1 => 'PERIOD_NAME',
505: p_token1_value => p_period_from);
506:
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509:
510: IF (l_period_status NOT IN ('O')) THEN
511: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 511: OKL_API.set_message(p_app_name => G_APP_NAME,

507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509:
510: IF (l_period_status NOT IN ('O')) THEN
511: OKL_API.set_message(p_app_name => G_APP_NAME,
512: p_msg_name => 'OKL_PERD_INVALID_STATUS',
513: p_token1 => 'PERIOD',
514: p_token1_value => p_period_from);
515:

Line 516: RAISE OKL_API.G_EXCEPTION_ERROR;

512: p_msg_name => 'OKL_PERD_INVALID_STATUS',
513: p_token1 => 'PERIOD',
514: p_token1_value => p_period_from);
515:
516: RAISE OKL_API.G_EXCEPTION_ERROR;
517: END IF;
518:
519: OKL_ACCOUNTING_UTIL.get_period_info(p_period_from, l_start_date_from,l_end_date_from,l_ledger_id);
520:

Line 521: IF (p_period_to IS NOT NULL) AND (p_period_to <> OKL_API.G_MISS_CHAR) THEN

517: END IF;
518:
519: OKL_ACCOUNTING_UTIL.get_period_info(p_period_from, l_start_date_from,l_end_date_from,l_ledger_id);
520:
521: IF (p_period_to IS NOT NULL) AND (p_period_to <> OKL_API.G_MISS_CHAR) THEN
522: OKL_ACCOUNTING_UTIL.get_period_info(p_period_to, l_start_date_to, l_end_date_to, l_ledger_id);
523: IF (l_start_date_to IS NULL) THEN
524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => 'OKL_PERIOD_NOT_FOUND',

Line 524: OKL_API.set_message(p_app_name => G_APP_NAME,

520:
521: IF (p_period_to IS NOT NULL) AND (p_period_to <> OKL_API.G_MISS_CHAR) THEN
522: OKL_ACCOUNTING_UTIL.get_period_info(p_period_to, l_start_date_to, l_end_date_to, l_ledger_id);
523: IF (l_start_date_to IS NULL) THEN
524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
526: p_token1 => 'PERIOD_NAME',
527: p_token1_value => p_period_to);
528:

Line 529: RAISE OKL_API.G_EXCEPTION_ERROR;

525: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
526: p_token1 => 'PERIOD_NAME',
527: p_token1_value => p_period_to);
528:
529: RAISE OKL_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_to_period := p_period_to;
532: ELSE
533: OPEN perd_csr(l_start_date_from,l_ledger_id);

Line 537: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'To Period');

533: OPEN perd_csr(l_start_date_from,l_ledger_id);
534: FETCH perd_csr INTO l_to_date;
535: CLOSE perd_csr;
536: IF (l_to_date IS NULL) THEN
537: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'To Period');
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: OKL_ACCOUNTING_UTIL.get_period_info(l_to_date, l_to_period, l_start_date_to, l_end_date_to,l_ledger_id);

Line 538: RAISE OKL_API.G_EXCEPTION_ERROR;

534: FETCH perd_csr INTO l_to_date;
535: CLOSE perd_csr;
536: IF (l_to_date IS NULL) THEN
537: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'To Period');
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: OKL_ACCOUNTING_UTIL.get_period_info(l_to_date, l_to_period, l_start_date_to, l_end_date_to,l_ledger_id);
542: END IF;

Line 548: OKL_API.set_message(p_app_name => G_APP_NAME,

544: l_period_status := NULL;
545: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(l_to_period
546: ,l_ledger_id);
547: IF (l_period_status NOT IN ('O','F')) THEN
548: OKL_API.set_message(p_app_name => G_APP_NAME,
549: p_msg_name => 'OKL_PERIOD_NOT_OPEN',
550: p_token1 => 'PERIOD_NAME',
551: p_token1_value => l_to_period);
552:

Line 553: RAISE OKL_API.G_EXCEPTION_ERROR;

549: p_msg_name => 'OKL_PERIOD_NOT_OPEN',
550: p_token1 => 'PERIOD_NAME',
551: p_token1_value => l_to_period);
552:
553: RAISE OKL_API.G_EXCEPTION_ERROR;
554: END IF;
555:
556: OKL_ACCOUNTING_UTIL.get_period_info(l_to_period, l_start_date_to,l_end_date_to,l_ledger_id);
557:

Line 559: OKL_API.set_message(p_app_name => G_APP_NAME,

555:
556: OKL_ACCOUNTING_UTIL.get_period_info(l_to_period, l_start_date_to,l_end_date_to,l_ledger_id);
557:
558: IF (l_start_date_to <= l_start_date_from) THEN
559: OKL_API.set_message(p_app_name => G_APP_NAME,
560: p_msg_name => 'OKL_TO_PERIOD_LATER');
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563:

Line 561: RAISE OKL_API.G_EXCEPTION_ERROR;

557:
558: IF (l_start_date_to <= l_start_date_from) THEN
559: OKL_API.set_message(p_app_name => G_APP_NAME,
560: p_msg_name => 'OKL_TO_PERIOD_LATER');
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563:
564: IF (p_run_option IS NULL) THEN
565: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'Run Option');

Line 565: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'Run Option');

561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563:
564: IF (p_run_option IS NULL) THEN
565: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'Run Option');
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;
568:
569:

Line 566: RAISE OKL_API.G_EXCEPTION_ERROR;

562: END IF;
563:
564: IF (p_run_option IS NULL) THEN
565: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'Run Option');
566: RAISE OKL_API.G_EXCEPTION_ERROR;
567: END IF;
568:
569:
570: --- Call to okl gl transfer concurrent program

Line 581: OKL_API.set_message(p_app_name => 'OFA',

577: ,argument3 => l_to_period
578: ,argument4 => p_run_option);
579:
580: IF x_request_id = 0 THEN
581: OKL_API.set_message(p_app_name => 'OFA',
582: p_msg_name => 'FA_DEPRN_TAX_ERROR',
583: p_token1 => 'REQUEST_ID',
584: p_token1_value => x_request_id);
585:

Line 586: RAISE okl_api.g_exception_error;

582: p_msg_name => 'FA_DEPRN_TAX_ERROR',
583: p_token1 => 'REQUEST_ID',
584: p_token1_value => x_request_id);
585:
586: RAISE okl_api.g_exception_error;
587: END IF;
588:
589: OKL_API.end_activity(x_msg_count, x_msg_data);
590:

Line 589: OKL_API.end_activity(x_msg_count, x_msg_data);

585:
586: RAISE okl_api.g_exception_error;
587: END IF;
588:
589: OKL_API.end_activity(x_msg_count, x_msg_data);
590:
591: EXCEPTION
592: WHEN OKL_API.G_EXCEPTION_ERROR THEN
593: x_return_status := Okl_Api.handle_exceptions(l_api_name

Line 592: WHEN OKL_API.G_EXCEPTION_ERROR THEN

588:
589: OKL_API.end_activity(x_msg_count, x_msg_data);
590:
591: EXCEPTION
592: WHEN OKL_API.G_EXCEPTION_ERROR THEN
593: x_return_status := Okl_Api.handle_exceptions(l_api_name
594: ,g_pkg_name
595: ,'OKL_API.G_RET_STS_ERROR'
596: ,x_msg_count

Line 593: x_return_status := Okl_Api.handle_exceptions(l_api_name

589: OKL_API.end_activity(x_msg_count, x_msg_data);
590:
591: EXCEPTION
592: WHEN OKL_API.G_EXCEPTION_ERROR THEN
593: x_return_status := Okl_Api.handle_exceptions(l_api_name
594: ,g_pkg_name
595: ,'OKL_API.G_RET_STS_ERROR'
596: ,x_msg_count
597: ,x_msg_data

Line 595: ,'OKL_API.G_RET_STS_ERROR'

591: EXCEPTION
592: WHEN OKL_API.G_EXCEPTION_ERROR THEN
593: x_return_status := Okl_Api.handle_exceptions(l_api_name
594: ,g_pkg_name
595: ,'OKL_API.G_RET_STS_ERROR'
596: ,x_msg_count
597: ,x_msg_data
598: ,'_PVT');
599: WHEN okl_api.g_exception_unexpected_error THEN

Line 599: WHEN okl_api.g_exception_unexpected_error THEN

595: ,'OKL_API.G_RET_STS_ERROR'
596: ,x_msg_count
597: ,x_msg_data
598: ,'_PVT');
599: WHEN okl_api.g_exception_unexpected_error THEN
600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
601: ,g_pkg_name
602: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
603: ,x_msg_count

Line 600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

596: ,x_msg_count
597: ,x_msg_data
598: ,'_PVT');
599: WHEN okl_api.g_exception_unexpected_error THEN
600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
601: ,g_pkg_name
602: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
603: ,x_msg_count
604: ,x_msg_data

Line 602: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

598: ,'_PVT');
599: WHEN okl_api.g_exception_unexpected_error THEN
600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
601: ,g_pkg_name
602: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
603: ,x_msg_count
604: ,x_msg_data
605: ,'_PVT');
606: WHEN OTHERS THEN

Line 607: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

603: ,x_msg_count
604: ,x_msg_data
605: ,'_PVT');
606: WHEN OTHERS THEN
607: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
608: (l_api_name,
609: G_PKG_NAME,
610: 'OTHERS',
611: x_msg_count,