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

Line 669: IF (l_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN

665: IF (l_pflv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
666: l_pflv_rec.last_update_login := NULL;
667: END IF;
668: -- RABHUPAT - 2667636 -Start
669: IF (l_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN
670: l_pflv_rec.currency_code := NULL;
671: END IF;
672: IF (l_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
673: l_pflv_rec.currency_conversion_code := NULL;

Line 672: IF (l_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN

668: -- RABHUPAT - 2667636 -Start
669: IF (l_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN
670: l_pflv_rec.currency_code := NULL;
671: END IF;
672: IF (l_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
673: l_pflv_rec.currency_conversion_code := NULL;
674: END IF;
675: IF (l_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
676: l_pflv_rec.currency_conversion_type := NULL;

Line 675: IF (l_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN

671: END IF;
672: IF (l_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
673: l_pflv_rec.currency_conversion_code := NULL;
674: END IF;
675: IF (l_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
676: l_pflv_rec.currency_conversion_type := NULL;
677: END IF;
678: IF (l_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
679: l_pflv_rec.currency_conversion_rate := NULL;

Line 678: IF (l_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN

674: END IF;
675: IF (l_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
676: l_pflv_rec.currency_conversion_type := NULL;
677: END IF;
678: IF (l_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
679: l_pflv_rec.currency_conversion_rate := NULL;
680: END IF;
681: IF (l_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
682: l_pflv_rec.currency_conversion_date := NULL;

Line 681: IF (l_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN

677: END IF;
678: IF (l_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
679: l_pflv_rec.currency_conversion_rate := NULL;
680: END IF;
681: IF (l_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
682: l_pflv_rec.currency_conversion_date := NULL;
683: END IF;
684: -- RABHUPAT - 2667636 -End
685: RETURN(l_pflv_rec);

Line 704: x_return_status := OKC_API.G_RET_STS_SUCCESS;

700:
701: PROCEDURE validate_currency_record(p_pflv_rec IN pflv_rec_type,
702: x_return_status OUT NOCOPY VARCHAR2) IS
703: BEGIN
704: x_return_status := OKC_API.G_RET_STS_SUCCESS;
705: -- If transaction currency <> functional currency, then conversion columns
706: -- are mandatory
707: IF (p_pflv_rec.currency_code <> p_pflv_rec.currency_conversion_code) THEN
708: IF (p_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR

Line 708: IF (p_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR

704: x_return_status := OKC_API.G_RET_STS_SUCCESS;
705: -- If transaction currency <> functional currency, then conversion columns
706: -- are mandatory
707: IF (p_pflv_rec.currency_code <> p_pflv_rec.currency_conversion_code) THEN
708: IF (p_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
709: p_pflv_rec.currency_conversion_type IS NULL) THEN
710: --SET MESSAGE
711: OKC_API.set_message(p_app_name => G_APP_NAME,
712: p_msg_name => G_REQUIRED_VALUE,

Line 711: OKC_API.set_message(p_app_name => G_APP_NAME,

707: IF (p_pflv_rec.currency_code <> p_pflv_rec.currency_conversion_code) THEN
708: IF (p_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
709: p_pflv_rec.currency_conversion_type IS NULL) THEN
710: --SET MESSAGE
711: OKC_API.set_message(p_app_name => G_APP_NAME,
712: p_msg_name => G_REQUIRED_VALUE,
713: p_token1 => G_COL_NAME_TOKEN,
714: p_token1_value => 'currency_conversion_type');
715: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 715: x_return_status := OKC_API.G_RET_STS_ERROR;

711: OKC_API.set_message(p_app_name => G_APP_NAME,
712: p_msg_name => G_REQUIRED_VALUE,
713: p_token1 => G_COL_NAME_TOKEN,
714: p_token1_value => 'currency_conversion_type');
715: x_return_status := OKC_API.G_RET_STS_ERROR;
716: END IF;
717: IF (p_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
718: p_pflv_rec.currency_conversion_rate IS NULL) THEN
719: --SET MESSAGE

Line 717: IF (p_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR

713: p_token1 => G_COL_NAME_TOKEN,
714: p_token1_value => 'currency_conversion_type');
715: x_return_status := OKC_API.G_RET_STS_ERROR;
716: END IF;
717: IF (p_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
718: p_pflv_rec.currency_conversion_rate IS NULL) THEN
719: --SET MESSAGE
720: OKC_API.set_message(p_app_name => G_APP_NAME,
721: p_msg_name => G_REQUIRED_VALUE,

Line 720: OKC_API.set_message(p_app_name => G_APP_NAME,

716: END IF;
717: IF (p_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
718: p_pflv_rec.currency_conversion_rate IS NULL) THEN
719: --SET MESSAGE
720: OKC_API.set_message(p_app_name => G_APP_NAME,
721: p_msg_name => G_REQUIRED_VALUE,
722: p_token1 => G_COL_NAME_TOKEN,
723: p_token1_value => 'currency_conversion_rate');
724: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 724: x_return_status := OKC_API.G_RET_STS_ERROR;

720: OKC_API.set_message(p_app_name => G_APP_NAME,
721: p_msg_name => G_REQUIRED_VALUE,
722: p_token1 => G_COL_NAME_TOKEN,
723: p_token1_value => 'currency_conversion_rate');
724: x_return_status := OKC_API.G_RET_STS_ERROR;
725: END IF;
726: IF (p_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
727: p_pflv_rec.currency_conversion_date IS NULL) THEN
728: --SET MESSAGE

Line 726: IF (p_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR

722: p_token1 => G_COL_NAME_TOKEN,
723: p_token1_value => 'currency_conversion_rate');
724: x_return_status := OKC_API.G_RET_STS_ERROR;
725: END IF;
726: IF (p_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
727: p_pflv_rec.currency_conversion_date IS NULL) THEN
728: --SET MESSAGE
729: OKC_API.set_message(p_app_name => G_APP_NAME,
730: p_msg_name => G_REQUIRED_VALUE,

Line 729: OKC_API.set_message(p_app_name => G_APP_NAME,

725: END IF;
726: IF (p_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
727: p_pflv_rec.currency_conversion_date IS NULL) THEN
728: --SET MESSAGE
729: OKC_API.set_message(p_app_name => G_APP_NAME,
730: p_msg_name => G_REQUIRED_VALUE,
731: p_token1 => G_COL_NAME_TOKEN,
732: p_token1_value => 'currency_conversion_date');
733: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 733: x_return_status := OKC_API.G_RET_STS_ERROR;

729: OKC_API.set_message(p_app_name => G_APP_NAME,
730: p_msg_name => G_REQUIRED_VALUE,
731: p_token1 => G_COL_NAME_TOKEN,
732: p_token1_value => 'currency_conversion_date');
733: x_return_status := OKC_API.G_RET_STS_ERROR;
734: END IF;
735: -- Else If transaction currency = functional currency, then conversion columns
736: -- should all be NULL
737: ELSIF (p_pflv_rec.currency_code = p_pflv_rec.currency_conversion_code) THEN

Line 744: OKC_API.set_message(p_app_name => G_APP_NAME,

740: (p_pflv_rec.currency_conversion_date IS NOT NULL) THEN
741: --SET MESSAGE
742: -- Currency conversion columns should be all null
743: IF p_pflv_rec.currency_conversion_rate IS NOT NULL THEN
744: OKC_API.set_message(p_app_name => G_APP_NAME,
745: p_msg_name => G_INVALID_VALUE,
746: p_token1 => G_COL_NAME_TOKEN,
747: p_token1_value => 'currency_conversion_rate');
748: END IF;

Line 750: OKC_API.set_message(p_app_name => G_APP_NAME,

746: p_token1 => G_COL_NAME_TOKEN,
747: p_token1_value => 'currency_conversion_rate');
748: END IF;
749: IF p_pflv_rec.currency_conversion_date IS NOT NULL THEN
750: OKC_API.set_message(p_app_name => G_APP_NAME,
751: p_msg_name => G_INVALID_VALUE,
752: p_token1 => G_COL_NAME_TOKEN,
753: p_token1_value => 'currency_conversion_date');
754: END IF;

Line 756: OKC_API.set_message(p_app_name => G_APP_NAME,

752: p_token1 => G_COL_NAME_TOKEN,
753: p_token1_value => 'currency_conversion_date');
754: END IF;
755: IF p_pflv_rec.currency_conversion_type IS NOT NULL THEN
756: OKC_API.set_message(p_app_name => G_APP_NAME,
757: p_msg_name => G_INVALID_VALUE,
758: p_token1 => G_COL_NAME_TOKEN,
759: p_token1_value => 'currency_conversion_type');
760: END IF;

Line 761: x_return_status := OKC_API.G_RET_STS_ERROR;

757: p_msg_name => G_INVALID_VALUE,
758: p_token1 => G_COL_NAME_TOKEN,
759: p_token1_value => 'currency_conversion_type');
760: END IF;
761: x_return_status := OKC_API.G_RET_STS_ERROR;
762: END IF;
763: ELSE
764: x_return_status := OKC_API.G_RET_STS_ERROR;
765: END IF;

Line 764: x_return_status := OKC_API.G_RET_STS_ERROR;

760: END IF;
761: x_return_status := OKC_API.G_RET_STS_ERROR;
762: END IF;
763: ELSE
764: x_return_status := OKC_API.G_RET_STS_ERROR;
765: END IF;
766: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
767: RAISE G_EXCEPTION_HALT_VALIDATION;
768: END IF;

Line 766: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

762: END IF;
763: ELSE
764: x_return_status := OKC_API.G_RET_STS_ERROR;
765: END IF;
766: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
767: RAISE G_EXCEPTION_HALT_VALIDATION;
768: END IF;
769: EXCEPTION
770: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 771: x_return_status := OKC_API.G_RET_STS_ERROR;

767: RAISE G_EXCEPTION_HALT_VALIDATION;
768: END IF;
769: EXCEPTION
770: WHEN G_EXCEPTION_HALT_VALIDATION THEN
771: x_return_status := OKC_API.G_RET_STS_ERROR;
772: WHEN OTHERS THEN
773: -- store SQL error message on message stack for caller
774: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
775: p_msg_name => g_unexpected_error,

Line 774: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

770: WHEN G_EXCEPTION_HALT_VALIDATION THEN
771: x_return_status := OKC_API.G_RET_STS_ERROR;
772: WHEN OTHERS THEN
773: -- store SQL error message on message stack for caller
774: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
775: p_msg_name => g_unexpected_error,
776: p_token1 => g_sqlcode_token,
777: p_token1_value => sqlcode,
778: p_token2 => g_sqlerrm_token,

Line 781: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

777: p_token1_value => sqlcode,
778: p_token2 => g_sqlerrm_token,
779: p_token2_value => sqlerrm);
780: -- notify caller of an UNEXPECTED error
781: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
782: END validate_currency_record;
783: ---------------------------------------------------------------------------------
784: -- Start of comments
785: --

Line 796: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;

792: -- End of comments
793:
794: PROCEDURE validate_currency_code(p_pflv_rec IN pflv_rec_type,
795: x_return_status OUT NOCOPY VARCHAR2) IS
796: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
797: BEGIN
798: -- initialize return status
799: x_return_status := OKC_API.G_RET_STS_SUCCESS;
800: -- data is required

Line 799: x_return_status := OKC_API.G_RET_STS_SUCCESS;

795: x_return_status OUT NOCOPY VARCHAR2) IS
796: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
797: BEGIN
798: -- initialize return status
799: x_return_status := OKC_API.G_RET_STS_SUCCESS;
800: -- data is required
801: IF (p_pflv_rec.currency_code IS NULL) OR
802: (p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN
803: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 802: (p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN

798: -- initialize return status
799: x_return_status := OKC_API.G_RET_STS_SUCCESS;
800: -- data is required
801: IF (p_pflv_rec.currency_code IS NULL) OR
802: (p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN
803: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
804: ,p_msg_name => G_REQUIRED_VALUE
805: ,p_token1 => G_COL_NAME_TOKEN
806: ,p_token1_value => 'currency_code');

Line 803: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

799: x_return_status := OKC_API.G_RET_STS_SUCCESS;
800: -- data is required
801: IF (p_pflv_rec.currency_code IS NULL) OR
802: (p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR) THEN
803: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
804: ,p_msg_name => G_REQUIRED_VALUE
805: ,p_token1 => G_COL_NAME_TOKEN
806: ,p_token1_value => 'currency_code');
807:

Line 813: IF (l_return_status <> OKC_API.G_TRUE) THEN

809: RAISE G_EXCEPTION_HALT_VALIDATION;
810: END IF;
811: -- check from currency values using the generic okl_util.validate_currency_code
812: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_pflv_rec.currency_code);
813: IF (l_return_status <> OKC_API.G_TRUE) THEN
814: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
815: p_msg_name => g_invalid_value,
816: p_token1 => g_col_name_token,
817: p_token1_value => 'currency_code');

Line 814: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

810: END IF;
811: -- check from currency values using the generic okl_util.validate_currency_code
812: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_pflv_rec.currency_code);
813: IF (l_return_status <> OKC_API.G_TRUE) THEN
814: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
815: p_msg_name => g_invalid_value,
816: p_token1 => g_col_name_token,
817: p_token1_value => 'currency_code');
818: -- halt further validation of this column

Line 823: x_return_status := OKC_API.G_RET_STS_ERROR;

819: RAISE G_EXCEPTION_HALT_VALIDATION;
820: END IF;
821: EXCEPTION
822: WHEN G_EXCEPTION_HALT_VALIDATION THEN
823: x_return_status := OKC_API.G_RET_STS_ERROR;
824: WHEN OTHERS THEN
825: -- store SQL error message on message stack for caller
826: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
827: p_msg_name => g_unexpected_error,

Line 826: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

822: WHEN G_EXCEPTION_HALT_VALIDATION THEN
823: x_return_status := OKC_API.G_RET_STS_ERROR;
824: WHEN OTHERS THEN
825: -- store SQL error message on message stack for caller
826: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
827: p_msg_name => g_unexpected_error,
828: p_token1 => g_sqlcode_token,
829: p_token1_value => sqlcode,
830: p_token2 => g_sqlerrm_token,

Line 833: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

829: p_token1_value => sqlcode,
830: p_token2 => g_sqlerrm_token,
831: p_token2_value => sqlerrm);
832: -- notify caller of an UNEXPECTED error
833: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
834: END validate_currency_code;
835: ---------------------------------------------------------------------------------
836: -- Start of comments
837: --

Line 848: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;

844: -- End of comments
845:
846: PROCEDURE validate_currency_con_code(p_pflv_rec IN pflv_rec_type,
847: x_return_status OUT NOCOPY VARCHAR2) IS
848: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
849: BEGIN
850: -- initialize return status
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- data is required

Line 851: x_return_status := OKC_API.G_RET_STS_SUCCESS;

847: x_return_status OUT NOCOPY VARCHAR2) IS
848: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
849: BEGIN
850: -- initialize return status
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- data is required
853: IF (p_pflv_rec.currency_conversion_code IS NULL) OR
854: (p_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
855: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 854: (p_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN

850: -- initialize return status
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- data is required
853: IF (p_pflv_rec.currency_conversion_code IS NULL) OR
854: (p_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
855: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
856: ,p_msg_name => G_REQUIRED_VALUE
857: ,p_token1 => G_COL_NAME_TOKEN
858: ,p_token1_value => 'currency_conversion_code');

Line 855: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- data is required
853: IF (p_pflv_rec.currency_conversion_code IS NULL) OR
854: (p_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR) THEN
855: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
856: ,p_msg_name => G_REQUIRED_VALUE
857: ,p_token1 => G_COL_NAME_TOKEN
858: ,p_token1_value => 'currency_conversion_code');
859: -- halt further validation of this column

Line 864: IF (l_return_status <> OKC_API.G_TRUE) THEN

860: RAISE G_EXCEPTION_HALT_VALIDATION;
861: END IF;
862: -- check from currency values using the generic okl_util.validate_currency_code
863: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_pflv_rec.currency_conversion_code);
864: IF (l_return_status <> OKC_API.G_TRUE) THEN
865: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
866: p_msg_name => g_invalid_value,
867: p_token1 => g_col_name_token,
868: p_token1_value => 'currency_conversion_code');

Line 865: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

861: END IF;
862: -- check from currency values using the generic okl_util.validate_currency_code
863: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_pflv_rec.currency_conversion_code);
864: IF (l_return_status <> OKC_API.G_TRUE) THEN
865: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
866: p_msg_name => g_invalid_value,
867: p_token1 => g_col_name_token,
868: p_token1_value => 'currency_conversion_code');
869: -- halt further validation of this column

Line 874: x_return_status := OKC_API.G_RET_STS_ERROR;

870: RAISE G_EXCEPTION_HALT_VALIDATION;
871: END IF;
872: EXCEPTION
873: WHEN G_EXCEPTION_HALT_VALIDATION THEN
874: x_return_status := OKC_API.G_RET_STS_ERROR;
875: WHEN OTHERS THEN
876: -- store SQL error message on message stack for caller
877: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
878: p_msg_name => g_unexpected_error,

Line 877: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

873: WHEN G_EXCEPTION_HALT_VALIDATION THEN
874: x_return_status := OKC_API.G_RET_STS_ERROR;
875: WHEN OTHERS THEN
876: -- store SQL error message on message stack for caller
877: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
878: p_msg_name => g_unexpected_error,
879: p_token1 => g_sqlcode_token,
880: p_token1_value => sqlcode,
881: p_token2 => g_sqlerrm_token,

Line 885: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

881: p_token2 => g_sqlerrm_token,
882: p_token2_value => sqlerrm);
883:
884: -- notify caller of an UNEXPECTED error
885: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
886: END validate_currency_con_code;
887: ---------------------------------------------------------------------------------
888: -- Start of comments
889: --

Line 900: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;

896: -- End of comments
897:
898: PROCEDURE validate_currency_con_type(p_pflv_rec IN pflv_rec_type,
899: x_return_status OUT NOCOPY VARCHAR2) IS
900: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
901: BEGIN
902: -- initialize return status
903: x_return_status := OKC_API.G_RET_STS_SUCCESS;
904: IF (p_pflv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND

Line 903: x_return_status := OKC_API.G_RET_STS_SUCCESS;

899: x_return_status OUT NOCOPY VARCHAR2) IS
900: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
901: BEGIN
902: -- initialize return status
903: x_return_status := OKC_API.G_RET_STS_SUCCESS;
904: IF (p_pflv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
905: p_pflv_rec.currency_conversion_type IS NOT NULL) THEN
906: -- check from currency values using the generic okl_util.validate_currency_code
907: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_pflv_rec.currency_conversion_type);

Line 908: IF (l_return_status <> OKC_API.G_TRUE) THEN

904: IF (p_pflv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
905: p_pflv_rec.currency_conversion_type IS NOT NULL) THEN
906: -- check from currency values using the generic okl_util.validate_currency_code
907: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_pflv_rec.currency_conversion_type);
908: IF (l_return_status <> OKC_API.G_TRUE) THEN
909: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
910: p_msg_name => g_invalid_value,
911: p_token1 => g_col_name_token,
912: p_token1_value => 'currency_conversion_type');

Line 909: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

905: p_pflv_rec.currency_conversion_type IS NOT NULL) THEN
906: -- check from currency values using the generic okl_util.validate_currency_code
907: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_pflv_rec.currency_conversion_type);
908: IF (l_return_status <> OKC_API.G_TRUE) THEN
909: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
910: p_msg_name => g_invalid_value,
911: p_token1 => g_col_name_token,
912: p_token1_value => 'currency_conversion_type');
913: -- halt further validation of this column

Line 919: x_return_status := OKC_API.G_RET_STS_ERROR;

915: END IF;
916: END IF;
917: EXCEPTION
918: WHEN G_EXCEPTION_HALT_VALIDATION THEN
919: x_return_status := OKC_API.G_RET_STS_ERROR;
920: WHEN OTHERS THEN
921: -- store SQL error message on message stack for caller
922: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
923: p_msg_name => g_unexpected_error,

Line 922: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

918: WHEN G_EXCEPTION_HALT_VALIDATION THEN
919: x_return_status := OKC_API.G_RET_STS_ERROR;
920: WHEN OTHERS THEN
921: -- store SQL error message on message stack for caller
922: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
923: p_msg_name => g_unexpected_error,
924: p_token1 => g_sqlcode_token,
925: p_token1_value => sqlcode,
926: p_token2 => g_sqlerrm_token,

Line 929: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

925: p_token1_value => sqlcode,
926: p_token2 => g_sqlerrm_token,
927: p_token2_value => sqlerrm);
928: -- notify caller of an UNEXPECTED error
929: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
930: END validate_currency_con_type;
931:
932: ---------------------------------
933: -- Validate_Attributes for: ID --

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

1284: -- RMUNJULU - 2667636 - Start
1285: validate_currency_code(p_pflv_rec => p_pflv_rec,
1286: x_return_status => l_return_status);
1287: -- store the highest degree of error
1288: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1289: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: x_return_status := l_return_status;
1291: END IF;
1292: END IF;

Line 1289: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1285: validate_currency_code(p_pflv_rec => p_pflv_rec,
1286: x_return_status => l_return_status);
1287: -- store the highest degree of error
1288: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1289: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: x_return_status := l_return_status;
1291: END IF;
1292: END IF;
1293:

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

1293:
1294: validate_currency_con_code(p_pflv_rec => p_pflv_rec,
1295: x_return_status => l_return_status);
1296: -- store the highest degree of error
1297: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1298: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1299: x_return_status := l_return_status;
1300: END IF;
1301: END IF;

Line 1298: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1294: validate_currency_con_code(p_pflv_rec => p_pflv_rec,
1295: x_return_status => l_return_status);
1296: -- store the highest degree of error
1297: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1298: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1299: x_return_status := l_return_status;
1300: END IF;
1301: END IF;
1302:

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

1302:
1303: validate_currency_con_type(p_pflv_rec => p_pflv_rec,
1304: x_return_status => l_return_status);
1305: -- store the highest degree of error
1306: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1307: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1308: x_return_status := l_return_status;
1309: END IF;
1310: END IF;

Line 1307: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1303: validate_currency_con_type(p_pflv_rec => p_pflv_rec,
1304: x_return_status => l_return_status);
1305: -- store the highest degree of error
1306: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1307: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1308: x_return_status := l_return_status;
1309: END IF;
1310: END IF;
1311: -- RMUNJULU - 2667636 - End

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

1555:
1556: validate_currency_record(p_pflv_rec => p_pflv_rec,
1557: x_return_status => l_return_status);
1558: -- store the highest degree of error
1559: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1560: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1561: x_return_status := l_return_status;
1562: END IF;
1563: END IF;

Line 1560: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1556: validate_currency_record(p_pflv_rec => p_pflv_rec,
1557: x_return_status => l_return_status);
1558: -- store the highest degree of error
1559: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1560: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1561: x_return_status := l_return_status;
1562: END IF;
1563: END IF;
1564:

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

1564:
1565: -- RABHUPAT - 2667636 - End
1566: l_return_status := validate_foreign_keys(p_pflv_rec, p_db_pflv_rec);
1567: -- store the highest degree of error
1568: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1569: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: x_return_status := l_return_status;
1571: END IF;
1572: END IF;

Line 1569: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1565: -- RABHUPAT - 2667636 - End
1566: l_return_status := validate_foreign_keys(p_pflv_rec, p_db_pflv_rec);
1567: -- store the highest degree of error
1568: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1569: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: x_return_status := l_return_status;
1571: END IF;
1572: END IF;
1573: RETURN (x_return_status);

Line 2342: OR p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR THEN

2338: -- RABHUPAT - 2667636 - Start
2339: x_pflv_rec.currency_conversion_code := OKL_AM_UTIL_PVT.get_functional_currency;
2340:
2341: IF p_pflv_rec.currency_code IS NULL
2342: OR p_pflv_rec.currency_code = OKC_API.G_MISS_CHAR THEN
2343: x_pflv_rec.currency_code := x_pflv_rec.currency_conversion_code;
2344: END IF;
2345: -- RABHUPAT- 2667636 - End
2346: RETURN(l_return_status);

Line 3265: IF (x_pfl_rec.currency_code = OKC_API.G_MISS_CHAR)

3261: x_pfl_rec.last_update_login := l_pfl_rec.last_update_login;
3262: END IF;
3263: END IF;
3264: -- RABHUPAT - 2667636 - Start
3265: IF (x_pfl_rec.currency_code = OKC_API.G_MISS_CHAR)
3266: THEN
3267: x_pfl_rec.currency_code := l_pfl_rec.currency_code;
3268: END IF;
3269: IF (x_pfl_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)

Line 3269: IF (x_pfl_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)

3265: IF (x_pfl_rec.currency_code = OKC_API.G_MISS_CHAR)
3266: THEN
3267: x_pfl_rec.currency_code := l_pfl_rec.currency_code;
3268: END IF;
3269: IF (x_pfl_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)
3270: THEN
3271: x_pfl_rec.currency_conversion_code := l_pfl_rec.currency_conversion_code;
3272: END IF;
3273: IF (x_pfl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

Line 3273: IF (x_pfl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

3269: IF (x_pfl_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)
3270: THEN
3271: x_pfl_rec.currency_conversion_code := l_pfl_rec.currency_conversion_code;
3272: END IF;
3273: IF (x_pfl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
3274: THEN
3275: x_pfl_rec.currency_conversion_type := l_pfl_rec.currency_conversion_type;
3276: END IF;
3277: IF (x_pfl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

Line 3277: IF (x_pfl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

3273: IF (x_pfl_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
3274: THEN
3275: x_pfl_rec.currency_conversion_type := l_pfl_rec.currency_conversion_type;
3276: END IF;
3277: IF (x_pfl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
3278: THEN
3279: x_pfl_rec.currency_conversion_rate := l_pfl_rec.currency_conversion_rate;
3280: END IF;
3281: IF (x_pfl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

Line 3281: IF (x_pfl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

3277: IF (x_pfl_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
3278: THEN
3279: x_pfl_rec.currency_conversion_rate := l_pfl_rec.currency_conversion_rate;
3280: END IF;
3281: IF (x_pfl_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
3282: THEN
3283: x_pfl_rec.currency_conversion_date := l_pfl_rec.currency_conversion_date;
3284: END IF;
3285: -- RABHUPAT - 2667636 - End

Line 3796: IF (x_pflv_rec.currency_code = OKC_API.G_MISS_CHAR)

3792: THEN
3793: x_pflv_rec.last_update_login := l_db_pflv_rec.last_update_login;
3794: END IF;
3795: -- RABHUPAT - 2667636 - Start
3796: IF (x_pflv_rec.currency_code = OKC_API.G_MISS_CHAR)
3797: THEN
3798: x_pflv_rec.currency_code := l_db_pflv_rec.currency_code;
3799: END IF;
3800: IF (x_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)

Line 3800: IF (x_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)

3796: IF (x_pflv_rec.currency_code = OKC_API.G_MISS_CHAR)
3797: THEN
3798: x_pflv_rec.currency_code := l_db_pflv_rec.currency_code;
3799: END IF;
3800: IF (x_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)
3801: THEN
3802: x_pflv_rec.currency_conversion_code := l_db_pflv_rec.currency_conversion_code;
3803: END IF;
3804: IF (x_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

Line 3804: IF (x_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)

3800: IF (x_pflv_rec.currency_conversion_code = OKC_API.G_MISS_CHAR)
3801: THEN
3802: x_pflv_rec.currency_conversion_code := l_db_pflv_rec.currency_conversion_code;
3803: END IF;
3804: IF (x_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
3805: THEN
3806: x_pflv_rec.currency_conversion_type := l_db_pflv_rec.currency_conversion_type;
3807: END IF;
3808: IF (x_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

Line 3808: IF (x_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)

3804: IF (x_pflv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR)
3805: THEN
3806: x_pflv_rec.currency_conversion_type := l_db_pflv_rec.currency_conversion_type;
3807: END IF;
3808: IF (x_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
3809: THEN
3810: x_pflv_rec.currency_conversion_rate := l_db_pflv_rec.currency_conversion_rate;
3811: END IF;
3812: IF (x_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

Line 3812: IF (x_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE)

3808: IF (x_pflv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM)
3809: THEN
3810: x_pflv_rec.currency_conversion_rate := l_db_pflv_rec.currency_conversion_rate;
3811: END IF;
3812: IF (x_pflv_rec.currency_conversion_date = OKC_API.G_MISS_DATE)
3813: THEN
3814: x_pflv_rec.currency_conversion_date := l_db_pflv_rec.currency_conversion_date;
3815: END IF;
3816: -- RABHUPAT - 2667636 - End