[Home] [Help]
819: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
820:
821: IF l_employer_name IS NULL THEN
822: l_errflag := 'Y';
823: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
824: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
825: END IF;
826: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
827: l_errflag := 'Y';
820:
821: IF l_employer_name IS NULL THEN
822: l_errflag := 'Y';
823: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
824: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
825: END IF;
826: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
827: l_errflag := 'Y';
828: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
824: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
825: END IF;
826: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
827: l_errflag := 'Y';
828: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
829: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
830: END IF;
831: IF l_cbr_no IS NULL THEN
832: l_errflag := 'Y';
825: END IF;
826: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
827: l_errflag := 'Y';
828: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
829: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
830: END IF;
831: IF l_cbr_no IS NULL THEN
832: l_errflag := 'Y';
833: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
829: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
830: END IF;
831: IF l_cbr_no IS NULL THEN
832: l_errflag := 'Y';
833: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
834: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
835: END IF;
836: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
837: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
830: END IF;
831: IF l_cbr_no IS NULL THEN
832: l_errflag := 'Y';
833: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
834: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
835: END IF;
836: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
837: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
838: l_errflag := 'Y';
835: END IF;
836: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
837: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
838: l_errflag := 'Y';
839: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
840: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
841: END IF;
842:
843: hr_utility.set_location('l_errflag '||l_errflag, 370);
836: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
837: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
838: l_errflag := 'Y';
839: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
840: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
841: END IF;
842:
843: hr_utility.set_location('l_errflag '||l_errflag, 370);
844:
842:
843: hr_utility.set_location('l_errflag '||l_errflag, 370);
844:
845: IF l_errflag = 'Y' THEN
846: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
847: Raise l_ehecs_exception;
848: END IF;
849:
850: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
989:
990: hr_utility.set_location('After building the dynamic query.',520);
991:
992: /*6978389 */
993: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
994:
995: OPEN csr_get_asg FOR l_select_str; -- ref cursor
996: LOOP
997: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
1457: END IF;
1458: END IF;
1459: /* ELSE
1460: l_errflag := 'Y';
1461: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Normal hours value is not null at the assignment level of person'||p_person_id );
1462: Raise l_ehecs_exception;
1463: END IF;
1464: */
1465: ELSE
3715: l_str_common := 'An entry exists for full time ' || l_employee_categories ||' employed at the first day of the quarter or the last day of the quarter.';
3716: --
3717: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3718: l_errflag := 'Y';
3719: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories || l_is_gt_0);
3720: --||' must be > 0 '||l_str_common);
3721: END IF;
3722: --
3723: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3721: END IF;
3722: --
3723: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3724: l_errflag := 'Y';
3725: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories || l_is_gt_0 );
3726: --||' must be > 0 '||l_str_common );
3727: END IF;
3728: --
3729: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3727: END IF;
3728: --
3729: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3730: l_errflag := 'Y';
3731: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories || l_is_gt_0 );
3732: --||' must be > 0 '||l_str_common);
3733: END IF;
3734: --
3735:
3740: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
3741: --
3742: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3743: l_errflag := 'Y';
3744: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories || l_is_gt_0 );
3745:
3746: END IF;
3747: --
3748: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3746: END IF;
3747: --
3748: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3749: l_errflag := 'Y';
3750: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories || l_is_gt_0 );
3751:
3752: END IF;
3753:
3754: END IF;
3757: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
3758: --
3759: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3760: l_errflag := 'Y';
3761: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3762: --||' must be > 0 '||l_str_common );
3763: END IF;
3764: --
3765: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3763: END IF;
3764: --
3765: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3766: l_errflag := 'Y';
3767: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3768: --||' must be > 0 '||l_str_common );
3769: END IF;
3770: --
3771: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3769: END IF;
3770: --
3771: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3772: l_errflag := 'Y';
3773: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3774: --||' must be > 0 '||l_str_common );
3775: END IF;
3776: END IF;
3777: --
3779: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories ;
3780: --
3781: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3782: l_errflag := 'Y';
3783: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3784: --||' must be > 0 '||l_str_common );
3785: END IF;
3786: --
3787: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3785: END IF;
3786: --
3787: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3788: l_errflag := 'Y';
3789: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3790: --||' must be > 0 '||l_str_common );
3791: END IF;
3792: --
3793: IF l_data_part3.l_ot_hrs_paid_ft_mg = 0 THEN
3791: END IF;
3792: --
3793: IF l_data_part3.l_ot_hrs_paid_ft_mg = 0 THEN
3794: l_errflag := 'Y';
3795: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
3796: --||' must be > 0 '||l_str_common );
3797: END IF;
3798: --
3799: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3797: END IF;
3798: --
3799: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3800: l_errflag := 'Y';
3801: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3802: --||' must be > 0 '||l_str_common );
3803: END IF;
3804: --
3805: END IF;
3808: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
3809: --
3810: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3811: l_errflag := 'Y';
3812: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3813: --||' must be > 0 '||l_str_common );
3814: END IF;
3815: --
3816: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3814: END IF;
3815: --
3816: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3817: l_errflag := 'Y';
3818: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3819: --||' must be > 0 '||l_str_common );
3820: END IF;
3821: --
3822: END IF;
3826: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
3827: --
3828: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3829: l_errflag := 'Y';
3830: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3831: --||' must be > 0 '||l_str_common );
3832: END IF;
3833: --
3834: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3832: END IF;
3833: --
3834: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3835: l_errflag := 'Y';
3836: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3837: --||' must be > 0 '||l_str_common );
3838: END IF;
3839: --
3840: IF l_data_part2.l_ot_paid_ft_mg = 0 THEN
3838: END IF;
3839: --
3840: IF l_data_part2.l_ot_paid_ft_mg = 0 THEN
3841: l_errflag := 'Y';
3842: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
3843: --||' must be > 0 '||l_str_common );
3844: END IF;
3845: --
3846: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3844: END IF;
3845: --
3846: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3847: l_errflag := 'Y';
3848: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3849: --||' must be > 0 '||l_str_common );
3850: END IF;
3851: --
3852: END IF;
3856: l_str_common := 'An entry exists for Annual Leave and Bank Holidays or Maternity Leave or Sick Leave or Other Leave- full time '|| l_employee_categories;
3857: --
3858: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3859: l_errflag := 'Y';
3860: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3861: --||' must be > 0 '||l_str_common );
3862: END IF;
3863: --
3864: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3862: END IF;
3863: --
3864: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3865: l_errflag := 'Y';
3866: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3867: --||' must be > 0 '||l_str_common );
3868: END IF;
3869: --
3870: END IF;
3874: ||' the first day of the quarter or the last day of the quarter.';
3875: --
3876: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3877: l_errflag := 'Y';
3878: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3879: --||' must be > 0 '||l_str_common );
3880: END IF;
3881: --
3882: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3880: END IF;
3881: --
3882: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3883: l_errflag := 'Y';
3884: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3885: --||' must be > 0 '||l_str_common );
3886: END IF;
3887: --
3888: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3886: END IF;
3887: --
3888: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3889: l_errflag := 'Y';
3890: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3891: --||' must be > 0 '||l_str_common );
3892: END IF;
3893: --
3894: END IF;
3897: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
3898: --
3899: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3900: l_errflag := 'Y';
3901: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3902: --||' must be > 0 '||l_str_common );
3903: END IF;
3904: --
3905: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3903: END IF;
3904: --
3905: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3906: l_errflag := 'Y';
3907: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3908: --||' must be > 0 '||l_str_common );
3909: END IF;
3910: --
3911: END IF;
3914: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
3915: --
3916: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3917: l_errflag := 'Y';
3918: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3919: --||' must be > 0 '||l_str_common );
3920: END IF;
3921: --
3922: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3920: END IF;
3921: --
3922: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3923: l_errflag := 'Y';
3924: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3925: --||' must be > 0 '||l_str_common );
3926: END IF;
3927: --
3928: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3926: END IF;
3927: --
3928: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3929: l_errflag := 'Y';
3930: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3931: --||' must be > 0 '||l_str_common );
3932: END IF;
3933: --
3934: END IF;
3937: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
3938: --
3939: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3940: l_errflag := 'Y';
3941: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3942: --||' must be > 0 '||l_str_common );
3943: END IF;
3944: --
3945: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3943: END IF;
3944: --
3945: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3946: l_errflag := 'Y';
3947: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3948: --||' must be > 0 '||l_str_common );
3949: END IF;
3950: --
3951: IF l_data_part3.l_ot_hrs_paid_pt_mg = 0 THEN
3949: END IF;
3950: --
3951: IF l_data_part3.l_ot_hrs_paid_pt_mg = 0 THEN
3952: l_errflag := 'Y';
3953: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
3954: --||' must be > 0 '||l_str_common );
3955: END IF;
3956: --
3957: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3955: END IF;
3956: --
3957: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3958: l_errflag := 'Y';
3959: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3960: --||' must be > 0 '||l_str_common );
3961: END IF;
3962: END IF;
3963:
3965: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
3966: --
3967: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3968: l_errflag := 'Y';
3969: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3970: --||' must be > 0 '||l_str_common );
3971: END IF;
3972: --
3973: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3971: END IF;
3972: --
3973: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3974: l_errflag := 'Y';
3975: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3976: --||' must be > 0 '||l_str_common );
3977: END IF;
3978: END IF;
3979:
3981: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
3982: --
3983: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3984: l_errflag := 'Y';
3985: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3986: --||' must be > 0 '||l_str_common );
3987: END IF;
3988: --
3989: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3987: END IF;
3988: --
3989: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3990: l_errflag := 'Y';
3991: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3992: --||' must be > 0 '||l_str_common );
3993: END IF;
3994: --
3995: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3993: END IF;
3994: --
3995: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3996: l_errflag := 'Y';
3997: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3998: --||' must be > 0 '||l_str_common );
3999: END IF;
4000: END IF;
4001:
4003: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
4004: --
4005: IF l_data_part2.l_reg_wg_ft_mg = 0 AND l_data_part2.l_reg_wg_pt_mg = 0 AND l_data_part2.l_tot_wg_app_mg = 0 THEN
4006: l_errflag := 'Y';
4007: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4008: --||' must be > 0 '||l_str_common );
4009: END IF;
4010: --
4011: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 AND l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4009: END IF;
4010: --
4011: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 AND l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4012: l_errflag := 'Y';
4013: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4014: --||' must be > 0 '||l_str_common );
4015: END IF;
4016: --
4017: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 AND l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4015: END IF;
4016: --
4017: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 AND l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4018: l_errflag := 'Y';
4019: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4020: --||' must be > 0 '||l_str_common );
4021: END IF;
4022: END IF;
4023:
4026: l_str_common := 'An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees.';
4027:
4028: IF l_data_part2.l_reg_wg_ft_mg = 0 AND l_data_part2.l_reg_wg_pt_mg = 0 THEN
4029: l_errflag := 'Y';
4030: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4031: --||' must be > 0 '||l_str_common );
4032: END IF;
4033: --
4034: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
4032: END IF;
4033: --
4034: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
4035: l_errflag := 'Y';
4036: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4037: --||' must be > 0 '||l_str_common );
4038: END IF;
4039: --
4040: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
4038: END IF;
4039: --
4040: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
4041: l_errflag := 'Y';
4042: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4043: --||' must be > 0 '||l_str_common );
4044: END IF;
4045: --
4046: END If;
4051: l_str_common := ' An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
4052: --
4053: IF l_data_part2.l_reg_wg_ft_mg = 0 AND l_data_part2.l_reg_wg_pt_mg = 0 THEN
4054: l_errflag := 'Y';
4055: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4056: --||' must be > 0 '||l_str_common );
4057: END IF;
4058: --
4059: --
4058: --
4059: --
4060: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
4061: l_errflag := 'Y';
4062: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4063: --||' must be > 0 '||l_str_common );
4064: END IF;
4065: --
4066: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
4064: END IF;
4065: --
4066: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
4067: l_errflag := 'Y';
4068: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4069: --||' must be > 0 '||l_str_common );
4070: END IF;
4071: END IF;
4072: ----------------Section B: Full and part time clerical, sales and service workers:
4076: l_str_common := 'as full time ' || l_employee_categories ||' employed at the first day of the quarter or the last day of the quarter exists ';
4077: --
4078: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4079: l_errflag := 'Y';
4080: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4081: --||' must be > 0 '||l_str_common);
4082: END IF;
4083: --
4084: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4082: END IF;
4083: --
4084: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4085: l_errflag := 'Y';
4086: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4087: --||' must be > 0 '||l_str_common );
4088: END IF;
4089: --
4090: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4088: END IF;
4089: --
4090: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4091: l_errflag := 'Y';
4092: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4093: --||' must be > 0 '||l_str_common);
4094: END IF;
4095: --
4096:
4100: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
4101: --
4102: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4103: l_errflag := 'Y';
4104: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4105: --||' must be > 0 '||l_str_common );
4106: END IF;
4107: --
4108: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4106: END IF;
4107: --
4108: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4109: l_errflag := 'Y';
4110: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4111: --||' must be > 0 '||l_str_common);
4112: END IF;
4113: --
4114:
4118: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
4119: --
4120: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4121: l_errflag := 'Y';
4122: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4123: --||' must be > 0 '||l_str_common );
4124: END IF;
4125: --
4126: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4124: END IF;
4125: --
4126: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4127: l_errflag := 'Y';
4128: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4129: --||' must be > 0 '||l_str_common );
4130: END IF;
4131: --
4132: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4130: END IF;
4131: --
4132: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4133: l_errflag := 'Y';
4134: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4135: --||' must be > 0 '||l_str_common );
4136: END IF;
4137: END IF;
4138: --
4140: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories;
4141: --
4142: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4143: l_errflag := 'Y';
4144: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4145: --||' must be > 0 '||l_str_common );
4146: END IF;
4147: --
4148: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4146: END IF;
4147: --
4148: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4149: l_errflag := 'Y';
4150: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4151: --||' must be > 0 '||l_str_common );
4152: END IF;
4153: --
4154: IF l_data_part3.l_ot_hrs_paid_ft_cl = 0 THEN
4152: END IF;
4153: --
4154: IF l_data_part3.l_ot_hrs_paid_ft_cl = 0 THEN
4155: l_errflag := 'Y';
4156: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
4157: --||' must be > 0 '||l_str_common );
4158: END IF;
4159: --
4160: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4158: END IF;
4159: --
4160: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4161: l_errflag := 'Y';
4162: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4163: --||' must be > 0 '||l_str_common );
4164: END IF;
4165: --
4166: END IF;
4169: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
4170: --
4171: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4172: l_errflag := 'Y';
4173: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4174: --||' must be > 0 '||l_str_common );
4175: END IF;
4176: --
4177: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4175: END IF;
4176: --
4177: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4178: l_errflag := 'Y';
4179: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4180: --||' must be > 0 '||l_str_common );
4181: END IF;
4182: --
4183: END IF;
4187: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
4188: --
4189: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4190: l_errflag := 'Y';
4191: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4192: --||' must be > 0 '||l_str_common );
4193: END IF;
4194: --
4195: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4193: END IF;
4194: --
4195: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4196: l_errflag := 'Y';
4197: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4198: --||' must be > 0 '||l_str_common );
4199: END IF;
4200: --
4201: IF l_data_part2.l_ot_paid_ft_cl = 0 THEN
4199: END IF;
4200: --
4201: IF l_data_part2.l_ot_paid_ft_cl = 0 THEN
4202: l_errflag := 'Y';
4203: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
4204: -- ||' must be > 0 '||l_str_common );
4205: END IF;
4206: --
4207: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4205: END IF;
4206: --
4207: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
4208: l_errflag := 'Y';
4209: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4210: --||' must be > 0 '||l_str_common );
4211: END IF;
4212: --
4213: END IF;
4218:
4219: --
4220: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
4221: l_errflag := 'Y';
4222: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4223: --||' must be > 0 '||l_str_common );
4224: END IF;
4225: --
4226: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4224: END IF;
4225: --
4226: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
4227: l_errflag := 'Y';
4228: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4229: --||' must be > 0 '||l_str_common );
4230: END IF;
4231: --
4232: END IF;
4236: ||' the first day of the quarter or the last day of the quarter.';
4237: --
4238: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4239: l_errflag := 'Y';
4240: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4241: --||' must be > 0 '||l_str_common );
4242: END IF;
4243: --
4244: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4242: END IF;
4243: --
4244: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4245: l_errflag := 'Y';
4246: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4247: --||' must be > 0 '||l_str_common );
4248: END IF;
4249: --
4250: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4248: END IF;
4249: --
4250: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4251: l_errflag := 'Y';
4252: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4253: --||' must be > 0 '||l_str_common );
4254: END IF;
4255: --
4256: END IF;
4259: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
4260: --
4261: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4262: l_errflag := 'Y';
4263: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4264: --||' must be > 0 '||l_str_common );
4265: END IF;
4266: --
4267: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4265: END IF;
4266: --
4267: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4268: l_errflag := 'Y';
4269: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4270: --||' must be > 0 '||l_str_common );
4271: END IF;
4272: --
4273: END IF;
4276: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
4277: --
4278: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4279: l_errflag := 'Y';
4280: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4281: --||' must be > 0 '||l_str_common );
4282: END IF;
4283: --
4284: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4282: END IF;
4283: --
4284: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4285: l_errflag := 'Y';
4286: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4287: --||' must be > 0 '||l_str_common );
4288: END IF;
4289: --
4290: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4288: END IF;
4289: --
4290: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4291: l_errflag := 'Y';
4292: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4293: --||' must be > 0 '||l_str_common );
4294: END IF;
4295: --
4296: END IF;
4299: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
4300: --
4301: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4302: l_errflag := 'Y';
4303: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4304: --||' must be > 0 '||l_str_common );
4305: END IF;
4306: --
4307: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4305: END IF;
4306: --
4307: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4308: l_errflag := 'Y';
4309: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4310: --||' must be > 0 '||l_str_common );
4311: END IF;
4312: --
4313: IF l_data_part3.l_ot_hrs_paid_pt_cl = 0 THEN
4311: END IF;
4312: --
4313: IF l_data_part3.l_ot_hrs_paid_pt_cl = 0 THEN
4314: l_errflag := 'Y';
4315: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
4316: --||' must be > 0 '||l_str_common );
4317: END IF;
4318: --
4319: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4317: END IF;
4318: --
4319: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4320: l_errflag := 'Y';
4321: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4322: --||' must be > 0 '||l_str_common );
4323: END IF;
4324: END IF;
4325:
4327: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
4328: --
4329: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4330: l_errflag := 'Y';
4331: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4332: --||' must be > 0 '||l_str_common );
4333: END IF;
4334: --
4335: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4333: END IF;
4334: --
4335: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4336: l_errflag := 'Y';
4337: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4338: --||' must be > 0 '||l_str_common );
4339: END IF;
4340: END IF;
4341:
4343: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
4344: --
4345: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4346: l_errflag := 'Y';
4347: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4348: --||' must be > 0 '||l_str_common );
4349: END IF;
4350: --
4351: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4349: END IF;
4350: --
4351: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4352: l_errflag := 'Y';
4353: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4354: --||' must be > 0 '||l_str_common );
4355: END IF;
4356: --
4357: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4355: END IF;
4356: --
4357: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4358: l_errflag := 'Y';
4359: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4360: --||' must be > 0 '||l_str_common );
4361: END IF;
4362: END IF;
4363:
4365: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
4366: --
4367: IF l_data_part2.l_reg_wg_ft_cl = 0 AND l_data_part2.l_reg_wg_pt_cl = 0 AND l_data_part2.l_tot_wg_app_cl = 0 THEN
4368: l_errflag := 'Y';
4369: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4370: --||' must be > 0 '||l_str_common );
4371: END IF;
4372: --
4373: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 AND l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4371: END IF;
4372: --
4373: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 AND l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4374: l_errflag := 'Y';
4375: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4376: --||' must be > 0 '||l_str_common );
4377: END IF;
4378: --
4379: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 AND l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4377: END IF;
4378: --
4379: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 AND l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4380: l_errflag := 'Y';
4381: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4382: --||' must be > 0 '||l_str_common );
4383: END IF;
4384: END IF;
4385:
4388: l_str_common := 'An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees.';
4389:
4390: IF l_data_part2.l_reg_wg_ft_cl = 0 AND l_data_part2.l_reg_wg_pt_cl = 0 THEN
4391: l_errflag := 'Y';
4392: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4393: --||' must be > 0 '||l_str_common );
4394: END IF;
4395: --
4396: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4394: END IF;
4395: --
4396: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4397: l_errflag := 'Y';
4398: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4399: --||' must be > 0 '||l_str_common );
4400: END IF;
4401: --
4402: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4400: END IF;
4401: --
4402: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4403: l_errflag := 'Y';
4404: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4405: --||' must be > 0 '||l_str_common );
4406: END IF;
4407: --
4408: END If;
4413: l_str_common := 'An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
4414: --
4415: IF l_data_part2.l_reg_wg_ft_cl = 0 AND l_data_part2.l_reg_wg_pt_cl = 0 THEN
4416: l_errflag := 'Y';
4417: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4418: --||' must be > 0 '||l_str_common );
4419: END IF;
4420: --
4421: --
4420: --
4421: --
4422: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4423: l_errflag := 'Y';
4424: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4425: --||' must be > 0 '||l_str_common );
4426: END IF;
4427: --
4428: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4426: END IF;
4427: --
4428: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4429: l_errflag := 'Y';
4430: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4431: --||' must be > 0 '||l_str_common );
4432: END IF;
4433: END IF;
4434:
4439: l_str_common := 'An entry exists for full time ' || l_employee_categories ||' employed at the first day of the quarter or the last day of the quarter.';
4440: --
4441: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4442: l_errflag := 'Y';
4443: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4444: --||' must be > 0 '||l_str_common);
4445: END IF;
4446: --
4447: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4445: END IF;
4446: --
4447: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4448: l_errflag := 'Y';
4449: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4450: --||' must be > 0 '||l_str_common );
4451: END IF;
4452: --
4453: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4451: END IF;
4452: --
4453: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4454: l_errflag := 'Y';
4455: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4456: --||' must be > 0 '||l_str_common);
4457: END IF;
4458: --
4459: --
4463: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
4464: --
4465: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4466: l_errflag := 'Y';
4467: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4468: --||' must be > 0 '||l_str_common );
4469: END IF;
4470: --
4471: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4469: END IF;
4470: --
4471: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4472: l_errflag := 'Y';
4473: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4474: --||' must be > 0 '||l_str_common);
4475: END IF;
4476: --
4477: --
4481: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
4482: --
4483: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4484: l_errflag := 'Y';
4485: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4486: --||' must be > 0 '||l_str_common );
4487: END IF;
4488: --
4489: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4487: END IF;
4488: --
4489: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4490: l_errflag := 'Y';
4491: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4492: --||' must be > 0 '||l_str_common );
4493: END IF;
4494: --
4495: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4493: END IF;
4494: --
4495: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4496: l_errflag := 'Y';
4497: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4498: --||' must be > 0 '||l_str_common );
4499: END IF;
4500: END IF;
4501: --
4503: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories;
4504: --
4505: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4506: l_errflag := 'Y';
4507: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4508: --||' must be > 0 '||l_str_common );
4509: END IF;
4510: --
4511: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4509: END IF;
4510: --
4511: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4512: l_errflag := 'Y';
4513: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4514: --||' must be > 0 '||l_str_common );
4515: END IF;
4516: --
4517: IF l_data_part3.l_ot_hrs_paid_ft_ot = 0 THEN
4515: END IF;
4516: --
4517: IF l_data_part3.l_ot_hrs_paid_ft_ot = 0 THEN
4518: l_errflag := 'Y';
4519: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
4520: --||' must be > 0 '||l_str_common );
4521: END IF;
4522: --
4523: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4521: END IF;
4522: --
4523: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4524: l_errflag := 'Y';
4525: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4526: --||' must be > 0 '||l_str_common );
4527: END IF;
4528: --
4529: END IF;
4532: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
4533: --
4534: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4535: l_errflag := 'Y';
4536: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4537: --||' must be > 0 '||l_str_common );
4538: END IF;
4539: --
4540: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4538: END IF;
4539: --
4540: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4541: l_errflag := 'Y';
4542: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4543: --||' must be > 0 '||l_str_common );
4544: END IF;
4545: --
4546: END IF;
4550: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
4551: --
4552: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4553: l_errflag := 'Y';
4554: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4555: --||' must be > 0 '||l_str_common );
4556: END IF;
4557: --
4558: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4556: END IF;
4557: --
4558: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4559: l_errflag := 'Y';
4560: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4561: --||' must be > 0 '||l_str_common );
4562: END IF;
4563: --
4564: IF l_data_part2.l_ot_paid_ft_ot = 0 THEN
4562: END IF;
4563: --
4564: IF l_data_part2.l_ot_paid_ft_ot = 0 THEN
4565: l_errflag := 'Y';
4566: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
4567: --||' must be > 0 '||l_str_common );
4568: END IF;
4569: --
4570: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4568: END IF;
4569: --
4570: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4571: l_errflag := 'Y';
4572: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4573: --||' must be > 0 '||l_str_common );
4574: END IF;
4575: --
4576: END IF;
4580: l_str_common := 'An entry exists for Annual Leave and Bank Holidays or Maternity Leave or Sick Leave or Other Leave- full time '|| l_employee_categories;
4581: --
4582: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4583: l_errflag := 'Y';
4584: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4585: --||' must be > 0 '||l_str_common );
4586: END IF;
4587: --
4588: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4586: END IF;
4587: --
4588: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4589: l_errflag := 'Y';
4590: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4591: --||' must be > 0 '||l_str_common );
4592: END IF;
4593: --
4594: END IF;
4598: ||' the first day of the quarter or the last day of the quarter.';
4599: --
4600: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4601: l_errflag := 'Y';
4602: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4603: --||' must be > 0 '||l_str_common );
4604: END IF;
4605: --
4606: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4604: END IF;
4605: --
4606: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4607: l_errflag := 'Y';
4608: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4609: --||' must be > 0 '||l_str_common );
4610: END IF;
4611: --
4612: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4610: END IF;
4611: --
4612: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4613: l_errflag := 'Y';
4614: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4615: --||' must be > 0 '||l_str_common );
4616: END IF;
4617: --
4618: END IF;
4621: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
4622: --
4623: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4624: l_errflag := 'Y';
4625: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4626: --||' must be > 0 '||l_str_common );
4627: END IF;
4628: --
4629: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4627: END IF;
4628: --
4629: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4630: l_errflag := 'Y';
4631: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4632: --||' must be > 0 '||l_str_common );
4633: END IF;
4634: --
4635: END IF;
4638: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
4639: --
4640: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4641: l_errflag := 'Y';
4642: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4643: --||' must be > 0 '||l_str_common );
4644: END IF;
4645: --
4646: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4644: END IF;
4645: --
4646: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4647: l_errflag := 'Y';
4648: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4649: --||' must be > 0 '||l_str_common );
4650: END IF;
4651: --
4652: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4650: END IF;
4651: --
4652: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4653: l_errflag := 'Y';
4654: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4655: --||' must be > 0 '||l_str_common );
4656: END IF;
4657: --
4658: END IF;
4661: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
4662: --
4663: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4664: l_errflag := 'Y';
4665: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4666: --||' must be > 0 '||l_str_common );
4667: END IF;
4668: --
4669: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4667: END IF;
4668: --
4669: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4670: l_errflag := 'Y';
4671: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4672: --||' must be > 0 '||l_str_common );
4673: END IF;
4674: --
4675: IF l_data_part3.l_ot_hrs_paid_pt_ot = 0 THEN
4673: END IF;
4674: --
4675: IF l_data_part3.l_ot_hrs_paid_pt_ot = 0 THEN
4676: l_errflag := 'Y';
4677: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
4678: --||' must be > 0 '||l_str_common );
4679: END IF;
4680: --
4681: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4679: END IF;
4680: --
4681: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4682: l_errflag := 'Y';
4683: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4684: --||' must be > 0 '||l_str_common );
4685: END IF;
4686: END IF;
4687:
4689: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
4690: --
4691: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4692: l_errflag := 'Y';
4693: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4694: --||' must be > 0 '||l_str_common );
4695: END IF;
4696: --
4697: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4695: END IF;
4696: --
4697: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4698: l_errflag := 'Y';
4699: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4700: --||' must be > 0 '||l_str_common );
4701: END IF;
4702: END IF;
4703:
4705: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
4706: --
4707: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4708: l_errflag := 'Y';
4709: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4710: --||' must be > 0 '||l_str_common );
4711: END IF;
4712: --
4713: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4711: END IF;
4712: --
4713: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4714: l_errflag := 'Y';
4715: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4716: --||' must be > 0 '||l_str_common );
4717: END IF;
4718: --
4719: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4717: END IF;
4718: --
4719: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4720: l_errflag := 'Y';
4721: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4722: --||' must be > 0 '||l_str_common );
4723: END IF;
4724: END IF;
4725:
4727: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
4728: --
4729: IF l_data_part2.l_reg_wg_ft_ot = 0 AND l_data_part2.l_reg_wg_pt_ot = 0 AND l_data_part2.l_tot_wg_app_ot = 0 THEN
4730: l_errflag := 'Y';
4731: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4732: --||' must be > 0 '||l_str_common );
4733: END IF;
4734: --
4735: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 AND l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4733: END IF;
4734: --
4735: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 AND l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4736: l_errflag := 'Y';
4737: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4738: --||' must be > 0 '||l_str_common );
4739: END IF;
4740: --
4741: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 AND l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4739: END IF;
4740: --
4741: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 AND l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4742: l_errflag := 'Y';
4743: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time / apprentice/trainee '|| l_is_gt_0 );
4744: --||' must be > 0 '||l_str_common );
4745: END IF;
4746: END IF;
4747:
4750: l_str_common := ' An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees ';
4751:
4752: IF l_data_part2.l_reg_wg_ft_ot = 0 AND l_data_part2.l_reg_wg_pt_ot = 0 THEN
4753: l_errflag := 'Y';
4754: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4755: --||' must be > 0 '||l_str_common );
4756: END IF;
4757: --
4758: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4756: END IF;
4757: --
4758: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4759: l_errflag := 'Y';
4760: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4761: --||' must be > 0 '||l_str_common );
4762: END IF;
4763: --
4764: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4762: END IF;
4763: --
4764: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4765: l_errflag := 'Y';
4766: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4767: --||' must be > 0 '||l_str_common );
4768: END IF;
4769: --
4770: END If;
4775: l_str_common := 'An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
4776: --
4777: IF l_data_part2.l_reg_wg_ft_ot = 0 AND l_data_part2.l_reg_wg_pt_ot = 0 THEN
4778: l_errflag := 'Y';
4779: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries for any one of them - full time / part time '|| l_is_gt_0 );
4780: --||' must be > 0 '||l_str_common );
4781: END IF;
4782: --
4783: --
4782: --
4783: --
4784: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4785: l_errflag := 'Y';
4786: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours for any one of them - full time / part time '|| l_is_gt_0 );
4787: --||' must be > 0 '||l_str_common );
4788: END IF;
4789: --
4790: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4788: END IF;
4789: --
4790: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4791: l_errflag := 'Y';
4792: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays for any one of them - full time / part time '|| l_is_gt_0 );
4793: --||' must be > 0 '||l_str_common );
4794: END IF;
4795: END IF;
4796:
4801: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
4802: --
4803: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4804: l_errflag := 'Y';
4805: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4806: --||' must be > 0 '||l_str_common);
4807: END IF;
4808: --
4809: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4807: END IF;
4808: --
4809: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4810: l_errflag := 'Y';
4811: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4812: --||' must be > 0 '||l_str_common );
4813: END IF;
4814: --
4815: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4813: END IF;
4814: --
4815: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4816: l_errflag := 'Y';
4817: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4818: --||' must be > 0 '||l_str_common);
4819: END IF;
4820: --
4821: END IF;
4824: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
4825: --
4826: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4827: l_errflag := 'Y';
4828: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4829: --||' must be > 0 '||l_str_common );
4830: END IF;
4831: --
4832: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4830: END IF;
4831: --
4832: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4833: l_errflag := 'Y';
4834: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4835: --||' must be > 0 '||l_str_common);
4836: END IF;
4837: --
4838: END IF;
4841: l_str_common := 'An entry exists for paid contracted hours for '|| l_employee_categories;
4842: --
4843: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4844: l_errflag := 'Y';
4845: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4846: --||' must be > 0 '||l_str_common );
4847: END IF;
4848: --
4849: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4847: END IF;
4848: --
4849: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4850: l_errflag := 'Y';
4851: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4852: --||' must be > 0 '||l_str_common );
4853: END IF;
4854: END IF;
4855:
4858: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
4859: --
4860: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4861: l_errflag := 'Y';
4862: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4863: --||' must be > 0 '||l_str_common );
4864: END IF;
4865: --
4866: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4864: END IF;
4865: --
4866: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4867: l_errflag := 'Y';
4868: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4869: --||' must be > 0 '||l_str_common );
4870: END IF;
4871: --
4872: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4870: END IF;
4871: --
4872: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4873: l_errflag := 'Y';
4874: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4875: --||' must be > 0 '||l_str_common );
4876: END IF;
4877: --
4878: END IF;
4882: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
4883: --
4884: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4885: l_errflag := 'Y';
4886: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4887: --||' must be > 0 '||l_str_common );
4888: END IF;
4889: --
4890: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4888: END IF;
4889: --
4890: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4891: l_errflag := 'Y';
4892: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
4893: --||' must be > 0 '||l_str_common );
4894: END IF;
4895: --
4896: END IF;
4900: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
4901: --
4902: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4903: l_errflag := 'Y';
4904: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4905: --||' must be > 0 '||l_str_common );
4906: END IF;
4907: --
4908: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4906: END IF;
4907: --
4908: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4909: l_errflag := 'Y';
4910: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4911: --||' must be > 0 '||l_str_common );
4912: END IF;
4913: --
4914: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4912: END IF;
4913: --
4914: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4915: l_errflag := 'Y';
4916: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4917: --||' must be > 0 '||l_str_common );
4918: END IF;
4919: END IF;
4920: -------------
4925: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
4926: --
4927: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4928: l_errflag := 'Y';
4929: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4930: --||' must be > 0 '||l_str_common);
4931: END IF;
4932: --
4933: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4931: END IF;
4932: --
4933: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4934: l_errflag := 'Y';
4935: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4936: --||' must be > 0 '||l_str_common );
4937: END IF;
4938: --
4939: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4937: END IF;
4938: --
4939: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4940: l_errflag := 'Y';
4941: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4942: --||' must be > 0 '||l_str_common);
4943: END IF;
4944: --
4945: END IF;
4948: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
4949: --
4950: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4951: l_errflag := 'Y';
4952: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4953: --||' must be > 0 '||l_str_common );
4954: END IF;
4955: --
4956: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4954: END IF;
4955: --
4956: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4957: l_errflag := 'Y';
4958: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4959: --||' must be > 0 '||l_str_common);
4960: END IF;
4961: --
4962: END IF;
4965: l_str_common := 'An entry exists for paid contracted hours for '|| l_employee_categories;
4966: --
4967: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4968: l_errflag := 'Y';
4969: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4970: --||' must be > 0 '||l_str_common );
4971: END IF;
4972: --
4973: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4971: END IF;
4972: --
4973: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4974: l_errflag := 'Y';
4975: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4976: --||' must be > 0 '||l_str_common );
4977: END IF;
4978: END IF;
4979:
4982: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
4983: --
4984: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4985: l_errflag := 'Y';
4986: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4987: --||' must be > 0 '||l_str_common );
4988: END IF;
4989: --
4990: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4988: END IF;
4989: --
4990: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4991: l_errflag := 'Y';
4992: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4993: --||' must be > 0 '||l_str_common );
4994: END IF;
4995: --
4996: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4994: END IF;
4995: --
4996: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4997: l_errflag := 'Y';
4998: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4999: --||' must be > 0 '||l_str_common );
5000: END IF;
5001: --
5002: END IF;
5006: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
5007: --
5008: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
5009: l_errflag := 'Y';
5010: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5011: --||' must be > 0 '||l_str_common );
5012: END IF;
5013: --
5014: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
5012: END IF;
5013: --
5014: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
5015: l_errflag := 'Y';
5016: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
5017: --||' must be > 0 '||l_str_common );
5018: END IF;
5019: --
5020: END IF;
5024: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
5025: --
5026: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
5027: l_errflag := 'Y';
5028: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5029: --||' must be > 0 '||l_str_common );
5030: END IF;
5031: --
5032: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
5030: END IF;
5031: --
5032: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
5033: l_errflag := 'Y';
5034: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
5035: --||' must be > 0 '||l_str_common );
5036: END IF;
5037: --
5038: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
5036: END IF;
5037: --
5038: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
5039: l_errflag := 'Y';
5040: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5041: --||' must be > 0 '||l_str_common );
5042: END IF;
5043: END IF;
5044: -------------
5048: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
5049: --
5050: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
5051: l_errflag := 'Y';
5052: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5053: --||' must be > 0 '||l_str_common);
5054: END IF;
5055: --
5056: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5054: END IF;
5055: --
5056: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5057: l_errflag := 'Y';
5058: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
5059: --||' must be > 0 '||l_str_common );
5060: END IF;
5061: --
5062: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5060: END IF;
5061: --
5062: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5063: l_errflag := 'Y';
5064: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5065: --||' must be > 0 '||l_str_common);
5066: END IF;
5067: --
5068: END IF;
5071: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
5072: --
5073: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5074: l_errflag := 'Y';
5075: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
5076: --||' must be > 0 '||l_str_common );
5077: END IF;
5078: --
5079: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5077: END IF;
5078: --
5079: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5080: l_errflag := 'Y';
5081: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5082: --||' must be > 0 '||l_str_common);
5083: END IF;
5084: --
5085: END IF;
5088: l_str_common := 'An entry exists for paid contracted hours for '|| l_employee_categories;
5089: --
5090: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
5091: l_errflag := 'Y';
5092: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5093: --||' must be > 0 '||l_str_common );
5094: END IF;
5095: --
5096: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5094: END IF;
5095: --
5096: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5097: l_errflag := 'Y';
5098: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5099: --||' must be > 0 '||l_str_common );
5100: END IF;
5101: END IF;
5102:
5105: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
5106: --
5107: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
5108: l_errflag := 'Y';
5109: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5110: --||' must be > 0 '||l_str_common );
5111: END IF;
5112: --
5113: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5111: END IF;
5112: --
5113: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5114: l_errflag := 'Y';
5115: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
5116: --||' must be > 0 '||l_str_common );
5117: END IF;
5118: --
5119: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5117: END IF;
5118: --
5119: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5120: l_errflag := 'Y';
5121: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5122: --||' must be > 0 '||l_str_common );
5123: END IF;
5124: --
5125: END IF;
5129: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
5130: --
5131: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
5132: l_errflag := 'Y';
5133: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5134: --||' must be > 0 '||l_str_common );
5135: END IF;
5136: --
5137: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5135: END IF;
5136: --
5137: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5138: l_errflag := 'Y';
5139: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
5140: --||' must be > 0 '||l_str_common );
5141: END IF;
5142: --
5143: END IF;
5147: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
5148: --
5149: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
5150: l_errflag := 'Y';
5151: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
5152: --||' must be > 0 '||l_str_common );
5153: END IF;
5154: --
5155: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5153: END IF;
5154: --
5155: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
5156: l_errflag := 'Y';
5157: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
5158: --||' must be > 0 '||l_str_common );
5159: END IF;
5160: --
5161: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5159: END IF;
5160: --
5161: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
5162: l_errflag := 'Y';
5163: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
5164: --||' must be > 0 '||l_str_common );
5165: END IF;
5166: END IF;
5167:
5175: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
5176: ||' managers, professionals and associate professional employees is less than total paid'
5177: ||' contracted hours for all full time managers, professional and associate professional employees.';
5178: l_errflag := 'Y';
5179: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5180: END IF;
5181:
5182: IF (l_data_part4.l_ann_leave_ft_cl + l_data_part4.l_mat_leave_ft_cl +
5183: l_data_part4.l_sck_leave_ft_cl + l_data_part4.l_other_leave_ft_cl) >
5186: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
5187: ||' clerical, sales and service workers is less than or equal to total paid contracted hours for'
5188: ||' all full time clerical, sales and service workers.';
5189: l_errflag := 'Y';
5190: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5191: END IF;
5192:
5193: IF (l_data_part4.l_ann_leave_ft_ot + l_data_part4.l_mat_leave_ft_ot +
5194: l_data_part4.l_sck_leave_ft_ot + l_data_part4.l_other_leave_ft_ot ) >
5197: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
5198: ||' production, transport, craft, tradespersons and other manual workers is less than or equal to'
5199: ||' the total of paid contracted hours for all full time production, transport, craft, tradespersons and other manual workers.';
5200: l_errflag := 'Y';
5201: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5202: END IF;
5203:
5204: IF (l_data_part4.l_ann_leave_pt_mg + l_data_part4.l_mat_leave_pt_mg +
5205: l_data_part4.l_sck_leave_pt_mg + l_data_part4.l_other_leave_pt_mg) >
5208: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time managers,'
5209: ||' professionals and associate professional employees is less than or equal to total paid contracted hours for'
5210: ||' all part time managers, professional and associate professional employees.';
5211: l_errflag := 'Y';
5212: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5213:
5214: END IF;
5215:
5216: IF (l_data_part4.l_ann_leave_pt_cl + l_data_part4.l_mat_leave_pt_cl +
5220: l_str_common := 'The sum of annual leave, maternity leave, sick leave and other leave for all part time clerical,'
5221: ||' sales and service workers must be less than or equal to total paid contracted hours for all part time clerical,'
5222: ||' sales and service workers.';
5223: l_errflag := 'Y';
5224: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5225: END IF;
5226:
5227: IF ( l_data_part4.l_ann_leave_pt_ot + l_data_part4.l_mat_leave_pt_ot +
5228: l_data_part4.l_sck_leave_pt_ot + l_data_part4.l_other_leave_pt_ot) >
5231: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time production, '
5232: ||' transport, craft, tradespersons and other manual workers is less than or equal to the total of paid contracted '
5233: ||' hours for all part time production, transport, craft, tradespersons and other manual workers.';
5234: l_errflag := 'Y';
5235: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5236: END IF;
5237:
5238: IF ( l_data_part4.l_ann_leave_pt_ot + l_data_part4.l_mat_leave_pt_ot +
5239: l_data_part4.l_sck_leave_pt_ot + l_data_part4.l_other_leave_pt_ot) >
5241: l_errflag := 'Y';
5242: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time production,'
5243: ||' transport, craft, tradespersons and other manual workers is less than or equal to the total of paid contracted '
5244: ||' hours for all part time production, transport, craft, tradespersons and other manual workers.';
5245: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5246: END IF;
5247:
5248: IF l_data_part4.l_all_paid_leave_app_mg > l_data_part3.l_contracted_hrs_paid_app_mg THEN
5249: l_errflag := 'Y';
5249: l_errflag := 'Y';
5250: l_str_common := 'Ensure that all paid leave for apprentice/trainee managers, professionals and associate professional employees '
5251: ||'is less than or equal to total paid contracted hours for all apprentice/trainee managers, professionals and '
5252: ||' associate professionals.';
5253: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5254: END IF;
5255:
5256: IF l_data_part4.l_all_paid_leave_app_cl > l_data_part3.l_contracted_hrs_paid_app_cl THEN
5257: l_errflag := 'Y';
5256: IF l_data_part4.l_all_paid_leave_app_cl > l_data_part3.l_contracted_hrs_paid_app_cl THEN
5257: l_errflag := 'Y';
5258: l_str_common := 'Ensure that all paid leave for apprentice/trainee clerical, sales and service workers is less than'
5259: ||' or equal to total paid contracted hours for all apprentice/trainee clerical, sales and service workers.';
5260: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5261: END IF;
5262:
5263: IF l_data_part4.l_all_paid_leave_app_ot > l_data_part3.l_contracted_hrs_paid_app_ot THEN
5264: l_errflag := 'Y';
5264: l_errflag := 'Y';
5265: l_str_common := 'Ensure that all paid leave for apprentice/trainee production, transport, craft, tradespersons and other '
5266: ||' manual workers is less than or equal to total paid contracted hours for all apprentice/trainee '
5267: ||' production, transport, craft, tradespersons and other manual workers.';
5268: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5269: END IF;
5270:
5271: --6922250
5272: /*
5531: l_str_common := 'The report completed with validation warning(s). Do not submit the generated XML file '
5532: ||'as it may not be in the correct format. You can, however, modify and use the template output.';
5533:
5534: IF l_errflag = 'Y' THEN
5535: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5536: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5537: 'EHECS Report completed with validation warning(s).');
5538: END IF;
5539: