[Home] [Help]
645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
646:
647: IF l_employer_name IS NULL THEN
648: l_errflag := 'Y';
649: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
650: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
651: END IF;
652: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
653: l_errflag := 'Y';
646:
647: IF l_employer_name IS NULL THEN
648: l_errflag := 'Y';
649: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
650: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
651: END IF;
652: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
653: l_errflag := 'Y';
654: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
650: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
651: END IF;
652: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
653: l_errflag := 'Y';
654: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
655: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
656: END IF;
657: IF l_cbr_no IS NULL THEN
658: l_errflag := 'Y';
651: END IF;
652: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
653: l_errflag := 'Y';
654: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
655: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
656: END IF;
657: IF l_cbr_no IS NULL THEN
658: l_errflag := 'Y';
659: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
655: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
656: END IF;
657: IF l_cbr_no IS NULL THEN
658: l_errflag := 'Y';
659: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
660: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
661: END IF;
662: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
663: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
656: END IF;
657: IF l_cbr_no IS NULL THEN
658: l_errflag := 'Y';
659: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
660: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
661: END IF;
662: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
663: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
664: l_errflag := 'Y';
661: END IF;
662: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
663: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
664: l_errflag := 'Y';
665: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
666: 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.' );
667: END IF;
668:
669: hr_utility.set_location('l_errflag '||l_errflag, 370);
662: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
663: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
664: l_errflag := 'Y';
665: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
666: 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.' );
667: END IF;
668:
669: hr_utility.set_location('l_errflag '||l_errflag, 370);
670:
668:
669: hr_utility.set_location('l_errflag '||l_errflag, 370);
670:
671: IF l_errflag = 'Y' THEN
672: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
673: Raise l_ehecs_exception;
674: END IF;
675:
676: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
815:
816: hr_utility.set_location('After building the dynamic query.',520);
817:
818: /*6978389 */
819: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
820:
821: OPEN csr_get_asg FOR l_select_str; -- ref cursor
822: LOOP
823: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
1174: l_chrs_bal_val:=(nvl(l_valid_asg_rec.normal_hours,0))/4;
1175: END IF;
1176: /* ELSE
1177: l_errflag := 'Y';
1178: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Normal hours value is not null at the assignment level of person'||p_person_id );
1179: Raise l_ehecs_exception;
1180: END IF;
1181: */
1182: ELSE
3411: 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.';
3412: --
3413: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3414: l_errflag := 'Y';
3415: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories || l_is_gt_0);
3416: --||' must be > 0 '||l_str_common);
3417: END IF;
3418: --
3419: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3417: END IF;
3418: --
3419: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3420: l_errflag := 'Y';
3421: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories || l_is_gt_0 );
3422: --||' must be > 0 '||l_str_common );
3423: END IF;
3424: --
3425: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3423: END IF;
3424: --
3425: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3426: l_errflag := 'Y';
3427: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories || l_is_gt_0 );
3428: --||' must be > 0 '||l_str_common);
3429: END IF;
3430: --
3431:
3436: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
3437: --
3438: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3439: l_errflag := 'Y';
3440: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories || l_is_gt_0 );
3441:
3442: END IF;
3443: --
3444: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3442: END IF;
3443: --
3444: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3445: l_errflag := 'Y';
3446: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories || l_is_gt_0 );
3447:
3448: END IF;
3449:
3450: END IF;
3453: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
3454: --
3455: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3456: l_errflag := 'Y';
3457: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3458: --||' must be > 0 '||l_str_common );
3459: END IF;
3460: --
3461: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3459: END IF;
3460: --
3461: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3462: l_errflag := 'Y';
3463: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3464: --||' must be > 0 '||l_str_common );
3465: END IF;
3466: --
3467: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3465: END IF;
3466: --
3467: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3468: l_errflag := 'Y';
3469: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3470: --||' must be > 0 '||l_str_common );
3471: END IF;
3472: END IF;
3473: --
3475: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories ;
3476: --
3477: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3478: l_errflag := 'Y';
3479: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3480: --||' must be > 0 '||l_str_common );
3481: END IF;
3482: --
3483: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3481: END IF;
3482: --
3483: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3484: l_errflag := 'Y';
3485: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3486: --||' must be > 0 '||l_str_common );
3487: END IF;
3488: --
3489: IF l_data_part3.l_ot_hrs_paid_ft_mg = 0 THEN
3487: END IF;
3488: --
3489: IF l_data_part3.l_ot_hrs_paid_ft_mg = 0 THEN
3490: l_errflag := 'Y';
3491: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
3492: --||' must be > 0 '||l_str_common );
3493: END IF;
3494: --
3495: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3493: END IF;
3494: --
3495: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3496: l_errflag := 'Y';
3497: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3498: --||' must be > 0 '||l_str_common );
3499: END IF;
3500: --
3501: END IF;
3504: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
3505: --
3506: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3507: l_errflag := 'Y';
3508: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3509: --||' must be > 0 '||l_str_common );
3510: END IF;
3511: --
3512: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3510: END IF;
3511: --
3512: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3513: l_errflag := 'Y';
3514: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3515: --||' must be > 0 '||l_str_common );
3516: END IF;
3517: --
3518: END IF;
3522: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
3523: --
3524: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3525: l_errflag := 'Y';
3526: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3527: --||' must be > 0 '||l_str_common );
3528: END IF;
3529: --
3530: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3528: END IF;
3529: --
3530: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3531: l_errflag := 'Y';
3532: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3533: --||' must be > 0 '||l_str_common );
3534: END IF;
3535: --
3536: IF l_data_part2.l_ot_paid_ft_mg = 0 THEN
3534: END IF;
3535: --
3536: IF l_data_part2.l_ot_paid_ft_mg = 0 THEN
3537: l_errflag := 'Y';
3538: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
3539: --||' must be > 0 '||l_str_common );
3540: END IF;
3541: --
3542: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3540: END IF;
3541: --
3542: IF l_data_part4.l_ann_leave_ft_mg = 0 THEN
3543: l_errflag := 'Y';
3544: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3545: --||' must be > 0 '||l_str_common );
3546: END IF;
3547: --
3548: END IF;
3552: 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;
3553: --
3554: IF l_data_part2.l_reg_wg_ft_mg = 0 THEN
3555: l_errflag := 'Y';
3556: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3557: --||' must be > 0 '||l_str_common );
3558: END IF;
3559: --
3560: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3558: END IF;
3559: --
3560: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 THEN
3561: l_errflag := 'Y';
3562: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3563: --||' must be > 0 '||l_str_common );
3564: END IF;
3565: --
3566: END IF;
3570: ||' the first day of the quarter or the last day of the quarter.';
3571: --
3572: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3573: l_errflag := 'Y';
3574: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3575: --||' must be > 0 '||l_str_common );
3576: END IF;
3577: --
3578: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3576: END IF;
3577: --
3578: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3579: l_errflag := 'Y';
3580: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3581: --||' must be > 0 '||l_str_common );
3582: END IF;
3583: --
3584: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3582: END IF;
3583: --
3584: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3585: l_errflag := 'Y';
3586: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3587: --||' must be > 0 '||l_str_common );
3588: END IF;
3589: --
3590: END IF;
3593: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
3594: --
3595: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3596: l_errflag := 'Y';
3597: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3598: --||' must be > 0 '||l_str_common );
3599: END IF;
3600: --
3601: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3599: END IF;
3600: --
3601: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3602: l_errflag := 'Y';
3603: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3604: --||' must be > 0 '||l_str_common );
3605: END IF;
3606: --
3607: END IF;
3610: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
3611: --
3612: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3613: l_errflag := 'Y';
3614: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3615: --||' must be > 0 '||l_str_common );
3616: END IF;
3617: --
3618: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3616: END IF;
3617: --
3618: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3619: l_errflag := 'Y';
3620: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3621: --||' must be > 0 '||l_str_common );
3622: END IF;
3623: --
3624: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3622: END IF;
3623: --
3624: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3625: l_errflag := 'Y';
3626: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3627: --||' must be > 0 '||l_str_common );
3628: END IF;
3629: --
3630: END IF;
3633: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
3634: --
3635: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3636: l_errflag := 'Y';
3637: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3638: --||' must be > 0 '||l_str_common );
3639: END IF;
3640: --
3641: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3639: END IF;
3640: --
3641: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3642: l_errflag := 'Y';
3643: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3644: --||' must be > 0 '||l_str_common );
3645: END IF;
3646: --
3647: IF l_data_part3.l_ot_hrs_paid_pt_mg = 0 THEN
3645: END IF;
3646: --
3647: IF l_data_part3.l_ot_hrs_paid_pt_mg = 0 THEN
3648: l_errflag := 'Y';
3649: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
3650: --||' must be > 0 '||l_str_common );
3651: END IF;
3652: --
3653: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3651: END IF;
3652: --
3653: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3654: l_errflag := 'Y';
3655: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3656: --||' must be > 0 '||l_str_common );
3657: END IF;
3658: END IF;
3659:
3661: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
3662: --
3663: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3664: l_errflag := 'Y';
3665: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3666: --||' must be > 0 '||l_str_common );
3667: END IF;
3668: --
3669: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3667: END IF;
3668: --
3669: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3670: l_errflag := 'Y';
3671: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3672: --||' must be > 0 '||l_str_common );
3673: END IF;
3674: END IF;
3675:
3677: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
3678: --
3679: IF l_data_part2.l_reg_wg_pt_mg = 0 THEN
3680: l_errflag := 'Y';
3681: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3682: --||' must be > 0 '||l_str_common );
3683: END IF;
3684: --
3685: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3683: END IF;
3684: --
3685: IF l_data_part4.l_ann_leave_pt_mg = 0 THEN
3686: l_errflag := 'Y';
3687: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3688: --||' must be > 0 '||l_str_common );
3689: END IF;
3690: --
3691: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3689: END IF;
3690: --
3691: IF l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3692: l_errflag := 'Y';
3693: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3694: --||' must be > 0 '||l_str_common );
3695: END IF;
3696: END IF;
3697:
3699: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
3700: --
3701: 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
3702: l_errflag := 'Y';
3703: 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 );
3704: --||' must be > 0 '||l_str_common );
3705: END IF;
3706: --
3707: 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
3705: END IF;
3706: --
3707: 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
3708: l_errflag := 'Y';
3709: 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 );
3710: --||' must be > 0 '||l_str_common );
3711: END IF;
3712: --
3713: 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
3711: END IF;
3712: --
3713: 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
3714: l_errflag := 'Y';
3715: 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 );
3716: --||' must be > 0 '||l_str_common );
3717: END IF;
3718: END IF;
3719:
3722: l_str_common := 'An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees.';
3723:
3724: IF l_data_part2.l_reg_wg_ft_mg = 0 AND l_data_part2.l_reg_wg_pt_mg = 0 THEN
3725: l_errflag := 'Y';
3726: 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 );
3727: --||' must be > 0 '||l_str_common );
3728: END IF;
3729: --
3730: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3728: END IF;
3729: --
3730: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3731: l_errflag := 'Y';
3732: 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 );
3733: --||' must be > 0 '||l_str_common );
3734: END IF;
3735: --
3736: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
3734: END IF;
3735: --
3736: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
3737: l_errflag := 'Y';
3738: 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 );
3739: --||' must be > 0 '||l_str_common );
3740: END IF;
3741: --
3742: END If;
3747: l_str_common := ' An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
3748: --
3749: IF l_data_part2.l_reg_wg_ft_mg = 0 AND l_data_part2.l_reg_wg_pt_mg = 0 THEN
3750: l_errflag := 'Y';
3751: 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 );
3752: --||' must be > 0 '||l_str_common );
3753: END IF;
3754: --
3755: --
3754: --
3755: --
3756: IF l_data_part3.l_contracted_hrs_paid_ft_mg = 0 AND l_data_part3.l_contracted_hrs_paid_pt_mg = 0 THEN
3757: l_errflag := 'Y';
3758: 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 );
3759: --||' must be > 0 '||l_str_common );
3760: END IF;
3761: --
3762: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
3760: END IF;
3761: --
3762: IF l_data_part4.l_ann_leave_ft_mg = 0 AND l_data_part4.l_ann_leave_pt_mg = 0 THEN
3763: l_errflag := 'Y';
3764: 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 );
3765: --||' must be > 0 '||l_str_common );
3766: END IF;
3767: END IF;
3768: ----------------Section B: Full and part time clerical, sales and service workers:
3772: 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 ';
3773: --
3774: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3775: l_errflag := 'Y';
3776: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3777: --||' must be > 0 '||l_str_common);
3778: END IF;
3779: --
3780: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3778: END IF;
3779: --
3780: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3781: l_errflag := 'Y';
3782: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3783: --||' must be > 0 '||l_str_common );
3784: END IF;
3785: --
3786: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3784: END IF;
3785: --
3786: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3787: l_errflag := 'Y';
3788: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3789: --||' must be > 0 '||l_str_common);
3790: END IF;
3791: --
3792:
3796: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
3797: --
3798: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3799: l_errflag := 'Y';
3800: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3801: --||' must be > 0 '||l_str_common );
3802: END IF;
3803: --
3804: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3802: END IF;
3803: --
3804: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3805: l_errflag := 'Y';
3806: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3807: --||' must be > 0 '||l_str_common);
3808: END IF;
3809: --
3810:
3814: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
3815: --
3816: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3817: l_errflag := 'Y';
3818: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3819: --||' must be > 0 '||l_str_common );
3820: END IF;
3821: --
3822: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3820: END IF;
3821: --
3822: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3823: l_errflag := 'Y';
3824: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3825: --||' must be > 0 '||l_str_common );
3826: END IF;
3827: --
3828: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3826: END IF;
3827: --
3828: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3829: l_errflag := 'Y';
3830: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3831: --||' must be > 0 '||l_str_common );
3832: END IF;
3833: END IF;
3834: --
3836: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories;
3837: --
3838: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3839: l_errflag := 'Y';
3840: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3841: --||' must be > 0 '||l_str_common );
3842: END IF;
3843: --
3844: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3842: END IF;
3843: --
3844: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3845: l_errflag := 'Y';
3846: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3847: --||' must be > 0 '||l_str_common );
3848: END IF;
3849: --
3850: IF l_data_part3.l_ot_hrs_paid_ft_cl = 0 THEN
3848: END IF;
3849: --
3850: IF l_data_part3.l_ot_hrs_paid_ft_cl = 0 THEN
3851: l_errflag := 'Y';
3852: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
3853: --||' must be > 0 '||l_str_common );
3854: END IF;
3855: --
3856: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3854: END IF;
3855: --
3856: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3857: l_errflag := 'Y';
3858: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3859: --||' must be > 0 '||l_str_common );
3860: END IF;
3861: --
3862: END IF;
3865: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
3866: --
3867: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3868: l_errflag := 'Y';
3869: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3870: --||' must be > 0 '||l_str_common );
3871: END IF;
3872: --
3873: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3871: END IF;
3872: --
3873: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3874: l_errflag := 'Y';
3875: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3876: --||' must be > 0 '||l_str_common );
3877: END IF;
3878: --
3879: END IF;
3883: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
3884: --
3885: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3886: l_errflag := 'Y';
3887: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
3888: --||' must be > 0 '||l_str_common );
3889: END IF;
3890: --
3891: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3889: END IF;
3890: --
3891: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3892: l_errflag := 'Y';
3893: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3894: --||' must be > 0 '||l_str_common );
3895: END IF;
3896: --
3897: IF l_data_part2.l_ot_paid_ft_cl = 0 THEN
3895: END IF;
3896: --
3897: IF l_data_part2.l_ot_paid_ft_cl = 0 THEN
3898: l_errflag := 'Y';
3899: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
3900: -- ||' must be > 0 '||l_str_common );
3901: END IF;
3902: --
3903: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3901: END IF;
3902: --
3903: IF l_data_part4.l_ann_leave_ft_cl = 0 THEN
3904: l_errflag := 'Y';
3905: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
3906: --||' must be > 0 '||l_str_common );
3907: END IF;
3908: --
3909: END IF;
3914:
3915: --
3916: IF l_data_part2.l_reg_wg_ft_cl = 0 THEN
3917: l_errflag := 'Y';
3918: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full 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_ft_cl = 0 THEN
3920: END IF;
3921: --
3922: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 THEN
3923: l_errflag := 'Y';
3924: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
3925: --||' must be > 0 '||l_str_common );
3926: END IF;
3927: --
3928: END IF;
3932: ||' the first day of the quarter or the last day of the quarter.';
3933: --
3934: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
3935: l_errflag := 'Y';
3936: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3937: --||' must be > 0 '||l_str_common );
3938: END IF;
3939: --
3940: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
3938: END IF;
3939: --
3940: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
3941: l_errflag := 'Y';
3942: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3943: --||' must be > 0 '||l_str_common );
3944: END IF;
3945: --
3946: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3944: END IF;
3945: --
3946: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3947: l_errflag := 'Y';
3948: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3949: --||' must be > 0 '||l_str_common );
3950: END IF;
3951: --
3952: END IF;
3955: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
3956: --
3957: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
3958: l_errflag := 'Y';
3959: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3960: --||' must be > 0 '||l_str_common );
3961: END IF;
3962: --
3963: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3961: END IF;
3962: --
3963: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3964: l_errflag := 'Y';
3965: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3966: --||' must be > 0 '||l_str_common );
3967: END IF;
3968: --
3969: END IF;
3972: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
3973: --
3974: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
3975: l_errflag := 'Y';
3976: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
3977: --||' must be > 0 '||l_str_common );
3978: END IF;
3979: --
3980: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
3978: END IF;
3979: --
3980: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
3981: l_errflag := 'Y';
3982: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
3983: --||' must be > 0 '||l_str_common );
3984: END IF;
3985: --
3986: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3984: END IF;
3985: --
3986: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
3987: l_errflag := 'Y';
3988: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
3989: --||' must be > 0 '||l_str_common );
3990: END IF;
3991: --
3992: END IF;
3995: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
3996: --
3997: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
3998: l_errflag := 'Y';
3999: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4000: --||' must be > 0 '||l_str_common );
4001: END IF;
4002: --
4003: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4001: END IF;
4002: --
4003: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4004: l_errflag := 'Y';
4005: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4006: --||' must be > 0 '||l_str_common );
4007: END IF;
4008: --
4009: IF l_data_part3.l_ot_hrs_paid_pt_cl = 0 THEN
4007: END IF;
4008: --
4009: IF l_data_part3.l_ot_hrs_paid_pt_cl = 0 THEN
4010: l_errflag := 'Y';
4011: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
4012: --||' must be > 0 '||l_str_common );
4013: END IF;
4014: --
4015: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4013: END IF;
4014: --
4015: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4016: l_errflag := 'Y';
4017: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4018: --||' must be > 0 '||l_str_common );
4019: END IF;
4020: END IF;
4021:
4023: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
4024: --
4025: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4026: l_errflag := 'Y';
4027: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4028: --||' must be > 0 '||l_str_common );
4029: END IF;
4030: --
4031: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4029: END IF;
4030: --
4031: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4032: l_errflag := 'Y';
4033: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4034: --||' must be > 0 '||l_str_common );
4035: END IF;
4036: END IF;
4037:
4039: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
4040: --
4041: IF l_data_part2.l_reg_wg_pt_cl = 0 THEN
4042: l_errflag := 'Y';
4043: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4044: --||' must be > 0 '||l_str_common );
4045: END IF;
4046: --
4047: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4045: END IF;
4046: --
4047: IF l_data_part4.l_ann_leave_pt_cl = 0 THEN
4048: l_errflag := 'Y';
4049: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4050: --||' must be > 0 '||l_str_common );
4051: END IF;
4052: --
4053: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4051: END IF;
4052: --
4053: IF l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4054: l_errflag := 'Y';
4055: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4056: --||' must be > 0 '||l_str_common );
4057: END IF;
4058: END IF;
4059:
4061: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
4062: --
4063: 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
4064: l_errflag := 'Y';
4065: 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 );
4066: --||' must be > 0 '||l_str_common );
4067: END IF;
4068: --
4069: 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
4067: END IF;
4068: --
4069: 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
4070: l_errflag := 'Y';
4071: 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 );
4072: --||' must be > 0 '||l_str_common );
4073: END IF;
4074: --
4075: 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
4073: END IF;
4074: --
4075: 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
4076: l_errflag := 'Y';
4077: 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 );
4078: --||' must be > 0 '||l_str_common );
4079: END IF;
4080: END IF;
4081:
4084: l_str_common := 'An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees.';
4085:
4086: IF l_data_part2.l_reg_wg_ft_cl = 0 AND l_data_part2.l_reg_wg_pt_cl = 0 THEN
4087: l_errflag := 'Y';
4088: 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 );
4089: --||' must be > 0 '||l_str_common );
4090: END IF;
4091: --
4092: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4090: END IF;
4091: --
4092: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4093: l_errflag := 'Y';
4094: 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 );
4095: --||' must be > 0 '||l_str_common );
4096: END IF;
4097: --
4098: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4096: END IF;
4097: --
4098: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4099: l_errflag := 'Y';
4100: 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 );
4101: --||' must be > 0 '||l_str_common );
4102: END IF;
4103: --
4104: END If;
4109: l_str_common := 'An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
4110: --
4111: IF l_data_part2.l_reg_wg_ft_cl = 0 AND l_data_part2.l_reg_wg_pt_cl = 0 THEN
4112: l_errflag := 'Y';
4113: 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 );
4114: --||' must be > 0 '||l_str_common );
4115: END IF;
4116: --
4117: --
4116: --
4117: --
4118: IF l_data_part3.l_contracted_hrs_paid_ft_cl = 0 AND l_data_part3.l_contracted_hrs_paid_pt_cl = 0 THEN
4119: l_errflag := 'Y';
4120: 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 );
4121: --||' must be > 0 '||l_str_common );
4122: END IF;
4123: --
4124: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4122: END IF;
4123: --
4124: IF l_data_part4.l_ann_leave_ft_cl = 0 AND l_data_part4.l_ann_leave_pt_cl = 0 THEN
4125: l_errflag := 'Y';
4126: 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 );
4127: --||' must be > 0 '||l_str_common );
4128: END IF;
4129: END IF;
4130:
4135: 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.';
4136: --
4137: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4138: l_errflag := 'Y';
4139: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4140: --||' must be > 0 '||l_str_common);
4141: END IF;
4142: --
4143: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4141: END IF;
4142: --
4143: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4144: l_errflag := 'Y';
4145: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4146: --||' must be > 0 '||l_str_common );
4147: END IF;
4148: --
4149: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4147: END IF;
4148: --
4149: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4150: l_errflag := 'Y';
4151: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4152: --||' must be > 0 '||l_str_common);
4153: END IF;
4154: --
4155: --
4159: l_str_common := 'An entry exists for regular wages and salaries for full time '|| l_employee_categories;
4160: --
4161: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4162: l_errflag := 'Y';
4163: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4164: --||' must be > 0 '||l_str_common );
4165: END IF;
4166: --
4167: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4165: END IF;
4166: --
4167: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4168: l_errflag := 'Y';
4169: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4170: --||' must be > 0 '||l_str_common);
4171: END IF;
4172: --
4173: --
4177: l_str_common := 'An entry exists for irregular bonuses and allowances for full time '|| l_employee_categories;
4178: --
4179: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4180: l_errflag := 'Y';
4181: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4182: --||' must be > 0 '||l_str_common );
4183: END IF;
4184: --
4185: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4183: END IF;
4184: --
4185: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4186: l_errflag := 'Y';
4187: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4188: --||' must be > 0 '||l_str_common );
4189: END IF;
4190: --
4191: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4189: END IF;
4190: --
4191: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4192: l_errflag := 'Y';
4193: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4194: --||' must be > 0 '||l_str_common );
4195: END IF;
4196: END IF;
4197: --
4199: l_str_common := 'An entry exists for overtime for full time '|| l_employee_categories;
4200: --
4201: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4202: l_errflag := 'Y';
4203: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4204: --||' must be > 0 '||l_str_common );
4205: END IF;
4206: --
4207: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4205: END IF;
4206: --
4207: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4208: l_errflag := 'Y';
4209: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4210: --||' must be > 0 '||l_str_common );
4211: END IF;
4212: --
4213: IF l_data_part3.l_ot_hrs_paid_ft_ot = 0 THEN
4211: END IF;
4212: --
4213: IF l_data_part3.l_ot_hrs_paid_ft_ot = 0 THEN
4214: l_errflag := 'Y';
4215: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - full time '|| l_employee_categories|| l_is_gt_0 );
4216: --||' must be > 0 '||l_str_common );
4217: END IF;
4218: --
4219: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4217: END IF;
4218: --
4219: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4220: l_errflag := 'Y';
4221: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4222: --||' must be > 0 '||l_str_common );
4223: END IF;
4224: --
4225: END IF;
4228: l_str_common := 'An entry exists for contracted hours for full time '|| l_employee_categories;
4229: --
4230: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4231: l_errflag := 'Y';
4232: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4233: --||' must be > 0 '||l_str_common );
4234: END IF;
4235: --
4236: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4234: END IF;
4235: --
4236: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4237: l_errflag := 'Y';
4238: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4239: --||' must be > 0 '||l_str_common );
4240: END IF;
4241: --
4242: END IF;
4246: l_str_common := 'An entry exists for overtime hours for full time '|| l_employee_categories;
4247: --
4248: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4249: l_errflag := 'Y';
4250: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full time '|| l_employee_categories|| l_is_gt_0 );
4251: --||' must be > 0 '||l_str_common );
4252: END IF;
4253: --
4254: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4252: END IF;
4253: --
4254: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4255: l_errflag := 'Y';
4256: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4257: --||' must be > 0 '||l_str_common );
4258: END IF;
4259: --
4260: IF l_data_part2.l_ot_paid_ft_ot = 0 THEN
4258: END IF;
4259: --
4260: IF l_data_part2.l_ot_paid_ft_ot = 0 THEN
4261: l_errflag := 'Y';
4262: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Overtime - full time '|| l_employee_categories|| l_is_gt_0 );
4263: --||' must be > 0 '||l_str_common );
4264: END IF;
4265: --
4266: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4264: END IF;
4265: --
4266: IF l_data_part4.l_ann_leave_ft_ot = 0 THEN
4267: l_errflag := 'Y';
4268: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - full time '|| l_employee_categories|| l_is_gt_0 );
4269: --||' must be > 0 '||l_str_common );
4270: END IF;
4271: --
4272: END IF;
4276: 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;
4277: --
4278: IF l_data_part2.l_reg_wg_ft_ot = 0 THEN
4279: l_errflag := 'Y';
4280: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - full 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_ft_ot = 0 THEN
4282: END IF;
4283: --
4284: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 THEN
4285: l_errflag := 'Y';
4286: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - full time '|| l_employee_categories|| l_is_gt_0 );
4287: --||' must be > 0 '||l_str_common );
4288: END IF;
4289: --
4290: END IF;
4294: ||' the first day of the quarter or the last day of the quarter.';
4295: --
4296: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4297: l_errflag := 'Y';
4298: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4299: --||' must be > 0 '||l_str_common );
4300: END IF;
4301: --
4302: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4300: END IF;
4301: --
4302: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4303: l_errflag := 'Y';
4304: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4305: --||' must be > 0 '||l_str_common );
4306: END IF;
4307: --
4308: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4306: END IF;
4307: --
4308: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4309: l_errflag := 'Y';
4310: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4311: --||' must be > 0 '||l_str_common );
4312: END IF;
4313: --
4314: END IF;
4317: l_str_common := 'An entry exists for regular wages and salaries for part time '|| l_employee_categories;
4318: --
4319: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4320: l_errflag := 'Y';
4321: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4322: --||' must be > 0 '||l_str_common );
4323: END IF;
4324: --
4325: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4323: END IF;
4324: --
4325: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4326: l_errflag := 'Y';
4327: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4328: --||' must be > 0 '||l_str_common );
4329: END IF;
4330: --
4331: END IF;
4334: l_str_common := 'An entry exists for irregular bonuses and allowances for part time '|| l_employee_categories;
4335: --
4336: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4337: l_errflag := 'Y';
4338: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4339: --||' must be > 0 '||l_str_common );
4340: END IF;
4341: --
4342: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4340: END IF;
4341: --
4342: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4343: l_errflag := 'Y';
4344: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4345: --||' must be > 0 '||l_str_common );
4346: END IF;
4347: --
4348: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4346: END IF;
4347: --
4348: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4349: l_errflag := 'Y';
4350: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4351: --||' must be > 0 '||l_str_common );
4352: END IF;
4353: --
4354: END IF;
4357: l_str_common := 'An entry exists for overtime for part time '|| l_employee_categories;
4358: --
4359: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4360: l_errflag := 'Y';
4361: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4362: --||' must be > 0 '||l_str_common );
4363: END IF;
4364: --
4365: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4363: END IF;
4364: --
4365: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4366: l_errflag := 'Y';
4367: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4368: --||' must be > 0 '||l_str_common );
4369: END IF;
4370: --
4371: IF l_data_part3.l_ot_hrs_paid_pt_ot = 0 THEN
4369: END IF;
4370: --
4371: IF l_data_part3.l_ot_hrs_paid_pt_ot = 0 THEN
4372: l_errflag := 'Y';
4373: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid overtime hours - part time '|| l_employee_categories|| l_is_gt_0 );
4374: --||' must be > 0 '||l_str_common );
4375: END IF;
4376: --
4377: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4375: END IF;
4376: --
4377: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4378: l_errflag := 'Y';
4379: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4380: --||' must be > 0 '||l_str_common );
4381: END IF;
4382: END IF;
4383:
4385: l_str_common := 'An entry exists for paid contracted hours for part time '|| l_employee_categories;
4386: --
4387: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4388: l_errflag := 'Y';
4389: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4390: --||' must be > 0 '||l_str_common );
4391: END IF;
4392: --
4393: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4391: END IF;
4392: --
4393: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4394: l_errflag := 'Y';
4395: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4396: --||' must be > 0 '||l_str_common );
4397: END IF;
4398: END IF;
4399:
4401: l_str_common := 'An entry exists for overtime hours for part time '|| l_employee_categories;
4402: --
4403: IF l_data_part2.l_reg_wg_pt_ot = 0 THEN
4404: l_errflag := 'Y';
4405: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Regular wages and salaries - part time '|| l_employee_categories|| l_is_gt_0 );
4406: --||' must be > 0 '||l_str_common );
4407: END IF;
4408: --
4409: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4407: END IF;
4408: --
4409: IF l_data_part4.l_ann_leave_pt_ot = 0 THEN
4410: l_errflag := 'Y';
4411: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Annual Leave and Bank Holidays - part time '|| l_employee_categories|| l_is_gt_0 );
4412: --||' must be > 0 '||l_str_common );
4413: END IF;
4414: --
4415: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4413: END IF;
4414: --
4415: IF l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4416: l_errflag := 'Y';
4417: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours - part time '|| l_employee_categories|| l_is_gt_0 );
4418: --||' must be > 0 '||l_str_common );
4419: END IF;
4420: END IF;
4421:
4423: l_str_common := ' An entry exists for Employers contributions to pension funds for '|| l_employee_categories;
4424: --
4425: 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
4426: l_errflag := 'Y';
4427: 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 );
4428: --||' must be > 0 '||l_str_common );
4429: END IF;
4430: --
4431: 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
4429: END IF;
4430: --
4431: 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
4432: l_errflag := 'Y';
4433: 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 );
4434: --||' must be > 0 '||l_str_common );
4435: END IF;
4436: --
4437: 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
4435: END IF;
4436: --
4437: 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
4438: l_errflag := 'Y';
4439: 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 );
4440: --||' must be > 0 '||l_str_common );
4441: END IF;
4442: END IF;
4443:
4446: l_str_common := ' An entry exists for Social Security Contributions for full time and part time '|| l_employee_categories||' employees ';
4447:
4448: IF l_data_part2.l_reg_wg_ft_ot = 0 AND l_data_part2.l_reg_wg_pt_ot = 0 THEN
4449: l_errflag := 'Y';
4450: 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 );
4451: --||' must be > 0 '||l_str_common );
4452: END IF;
4453: --
4454: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4452: END IF;
4453: --
4454: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4455: l_errflag := 'Y';
4456: 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 );
4457: --||' must be > 0 '||l_str_common );
4458: END IF;
4459: --
4460: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4458: END IF;
4459: --
4460: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4461: l_errflag := 'Y';
4462: 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 );
4463: --||' must be > 0 '||l_str_common );
4464: END IF;
4465: --
4466: END If;
4471: l_str_common := 'An entry exists for Other Benefits to Employees - full time and part time '|| l_employee_categories;
4472: --
4473: IF l_data_part2.l_reg_wg_ft_ot = 0 AND l_data_part2.l_reg_wg_pt_ot = 0 THEN
4474: l_errflag := 'Y';
4475: 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 );
4476: --||' must be > 0 '||l_str_common );
4477: END IF;
4478: --
4479: --
4478: --
4479: --
4480: IF l_data_part3.l_contracted_hrs_paid_ft_ot = 0 AND l_data_part3.l_contracted_hrs_paid_pt_ot = 0 THEN
4481: l_errflag := 'Y';
4482: 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 );
4483: --||' must be > 0 '||l_str_common );
4484: END IF;
4485: --
4486: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4484: END IF;
4485: --
4486: IF l_data_part4.l_ann_leave_ft_ot = 0 AND l_data_part4.l_ann_leave_pt_ot = 0 THEN
4487: l_errflag := 'Y';
4488: 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 );
4489: --||' must be > 0 '||l_str_common );
4490: END IF;
4491: END IF;
4492:
4497: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
4498: --
4499: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4500: l_errflag := 'Y';
4501: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4502: --||' must be > 0 '||l_str_common);
4503: END IF;
4504: --
4505: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4503: END IF;
4504: --
4505: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4506: l_errflag := 'Y';
4507: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4508: --||' must be > 0 '||l_str_common );
4509: END IF;
4510: --
4511: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4509: END IF;
4510: --
4511: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4512: l_errflag := 'Y';
4513: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4514: --||' must be > 0 '||l_str_common);
4515: END IF;
4516: --
4517: END IF;
4520: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
4521: --
4522: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4523: l_errflag := 'Y';
4524: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4525: --||' must be > 0 '||l_str_common );
4526: END IF;
4527: --
4528: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4526: END IF;
4527: --
4528: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4529: l_errflag := 'Y';
4530: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4531: --||' must be > 0 '||l_str_common);
4532: END IF;
4533: --
4534: END IF;
4537: l_str_common := 'An entry exists for paid contracted hours for '|| l_employee_categories;
4538: --
4539: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4540: l_errflag := 'Y';
4541: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4542: --||' must be > 0 '||l_str_common );
4543: END IF;
4544: --
4545: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4543: END IF;
4544: --
4545: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4546: l_errflag := 'Y';
4547: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4548: --||' must be > 0 '||l_str_common );
4549: END IF;
4550: END IF;
4551:
4554: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
4555: --
4556: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4557: l_errflag := 'Y';
4558: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4559: --||' must be > 0 '||l_str_common );
4560: END IF;
4561: --
4562: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4560: END IF;
4561: --
4562: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4563: l_errflag := 'Y';
4564: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4565: --||' must be > 0 '||l_str_common );
4566: END IF;
4567: --
4568: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4566: END IF;
4567: --
4568: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4569: l_errflag := 'Y';
4570: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4571: --||' must be > 0 '||l_str_common );
4572: END IF;
4573: --
4574: END IF;
4578: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
4579: --
4580: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4581: l_errflag := 'Y';
4582: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4583: --||' must be > 0 '||l_str_common );
4584: END IF;
4585: --
4586: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4584: END IF;
4585: --
4586: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4587: l_errflag := 'Y';
4588: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
4589: --||' must be > 0 '||l_str_common );
4590: END IF;
4591: --
4592: END IF;
4596: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
4597: --
4598: IF l_data_part2.l_tot_wg_app_mg = 0 THEN
4599: l_errflag := 'Y';
4600: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4601: --||' must be > 0 '||l_str_common );
4602: END IF;
4603: --
4604: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4602: END IF;
4603: --
4604: IF l_data_part3.l_contracted_hrs_paid_app_mg = 0 THEN
4605: l_errflag := 'Y';
4606: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4607: --||' must be > 0 '||l_str_common );
4608: END IF;
4609: --
4610: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4608: END IF;
4609: --
4610: IF l_data_part4.l_all_paid_leave_app_mg = 0 THEN
4611: l_errflag := 'Y';
4612: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4613: --||' must be > 0 '||l_str_common );
4614: END IF;
4615: END IF;
4616: -------------
4621: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
4622: --
4623: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4624: l_errflag := 'Y';
4625: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4626: --||' must be > 0 '||l_str_common);
4627: END IF;
4628: --
4629: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4627: END IF;
4628: --
4629: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4630: l_errflag := 'Y';
4631: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4632: --||' must be > 0 '||l_str_common );
4633: END IF;
4634: --
4635: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4633: END IF;
4634: --
4635: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4636: l_errflag := 'Y';
4637: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4638: --||' must be > 0 '||l_str_common);
4639: END IF;
4640: --
4641: END IF;
4644: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
4645: --
4646: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4647: l_errflag := 'Y';
4648: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4649: --||' must be > 0 '||l_str_common );
4650: END IF;
4651: --
4652: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4650: END IF;
4651: --
4652: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4653: l_errflag := 'Y';
4654: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| 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 paid contracted hours for '|| l_employee_categories;
4662: --
4663: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4664: l_errflag := 'Y';
4665: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4666: --||' must be > 0 '||l_str_common );
4667: END IF;
4668: --
4669: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4667: END IF;
4668: --
4669: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4670: l_errflag := 'Y';
4671: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4672: --||' must be > 0 '||l_str_common );
4673: END IF;
4674: END IF;
4675:
4678: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
4679: --
4680: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4681: l_errflag := 'Y';
4682: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4683: --||' must be > 0 '||l_str_common );
4684: END IF;
4685: --
4686: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4684: END IF;
4685: --
4686: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4687: l_errflag := 'Y';
4688: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4689: --||' must be > 0 '||l_str_common );
4690: END IF;
4691: --
4692: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4690: END IF;
4691: --
4692: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4693: l_errflag := 'Y';
4694: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4695: --||' must be > 0 '||l_str_common );
4696: END IF;
4697: --
4698: END IF;
4702: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
4703: --
4704: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4705: l_errflag := 'Y';
4706: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4707: --||' must be > 0 '||l_str_common );
4708: END IF;
4709: --
4710: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4708: END IF;
4709: --
4710: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4711: l_errflag := 'Y';
4712: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
4713: --||' must be > 0 '||l_str_common );
4714: END IF;
4715: --
4716: END IF;
4720: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
4721: --
4722: IF l_data_part2.l_tot_wg_app_cl = 0 THEN
4723: l_errflag := 'Y';
4724: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4725: --||' must be > 0 '||l_str_common );
4726: END IF;
4727: --
4728: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4726: END IF;
4727: --
4728: IF l_data_part3.l_contracted_hrs_paid_app_cl = 0 THEN
4729: l_errflag := 'Y';
4730: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4731: --||' must be > 0 '||l_str_common );
4732: END IF;
4733: --
4734: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4732: END IF;
4733: --
4734: IF l_data_part4.l_all_paid_leave_app_cl = 0 THEN
4735: l_errflag := 'Y';
4736: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4737: --||' must be > 0 '||l_str_common );
4738: END IF;
4739: END IF;
4740: -------------
4744: l_str_common := 'An entry exists for the average number of '||l_employee_categories;
4745: --
4746: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
4747: l_errflag := 'Y';
4748: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4749: --||' must be > 0 '||l_str_common);
4750: END IF;
4751: --
4752: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4750: END IF;
4751: --
4752: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4753: l_errflag := 'Y';
4754: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4755: --||' must be > 0 '||l_str_common );
4756: END IF;
4757: --
4758: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4756: END IF;
4757: --
4758: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4759: l_errflag := 'Y';
4760: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4761: --||' must be > 0 '||l_str_common);
4762: END IF;
4763: --
4764: END IF;
4767: l_str_common := 'An entry exists for total wages and salaries for '|| l_employee_categories;
4768: --
4769: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4770: l_errflag := 'Y';
4771: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4772: --||' must be > 0 '||l_str_common );
4773: END IF;
4774: --
4775: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4773: END IF;
4774: --
4775: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4776: l_errflag := 'Y';
4777: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4778: --||' must be > 0 '||l_str_common);
4779: END IF;
4780: --
4781: END IF;
4784: l_str_common := 'An entry exists for paid contracted hours for '|| l_employee_categories;
4785: --
4786: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
4787: l_errflag := 'Y';
4788: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4789: --||' must be > 0 '||l_str_common );
4790: END IF;
4791: --
4792: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4790: END IF;
4791: --
4792: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4793: l_errflag := 'Y';
4794: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4795: --||' must be > 0 '||l_str_common );
4796: END IF;
4797: END IF;
4798:
4801: l_str_common := 'An entry exists for overtime hours for '|| l_employee_categories ;
4802: --
4803: IF l_data_part2.l_tot_wg_app_ot = 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_ot = 0 THEN
4807: END IF;
4808: --
4809: IF l_data_part3.l_contracted_hrs_paid_app_ot = 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_ot = 0 THEN
4813: END IF;
4814: --
4815: IF l_data_part4.l_all_paid_leave_app_ot = 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;
4825: l_str_common := 'An entry exists for All paid leave for '|| l_employee_categories;
4826: --
4827: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
4828: l_errflag := 'Y';
4829: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4830: --||' must be > 0 '||l_str_common );
4831: END IF;
4832: --
4833: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4831: END IF;
4832: --
4833: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4834: l_errflag := 'Y';
4835: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contract hours '|| l_employee_categories|| l_is_gt_0 );
4836: --||' must be > 0 '||l_str_common );
4837: END IF;
4838: --
4839: END IF;
4843: l_str_common := 'An entry exists for total social security contributions for '|| l_employee_categories;
4844: --
4845: IF l_data_part2.l_tot_wg_app_ot = 0 THEN
4846: l_errflag := 'Y';
4847: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Total wages and salaries '|| l_employee_categories|| l_is_gt_0 );
4848: --||' must be > 0 '||l_str_common );
4849: END IF;
4850: --
4851: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4849: END IF;
4850: --
4851: IF l_data_part3.l_contracted_hrs_paid_app_ot = 0 THEN
4852: l_errflag := 'Y';
4853: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Paid contracted hours '|| l_employee_categories|| l_is_gt_0 );
4854: --||' must be > 0 '||l_str_common );
4855: END IF;
4856: --
4857: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4855: END IF;
4856: --
4857: IF l_data_part4.l_all_paid_leave_app_ot = 0 THEN
4858: l_errflag := 'Y';
4859: Fnd_file.put_line(FND_FILE.LOG,'Ensure that All paid leave '|| l_employee_categories|| l_is_gt_0 );
4860: --||' must be > 0 '||l_str_common );
4861: END IF;
4862: END IF;
4863:
4871: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
4872: ||' managers, professionals and associate professional employees is less than total paid'
4873: ||' contracted hours for all full time managers, professional and associate professional employees.';
4874: l_errflag := 'Y';
4875: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4876: END IF;
4877:
4878: IF (l_data_part4.l_ann_leave_ft_cl + l_data_part4.l_mat_leave_ft_cl +
4879: l_data_part4.l_sck_leave_ft_cl + l_data_part4.l_other_leave_ft_cl) >
4882: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
4883: ||' clerical, sales and service workers is less than or equal to total paid contracted hours for'
4884: ||' all full time clerical, sales and service workers.';
4885: l_errflag := 'Y';
4886: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4887: END IF;
4888:
4889: IF (l_data_part4.l_ann_leave_ft_ot + l_data_part4.l_mat_leave_ft_ot +
4890: l_data_part4.l_sck_leave_ft_ot + l_data_part4.l_other_leave_ft_ot ) >
4893: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all full time'
4894: ||' production, transport, craft, tradespersons and other manual workers is less than or equal to'
4895: ||' the total of paid contracted hours for all full time production, transport, craft, tradespersons and other manual workers.';
4896: l_errflag := 'Y';
4897: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4898: END IF;
4899:
4900: IF (l_data_part4.l_ann_leave_pt_mg + l_data_part4.l_mat_leave_pt_mg +
4901: l_data_part4.l_sck_leave_pt_mg + l_data_part4.l_other_leave_pt_mg) >
4904: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time managers,'
4905: ||' professionals and associate professional employees is less than or equal to total paid contracted hours for'
4906: ||' all part time managers, professional and associate professional employees.';
4907: l_errflag := 'Y';
4908: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4909:
4910: END IF;
4911:
4912: IF (l_data_part4.l_ann_leave_pt_cl + l_data_part4.l_mat_leave_pt_cl +
4916: l_str_common := 'The sum of annual leave, maternity leave, sick leave and other leave for all part time clerical,'
4917: ||' sales and service workers must be less than or equal to total paid contracted hours for all part time clerical,'
4918: ||' sales and service workers.';
4919: l_errflag := 'Y';
4920: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4921: END IF;
4922:
4923: IF ( l_data_part4.l_ann_leave_pt_ot + l_data_part4.l_mat_leave_pt_ot +
4924: l_data_part4.l_sck_leave_pt_ot + l_data_part4.l_other_leave_pt_ot) >
4927: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time production, '
4928: ||' transport, craft, tradespersons and other manual workers is less than or equal to the total of paid contracted '
4929: ||' hours for all part time production, transport, craft, tradespersons and other manual workers.';
4930: l_errflag := 'Y';
4931: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4932: END IF;
4933:
4934: IF ( l_data_part4.l_ann_leave_pt_ot + l_data_part4.l_mat_leave_pt_ot +
4935: l_data_part4.l_sck_leave_pt_ot + l_data_part4.l_other_leave_pt_ot) >
4937: l_errflag := 'Y';
4938: l_str_common := 'Ensure that the sum of annual leave, maternity leave, sick leave and other leave for all part time production,'
4939: ||' transport, craft, tradespersons and other manual workers is less than or equal to the total of paid contracted '
4940: ||' hours for all part time production, transport, craft, tradespersons and other manual workers.';
4941: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4942: END IF;
4943:
4944: IF l_data_part4.l_all_paid_leave_app_mg > l_data_part3.l_contracted_hrs_paid_app_mg THEN
4945: l_errflag := 'Y';
4945: l_errflag := 'Y';
4946: l_str_common := 'Ensure that all paid leave for apprentice/trainee managers, professionals and associate professional employees '
4947: ||'is less than or equal to total paid contracted hours for all apprentice/trainee managers, professionals and '
4948: ||' associate professionals.';
4949: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4950: END IF;
4951:
4952: IF l_data_part4.l_all_paid_leave_app_cl > l_data_part3.l_contracted_hrs_paid_app_cl THEN
4953: l_errflag := 'Y';
4952: IF l_data_part4.l_all_paid_leave_app_cl > l_data_part3.l_contracted_hrs_paid_app_cl THEN
4953: l_errflag := 'Y';
4954: l_str_common := 'Ensure that all paid leave for apprentice/trainee clerical, sales and service workers is less than'
4955: ||' or equal to total paid contracted hours for all apprentice/trainee clerical, sales and service workers.';
4956: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4957: END IF;
4958:
4959: IF l_data_part4.l_all_paid_leave_app_ot > l_data_part3.l_contracted_hrs_paid_app_ot THEN
4960: l_errflag := 'Y';
4960: l_errflag := 'Y';
4961: l_str_common := 'Ensure that all paid leave for apprentice/trainee production, transport, craft, tradespersons and other '
4962: ||' manual workers is less than or equal to total paid contracted hours for all apprentice/trainee '
4963: ||' production, transport, craft, tradespersons and other manual workers.';
4964: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
4965: END IF;
4966:
4967: --6922250
4968: /*
5227: l_str_common := 'The report completed with validation warning(s). Do not submit the generated XML file '
5228: ||'as it may not be in the correct format. You can, however, modify and use the template output.';
5229:
5230: IF l_errflag = 'Y' THEN
5231: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5232: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5233: 'EHECS Report completed with validation warning(s).');
5234: END IF;
5235: