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

Line 150: fnd_file.put_line (fnd_file.LOG

146: INTO lr_parameter_info;
147:
148: CLOSE csr_parameter_info;
149:
150: fnd_file.put_line (fnd_file.LOG
151: , 'lr_parameter_info.STILL_EMPLOYED '
152: || lr_parameter_info.still_employed
153: );
154: --logger ('Entering ', l_proc);

Line 491: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);

487: --START OF PICKING UP DATA
488:
489: l_report_start_date := TO_DATE('01/'||g_report_start_month||'/'||g_report_start_year,'DD/MM/YYYY');
490:
491: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);
492: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));
493: fnd_file.put_line (fnd_file.LOG, 'l_report_start_date'||to_char(l_report_start_date));
494: fnd_file.put_line (fnd_file.LOG, 'g_business_group_id'||to_char(g_business_group_id));
495:

Line 492: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));

488:
489: l_report_start_date := TO_DATE('01/'||g_report_start_month||'/'||g_report_start_year,'DD/MM/YYYY');
490:
491: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);
492: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));
493: fnd_file.put_line (fnd_file.LOG, 'l_report_start_date'||to_char(l_report_start_date));
494: fnd_file.put_line (fnd_file.LOG, 'g_business_group_id'||to_char(g_business_group_id));
495:
496:

Line 493: fnd_file.put_line (fnd_file.LOG, 'l_report_start_date'||to_char(l_report_start_date));

489: l_report_start_date := TO_DATE('01/'||g_report_start_month||'/'||g_report_start_year,'DD/MM/YYYY');
490:
491: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);
492: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));
493: fnd_file.put_line (fnd_file.LOG, 'l_report_start_date'||to_char(l_report_start_date));
494: fnd_file.put_line (fnd_file.LOG, 'g_business_group_id'||to_char(g_business_group_id));
495:
496:
497: OPEN csr_asg_effective_date ( g_assignment_id, g_effective_date , l_report_start_date, g_business_group_id);

Line 494: fnd_file.put_line (fnd_file.LOG, 'g_business_group_id'||to_char(g_business_group_id));

490:
491: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);
492: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));
493: fnd_file.put_line (fnd_file.LOG, 'l_report_start_date'||to_char(l_report_start_date));
494: fnd_file.put_line (fnd_file.LOG, 'g_business_group_id'||to_char(g_business_group_id));
495:
496:
497: OPEN csr_asg_effective_date ( g_assignment_id, g_effective_date , l_report_start_date, g_business_group_id);
498: FETCH csr_asg_effective_date INTO lr_asg_effective_date;

Line 516: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));

512: FROM DUAL;
513:
514: END IF;
515:
516: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));
517:
518: IF lr_asg_effective_date.effective_date IS NOT NULL THEN
519:
520:

Line 716: -- fnd_file.put_line (fnd_file.LOG, 'l_days_worked'||l_days_worked);

712: CLOSE csr_se_wtc_time_worked_info;
713: l_days_worked := lr_se_wtc_time_worked_info.aei_information3;
714: END IF;
715:
716: -- fnd_file.put_line (fnd_file.LOG, 'l_days_worked'||l_days_worked);
717:
718: BEGIN
719: l_addl_time_hours :=0;
720: l_tot_addl_time_hours:=0;

Line 739: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));

735: END LOOP ;
736:
737: EXCEPTION
738: WHEN others THEN
739: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
740: null;
741: END;
742: l_addl_time_hw :=0;
743: l_tot_addl_time_hw :=0;

Line 774: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_relief_duty_hours'||l_tot_relief_duty_hours);

770: l_tot_relief_duty_hours := l_tot_relief_duty_hours + nvl(l_relief_duty_hours,0);
771: END IF;
772: END LOOP ;
773:
774: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_relief_duty_hours'||l_tot_relief_duty_hours);
775:
776: EXCEPTION
777: WHEN others THEN
778: null;

Line 921: -- fnd_file.put_line (fnd_file.LOG, 'l_other_tax_compensation'||l_other_tax_compensation);

917:
918: l_hourly_pay_variable := lr_extra_assignment_info.aei_information9;
919: l_other_tax_compensation := lr_extra_assignment_info.aei_information12;
920:
921: -- fnd_file.put_line (fnd_file.LOG, 'l_other_tax_compensation'||l_other_tax_compensation);
922: --fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
923:
924:
925: IF l_other_tax_compensation ='Y'

Line 922: --fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);

918: l_hourly_pay_variable := lr_extra_assignment_info.aei_information9;
919: l_other_tax_compensation := lr_extra_assignment_info.aei_information12;
920:
921: -- fnd_file.put_line (fnd_file.LOG, 'l_other_tax_compensation'||l_other_tax_compensation);
922: --fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
923:
924:
925: IF l_other_tax_compensation ='Y'
926: THEN

Line 941: --fnd_file.put_line (fnd_file.LOG, 'l_oth_comp' ||l_oth_comp);

937: IF csr_balance%FOUND THEN
938:
939: l_oth_comp :=0;
940: l_oth_comp :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
941: --fnd_file.put_line (fnd_file.LOG, 'l_oth_comp' ||l_oth_comp);
942:
943: IF l_oth_comp > 0 THEN
944:
945: pay_action_information_api.create_action_information

Line 994: fnd_file.put_line (fnd_file.LOG, '$$$ l_reporting_date'||l_reporting_date);

990: END LOOP ;
991:
992: -- Bug# 9222739 fix starts
993:
994: fnd_file.put_line (fnd_file.LOG, '$$$ l_reporting_date'||l_reporting_date);
995: fnd_file.put_line (fnd_file.LOG, '$$$ l_month'||l_month);
996:
997: l_sick_pay_hours := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay Hours','_ASG_LE_MONTH',l_reporting_date);
998: l_sick_pay := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay','_ASG_LE_MONTH',l_reporting_date);

Line 995: fnd_file.put_line (fnd_file.LOG, '$$$ l_month'||l_month);

991:
992: -- Bug# 9222739 fix starts
993:
994: fnd_file.put_line (fnd_file.LOG, '$$$ l_reporting_date'||l_reporting_date);
995: fnd_file.put_line (fnd_file.LOG, '$$$ l_month'||l_month);
996:
997: l_sick_pay_hours := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay Hours','_ASG_LE_MONTH',l_reporting_date);
998: l_sick_pay := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay','_ASG_LE_MONTH',l_reporting_date);
999: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours'||l_sick_pay_hours);

Line 999: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours'||l_sick_pay_hours);

995: fnd_file.put_line (fnd_file.LOG, '$$$ l_month'||l_month);
996:
997: l_sick_pay_hours := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay Hours','_ASG_LE_MONTH',l_reporting_date);
998: l_sick_pay := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay','_ASG_LE_MONTH',l_reporting_date);
999: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours'||l_sick_pay_hours);
1000: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay'||l_sick_pay);
1001:
1002: IF l_sick_pay_hours > 0 THEN
1003: pay_action_information_api.create_action_information

Line 1000: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay'||l_sick_pay);

996:
997: l_sick_pay_hours := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay Hours','_ASG_LE_MONTH',l_reporting_date);
998: l_sick_pay := GET_DEFINED_BALANCE_VALUE(g_assignment_id, 'Total Sick Pay','_ASG_LE_MONTH',l_reporting_date);
999: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours'||l_sick_pay_hours);
1000: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay'||l_sick_pay);
1001:
1002: IF l_sick_pay_hours > 0 THEN
1003: pay_action_information_api.create_action_information
1004: (p_action_information_id => l_action_info_id

Line 1050: fnd_file.put_line (fnd_file.LOG, 'Error in Other Compensation'||substr(sqlerrm,1,30));

1046: -- Bug# 9222739 fix ends
1047:
1048: EXCEPTION
1049: WHEN others THEN
1050: fnd_file.put_line (fnd_file.LOG, 'Error in Other Compensation'||substr(sqlerrm,1,30));
1051: END;
1052:
1053: END IF; --- End of Validation for Other Tax Compensation in Assignment EIT
1054:

Line 1064: --fnd_file.put_line (fnd_file.LOG, 'l_hourly_pay_variable'||l_hourly_pay_variable);

1060: -- Salary Information in Working Time Certificate of Section 12
1061: -- has vaiable Additional and Overtime Pay
1062: -- Assignment EIT of Income Info has Hourly Pay Variable marked as 'YES'
1063:
1064: --fnd_file.put_line (fnd_file.LOG, 'l_hourly_pay_variable'||l_hourly_pay_variable);
1065:
1066: IF l_hourly_pay_variable = 'Y'
1067: THEN
1068:

Line 1083: --fnd_file.put_line (fnd_file.LOG, 'l_overtime_mw' ||l_overtime_mw);

1079:
1080: IF csr_balance%FOUND THEN
1081: l_overtime_mw := 0;
1082: l_overtime_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1083: --fnd_file.put_line (fnd_file.LOG, 'l_overtime_mw' ||l_overtime_mw);
1084: IF l_overtime_mw > 0 THEN
1085:
1086: pay_action_information_api.create_action_information
1087: (p_action_information_id => l_action_info_id

Line 1136: fnd_file.put_line (fnd_file.LOG, 'Error in Overtime'||substr(sqlerrm,1,30));

1132:
1133:
1134: EXCEPTION
1135: WHEN others THEN
1136: fnd_file.put_line (fnd_file.LOG, 'Error in Overtime'||substr(sqlerrm,1,30));
1137: END; -- End of Begin for Overtime Variable Pay
1138:
1139:
1140: ------------------------------------Additional/Supplementary hours - if variable ---

Line 1154: --fnd_file.put_line (fnd_file.LOG, 'check_addtional' ||l_addl_time_mw);

1150:
1151: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1152: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1153: CLOSE csr_bg_Get_Defined_Balance_Id;
1154: --fnd_file.put_line (fnd_file.LOG, 'check_addtional' ||l_addl_time_mw);
1155:
1156: IF csr_balance%FOUND THEN
1157:
1158: l_addl_time_mw :=0;

Line 1160: --fnd_file.put_line (fnd_file.LOG, 'l_addl_time_mw' ||l_addl_time_mw);

1156: IF csr_balance%FOUND THEN
1157:
1158: l_addl_time_mw :=0;
1159: l_addl_time_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1160: --fnd_file.put_line (fnd_file.LOG, 'l_addl_time_mw' ||l_addl_time_mw);
1161: IF l_addl_time_mw > 0 THEN
1162:
1163: pay_action_information_api.create_action_information
1164: (p_action_information_id => l_action_info_id

Line 1213: fnd_file.put_line (fnd_file.LOG, 'Error in Additional'||substr(sqlerrm,1,30));

1209:
1210:
1211: EXCEPTION
1212: WHEN others THEN
1213: fnd_file.put_line (fnd_file.LOG, 'Error in Additional'||substr(sqlerrm,1,30));
1214: END; -- End of Begin for Additional Time monthly Wage
1215:
1216: END IF; --- End of IF condition for hourly pay variable
1217: