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_BLK_AST_UPD_PVT dependencies on OKL_API

Line 32: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

28:
29:
30: PROCEDURE create_txl_itm_insts(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2,
36: p_date_from IN DATE,

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

40: x_itiv_rec OUT NOCOPY itiv_rec_type);
41:
42: PROCEDURE Create_asset_header(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_trxv_rec IN trxv_rec_type,

Line 53: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

49: x_trxv_rec OUT NOCOPY trxv_rec_type) ;
50:
51: PROCEDURE Update_asset_header(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_trxv_rec IN trxv_rec_type,

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

114: ,p_init_msg_list
115: ,'_PVT'
116: ,x_return_status);
117: --Check if activity started successfully
118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_ERROR;
122: END IF;

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

116: ,x_return_status);
117: --Check if activity started successfully
118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_ERROR;
122: END IF;
123: -- end bug 8459840
124:

Line 363: x_return_status := OKL_API.G_RET_STS_SUCCESS;

359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_oldsite_id2 :'||p_loc_rec.oldsite_id2);
360: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_loc_rec.date_from);
361: END IF;
362:
363: x_return_status := OKL_API.G_RET_STS_SUCCESS;
364:
365: --Call start_activity to create savepoint, check compatibility and initialize message list
366:
367: x_return_status := OKL_API.START_ACTIVITY(

Line 367: x_return_status := OKL_API.START_ACTIVITY(

363: x_return_status := OKL_API.G_RET_STS_SUCCESS;
364:
365: --Call start_activity to create savepoint, check compatibility and initialize message list
366:
367: x_return_status := OKL_API.START_ACTIVITY(
368: l_api_name
369: ,p_init_msg_list
370: ,'_PVT'
371: ,x_return_status);

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

371: ,x_return_status);
372:
373: --Check if activity started successfully
374:
375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;

Line 376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

372:
373: --Check if activity started successfully
374:
375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380:

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

373: --Check if activity started successfully
374:
375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381: --asawanka ebtax changes start

Line 378: RAISE OKL_API.G_EXCEPTION_ERROR;

374:
375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381: --asawanka ebtax changes start
382:

Line 386: OKL_API.set_message( p_app_name => 'OKL',

382:
383: OPEN c_get_entered_alc_trx(p_loc_rec.parent_line_id);
384: FETCH c_get_entered_alc_trx INTO l_entered;
385: IF c_get_entered_alc_trx%FOUND THEN
386: OKL_API.set_message( p_app_name => 'OKL',
387: p_msg_name => 'OKL_ASTLOC_CHNG_NA_ENT');
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:

Line 388: RAISE OKL_API.G_EXCEPTION_ERROR;

384: FETCH c_get_entered_alc_trx INTO l_entered;
385: IF c_get_entered_alc_trx%FOUND THEN
386: OKL_API.set_message( p_app_name => 'OKL',
387: p_msg_name => 'OKL_ASTLOC_CHNG_NA_ENT');
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:
391: OPEN c_get_chr_id(p_loc_rec.parent_line_id);
392: FETCH c_get_chr_id INTO l_chr_id,l_org_id ,l_currency_code;

Line 401: OKL_API.set_message( p_app_name => 'OKL',

397: CLOSE c_bill_upfront_tax;
398:
399: IF l_bill_upfront_tax IS NOT NULL THEN
400: IF l_bill_upfront_tax <> 'BILLED' THEN
401: OKL_API.set_message( p_app_name => 'OKL',
402: p_msg_name => 'OKL_ASTLOC_CHNG_NA_AST');
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405: ELSE

Line 403: RAISE OKL_API.G_EXCEPTION_ERROR;

399: IF l_bill_upfront_tax IS NOT NULL THEN
400: IF l_bill_upfront_tax <> 'BILLED' THEN
401: OKL_API.set_message( p_app_name => 'OKL',
402: p_msg_name => 'OKL_ASTLOC_CHNG_NA_AST');
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405: ELSE
406: -- dcshanmu bug 6673102 start
407: OPEN c_upfront_tax_calc(l_chr_id);

Line 415: OKL_API.set_message( p_app_name => 'OKL',

411: OPEN c_asset_upfront_tax(l_chr_id);
412: FETCH c_asset_upfront_tax INTO l_asset_upfront_tax;
413: CLOSE c_asset_upfront_tax;
414: IF l_asset_upfront_tax IS NULL OR l_asset_upfront_tax <> 'BILLED' THEN
415: OKL_API.set_message( p_app_name => 'OKL',
416: p_msg_name => 'OKL_ASTLOC_CHNG_NA_KHR');
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: -- dcshanmu bug 6673102 start

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413: CLOSE c_asset_upfront_tax;
414: IF l_asset_upfront_tax IS NULL OR l_asset_upfront_tax <> 'BILLED' THEN
415: OKL_API.set_message( p_app_name => 'OKL',
416: p_msg_name => 'OKL_ASTLOC_CHNG_NA_KHR');
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: -- dcshanmu bug 6673102 start
420: END IF;
421: CLOSE c_upfront_tax_calc;

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

440:
441: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
442: x_try_id => l_try_id);
443:
444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;

Line 445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

441: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
442: x_try_id => l_try_id);
443:
444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;
449:

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

442: x_try_id => l_try_id);
443:
444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;
449:
450: l_trqv_rec.request_status_code := 'ENTERED';

Line 447: RAISE OKL_API.G_EXCEPTION_ERROR;

443:
444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;
449:
450: l_trqv_rec.request_status_code := 'ENTERED';
451: l_trqv_rec.request_type_code := 'ASSET_RELOCATION';

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

462: x_msg_count => x_msg_count,
463: x_msg_data => x_msg_data,
464: p_trqv_rec => l_trqv_rec,
465: x_trqv_rec => x_trqv_rec);
466: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;

Line 467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

463: x_msg_data => x_msg_data,
464: p_trqv_rec => l_trqv_rec,
465: x_trqv_rec => x_trqv_rec);
466: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471:

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

464: p_trqv_rec => l_trqv_rec,
465: x_trqv_rec => x_trqv_rec);
466: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471:
472: G_CTR := 1;

Line 469: RAISE OKL_API.G_EXCEPTION_ERROR;

465: x_trqv_rec => x_trqv_rec);
466: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471:
472: G_CTR := 1;
473: --asawanka ebtax changes end

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

512: x_itiv_rec => l_out_rec
513: );
514:
515:
516: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
518: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;

Line 517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

513: );
514:
515:
516: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
518: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:

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

514:
515:
516: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
518: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:
522: IF l_serialized_yn = 'Y' AND G_CTR = 1 THEN

Line 519: RAISE OKL_API.G_EXCEPTION_ERROR;

515:
516: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
518: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:
522: IF l_serialized_yn = 'Y' AND G_CTR = 1 THEN
523: IF G_CTR = l_ser_count THEN

Line 566: OKL_API.END_ACTIVITY (x_msg_count,

562: END LOOP;
563: G_CTR := G_CTR + 1;
564: END LOOP;
565:
566: OKL_API.END_ACTIVITY (x_msg_count,
567: x_msg_data );
568: EXCEPTION
569: WHEN OKL_API.G_EXCEPTION_ERROR THEN
570: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 569: WHEN OKL_API.G_EXCEPTION_ERROR THEN

565:
566: OKL_API.END_ACTIVITY (x_msg_count,
567: x_msg_data );
568: EXCEPTION
569: WHEN OKL_API.G_EXCEPTION_ERROR THEN
570: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
571: l_api_name,
572: G_PKG_NAME,
573: 'OKL_API.G_RET_STS_ERROR',

Line 570: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

566: OKL_API.END_ACTIVITY (x_msg_count,
567: x_msg_data );
568: EXCEPTION
569: WHEN OKL_API.G_EXCEPTION_ERROR THEN
570: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
571: l_api_name,
572: G_PKG_NAME,
573: 'OKL_API.G_RET_STS_ERROR',
574: x_msg_count,

Line 573: 'OKL_API.G_RET_STS_ERROR',

569: WHEN OKL_API.G_EXCEPTION_ERROR THEN
570: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
571: l_api_name,
572: G_PKG_NAME,
573: 'OKL_API.G_RET_STS_ERROR',
574: x_msg_count,
575: x_msg_data,
576: '_PVT');
577: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 577: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

573: 'OKL_API.G_RET_STS_ERROR',
574: x_msg_count,
575: x_msg_data,
576: '_PVT');
577: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
579: l_api_name,
580: G_PKG_NAME,
581: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

574: x_msg_count,
575: x_msg_data,
576: '_PVT');
577: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
579: l_api_name,
580: G_PKG_NAME,
581: 'OKL_API.G_RET_STS_UNEXP_ERROR',
582: x_msg_count,

Line 581: 'OKL_API.G_RET_STS_UNEXP_ERROR',

577: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
579: l_api_name,
580: G_PKG_NAME,
581: 'OKL_API.G_RET_STS_UNEXP_ERROR',
582: x_msg_count,
583: x_msg_data,
584: '_PVT');
585: WHEN OTHERS THEN

Line 586: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

582: x_msg_count,
583: x_msg_data,
584: '_PVT');
585: WHEN OTHERS THEN
586: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
587: l_api_name,
588: G_PKG_NAME,
589: 'OTHERS',
590: x_msg_count,

Line 598: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

594: END update_location;
595:
596: PROCEDURE create_txl_itm_insts(
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,
602: p_date_from IN DATE,

Line 612: x_return_status := OKL_API.G_RET_STS_SUCCESS;

608: l_trxv_rec trxv_rec_type;
609: lm_itiv_rec itiv_rec_type;
610: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ITM_INSTS';
611: BEGIN
612: x_return_status := OKL_API.G_RET_STS_SUCCESS;
613: -- Call start_activity to create savepoint, check compatibility
614: -- and initialize message list
615: x_return_status := OKL_API.START_ACTIVITY (
616: l_api_name

Line 615: x_return_status := OKL_API.START_ACTIVITY (

611: BEGIN
612: x_return_status := OKL_API.G_RET_STS_SUCCESS;
613: -- Call start_activity to create savepoint, check compatibility
614: -- and initialize message list
615: x_return_status := OKL_API.START_ACTIVITY (
616: l_api_name
617: ,p_init_msg_list
618: ,'_PVT'
619: ,x_return_status);

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

617: ,p_init_msg_list
618: ,'_PVT'
619: ,x_return_status);
620: -- Check if activity started successfully
621: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;

Line 622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

618: ,'_PVT'
619: ,x_return_status);
620: -- Check if activity started successfully
621: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;
626: -- Create New Header record and new Line record

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

619: ,x_return_status);
620: -- Check if activity started successfully
621: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;
626: -- Create New Header record and new Line record
627: -- Before creating Header record

Line 624: RAISE OKL_API.G_EXCEPTION_ERROR;

620: -- Check if activity started successfully
621: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;
626: -- Create New Header record and new Line record
627: -- Before creating Header record
628: -- we should make sure atleast the required record is given

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

632: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
633: x_try_id => l_trxv_rec.try_id);
634:
635:
636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;

Line 637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

633: x_try_id => l_trxv_rec.try_id);
634:
635:
636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641:

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

634:
635:
636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641:
642: l_trxv_rec.tsu_code := 'ENTERED';

Line 639: RAISE OKL_API.G_EXCEPTION_ERROR;

635:
636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641:
642: l_trxv_rec.tsu_code := 'ENTERED';
643: l_trxv_rec.date_trans_occurred := p_date_from;

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

651: x_msg_data => x_msg_data,
652: p_trxv_rec => l_trxv_rec,
653: x_trxv_rec => x_trxv_rec);
654:
655: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
656: l_trxv_rec := x_trxv_rec;
657: l_trxv_rec.tsu_code := 'ERROR';
658: Update_asset_header(p_api_version => p_api_version,
659: p_init_msg_list => p_init_msg_list,

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

662: x_msg_data => x_msg_data,
663: p_trxv_rec => l_trxv_rec,
664: x_trxv_rec => x_trxv_rec);
665:
666: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;

Line 667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

663: p_trxv_rec => l_trxv_rec,
664: x_trxv_rec => x_trxv_rec);
665:
666: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;
671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

664: x_trxv_rec => x_trxv_rec);
665:
666: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;
671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 669: RAISE OKL_API.G_EXCEPTION_ERROR;

665:
666: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;
671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
673: l_trxv_rec := x_trxv_rec;

Line 671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;
671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
673: l_trxv_rec := x_trxv_rec;
674: l_trxv_rec.tsu_code := 'ERROR';
675:

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

668: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_ERROR;
670: END IF;
671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
673: l_trxv_rec := x_trxv_rec;
674: l_trxv_rec.tsu_code := 'ERROR';
675:
676:

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

680: x_msg_count => x_msg_count,
681: x_msg_data => x_msg_data,
682: p_trxv_rec => l_trxv_rec,
683: x_trxv_rec => x_trxv_rec);
684: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_ERROR;
688: END IF;

Line 685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

681: x_msg_data => x_msg_data,
682: p_trxv_rec => l_trxv_rec,
683: x_trxv_rec => x_trxv_rec);
684: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_ERROR;
688: END IF;
689: RAISE OKL_API.G_EXCEPTION_ERROR;

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

682: p_trxv_rec => l_trxv_rec,
683: x_trxv_rec => x_trxv_rec);
684: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_ERROR;
688: END IF;
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;

Line 687: RAISE OKL_API.G_EXCEPTION_ERROR;

683: x_trxv_rec => x_trxv_rec);
684: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_ERROR;
688: END IF;
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691: -- Now we are creating the new line record

Line 689: RAISE OKL_API.G_EXCEPTION_ERROR;

685: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_ERROR;
688: END IF;
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691: -- Now we are creating the new line record
692: lm_itiv_rec := p_itiv_rec;
693: lm_itiv_rec.tas_id := x_trxv_rec.id;

Line 694: IF (lm_itiv_rec.tal_type = OKL_API.G_MISS_CHAR OR

690: END IF;
691: -- Now we are creating the new line record
692: lm_itiv_rec := p_itiv_rec;
693: lm_itiv_rec.tas_id := x_trxv_rec.id;
694: IF (lm_itiv_rec.tal_type = OKL_API.G_MISS_CHAR OR
695: lm_itiv_rec.tal_type IS NUll) THEN
696: lm_itiv_rec.tal_type := 'AGL';
697: END IF;
698:

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

715: x_iipv_rec => x_itiv_rec);
716:
717:
718:
719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_ERROR;
723: END IF;

Line 720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

716:
717:
718:
719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_ERROR;
723: END IF;
724: OKL_API.END_ACTIVITY (x_msg_count,

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

717:
718:
719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_ERROR;
723: END IF;
724: OKL_API.END_ACTIVITY (x_msg_count,
725: x_msg_data );

Line 722: RAISE OKL_API.G_EXCEPTION_ERROR;

718:
719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_ERROR;
723: END IF;
724: OKL_API.END_ACTIVITY (x_msg_count,
725: x_msg_data );
726: EXCEPTION

Line 724: OKL_API.END_ACTIVITY (x_msg_count,

720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_ERROR;
723: END IF;
724: OKL_API.END_ACTIVITY (x_msg_count,
725: x_msg_data );
726: EXCEPTION
727: WHEN OKL_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 727: WHEN OKL_API.G_EXCEPTION_ERROR THEN

723: END IF;
724: OKL_API.END_ACTIVITY (x_msg_count,
725: x_msg_data );
726: EXCEPTION
727: WHEN OKL_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: l_api_name,
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_ERROR',

Line 728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

724: OKL_API.END_ACTIVITY (x_msg_count,
725: x_msg_data );
726: EXCEPTION
727: WHEN OKL_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: l_api_name,
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_ERROR',
732: x_msg_count,

Line 731: 'OKL_API.G_RET_STS_ERROR',

727: WHEN OKL_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: l_api_name,
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_ERROR',
732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

731: 'OKL_API.G_RET_STS_ERROR',
732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
737: l_api_name,
738: G_PKG_NAME,
739: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 736: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
737: l_api_name,
738: G_PKG_NAME,
739: 'OKL_API.G_RET_STS_UNEXP_ERROR',
740: x_msg_count,

Line 739: 'OKL_API.G_RET_STS_UNEXP_ERROR',

735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
737: l_api_name,
738: G_PKG_NAME,
739: 'OKL_API.G_RET_STS_UNEXP_ERROR',
740: x_msg_count,
741: x_msg_data,
742: '_PVT');
743: WHEN OTHERS THEN

Line 744: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

740: x_msg_count,
741: x_msg_data,
742: '_PVT');
743: WHEN OTHERS THEN
744: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
745: l_api_name,
746: G_PKG_NAME,
747: 'OTHERS',
748: x_msg_count,

Line 755: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

751: END create_txl_itm_insts;
752:
753: PROCEDURE Create_asset_header(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_trxv_rec IN trxv_rec_type,

Line 763: x_return_status := OKL_API.G_RET_STS_SUCCESS;

759: p_trxv_rec IN trxv_rec_type,
760: x_trxv_rec OUT NOCOPY trxv_rec_type) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TRX_ASSET_HEADER';
762: BEGIN
763: x_return_status := OKL_API.G_RET_STS_SUCCESS;
764: -- Call start_activity to create savepoint, check compatibility
765: -- and initialize message list
766: x_return_status := OKL_API.START_ACTIVITY (
767: l_api_name

Line 766: x_return_status := OKL_API.START_ACTIVITY (

762: BEGIN
763: x_return_status := OKL_API.G_RET_STS_SUCCESS;
764: -- Call start_activity to create savepoint, check compatibility
765: -- and initialize message list
766: x_return_status := OKL_API.START_ACTIVITY (
767: l_api_name
768: ,p_init_msg_list
769: ,'_PVT'
770: ,x_return_status);

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

768: ,p_init_msg_list
769: ,'_PVT'
770: ,x_return_status);
771: -- Check if activity started successfully
772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;

Line 773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

769: ,'_PVT'
770: ,x_return_status);
771: -- Check if activity started successfully
772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777: -- evaluate conditions, build outcomes for true conditions and

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

770: ,x_return_status);
771: -- Check if activity started successfully
772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777: -- evaluate conditions, build outcomes for true conditions and
778: -- put them on outcome queue

Line 775: RAISE OKL_API.G_EXCEPTION_ERROR;

771: -- Check if activity started successfully
772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777: -- evaluate conditions, build outcomes for true conditions and
778: -- put them on outcome queue
779: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

Line 787: OKL_API.END_ACTIVITY (x_msg_count,

783: x_msg_count => x_msg_count,
784: x_msg_data => x_msg_data,
785: p_thpv_rec => p_trxv_rec,
786: x_thpv_rec => x_trxv_rec);
787: OKL_API.END_ACTIVITY (x_msg_count,
788: x_msg_data );
789: EXCEPTION
790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 790: WHEN OKL_API.G_EXCEPTION_ERROR THEN

786: x_thpv_rec => x_trxv_rec);
787: OKL_API.END_ACTIVITY (x_msg_count,
788: x_msg_data );
789: EXCEPTION
790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',

Line 791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

787: OKL_API.END_ACTIVITY (x_msg_count,
788: x_msg_data );
789: EXCEPTION
790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,

Line 794: 'OKL_API.G_RET_STS_ERROR',

790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,
796: x_msg_data,
797: '_PVT');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,
796: x_msg_data,
797: '_PVT');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

795: x_msg_count,
796: x_msg_data,
797: '_PVT');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',
803: x_msg_count,

Line 802: 'OKL_API.G_RET_STS_UNEXP_ERROR',

798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',
803: x_msg_count,
804: x_msg_data,
805: '_PVT');
806: WHEN OTHERS THEN

Line 807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

803: x_msg_count,
804: x_msg_data,
805: '_PVT');
806: WHEN OTHERS THEN
807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
808: l_api_name,
809: G_PKG_NAME,
810: 'OTHERS',
811: x_msg_count,

Line 818: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

814: END Create_asset_header;
815:
816: PROCEDURE Update_asset_header(
817: p_api_version IN NUMBER,
818: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
819: x_return_status OUT NOCOPY VARCHAR2,
820: x_msg_count OUT NOCOPY NUMBER,
821: x_msg_data OUT NOCOPY VARCHAR2,
822: p_trxv_rec IN trxv_rec_type,

Line 826: x_return_status := OKL_API.G_RET_STS_SUCCESS;

822: p_trxv_rec IN trxv_rec_type,
823: x_trxv_rec OUT NOCOPY trxv_rec_type) IS
824: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_ASSET_HEADER';
825: BEGIN
826: x_return_status := OKL_API.G_RET_STS_SUCCESS;
827: -- Call start_activity to create savepoint, check compatibility
828: -- and initialize message list
829: x_return_status := OKL_API.START_ACTIVITY (
830: l_api_name

Line 829: x_return_status := OKL_API.START_ACTIVITY (

825: BEGIN
826: x_return_status := OKL_API.G_RET_STS_SUCCESS;
827: -- Call start_activity to create savepoint, check compatibility
828: -- and initialize message list
829: x_return_status := OKL_API.START_ACTIVITY (
830: l_api_name
831: ,p_init_msg_list
832: ,'_PVT'
833: ,x_return_status);

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

831: ,p_init_msg_list
832: ,'_PVT'
833: ,x_return_status);
834: -- Check if activity started successfully
835: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;

Line 836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

832: ,'_PVT'
833: ,x_return_status);
834: -- Check if activity started successfully
835: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840: -- evaluate conditions, build outcomes for true conditions and

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

833: ,x_return_status);
834: -- Check if activity started successfully
835: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840: -- evaluate conditions, build outcomes for true conditions and
841: -- put them on outcome queue

Line 838: RAISE OKL_API.G_EXCEPTION_ERROR;

834: -- Check if activity started successfully
835: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840: -- evaluate conditions, build outcomes for true conditions and
841: -- put them on outcome queue
842: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

Line 850: OKL_API.END_ACTIVITY (x_msg_count,

846: x_msg_count => x_msg_count,
847: x_msg_data => x_msg_data,
848: p_thpv_rec => p_trxv_rec,
849: x_thpv_rec => x_trxv_rec);
850: OKL_API.END_ACTIVITY (x_msg_count,
851: x_msg_data );
852: EXCEPTION
853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 853: WHEN OKL_API.G_EXCEPTION_ERROR THEN

849: x_thpv_rec => x_trxv_rec);
850: OKL_API.END_ACTIVITY (x_msg_count,
851: x_msg_data );
852: EXCEPTION
853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
855: l_api_name,
856: G_PKG_NAME,
857: 'OKL_API.G_RET_STS_ERROR',

Line 854: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

850: OKL_API.END_ACTIVITY (x_msg_count,
851: x_msg_data );
852: EXCEPTION
853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
855: l_api_name,
856: G_PKG_NAME,
857: 'OKL_API.G_RET_STS_ERROR',
858: x_msg_count,

Line 857: 'OKL_API.G_RET_STS_ERROR',

853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
855: l_api_name,
856: G_PKG_NAME,
857: 'OKL_API.G_RET_STS_ERROR',
858: x_msg_count,
859: x_msg_data,
860: '_PVT');
861: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 861: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

857: 'OKL_API.G_RET_STS_ERROR',
858: x_msg_count,
859: x_msg_data,
860: '_PVT');
861: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
862: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
863: l_api_name,
864: G_PKG_NAME,
865: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 862: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

858: x_msg_count,
859: x_msg_data,
860: '_PVT');
861: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
862: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
863: l_api_name,
864: G_PKG_NAME,
865: 'OKL_API.G_RET_STS_UNEXP_ERROR',
866: x_msg_count,

Line 865: 'OKL_API.G_RET_STS_UNEXP_ERROR',

861: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
862: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
863: l_api_name,
864: G_PKG_NAME,
865: 'OKL_API.G_RET_STS_UNEXP_ERROR',
866: x_msg_count,
867: x_msg_data,
868: '_PVT');
869: WHEN OTHERS THEN

Line 870: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

866: x_msg_count,
867: x_msg_data,
868: '_PVT');
869: WHEN OTHERS THEN
870: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
871: l_api_name,
872: G_PKG_NAME,
873: 'OTHERS',
874: x_msg_count,

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

979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2)
982: IS
983: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
984: l_api_name CONSTANT VARCHAR2(30) := 'Update_Location';
985: l_api_version CONSTANT NUMBER := 1;
986: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
987: i NUMBER;

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

982: IS
983: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
984: l_api_name CONSTANT VARCHAR2(30) := 'Update_Location';
985: l_api_version CONSTANT NUMBER := 1;
986: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
987: i NUMBER;
988: BEGIN
989: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
990: G_PKG_NAME,

Line 989: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

985: l_api_version CONSTANT NUMBER := 1;
986: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
987: i NUMBER;
988: BEGIN
989: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
990: G_PKG_NAME,
991: p_init_msg_list,
992: l_api_version,
993: p_api_version,

Line 997: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

993: p_api_version,
994: '_PVT',
995: x_return_status);
996: -- check if activity started successfully
997: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
998: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1000: raise OKL_API.G_EXCEPTION_ERROR;
1001: End If;

Line 998: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

994: '_PVT',
995: x_return_status);
996: -- check if activity started successfully
997: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
998: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1000: raise OKL_API.G_EXCEPTION_ERROR;
1001: End If;
1002: -- Make sure PL/SQL table has records in it before passing

Line 999: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

995: x_return_status);
996: -- check if activity started successfully
997: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
998: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1000: raise OKL_API.G_EXCEPTION_ERROR;
1001: End If;
1002: -- Make sure PL/SQL table has records in it before passing
1003: IF (p_loc_tbl.COUNT > 0) THEN

Line 1000: raise OKL_API.G_EXCEPTION_ERROR;

996: -- check if activity started successfully
997: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
998: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1000: raise OKL_API.G_EXCEPTION_ERROR;
1001: End If;
1002: -- Make sure PL/SQL table has records in it before passing
1003: IF (p_loc_tbl.COUNT > 0) THEN
1004: i := p_loc_tbl.FIRST;

Line 1027: p_init_msg_list => OKL_API.G_FALSE,

1023: END IF;
1024: LOOP
1025: update_location (
1026: p_api_version => l_api_version,
1027: p_init_msg_list => OKL_API.G_FALSE,
1028: x_return_status => x_return_status,
1029: x_msg_count => x_msg_count,
1030: x_msg_data => x_msg_data,
1031: p_loc_rec => p_loc_tbl(i));

Line 1033: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

1029: x_msg_count => x_msg_count,
1030: x_msg_data => x_msg_data,
1031: p_loc_rec => p_loc_tbl(i));
1032: -- store the highest degree of error
1033: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1034: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1035: l_overall_status := x_return_status;
1036: End If;
1037: End If;

Line 1034: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

1030: x_msg_data => x_msg_data,
1031: p_loc_rec => p_loc_tbl(i));
1032: -- store the highest degree of error
1033: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1034: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1035: l_overall_status := x_return_status;
1036: End If;
1037: End If;
1038: EXIT WHEN (i = p_loc_tbl.LAST);

Line 1044: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1040: END LOOP;
1041: -- return overall status
1042: x_return_status := l_overall_status;
1043: END IF;
1044: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;

Line 1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1041: -- return overall status
1042: x_return_status := l_overall_status;
1043: END IF;
1044: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;
1049: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

Line 1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1042: x_return_status := l_overall_status;
1043: END IF;
1044: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;
1049: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1050: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1047: raise OKL_API.G_EXCEPTION_ERROR;

1043: END IF;
1044: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;
1049: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1050: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');

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

1045: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;
1049: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1050: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');
1052: END IF;
1053: EXCEPTION

Line 1054: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1050: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');
1052: END IF;
1053: EXCEPTION
1054: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1058: END IF;

Line 1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');

1053: EXCEPTION
1054: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1058: END IF;
1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1059: x_return_status := OKL_API.G_RET_STS_ERROR;

1055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1058: END IF;
1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1058: END IF;
1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1064: END IF;

Line 1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1064: END IF;
1065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1064: END IF;
1065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1069: 'EXCEPTION :'||sqlerrm);

Line 1071: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1069: 'EXCEPTION :'||sqlerrm);
1070: END IF;
1071: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1072: -- unexpected error
1073: OKL_API.set_message(p_app_name => g_app_name,
1074: p_msg_name => g_unexpected_error,
1075: p_token1 => g_sqlcode_token,

Line 1073: OKL_API.set_message(p_app_name => g_app_name,

1069: 'EXCEPTION :'||sqlerrm);
1070: END IF;
1071: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1072: -- unexpected error
1073: OKL_API.set_message(p_app_name => g_app_name,
1074: p_msg_name => g_unexpected_error,
1075: p_token1 => g_sqlcode_token,
1076: p_token1_value => sqlcode,
1077: p_token2 => g_sqlerrm_token,

Line 1170: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1166: BEGIN
1167:
1168: okl_debug_pub.logmessage('OKL: populate_account_data : START');
1169:
1170: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1171:
1172: l_acc_gen_primary_key_tbl(1).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
1173: OPEN fnd_pro_csr;
1174: FETCH fnd_pro_csr INTO fnd_pro_rec;

Line 1228: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)

1224:
1225:
1226: okl_debug_pub.logmessage('OKL: populate_account_data : OKL_SECURITIZATION_PVT : '||x_return_status);
1227:
1228: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1229: THEN
1230: RAISE account_data_exception;
1231: END IF;
1232:

Line 1284: x_return_status := OKL_API.G_RET_STS_ERROR;

1280:
1281: EXCEPTION
1282: WHEN account_data_exception
1283: THEN
1284: x_return_status := OKL_API.G_RET_STS_ERROR;
1285:
1286: END populate_account_data;
1287:
1288: -- Start of comments

Line 1429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1425: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','Begin(+)');
1427: END IF;
1428:
1429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1430:
1431: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1432: THEN
1433: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT

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

1439: FETCH acct_opt_csr INTO l_acct_opt;
1440:
1441: IF acct_opt_csr%NOTFOUND
1442: THEN
1443: OKL_API.set_message( p_app_name => G_APP_NAME,
1444: p_msg_name => 'OKL_LA_ST_ACCT_ERROR');
1445: CLOSE acct_opt_csr;
1446: RAISE upfront_tax_acct_exception;
1447: END IF;

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

1456: END IF;
1457:
1458: IF (l_acct_opt IS NULL)
1459: THEN
1460: OKL_API.set_message( p_app_name => G_APP_NAME,
1461: p_msg_name => 'OKL_LA_ST_ACCT_ERROR');
1462: RAISE upfront_tax_acct_exception;
1463: END IF;
1464:

Line 1483: Okl_Api.SET_MESSAGE( G_APP_NAME

1479: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1481: IF fnd_lookups_csr%NOTFOUND
1482: THEN
1483: Okl_Api.SET_MESSAGE( G_APP_NAME
1484: ,OKL_API.G_INVALID_VALUE
1485: ,'TRANSACTION_TYPE'
1486: ,'Upfront Tax');
1487: CLOSE fnd_lookups_csr;

Line 1484: ,OKL_API.G_INVALID_VALUE

1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1481: IF fnd_lookups_csr%NOTFOUND
1482: THEN
1483: Okl_Api.SET_MESSAGE( G_APP_NAME
1484: ,OKL_API.G_INVALID_VALUE
1485: ,'TRANSACTION_TYPE'
1486: ,'Upfront Tax');
1487: CLOSE fnd_lookups_csr;
1488: RAISE upfront_tax_acct_exception;

Line 1503: Okl_Api.SET_MESSAGE(G_APP_NAME,

1499: l_Trx_Type_rec := NULL;
1500: OPEN Transaction_Type_csr('Upfront Tax');
1501: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
1502: IF Transaction_Type_csr%NOTFOUND THEN
1503: Okl_Api.SET_MESSAGE(G_APP_NAME,
1504: OKL_API.G_INVALID_VALUE,
1505: 'TRANSACTION_TYPE',
1506: 'Upfront Tax');
1507: CLOSE Transaction_Type_csr;

Line 1504: OKL_API.G_INVALID_VALUE,

1500: OPEN Transaction_Type_csr('Upfront Tax');
1501: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
1502: IF Transaction_Type_csr%NOTFOUND THEN
1503: Okl_Api.SET_MESSAGE(G_APP_NAME,
1504: OKL_API.G_INVALID_VALUE,
1505: 'TRANSACTION_TYPE',
1506: 'Upfront Tax');
1507: CLOSE Transaction_Type_csr;
1508: RAISE upfront_tax_acct_exception;

Line 1527: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1523: x_primary_sty_id => l_billed_sty_id);
1524:
1525: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: UPFRONT_TAX_BILLED : '||l_billed_sty_id);
1526:
1527: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1528: RAISE upfront_tax_acct_exception;
1529: End If;
1530:
1531: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)

Line 1611: Okl_Api.set_message(p_app_name => G_APP_NAME,

1607: IF l_legal_entity_id IS NOT NULL THEN
1608: l_trxH_in_rec.legal_entity_id := l_legal_entity_id;
1609: ELSE
1610:
1611: Okl_Api.set_message(p_app_name => G_APP_NAME,
1612: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1613: p_token1 => 'CONTRACT_NUMBER',
1614: p_token1_value => l_contract_rec.contract_number);
1615: RAISE upfront_tax_acct_exception;

Line 1637: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)

1633:
1634: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_trx_contracts : '||x_return_status);
1635:
1636: -- check transaction creation was successful
1637: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1638: THEN
1639: RAISE upfront_tax_acct_exception;
1640: END IF;
1641:

Line 1679: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)

1675:
1676: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_trx_cntrct_lines : '||x_return_status);
1677:
1678: -- check transaction line creation was successful
1679: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1680: THEN
1681: RAISE upfront_tax_acct_exception;
1682: END IF;
1683:

Line 1700: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)

1696:
1697: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: populate_account_data : '||x_return_status);
1698:
1699: -- check transaction line creation was successful
1700: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1701: THEN
1702: RAISE upfront_tax_acct_exception;
1703: END IF;
1704:

Line 1729: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)

1725: p_trx_header_id => l_trxh_out_rec.id);
1726:
1727: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_accounting_dist : '|| x_return_status);
1728:
1729: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1730: THEN
1731: RAISE upfront_tax_acct_exception;
1732: END IF;
1733:

Line 1743: x_return_status := OKL_API.G_RET_STS_ERROR;

1739:
1740: EXCEPTION
1741: WHEN upfront_tax_acct_exception
1742: THEN
1743: x_return_status := OKL_API.G_RET_STS_ERROR;
1744:
1745: END create_upfront_tax_accounting;
1746: --Bug# 6619311 End
1747:

Line 1867: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1863: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1864: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_kle_id :'|| p_kle_id);
1865: END IF;
1866:
1867: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1868:
1869: --Call start_activity to create savepoint, check compatibility and initialize message list
1870:
1871: x_return_status := OKL_API.START_ACTIVITY(

Line 1871: x_return_status := OKL_API.START_ACTIVITY(

1867: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1868:
1869: --Call start_activity to create savepoint, check compatibility and initialize message list
1870:
1871: x_return_status := OKL_API.START_ACTIVITY(
1872: l_api_name
1873: ,p_init_msg_list
1874: ,'_PVT'
1875: ,x_return_status);

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

1875: ,x_return_status);
1876:
1877: --Check if activity started successfully
1878:
1879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1882: RAISE OKL_API.G_EXCEPTION_ERROR;
1883: END IF;

Line 1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1876:
1877: --Check if activity started successfully
1878:
1879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1882: RAISE OKL_API.G_EXCEPTION_ERROR;
1883: END IF;
1884:

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

1877: --Check if activity started successfully
1878:
1879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1882: RAISE OKL_API.G_EXCEPTION_ERROR;
1883: END IF;
1884:
1885: FOR l_c_free_form2 in c_free_form2(p_kle_id) LOOP

Line 1882: RAISE OKL_API.G_EXCEPTION_ERROR;

1878:
1879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1882: RAISE OKL_API.G_EXCEPTION_ERROR;
1883: END IF;
1884:
1885: FOR l_c_free_form2 in c_free_form2(p_kle_id) LOOP
1886: FOR l_c_inst_item IN c_inst_item(l_c_free_form2.id) LOOP

Line 1896: OKL_API.set_message( p_app_name => 'OKL',

1892:
1893: OPEN c_get_entered_alc_trx(l_c_inst_item.id);
1894: FETCH c_get_entered_alc_trx INTO l_trx_rec;
1895: IF c_get_entered_alc_trx%NOTFOUND THEN
1896: OKL_API.set_message( p_app_name => 'OKL',
1897: p_msg_name => 'OKL_ASTLOC_TRX_NF');
1898: RAISE OKL_API.G_EXCEPTION_ERROR;
1899: END IF;
1900: CLOSE c_get_entered_alc_trx;

Line 1898: RAISE OKL_API.G_EXCEPTION_ERROR;

1894: FETCH c_get_entered_alc_trx INTO l_trx_rec;
1895: IF c_get_entered_alc_trx%NOTFOUND THEN
1896: OKL_API.set_message( p_app_name => 'OKL',
1897: p_msg_name => 'OKL_ASTLOC_TRX_NF');
1898: RAISE OKL_API.G_EXCEPTION_ERROR;
1899: END IF;
1900: CLOSE c_get_entered_alc_trx;
1901:
1902: -- updating installed base item.

Line 2111: OKL_API.set_message( p_app_name => 'OKL',

2107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2108: RAISE OKC_API.G_EXCEPTION_ERROR;
2109: END IF;
2110: ELSE
2111: OKL_API.set_message( p_app_name => 'OKL',
2112: p_msg_name => 'OKL_ASTLOC_TAX_NOT_BILLED');
2113: END IF;
2114:
2115: END IF; -- ER# 9327076

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

2126: p_trxv_rec => l_trxv_rec,
2127: x_trxv_rec => x_trxv_rec);
2128:
2129:
2130: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;

Line 2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2127: x_trxv_rec => x_trxv_rec);
2128:
2129:
2130: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135: END IF; -- If _ib_inst found

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

2128:
2129:
2130: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135: END IF; -- If _ib_inst found
2136: CLOSE c_ib_inst;

Line 2133: RAISE OKL_API.G_EXCEPTION_ERROR;

2129:
2130: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135: END IF; -- If _ib_inst found
2136: CLOSE c_ib_inst;
2137: END LOOP;

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

2149: x_msg_data => x_msg_data,
2150: p_trqv_rec => l_trqv_rec,
2151: x_trqv_rec => x_trqv_rec);
2152:
2153: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2154: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2155: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2156: RAISE OKL_API.G_EXCEPTION_ERROR;
2157: END IF;

Line 2154: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2150: p_trqv_rec => l_trqv_rec,
2151: x_trqv_rec => x_trqv_rec);
2152:
2153: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2154: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2155: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2156: RAISE OKL_API.G_EXCEPTION_ERROR;
2157: END IF;
2158:

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

2151: x_trqv_rec => x_trqv_rec);
2152:
2153: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2154: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2155: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2156: RAISE OKL_API.G_EXCEPTION_ERROR;
2157: END IF;
2158:
2159: END IF;

Line 2156: RAISE OKL_API.G_EXCEPTION_ERROR;

2152:
2153: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2154: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2155: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2156: RAISE OKL_API.G_EXCEPTION_ERROR;
2157: END IF;
2158:
2159: END IF;
2160: G_CTR := G_CTR + 1;

Line 2163: OKL_API.END_ACTIVITY (x_msg_count,

2159: END IF;
2160: G_CTR := G_CTR + 1;
2161: END LOOP;
2162:
2163: OKL_API.END_ACTIVITY (x_msg_count,
2164: x_msg_data );
2165: EXCEPTION
2166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2166: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2162:
2163: OKL_API.END_ACTIVITY (x_msg_count,
2164: x_msg_data );
2165: EXCEPTION
2166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2168: l_api_name,
2169: G_PKG_NAME,
2170: 'OKL_API.G_RET_STS_ERROR',

Line 2167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2163: OKL_API.END_ACTIVITY (x_msg_count,
2164: x_msg_data );
2165: EXCEPTION
2166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2168: l_api_name,
2169: G_PKG_NAME,
2170: 'OKL_API.G_RET_STS_ERROR',
2171: x_msg_count,

Line 2170: 'OKL_API.G_RET_STS_ERROR',

2166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2168: l_api_name,
2169: G_PKG_NAME,
2170: 'OKL_API.G_RET_STS_ERROR',
2171: x_msg_count,
2172: x_msg_data,
2173: '_PVT');
2174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2170: 'OKL_API.G_RET_STS_ERROR',
2171: x_msg_count,
2172: x_msg_data,
2173: '_PVT');
2174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2176: l_api_name,
2177: G_PKG_NAME,
2178: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2171: x_msg_count,
2172: x_msg_data,
2173: '_PVT');
2174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2176: l_api_name,
2177: G_PKG_NAME,
2178: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2179: x_msg_count,

Line 2178: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2176: l_api_name,
2177: G_PKG_NAME,
2178: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2179: x_msg_count,
2180: x_msg_data,
2181: '_PVT');
2182: WHEN OTHERS THEN

Line 2183: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2179: x_msg_count,
2180: x_msg_data,
2181: '_PVT');
2182: WHEN OTHERS THEN
2183: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2184: l_api_name,
2185: G_PKG_NAME,
2186: 'OTHERS',
2187: x_msg_count,