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_CAF_PVT dependencies on OKC_API

Line 435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

431: ---------------------------------
432: PROCEDURE validate_id(
433: p_cafv_rec IN cafv_rec_type,
434: x_return_status OUT NOCOPY VARCHAR2) IS
435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
436: BEGIN
437:
438: IF (p_cafv_rec.id = OKL_API.G_MISS_NUM OR p_cafv_rec.id IS NULL)
439: THEN

Line 462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

458: -------------------------------------
459: PROCEDURE validate_cfo_id(
460: p_cafv_rec IN cafv_rec_type,
461: x_return_status OUT NOCOPY VARCHAR2) IS
462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
463:
464: l_dummy_var VARCHAR2(1) := '?' ;
465:
466: CURSOR okl_cafv_cfov_fk_csr (p_id IN NUMBER) IS

Line 483: OKC_API.set_message(g_app_name,

479: FETCH okl_cafv_cfov_fk_csr into l_dummy_var ;
480: CLOSE okl_cafv_cfov_fk_csr ;
481: -- still set to default means data was not found
482: IF ( l_dummy_var = '?' ) THEN
483: OKC_API.set_message(g_app_name,
484: g_no_parent_record,
485: g_col_name_token,
486: 'cfo_id',
487: g_child_table_token ,

Line 491: l_return_status := OKC_API.G_RET_STS_ERROR;

487: g_child_table_token ,
488: 'OKL_CASH_FLOWS_V',
489: g_parent_table_token ,
490: 'OKL_CASH_FLOW_OBJECTS_V');
491: l_return_status := OKC_API.G_RET_STS_ERROR;
492:
493: END IF;
494: END IF;
495: x_return_status := l_return_status;

Line 513: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

509: ---------------------------------------
510: PROCEDURE validate_sts_code(
511: p_cafv_rec IN cafv_rec_type,
512: x_return_status OUT NOCOPY VARCHAR2) IS
513: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
514:
515: l_dummy_var VARCHAR2(1) := '?' ;
516:
517: CURSOR okl_cafv_sts_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 535: OKC_API.set_message(g_app_name,

531: FETCH okl_cafv_sts_fk_csr into l_dummy_var ;
532: CLOSE okl_cafv_sts_fk_csr ;
533: -- still set to default means data was not found
534: IF ( l_dummy_var = '?' ) THEN
535: OKC_API.set_message(g_app_name,
536: g_no_parent_record,
537: g_col_name_token,
538: 'sts_code',
539: g_child_table_token ,

Line 543: l_return_status := OKC_API.G_RET_STS_ERROR;

539: g_child_table_token ,
540: 'OKL_CASH_FLOWS_V',
541: g_parent_table_token ,
542: 'FND_LOOKUP_VALUES');
543: l_return_status := OKC_API.G_RET_STS_ERROR;
544:
545: END IF;
546: END IF;
547: x_return_status := l_return_status;

Line 566: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

562: -------------------------------------
563: PROCEDURE validate_sty_id(
564: p_cafv_rec IN cafv_rec_type,
565: x_return_status OUT NOCOPY VARCHAR2) IS
566: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
567:
568: l_dummy_var VARCHAR2(1) := '?' ;
569:
570: CURSOR okl_cafv_styv_fk_csr (p_id IN NUMBER) IS

Line 585: OKC_API.set_message(g_app_name,

581: FETCH okl_cafv_styv_fk_csr into l_dummy_var ;
582: CLOSE okl_cafv_styv_fk_csr ;
583: -- still set to default means data was not found
584: IF ( l_dummy_var = '?' ) THEN
585: OKC_API.set_message(g_app_name,
586: g_no_parent_record,
587: g_col_name_token,
588: 'sty_id',
589: g_child_table_token ,

Line 593: l_return_status := OKC_API.G_RET_STS_ERROR;

589: g_child_table_token ,
590: 'OKL_CASH_FLOWS_V',
591: g_parent_table_token ,
592: 'OKL_STRM_TYPE_V');
593: l_return_status := OKC_API.G_RET_STS_ERROR;
594:
595: END IF;
596: END IF;
597: x_return_status := l_return_status;

Line 615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

611: ---------------------------------------
612: PROCEDURE validate_cft_code(
613: p_cafv_rec IN cafv_rec_type,
614: x_return_status OUT NOCOPY VARCHAR2) IS
615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
616:
617: l_dummy_var VARCHAR2(1) := '?' ;
618:
619: CURSOR okl_cafv_cft_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 638: OKC_API.set_message(g_app_name,

634: FETCH okl_cafv_cft_fk_csr into l_dummy_var ;
635: CLOSE okl_cafv_cft_fk_csr ;
636: -- still set to default means data was not found
637: IF ( l_dummy_var = '?' ) THEN
638: OKC_API.set_message(g_app_name,
639: g_no_parent_record,
640: g_col_name_token,
641: 'cft_code',
642: g_child_table_token ,

Line 646: l_return_status := OKC_API.G_RET_STS_ERROR;

642: g_child_table_token ,
643: 'OKL_CASH_FLOWS_V',
644: g_parent_table_token ,
645: 'FND_LOOKUP_VALUES');
646: l_return_status := OKC_API.G_RET_STS_ERROR;
647:
648: END IF;
649: END IF;
650: x_return_status := l_return_status;

Line 668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

664: -----------------------------------------
665: PROCEDURE validate_start_date(
666: p_cafv_rec IN cafv_rec_type,
667: x_return_status OUT NOCOPY VARCHAR2) IS
668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
669: BEGIN
670:
671: IF (p_cafv_rec.start_date = OKL_API.G_MISS_DATE OR p_cafv_rec.start_date IS NULL)
672: THEN

Line 708: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

704: -- ***
705: -- id
706: -- ***
707: validate_id(p_cafv_rec, l_return_status);
708: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
709: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
710: x_return_status := l_return_status;
711: RAISE G_EXCEPTION_HALT_VALIDATION;
712: ELSE

Line 709: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

705: -- id
706: -- ***
707: validate_id(p_cafv_rec, l_return_status);
708: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
709: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
710: x_return_status := l_return_status;
711: RAISE G_EXCEPTION_HALT_VALIDATION;
712: ELSE
713: x_return_status := l_return_status;

Line 723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

719: -- ***
720: -- cfo_id
721: -- ***
722: validate_cfo_id(p_cafv_rec, l_return_status);
723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: x_return_status := l_return_status;
726: RAISE G_EXCEPTION_HALT_VALIDATION;
727: ELSE

Line 724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

720: -- cfo_id
721: -- ***
722: validate_cfo_id(p_cafv_rec, l_return_status);
723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: x_return_status := l_return_status;
726: RAISE G_EXCEPTION_HALT_VALIDATION;
727: ELSE
728: x_return_status := l_return_status;

Line 738: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

734: -- ***
735: -- sts_code
736: -- ***
737: validate_sts_code(p_cafv_rec, l_return_status);
738: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
739: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
740: x_return_status := l_return_status;
741: RAISE G_EXCEPTION_HALT_VALIDATION;
742: ELSE

Line 739: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

735: -- sts_code
736: -- ***
737: validate_sts_code(p_cafv_rec, l_return_status);
738: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
739: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
740: x_return_status := l_return_status;
741: RAISE G_EXCEPTION_HALT_VALIDATION;
742: ELSE
743: x_return_status := l_return_status;

Line 752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

748: -- ***
749: -- sty_id
750: -- ***
751: validate_sty_id(p_cafv_rec, l_return_status);
752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
754: x_return_status := l_return_status;
755: RAISE G_EXCEPTION_HALT_VALIDATION;
756: ELSE

Line 753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

749: -- sty_id
750: -- ***
751: validate_sty_id(p_cafv_rec, l_return_status);
752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
754: x_return_status := l_return_status;
755: RAISE G_EXCEPTION_HALT_VALIDATION;
756: ELSE
757: x_return_status := l_return_status;

Line 767: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

763: -- ***
764: -- cft_code
765: -- ***
766: validate_cft_code(p_cafv_rec, l_return_status);
767: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
768: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
769: x_return_status := l_return_status;
770: RAISE G_EXCEPTION_HALT_VALIDATION;
771: ELSE

Line 768: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

764: -- cft_code
765: -- ***
766: validate_cft_code(p_cafv_rec, l_return_status);
767: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
768: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
769: x_return_status := l_return_status;
770: RAISE G_EXCEPTION_HALT_VALIDATION;
771: ELSE
772: x_return_status := l_return_status;

Line 782: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

778: -- ***
779: -- start_date
780: -- ***
781: validate_start_date(p_cafv_rec, l_return_status);
782: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
784: x_return_status := l_return_status;
785: RAISE G_EXCEPTION_HALT_VALIDATION;
786: ELSE

Line 783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

779: -- start_date
780: -- ***
781: validate_start_date(p_cafv_rec, l_return_status);
782: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
784: x_return_status := l_return_status;
785: RAISE G_EXCEPTION_HALT_VALIDATION;
786: ELSE
787: x_return_status := l_return_status;