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 973: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');

969:
970: begin
971: retcode := 0;
972: -- hr_utility.trace_on(null,'ZATYEVL');
973: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
974: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
976:
977: /*Loop through all Assignments for given payroll_action_id*/

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

970: begin
971: retcode := 0;
972: -- hr_utility.trace_on(null,'ZATYEVL');
973: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
974: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
976:
977: /*Loop through all Assignments for given payroll_action_id*/
978: FOR asgn IN asgn_for_payroll_action_cur

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

971: retcode := 0;
972: -- hr_utility.trace_on(null,'ZATYEVL');
973: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
974: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
976:
977: /*Loop through all Assignments for given payroll_action_id*/
978: FOR asgn IN asgn_for_payroll_action_cur
979: LOOP

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

981: l_count1:=0;
982: l_65flag:=0;
983: l_3902:=0;
984: /* Fetch Employee_number */
985: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
986: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
987: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
988: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
989: LOOP

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

982: l_65flag:=0;
983: l_3902:=0;
984: /* Fetch Employee_number */
985: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
986: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
987: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
988: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
989: LOOP
990: l_empno := emp_num.empno ;

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

983: l_3902:=0;
984: /* Fetch Employee_number */
985: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Action Id : ' || asgn.assignment_action_id);
986: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
987: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
988: FOR emp_num IN emp_number_cur(asgn.assignment_action_id)
989: LOOP
990: l_empno := emp_num.empno ;
991: l_assgno:= emp_num.assgno;

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

989: LOOP
990: l_empno := emp_num.empno ;
991: l_assgno:= emp_num.assgno;
992: l_65date:=emp_num.dateb;
993: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
994: END LOOP;
995:
996: --Added for TYE09
997: IF l_65date <= p_tax_yr_end_date then

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

998: l_65flag:=1;
999: END if;
1000: -- Rule 1) If an employee has paid any Tax during the current tax year,
1001: -- they must have a value in the SITE and/or PAYE balance (SITE_ASG_TAX_YTD or PAYE_ASG_TAX_YTD)
1002: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');
1003: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
1004: into l_tax_ytd
1005: from ff_archive_items arc,
1006: ff_database_items dbi

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

1026: and arc.context1 = asgn.assignment_action_id;
1027:
1028: IF l_site = 0 AND l_paye = 0 THEN
1029: l_count:=1;
1030: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');

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

1027:
1028: IF l_site = 0 AND l_paye = 0 THEN
1029: l_count:=1;
1030: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);

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

1028: IF l_site = 0 AND l_paye = 0 THEN
1029: l_count:=1;
1030: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');

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

1029: l_count:=1;
1030: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;

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

1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1041: END IF ;

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

1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1041: END IF ;
1042: END IF ;

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

1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1041: END IF ;
1042: END IF ;
1043:

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

1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1041: END IF ;
1042: END IF ;
1043:
1044: -- Rule 2) Check for Income Balances which may not contain negative amounts

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

1041: END IF ;
1042: END IF ;
1043:
1044: -- Rule 2) Check for Income Balances which may not contain negative amounts
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 2) Check for Income Balances which may not contain negative amounts');
1046: FOR neg_amt_check IN negative_amt_check_cur(asgn.assignment_action_id)
1047: LOOP
1048: if l_count <>1 then
1049: l_count:=1;

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

1046: FOR neg_amt_check IN negative_amt_check_cur(asgn.assignment_action_id)
1047: LOOP
1048: if l_count <>1 then
1049: l_count:=1;
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;

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

1047: LOOP
1048: if l_count <>1 then
1049: l_count:=1;
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

1048: if l_count <>1 then
1049: l_count:=1;
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);

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

1049: l_count:=1;
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);

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

1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);
1058: l_msgtext := fnd_message.get('Y');
1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1060: END LOOP ;
1061:
1062: -- Rule 3) Check Lumpsum balances which may not contain negative amounts
1063: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 3) Check Lumpsum balances which may not contain negative amounts');

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

1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1060: END LOOP ;
1061:
1062: -- Rule 3) Check Lumpsum balances which may not contain negative amounts
1063: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 3) Check Lumpsum balances which may not contain negative amounts');
1064: FOR lmpsum_bal IN fetch_lmpsm_bal_cur(asgn.assignment_action_id)
1065: LOOP
1066: if l_count <>1 then
1067: l_count:=1;

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

1064: FOR lmpsum_bal IN fetch_lmpsm_bal_cur(asgn.assignment_action_id)
1065: LOOP
1066: if l_count <>1 then
1067: l_count:=1;
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1069: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;

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

1065: LOOP
1066: if l_count <>1 then
1067: l_count:=1;
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1069: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);

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

1066: if l_count <>1 then
1067: l_count:=1;
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1069: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

1067: l_count:=1;
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1069: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);

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

1069: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');

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

1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');
1078: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1079: END LOOP ;
1080: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number
1081:
1082: FOR rec_lmpsm_crt_bal IN get_lmpsm_crt_bal(asgn.assignment_action_id)

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

1082: FOR rec_lmpsm_crt_bal IN get_lmpsm_crt_bal(asgn.assignment_action_id)
1083: loop
1084: if l_count <>1 then
1085: l_count:=1;
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1087: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;

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

1083: loop
1084: if l_count <>1 then
1085: l_count:=1;
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1087: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);

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

1084: if l_count <>1 then
1085: l_count:=1;
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1087: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

1085: l_count:=1;
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1087: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);

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

1087: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');

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

1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');
1096: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1097:
1098:
1099: END loop;
1100: -- End check for Lump Sum Balances with Directive Number Other than the Defoult directive number

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

1100: -- End check for Lump Sum Balances with Directive Number Other than the Defoult directive number
1101: -- Rule 4) Check for Deduction Balances
1102: -- a) may not contain negative amounts
1103: -- b) Clearance number must be entered
1104: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 4) Check for Deduction Balances ') ;
1105: l_missing_clrno_flag := 'N' ;
1106: FOR ded_bal IN fetch_deduction_bal_cur(asgn.assignment_action_id)
1107: LOOP
1108: IF ded_bal.value <0 THEN

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

1107: LOOP
1108: IF ded_bal.value <0 THEN
1109: if l_count <>1 then
1110: l_count:=1;
1111: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;

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

1108: IF ded_bal.value <0 THEN
1109: if l_count <>1 then
1110: l_count:=1;
1111: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

1109: if l_count <>1 then
1110: l_count:=1;
1111: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);

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

1110: l_count:=1;
1111: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);

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

1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);
1119: l_msgtext := fnd_message.get('Y');
1120: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1121: END IF ;
1122: IF ded_bal.clearance_num = g_default_clrno THEN
1123: l_missing_clrno_flag := 'Y' ;
1124: END IF ;

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

1127: -- If clearance number is g_default_clrno,
1128: -- find out the element(s) whose run_result_values contain defaults (99999999999) for 'Clearance' Input value
1129: IF l_missing_clrno_flag = 'Y' THEN
1130: /*Loop through all assignment_action_id for payroll run for given assignment*/
1131: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Clearance Number is default ') ;
1132: FOR paa IN payroll_asgn_ac_id_cur(asgn.assignment_id, p_tax_yr_start_date, p_tax_yr_end_date)
1133: LOOP
1134: /*Loop through all element names for which the employee has missing clearance numbers*/
1135: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'For payroll assignment_action id : '||paa.assignment_action_id) ;

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

1131: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Clearance Number is default ') ;
1132: FOR paa IN payroll_asgn_ac_id_cur(asgn.assignment_id, p_tax_yr_start_date, p_tax_yr_end_date)
1133: LOOP
1134: /*Loop through all element names for which the employee has missing clearance numbers*/
1135: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'For payroll assignment_action id : '||paa.assignment_action_id) ;
1136: FOR elem_names IN elem_names_cur (paa.assignment_action_id)
1137: LOOP
1138: if l_count <>1 then
1139: l_count:=1;

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

1136: FOR elem_names IN elem_names_cur (paa.assignment_action_id)
1137: LOOP
1138: if l_count <>1 then
1139: l_count:=1;
1140: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1141: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;

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

1137: LOOP
1138: if l_count <>1 then
1139: l_count:=1;
1140: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1141: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');

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

1138: if l_count <>1 then
1139: l_count:=1;
1140: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1141: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);

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

1139: l_count:=1;
1140: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1141: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);

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

1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);
1148: l_msgtext := fnd_message.get('Y');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1150: END LOOP ;
1151: END LOOP ;
1152: END IF;
1153:

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

1156: FOR pkg_bal IN fetch_pkg_balances(asgn.assignment_action_id)
1157: LOOP
1158: if l_count <>1 then
1159: l_count:=1;
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1164: end if;

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

1157: LOOP
1158: if l_count <>1 then
1159: l_count:=1;
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1164: end if;
1165:

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

1158: if l_count <>1 then
1159: l_count:=1;
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1164: end if;
1165:
1166: IF l_count1 <>1 then

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

1159: l_count:=1;
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1164: end if;
1165:
1166: IF l_count1 <>1 then
1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');

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

1166: IF l_count1 <>1 then
1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
1168: fnd_message.set_token('EMPno',l_empno);
1169: l_msgtext := fnd_message.get('Y');
1170: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1171: l_count1:=1;
1172: END IF;
1173:
1174: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)

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

1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
1179: l_msgtext := fnd_message.get('Y');
1180: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1181: END LOOP;
1182:
1183: END LOOP;
1184:

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

1183: END LOOP;
1184:
1185: -- Rule 5) Cross validation of Medical Aid Codes
1186: -- initialize table of medical aid codes
1187: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 5) Cross validation of Medical Aid Codes');
1188: med_code_t(3810) := 0 ;
1189: med_code_t(3813) := 0 ;
1190: med_code_t(4005) := 0 ;
1191: med_code_t(4024) := 0 ;

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

1207: -- Code 3810 must be less than 4474
1208: IF med_code_t(3810) >= med_code_t(4474) AND (med_code_t(3810) <>0 OR med_code_t(4474) <>0) THEN
1209: if l_count <>1 then
1210: l_count:=1;
1211: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1215: end if;

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

1208: IF med_code_t(3810) >= med_code_t(4474) AND (med_code_t(3810) <>0 OR med_code_t(4474) <>0) THEN
1209: if l_count <>1 then
1210: l_count:=1;
1211: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1215: end if;
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 must be less than Code 4474.') ;

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

1209: if l_count <>1 then
1210: l_count:=1;
1211: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1215: end if;
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 must be less than Code 4474.') ;
1217: END IF ;

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

1210: l_count:=1;
1211: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1215: end if;
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 must be less than Code 4474.') ;
1217: END IF ;
1218:

Line 1216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 must be less than Code 4474.') ;

1212: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1215: end if;
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 must be less than Code 4474.') ;
1217: END IF ;
1218:
1219:
1220: -- 5a) Code 3813 must be equal to the sum of Codes 4024 and 4485

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

1220: -- 5a) Code 3813 must be equal to the sum of Codes 4024 and 4485
1221: IF med_code_t(3813) <> (med_code_t(4024) + med_code_t(4485)) THEN
1222: if l_count <>1 then
1223: l_count:=1;
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1228: end if;

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

1221: IF med_code_t(3813) <> (med_code_t(4024) + med_code_t(4485)) THEN
1222: if l_count <>1 then
1223: l_count:=1;
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1228: end if;
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;

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

1222: if l_count <>1 then
1223: l_count:=1;
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1228: end if;
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
1230: END IF ;

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

1223: l_count:=1;
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1228: end if;
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
1230: END IF ;
1231: -- 5b) Code 4005 must be greater than zero if there is a value in 3810 or 4025

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

1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1228: end if;
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3813 must be equal to the sum of Codes 4024 and 4485') ;
1230: END IF ;
1231: -- 5b) Code 4005 must be greater than zero if there is a value in 3810 or 4025
1232: IF (med_code_t(3810) <>0) OR (med_code_t(4025) <>0) THEN
1233: IF med_code_t(4005) <=0 THEN

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

1232: IF (med_code_t(3810) <>0) OR (med_code_t(4025) <>0) THEN
1233: IF med_code_t(4005) <=0 THEN
1234: if l_count <>1 then
1235: l_count:=1;
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1240: end if;

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

1233: IF med_code_t(4005) <=0 THEN
1234: if l_count <>1 then
1235: l_count:=1;
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1240: end if;
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;

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

1234: if l_count <>1 then
1235: l_count:=1;
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1240: end if;
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
1242: END IF;

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

1235: l_count:=1;
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1240: end if;
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
1242: END IF;
1243: END IF ;

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

1237: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1240: end if;
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or 4025 has a value') ;
1242: END IF;
1243: END IF ;
1244: -- 5d) Code 4025 may not be greater than 4005
1245: --Modified for TYE09 so that 4025 may not be greater than 4005 except when employee >=65 yr

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

1245: --Modified for TYE09 so that 4025 may not be greater than 4005 except when employee >=65 yr
1246: IF med_code_t(4025) > med_code_t(4005) AND l_65flag=0 THEN
1247: if l_count <>1 then
1248: l_count:=1;
1249: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1253: end if;

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

1246: IF med_code_t(4025) > med_code_t(4005) AND l_65flag=0 THEN
1247: if l_count <>1 then
1248: l_count:=1;
1249: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1253: end if;
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4005 except when the employee is 65 years or older.') ;

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

1247: if l_count <>1 then
1248: l_count:=1;
1249: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1253: end if;
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4005 except when the employee is 65 years or older.') ;
1255: END IF ;

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

1248: l_count:=1;
1249: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1253: end if;
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4005 except when the employee is 65 years or older.') ;
1255: END IF ;
1256:

Line 1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4005 except when the employee is 65 years or older.') ;

1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1253: end if;
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4005 except when the employee is 65 years or older.') ;
1255: END IF ;
1256:
1257: --Added for TYE09
1258: --Code 4025 may not be greater than 4486 except when employee >=65 yr

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

1258: --Code 4025 may not be greater than 4486 except when employee >=65 yr
1259: IF med_code_t(4025) > med_code_t(4486) AND l_65flag=0 THEN
1260: if l_count <>1 then
1261: l_count:=1;
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1266: end if;

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

1259: IF med_code_t(4025) > med_code_t(4486) AND l_65flag=0 THEN
1260: if l_count <>1 then
1261: l_count:=1;
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1266: end if;
1267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4486 except when the employee is 65 years or older.') ;

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

1260: if l_count <>1 then
1261: l_count:=1;
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1266: end if;
1267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4486 except when the employee is 65 years or older.') ;
1268: END IF ;

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

1261: l_count:=1;
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1266: end if;
1267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4486 except when the employee is 65 years or older.') ;
1268: END IF ;
1269:

Line 1267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4486 except when the employee is 65 years or older.') ;

1263: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1266: end if;
1267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4025 must not be greater than Code 4486 except when the employee is 65 years or older.') ;
1268: END IF ;
1269:
1270:
1271: --Added for TYE09

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

1272: IF med_code_t(3810) <>0 THEN
1273: IF med_code_t(4474) = 0 THEN
1274: if l_count <>1 then
1275: l_count:=1;
1276: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1280: end if;

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

1273: IF med_code_t(4474) = 0 THEN
1274: if l_count <>1 then
1275: l_count:=1;
1276: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1280: end if;
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 has a value.') ;

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

1274: if l_count <>1 then
1275: l_count:=1;
1276: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1280: end if;
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 has a value.') ;
1282: END IF ;

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

1275: l_count:=1;
1276: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1280: end if;
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 has a value.') ;
1282: END IF ;
1283: END IF ;

Line 1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 has a value.') ;

1277: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1280: end if;
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 has a value.') ;
1282: END IF ;
1283: END IF ;
1284:
1285:

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

1288: IF med_code_t(4493) <> 0 THEN
1289: IF med_code_t(4474) <>0 OR med_code_t(3810) <>0 THEN
1290: if l_count <>1 then
1291: l_count:=1;
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1296: end if;

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

1289: IF med_code_t(4474) <>0 OR med_code_t(3810) <>0 THEN
1290: if l_count <>1 then
1291: l_count:=1;
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1296: end if;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 or Code 3810 not allowed if Code 4493 is specified.') ;

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

1290: if l_count <>1 then
1291: l_count:=1;
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1296: end if;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 or Code 3810 not allowed if Code 4493 is specified.') ;
1298: END IF ;

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

1291: l_count:=1;
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1296: end if;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 or Code 3810 not allowed if Code 4493 is specified.') ;
1298: END IF ;
1299: END IF ;

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 or Code 3810 not allowed if Code 4493 is specified.') ;

1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1296: end if;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 or Code 3810 not allowed if Code 4493 is specified.') ;
1298: END IF ;
1299: END IF ;
1300:
1301: -- 5c) Code 4486 must be greater than zero if there is a value in 4025

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

1302: IF med_code_t(4025) <>0 THEN
1303: IF med_code_t(4486) <= 0 THEN
1304: if l_count <>1 then
1305: l_count:=1;
1306: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1310: end if;

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

1303: IF med_code_t(4486) <= 0 THEN
1304: if l_count <>1 then
1305: l_count:=1;
1306: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1310: end if;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;

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

1304: if l_count <>1 then
1305: l_count:=1;
1306: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1310: end if;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1312: END IF ;

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

1305: l_count:=1;
1306: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1310: end if;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1312: END IF ;
1313: END IF ;

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

1307: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1310: end if;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4486 must be greater than zero if Code 4025 has a value') ;
1312: END IF ;
1313: END IF ;
1314:
1315:

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

1319: loop
1320: IF (rec_lmpsm_bal.code = 3920 and length(trunc(pay_za_eoy_val.decimal_character_conversion(rec_lmpsm_bal.value))) > 11) THEN
1321: if l_count <>1 then
1322: l_count:=1;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1324: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1327: end if;

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

1320: IF (rec_lmpsm_bal.code = 3920 and length(trunc(pay_za_eoy_val.decimal_character_conversion(rec_lmpsm_bal.value))) > 11) THEN
1321: if l_count <>1 then
1322: l_count:=1;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1324: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1327: end if;
1328: if rec_lmpsm_bal.Tax_Directive_Number <> g_default_dirno then

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

1321: if l_count <>1 then
1322: l_count:=1;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1324: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1327: end if;
1328: if rec_lmpsm_bal.Tax_Directive_Number <> g_default_dirno then
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_bal.Tax_Directive_Number);

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

1322: l_count:=1;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1324: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1327: end if;
1328: if rec_lmpsm_bal.Tax_Directive_Number <> g_default_dirno then
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_bal.Tax_Directive_Number);
1330: else

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

1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1327: end if;
1328: if rec_lmpsm_bal.Tax_Directive_Number <> g_default_dirno then
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_bal.Tax_Directive_Number);
1330: else
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1332: end if;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3920 must not exceed 11 digits.') ;

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

1327: end if;
1328: if rec_lmpsm_bal.Tax_Directive_Number <> g_default_dirno then
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_bal.Tax_Directive_Number);
1330: else
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1332: end if;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3920 must not exceed 11 digits.') ;
1334: END IF ;
1335:

Line 1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3920 must not exceed 11 digits.') ;

1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_bal.Tax_Directive_Number);
1330: else
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1332: end if;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3920 must not exceed 11 digits.') ;
1334: END IF ;
1335:
1336: /*Check for l_3902 is placed for if the message is printed once, say for code 3902,
1337: must not display the message again if code 3904 is present */

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

1340: and to_number(to_char(p_tax_yr_end_date,'YYYY')) > 2009 THEN
1341: l_3902 :=1;
1342: if l_count <>1 then
1343: l_count:=1;
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1348: end if;

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

1341: l_3902 :=1;
1342: if l_count <>1 then
1343: l_count:=1;
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1348: end if;
1349: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3902 and 3904 are obsolete from 01-Mar-2009.') ;

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

1342: if l_count <>1 then
1343: l_count:=1;
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1348: end if;
1349: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3902 and 3904 are obsolete from 01-Mar-2009.') ;
1350: --Codes 3902 and 3902 must not be used after tax year 2009

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

1343: l_count:=1;
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1348: end if;
1349: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3902 and 3904 are obsolete from 01-Mar-2009.') ;
1350: --Codes 3902 and 3902 must not be used after tax year 2009
1351: end if;

Line 1349: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3902 and 3904 are obsolete from 01-Mar-2009.') ;

1345: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1348: end if;
1349: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3902 and 3904 are obsolete from 01-Mar-2009.') ;
1350: --Codes 3902 and 3902 must not be used after tax year 2009
1351: end if;
1352: end if;
1353: END loop;

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

1355: --Added for TYS2010
1356: IF (length(trunc(pay_za_eoy_val.decimal_character_conversion(med_code_t(4030)))) > 11) THEN
1357: if l_count <>1 then
1358: l_count:=1;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1363: end if;

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

1356: IF (length(trunc(pay_za_eoy_val.decimal_character_conversion(med_code_t(4030)))) > 11) THEN
1357: if l_count <>1 then
1358: l_count:=1;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1363: end if;
1364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4030 must not exceed 11 digits.') ;

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

1357: if l_count <>1 then
1358: l_count:=1;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1363: end if;
1364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4030 must not exceed 11 digits.') ;
1365: END IF ;

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

1358: l_count:=1;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1363: end if;
1364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4030 must not exceed 11 digits.') ;
1365: END IF ;
1366:

Line 1364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4030 must not exceed 11 digits.') ;

1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1363: end if;
1364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4030 must not exceed 11 digits.') ;
1365: END IF ;
1366:
1367:
1368:

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

1370: -- Retirement Fund Lumpsum (3915) or retiremnt_fund_lmpsum(3920) itself is not present
1371: /* retiremnt_fund_lmpsum(3915) := 0 ;
1372: retiremnt_fund_lmpsum(4115) := 0 ;
1373: retiremnt_fund_lmpsum(3920) := 0 ; */
1374: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 6) Cross Validation of codes 3915 and 4115 ') ;
1375: FOR chk_rtrmnt_fnd IN chk_rtrmnt_fnd_cur(asgn.assignment_action_id)
1376: LOOP
1377: retiremnt_fund_lmpsum(chk_rtrmnt_fnd.code||chk_rtrmnt_fnd.Tax_Directive_Number) := chk_rtrmnt_fnd.value ;
1378: end loop;

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

1394: null;
1395: else
1396: if l_count <>1 then
1397: l_count:=1;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1399: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;

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

1395: else
1396: if l_count <>1 then
1397: l_count:=1;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1399: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);

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

1396: if l_count <>1 then
1397: l_count:=1;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1399: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3915 or 3920 are not present.');

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

1397: l_count:=1;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1399: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3915 or 3920 are not present.');
1405: end if;

Line 1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);

1399: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3915 or 3920 are not present.');
1405: end if;
1406: END IF ;
1407: a:=retiremnt_fund_lmpsum.next(a);

Line 1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3915 or 3920 are not present.');

1400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1402: end if;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || l_tax_dir_num);
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3915 or 3920 are not present.');
1405: end if;
1406: END IF ;
1407: a:=retiremnt_fund_lmpsum.next(a);
1408: end loop;

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

1410:
1411:
1412:
1413: END LOOP ; -- End of assignment Loop
1414: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
1415: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1416: -- hr_utility.trace_off;
1417: EXCEPTION
1418: WHEN OTHERS then

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

1411:
1412:
1413: END LOOP ; -- End of assignment Loop
1414: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
1415: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1416: -- hr_utility.trace_off;
1417: EXCEPTION
1418: WHEN OTHERS then
1419: errbuf := substr(SQLERRM,1,255);

Line 1766: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));

1762: p_clob := l_clob;
1763: --
1764: EXCEPTION
1765: WHEN OTHERS THEN
1766: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
1767: hr_utility.set_location(sqlerrm(sqlcode),110);
1768: --
1769: END write_to_clob;
1770:

Line 3871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data has been validated and appears correct.');

3867: then
3868: --No errors encountered for Non Test Run Annual report
3869: if P_TEST_RUN='N' then
3870: if P_MONTHLY_RUN='N' then
3871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data has been validated and appears correct.');
3872: else
3873: FND_FILE.PUT_LINE(FND_FILE.LOG,'No errors identified when validating tax year end data.');
3874: end if;
3875: end if;

Line 3873: FND_FILE.PUT_LINE(FND_FILE.LOG,'No errors identified when validating tax year end data.');

3869: if P_TEST_RUN='N' then
3870: if P_MONTHLY_RUN='N' then
3871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data has been validated and appears correct.');
3872: else
3873: FND_FILE.PUT_LINE(FND_FILE.LOG,'No errors identified when validating tax year end data.');
3874: end if;
3875: end if;
3876:
3877: if P_MONTHLY_RUN='N' then

Line 3907: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data errors exist. Refer to Tax Year End Data Validation Report output and correct the data.');

3903: else
3904: if P_TEST_RUN ='N' then
3905: --errors found and archiver was not fired
3906: if P_MONTHLY_RUN='N' then
3907: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data errors exist. Refer to Tax Year End Data Validation Report output and correct the data.');
3908: else
3909: FND_FILE.PUT_LINE(FND_FILE.LOG,'Errors identified when validating tax year end data. Refer to the Tax Year End Data Validation Report output for further details.');
3910: end if;
3911: end if;

Line 3909: FND_FILE.PUT_LINE(FND_FILE.LOG,'Errors identified when validating tax year end data. Refer to the Tax Year End Data Validation Report output for further details.');

3905: --errors found and archiver was not fired
3906: if P_MONTHLY_RUN='N' then
3907: FND_FILE.PUT_LINE(FND_FILE.LOG,'Tax Year End data errors exist. Refer to Tax Year End Data Validation Report output and correct the data.');
3908: else
3909: FND_FILE.PUT_LINE(FND_FILE.LOG,'Errors identified when validating tax year end data. Refer to the Tax Year End Data Validation Report output for further details.');
3910: end if;
3911: end if;
3912: end if;
3913:

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

4408:
4409: begin
4410: retcode := 0;
4411: -- hr_utility.trace_on(null,'ZATYEVL');
4412: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
4413: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
4415:
4416: --For ITREG no validations required as codes are not archived.

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

4409: begin
4410: retcode := 0;
4411: -- hr_utility.trace_on(null,'ZATYEVL');
4412: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
4413: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
4415:
4416: --For ITREG no validations required as codes are not archived.
4417: select legislative_parameters

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

4410: retcode := 0;
4411: -- hr_utility.trace_on(null,'ZATYEVL');
4412: FND_FILE.PUT_LINE(FND_FILE.LOG,'In validate_tye_data');
4413: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_payroll_action_id :' || p_payroll_action_id);
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside validate_tye_data');
4415:
4416: --For ITREG no validations required as codes are not archived.
4417: select legislative_parameters
4418: into l_leg_param

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

4461: /* The check should be for TYE or if employee is terminated
4462: For normal employee in Mid TYE this check should not be performed*/
4463: if p_period_recon = '02' and rec_info.tax <>0 and (rec_info.site=0 and rec_info.paye=0) then
4464: l_count:=1;
4465: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');

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

4462: For normal employee in Mid TYE this check should not be performed*/
4463: if p_period_recon = '02' and rec_info.tax <>0 and (rec_info.site=0 and rec_info.paye=0) then
4464: l_count:=1;
4465: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);

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

4463: if p_period_recon = '02' and rec_info.tax <>0 and (rec_info.site=0 and rec_info.paye=0) then
4464: l_count:=1;
4465: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');

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

4464: l_count:=1;
4465: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;

Line 4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;

4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;
4475: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4476: end if;

Line 4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;

4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;
4475: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4476: end if;
4477:

Line 4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;

4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;
4475: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4476: end if;
4477:
4478:

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

4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;
4475: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4476: end if;
4477:
4478:
4479: --Validate negative income in the main certificate

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

4481: for rec_neg_income in csr_neg_income(l_ass_act_id, l_main_cert_num)
4482: loop
4483: if l_count <>1 then
4484: l_count:=1;
4485: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4486: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;

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

4482: loop
4483: if l_count <>1 then
4484: l_count:=1;
4485: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4486: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

4483: if l_count <>1 then
4484: l_count:=1;
4485: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4486: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);

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

4484: l_count:=1;
4485: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4486: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);

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

4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);
4493: l_msgtext := fnd_message.get('Y');
4494: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4495: end loop;
4496:
4497: --Validate negative lump sums in the main certificate
4498: hr_utility.set_location('Validating negative income for lump sum',20);

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

4499: for rec_neg_lmpsm in csr_neg_lmpsm(l_ass_act_id, l_main_cert_num)
4500: loop
4501: if l_count <>1 then
4502: l_count:=1;
4503: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4507: end if;

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

4500: loop
4501: if l_count <>1 then
4502: l_count:=1;
4503: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4507: end if;
4508:

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

4501: if l_count <>1 then
4502: l_count:=1;
4503: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4507: end if;
4508:
4509: -- To Be Advised directive has negative value

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

4502: l_count:=1;
4503: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4507: end if;
4508:
4509: -- To Be Advised directive has negative value
4510: if rec_neg_lmpsm.to_be_adv_val < 0 then

Line 4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);

4507: end if;
4508:
4509: -- To Be Advised directive has negative value
4510: if rec_neg_lmpsm.to_be_adv_val < 0 then
4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);
4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');

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

4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');
4516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4517: end if;
4518:
4519: --Directive 1 has negative value
4520: if rec_neg_lmpsm.value1 < 0 then

Line 4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);

4517: end if;
4518:
4519: --Directive 1 has negative value
4520: if rec_neg_lmpsm.value1 < 0 then
4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');

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

4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4527: end if;
4528:
4529: --Directive 2 has negative value
4530: if rec_neg_lmpsm.value2 < 0 then

Line 4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);

4527: end if;
4528:
4529: --Directive 2 has negative value
4530: if rec_neg_lmpsm.value2 < 0 then
4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);
4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');

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

4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');
4536: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4537: end if;
4538:
4539: --Directive 3 has negative value
4540: if rec_neg_lmpsm.value3 < 0 then

Line 4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);

4537: end if;
4538:
4539: --Directive 3 has negative value
4540: if rec_neg_lmpsm.value3 < 0 then
4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);
4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');

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

4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');
4546: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4547: end if;
4548: end loop;
4549:
4550: --Validate negative lump sums in the lump sum certificate

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

4552: for rec_neg_lmpsm in csr_neg_lmpsm2(l_ass_act_id, l_main_cert_num)
4553: loop
4554: if l_count <>1 then
4555: l_count:=1;
4556: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4560: end if;

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

4553: loop
4554: if l_count <>1 then
4555: l_count:=1;
4556: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4560: end if;
4561:

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

4554: if l_count <>1 then
4555: l_count:=1;
4556: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4560: end if;
4561:
4562: -- To Be Advised directive has negative value

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

4555: l_count:=1;
4556: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4560: end if;
4561:
4562: -- To Be Advised directive has negative value
4563: if rec_neg_lmpsm.value < 0 then

Line 4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);

4560: end if;
4561:
4562: -- To Be Advised directive has negative value
4563: if rec_neg_lmpsm.value < 0 then
4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');

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

4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');
4569: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4570: end if;
4571: end loop;
4572:
4573: for rec_neg_tax in chk_neg_tax(l_ass_act_id)

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

4573: for rec_neg_tax in chk_neg_tax(l_ass_act_id)
4574: loop
4575: if l_count <>1 then
4576: l_count:=1;
4577: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4578: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4581: end if;

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

4574: loop
4575: if l_count <>1 then
4576: l_count:=1;
4577: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4578: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4581: end if;
4582: if rec_neg_tax.temp_cert_num = l_main_cert_num then

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

4575: if l_count <>1 then
4576: l_count:=1;
4577: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4578: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4581: end if;
4582: if rec_neg_tax.temp_cert_num = l_main_cert_num then
4583: l_directive1:='Certificate: Main Certificate';

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

4576: l_count:=1;
4577: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4578: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4581: end if;
4582: if rec_neg_tax.temp_cert_num = l_main_cert_num then
4583: l_directive1:='Certificate: Main Certificate';
4584: else

Line 4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4586: end if;
4587:
4588: --Site has negative value
4589: if rec_neg_tax.site < 0 then
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');

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

4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');
4595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4596: end if;
4597:
4598: --Paye has negative value
4599: if rec_neg_tax.paye < 0 then

Line 4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4596: end if;
4597:
4598: --Paye has negative value
4599: if rec_neg_tax.paye < 0 then
4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');

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

4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');
4605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4606: end if;
4607:
4608: --Tax on Retirement Fund has negative value
4609: if rec_neg_tax.tax_ret < 0 then

Line 4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4606: end if;
4607:
4608: --Tax on Retirement Fund has negative value
4609: if rec_neg_tax.tax_ret < 0 then
4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');

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

4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');
4615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4616: end if;
4617:
4618: --UIF has negative value
4619: if rec_neg_tax.uif < 0 then

Line 4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4616: end if;
4617:
4618: --UIF has negative value
4619: if rec_neg_tax.uif < 0 then
4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');

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

4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');
4625: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4626: end if;
4627:
4628: --SDL has negative value
4629: if rec_neg_tax.sdl < 0 then

Line 4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4626: end if;
4627:
4628: --SDL has negative value
4629: if rec_neg_tax.sdl < 0 then
4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');

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

4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');
4635: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4636: end if;
4637:
4638: --total has negative value
4639: if rec_neg_tax.total < 0 then

Line 4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);

4636: end if;
4637:
4638: --total has negative value
4639: if rec_neg_tax.total < 0 then
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');

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

4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');
4645: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4646: end if;
4647:
4648: end loop;
4649:

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

4652: for rec_neg_deduct in csr_neg_deduct(l_ass_act_id, l_main_cert_num)
4653: loop
4654: if l_count <>1 then
4655: l_count:=1;
4656: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4657: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;

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

4653: loop
4654: if l_count <>1 then
4655: l_count:=1;
4656: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4657: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

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

4654: if l_count <>1 then
4655: l_count:=1;
4656: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4657: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);

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

4655: l_count:=1;
4656: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4657: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);

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

4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);
4664: l_msgtext := fnd_message.get('Y');
4665: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4666: end loop;
4667:
4668: -- Added for bug#10287216
4669:

Line 4679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income is negative for ');

4675: hr_utility.set_location('Validating Non-Taxable Income',20);
4676:
4677: if rec_fetch_rfi_nrfi.Non_Taxable_Income < 0 then
4678:
4679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income is negative for ');
4680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income : ' || rec_fetch_rfi_nrfi.Non_Taxable_Income);
4683:

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

4676:
4677: if rec_fetch_rfi_nrfi.Non_Taxable_Income < 0 then
4678:
4679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income is negative for ');
4680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income : ' || rec_fetch_rfi_nrfi.Non_Taxable_Income);
4683:
4684: end if;

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

4677: if rec_fetch_rfi_nrfi.Non_Taxable_Income < 0 then
4678:
4679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income is negative for ');
4680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income : ' || rec_fetch_rfi_nrfi.Non_Taxable_Income);
4683:
4684: end if;
4685:

Line 4682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income : ' || rec_fetch_rfi_nrfi.Non_Taxable_Income);

4678:
4679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income is negative for ');
4680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Non-Taxable Income : ' || rec_fetch_rfi_nrfi.Non_Taxable_Income);
4683:
4684: end if;
4685:
4686: hr_utility.set_location('Validated Non-Taxable Income',20);

Line 4695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income is negative for ');

4691:
4692:
4693: if rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income < 0 then
4694:
4695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income is negative for ');
4696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income);
4699:

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

4692:
4693: if rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income < 0 then
4694:
4695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income is negative for ');
4696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income);
4699:
4700: end if;

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

4693: if rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income < 0 then
4694:
4695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income is negative for ');
4696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income);
4699:
4700: end if;
4701:

Line 4698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income);

4694:
4695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income is negative for ');
4696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Retire_Fund_Income);
4699:
4700: end if;
4701:
4702:

Line 4712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income is negative for :');

4708:
4709:
4710: if rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In < 0 then
4711:
4712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income is negative for :');
4713: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In);
4716:

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

4709:
4710: if rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In < 0 then
4711:
4712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income is negative for :');
4713: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In);
4716:
4717: end if ;

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

4710: if rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In < 0 then
4711:
4712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income is negative for :');
4713: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In);
4716:
4717: end if ;
4718:

Line 4715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In);

4711:
4712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income is negative for :');
4713: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gross Non-Retirement Funding Income : ' || rec_fetch_rfi_nrfi.Gross_Non_Retire_Fund_In);
4716:
4717: end if ;
4718:
4719: hr_utility.set_location('Validated Gross Non-Retirement Funding Income ',20);

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

4727: for rec_pkg_balances in fetch_pkg_balances(l_ass_act_id, l_main_cert_num)
4728: loop
4729: if l_count <>1 then
4730: l_count:=1;
4731: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4732: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;

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

4728: loop
4729: if l_count <>1 then
4730: l_count:=1;
4731: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4732: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;
4736:

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

4729: if l_count <>1 then
4730: l_count:=1;
4731: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4732: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;
4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');

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

4730: l_count:=1;
4731: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4732: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;
4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
4738: fnd_message.set_token('EMPno',l_empno);

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

4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
4738: fnd_message.set_token('EMPno',l_empno);
4739: l_msgtext := fnd_message.get('Y');
4740: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4741:
4742: select max(paa.action_sequence)
4743: into l_run_action_seq
4744: from pay_assignment_actions paa,

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

4764: LOOP
4765: fnd_message.set_name('PAY', 'PY_ZA_NEW_ELE_FEED_PKG_BAL');
4766: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
4767: l_msgtext := fnd_message.get('Y');
4768: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4769: END LOOP;
4770: end loop; --end loop for fetch_pkg_balances
4771:
4772: -- Code 4115 must be present only if code 3901, 3915, 3920, 3921 are present. (added 3901 for bug 11899934)

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

4777: fetch chk_ret_fund_ls into rec_ret_fund_ls;
4778: if chk_ret_fund_ls%notfound then
4779: if l_count <>1 then
4780: l_count:=1;
4781: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4782: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4783: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4785: end if;

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

4778: if chk_ret_fund_ls%notfound then
4779: if l_count <>1 then
4780: l_count:=1;
4781: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4782: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4783: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4785: end if;
4786: --If main certificate has code 4115 but 3901,3915,3920,3921 not present (added 3901 for bug 11899934)

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

4779: if l_count <>1 then
4780: l_count:=1;
4781: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4782: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4783: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4785: end if;
4786: --If main certificate has code 4115 but 3901,3915,3920,3921 not present (added 3901 for bug 11899934)
4787: if rec_tax_ret_fund_ls.temp_cert_num = l_main_cert_num then

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

4780: l_count:=1;
4781: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4782: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4783: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4785: end if;
4786: --If main certificate has code 4115 but 3901,3915,3920,3921 not present (added 3901 for bug 11899934)
4787: if rec_tax_ret_fund_ls.temp_cert_num = l_main_cert_num then
4788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certificate ' || 'Main Certificate');

Line 4788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certificate ' || 'Main Certificate');

4784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4785: end if;
4786: --If main certificate has code 4115 but 3901,3915,3920,3921 not present (added 3901 for bug 11899934)
4787: if rec_tax_ret_fund_ls.temp_cert_num = l_main_cert_num then
4788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certificate ' || 'Main Certificate');
4789: else
4790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_tax_ret_fund_ls.direct1);
4791: end if;
4792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3901, 3915, 3920, and 3921 are not present.'); -- (added 3901 for bug 11899934)

Line 4790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_tax_ret_fund_ls.direct1);

4786: --If main certificate has code 4115 but 3901,3915,3920,3921 not present (added 3901 for bug 11899934)
4787: if rec_tax_ret_fund_ls.temp_cert_num = l_main_cert_num then
4788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certificate ' || 'Main Certificate');
4789: else
4790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_tax_ret_fund_ls.direct1);
4791: end if;
4792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3901, 3915, 3920, and 3921 are not present.'); -- (added 3901 for bug 11899934)
4793: end if;
4794: close chk_ret_fund_ls;

Line 4792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3901, 3915, 3920, and 3921 are not present.'); -- (added 3901 for bug 11899934)

4788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certificate ' || 'Main Certificate');
4789: else
4790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_tax_ret_fund_ls.direct1);
4791: end if;
4792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4115 must not be present if Codes 3901, 3915, 3920, and 3921 are not present.'); -- (added 3901 for bug 11899934)
4793: end if;
4794: close chk_ret_fund_ls;
4795: end loop;*/
4796: open csr_4115_is_mandatory(l_ass_act_id);

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

4797: fetch csr_4115_is_mandatory into l_rec_count;
4798: if csr_4115_is_mandatory%found then
4799: if l_count <>1 then
4800: l_count:=1;
4801: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4802: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4803: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4804: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4805: end if;

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

4798: if csr_4115_is_mandatory%found then
4799: if l_count <>1 then
4800: l_count:=1;
4801: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4802: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4803: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4804: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4805: end if;
4806: l_msgtext :='Code 4115 is mandatory if there is a value for 3901, 3915, 3920, 3921 and 3922 AND 4150 does not have a value';

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

4799: if l_count <>1 then
4800: l_count:=1;
4801: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4802: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4803: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4804: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4805: end if;
4806: l_msgtext :='Code 4115 is mandatory if there is a value for 3901, 3915, 3920, 3921 and 3922 AND 4150 does not have a value';
4807: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

4800: l_count:=1;
4801: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4802: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4803: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4804: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4805: end if;
4806: l_msgtext :='Code 4115 is mandatory if there is a value for 3901, 3915, 3920, 3921 and 3922 AND 4150 does not have a value';
4807: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4808: end if;

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

4803: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4804: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4805: end if;
4806: l_msgtext :='Code 4115 is mandatory if there is a value for 3901, 3915, 3920, 3921 and 3922 AND 4150 does not have a value';
4807: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4808: end if;
4809: close csr_4115_is_mandatory;
4810: hr_utility.set_location('End Tax on Retirement Fund check',35);
4811:

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

4853: if (((nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) >= cross_val_t(4474)) AND
4854: ((nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) <> 0 OR cross_val_t(4474)<>0)) then
4855: if l_count <>1 then
4856: l_count:=1;
4857: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4858: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4861: end if;

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

4854: ((nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) <> 0 OR cross_val_t(4474)<>0)) then
4855: if l_count <>1 then
4856: l_count:=1;
4857: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4858: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4861: end if;
4862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be less than Code 4474.');

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

4855: if l_count <>1 then
4856: l_count:=1;
4857: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4858: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4861: end if;
4862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be less than Code 4474.');
4863: end if;

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

4856: l_count:=1;
4857: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4858: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4861: end if;
4862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be less than Code 4474.');
4863: end if;
4864: else

Line 4862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be less than Code 4474.');

4858: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4861: end if;
4862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be less than Code 4474.');
4863: end if;
4864: else
4865: if (nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) <> nvl(cross_val_t(4474),0) then
4866: if l_count <>1 then

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

4864: else
4865: if (nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) <> nvl(cross_val_t(4474),0) then
4866: if l_count <>1 then
4867: l_count:=1;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4872: end if;

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

4865: if (nvl(cross_val_t(3810),0) + nvl(cross_val_t(3860),0)) <> nvl(cross_val_t(4474),0) then
4866: if l_count <>1 then
4867: l_count:=1;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4872: end if;
4873: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be equal to the Code 4474.');

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

4866: if l_count <>1 then
4867: l_count:=1;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4872: end if;
4873: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be equal to the Code 4474.');
4874: end if;

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

4867: l_count:=1;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4872: end if;
4873: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be equal to the Code 4474.');
4874: end if;
4875: end if;

Line 4873: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be equal to the Code 4474.');

4869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4872: end if;
4873: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 3810 / 3860 must be equal to the Code 4474.');
4874: end if;
4875: end if;
4876:
4877: hr_utility.set_location('check whether 3813 greater than 4024',45);

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

4878: --Code 3813/3863 must be greater than or equal to the value of code 4024
4879: if ((case when cross_val_t(3813)=0 then cross_val_t(3863) else cross_val_t(3813) end) < cross_val_t(4024)) then
4880: if l_count <>1 then
4881: l_count:=1;
4882: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4883: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4886: end if;

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

4879: if ((case when cross_val_t(3813)=0 then cross_val_t(3863) else cross_val_t(3813) end) < cross_val_t(4024)) then
4880: if l_count <>1 then
4881: l_count:=1;
4882: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4883: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4886: end if;
4887: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3813 and 3863 must not be less than Code 4024.');

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

4880: if l_count <>1 then
4881: l_count:=1;
4882: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4883: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4886: end if;
4887: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3813 and 3863 must not be less than Code 4024.');
4888: end if;

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

4881: l_count:=1;
4882: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4883: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4886: end if;
4887: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3813 and 3863 must not be less than Code 4024.');
4888: end if;
4889:

Line 4887: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3813 and 3863 must not be less than Code 4024.');

4883: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4886: end if;
4887: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3813 and 3863 must not be less than Code 4024.');
4888: end if;
4889:
4890: --Code 3810/3860 and 4474 is not allowed if code 4493 is specified
4891: hr_utility.set_location('check whether 3810 OR 4474 present if 4493 specified',45);

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

4892: if cross_val_t(4493) <> 0 then
4893: if cross_val_t(3810) <>0 OR cross_val_t(3860) <>0 OR cross_val_t(4474) <>0 then
4894: if l_count <>1 then
4895: l_count:=1;
4896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4897: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4900: end if;

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

4893: if cross_val_t(3810) <>0 OR cross_val_t(3860) <>0 OR cross_val_t(4474) <>0 then
4894: if l_count <>1 then
4895: l_count:=1;
4896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4897: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4900: end if;
4901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3810, 3860, and 4474 not allowed if Code 4493 is specified.');

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

4894: if l_count <>1 then
4895: l_count:=1;
4896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4897: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4900: end if;
4901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3810, 3860, and 4474 not allowed if Code 4493 is specified.');
4902: end if;

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

4895: l_count:=1;
4896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4897: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4900: end if;
4901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3810, 3860, and 4474 not allowed if Code 4493 is specified.');
4902: end if;
4903: end if;

Line 4901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3810, 3860, and 4474 not allowed if Code 4493 is specified.');

4897: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4900: end if;
4901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Codes 3810, 3860, and 4474 not allowed if Code 4493 is specified.');
4902: end if;
4903: end if;
4904:
4905: /* --Already handled in message Code 3813/3863 must be greater than or equal to the value of code 4024

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

4907: hr_utility.set_location('Check whether 4024 greater than 3813/3863',45);
4908: if cross_val_t(4024) > cross_val_t(3813) OR cross_val_t(4024) > cross_val_t(3863) then
4909: if l_count <>1 then
4910: l_count:=1;
4911: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4912: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4913: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4915: end if;

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

4908: if cross_val_t(4024) > cross_val_t(3813) OR cross_val_t(4024) > cross_val_t(3863) then
4909: if l_count <>1 then
4910: l_count:=1;
4911: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4912: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4913: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4915: end if;
4916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4024 must be less than Codes 3813 and 3863.');

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

4909: if l_count <>1 then
4910: l_count:=1;
4911: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4912: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4913: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4915: end if;
4916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4024 must be less than Codes 3813 and 3863.');
4917: end if;

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

4910: l_count:=1;
4911: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4912: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4913: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4915: end if;
4916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4024 must be less than Codes 3813 and 3863.');
4917: end if;
4918: */

Line 4916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4024 must be less than Codes 3813 and 3863.');

4912: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4913: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4915: end if;
4916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4024 must be less than Codes 3813 and 3863.');
4917: end if;
4918: */
4919:
4920: --Code 4474 is mandatory if an amount is specified for code 3810/3860

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

4921: hr_utility.set_location('4474 mandatory for 3810',45);
4922: if (cross_val_t(3810) <> 0 OR cross_val_t(3860)<>0) AND cross_val_t(4474)=0 then
4923: if l_count <>1 then
4924: l_count:=1;
4925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4926: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4929: end if;

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

4922: if (cross_val_t(3810) <> 0 OR cross_val_t(3860)<>0) AND cross_val_t(4474)=0 then
4923: if l_count <>1 then
4924: l_count:=1;
4925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4926: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4929: end if;
4930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 or Code 3860 has a value.');

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

4923: if l_count <>1 then
4924: l_count:=1;
4925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4926: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4929: end if;
4930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 or Code 3860 has a value.');
4931: end if;

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

4924: l_count:=1;
4925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4926: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4929: end if;
4930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 or Code 3860 has a value.');
4931: end if;
4932:

Line 4930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 or Code 3860 has a value.');

4926: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4929: end if;
4930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4474 must be greater than zero if Code 3810 or Code 3860 has a value.');
4931: end if;
4932:
4933: --Code 4005 is mandatory if an amount is specified for code 3810/3860
4934: hr_utility.set_location('4005 mandatory for 3810',45);

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

4934: hr_utility.set_location('4005 mandatory for 3810',45);
4935: if (cross_val_t(3810) <> 0 OR cross_val_t(3860)<>0) AND cross_val_t(4005)=0 then
4936: if l_count <>1 then
4937: l_count:=1;
4938: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4939: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4942: end if;

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

4935: if (cross_val_t(3810) <> 0 OR cross_val_t(3860)<>0) AND cross_val_t(4005)=0 then
4936: if l_count <>1 then
4937: l_count:=1;
4938: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4939: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4942: end if;
4943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or Code 3860 has a value.');

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

4936: if l_count <>1 then
4937: l_count:=1;
4938: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4939: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4942: end if;
4943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or Code 3860 has a value.');
4944: end if;

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

4937: l_count:=1;
4938: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4939: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4942: end if;
4943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or Code 3860 has a value.');
4944: end if;
4945:

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

4939: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4942: end if;
4943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Code 4005 must be greater than zero if Code 3810 or Code 3860 has a value.');
4944: end if;
4945:
4946:
4947: -- Check that number of deduction codes must not exceed 7.

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

4952:
4953: if l_num_ded_codes > 7 then
4954: if l_count <>1 then
4955: l_count:=1;
4956: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4957: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;

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

4953: if l_num_ded_codes > 7 then
4954: if l_count <>1 then
4955: l_count:=1;
4956: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4957: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');

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

4954: if l_count <>1 then
4955: l_count:=1;
4956: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4957: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);

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

4955: l_count:=1;
4956: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4957: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');

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

4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');
4966: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4967: end if;
4968:
4969: -- Check that number of income codes must not exceed 13.
4970: hr_utility.set_location('Count income codes',50);

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

4980:
4981: if l_num_inc_codes > 13 then
4982: if l_count <>1 then
4983: l_count:=1;
4984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4985: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;

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

4981: if l_num_inc_codes > 13 then
4982: if l_count <>1 then
4983: l_count:=1;
4984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4985: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');

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

4982: if l_count <>1 then
4983: l_count:=1;
4984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4985: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);

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

4983: l_count:=1;
4984: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4985: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');

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

4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');
4994: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4995: end if;
4996:
4997: --If the employer is not register for PAYE (Paye Reference number doesnot start with 7)
4998: --but any employee has code 4101,4102,4115 then it is invalid

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

5012:
5013: if l_tax_code_ind is not null then
5014: if l_count <>1 then
5015: l_count:=1;
5016: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5017: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;

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

5013: if l_tax_code_ind is not null then
5014: if l_count <>1 then
5015: l_count:=1;
5016: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5017: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');

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

5014: if l_count <>1 then
5015: l_count:=1;
5016: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5017: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);

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

5015: l_count:=1;
5016: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5017: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);
5023: l_msgtext := fnd_message.get('Y');

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

5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);
5023: l_msgtext := fnd_message.get('Y');
5024: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5025: end if;
5026: end if;
5027:
5028: -- Aug 2012 Changes

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

5030: fetch csr_4116_nature_of_person into l_rec_count;
5031: if csr_4116_nature_of_person%found then
5032: if l_count <>1 then
5033: l_count:=1;
5034: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5035: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5038: end if;

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

5031: if csr_4116_nature_of_person%found then
5032: if l_count <>1 then
5033: l_count:=1;
5034: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5035: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5038: end if;
5039: l_msgtext :='Code 4116 may only have a value if Nature of Person is A, B, C or N';

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

5032: if l_count <>1 then
5033: l_count:=1;
5034: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5035: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5038: end if;
5039: l_msgtext :='Code 4116 may only have a value if Nature of Person is A, B, C or N';
5040: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

5033: l_count:=1;
5034: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5035: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5038: end if;
5039: l_msgtext :='Code 4116 may only have a value if Nature of Person is A, B, C or N';
5040: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5041: end if;

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

5036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5038: end if;
5039: l_msgtext :='Code 4116 may only have a value if Nature of Person is A, B, C or N';
5040: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5041: end if;
5042: close csr_4116_nature_of_person;
5043:
5044: open csr_4116_4005_age(l_ass_act_id);

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

5046: if csr_4116_4005_age%found then
5047: if (l_age = 'B' and l_4116_val is null) THEN
5048: if l_count <>1 then
5049: l_count:=1;
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5054: end if;

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

5047: if (l_age = 'B' and l_4116_val is null) THEN
5048: if l_count <>1 then
5049: l_count:=1;
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5054: end if;
5055: l_msgtext :='Code 4116 must have a value if any value is specified for Medical Scheme Contributions (4005) and age is below 65';

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

5048: if l_count <>1 then
5049: l_count:=1;
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5054: end if;
5055: l_msgtext :='Code 4116 must have a value if any value is specified for Medical Scheme Contributions (4005) and age is below 65';
5056: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

5049: l_count:=1;
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5054: end if;
5055: l_msgtext :='Code 4116 must have a value if any value is specified for Medical Scheme Contributions (4005) and age is below 65';
5056: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5057: elsif ( l_age = 'A' and l_4116_val is not null ) THEN

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

5052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5054: end if;
5055: l_msgtext :='Code 4116 must have a value if any value is specified for Medical Scheme Contributions (4005) and age is below 65';
5056: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5057: elsif ( l_age = 'A' and l_4116_val is not null ) THEN
5058: if l_count <>1 then
5059: l_count:=1;
5060: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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

5056: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5057: elsif ( l_age = 'A' and l_4116_val is not null ) THEN
5058: if l_count <>1 then
5059: l_count:=1;
5060: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5061: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5064: end if;

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

5057: elsif ( l_age = 'A' and l_4116_val is not null ) THEN
5058: if l_count <>1 then
5059: l_count:=1;
5060: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5061: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5064: end if;
5065: l_msgtext :='Code 4116 must not have a value if any value is specified for Medical Scheme Contributions (4005) and age is 65 or above';

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

5058: if l_count <>1 then
5059: l_count:=1;
5060: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5061: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5064: end if;
5065: l_msgtext :='Code 4116 must not have a value if any value is specified for Medical Scheme Contributions (4005) and age is 65 or above';
5066: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

5059: l_count:=1;
5060: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5061: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5064: end if;
5065: l_msgtext :='Code 4116 must not have a value if any value is specified for Medical Scheme Contributions (4005) and age is 65 or above';
5066: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5067: end if;

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

5062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5064: end if;
5065: l_msgtext :='Code 4116 must not have a value if any value is specified for Medical Scheme Contributions (4005) and age is 65 or above';
5066: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5067: end if;
5068:
5069: end if;
5070: close csr_4116_4005_age;

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

5071:
5072: open csr_3922_rep_err(l_ass_act_id);
5073: fetch csr_3922_rep_err into l_3922_rep_err;
5074: if l_3922_rep_err = 'Y' then
5075: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5076: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5077: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';

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

5072: open csr_3922_rep_err(l_ass_act_id);
5073: fetch csr_3922_rep_err into l_3922_rep_err;
5074: if l_3922_rep_err = 'Y' then
5075: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5076: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5077: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

5073: fetch csr_3922_rep_err into l_3922_rep_err;
5074: if l_3922_rep_err = 'Y' then
5075: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5076: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5077: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then

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

5074: if l_3922_rep_err = 'Y' then
5075: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5076: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5077: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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

5076: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5077: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);

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

5078: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5086: l_msgtext :='Value for code 3922 is less than or equal to R300 000 therefore amount reflected under code 3922 should be reported under code 3696';

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

5079: l_msgtext :='Value for code 3922 is greater than R300 000 therefore amount reflected under code 3922 should not be reported under code 3696';
5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5086: l_msgtext :='Value for code 3922 is less than or equal to R300 000 therefore amount reflected under code 3922 should be reported under code 3696';
5087: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

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

5080: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5086: l_msgtext :='Value for code 3922 is less than or equal to R300 000 therefore amount reflected under code 3922 should be reported under code 3696';
5087: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5088: end if;

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

5081: elsif l_3922_rep_err = 'N' then
5082: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5086: l_msgtext :='Value for code 3922 is less than or equal to R300 000 therefore amount reflected under code 3922 should be reported under code 3696';
5087: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5088: end if;
5089:

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

5083: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5086: l_msgtext :='Value for code 3922 is less than or equal to R300 000 therefore amount reflected under code 3922 should be reported under code 3696';
5087: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5088: end if;
5089:
5090: close csr_3922_rep_err;
5091:

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

5090: close csr_3922_rep_err;
5091:
5092: END LOOP; --end of assignment loop
5093:
5094: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
5095: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5096: -- hr_utility.trace_off;
5097: EXCEPTION
5098: WHEN OTHERS then

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

5091:
5092: END LOOP; --end of assignment loop
5093:
5094: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of log file');
5095: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5096: -- hr_utility.trace_off;
5097: EXCEPTION
5098: WHEN OTHERS then
5099: errbuf := substr(SQLERRM,1,255);