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.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_VER_PKG

Line 548: smvk 20-Dec-2002 Removed the IGS_PS_UNIT_VER_PKG.check_constraints call of owner_org_unit_cd.

544: institutional_financial_aid,same_teaching_period,exclude_from_cp_limit,
545: record_exclusion_flag,ss_display_ind,special_permission_ind,IVR_enrol_ind,
546: ss_enrol_ind,anon_unit_grading_ind,anon_assess_grading_ind,auditable_ind,
547: audit_permission_ind
548: smvk 20-Dec-2002 Removed the IGS_PS_UNIT_VER_PKG.check_constraints call of owner_org_unit_cd.
549: As owner org unit code can have value in mixed case. Bug 2487149.
550: ***********************************************************************************************/
551:
552: CURSOR cur_credit_point_des(cp_credit_point_descriptor igs_lookup_values.lookup_code%TYPE) IS

Line 561: IF igs_ps_unit_ver_pkg.get_pk_for_validation(p_unit_ver_rec.unit_cd,

557: l_var VARCHAR2(1);
558:
559: BEGIN
560: --Check for Pk validations
561: IF igs_ps_unit_ver_pkg.get_pk_for_validation(p_unit_ver_rec.unit_cd,
562: p_unit_ver_rec.version_number) THEN
563: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS','UNIT_VERSION','LEGACY_TOKENS',FALSE);
564: p_unit_ver_rec.status:='W';
565: RETURN;

Line 587: igs_ps_unit_ver_pkg.check_constraints('UNIT_CD',p_unit_ver_rec.unit_cd);

583: END IF;
584:
585: --Check constraint
586: BEGIN
587: igs_ps_unit_ver_pkg.check_constraints('UNIT_CD',p_unit_ver_rec.unit_cd);
588: EXCEPTION
589: WHEN OTHERS THEN
590: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','UNIT_CD','LEGACY_TOKENS',TRUE);
591: p_unit_ver_rec.status :='E';

Line 595: igs_ps_unit_ver_pkg.check_constraints('ABBREVIATION',p_unit_ver_rec.abbreviation);

591: p_unit_ver_rec.status :='E';
592: END;
593:
594: BEGIN
595: igs_ps_unit_ver_pkg.check_constraints('ABBREVIATION',p_unit_ver_rec.abbreviation);
596: EXCEPTION
597: WHEN OTHERS THEN
598: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','ABBREVIATION','LEGACY_TOKENS',TRUE);
599: p_unit_ver_rec.status :='E';

Line 603: igs_ps_unit_ver_pkg.check_constraints('ASSESSABLE_IND',p_unit_ver_rec.assessable_ind);

599: p_unit_ver_rec.status :='E';
600: END;
601:
602: BEGIN
603: igs_ps_unit_ver_pkg.check_constraints('ASSESSABLE_IND',p_unit_ver_rec.assessable_ind);
604: EXCEPTION
605: WHEN OTHERS THEN
606: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','ASSESSABLE_IND','LEGACY_TOKENS',TRUE);
607: p_unit_ver_rec.status :='E';

Line 611: igs_ps_unit_ver_pkg.check_constraints('AWARD_COURSE_ONLY_IND',p_unit_ver_rec.award_course_only_ind);

607: p_unit_ver_rec.status :='E';
608: END;
609:
610: BEGIN
611: igs_ps_unit_ver_pkg.check_constraints('AWARD_COURSE_ONLY_IND',p_unit_ver_rec.award_course_only_ind);
612: EXCEPTION
613: WHEN OTHERS THEN
614: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','AWARD_COURSE_ONLY_IND','LEGACY_TOKENS',TRUE);
615: p_unit_ver_rec.status :='E';

Line 619: igs_ps_unit_ver_pkg.check_constraints('CREDIT_POINT_DESCRIPTOR',p_unit_ver_rec.credit_point_descriptor);

615: p_unit_ver_rec.status :='E';
616: END;
617:
618: BEGIN
619: igs_ps_unit_ver_pkg.check_constraints('CREDIT_POINT_DESCRIPTOR',p_unit_ver_rec.credit_point_descriptor);
620: EXCEPTION
621: WHEN OTHERS THEN
622: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','CREDIT_POINT_DESCRIPTOR','LEGACY_TOKENS',TRUE);
623: p_unit_ver_rec.status :='E';

Line 627: igs_ps_unit_ver_pkg.check_constraints('INDUSTRIAL_IND',p_unit_ver_rec.industrial_ind);

623: p_unit_ver_rec.status :='E';
624: END;
625:
626: BEGIN
627: igs_ps_unit_ver_pkg.check_constraints('INDUSTRIAL_IND',p_unit_ver_rec.industrial_ind);
628: EXCEPTION
629: WHEN OTHERS THEN
630: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','INDUSTRIAL_IND','LEGACY_TOKENS',TRUE);
631: p_unit_ver_rec.status :='E';

Line 635: igs_ps_unit_ver_pkg.check_constraints('POINTS_OVERRIDE_IND',p_unit_ver_rec.points_override_ind);

631: p_unit_ver_rec.status :='E';
632: END;
633:
634: BEGIN
635: igs_ps_unit_ver_pkg.check_constraints('POINTS_OVERRIDE_IND',p_unit_ver_rec.points_override_ind);
636: EXCEPTION
637: WHEN OTHERS THEN
638: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','POINTS_OVERRIDE_IND','LEGACY_TOKENS',TRUE);
639: p_unit_ver_rec.status :='E';

Line 643: igs_ps_unit_ver_pkg.check_constraints('PRACTICAL_IND',p_unit_ver_rec.practical_ind);

639: p_unit_ver_rec.status :='E';
640: END;
641:
642: BEGIN
643: igs_ps_unit_ver_pkg.check_constraints('PRACTICAL_IND',p_unit_ver_rec.practical_ind);
644: EXCEPTION
645: WHEN OTHERS THEN
646: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','PRACTICAL_IND','LEGACY_TOKENS',TRUE);
647: p_unit_ver_rec.status :='E';

Line 651: igs_ps_unit_ver_pkg.check_constraints('REPEATABLE_IND',p_unit_ver_rec.repeatable_ind);

647: p_unit_ver_rec.status :='E';
648: END;
649:
650: BEGIN
651: igs_ps_unit_ver_pkg.check_constraints('REPEATABLE_IND',p_unit_ver_rec.repeatable_ind);
652: EXCEPTION
653: WHEN OTHERS THEN
654: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','REPEATABLE_IND','LEGACY_TOKENS',TRUE);
655: p_unit_ver_rec.status :='E';

Line 659: igs_ps_unit_ver_pkg.check_constraints('RESEARCH_UNIT_IND',p_unit_ver_rec.research_unit_ind);

655: p_unit_ver_rec.status :='E';
656: END;
657:
658: BEGIN
659: igs_ps_unit_ver_pkg.check_constraints('RESEARCH_UNIT_IND',p_unit_ver_rec.research_unit_ind);
660: EXCEPTION
661: WHEN OTHERS THEN
662: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','RESEARCH_UNIT_IND','LEGACY_TOKENS',TRUE);
663: p_unit_ver_rec.status :='E';

Line 667: igs_ps_unit_ver_pkg.check_constraints('SUPP_EXAM_PERMITTED_IND',p_unit_ver_rec.supp_exam_permitted_ind);

663: p_unit_ver_rec.status :='E';
664: END;
665:
666: BEGIN
667: igs_ps_unit_ver_pkg.check_constraints('SUPP_EXAM_PERMITTED_IND',p_unit_ver_rec.supp_exam_permitted_ind);
668: EXCEPTION
669: WHEN OTHERS THEN
670: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','SUPP_EXAM_PERMITTED_IND','LEGACY_TOKENS',TRUE);
671: p_unit_ver_rec.status :='E';

Line 675: igs_ps_unit_ver_pkg.check_constraints('TITLE_OVERRIDE_IND',p_unit_ver_rec.title_override_ind);

671: p_unit_ver_rec.status :='E';
672: END;
673:
674: BEGIN
675: igs_ps_unit_ver_pkg.check_constraints('TITLE_OVERRIDE_IND',p_unit_ver_rec.title_override_ind);
676: EXCEPTION
677: WHEN OTHERS THEN
678: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','TITLE_OVERRIDE_IND','LEGACY_TOKENS',TRUE);
679: p_unit_ver_rec.status :='E';

Line 685: igs_ps_unit_ver_pkg.check_constraints('STATE_FINANCIAL_AID',p_unit_ver_rec.state_financial_aid);

681:
682: -----------------------------------Following checks are done as a part of bug#2702240---------------
683:
684: BEGIN
685: igs_ps_unit_ver_pkg.check_constraints('STATE_FINANCIAL_AID',p_unit_ver_rec.state_financial_aid);
686: EXCEPTION
687: WHEN OTHERS THEN
688: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','STATE_FINANCIAL_AID','LEGACY_TOKENS',TRUE);
689: p_unit_ver_rec.status :='E';

Line 693: igs_ps_unit_ver_pkg.check_constraints('FEDERAL_FINANCIAL_AID',p_unit_ver_rec.federal_financial_aid);

689: p_unit_ver_rec.status :='E';
690: END;
691:
692: BEGIN
693: igs_ps_unit_ver_pkg.check_constraints('FEDERAL_FINANCIAL_AID',p_unit_ver_rec.federal_financial_aid);
694: EXCEPTION
695: WHEN OTHERS THEN
696: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','FEDERAL_FINANCIAL_AID','LEGACY_TOKENS',TRUE);
697: p_unit_ver_rec.status :='E';

Line 701: igs_ps_unit_ver_pkg.check_constraints('INSTITUTIONAL_FINANCIAL_AID',p_unit_ver_rec.institutional_financial_aid);

697: p_unit_ver_rec.status :='E';
698: END;
699:
700: BEGIN
701: igs_ps_unit_ver_pkg.check_constraints('INSTITUTIONAL_FINANCIAL_AID',p_unit_ver_rec.institutional_financial_aid);
702: EXCEPTION
703: WHEN OTHERS THEN
704: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','INSTITUTIONAL_FINANCIAL_AID','LEGACY_TOKENS',TRUE);
705: p_unit_ver_rec.status :='E';

Line 709: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACHING_PERIOD',p_unit_ver_rec.same_teaching_period);

705: p_unit_ver_rec.status :='E';
706: END;
707:
708: BEGIN
709: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACHING_PERIOD',p_unit_ver_rec.same_teaching_period);
710: EXCEPTION
711: WHEN OTHERS THEN
712: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','SAME_TEACHING_PERIOD','LEGACY_TOKENS',TRUE);
713: p_unit_ver_rec.status :='E';

Line 717: igs_ps_unit_ver_pkg.check_constraints('EXCLUDE_FROM_MAX_CP_LIMIT',p_unit_ver_rec.exclude_from_max_cp_limit);

713: p_unit_ver_rec.status :='E';
714: END;
715:
716: BEGIN
717: igs_ps_unit_ver_pkg.check_constraints('EXCLUDE_FROM_MAX_CP_LIMIT',p_unit_ver_rec.exclude_from_max_cp_limit);
718: EXCEPTION
719: WHEN OTHERS THEN
720: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','EXCLUDE_FROM_MAX_CP_LIMIT','LEGACY_TOKENS',TRUE);
721: p_unit_ver_rec.status :='E';

Line 725: igs_ps_unit_ver_pkg.check_constraints('RECORD_EXCLUSION_FLAG',p_unit_ver_rec.record_exclusion_flag);

721: p_unit_ver_rec.status :='E';
722: END;
723:
724: BEGIN
725: igs_ps_unit_ver_pkg.check_constraints('RECORD_EXCLUSION_FLAG',p_unit_ver_rec.record_exclusion_flag);
726: EXCEPTION
727: WHEN OTHERS THEN
728: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','RECORD_EXCLUSION_FLAG','LEGACY_TOKENS',TRUE);
729: p_unit_ver_rec.status :='E';

Line 733: igs_ps_unit_ver_pkg.check_constraints('SS_DISPLAY_IND',p_unit_ver_rec.ss_display_ind);

729: p_unit_ver_rec.status :='E';
730: END;
731:
732: BEGIN
733: igs_ps_unit_ver_pkg.check_constraints('SS_DISPLAY_IND',p_unit_ver_rec.ss_display_ind);
734: EXCEPTION
735: WHEN OTHERS THEN
736: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','SS_DISPLAY_IND','LEGACY_TOKENS',TRUE);
737: p_unit_ver_rec.status :='E';

Line 741: igs_ps_unit_ver_pkg.check_constraints('SPECIAL_PERMISSION_IND',p_unit_ver_rec.special_permission_ind);

737: p_unit_ver_rec.status :='E';
738: END;
739:
740: BEGIN
741: igs_ps_unit_ver_pkg.check_constraints('SPECIAL_PERMISSION_IND',p_unit_ver_rec.special_permission_ind);
742: EXCEPTION
743: WHEN OTHERS THEN
744: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','SPECIAL_PERMISSION_IND','LEGACY_TOKENS',TRUE);
745: p_unit_ver_rec.status :='E';

Line 777: igs_ps_unit_ver_pkg.check_constraints('ANON_UNIT_GRADING_IND',p_unit_ver_rec.anon_unit_grading_ind);

773: END IF;
774:
775:
776: BEGIN
777: igs_ps_unit_ver_pkg.check_constraints('ANON_UNIT_GRADING_IND',p_unit_ver_rec.anon_unit_grading_ind);
778: EXCEPTION
779: WHEN OTHERS THEN
780: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','ANON_UNIT_GRADING_IND','LEGACY_TOKENS',TRUE);
781: p_unit_ver_rec.status :='E';

Line 785: igs_ps_unit_ver_pkg.check_constraints('ANON_ASSESS_GRADING_IND',p_unit_ver_rec.anon_assess_grading_ind);

781: p_unit_ver_rec.status :='E';
782: END;
783:
784: BEGIN
785: igs_ps_unit_ver_pkg.check_constraints('ANON_ASSESS_GRADING_IND',p_unit_ver_rec.anon_assess_grading_ind);
786: EXCEPTION
787: WHEN OTHERS THEN
788: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','ANON_ASSESS_GRADING_IND','LEGACY_TOKENS',TRUE);
789: p_unit_ver_rec.status :='E';

Line 793: igs_ps_unit_ver_pkg.check_constraints('AUDITABLE_IND',p_unit_ver_rec.auditable_ind);

789: p_unit_ver_rec.status :='E';
790: END;
791:
792: BEGIN
793: igs_ps_unit_ver_pkg.check_constraints('AUDITABLE_IND',p_unit_ver_rec.auditable_ind);
794: EXCEPTION
795: WHEN OTHERS THEN
796: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','AUDITABLE_IND','LEGACY_TOKENS',TRUE);
797: p_unit_ver_rec.status :='E';

Line 801: igs_ps_unit_ver_pkg.check_constraints('AUDIT_PERMISSION_IND',p_unit_ver_rec.audit_permission_ind);

797: p_unit_ver_rec.status :='E';
798: END;
799:
800: BEGIN
801: igs_ps_unit_ver_pkg.check_constraints('AUDIT_PERMISSION_IND',p_unit_ver_rec.audit_permission_ind);
802: EXCEPTION
803: WHEN OTHERS THEN
804: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','AUDIT_PERMISSION_IND','LEGACY_TOKENS',TRUE);
805: p_unit_ver_rec.status :='E';

Line 810: igs_ps_unit_ver_pkg.check_constraints('UNIT_INT_COURSE_LEVEL_CD',p_unit_ver_rec.unit_int_course_level_cd);

806: END;
807: -----------------------------------------------------------------------------------------------------
808:
809: BEGIN
810: igs_ps_unit_ver_pkg.check_constraints('UNIT_INT_COURSE_LEVEL_CD',p_unit_ver_rec.unit_int_course_level_cd);
811: EXCEPTION
812: WHEN OTHERS THEN
813: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','UNIT_INT_COURSE_LEVEL_CD','LEGACY_TOKENS',TRUE);
814: p_unit_ver_rec.status :='E';

Line 818: igs_ps_unit_ver_pkg.check_constraints('UNIT_STATUS',p_unit_ver_rec.unit_status);

814: p_unit_ver_rec.status :='E';
815: END;
816:
817: BEGIN
818: igs_ps_unit_ver_pkg.check_constraints('UNIT_STATUS',p_unit_ver_rec.unit_status);
819: EXCEPTION
820: WHEN OTHERS THEN
821: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','UNIT_STATUS','LEGACY_TOKENS',TRUE);
822: p_unit_ver_rec.status :='E';

Line 826: igs_ps_unit_ver_pkg.check_constraints('UNIT_LEVEL',p_unit_ver_rec.unit_level);

822: p_unit_ver_rec.status :='E';
823: END;
824:
825: BEGIN
826: igs_ps_unit_ver_pkg.check_constraints('UNIT_LEVEL',p_unit_ver_rec.unit_level);
827: EXCEPTION
828: WHEN OTHERS THEN
829: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','UNIT_LEVEL','LEGACY_TOKENS',TRUE);
830: p_unit_ver_rec.status :='E';

Line 834: igs_ps_unit_ver_pkg.check_constraints('ACHIEVABLE_CREDIT_POINTS',p_unit_ver_rec.achievable_credit_points);

830: p_unit_ver_rec.status :='E';
831: END;
832:
833: BEGIN
834: igs_ps_unit_ver_pkg.check_constraints('ACHIEVABLE_CREDIT_POINTS',p_unit_ver_rec.achievable_credit_points);
835: EXCEPTION
836: WHEN OTHERS THEN
837: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','ACHIEVABLE_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
838: p_unit_ver_rec.status :='E';

Line 842: igs_ps_unit_ver_pkg.check_constraints('POINTS_INCREMENT',p_unit_ver_rec.points_increment);

838: p_unit_ver_rec.status :='E';
839: END;
840:
841: BEGIN
842: igs_ps_unit_ver_pkg.check_constraints('POINTS_INCREMENT',p_unit_ver_rec.points_increment);
843: EXCEPTION
844: WHEN OTHERS THEN
845: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','POINTS_INCREMENT','LEGACY_TOKENS',TRUE);
846: p_unit_ver_rec.status :='E';

Line 850: igs_ps_unit_ver_pkg.check_constraints('POINTS_MIN',p_unit_ver_rec.points_min);

846: p_unit_ver_rec.status :='E';
847: END;
848:
849: BEGIN
850: igs_ps_unit_ver_pkg.check_constraints('POINTS_MIN',p_unit_ver_rec.points_min);
851: EXCEPTION
852: WHEN OTHERS THEN
853: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','POINTS_MIN','LEGACY_TOKENS',TRUE);
854: p_unit_ver_rec.status :='E';

Line 858: igs_ps_unit_ver_pkg.check_constraints('POINTS_MAX',p_unit_ver_rec.points_max);

854: p_unit_ver_rec.status :='E';
855: END;
856:
857: BEGIN
858: igs_ps_unit_ver_pkg.check_constraints('POINTS_MAX',p_unit_ver_rec.points_max);
859: EXCEPTION
860: WHEN OTHERS THEN
861: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','POINTS_MAX','LEGACY_TOKENS',TRUE);
862: p_unit_ver_rec.status :='E';

Line 866: igs_ps_unit_ver_pkg.check_constraints('ENROLLED_CREDIT_POINTS',p_unit_ver_rec.enrolled_credit_points);

862: p_unit_ver_rec.status :='E';
863: END;
864:
865: BEGIN
866: igs_ps_unit_ver_pkg.check_constraints('ENROLLED_CREDIT_POINTS',p_unit_ver_rec.enrolled_credit_points);
867: EXCEPTION
868: WHEN OTHERS THEN
869: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','ENROLLED_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
870: p_unit_ver_rec.status :='E';

Line 874: igs_ps_unit_ver_pkg.check_constraints('VERSION_NUMBER',p_unit_ver_rec.version_number);

870: p_unit_ver_rec.status :='E';
871: END;
872:
873: BEGIN
874: igs_ps_unit_ver_pkg.check_constraints('VERSION_NUMBER',p_unit_ver_rec.version_number);
875: EXCEPTION
876: WHEN OTHERS THEN
877: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VER_NUM_1_999',NULL,NULL,TRUE);
878: p_unit_ver_rec.status :='E';

Line 883: igs_ps_unit_ver_pkg.check_constraints ( 'BILLING_CREDIT_POINTS', p_unit_ver_rec.billing_credit_points);

879: END;
880:
881: IF p_unit_ver_rec.billing_credit_points IS NOT NULL THEN
882: BEGIN
883: igs_ps_unit_ver_pkg.check_constraints ( 'BILLING_CREDIT_POINTS', p_unit_ver_rec.billing_credit_points);
884: EXCEPTION
885: WHEN OTHERS THEN
886: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999', 'BILLING_CREDIT_POINTS', 'LEGACY_TOKENS', TRUE);
887: p_unit_ver_rec.status := 'E';

Line 941: igs_ps_unit_ver_pkg.check_constraints('CLAIMABLE_HOURS',p_unit_ver_rec.claimable_hours);

937:
938: -- Added as a part of 2702263
939: IF p_unit_ver_rec.claimable_hours IS NOT NULL THEN
940: BEGIN
941: igs_ps_unit_ver_pkg.check_constraints('CLAIMABLE_HOURS',p_unit_ver_rec.claimable_hours);
942: EXCEPTION
943: WHEN OTHERS THEN
944: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','CLAIMABLE_HOURS','LEGACY_TOKENS',TRUE);
945: p_unit_ver_rec.status :='E';

Line 951: igs_ps_unit_ver_pkg.check_constraints('LECTURE_CREDIT_POINTS',p_unit_ver_rec.lecture_credit_points);

947: END IF;
948:
949: IF p_unit_ver_rec.lecture_credit_points IS NOT NULL THEN
950: BEGIN
951: igs_ps_unit_ver_pkg.check_constraints('LECTURE_CREDIT_POINTS',p_unit_ver_rec.lecture_credit_points);
952: EXCEPTION
953: WHEN OTHERS THEN
954: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','LECTURE_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
955: p_unit_ver_rec.status :='E';

Line 961: igs_ps_unit_ver_pkg.check_constraints('LAB_CREDIT_POINTS',p_unit_ver_rec.lab_credit_points);

957: END IF;
958:
959: IF p_unit_ver_rec.lab_credit_points IS NOT NULL THEN
960: BEGIN
961: igs_ps_unit_ver_pkg.check_constraints('LAB_CREDIT_POINTS',p_unit_ver_rec.lab_credit_points);
962: EXCEPTION
963: WHEN OTHERS THEN
964: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','LAB_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
965: p_unit_ver_rec.status :='E';

Line 971: igs_ps_unit_ver_pkg.check_constraints('OTHER_CREDIT_POINTS',p_unit_ver_rec.other_credit_points);

967: END IF;
968:
969: IF p_unit_ver_rec.other_credit_points IS NOT NULL THEN
970: BEGIN
971: igs_ps_unit_ver_pkg.check_constraints('OTHER_CREDIT_POINTS',p_unit_ver_rec.other_credit_points);
972: EXCEPTION
973: WHEN OTHERS THEN
974: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','OTHER_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
975: p_unit_ver_rec.status :='E';

Line 981: igs_ps_unit_ver_pkg.check_constraints('CLOCK_HOURS',p_unit_ver_rec.clock_hours);

977: END IF;
978:
979: IF p_unit_ver_rec.clock_hours IS NOT NULL THEN
980: BEGIN
981: igs_ps_unit_ver_pkg.check_constraints('CLOCK_HOURS',p_unit_ver_rec.clock_hours);
982: EXCEPTION
983: WHEN OTHERS THEN
984: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','CLOCK_HOURS','LEGACY_TOKENS',TRUE);
985: p_unit_ver_rec.status :='E';

Line 991: igs_ps_unit_ver_pkg.check_constraints('CONTINUING_EDUCATION_UNITS',p_unit_ver_rec.continuing_education_units);

987: END IF;
988:
989: IF p_unit_ver_rec.continuing_education_units IS NOT NULL THEN
990: BEGIN
991: igs_ps_unit_ver_pkg.check_constraints('CONTINUING_EDUCATION_UNITS',p_unit_ver_rec.continuing_education_units);
992: EXCEPTION
993: WHEN OTHERS THEN
994: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','CONTINUING_EDUCATION_UNITS','LEGACY_TOKENS',TRUE);
995: p_unit_ver_rec.status :='E';

Line 1001: igs_ps_unit_ver_pkg.check_constraints('ADVANCE_MAXIMUM',p_unit_ver_rec.advance_maximum);

997: END IF;
998:
999: IF p_unit_ver_rec.advance_maximum IS NOT NULL THEN
1000: BEGIN
1001: igs_ps_unit_ver_pkg.check_constraints('ADVANCE_MAXIMUM',p_unit_ver_rec.advance_maximum);
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ADVANCE_MAXIMUM','LEGACY_TOKENS',TRUE);
1005: p_unit_ver_rec.status :='E';

Line 1011: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_EXPECTED',p_unit_ver_rec.enrollment_expected);

1007: END IF;
1008:
1009: IF p_unit_ver_rec.enrollment_expected IS NOT NULL THEN
1010: BEGIN
1011: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_EXPECTED',p_unit_ver_rec.enrollment_expected);
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_EXPECTED','LEGACY_TOKENS',TRUE);
1015: p_unit_ver_rec.status :='E';

Line 1021: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MINIMUM',p_unit_ver_rec.enrollment_minimum);

1017: END IF;
1018:
1019: IF p_unit_ver_rec.enrollment_minimum IS NOT NULL THEN
1020: BEGIN
1021: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MINIMUM',p_unit_ver_rec.enrollment_minimum);
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_MINIMUM','LEGACY_TOKENS',TRUE);
1025: p_unit_ver_rec.status :='E';

Line 1031: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MAXIMUM',p_unit_ver_rec.enrollment_maximum);

1027: END IF;
1028:
1029: IF p_unit_ver_rec.enrollment_maximum IS NOT NULL THEN
1030: BEGIN
1031: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MAXIMUM',p_unit_ver_rec.enrollment_maximum);
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_MAXIMUM','LEGACY_TOKENS',TRUE);
1035: p_unit_ver_rec.status :='E';

Line 1041: igs_ps_unit_ver_pkg.check_constraints('OVERRIDE_ENROLLMENT_MAX',p_unit_ver_rec.override_enrollment_max);

1037: END IF;
1038:
1039: IF p_unit_ver_rec.override_enrollment_max IS NOT NULL THEN
1040: BEGIN
1041: igs_ps_unit_ver_pkg.check_constraints('OVERRIDE_ENROLLMENT_MAX',p_unit_ver_rec.override_enrollment_max);
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','OVERRIDE_ENROLLMENT_MAX','LEGACY_TOKENS',TRUE);
1045: p_unit_ver_rec.status :='E';

Line 1051: igs_ps_unit_ver_pkg.check_constraints('MAX_AUDITORS_ALLOWED',p_unit_ver_rec.max_auditors_allowed);

1047: END IF;
1048:
1049: IF p_unit_ver_rec.max_auditors_allowed IS NOT NULL THEN
1050: BEGIN
1051: igs_ps_unit_ver_pkg.check_constraints('MAX_AUDITORS_ALLOWED',p_unit_ver_rec.max_auditors_allowed);
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_1_999999','MAX_AUDITORS_ALLOWED','LEGACY_TOKENS',TRUE);
1055: p_unit_ver_rec.status :='E';

Line 1061: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_CP_LECTURE',p_unit_ver_rec.work_load_cp_lecture);

1057: END IF;
1058:
1059: IF p_unit_ver_rec.work_load_cp_lecture IS NOT NULL THEN
1060: BEGIN
1061: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_CP_LECTURE',p_unit_ver_rec.work_load_cp_lecture);
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','WORK_LOAD_CP_LECTURE','LEGACY_TOKENS',TRUE);
1065: p_unit_ver_rec.status :='E';

Line 1072: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_CP_LAB',p_unit_ver_rec.work_load_cp_lab);

1068:
1069:
1070: IF p_unit_ver_rec.work_load_cp_lab IS NOT NULL THEN
1071: BEGIN
1072: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_CP_LAB',p_unit_ver_rec.work_load_cp_lab);
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','WORK_LOAD_CP_LAB','LEGACY_TOKENS',TRUE);
1076: p_unit_ver_rec.status :='E';

Line 1082: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEAT_CREDIT_POINTS',p_unit_ver_rec.max_repeat_credit_points);

1078: END IF;
1079:
1080: IF p_unit_ver_rec.max_repeat_credit_points IS NOT NULL THEN
1081: BEGIN
1082: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEAT_CREDIT_POINTS',p_unit_ver_rec.max_repeat_credit_points);
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','MAX_REPEAT_CREDIT_POINTS','LEGACY_TOKENS',TRUE);
1086: p_unit_ver_rec.status :='E';

Line 1092: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACH_PERIOD_REPEATS_CP',p_unit_ver_rec.same_teach_period_repeats_cp);

1088: END IF;
1089:
1090: IF p_unit_ver_rec.same_teach_period_repeats_cp IS NOT NULL THEN
1091: BEGIN
1092: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACH_PERIOD_REPEATS_CP',p_unit_ver_rec.same_teach_period_repeats_cp);
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','SAME_TEACH_PERIOD_REPEATS_CP','LEGACY_TOKENS',TRUE);
1096: p_unit_ver_rec.status :='E';

Line 1102: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_OTHER',p_unit_ver_rec.work_load_other);

1098: END IF;
1099:
1100: IF p_unit_ver_rec.work_load_other IS NOT NULL THEN
1101: BEGIN
1102: igs_ps_unit_ver_pkg.check_constraints('WORK_LOAD_OTHER',p_unit_ver_rec.work_load_other);
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','WORK_LOAD_OTHER','LEGACY_TOKENS',TRUE);
1106: p_unit_ver_rec.status :='E';

Line 1112: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_LECTURE',p_unit_ver_rec.contact_hrs_lecture);

1108: END IF;
1109:
1110: IF p_unit_ver_rec.contact_hrs_lecture IS NOT NULL THEN
1111: BEGIN
1112: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_LECTURE',p_unit_ver_rec.contact_hrs_lecture);
1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','CONTACT_HRS_LECTURE','LEGACY_TOKENS',TRUE);
1116: p_unit_ver_rec.status :='E';

Line 1122: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_LAB',p_unit_ver_rec.contact_hrs_lab);

1118: END IF;
1119:
1120: IF p_unit_ver_rec.contact_hrs_lab IS NOT NULL THEN
1121: BEGIN
1122: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_LAB',p_unit_ver_rec.contact_hrs_lab);
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','CONTACT_HRS_LAB','LEGACY_TOKENS',TRUE);
1126: p_unit_ver_rec.status :='E';

Line 1132: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_OTHER',p_unit_ver_rec.contact_hrs_other);

1128: END IF;
1129:
1130: IF p_unit_ver_rec.contact_hrs_other IS NOT NULL THEN
1131: BEGIN
1132: igs_ps_unit_ver_pkg.check_constraints('CONTACT_HRS_OTHER',p_unit_ver_rec.contact_hrs_other);
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','CONTACT_HRS_OTHER','LEGACY_TOKENS',TRUE);
1136: p_unit_ver_rec.status :='E';

Line 1142: igs_ps_unit_ver_pkg.check_constraints('NON_SCHD_REQUIRED_HRS',p_unit_ver_rec.non_schd_required_hrs);

1138: END IF;
1139:
1140: IF p_unit_ver_rec.non_schd_required_hrs IS NOT NULL THEN
1141: BEGIN
1142: igs_ps_unit_ver_pkg.check_constraints('NON_SCHD_REQUIRED_HRS',p_unit_ver_rec.non_schd_required_hrs);
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','NON_SCHD_REQUIRED_HRS','LEGACY_TOKENS',TRUE);
1146: p_unit_ver_rec.status :='E';

Line 1152: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEATS_FOR_CREDIT',p_unit_ver_rec.max_repeats_for_credit);

1148: END IF;
1149:
1150: IF p_unit_ver_rec.max_repeats_for_credit IS NOT NULL THEN
1151: BEGIN
1152: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEATS_FOR_CREDIT',p_unit_ver_rec.max_repeats_for_credit);
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999','MAX_REPEATS_FOR_CREDIT','LEGACY_TOKENS',TRUE);
1156: p_unit_ver_rec.status :='E';

Line 1162: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEATS_FOR_FUNDING',p_unit_ver_rec.max_repeats_for_funding);

1158: END IF;
1159:
1160: IF p_unit_ver_rec.max_repeats_for_funding IS NOT NULL THEN
1161: BEGIN
1162: igs_ps_unit_ver_pkg.check_constraints('MAX_REPEATS_FOR_FUNDING',p_unit_ver_rec.max_repeats_for_funding);
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999','MAX_REPEATS_FOR_FUNDING','LEGACY_TOKENS',TRUE);
1166: p_unit_ver_rec.status :='E';

Line 1172: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACH_PERIOD_REPEATS',p_unit_ver_rec.same_teach_period_repeats);

1168: END IF;
1169:
1170: IF p_unit_ver_rec.same_teach_period_repeats IS NOT NULL THEN
1171: BEGIN
1172: igs_ps_unit_ver_pkg.check_constraints('SAME_TEACH_PERIOD_REPEATS',p_unit_ver_rec.same_teach_period_repeats);
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999','SAME_TEACH_PERIOD_REPEATS','LEGACY_TOKENS',TRUE);
1176: p_unit_ver_rec.status :='E';

Line 1182: igs_ps_unit_ver_pkg.check_constraints('OVRD_WKLD_VAL_FLAG',p_unit_ver_rec.ovrd_wkld_val_flag);

1178: END IF;
1179:
1180:
1181: BEGIN
1182: igs_ps_unit_ver_pkg.check_constraints('OVRD_WKLD_VAL_FLAG',p_unit_ver_rec.ovrd_wkld_val_flag);
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','OVRD_WKLD_VAL_FLAG','LEGACY_TOKENS',TRUE);
1186: p_unit_ver_rec.status :='E';

Line 1198: igs_ps_unit_ver_pkg.check_constraints('BILLING_HRS',p_unit_ver_rec.billing_hrs);

1194: END IF;
1195:
1196: IF p_unit_ver_rec.billing_hrs IS NOT NULL THEN
1197: BEGIN
1198: igs_ps_unit_ver_pkg.check_constraints('BILLING_HRS',p_unit_ver_rec.billing_hrs);
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D999','BILLING_HRS','LEGACY_TOKENS',TRUE);
1202: p_unit_ver_rec.status :='E';

Line 1719: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (

1715: l_d_ou_start_dt ) THEN
1716: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ORG_UNIT_CD', 'LEGACY_TOKENS', FALSE);
1717: p_teach_resp_rec.status := 'E';
1718: END IF;
1719: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
1720: p_teach_resp_rec.unit_cd,
1721: p_teach_resp_rec.version_number ) THEN
1722: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
1723: p_teach_resp_rec.status := 'E';

Line 1962: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (p_unit_dscp_rec.unit_cd, p_unit_dscp_rec.version_number) THEN

1958: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'DISCIPLINE_GROUP_CD', 'LEGACY_TOKENS', FALSE);
1959: p_unit_dscp_rec.status := 'E';
1960: END IF;
1961:
1962: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (p_unit_dscp_rec.unit_cd, p_unit_dscp_rec.version_number) THEN
1963: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
1964: p_unit_dscp_rec.status := 'E';
1965: END IF;
1966:

Line 2159: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation ( p_grd_sch_rec.unit_cd, p_grd_sch_rec.version_number ) THEN

2155: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_GRADING_SCHM', 'LEGACY_TOKENS', FALSE);
2156: p_grd_sch_rec.status := 'E';
2157: END IF;
2158:
2159: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation ( p_grd_sch_rec.unit_cd, p_grd_sch_rec.version_number ) THEN
2160: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
2161: p_grd_sch_rec.status := 'E';
2162: END IF;
2163: END validate_db_cons;

Line 2565: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation ( p_usec_rec.unit_cd, p_usec_rec.version_number ) THEN

2561: END IF;
2562: END;
2563:
2564: BEGIN
2565: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation ( p_usec_rec.unit_cd, p_usec_rec.version_number ) THEN
2566: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
2567: p_usec_rec.status := 'E';
2568: END IF;
2569: END;

Line 5243: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_EXPECTED',p_usec_rec.enrollment_expected);

5239: END IF;
5240:
5241: IF p_usec_rec.enrollment_expected IS NOT NULL THEN
5242: BEGIN
5243: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_EXPECTED',p_usec_rec.enrollment_expected);
5244: EXCEPTION
5245: WHEN OTHERS THEN
5246: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_EXPECTED','LEGACY_TOKENS',TRUE);
5247: p_usec_rec.status :='E';

Line 5253: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MINIMUM',p_usec_rec.enrollment_minimum);

5249: END IF;
5250:
5251: IF p_usec_rec.enrollment_minimum IS NOT NULL THEN
5252: BEGIN
5253: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MINIMUM',p_usec_rec.enrollment_minimum);
5254: EXCEPTION
5255: WHEN OTHERS THEN
5256: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_MINIMUM','LEGACY_TOKENS',TRUE);
5257: p_usec_rec.status :='E';

Line 5263: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MAXIMUM',p_usec_rec.enrollment_maximum);

5259: END IF;
5260:
5261: IF p_usec_rec.enrollment_maximum IS NOT NULL THEN
5262: BEGIN
5263: igs_ps_unit_ver_pkg.check_constraints('ENROLLMENT_MAXIMUM',p_usec_rec.enrollment_maximum);
5264: EXCEPTION
5265: WHEN OTHERS THEN
5266: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ENROLLMENT_MAXIMUM','LEGACY_TOKENS',TRUE);
5267: p_usec_rec.status :='E';

Line 5273: igs_ps_unit_ver_pkg.check_constraints('ADVANCE_MAXIMUM',p_usec_rec.advance_maximum);

5269: END IF;
5270:
5271: IF p_usec_rec.advance_maximum IS NOT NULL THEN
5272: BEGIN
5273: igs_ps_unit_ver_pkg.check_constraints('ADVANCE_MAXIMUM',p_usec_rec.advance_maximum);
5274: EXCEPTION
5275: WHEN OTHERS THEN
5276: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','ADVANCE_MAXIMUM','LEGACY_TOKENS',TRUE);
5277: p_usec_rec.status :='E';

Line 5283: igs_ps_unit_ver_pkg.check_constraints('OVERRIDE_ENROLLMENT_MAX',p_usec_rec.override_enrollment_maximum);

5279: END IF;
5280:
5281: IF p_usec_rec.override_enrollment_maximum IS NOT NULL THEN
5282: BEGIN
5283: igs_ps_unit_ver_pkg.check_constraints('OVERRIDE_ENROLLMENT_MAX',p_usec_rec.override_enrollment_maximum);
5284: EXCEPTION
5285: WHEN OTHERS THEN
5286: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','OVERRIDE_ENROLLMENT_MAX','LEGACY_TOKENS',TRUE);
5287: p_usec_rec.status :='E';

Line 5293: igs_ps_unit_ver_pkg.check_constraints('MAX_AUDITORS_ALLOWED',p_usec_rec. max_auditors_allowed);

5289: END IF;
5290:
5291: IF p_usec_rec.max_auditors_allowed IS NOT NULL THEN
5292: BEGIN
5293: igs_ps_unit_ver_pkg.check_constraints('MAX_AUDITORS_ALLOWED',p_usec_rec. max_auditors_allowed);
5294: EXCEPTION
5295: WHEN OTHERS THEN
5296: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','MAX_AUDITORS_ALLOWED','LEGACY_TOKENS',TRUE);
5297: p_usec_rec.status :='E';

Line 7669: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation(p_ref_cd_rec.unit_cd, p_ref_cd_rec.version_number) THEN

7665: END IF;
7666: CLOSE c_res_flag;
7667:
7668: -- Foreign Key Validations : Unit Version doesn't exists
7669: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation(p_ref_cd_rec.unit_cd, p_ref_cd_rec.version_number) THEN
7670: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_VERSION','LEGACY_TOKENS', FALSE);
7671: p_ref_cd_rec.status := 'E';
7672: END IF;
7673:

Line 8531: igs_ps_unit_ver_pkg.check_constraints( 'UNIT_CD',p_uso_ins_rec.unit_cd);

8527: END IF;
8528:
8529: -- Check Constraints
8530: BEGIN
8531: igs_ps_unit_ver_pkg.check_constraints( 'UNIT_CD',p_uso_ins_rec.unit_cd);
8532: EXCEPTION
8533: WHEN OTHERS THEN
8534: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE','UNIT_CD','LEGACY_TOKENS',TRUE);
8535: p_uso_ins_rec.status :='E';

Line 8539: igs_ps_unit_ver_pkg.check_constraints('VERSION_NUMBER',p_uso_ins_rec.version_number);

8535: p_uso_ins_rec.status :='E';
8536: END;
8537:
8538: BEGIN
8539: igs_ps_unit_ver_pkg.check_constraints('VERSION_NUMBER',p_uso_ins_rec.version_number);
8540: EXCEPTION
8541: WHEN OTHERS THEN
8542: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VER_NUM_1_999',NULL,NULL,TRUE);
8543: p_uso_ins_rec.status :='E';