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_IE_NES_REPORT_PKG dependencies on FND_FILE

Line 860: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );

856: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
857:
858: IF l_employer_name IS NULL THEN
859: l_errflag := 'Y';
860: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
861: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
862: END IF;
863: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
864: l_errflag := 'Y';

Line 861: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );

857:
858: IF l_employer_name IS NULL THEN
859: l_errflag := 'Y';
860: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
861: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
862: END IF;
863: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
864: l_errflag := 'Y';
865: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );

Line 865: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );

861: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the employer name. Enter a valid employer name.' );
862: END IF;
863: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
864: l_errflag := 'Y';
865: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
866: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
867: END IF;
868: IF l_cbr_no IS NULL THEN
869: l_errflag := 'Y';

Line 866: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );

862: END IF;
863: IF l_addr1 IS NULL OR l_addr2 IS NULL THEN
864: l_errflag := 'Y';
865: --Fnd_file.put_line(FND_FILE.LOG,'Employer Address line 1/2 is missing. Please enter it first.' );
866: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
867: END IF;
868: IF l_cbr_no IS NULL THEN
869: l_errflag := 'Y';
870: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );

Line 870: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );

866: Fnd_file.put_line(FND_FILE.LOG,'You have not entered a complete address for the employer. Enter a valid address.' );
867: END IF;
868: IF l_cbr_no IS NULL THEN
869: l_errflag := 'Y';
870: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
871: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
872: END IF;
873: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
874: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN

Line 871: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );

867: END IF;
868: IF l_cbr_no IS NULL THEN
869: l_errflag := 'Y';
870: --Fnd_file.put_line(FND_FILE.LOG,'CBR Number is missing. Please enter it first.' );
871: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the CBR Number. Enter a valid CBR Number.' );
872: END IF;
873: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
874: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
875: l_errflag := 'Y';

Line 876: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );

872: END IF;
873: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
874: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
875: l_errflag := 'Y';
876: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
877: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
878: END IF;
879:
880: hr_utility.set_location('l_errflag '||l_errflag, 370);

Line 877: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );

873: IF l_declarant_name IS NULL OR l_declarant_phone IS NULL OR
874: l_declarant_email_add IS NULL OR l_declarant_position IS NULL THEN
875: l_errflag := 'Y';
876: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
877: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
878: END IF;
879:
880: hr_utility.set_location('l_errflag '||l_errflag, 370);
881:

Line 883: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );

879:
880: hr_utility.set_location('l_errflag '||l_errflag, 370);
881:
882: IF l_errflag = 'Y' THEN
883: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
884: Raise l_nes_exception;
885: END IF;
886:
887: hr_utility.set_location('Before entering record for IE_NES_HEADER ', 380);

Line 1107: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );

1103:
1104:
1105:
1106: /*6978389 */
1107: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
1108:
1109:
1110: OPEN csr_get_asg FOR l_select_str; -- ref cursor
1111: LOOP

Line 1820: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Normal hours value is not null at the assignment level of person'||p_person_id );

1816: l_chrs_bal_val:=(nvl(l_valid_asg_rec.normal_hours,0))/12;
1817: END IF;
1818: /* ELSE
1819: l_errflag := 'Y';
1820: Fnd_file.put_line(FND_FILE.LOG,'Ensure that Normal hours value is not null at the assignment level of person'||p_person_id );
1821: Raise l_nes_exception;
1822: END IF;
1823: */
1824: ELSE

Line 2931: Fnd_file.put_line(FND_FILE.LOG,'The Annual Earnings is less than the sum of Irregular Bonuses and Annual Benefit In Kind for Assignment : ' || l_employee_number);

2927:
2928:
2929: IF l_ann_earning < NVL(l_irrb_bal_val,0) + NVL(l_ann_bik,0) THEN
2930: l_errflag := 'Y';
2931: Fnd_file.put_line(FND_FILE.LOG,'The Annual Earnings is less than the sum of Irregular Bonuses and Annual Benefit In Kind for Assignment : ' || l_employee_number);
2932: END IF;
2933:
2934: IF l_gross_earning>0 and NVL(l_chrs_bal_val,0)<=0 THEN
2935: l_errflag := 'Y';

Line 2936: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be greater than Zero for Gross Earnings greater than Zero : ' || l_employee_number);

2932: END IF;
2933:
2934: IF l_gross_earning>0 and NVL(l_chrs_bal_val,0)<=0 THEN
2935: l_errflag := 'Y';
2936: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be greater than Zero for Gross Earnings greater than Zero : ' || l_employee_number);
2937: END IF;
2938:
2939: IF l_gross_earning=0 and NVL(l_chrs_bal_val,0)<>0 THEN
2940: l_errflag := 'Y';

Line 2941: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be Zero for Gross Earnings equal than Zero : ' || l_employee_number);

2937: END IF;
2938:
2939: IF l_gross_earning=0 and NVL(l_chrs_bal_val,0)<>0 THEN
2940: l_errflag := 'Y';
2941: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be Zero for Gross Earnings equal than Zero : ' || l_employee_number);
2942: END IF;
2943:
2944: IF NVL(l_chrs_bal_val,0) < NVL(l_othr_bal_val,0) THEN
2945: l_errflag := 'Y';

Line 2946: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be greater than or equal to Overtime Hours : ' || l_employee_number);

2942: END IF;
2943:
2944: IF NVL(l_chrs_bal_val,0) < NVL(l_othr_bal_val,0) THEN
2945: l_errflag := 'Y';
2946: Fnd_file.put_line(FND_FILE.LOG,'Paid Hours should be greater than or equal to Overtime Hours : ' || l_employee_number);
2947: END IF;
2948:
2949:
2950: IF l_gross_earning< (NVL(l_tot_comm_bal_val,0) + NVL(l_tot_shft_allnce_bal_val,0) + NVL(l_ovrt_bal_val_ptd,0)) THEN /* 9795571 replaced l_ovrt_bal by l_ovrt_bal_val_ptd */

Line 2952: Fnd_file.put_line(FND_FILE.LOG,'Gross Earnings must be greater than the sum of Total Commission, Shift Allowance and Overtime Earnings : ' || l_employee_number);

2948:
2949:
2950: IF l_gross_earning< (NVL(l_tot_comm_bal_val,0) + NVL(l_tot_shft_allnce_bal_val,0) + NVL(l_ovrt_bal_val_ptd,0)) THEN /* 9795571 replaced l_ovrt_bal by l_ovrt_bal_val_ptd */
2951: l_errflag := 'Y';
2952: Fnd_file.put_line(FND_FILE.LOG,'Gross Earnings must be greater than the sum of Total Commission, Shift Allowance and Overtime Earnings : ' || l_employee_number);
2953: END IF;
2954:
2955: -----------------------------------------------------
2956:

Line 2959: Fnd_file.put_line(FND_FILE.LOG,'Overtime Hours should be zero for Overtime Earnings equal to 0 : ' || l_employee_number);

2955: -----------------------------------------------------
2956:
2957: IF NVL(l_ovrt_bal_val_ptd,0)=0 and NVL(l_othr_bal_val,0)<>0 THEN
2958: l_errflag := 'Y';
2959: Fnd_file.put_line(FND_FILE.LOG,'Overtime Hours should be zero for Overtime Earnings equal to 0 : ' || l_employee_number);
2960: END IF;
2961:
2962: IF NVL(l_ovrt_bal_val_ptd,0)>0 and NVL(l_othr_bal_val,0)<=0 THEN
2963: l_errflag := 'Y';

Line 2964: Fnd_file.put_line(FND_FILE.LOG,'Overtime Hours should be greater than zero for Overtime Earnings greater than 0 : ' || l_employee_number);

2960: END IF;
2961:
2962: IF NVL(l_ovrt_bal_val_ptd,0)>0 and NVL(l_othr_bal_val,0)<=0 THEN
2963: l_errflag := 'Y';
2964: Fnd_file.put_line(FND_FILE.LOG,'Overtime Hours should be greater than zero for Overtime Earnings greater than 0 : ' || l_employee_number);
2965: END IF;
2966:
2967: IF NVL(l_ovrt_bal_val_ptd,0)<=0 and NVL(l_othr_bal_val,0)>0 THEN
2968: l_errflag := 'Y';

Line 2969: Fnd_file.put_line(FND_FILE.LOG,'Overtime Earnings should be greater than zero for Overtime Hours greater than 0 : ' || l_employee_number);

2965: END IF;
2966:
2967: IF NVL(l_ovrt_bal_val_ptd,0)<=0 and NVL(l_othr_bal_val,0)>0 THEN
2968: l_errflag := 'Y';
2969: Fnd_file.put_line(FND_FILE.LOG,'Overtime Earnings should be greater than zero for Overtime Hours greater than 0 : ' || l_employee_number);
2970: END IF;
2971:
2972:
2973: hr_utility.set_location(' Before Inserting in to IE_NES_PART1 ', 890);

Line 3011: Fnd_file.put_line(FND_FILE.LOG,l_str_common);

3007: l_str_common := 'The report completed with validation warning(s). Do not submit the generated XML file '
3008: ||'as it may not be in the correct format. You can, however, modify and use the template output.';
3009:
3010: IF l_errflag = 'Y' THEN
3011: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
3012: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
3013: 'NES Report completed with validation warning(s).');
3014: END IF;
3015: