761: lv_error_mesg := 'Error in DISPMAG record for Employee '||lv_paternal_last_name || ' - ' ;
762:
763: if lv_er_ss_id is null then
764: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
765: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
766: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
767: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
768: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
769: end if;
762:
763: if lv_er_ss_id is null then
764: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
765: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
766: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
767: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
768: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
769: end if;
770:
763: if lv_er_ss_id is null then
764: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
765: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
766: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
767: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
768: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
769: end if;
770:
771: if lv_er_ss_chk_digit is null then
764: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
765: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
766: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
767: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
768: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
769: end if;
770:
771: if lv_er_ss_chk_digit is null then
772: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
769: end if;
770:
771: if lv_er_ss_chk_digit is null then
772: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
773: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
774: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
775: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
776: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
777: end if;
770:
771: if lv_er_ss_chk_digit is null then
772: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
773: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
774: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
775: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
776: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
777: end if;
778:
771: if lv_er_ss_chk_digit is null then
772: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
773: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
774: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
775: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
776: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
777: end if;
778:
779: if lv_ee_ss_id is null then
772: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
773: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
774: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
775: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
776: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
777: end if;
778:
779: if lv_ee_ss_id is null then
780: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
777: end if;
778:
779: if lv_ee_ss_id is null then
780: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
781: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
782: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
783: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
784: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
785:
778:
779: if lv_ee_ss_id is null then
780: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
781: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
782: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
783: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
784: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
785:
786: end if;
779: if lv_ee_ss_id is null then
780: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
781: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
782: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
783: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
784: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
785:
786: end if;
787:
780: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
781: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
782: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
783: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
784: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
785:
786: end if;
787:
788: if lv_ee_ss_chk_digit is null then
786: end if;
787:
788: if lv_ee_ss_chk_digit is null then
789: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
790: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
791: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
792: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
793: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
794:
787:
788: if lv_ee_ss_chk_digit is null then
789: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
790: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
791: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
792: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
793: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
794:
795: end if;
788: if lv_ee_ss_chk_digit is null then
789: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
790: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
791: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
792: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
793: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
794:
795: end if;
796:
789: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
790: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
791: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
792: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
793: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
794:
795: end if;
796:
797:
796:
797:
798: if lv_name is null then
799: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
800: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
801: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
802: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
803: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
804:
797:
798: if lv_name is null then
799: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
800: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
801: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
802: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
803: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
804:
805: end if;
798: if lv_name is null then
799: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
800: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
801: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
802: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
803: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
804:
805: end if;
806:
799: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
800: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
801: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
802: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
803: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
804:
805: end if;
806:
807:
806:
807:
808: if to_number(nvl(lv_IDW,'0')) <= 0 then
809: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
810: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
811: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
812: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
813: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
814:
807:
808: if to_number(nvl(lv_IDW,'0')) <= 0 then
809: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
810: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
811: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
812: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
813: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
814:
815: end if;
808: if to_number(nvl(lv_IDW,'0')) <= 0 then
809: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
810: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
811: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
812: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
813: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
814:
815: end if;
816:
809: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
810: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
811: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
812: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
813: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
814:
815: end if;
816:
817: if lv_worker_type is null then
815: end if;
816:
817: if lv_worker_type is null then
818: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
819: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
820: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
821: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
822: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
823:
816:
817: if lv_worker_type is null then
818: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
819: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
820: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
821: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
822: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
823:
824: end if;
817: if lv_worker_type is null then
818: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
819: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
820: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
821: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
822: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
823:
824: end if;
825:
818: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
819: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
820: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
821: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
822: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
823:
824: end if;
825:
826:
825:
826:
827: if lv_salary_type is null then
828: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
829: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
830: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
831: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
832: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
833:
826:
827: if lv_salary_type is null then
828: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
829: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
830: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
831: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
832: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
833:
834: end if;
827: if lv_salary_type is null then
828: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
829: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
830: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
831: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
832: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
833:
834: end if;
835:
828: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
829: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
830: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
831: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
832: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
833:
834: end if;
835:
836: if lv_rww is null then
834: end if;
835:
836: if lv_rww is null then
837: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
838: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
839: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
840: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
841: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
842:
835:
836: if lv_rww is null then
837: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
838: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
839: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
840: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
841: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
842:
843: end if;
836: if lv_rww is null then
837: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
838: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
839: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
840: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
841: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
842:
843: end if;
844:
837: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
838: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
839: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
840: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
841: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
842:
843: end if;
844:
845: if lv_hire_date is null then
843: end if;
844:
845: if lv_hire_date is null then
846: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
847: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
848: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
849: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
850: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
851:
844:
845: if lv_hire_date is null then
846: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
847: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
848: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
849: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
850: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
851:
852: end if;
845: if lv_hire_date is null then
846: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
847: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
848: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
849: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
850: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
851:
852: end if;
853:
846: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
847: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
848: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
849: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
850: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
851:
852: end if;
853:
854: if lv_imss_waybill is null then
852: end if;
853:
854: if lv_imss_waybill is null then
855: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
856: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
857: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
858: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
859: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
860:
853:
854: if lv_imss_waybill is null then
855: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
856: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
857: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
858: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
859: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
860:
861: end if;
854: if lv_imss_waybill is null then
855: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
856: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
857: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
858: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
859: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
860:
861: end if;
862:
855: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
856: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
857: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
858: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
859: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
860:
861: end if;
862:
863: end if;
892: lv_error_mesg := 'Error in DISPMAG record for Employee '||lv_paternal_last_name || ' - ' ;
893:
894: if lv_er_ss_id is null then
895: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
896: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
897: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
898: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
899: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing ') ;
900:
893:
894: if lv_er_ss_id is null then
895: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
896: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
897: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
898: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
899: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing ') ;
900:
901: end if;
894: if lv_er_ss_id is null then
895: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
896: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
897: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
898: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
899: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing ') ;
900:
901: end if;
902:
895: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
896: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
897: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
898: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
899: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing ') ;
900:
901: end if;
902:
903: if lv_er_ss_chk_digit is null then
901: end if;
902:
903: if lv_er_ss_chk_digit is null then
904: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
905: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
906: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
907: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
908: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
909:
902:
903: if lv_er_ss_chk_digit is null then
904: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
905: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
906: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
907: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
908: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
909:
910: end if;
903: if lv_er_ss_chk_digit is null then
904: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
905: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
906: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
907: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
908: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
909:
910: end if;
911:
904: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
905: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
906: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
907: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
908: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
909:
910: end if;
911:
912: if lv_ee_ss_id is null then
910: end if;
911:
912: if lv_ee_ss_id is null then
913: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
914: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
915: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
916: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
917: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
918:
911:
912: if lv_ee_ss_id is null then
913: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
914: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
915: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
916: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
917: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
918:
919: end if;
912: if lv_ee_ss_id is null then
913: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
914: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
915: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
916: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
917: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
918:
919: end if;
920:
913: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
914: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
915: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
916: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
917: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
918:
919: end if;
920:
921: if lv_ee_ss_chk_digit is null then
919: end if;
920:
921: if lv_ee_ss_chk_digit is null then
922: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
923: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
924: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
925: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
926: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing ') ;
927:
920:
921: if lv_ee_ss_chk_digit is null then
922: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
923: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
924: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
925: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
926: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing ') ;
927:
928: end if;
921: if lv_ee_ss_chk_digit is null then
922: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
923: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
924: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
925: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
926: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing ') ;
927:
928: end if;
929:
922: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
923: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
924: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
925: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
926: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing ') ;
927:
928: end if;
929:
930: if lv_name is null then
928: end if;
929:
930: if lv_name is null then
931: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
932: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
933: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
934: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
935: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing') ;
936:
929:
930: if lv_name is null then
931: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
932: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
933: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
934: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
935: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing') ;
936:
937: end if;
930: if lv_name is null then
931: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
932: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
933: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
934: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
935: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing') ;
936:
937: end if;
938:
931: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
932: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
933: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
934: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
935: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing') ;
936:
937: end if;
938:
939: if lv_sep_date is null then
937: end if;
938:
939: if lv_sep_date is null then
940: lv_error_mesg := lv_error_mesg || 'Separation date is Missing ' ;
941: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
942: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
943: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
944: pay_core_utils.push_token('DESCRIPTION','Separation date is Missing ') ;
945:
938:
939: if lv_sep_date is null then
940: lv_error_mesg := lv_error_mesg || 'Separation date is Missing ' ;
941: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
942: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
943: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
944: pay_core_utils.push_token('DESCRIPTION','Separation date is Missing ') ;
945:
946: end if;
939: if lv_sep_date is null then
940: lv_error_mesg := lv_error_mesg || 'Separation date is Missing ' ;
941: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
942: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
943: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
944: pay_core_utils.push_token('DESCRIPTION','Separation date is Missing ') ;
945:
946: end if;
947:
940: lv_error_mesg := lv_error_mesg || 'Separation date is Missing ' ;
941: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
942: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
943: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
944: pay_core_utils.push_token('DESCRIPTION','Separation date is Missing ') ;
945:
946: end if;
947:
948: if lv_imss_waybill is null then
946: end if;
947:
948: if lv_imss_waybill is null then
949: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
950: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
951: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
952: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
953: pay_core_utils.push_token('DESCRIPTION','IMSS Waybill Number is Missing') ;
954:
947:
948: if lv_imss_waybill is null then
949: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
950: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
951: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
952: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
953: pay_core_utils.push_token('DESCRIPTION','IMSS Waybill Number is Missing') ;
954:
955: end if;
948: if lv_imss_waybill is null then
949: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
950: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
951: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
952: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
953: pay_core_utils.push_token('DESCRIPTION','IMSS Waybill Number is Missing') ;
954:
955: end if;
956:
949: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
950: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
951: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
952: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
953: pay_core_utils.push_token('DESCRIPTION','IMSS Waybill Number is Missing') ;
954:
955: end if;
956:
957: if lv_leav_reason is null then
955: end if;
956:
957: if lv_leav_reason is null then
958: lv_error_mesg := lv_error_mesg || ' Leaving Reason is Missing ' ;
959: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
960: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
961: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
962: pay_core_utils.push_token('DESCRIPTION',' Leaving Reason is Missing') ;
963: -- pay_core_utils.push_token('DESCRIPTION','(Assignment Action Id :'|| to_char(p_assignment_action_id)
956:
957: if lv_leav_reason is null then
958: lv_error_mesg := lv_error_mesg || ' Leaving Reason is Missing ' ;
959: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
960: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
961: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
962: pay_core_utils.push_token('DESCRIPTION',' Leaving Reason is Missing') ;
963: -- pay_core_utils.push_token('DESCRIPTION','(Assignment Action Id :'|| to_char(p_assignment_action_id)
964: -- ||') Leaving Reason is Missing') ;
957: if lv_leav_reason is null then
958: lv_error_mesg := lv_error_mesg || ' Leaving Reason is Missing ' ;
959: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
960: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
961: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
962: pay_core_utils.push_token('DESCRIPTION',' Leaving Reason is Missing') ;
963: -- pay_core_utils.push_token('DESCRIPTION','(Assignment Action Id :'|| to_char(p_assignment_action_id)
964: -- ||') Leaving Reason is Missing') ;
965: end if;
958: lv_error_mesg := lv_error_mesg || ' Leaving Reason is Missing ' ;
959: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
960: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
961: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
962: pay_core_utils.push_token('DESCRIPTION',' Leaving Reason is Missing') ;
963: -- pay_core_utils.push_token('DESCRIPTION','(Assignment Action Id :'|| to_char(p_assignment_action_id)
964: -- ||') Leaving Reason is Missing') ;
965: end if;
966:
959: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
960: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
961: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
962: pay_core_utils.push_token('DESCRIPTION',' Leaving Reason is Missing') ;
963: -- pay_core_utils.push_token('DESCRIPTION','(Assignment Action Id :'|| to_char(p_assignment_action_id)
964: -- ||') Leaving Reason is Missing') ;
965: end if;
966:
967: end if;
1003: lv_error_mesg := 'Error in DISPMAG record for Employee '||lv_paternal_last_name || ' - ' ;
1004:
1005: if lv_er_ss_id is null then
1006: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
1007: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1008: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1009: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1010: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
1011: end if;
1004:
1005: if lv_er_ss_id is null then
1006: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
1007: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1008: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1009: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1010: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
1011: end if;
1012:
1005: if lv_er_ss_id is null then
1006: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
1007: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1008: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1009: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1010: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
1011: end if;
1012:
1013: if lv_er_ss_chk_digit is null then
1006: lv_error_mesg := lv_error_mesg || 'Employer SS ID is Missing ' ;
1007: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1008: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1009: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1010: pay_core_utils.push_token('DESCRIPTION','Employer SS ID is Missing') ;
1011: end if;
1012:
1013: if lv_er_ss_chk_digit is null then
1014: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
1011: end if;
1012:
1013: if lv_er_ss_chk_digit is null then
1014: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
1015: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1016: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1017: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1018: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
1019: end if;
1012:
1013: if lv_er_ss_chk_digit is null then
1014: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
1015: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1016: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1017: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1018: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
1019: end if;
1020:
1013: if lv_er_ss_chk_digit is null then
1014: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
1015: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1016: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1017: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1018: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
1019: end if;
1020:
1021: if lv_ee_ss_id is null then
1014: lv_error_mesg := lv_error_mesg || 'Employer SS Check Digit is Missing ' ;
1015: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1016: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1017: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1018: pay_core_utils.push_token('DESCRIPTION','Employer SS Check Digit is Missing') ;
1019: end if;
1020:
1021: if lv_ee_ss_id is null then
1022: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
1019: end if;
1020:
1021: if lv_ee_ss_id is null then
1022: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
1023: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1024: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1025: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1026: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
1027:
1020:
1021: if lv_ee_ss_id is null then
1022: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
1023: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1024: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1025: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1026: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
1027:
1028: end if;
1021: if lv_ee_ss_id is null then
1022: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
1023: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1024: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1025: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1026: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
1027:
1028: end if;
1029:
1022: lv_error_mesg := lv_error_mesg || 'Employee SS ID is Missing ' ;
1023: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1024: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1025: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1026: pay_core_utils.push_token('DESCRIPTION','Employee SS ID is Missing ') ;
1027:
1028: end if;
1029:
1030: if lv_ee_ss_chk_digit is null then
1028: end if;
1029:
1030: if lv_ee_ss_chk_digit is null then
1031: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
1032: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1033: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1034: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1035: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
1036:
1029:
1030: if lv_ee_ss_chk_digit is null then
1031: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
1032: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1033: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1034: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1035: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
1036:
1037: end if;
1030: if lv_ee_ss_chk_digit is null then
1031: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
1032: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1033: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1034: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1035: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
1036:
1037: end if;
1038:
1031: lv_error_mesg := lv_error_mesg || 'Employee SS Check Digit is Missing ' ;
1032: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1033: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1034: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1035: pay_core_utils.push_token('DESCRIPTION','Employee SS Check Digit is Missing') ;
1036:
1037: end if;
1038:
1039:
1038:
1039:
1040: if lv_name is null then
1041: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
1042: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1043: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1044: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1045: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
1046:
1039:
1040: if lv_name is null then
1041: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
1042: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1043: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1044: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1045: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
1046:
1047: end if;
1040: if lv_name is null then
1041: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
1042: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1043: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1044: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1045: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
1046:
1047: end if;
1048:
1041: lv_error_mesg := lv_error_mesg || 'First Name and/or Second Name is Missing ' ;
1042: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1043: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1044: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1045: pay_core_utils.push_token('DESCRIPTION','First Name and/or Second Name is Missing ') ;
1046:
1047: end if;
1048:
1049:
1048:
1049:
1050: if to_number(nvl(lv_IDW,'0')) <= 0 then
1051: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
1052: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1053: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1054: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1055: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
1056: end if;
1049:
1050: if to_number(nvl(lv_IDW,'0')) <= 0 then
1051: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
1052: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1053: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1054: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1055: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
1056: end if;
1057:
1050: if to_number(nvl(lv_IDW,'0')) <= 0 then
1051: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
1052: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1053: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1054: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1055: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
1056: end if;
1057:
1058: if lv_worker_type is null then
1051: lv_error_mesg := lv_error_mesg || 'IDW must be greater than zero ' ;
1052: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1053: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1054: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1055: pay_core_utils.push_token('DESCRIPTION','IDW must be greater than zero ') ;
1056: end if;
1057:
1058: if lv_worker_type is null then
1059: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
1056: end if;
1057:
1058: if lv_worker_type is null then
1059: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
1060: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1061: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1062: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1063: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
1064:
1057:
1058: if lv_worker_type is null then
1059: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
1060: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1061: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1062: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1063: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
1064:
1065: end if;
1058: if lv_worker_type is null then
1059: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
1060: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1061: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1062: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1063: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
1064:
1065: end if;
1066:
1059: lv_error_mesg := lv_error_mesg || 'Worker Type is Missing ' ;
1060: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1061: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1062: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1063: pay_core_utils.push_token('DESCRIPTION','Worker Type is Missing ') ;
1064:
1065: end if;
1066:
1067:
1066:
1067:
1068: if lv_salary_type is null then
1069: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
1070: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1071: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1072: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1073: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
1074:
1067:
1068: if lv_salary_type is null then
1069: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
1070: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1071: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1072: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1073: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
1074:
1075: end if;
1068: if lv_salary_type is null then
1069: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
1070: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1071: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1072: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1073: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
1074:
1075: end if;
1076:
1069: lv_error_mesg := lv_error_mesg || 'Salary Type is Missing ' ;
1070: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1071: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1072: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1073: pay_core_utils.push_token('DESCRIPTION','Salary Type is Missing ') ;
1074:
1075: end if;
1076:
1077: if lv_rww is null then
1075: end if;
1076:
1077: if lv_rww is null then
1078: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
1079: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1080: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1081: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1082: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
1083:
1076:
1077: if lv_rww is null then
1078: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
1079: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1080: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1081: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1082: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
1083:
1084: end if;
1077: if lv_rww is null then
1078: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
1079: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1080: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1081: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1082: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
1083:
1084: end if;
1085:
1078: lv_error_mesg := lv_error_mesg || 'Reduced working week flag is Missing ' ;
1079: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1080: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1081: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1082: pay_core_utils.push_token('DESCRIPTION','Reduced working week flag is Missing ') ;
1083:
1084: end if;
1085:
1086: if lv_hire_date is null then
1084: end if;
1085:
1086: if lv_hire_date is null then
1087: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
1088: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1089: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1090: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1091: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
1092:
1085:
1086: if lv_hire_date is null then
1087: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
1088: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1089: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1090: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1091: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
1092:
1093: end if;
1086: if lv_hire_date is null then
1087: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
1088: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1089: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1090: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1091: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
1092:
1093: end if;
1094:
1087: lv_error_mesg := lv_error_mesg || 'Hire date is Missing ' ;
1088: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1089: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1090: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1091: pay_core_utils.push_token('DESCRIPTION','Hire date is Missing ') ;
1092:
1093: end if;
1094:
1095: if lv_imss_waybill is null then
1093: end if;
1094:
1095: if lv_imss_waybill is null then
1096: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
1097: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1098: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1099: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1100: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
1101:
1094:
1095: if lv_imss_waybill is null then
1096: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
1097: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1098: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1099: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1100: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
1101:
1102: end if;
1095: if lv_imss_waybill is null then
1096: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
1097: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1098: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1099: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1100: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
1101:
1102: end if;
1103:
1096: lv_error_mesg := lv_error_mesg || ' IMSS Waybill Number is Missing ' ;
1097: pay_core_utils.push_message(800,'HR_MX_INVALID_DISPMAG_DATA','F');
1098: pay_core_utils.push_token('RECORD_NAME','DISPMAG') ;
1099: pay_core_utils.push_token('NAME_OR_NUMBER',lv_paternal_last_name) ;
1100: pay_core_utils.push_token('DESCRIPTION',' IMSS Waybill Number is Missing ') ;
1101:
1102: end if;
1103:
1104: end if;