eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_EOY_VAL dependencies on FND_FILE

Line 747: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');

743:
744: begin
745: retcode := 0;
746: -- hr_utility.trace_on(null,'ZATYEVL');
747: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
748: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
750:
751: /*Loop through all Assignments for given payroll_action_id*/

Line 748: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);

744: begin
745: retcode := 0;
746: -- hr_utility.trace_on(null,'ZATYEVL');
747: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
748: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
750:
751: /*Loop through all Assignments for given payroll_action_id*/
752: FOR asgn IN asgn_for_payroll_action_cur

Line 749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');

745: retcode := 0;
746: -- hr_utility.trace_on(null,'ZATYEVL');
747: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
748: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
750:
751: /*Loop through all Assignments for given payroll_action_id*/
752: FOR asgn IN asgn_for_payroll_action_cur
753: LOOP

Line 757: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);

753: LOOP
754: l_count:=0;
755: l_count1:=0;
756: /* Fetch Employee_number */
757: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
758: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
760: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
761: LOOP

Line 758: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

754: l_count:=0;
755: l_count1:=0;
756: /* Fetch Employee_number */
757: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
758: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
760: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
761: LOOP
762: l_empno := emp_num.empno ;

Line 759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

755: l_count1:=0;
756: /* Fetch Employee_number */
757: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
758: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
760: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
761: LOOP
762: l_empno := emp_num.empno ;
763: l_assgno:= emp_num.assgno;

Line 764: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

760: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
761: LOOP
762: l_empno := emp_num.empno ;
763: l_assgno:= emp_num.assgno;
764: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
765: END LOOP;
766:
767: -- Rule 1) If an employee has paid any Tax during the current tax year,
768: -- they must have a value in the SITE and/or PAYE balance (SITE_ASG_TAX_YTD or PAYE_ASG_TAX_YTD)

Line 769: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');

765: END LOOP;
766:
767: -- Rule 1) If an employee has paid any Tax during the current tax year,
768: -- they must have a value in the SITE and/or PAYE balance (SITE_ASG_TAX_YTD or PAYE_ASG_TAX_YTD)
769: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');
770: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
771: into l_tax_ytd
772: from ff_archive_items arc,
773: ff_database_items dbi

Line 797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

793: and arc.context1 = asgn.assignment_action_id;
794:
795: IF l_site = 0 AND l_paye = 0 THEN
796: l_count:=1;
797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');

Line 798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

794:
795: IF l_site = 0 AND l_paye = 0 THEN
796: l_count:=1;
797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);

Line 799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

795: IF l_site = 0 AND l_paye = 0 THEN
796: l_count:=1;
797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');

Line 800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

796: l_count:=1;
797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;

Line 804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;

800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
808: END IF ;

Line 805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;

801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
808: END IF ;
809: END IF ;

Line 806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;

802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
808: END IF ;
809: END IF ;
810:

Line 807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
808: END IF ;
809: END IF ;
810:
811: -- Rule 2) Check for Income Balances which may not contain negative amounts

Line 812: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 2) Check for Income Balances which may not contain negative amounts');

808: END IF ;
809: END IF ;
810:
811: -- Rule 2) Check for Income Balances which may not contain negative amounts
812: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 2) Check for Income Balances which may not contain negative amounts');
813: FOR neg_amt_check IN negative_amt_check_cur(asgn.assignment_action_id)
814: LOOP
815: if l_count <>1 then
816: l_count:=1;

Line 817: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

813: FOR neg_amt_check IN negative_amt_check_cur(asgn.assignment_action_id)
814: LOOP
815: if l_count <>1 then
816: l_count:=1;
817: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;

Line 818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

814: LOOP
815: if l_count <>1 then
816: l_count:=1;
817: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

Line 819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

815: if l_count <>1 then
816: l_count:=1;
817: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);

Line 820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

816: l_count:=1;
817: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);

Line 826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);
825: l_msgtext := fnd_message.get('Y');
826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
827: END LOOP ;
828:
829: -- Rule 3) Check Lumpsum balances which may not contain negative amounts
830: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 3) Check Lumpsum balances which may not contain negative amounts');

Line 830: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 3) Check Lumpsum balances which may not contain negative amounts');

826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
827: END LOOP ;
828:
829: -- Rule 3) Check Lumpsum balances which may not contain negative amounts
830: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 3) Check Lumpsum balances which may not contain negative amounts');
831: FOR lmpsum_bal IN fetch_lmpsm_bal_cur(asgn.assignment_action_id)
832: LOOP
833: if l_count <>1 then
834: l_count:=1;

Line 835: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

831: FOR lmpsum_bal IN fetch_lmpsm_bal_cur(asgn.assignment_action_id)
832: LOOP
833: if l_count <>1 then
834: l_count:=1;
835: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;

Line 836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

832: LOOP
833: if l_count <>1 then
834: l_count:=1;
835: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);

Line 837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

833: if l_count <>1 then
834: l_count:=1;
835: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

Line 838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

834: l_count:=1;
835: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);

Line 840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);

836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');
845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
846: END LOOP ;
847: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number
848:
849: FOR rec_lmpsm_crt_bal IN get_lmpsm_crt_bal(asgn.assignment_action_id)

Line 853: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

849: FOR rec_lmpsm_crt_bal IN get_lmpsm_crt_bal(asgn.assignment_action_id)
850: loop
851: if l_count <>1 then
852: l_count:=1;
853: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;

Line 854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

850: loop
851: if l_count <>1 then
852: l_count:=1;
853: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);

Line 855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

851: if l_count <>1 then
852: l_count:=1;
853: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

Line 856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

852: l_count:=1;
853: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);

Line 858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);

854: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');

Line 863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');
863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
864:
865:
866: END loop;
867: -- End check for Lump Sum Balances with Directive Number Other than the Defoult directive number

Line 871: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 4) Check for Deduction Balances ') ;

867: -- End check for Lump Sum Balances with Directive Number Other than the Defoult directive number
868: -- Rule 4) Check for Deduction Balances
869: -- a) may not contain negative amounts
870: -- b) Clearance number must be entered
871: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 4) Check for Deduction Balances ') ;
872: l_missing_clrno_flag := 'N' ;
873: FOR ded_bal IN fetch_deduction_bal_cur(asgn.assignment_action_id)
874: LOOP
875: IF ded_bal.value <0 THEN

Line 878: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

874: LOOP
875: IF ded_bal.value <0 THEN
876: if l_count <>1 then
877: l_count:=1;
878: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;

Line 879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

875: IF ded_bal.value <0 THEN
876: if l_count <>1 then
877: l_count:=1;
878: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

Line 880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

876: if l_count <>1 then
877: l_count:=1;
878: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);

Line 881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

877: l_count:=1;
878: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);

Line 887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);
886: l_msgtext := fnd_message.get('Y');
887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
888: END IF ;
889: IF ded_bal.clearance_num = g_default_clrno THEN
890: l_missing_clrno_flag := 'Y' ;
891: END IF ;

Line 898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Clearance Number is default ') ;

894: -- If clearance number is g_default_clrno,
895: -- find out the element(s) whose run_result_values contain defaults (99999999999) for 'Clearance' Input value
896: IF l_missing_clrno_flag = 'Y' THEN
897: /*Loop through all assignment_action_id for payroll run for given assignment*/
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Clearance Number is default ') ;
899: FOR paa IN payroll_asgn_ac_id_cur(asgn.assignment_id, p_tax_yr_start_date, p_tax_yr_end_date)
900: LOOP
901: /*Loop through all element names for which the employee has missing clearance numbers*/
902: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'For payroll assignment_action id : '||paa.assignment_action_id) ;

Line 902: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'For payroll assignment_action id : '||paa.assignment_action_id) ;

898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Clearance Number is default ') ;
899: FOR paa IN payroll_asgn_ac_id_cur(asgn.assignment_id, p_tax_yr_start_date, p_tax_yr_end_date)
900: LOOP
901: /*Loop through all element names for which the employee has missing clearance numbers*/
902: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'For payroll assignment_action id : '||paa.assignment_action_id) ;
903: FOR elem_names IN elem_names_cur (paa.assignment_action_id)
904: LOOP
905: if l_count <>1 then
906: l_count:=1;

Line 907: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

903: FOR elem_names IN elem_names_cur (paa.assignment_action_id)
904: LOOP
905: if l_count <>1 then
906: l_count:=1;
907: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;

Line 908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

904: LOOP
905: if l_count <>1 then
906: l_count:=1;
907: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');

Line 909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

905: if l_count <>1 then
906: l_count:=1;
907: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);

Line 910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

906: l_count:=1;
907: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);

Line 916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);
915: l_msgtext := fnd_message.get('Y');
916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
917: END LOOP ;
918: END LOOP ;
919: END IF;
920:

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

923: FOR pkg_bal IN fetch_pkg_balances(asgn.assignment_action_id)
924: LOOP
925: if l_count <>1 then
926: l_count:=1;
927: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
931: end if;

Line 928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

924: LOOP
925: if l_count <>1 then
926: l_count:=1;
927: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
931: end if;
932:

Line 929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

925: if l_count <>1 then
926: l_count:=1;
927: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
931: end if;
932:
933: IF l_count1 <>1 then

Line 930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

926: l_count:=1;
927: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
931: end if;
932:
933: IF l_count1 <>1 then
934: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');

Line 937: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

933: IF l_count1 <>1 then
934: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
935: fnd_message.set_token('EMPno',l_empno);
936: l_msgtext := fnd_message.get('Y');
937: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
938: l_count1:=1;
939: END IF;
940:
941: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)

Line 947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

943: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
944: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
945: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
946: l_msgtext := fnd_message.get('Y');
947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
948: END LOOP;
949:
950: END LOOP;
951:

Line 954: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 5) Cross validation of Medical Aid Codes');

950: END LOOP;
951:
952: -- Rule 5) Cross validation of Medical Aid Codes
953: -- initialize table of medical aid codes
954: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 5) Cross validation of Medical Aid Codes');
955: med_code_t(3810) := 0 ;
956: med_code_t(3813) := 0 ;
957: med_code_t(4005) := 0 ;
958: med_code_t(4024) := 0 ;

Line 971: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

967: -- 5a) Code 3813 must be equal to the sum of Codes 4024 and 4485
968: IF med_code_t(3813) <> (med_code_t(4024) + med_code_t(4485)) THEN
969: if l_count <>1 then
970: l_count:=1;
971: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
975: end if;

Line 972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

968: IF med_code_t(3813) <> (med_code_t(4024) + med_code_t(4485)) THEN
969: if l_count <>1 then
970: l_count:=1;
971: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
975: end if;
976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;

Line 973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

969: if l_count <>1 then
970: l_count:=1;
971: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
975: end if;
976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
977: END IF ;

Line 974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

970: l_count:=1;
971: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
975: end if;
976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
977: END IF ;
978: -- 5b) Code 4005 must be greater than zero if there is a value in 3810 or 4025

Line 976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;

972: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
975: end if;
976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
977: END IF ;
978: -- 5b) Code 4005 must be greater than zero if there is a value in 3810 or 4025
979: IF (med_code_t(3810) <>0) OR (med_code_t(4025) <>0) THEN
980: IF med_code_t(4005) <=0 THEN

Line 983: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

979: IF (med_code_t(3810) <>0) OR (med_code_t(4025) <>0) THEN
980: IF med_code_t(4005) <=0 THEN
981: if l_count <>1 then
982: l_count:=1;
983: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
987: end if;

Line 984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

980: IF med_code_t(4005) <=0 THEN
981: if l_count <>1 then
982: l_count:=1;
983: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
987: end if;
988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;

Line 985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

981: if l_count <>1 then
982: l_count:=1;
983: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
987: end if;
988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
989: END IF;

Line 986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

982: l_count:=1;
983: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
987: end if;
988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
989: END IF;
990: END IF ;

Line 988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;

984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
987: end if;
988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
989: END IF;
990: END IF ;
991: -- 5c) Code 4486 must be greater than zero if there is a value in 4025
992: IF med_code_t(4025) <>0 THEN

Line 996: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

992: IF med_code_t(4025) <>0 THEN
993: IF med_code_t(4486) <= 0 THEN
994: if l_count <>1 then
995: l_count:=1;
996: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1000: end if;

Line 997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

993: IF med_code_t(4486) <= 0 THEN
994: if l_count <>1 then
995: l_count:=1;
996: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1000: end if;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;

Line 998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

994: if l_count <>1 then
995: l_count:=1;
996: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1000: end if;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1002: END IF ;

Line 999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

995: l_count:=1;
996: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1000: end if;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1002: END IF ;
1003: END IF ;

Line 1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;

997: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
998: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1000: end if;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1002: END IF ;
1003: END IF ;
1004: -- 5d) Code 4025 may not be greater than 4005
1005: IF med_code_t(4025) > med_code_t(4005) THEN

Line 1008: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1004: -- 5d) Code 4025 may not be greater than 4005
1005: IF med_code_t(4025) > med_code_t(4005) THEN
1006: if l_count <>1 then
1007: l_count:=1;
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1012: end if;

Line 1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1005: IF med_code_t(4025) > med_code_t(4005) THEN
1006: if l_count <>1 then
1007: l_count:=1;
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1012: end if;
1013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 may not be greater than Code 4005') ;

Line 1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

1006: if l_count <>1 then
1007: l_count:=1;
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1012: end if;
1013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 may not be greater than Code 4005') ;
1014: END IF ;

Line 1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);

1007: l_count:=1;
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1012: end if;
1013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 may not be greater than Code 4005') ;
1014: END IF ;
1015:

Line 1013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 may not be greater than Code 4005') ;

1009: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1012: end if;
1013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 may not be greater than Code 4005') ;
1014: END IF ;
1015:
1016: -- Retirement Fund Lumpsum PAYE balance (4115) should not be present if
1017: -- Retirement Fund Lumpsum (3915) itself is not present

Line 1020: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 6) Cross Validation of codes 3915 and 4115 ') ;

1016: -- Retirement Fund Lumpsum PAYE balance (4115) should not be present if
1017: -- Retirement Fund Lumpsum (3915) itself is not present
1018: retiremnt_fund_lmpsum(3915) := 0 ;
1019: retiremnt_fund_lmpsum(4115) := 0 ;
1020: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 6) Cross Validation of codes 3915 and 4115 ') ;
1021: FOR chk_rtrmnt_fnd IN chk_rtrmnt_fnd_cur(asgn.assignment_action_id)
1022: LOOP
1023: retiremnt_fund_lmpsum(chk_rtrmnt_fnd.code) := chk_rtrmnt_fnd.value ;
1024: END LOOP;

Line 1027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Code 3915 is not present') ;

1023: retiremnt_fund_lmpsum(chk_rtrmnt_fnd.code) := chk_rtrmnt_fnd.value ;
1024: END LOOP;
1025:
1026: IF retiremnt_fund_lmpsum(4115)<> 0 and retiremnt_fund_lmpsum(3915) = 0 THEN
1027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Code 3915 is not present') ;
1028: END IF ;
1029:
1030: END LOOP ; -- End of assignment Loop
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');

Line 1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');

1027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Code 3915 is not present') ;
1028: END IF ;
1029:
1030: END LOOP ; -- End of assignment Loop
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1033: -- hr_utility.trace_off;
1034: EXCEPTION
1035: WHEN OTHERS then

Line 1032: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1028: END IF ;
1029:
1030: END LOOP ; -- End of assignment Loop
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1033: -- hr_utility.trace_off;
1034: EXCEPTION
1035: WHEN OTHERS then
1036: errbuf := substr(SQLERRM,1,255);