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 331: x_return_status := OKL_API.G_RET_STS_SUCCESS;

327: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_oldsite_id2 :'||p_loc_rec.oldsite_id2);
328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_loc_rec.date_from);
329: END IF;
330:
331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
332:
333: --Call start_activity to create savepoint, check compatibility and initialize message list
334:
335: x_return_status := OKL_API.START_ACTIVITY(

Line 335: x_return_status := OKL_API.START_ACTIVITY(

331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
332:
333: --Call start_activity to create savepoint, check compatibility and initialize message list
334:
335: x_return_status := OKL_API.START_ACTIVITY(
336: l_api_name
337: ,p_init_msg_list
338: ,'_PVT'
339: ,x_return_status);

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

339: ,x_return_status);
340:
341: --Check if activity started successfully
342:
343: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;

Line 344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

340:
341: --Check if activity started successfully
342:
343: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:

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

341: --Check if activity started successfully
342:
343: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349: --asawanka ebtax changes start

Line 346: RAISE OKL_API.G_EXCEPTION_ERROR;

342:
343: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349: --asawanka ebtax changes start
350:

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

350:
351: OPEN c_get_entered_alc_trx(p_loc_rec.parent_line_id);
352: FETCH c_get_entered_alc_trx INTO l_entered;
353: IF c_get_entered_alc_trx%FOUND THEN
354: OKL_API.set_message( p_app_name => 'OKL',
355: p_msg_name => 'OKL_ASTLOC_CHNG_NA_ENT');
356: RAISE OKL_API.G_EXCEPTION_ERROR;
357: END IF;
358:

Line 356: RAISE OKL_API.G_EXCEPTION_ERROR;

352: FETCH c_get_entered_alc_trx INTO l_entered;
353: IF c_get_entered_alc_trx%FOUND THEN
354: OKL_API.set_message( p_app_name => 'OKL',
355: p_msg_name => 'OKL_ASTLOC_CHNG_NA_ENT');
356: RAISE OKL_API.G_EXCEPTION_ERROR;
357: END IF;
358:
359: OPEN c_get_chr_id(p_loc_rec.parent_line_id);
360: FETCH c_get_chr_id INTO l_chr_id,l_org_id ,l_currency_code;

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

365: CLOSE c_bill_upfront_tax;
366:
367: IF l_bill_upfront_tax IS NOT NULL THEN
368: IF l_bill_upfront_tax <> 'BILLED' THEN
369: OKL_API.set_message( p_app_name => 'OKL',
370: p_msg_name => 'OKL_ASTLOC_CHNG_NA_AST');
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373: ELSE

Line 371: RAISE OKL_API.G_EXCEPTION_ERROR;

367: IF l_bill_upfront_tax IS NOT NULL THEN
368: IF l_bill_upfront_tax <> 'BILLED' THEN
369: OKL_API.set_message( p_app_name => 'OKL',
370: p_msg_name => 'OKL_ASTLOC_CHNG_NA_AST');
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373: ELSE
374: -- dcshanmu bug 6673102 start
375: OPEN c_upfront_tax_calc(l_chr_id);

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

379: OPEN c_asset_upfront_tax(l_chr_id);
380: FETCH c_asset_upfront_tax INTO l_asset_upfront_tax;
381: CLOSE c_asset_upfront_tax;
382: IF l_asset_upfront_tax IS NULL OR l_asset_upfront_tax <> 'BILLED' THEN
383: OKL_API.set_message( p_app_name => 'OKL',
384: p_msg_name => 'OKL_ASTLOC_CHNG_NA_KHR');
385: RAISE OKL_API.G_EXCEPTION_ERROR;
386: END IF;
387: -- dcshanmu bug 6673102 start

Line 385: RAISE OKL_API.G_EXCEPTION_ERROR;

381: CLOSE c_asset_upfront_tax;
382: IF l_asset_upfront_tax IS NULL OR l_asset_upfront_tax <> 'BILLED' THEN
383: OKL_API.set_message( p_app_name => 'OKL',
384: p_msg_name => 'OKL_ASTLOC_CHNG_NA_KHR');
385: RAISE OKL_API.G_EXCEPTION_ERROR;
386: END IF;
387: -- dcshanmu bug 6673102 start
388: END IF;
389: CLOSE c_upfront_tax_calc;

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

408:
409: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
410: x_try_id => l_try_id);
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;

Line 413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

409: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
410: x_try_id => l_try_id);
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417:

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

410: x_try_id => l_try_id);
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417:
418: l_trqv_rec.request_status_code := 'ENTERED';

Line 415: RAISE OKL_API.G_EXCEPTION_ERROR;

411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417:
418: l_trqv_rec.request_status_code := 'ENTERED';
419: l_trqv_rec.request_type_code := 'ASSET_RELOCATION';

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

430: x_msg_count => x_msg_count,
431: x_msg_data => x_msg_data,
432: p_trqv_rec => l_trqv_rec,
433: x_trqv_rec => x_trqv_rec);
434: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
436: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_ERROR;
438: END IF;

Line 435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

431: x_msg_data => x_msg_data,
432: p_trqv_rec => l_trqv_rec,
433: x_trqv_rec => x_trqv_rec);
434: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
436: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_ERROR;
438: END IF;
439:

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

432: p_trqv_rec => l_trqv_rec,
433: x_trqv_rec => x_trqv_rec);
434: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
436: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_ERROR;
438: END IF;
439:
440: G_CTR := 1;

Line 437: RAISE OKL_API.G_EXCEPTION_ERROR;

433: x_trqv_rec => x_trqv_rec);
434: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
436: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
437: RAISE OKL_API.G_EXCEPTION_ERROR;
438: END IF;
439:
440: G_CTR := 1;
441: --asawanka ebtax changes end

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

480: x_itiv_rec => l_out_rec
481: );
482:
483:
484: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_ERROR;
488: END IF;

Line 485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

481: );
482:
483:
484: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_ERROR;
488: END IF;
489:

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

482:
483:
484: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_ERROR;
488: END IF;
489:
490: IF l_serialized_yn = 'Y' AND G_CTR = 1 THEN

Line 487: RAISE OKL_API.G_EXCEPTION_ERROR;

483:
484: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_ERROR;
488: END IF;
489:
490: IF l_serialized_yn = 'Y' AND G_CTR = 1 THEN
491: IF G_CTR = l_ser_count THEN

Line 534: OKL_API.END_ACTIVITY (x_msg_count,

530: END LOOP;
531: G_CTR := G_CTR + 1;
532: END LOOP;
533:
534: OKL_API.END_ACTIVITY (x_msg_count,
535: x_msg_data );
536: EXCEPTION
537: WHEN OKL_API.G_EXCEPTION_ERROR THEN
538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 537: WHEN OKL_API.G_EXCEPTION_ERROR THEN

533:
534: OKL_API.END_ACTIVITY (x_msg_count,
535: x_msg_data );
536: EXCEPTION
537: WHEN OKL_API.G_EXCEPTION_ERROR THEN
538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
539: l_api_name,
540: G_PKG_NAME,
541: 'OKL_API.G_RET_STS_ERROR',

Line 538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

534: OKL_API.END_ACTIVITY (x_msg_count,
535: x_msg_data );
536: EXCEPTION
537: WHEN OKL_API.G_EXCEPTION_ERROR THEN
538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
539: l_api_name,
540: G_PKG_NAME,
541: 'OKL_API.G_RET_STS_ERROR',
542: x_msg_count,

Line 541: 'OKL_API.G_RET_STS_ERROR',

537: WHEN OKL_API.G_EXCEPTION_ERROR THEN
538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
539: l_api_name,
540: G_PKG_NAME,
541: 'OKL_API.G_RET_STS_ERROR',
542: x_msg_count,
543: x_msg_data,
544: '_PVT');
545: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 545: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

541: 'OKL_API.G_RET_STS_ERROR',
542: x_msg_count,
543: x_msg_data,
544: '_PVT');
545: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
546: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 546: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

542: x_msg_count,
543: x_msg_data,
544: '_PVT');
545: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
546: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_UNEXP_ERROR',
550: x_msg_count,

Line 549: 'OKL_API.G_RET_STS_UNEXP_ERROR',

545: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
546: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_UNEXP_ERROR',
550: x_msg_count,
551: x_msg_data,
552: '_PVT');
553: WHEN OTHERS THEN

Line 554: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

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

Line 566: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

562: END update_location;
563:
564: PROCEDURE create_txl_itm_insts(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
567: x_return_status OUT NOCOPY VARCHAR2,
568: x_msg_count OUT NOCOPY NUMBER,
569: x_msg_data OUT NOCOPY VARCHAR2,
570: p_date_from IN DATE,

Line 580: x_return_status := OKL_API.G_RET_STS_SUCCESS;

576: l_trxv_rec trxv_rec_type;
577: lm_itiv_rec itiv_rec_type;
578: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ITM_INSTS';
579: BEGIN
580: x_return_status := OKL_API.G_RET_STS_SUCCESS;
581: -- Call start_activity to create savepoint, check compatibility
582: -- and initialize message list
583: x_return_status := OKL_API.START_ACTIVITY (
584: l_api_name

Line 583: x_return_status := OKL_API.START_ACTIVITY (

579: BEGIN
580: x_return_status := OKL_API.G_RET_STS_SUCCESS;
581: -- Call start_activity to create savepoint, check compatibility
582: -- and initialize message list
583: x_return_status := OKL_API.START_ACTIVITY (
584: l_api_name
585: ,p_init_msg_list
586: ,'_PVT'
587: ,x_return_status);

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

585: ,p_init_msg_list
586: ,'_PVT'
587: ,x_return_status);
588: -- Check if activity started successfully
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;

Line 590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

586: ,'_PVT'
587: ,x_return_status);
588: -- Check if activity started successfully
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: -- Create New Header record and new Line record

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

587: ,x_return_status);
588: -- Check if activity started successfully
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: -- Create New Header record and new Line record
595: -- Before creating Header record

Line 592: RAISE OKL_API.G_EXCEPTION_ERROR;

588: -- Check if activity started successfully
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: -- Create New Header record and new Line record
595: -- Before creating Header record
596: -- we should make sure atleast the required record is given

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

600: x_return_status := get_try_id(p_try_name => G_TRY_NAME,
601: x_try_id => l_trxv_rec.try_id);
602:
603:
604: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;

Line 605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

601: x_try_id => l_trxv_rec.try_id);
602:
603:
604: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:

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

602:
603:
604: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: l_trxv_rec.tsu_code := 'ENTERED';

Line 607: RAISE OKL_API.G_EXCEPTION_ERROR;

603:
604: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: l_trxv_rec.tsu_code := 'ENTERED';
611: l_trxv_rec.date_trans_occurred := p_date_from;

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

619: x_msg_data => x_msg_data,
620: p_trxv_rec => l_trxv_rec,
621: x_trxv_rec => x_trxv_rec);
622:
623: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
624: l_trxv_rec := x_trxv_rec;
625: l_trxv_rec.tsu_code := 'ERROR';
626: Update_asset_header(p_api_version => p_api_version,
627: p_init_msg_list => p_init_msg_list,

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

630: x_msg_data => x_msg_data,
631: p_trxv_rec => l_trxv_rec,
632: x_trxv_rec => x_trxv_rec);
633:
634: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_ERROR;
638: END IF;

Line 635: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

631: p_trxv_rec => l_trxv_rec,
632: x_trxv_rec => x_trxv_rec);
633:
634: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_ERROR;
638: END IF;
639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

Line 637: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

636: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_ERROR;
638: END IF;
639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
641: l_trxv_rec := x_trxv_rec;
642: l_trxv_rec.tsu_code := 'ERROR';
643:
644:

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

648: x_msg_count => x_msg_count,
649: x_msg_data => x_msg_data,
650: p_trxv_rec => l_trxv_rec,
651: x_trxv_rec => x_trxv_rec);
652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_ERROR;
656: END IF;

Line 653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

649: x_msg_data => x_msg_data,
650: p_trxv_rec => l_trxv_rec,
651: x_trxv_rec => x_trxv_rec);
652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_ERROR;
656: END IF;
657: RAISE OKL_API.G_EXCEPTION_ERROR;

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

650: p_trxv_rec => l_trxv_rec,
651: x_trxv_rec => x_trxv_rec);
652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_ERROR;
656: END IF;
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;

Line 655: RAISE OKL_API.G_EXCEPTION_ERROR;

651: x_trxv_rec => x_trxv_rec);
652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_ERROR;
656: END IF;
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659: -- Now we are creating the new line record

Line 657: RAISE OKL_API.G_EXCEPTION_ERROR;

653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_ERROR;
656: END IF;
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659: -- Now we are creating the new line record
660: lm_itiv_rec := p_itiv_rec;
661: lm_itiv_rec.tas_id := x_trxv_rec.id;

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

658: END IF;
659: -- Now we are creating the new line record
660: lm_itiv_rec := p_itiv_rec;
661: lm_itiv_rec.tas_id := x_trxv_rec.id;
662: IF (lm_itiv_rec.tal_type = OKL_API.G_MISS_CHAR OR
663: lm_itiv_rec.tal_type IS NUll) THEN
664: lm_itiv_rec.tal_type := 'AGL';
665: END IF;
666:

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

683: x_iipv_rec => x_itiv_rec);
684:
685:
686:
687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;

Line 688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

684:
685:
686:
687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692: OKL_API.END_ACTIVITY (x_msg_count,

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

685:
686:
687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692: OKL_API.END_ACTIVITY (x_msg_count,
693: x_msg_data );

Line 690: RAISE OKL_API.G_EXCEPTION_ERROR;

686:
687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692: OKL_API.END_ACTIVITY (x_msg_count,
693: x_msg_data );
694: EXCEPTION

Line 692: OKL_API.END_ACTIVITY (x_msg_count,

688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692: OKL_API.END_ACTIVITY (x_msg_count,
693: x_msg_data );
694: EXCEPTION
695: WHEN OKL_API.G_EXCEPTION_ERROR THEN
696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 695: WHEN OKL_API.G_EXCEPTION_ERROR THEN

691: END IF;
692: OKL_API.END_ACTIVITY (x_msg_count,
693: x_msg_data );
694: EXCEPTION
695: WHEN OKL_API.G_EXCEPTION_ERROR THEN
696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
697: l_api_name,
698: G_PKG_NAME,
699: 'OKL_API.G_RET_STS_ERROR',

Line 696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

692: OKL_API.END_ACTIVITY (x_msg_count,
693: x_msg_data );
694: EXCEPTION
695: WHEN OKL_API.G_EXCEPTION_ERROR THEN
696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
697: l_api_name,
698: G_PKG_NAME,
699: 'OKL_API.G_RET_STS_ERROR',
700: x_msg_count,

Line 699: 'OKL_API.G_RET_STS_ERROR',

695: WHEN OKL_API.G_EXCEPTION_ERROR THEN
696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
697: l_api_name,
698: G_PKG_NAME,
699: 'OKL_API.G_RET_STS_ERROR',
700: x_msg_count,
701: x_msg_data,
702: '_PVT');
703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

699: 'OKL_API.G_RET_STS_ERROR',
700: x_msg_count,
701: x_msg_data,
702: '_PVT');
703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

700: x_msg_count,
701: x_msg_data,
702: '_PVT');
703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_UNEXP_ERROR',
708: x_msg_count,

Line 707: 'OKL_API.G_RET_STS_UNEXP_ERROR',

703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_UNEXP_ERROR',
708: x_msg_count,
709: x_msg_data,
710: '_PVT');
711: WHEN OTHERS THEN

Line 712: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

708: x_msg_count,
709: x_msg_data,
710: '_PVT');
711: WHEN OTHERS THEN
712: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
713: l_api_name,
714: G_PKG_NAME,
715: 'OTHERS',
716: x_msg_count,

Line 723: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

719: END create_txl_itm_insts;
720:
721: PROCEDURE Create_asset_header(
722: p_api_version IN NUMBER,
723: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,
726: x_msg_data OUT NOCOPY VARCHAR2,
727: p_trxv_rec IN trxv_rec_type,

Line 731: x_return_status := OKL_API.G_RET_STS_SUCCESS;

727: p_trxv_rec IN trxv_rec_type,
728: x_trxv_rec OUT NOCOPY trxv_rec_type) IS
729: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TRX_ASSET_HEADER';
730: BEGIN
731: x_return_status := OKL_API.G_RET_STS_SUCCESS;
732: -- Call start_activity to create savepoint, check compatibility
733: -- and initialize message list
734: x_return_status := OKL_API.START_ACTIVITY (
735: l_api_name

Line 734: x_return_status := OKL_API.START_ACTIVITY (

730: BEGIN
731: x_return_status := OKL_API.G_RET_STS_SUCCESS;
732: -- Call start_activity to create savepoint, check compatibility
733: -- and initialize message list
734: x_return_status := OKL_API.START_ACTIVITY (
735: l_api_name
736: ,p_init_msg_list
737: ,'_PVT'
738: ,x_return_status);

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

736: ,p_init_msg_list
737: ,'_PVT'
738: ,x_return_status);
739: -- Check if activity started successfully
740: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;

Line 741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

737: ,'_PVT'
738: ,x_return_status);
739: -- Check if activity started successfully
740: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: -- evaluate conditions, build outcomes for true conditions and

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

738: ,x_return_status);
739: -- Check if activity started successfully
740: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: -- evaluate conditions, build outcomes for true conditions and
746: -- put them on outcome queue

Line 743: RAISE OKL_API.G_EXCEPTION_ERROR;

739: -- Check if activity started successfully
740: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: -- evaluate conditions, build outcomes for true conditions and
746: -- put them on outcome queue
747: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

Line 755: OKL_API.END_ACTIVITY (x_msg_count,

751: x_msg_count => x_msg_count,
752: x_msg_data => x_msg_data,
753: p_thpv_rec => p_trxv_rec,
754: x_thpv_rec => x_trxv_rec);
755: OKL_API.END_ACTIVITY (x_msg_count,
756: x_msg_data );
757: EXCEPTION
758: WHEN OKL_API.G_EXCEPTION_ERROR THEN
759: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 758: WHEN OKL_API.G_EXCEPTION_ERROR THEN

754: x_thpv_rec => x_trxv_rec);
755: OKL_API.END_ACTIVITY (x_msg_count,
756: x_msg_data );
757: EXCEPTION
758: WHEN OKL_API.G_EXCEPTION_ERROR THEN
759: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
760: l_api_name,
761: G_PKG_NAME,
762: 'OKL_API.G_RET_STS_ERROR',

Line 759: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

755: OKL_API.END_ACTIVITY (x_msg_count,
756: x_msg_data );
757: EXCEPTION
758: WHEN OKL_API.G_EXCEPTION_ERROR THEN
759: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
760: l_api_name,
761: G_PKG_NAME,
762: 'OKL_API.G_RET_STS_ERROR',
763: x_msg_count,

Line 762: 'OKL_API.G_RET_STS_ERROR',

758: WHEN OKL_API.G_EXCEPTION_ERROR THEN
759: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
760: l_api_name,
761: G_PKG_NAME,
762: 'OKL_API.G_RET_STS_ERROR',
763: x_msg_count,
764: x_msg_data,
765: '_PVT');
766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

762: 'OKL_API.G_RET_STS_ERROR',
763: x_msg_count,
764: x_msg_data,
765: '_PVT');
766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
767: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
768: l_api_name,
769: G_PKG_NAME,
770: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 767: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

763: x_msg_count,
764: x_msg_data,
765: '_PVT');
766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
767: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
768: l_api_name,
769: G_PKG_NAME,
770: 'OKL_API.G_RET_STS_UNEXP_ERROR',
771: x_msg_count,

Line 770: 'OKL_API.G_RET_STS_UNEXP_ERROR',

766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
767: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
768: l_api_name,
769: G_PKG_NAME,
770: 'OKL_API.G_RET_STS_UNEXP_ERROR',
771: x_msg_count,
772: x_msg_data,
773: '_PVT');
774: WHEN OTHERS THEN

Line 775: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

771: x_msg_count,
772: x_msg_data,
773: '_PVT');
774: WHEN OTHERS THEN
775: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
776: l_api_name,
777: G_PKG_NAME,
778: 'OTHERS',
779: x_msg_count,

Line 786: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

782: END Create_asset_header;
783:
784: PROCEDURE Update_asset_header(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
787: x_return_status OUT NOCOPY VARCHAR2,
788: x_msg_count OUT NOCOPY NUMBER,
789: x_msg_data OUT NOCOPY VARCHAR2,
790: p_trxv_rec IN trxv_rec_type,

Line 794: x_return_status := OKL_API.G_RET_STS_SUCCESS;

790: p_trxv_rec IN trxv_rec_type,
791: x_trxv_rec OUT NOCOPY trxv_rec_type) IS
792: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_ASSET_HEADER';
793: BEGIN
794: x_return_status := OKL_API.G_RET_STS_SUCCESS;
795: -- Call start_activity to create savepoint, check compatibility
796: -- and initialize message list
797: x_return_status := OKL_API.START_ACTIVITY (
798: l_api_name

Line 797: x_return_status := OKL_API.START_ACTIVITY (

793: BEGIN
794: x_return_status := OKL_API.G_RET_STS_SUCCESS;
795: -- Call start_activity to create savepoint, check compatibility
796: -- and initialize message list
797: x_return_status := OKL_API.START_ACTIVITY (
798: l_api_name
799: ,p_init_msg_list
800: ,'_PVT'
801: ,x_return_status);

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

799: ,p_init_msg_list
800: ,'_PVT'
801: ,x_return_status);
802: -- Check if activity started successfully
803: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_ERROR;
807: END IF;

Line 804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

800: ,'_PVT'
801: ,x_return_status);
802: -- Check if activity started successfully
803: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_ERROR;
807: END IF;
808: -- evaluate conditions, build outcomes for true conditions and

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

801: ,x_return_status);
802: -- Check if activity started successfully
803: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_ERROR;
807: END IF;
808: -- evaluate conditions, build outcomes for true conditions and
809: -- put them on outcome queue

Line 806: RAISE OKL_API.G_EXCEPTION_ERROR;

802: -- Check if activity started successfully
803: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_ERROR;
807: END IF;
808: -- evaluate conditions, build outcomes for true conditions and
809: -- put them on outcome queue
810: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

Line 818: OKL_API.END_ACTIVITY (x_msg_count,

814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data,
816: p_thpv_rec => p_trxv_rec,
817: x_thpv_rec => x_trxv_rec);
818: OKL_API.END_ACTIVITY (x_msg_count,
819: x_msg_data );
820: EXCEPTION
821: WHEN OKL_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 821: WHEN OKL_API.G_EXCEPTION_ERROR THEN

817: x_thpv_rec => x_trxv_rec);
818: OKL_API.END_ACTIVITY (x_msg_count,
819: x_msg_data );
820: EXCEPTION
821: WHEN OKL_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
823: l_api_name,
824: G_PKG_NAME,
825: 'OKL_API.G_RET_STS_ERROR',

Line 822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

818: OKL_API.END_ACTIVITY (x_msg_count,
819: x_msg_data );
820: EXCEPTION
821: WHEN OKL_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
823: l_api_name,
824: G_PKG_NAME,
825: 'OKL_API.G_RET_STS_ERROR',
826: x_msg_count,

Line 825: 'OKL_API.G_RET_STS_ERROR',

821: WHEN OKL_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
823: l_api_name,
824: G_PKG_NAME,
825: 'OKL_API.G_RET_STS_ERROR',
826: x_msg_count,
827: x_msg_data,
828: '_PVT');
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

825: 'OKL_API.G_RET_STS_ERROR',
826: x_msg_count,
827: x_msg_data,
828: '_PVT');
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
831: l_api_name,
832: G_PKG_NAME,
833: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 830: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

826: x_msg_count,
827: x_msg_data,
828: '_PVT');
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
831: l_api_name,
832: G_PKG_NAME,
833: 'OKL_API.G_RET_STS_UNEXP_ERROR',
834: x_msg_count,

Line 833: 'OKL_API.G_RET_STS_UNEXP_ERROR',

829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
831: l_api_name,
832: G_PKG_NAME,
833: 'OKL_API.G_RET_STS_UNEXP_ERROR',
834: x_msg_count,
835: x_msg_data,
836: '_PVT');
837: WHEN OTHERS THEN

Line 838: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

834: x_msg_count,
835: x_msg_data,
836: '_PVT');
837: WHEN OTHERS THEN
838: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
839: l_api_name,
840: G_PKG_NAME,
841: 'OTHERS',
842: x_msg_count,

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

947: x_return_status OUT NOCOPY VARCHAR2,
948: x_msg_count OUT NOCOPY NUMBER,
949: x_msg_data OUT NOCOPY VARCHAR2)
950: IS
951: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: l_api_name CONSTANT VARCHAR2(30) := 'Update_Location';
953: l_api_version CONSTANT NUMBER := 1;
954: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
955: i NUMBER;

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

950: IS
951: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: l_api_name CONSTANT VARCHAR2(30) := 'Update_Location';
953: l_api_version CONSTANT NUMBER := 1;
954: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
955: i NUMBER;
956: BEGIN
957: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
958: G_PKG_NAME,

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

953: l_api_version CONSTANT NUMBER := 1;
954: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
955: i NUMBER;
956: BEGIN
957: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
958: G_PKG_NAME,
959: p_init_msg_list,
960: l_api_version,
961: p_api_version,

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

961: p_api_version,
962: '_PVT',
963: x_return_status);
964: -- check if activity started successfully
965: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
966: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
968: raise OKL_API.G_EXCEPTION_ERROR;
969: End If;

Line 966: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

962: '_PVT',
963: x_return_status);
964: -- check if activity started successfully
965: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
966: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
968: raise OKL_API.G_EXCEPTION_ERROR;
969: End If;
970: -- Make sure PL/SQL table has records in it before passing

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

963: x_return_status);
964: -- check if activity started successfully
965: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
966: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
968: raise OKL_API.G_EXCEPTION_ERROR;
969: End If;
970: -- Make sure PL/SQL table has records in it before passing
971: IF (p_loc_tbl.COUNT > 0) THEN

Line 968: raise OKL_API.G_EXCEPTION_ERROR;

964: -- check if activity started successfully
965: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
966: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
968: raise OKL_API.G_EXCEPTION_ERROR;
969: End If;
970: -- Make sure PL/SQL table has records in it before passing
971: IF (p_loc_tbl.COUNT > 0) THEN
972: i := p_loc_tbl.FIRST;

Line 995: p_init_msg_list => OKL_API.G_FALSE,

991: END IF;
992: LOOP
993: update_location (
994: p_api_version => l_api_version,
995: p_init_msg_list => OKL_API.G_FALSE,
996: x_return_status => x_return_status,
997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,
999: p_loc_rec => p_loc_tbl(i));

Line 1001: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,
999: p_loc_rec => p_loc_tbl(i));
1000: -- store the highest degree of error
1001: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1002: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1003: l_overall_status := x_return_status;
1004: End If;
1005: End If;

Line 1002: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

998: x_msg_data => x_msg_data,
999: p_loc_rec => p_loc_tbl(i));
1000: -- store the highest degree of error
1001: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1002: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1003: l_overall_status := x_return_status;
1004: End If;
1005: End If;
1006: EXIT WHEN (i = p_loc_tbl.LAST);

Line 1012: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1008: END LOOP;
1009: -- return overall status
1010: x_return_status := l_overall_status;
1011: END IF;
1012: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1015: raise OKL_API.G_EXCEPTION_ERROR;
1016: End If;

Line 1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1009: -- return overall status
1010: x_return_status := l_overall_status;
1011: END IF;
1012: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1015: raise OKL_API.G_EXCEPTION_ERROR;
1016: End If;
1017: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

Line 1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1010: x_return_status := l_overall_status;
1011: END IF;
1012: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1015: raise OKL_API.G_EXCEPTION_ERROR;
1016: End If;
1017: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1015: raise OKL_API.G_EXCEPTION_ERROR;

1011: END IF;
1012: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1015: raise OKL_API.G_EXCEPTION_ERROR;
1016: End If;
1017: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');

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

1013: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1015: raise OKL_API.G_EXCEPTION_ERROR;
1016: End If;
1017: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');
1020: END IF;
1021: EXCEPTION

Line 1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');
1020: END IF;
1021: EXCEPTION
1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1025: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1026: END IF;

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

1021: EXCEPTION
1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1025: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1026: END IF;
1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1027: x_return_status := OKL_API.G_RET_STS_ERROR;

1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1025: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1026: END IF;
1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1031: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 1028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1024: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1025: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1026: END IF;
1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1031: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1032: END IF;

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

1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1031: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1032: END IF;
1033: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1034: WHEN OTHERS THEN
1035: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1033: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1031: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1032: END IF;
1033: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1034: WHEN OTHERS THEN
1035: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1037: 'EXCEPTION :'||sqlerrm);

Line 1039: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1035: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1037: 'EXCEPTION :'||sqlerrm);
1038: END IF;
1039: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1040: -- unexpected error
1041: OKL_API.set_message(p_app_name => g_app_name,
1042: p_msg_name => g_unexpected_error,
1043: p_token1 => g_sqlcode_token,

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

1037: 'EXCEPTION :'||sqlerrm);
1038: END IF;
1039: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1040: -- unexpected error
1041: OKL_API.set_message(p_app_name => g_app_name,
1042: p_msg_name => g_unexpected_error,
1043: p_token1 => g_sqlcode_token,
1044: p_token1_value => sqlcode,
1045: p_token2 => g_sqlerrm_token,

Line 1138: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1134: BEGIN
1135:
1136: okl_debug_pub.logmessage('OKL: populate_account_data : START');
1137:
1138: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1139:
1140: l_acc_gen_primary_key_tbl(1).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
1141: OPEN fnd_pro_csr;
1142: FETCH fnd_pro_csr INTO fnd_pro_rec;

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

1192:
1193:
1194: okl_debug_pub.logmessage('OKL: populate_account_data : OKL_SECURITIZATION_PVT : '||x_return_status);
1195:
1196: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1197: THEN
1198: RAISE account_data_exception;
1199: END IF;
1200:

Line 1252: x_return_status := OKL_API.G_RET_STS_ERROR;

1248:
1249: EXCEPTION
1250: WHEN account_data_exception
1251: THEN
1252: x_return_status := OKL_API.G_RET_STS_ERROR;
1253:
1254: END populate_account_data;
1255:
1256: -- Start of comments

Line 1397: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1393: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','Begin(+)');
1395: END IF;
1396:
1397: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1398:
1399: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1400: THEN
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT

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

1407: FETCH acct_opt_csr INTO l_acct_opt;
1408:
1409: IF acct_opt_csr%NOTFOUND
1410: THEN
1411: OKL_API.set_message( p_app_name => G_APP_NAME,
1412: p_msg_name => 'OKL_LA_ST_ACCT_ERROR');
1413: CLOSE acct_opt_csr;
1414: RAISE upfront_tax_acct_exception;
1415: END IF;

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

1424: END IF;
1425:
1426: IF (l_acct_opt IS NULL)
1427: THEN
1428: OKL_API.set_message( p_app_name => G_APP_NAME,
1429: p_msg_name => 'OKL_LA_ST_ACCT_ERROR');
1430: RAISE upfront_tax_acct_exception;
1431: END IF;
1432:

Line 1451: Okl_Api.SET_MESSAGE( G_APP_NAME

1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1449: IF fnd_lookups_csr%NOTFOUND
1450: THEN
1451: Okl_Api.SET_MESSAGE( G_APP_NAME
1452: ,OKL_API.G_INVALID_VALUE
1453: ,'TRANSACTION_TYPE'
1454: ,'Upfront Tax');
1455: CLOSE fnd_lookups_csr;

Line 1452: ,OKL_API.G_INVALID_VALUE

1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1449: IF fnd_lookups_csr%NOTFOUND
1450: THEN
1451: Okl_Api.SET_MESSAGE( G_APP_NAME
1452: ,OKL_API.G_INVALID_VALUE
1453: ,'TRANSACTION_TYPE'
1454: ,'Upfront Tax');
1455: CLOSE fnd_lookups_csr;
1456: RAISE upfront_tax_acct_exception;

Line 1471: Okl_Api.SET_MESSAGE(G_APP_NAME,

1467: l_Trx_Type_rec := NULL;
1468: OPEN Transaction_Type_csr('Upfront Tax');
1469: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
1470: IF Transaction_Type_csr%NOTFOUND THEN
1471: Okl_Api.SET_MESSAGE(G_APP_NAME,
1472: OKL_API.G_INVALID_VALUE,
1473: 'TRANSACTION_TYPE',
1474: 'Upfront Tax');
1475: CLOSE Transaction_Type_csr;

Line 1472: OKL_API.G_INVALID_VALUE,

1468: OPEN Transaction_Type_csr('Upfront Tax');
1469: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
1470: IF Transaction_Type_csr%NOTFOUND THEN
1471: Okl_Api.SET_MESSAGE(G_APP_NAME,
1472: OKL_API.G_INVALID_VALUE,
1473: 'TRANSACTION_TYPE',
1474: 'Upfront Tax');
1475: CLOSE Transaction_Type_csr;
1476: RAISE upfront_tax_acct_exception;

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

1491: x_primary_sty_id => l_billed_sty_id);
1492:
1493: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: UPFRONT_TAX_BILLED : '||l_billed_sty_id);
1494:
1495: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1496: RAISE upfront_tax_acct_exception;
1497: End If;
1498:
1499: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)

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

1575: IF l_legal_entity_id IS NOT NULL THEN
1576: l_trxH_in_rec.legal_entity_id := l_legal_entity_id;
1577: ELSE
1578:
1579: Okl_Api.set_message(p_app_name => G_APP_NAME,
1580: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1581: p_token1 => 'CONTRACT_NUMBER',
1582: p_token1_value => l_contract_rec.contract_number);
1583: RAISE upfront_tax_acct_exception;

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

1601:
1602: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_trx_contracts : '||x_return_status);
1603:
1604: -- check transaction creation was successful
1605: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1606: THEN
1607: RAISE upfront_tax_acct_exception;
1608: END IF;
1609:

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

1643:
1644: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_trx_cntrct_lines : '||x_return_status);
1645:
1646: -- check transaction line creation was successful
1647: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1648: THEN
1649: RAISE upfront_tax_acct_exception;
1650: END IF;
1651:

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

1664:
1665: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: populate_account_data : '||x_return_status);
1666:
1667: -- check transaction line creation was successful
1668: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1669: THEN
1670: RAISE upfront_tax_acct_exception;
1671: END IF;
1672:

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

1693: p_trx_header_id => l_trxh_out_rec.id);
1694:
1695: okl_debug_pub.logmessage('OKL: create_upfront_tax_accounting Procedure: create_accounting_dist : '|| x_return_status);
1696:
1697: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
1698: THEN
1699: RAISE upfront_tax_acct_exception;
1700: END IF;
1701:

Line 1711: x_return_status := OKL_API.G_RET_STS_ERROR;

1707:
1708: EXCEPTION
1709: WHEN upfront_tax_acct_exception
1710: THEN
1711: x_return_status := OKL_API.G_RET_STS_ERROR;
1712:
1713: END create_upfront_tax_accounting;
1714: --Bug# 6619311 End
1715:

Line 1835: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1831: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1832: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_kle_id :'|| p_kle_id);
1833: END IF;
1834:
1835: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1836:
1837: --Call start_activity to create savepoint, check compatibility and initialize message list
1838:
1839: x_return_status := OKL_API.START_ACTIVITY(

Line 1839: x_return_status := OKL_API.START_ACTIVITY(

1835: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1836:
1837: --Call start_activity to create savepoint, check compatibility and initialize message list
1838:
1839: x_return_status := OKL_API.START_ACTIVITY(
1840: l_api_name
1841: ,p_init_msg_list
1842: ,'_PVT'
1843: ,x_return_status);

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

1843: ,x_return_status);
1844:
1845: --Check if activity started successfully
1846:
1847: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1850: RAISE OKL_API.G_EXCEPTION_ERROR;
1851: END IF;

Line 1848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1844:
1845: --Check if activity started successfully
1846:
1847: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1850: RAISE OKL_API.G_EXCEPTION_ERROR;
1851: END IF;
1852:

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

1845: --Check if activity started successfully
1846:
1847: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1850: RAISE OKL_API.G_EXCEPTION_ERROR;
1851: END IF;
1852:
1853: FOR l_c_free_form2 in c_free_form2(p_kle_id) LOOP

Line 1850: RAISE OKL_API.G_EXCEPTION_ERROR;

1846:
1847: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1850: RAISE OKL_API.G_EXCEPTION_ERROR;
1851: END IF;
1852:
1853: FOR l_c_free_form2 in c_free_form2(p_kle_id) LOOP
1854: FOR l_c_inst_item IN c_inst_item(l_c_free_form2.id) LOOP

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

1860:
1861: OPEN c_get_entered_alc_trx(l_c_inst_item.id);
1862: FETCH c_get_entered_alc_trx INTO l_trx_rec;
1863: IF c_get_entered_alc_trx%NOTFOUND THEN
1864: OKL_API.set_message( p_app_name => 'OKL',
1865: p_msg_name => 'OKL_ASTLOC_TRX_NF');
1866: RAISE OKL_API.G_EXCEPTION_ERROR;
1867: END IF;
1868: CLOSE c_get_entered_alc_trx;

Line 1866: RAISE OKL_API.G_EXCEPTION_ERROR;

1862: FETCH c_get_entered_alc_trx INTO l_trx_rec;
1863: IF c_get_entered_alc_trx%NOTFOUND THEN
1864: OKL_API.set_message( p_app_name => 'OKL',
1865: p_msg_name => 'OKL_ASTLOC_TRX_NF');
1866: RAISE OKL_API.G_EXCEPTION_ERROR;
1867: END IF;
1868: CLOSE c_get_entered_alc_trx;
1869:
1870: -- updating installed base item.

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

2073: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2074: RAISE OKC_API.G_EXCEPTION_ERROR;
2075: END IF;
2076: ELSE
2077: OKL_API.set_message( p_app_name => 'OKL',
2078: p_msg_name => 'OKL_ASTLOC_TAX_NOT_BILLED');
2079: END IF;
2080:
2081:

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

2091: p_trxv_rec => l_trxv_rec,
2092: x_trxv_rec => x_trxv_rec);
2093:
2094:
2095: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2098: RAISE OKL_API.G_EXCEPTION_ERROR;
2099: END IF;

Line 2096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2092: x_trxv_rec => x_trxv_rec);
2093:
2094:
2095: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2098: RAISE OKL_API.G_EXCEPTION_ERROR;
2099: END IF;
2100: END IF; -- If _ib_inst found

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

2093:
2094:
2095: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2098: RAISE OKL_API.G_EXCEPTION_ERROR;
2099: END IF;
2100: END IF; -- If _ib_inst found
2101: CLOSE c_ib_inst;

Line 2098: RAISE OKL_API.G_EXCEPTION_ERROR;

2094:
2095: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2098: RAISE OKL_API.G_EXCEPTION_ERROR;
2099: END IF;
2100: END IF; -- If _ib_inst found
2101: CLOSE c_ib_inst;
2102: END LOOP;

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

2114: x_msg_data => x_msg_data,
2115: p_trqv_rec => l_trqv_rec,
2116: x_trqv_rec => x_trqv_rec);
2117:
2118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;

Line 2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2115: p_trqv_rec => l_trqv_rec,
2116: x_trqv_rec => x_trqv_rec);
2117:
2118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;
2123:

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

2116: x_trqv_rec => x_trqv_rec);
2117:
2118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;
2123:
2124: END IF;

Line 2121: RAISE OKL_API.G_EXCEPTION_ERROR;

2117:
2118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;
2123:
2124: END IF;
2125: G_CTR := G_CTR + 1;

Line 2128: OKL_API.END_ACTIVITY (x_msg_count,

2124: END IF;
2125: G_CTR := G_CTR + 1;
2126: END LOOP;
2127:
2128: OKL_API.END_ACTIVITY (x_msg_count,
2129: x_msg_data );
2130: EXCEPTION
2131: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2131: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2127:
2128: OKL_API.END_ACTIVITY (x_msg_count,
2129: x_msg_data );
2130: EXCEPTION
2131: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: l_api_name,
2134: G_PKG_NAME,
2135: 'OKL_API.G_RET_STS_ERROR',

Line 2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2128: OKL_API.END_ACTIVITY (x_msg_count,
2129: x_msg_data );
2130: EXCEPTION
2131: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: l_api_name,
2134: G_PKG_NAME,
2135: 'OKL_API.G_RET_STS_ERROR',
2136: x_msg_count,

Line 2135: 'OKL_API.G_RET_STS_ERROR',

2131: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: l_api_name,
2134: G_PKG_NAME,
2135: 'OKL_API.G_RET_STS_ERROR',
2136: x_msg_count,
2137: x_msg_data,
2138: '_PVT');
2139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2135: 'OKL_API.G_RET_STS_ERROR',
2136: x_msg_count,
2137: x_msg_data,
2138: '_PVT');
2139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2140: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2141: l_api_name,
2142: G_PKG_NAME,
2143: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2140: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2136: x_msg_count,
2137: x_msg_data,
2138: '_PVT');
2139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2140: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2141: l_api_name,
2142: G_PKG_NAME,
2143: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2144: x_msg_count,

Line 2143: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2140: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2141: l_api_name,
2142: G_PKG_NAME,
2143: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2144: x_msg_count,
2145: x_msg_data,
2146: '_PVT');
2147: WHEN OTHERS THEN

Line 2148: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2144: x_msg_count,
2145: x_msg_data,
2146: '_PVT');
2147: WHEN OTHERS THEN
2148: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2149: l_api_name,
2150: G_PKG_NAME,
2151: 'OTHERS',
2152: x_msg_count,