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;
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;
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;
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;
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);
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
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,
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;
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
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,
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;
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
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,
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;
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
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;
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;
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;
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;
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;
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
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,
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,
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: --
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
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
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');
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:
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');
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
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,
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,
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: --
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
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
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');
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
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');
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
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,
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,
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: --
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
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);
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');
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
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,
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,
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 --
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;
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:
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;
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:
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;
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
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;
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:
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;
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);
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);
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)
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)
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)
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)
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
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)
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)
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)
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)
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