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

Line 28: okl_api.set_message(G_APP_NAME, G_TOT_RESIDU_INC_MSG);

24: CLOSE c_get_total_share;
25: -- the total residual share cannot be more than 100 or less than 100. it has to be always sum up to 100
26: IF(lv_total_share > 100 OR lv_total_share < 100)THEN
27: lv_return_status := 'E';
28: okl_api.set_message(G_APP_NAME, G_TOT_RESIDU_INC_MSG);
29: END IF;
30: RETURN lv_return_status;
31: EXCEPTION WHEN OTHERS THEN
32: lv_return_status := 'E';

Line 33: okl_api.set_message(G_APP_NAME, G_TOT_RESIDU_INC_MSG);

29: END IF;
30: RETURN lv_return_status;
31: EXCEPTION WHEN OTHERS THEN
32: lv_return_status := 'E';
33: okl_api.set_message(G_APP_NAME, G_TOT_RESIDU_INC_MSG);
34: RETURN lv_return_status;
35: END validate_total_residual;
36:
37: -- this function ensures that each residual share percent defined against the party in the Terms and Conditions page is a positive number

Line 53: okl_api.set_message(G_APP_NAME, G_RESIDU_NOT_POS_MSG);

49: lv_return_status := 'S';
50: FOR each_row IN c_get_residual_share(cp_chr_id => p_chr_id) LOOP
51: IF(to_number(each_row.share_percent) < 0)THEN
52: lv_return_status := 'E';
53: okl_api.set_message(G_APP_NAME, G_RESIDU_NOT_POS_MSG);
54: END IF;
55: END LOOP;
56: RETURN lv_return_status;
57: EXCEPTION WHEN OTHERS THEN

Line 59: okl_api.set_message(G_APP_NAME, G_RESIDU_NOT_POS_MSG);

55: END LOOP;
56: RETURN lv_return_status;
57: EXCEPTION WHEN OTHERS THEN
58: lv_return_status := 'E';
59: okl_api.set_message(G_APP_NAME, G_RESIDU_NOT_POS_MSG);
60: RETURN lv_return_status;
61: END validate_residual_positive;
62:
63: -- this function ensures that the pary information on the residual share terms and conditions page are valid parties on the program agreement

Line 540: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)

536: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
537: AND vpa.chr_id = cp_chr_id
538: AND lat.cust_credit_classification = cp_credit_class
539: AND lat.credit_review_purpose = cp_credit_review
540: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
541: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
542: AND vpa.id <> cp_id
543: AND vpa.assoc_object_id <> cp_object_id
544: AND (

Line 541: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)

537: AND vpa.chr_id = cp_chr_id
538: AND lat.cust_credit_classification = cp_credit_class
539: AND lat.credit_review_purpose = cp_credit_review
540: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
541: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
542: AND vpa.id <> cp_id
543: AND vpa.assoc_object_id <> cp_object_id
544: AND (
545: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

Line 559: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)

555: AND chreq.chr_id = cp_chr_id
556: AND vpa.crs_id = chreq.id
557: AND lat.cust_credit_classification = cp_credit_class
558: AND lat.credit_review_purpose = cp_credit_review
559: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
560: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
561: AND vpa.id <> cp_id
562: AND vpa.assoc_object_id <> cp_object_id
563: AND (

Line 560: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)

556: AND vpa.crs_id = chreq.id
557: AND lat.cust_credit_classification = cp_credit_class
558: AND lat.credit_review_purpose = cp_credit_review
559: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
560: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
561: AND vpa.id <> cp_id
562: AND vpa.assoc_object_id <> cp_object_id
563: AND (
564: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

Line 580: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)

576: AND okl.id = cp_chr_id
577: AND vpa.crs_id = okl.crs_id
578: AND lat.cust_credit_classification = cp_credit_class
579: AND lat.credit_review_purpose = cp_credit_review
580: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
581: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
582: AND vpa.id <> cp_id
583: AND vpa.assoc_object_id <> cp_object_id
584: AND (

Line 581: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)

577: AND vpa.crs_id = okl.crs_id
578: AND lat.cust_credit_classification = cp_credit_class
579: AND lat.credit_review_purpose = cp_credit_review
580: AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
581: AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
582: AND vpa.id <> cp_id
583: AND vpa.assoc_object_id <> cp_object_id
584: AND (
585: (trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR

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

600: AND cdef.crit_cat_def_id = crit.crit_cat_def_id
601: AND source_id = cp_chr_id
602: AND source_object_code = 'VENDOR_PROGRAM';
603:
604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;

Line 642: x_return_status := OKL_API.G_RET_STS_SUCCESS;

638: IF(l_debug_enabled='Y') THEN
639: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call get_lookup_meaning');
640: END IF;
641: -- initialize return status
642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
643:
644: OPEN get_agreement_rec(p_chr_id);
645: FETCH get_agreement_rec INTO l_start_date, l_end_date, l_agrmnt_number, l_inv_org_id, l_sts_code;
646: CLOSE get_agreement_rec;

Line 658: OKL_API.set_message(G_APP_NAME,

654: parent_rec.start_date,
655: parent_rec.end_date
656: );
657: IF(l_return_status = 'E')THEN
658: OKL_API.set_message(G_APP_NAME,
659: 'OKL_VN_AGR_INV_START_DATE',
660: 'AGR_NUMBER',
661: l_agrmnt_number,
662: 'PARENT_AGR_NUMBER',

Line 665: x_return_status := OKL_API.G_RET_STS_ERROR;

661: l_agrmnt_number,
662: 'PARENT_AGR_NUMBER',
663: parent_rec.contract_number
664: );
665: x_return_status := OKL_API.G_RET_STS_ERROR;
666: END IF;
667: -- Check if the agreements end date lies between the parent agreements effective dates, else throw an error.
668: l_return_status := validate_end_date(l_end_date,
669: parent_rec.start_date,

Line 673: OKL_API.set_message(G_APP_NAME,

669: parent_rec.start_date,
670: parent_rec.end_date
671: );
672: IF(l_return_status = 'E')THEN
673: OKL_API.set_message(G_APP_NAME,
674: 'OKL_VN_AGR_INV_END_DATE',
675: 'AGR_NUMBER',
676: l_agrmnt_number,
677: 'PARENT_AGR_NUMBER',

Line 680: x_return_status := OKL_API.G_RET_STS_ERROR;

676: l_agrmnt_number,
677: 'PARENT_AGR_NUMBER',
678: parent_rec.contract_number
679: );
680: x_return_status := OKL_API.G_RET_STS_ERROR;
681: END IF;
682: -- Check the parent agreement must be in status "Active", else throw an error.
683: l_return_status := validate_status(parent_rec.sts_code);
684: IF(l_return_status = 'E')THEN

Line 685: OKL_API.set_message(G_APP_NAME,

681: END IF;
682: -- Check the parent agreement must be in status "Active", else throw an error.
683: l_return_status := validate_status(parent_rec.sts_code);
684: IF(l_return_status = 'E')THEN
685: OKL_API.set_message(G_APP_NAME,
686: 'OKL_VN_AGR_INV_STATUS',
687: 'PARENT_AGR_NUMBER',
688: l_agrmnt_number,
689: 'AGR_NUMBER',

Line 692: x_return_status := OKL_API.G_RET_STS_ERROR;

688: l_agrmnt_number,
689: 'AGR_NUMBER',
690: parent_rec.contract_number
691: );
692: x_return_status := OKL_API.G_RET_STS_ERROR;
693: END IF;
694: END LOOP;
695:
696: --For each row found in the association records, validate each record, and raise arrors, if the validation fails.

Line 712: OKL_API.set_message(G_APP_NAME,

708: l_start_date,
709: l_end_date
710: );
711: IF(l_return_status = 'E')THEN
712: OKL_API.set_message(G_APP_NAME,
713: 'OKL_VN_INV_ASSOC_START_DATE',
714: 'ASSOC_TYPE',
715: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
716: 'ASSOC_NAME',

Line 721: x_return_status := OKL_API.G_RET_STS_ERROR;

717: l_assoc_agrmnt_number,
718: 'AGR_NUMBER',
719: l_agrmnt_number
720: );
721: x_return_status := OKL_API.G_RET_STS_ERROR;
722: END IF;
723: l_return_status := validate_end_date(each_row.end_date,
724: l_start_date,
725: l_end_date

Line 728: OKL_API.set_message(G_APP_NAME,

724: l_start_date,
725: l_end_date
726: );
727: IF(l_return_status = 'E')THEN
728: OKL_API.set_message(G_APP_NAME,
729: 'OKL_VN_INV_ASSOC_END_DATE',
730: 'ASSOC_TYPE',
731: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
732: 'ASSOC_NAME',

Line 737: x_return_status := OKL_API.G_RET_STS_ERROR;

733: l_assoc_agrmnt_number,
734: 'AGR_NUMBER',
735: l_agrmnt_number
736: );
737: x_return_status := OKL_API.G_RET_STS_ERROR;
738: END IF;
739: -- l_return_status := validate_status(l_assoc_sts_code);
740: -- sjalasut, Lease Contract Temaplates are PASSED and Lease Application Templates are ACTIVE
741: -- so one common method to validate their statuses is not correct.

Line 746: OKL_API.set_message(G_APP_NAME,

742: -- Bug 6642645: LC_TEMPLATE entities final status is PASSED, but not BOOKED as assumed.
743: IF((each_row.assoc_object_type_code = 'LC_TEMPLATE' AND l_assoc_sts_code <> 'PASSED') OR
744: (each_row.assoc_object_type_code = 'LA_TEMPLATE' AND l_assoc_sts_code <> 'ACTIVE')
745: )THEN
746: OKL_API.set_message(G_APP_NAME,
747: 'OKL_VN_INV_ASSOC_STATUS',
748: 'ASSOC_TYPE',
749: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
750: 'ASSOC_NAME',

Line 755: x_return_status := OKL_API.G_RET_STS_ERROR;

751: l_assoc_agrmnt_number,
752: 'AGR_NUMBER',
753: l_agrmnt_number
754: );
755: x_return_status := OKL_API.G_RET_STS_ERROR;
756: END IF;
757:
758: -- For lease application template, validate that the associated templates status should be active,
759: -- The association effective dates should lie in between the agreements effective dates. If any of the validation fails throw an error.

Line 786: OKL_API.SET_MESSAGE( G_APP_NAME,

782: FETCH get_la_assoc_rec_param INTO lv_leaseapp_tmpt_name;
783: CLOSE get_la_assoc_rec_param;
784:
785: IF (lv_leaseapp_tmpt_name IS NOT NULL) THEN
786: OKL_API.SET_MESSAGE( G_APP_NAME,
787: 'OKL_VP_DUPLICATE_ASSOCIATION',
788: 'FIRST',
789: l_appl_temp_name,
790: 'SECOND',

Line 795: x_return_status := OKL_API.G_RET_STS_ERROR;

791: l_assoc_agrmnt_number,
792: 'AGR_NUMBER',
793: l_agrmnt_number
794: );
795: x_return_status := OKL_API.G_RET_STS_ERROR;
796: RAISE G_EXCEPTION_HALT_VALIDATION;
797: END IF;
798:
799: l_return_status := validate_start_date(each_row.start_date,

Line 804: OKL_API.set_message(G_APP_NAME,

800: l_start_date,
801: l_end_date
802: );
803: IF(l_return_status = 'E')THEN
804: OKL_API.set_message(G_APP_NAME,
805: 'OKL_VN_INV_ASSOC_START_DATE',
806: 'ASSOC_TYPE',
807: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
808: 'ASSOC_NAME',

Line 813: x_return_status := OKL_API.G_RET_STS_ERROR;

809: l_assoc_agrmnt_number,
810: 'AGR_NUMBER',
811: l_agrmnt_number
812: );
813: x_return_status := OKL_API.G_RET_STS_ERROR;
814: END IF;
815: l_return_status := validate_end_date(each_row.end_date,
816: l_start_date,
817: l_end_date

Line 820: OKL_API.set_message(G_APP_NAME,

816: l_start_date,
817: l_end_date
818: );
819: IF(l_return_status = 'E')THEN
820: OKL_API.set_message(G_APP_NAME,
821: 'OKL_VN_INV_ASSOC_END_DATE',
822: 'ASSOC_TYPE',
823: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
824: 'ASSOC_NAME',

Line 829: x_return_status := OKL_API.G_RET_STS_ERROR;

825: l_assoc_agrmnt_number,
826: 'AGR_NUMBER',
827: l_agrmnt_number
828: );
829: x_return_status := OKL_API.G_RET_STS_ERROR;
830: END IF;
831: l_return_status := validate_status(l_assoc_sts_code);
832: IF(l_return_status = 'E')THEN
833: OKL_API.set_message(G_APP_NAME,

Line 833: OKL_API.set_message(G_APP_NAME,

829: x_return_status := OKL_API.G_RET_STS_ERROR;
830: END IF;
831: l_return_status := validate_status(l_assoc_sts_code);
832: IF(l_return_status = 'E')THEN
833: OKL_API.set_message(G_APP_NAME,
834: 'OKL_VN_INV_ASSOC_STATUS',
835: 'ASSOC_TYPE',
836: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
837: 'ASSOC_NAME',

Line 842: x_return_status := OKL_API.G_RET_STS_ERROR;

838: l_assoc_agrmnt_number,
839: 'AGR_NUMBER',
840: l_agrmnt_number
841: );
842: x_return_status := OKL_API.G_RET_STS_ERROR;
843: END IF;
844:
845: -- For each of the items associated to the agreement, the association dates should lie between the agreement effective dates,
846: -- For all the items of same type associated to the agreement, check no effective date of the items should be overlaping.

Line 857: OKL_API.set_message(G_APP_NAME,

853: l_start_date,
854: l_end_date
855: );
856: IF(l_return_status = 'E')THEN
857: OKL_API.set_message(G_APP_NAME,
858: 'OKL_VN_INV_ITEM_START_DATE',
859: 'ASSOC_NAME',
860: l_assoc_name,
861: 'AGR_NUMBER',

Line 864: x_return_status := OKL_API.G_RET_STS_ERROR;

860: l_assoc_name,
861: 'AGR_NUMBER',
862: l_agrmnt_number
863: );
864: x_return_status := OKL_API.G_RET_STS_ERROR;
865: END IF;
866: l_return_status := validate_end_date(each_row.end_date,
867: l_start_date,
868: l_end_date

Line 871: OKL_API.set_message(G_APP_NAME,

867: l_start_date,
868: l_end_date
869: );
870: IF(l_return_status = 'E')THEN
871: OKL_API.set_message(G_APP_NAME,
872: 'OKL_VN_INV_ITEM_END_DATE',
873: 'ASSOC_NAME',
874: l_assoc_name,
875: 'AGR_NUMBER',

Line 878: x_return_status := OKL_API.G_RET_STS_ERROR;

874: l_assoc_name,
875: 'AGR_NUMBER',
876: l_agrmnt_number
877: );
878: x_return_status := OKL_API.G_RET_STS_ERROR;
879: END IF;
880: l_return_status := validate_date_overlap(each_row.id,
881: p_chr_id,
882: each_row.assoc_object_id,

Line 887: OKL_API.set_message(G_APP_NAME,

883: each_row.start_date,
884: each_row.end_date
885: );
886: IF(l_return_status = 'E')THEN
887: OKL_API.set_message(G_APP_NAME,
888: 'OKL_VN_OVERLAP_DATE',
889: 'ASSOC_TYPE',
890: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
891: 'AGR_NUMBER',

Line 894: x_return_status := OKL_API.G_RET_STS_ERROR;

890: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
891: 'AGR_NUMBER',
892: l_agrmnt_number
893: );
894: x_return_status := OKL_API.G_RET_STS_ERROR;
895: END IF;
896:
897: -- For each of the item categories associated to the agreement, the association dates should lie between the agreement effective
898: -- dates. For all the item categories of same type associated to the agreement, check no effective date of the item categories

Line 909: OKL_API.set_message(G_APP_NAME,

905: l_start_date,
906: l_end_date
907: );
908: IF(l_return_status = 'E')THEN
909: OKL_API.set_message(G_APP_NAME,
910: 'OKL_VN_INV_ITEMCAT_START_DATE',
911: 'ASSOC_NAME',
912: l_assoc_name,
913: 'AGR_NUMBER',

Line 916: x_return_status := OKL_API.G_RET_STS_ERROR;

912: l_assoc_name,
913: 'AGR_NUMBER',
914: l_agrmnt_number
915: );
916: x_return_status := OKL_API.G_RET_STS_ERROR;
917: END IF;
918: l_return_status := validate_end_date(each_row.end_date,
919: l_start_date,
920: l_end_date

Line 923: OKL_API.set_message(G_APP_NAME,

919: l_start_date,
920: l_end_date
921: );
922: IF(l_return_status = 'E')THEN
923: OKL_API.set_message(G_APP_NAME,
924: 'OKL_VN_INV_ITEMCAT_END_DATE',
925: 'ASSOC_NAME',
926: l_assoc_name,
927: 'AGR_NUMBER',

Line 930: x_return_status := OKL_API.G_RET_STS_ERROR;

926: l_assoc_name,
927: 'AGR_NUMBER',
928: l_agrmnt_number
929: );
930: x_return_status := OKL_API.G_RET_STS_ERROR;
931: END IF;
932: l_return_status := validate_date_overlap(each_row.id,
933: p_chr_id,
934: each_row.assoc_object_id,

Line 939: OKL_API.set_message(G_APP_NAME,

935: each_row.start_date,
936: each_row.end_date
937: );
938: IF(l_return_status = 'E')THEN
939: OKL_API.set_message(G_APP_NAME,
940: 'OKL_VN_OVERLAP_DATE',
941: 'ASSOC_TYPE',
942: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
943: 'AGR_NUMBER',

Line 946: x_return_status := OKL_API.G_RET_STS_ERROR;

942: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
943: 'AGR_NUMBER',
944: l_agrmnt_number
945: );
946: x_return_status := OKL_API.G_RET_STS_ERROR;
947: END IF;
948:
949: -- For each of the end-of-terms associated to the agreement, the association dates should lie between the agreement effective
950: -- dates. For all the end-of-terms of same type associated to the agreement, check no effective date of the end-of-terms should

Line 961: OKL_API.set_message(G_APP_NAME,

957: l_start_date,
958: l_end_date
959: );
960: IF(l_return_status = 'E')THEN
961: OKL_API.set_message(G_APP_NAME,
962: 'OKL_VN_INV_EOT_START_DATE',
963: 'ASSOC_NAME',
964: l_assoc_name,
965: 'AGR_NUMBER',

Line 968: x_return_status := OKL_API.G_RET_STS_ERROR;

964: l_assoc_name,
965: 'AGR_NUMBER',
966: l_agrmnt_number
967: );
968: x_return_status := OKL_API.G_RET_STS_ERROR;
969: END IF;
970: l_return_status := validate_end_date(each_row.end_date,
971: l_start_date,
972: l_end_date

Line 975: OKL_API.set_message(G_APP_NAME,

971: l_start_date,
972: l_end_date
973: );
974: IF(l_return_status = 'E')THEN
975: OKL_API.set_message(G_APP_NAME,
976: 'OKL_VN_INV_EOT_END_DATE',
977: 'ASSOC_NAME',
978: l_assoc_name,
979: 'AGR_NUMBER',

Line 982: x_return_status := OKL_API.G_RET_STS_ERROR;

978: l_assoc_name,
979: 'AGR_NUMBER',
980: l_agrmnt_number
981: );
982: x_return_status := OKL_API.G_RET_STS_ERROR;
983: END IF;
984: l_return_status := validate_date_overlap(each_row.id,
985: p_chr_id,
986: each_row.assoc_object_id,

Line 991: OKL_API.set_message(G_APP_NAME,

987: each_row.start_date,
988: each_row.end_date
989: );
990: IF(l_return_status = 'E')THEN
991: OKL_API.set_message(G_APP_NAME,
992: 'OKL_VN_OVERLAP_DATE',
993: 'ASSOC_TYPE',
994: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
995: 'AGR_NUMBER',

Line 998: x_return_status := OKL_API.G_RET_STS_ERROR;

994: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
995: 'AGR_NUMBER',
996: l_agrmnt_number
997: );
998: x_return_status := OKL_API.G_RET_STS_ERROR;
999: END IF;
1000:
1001: -- For each of the products associated to the agreement, the association dates should lie between the agreement effective
1002: -- dates. For all the products of same type associated to the agreement, check no effective date of the products should

Line 1013: OKL_API.set_message(G_APP_NAME,

1009: l_start_date,
1010: l_end_date
1011: );
1012: IF(l_return_status = 'E')THEN
1013: OKL_API.set_message(G_APP_NAME,
1014: 'OKL_VN_INV_PDT_START_DATE',
1015: 'ASSOC_NAME',
1016: l_assoc_name,
1017: 'AGR_NUMBER',

Line 1020: x_return_status := OKL_API.G_RET_STS_ERROR;

1016: l_assoc_name,
1017: 'AGR_NUMBER',
1018: l_agrmnt_number
1019: );
1020: x_return_status := OKL_API.G_RET_STS_ERROR;
1021: END IF;
1022: l_return_status := validate_end_date(each_row.end_date,
1023: l_start_date,
1024: l_end_date

Line 1027: OKL_API.set_message(G_APP_NAME,

1023: l_start_date,
1024: l_end_date
1025: );
1026: IF(l_return_status = 'E')THEN
1027: OKL_API.set_message(G_APP_NAME,
1028: 'OKL_VN_INV_PDT_END_DATE',
1029: 'ASSOC_NAME',
1030: l_assoc_name,
1031: 'AGR_NUMBER',

Line 1034: x_return_status := OKL_API.G_RET_STS_ERROR;

1030: l_assoc_name,
1031: 'AGR_NUMBER',
1032: l_agrmnt_number
1033: );
1034: x_return_status := OKL_API.G_RET_STS_ERROR;
1035: END IF;
1036: l_return_status := validate_date_overlap(each_row.id,
1037: p_chr_id,
1038: each_row.assoc_object_id,

Line 1043: OKL_API.set_message(G_APP_NAME,

1039: each_row.start_date,
1040: each_row.end_date
1041: );
1042: IF(l_return_status = 'E')THEN
1043: OKL_API.set_message(G_APP_NAME,
1044: 'OKL_VN_OVERLAP_DATE',
1045: 'ASSOC_TYPE',
1046: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
1047: 'AGR_NUMBER',

Line 1050: x_return_status := OKL_API.G_RET_STS_ERROR;

1046: get_lookup_meaning('OKL_VP_ASSOC_OBJECT_TYPES', each_row.assoc_object_type_code),
1047: 'AGR_NUMBER',
1048: l_agrmnt_number
1049: );
1050: x_return_status := OKL_API.G_RET_STS_ERROR;
1051: END IF;
1052: END IF;
1053: END LOOP;
1054:

Line 1062: okl_api.set_message(p_app_name => G_APP_NAME

1058: IF((TRUNC(c_get_criteria_rec.effective_from_date) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date))) OR
1059: (TRUNC(NVL(c_get_criteria_rec.effective_to_date,okl_accounting_util.g_final_date)) NOT BETWEEN TRUNC(l_start_date) AND TRUNC(NVL(l_end_date,okl_accounting_util.g_final_date)))
1060: )THEN
1061: fnd_message.set_name(G_APP_NAME, 'OKL_ELIGIBILITY_CRIT_CAT');
1062: okl_api.set_message(p_app_name => G_APP_NAME
1063: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_DATES'
1064: ,p_token1 => 'CRIT_CAT'
1065: ,p_token1_value => fnd_message.get
1066: ,p_token2 => 'NAME'

Line 1068: x_return_status := OKL_API.G_RET_STS_ERROR;

1064: ,p_token1 => 'CRIT_CAT'
1065: ,p_token1_value => fnd_message.get
1066: ,p_token2 => 'NAME'
1067: ,p_token2_value => c_get_criteria_rec.crit_cat_name);
1068: x_return_status := OKL_API.G_RET_STS_ERROR;
1069: END IF;
1070: END LOOP;
1071: -- END of code changes
1072:

Line 1076: x_return_status := OKL_API.G_RET_STS_ERROR;

1072:
1073: -- sjalasut, added more validations as part of the vendor residual share enhancement.START
1074: l_return_status := validate_residual_positive(p_chr_id => p_chr_id);
1075: IF(l_return_status = 'E')THEN
1076: x_return_status := OKL_API.G_RET_STS_ERROR;
1077: END IF;
1078:
1079: l_return_status := validate_residual_parties(p_chr_id => p_chr_id);
1080: IF(l_return_status = 'E')THEN

Line 1081: x_return_status := OKL_API.G_RET_STS_ERROR;

1077: END IF;
1078:
1079: l_return_status := validate_residual_parties(p_chr_id => p_chr_id);
1080: IF(l_return_status = 'E')THEN
1081: x_return_status := OKL_API.G_RET_STS_ERROR;
1082: END IF;
1083:
1084: l_return_status := validate_total_residual(p_chr_id => p_chr_id);
1085: IF(l_return_status = 'E')THEN

Line 1086: x_return_status := OKL_API.G_RET_STS_ERROR;

1082: END IF;
1083:
1084: l_return_status := validate_total_residual(p_chr_id => p_chr_id);
1085: IF(l_return_status = 'E')THEN
1086: x_return_status := OKL_API.G_RET_STS_ERROR;
1087: END IF;
1088: -- sjalasut, added more validations as part of the vendor residual share enhancement.END
1089:
1090: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

Line 1090: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

1086: x_return_status := OKL_API.G_RET_STS_ERROR;
1087: END IF;
1088: -- sjalasut, added more validations as part of the vendor residual share enhancement.END
1089:
1090: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1091: OKL_API.set_message(
1092: p_app_name => G_APP_NAME,
1093: p_msg_name => G_QA_SUCCESS);
1094: END IF;

Line 1091: OKL_API.set_message(

1087: END IF;
1088: -- sjalasut, added more validations as part of the vendor residual share enhancement.END
1089:
1090: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1091: OKL_API.set_message(
1092: p_app_name => G_APP_NAME,
1093: p_msg_name => G_QA_SUCCESS);
1094: END IF;
1095:

Line 1107: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME,

1103: -- no processing necessary; validation can continue with next column
1104: NULL;
1105: WHEN OTHERS THEN
1106: -- store SQL error message on message stack
1107: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME,
1108: p_msg_name => G_UNEXPECTED_ERROR,
1109: p_token1 => G_SQLCODE_TOKEN,
1110: p_token1_value => SQLCODE,
1111: p_token2 => G_SQLERRM_TOKEN,

Line 1114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1110: p_token1_value => SQLCODE,
1111: p_token2 => G_SQLERRM_TOKEN,
1112: p_token2_value => SQLERRM);
1113: -- notify caller of an error as UNEXPETED error
1114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: END check_functional_constraints;
1117:
1118: END OKL_PA_DATA_INTEGRITY;