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 488: fnd_file.put_line (fnd_file.LOG, 'g_assignment_id'||g_assignment_id);

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

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

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

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

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

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

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

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

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

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

704: CLOSE csr_se_wtc_time_worked_info;
705: l_days_worked := lr_se_wtc_time_worked_info.aei_information3;
706: END IF;
707:
708: -- fnd_file.put_line (fnd_file.LOG, 'l_days_worked'||l_days_worked);
709:
710: BEGIN
711: l_addl_time_hours :=0;
712: l_tot_addl_time_hours:=0;

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

727: END LOOP ;
728:
729: EXCEPTION
730: WHEN others THEN
731: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
732: null;
733: END;
734: l_addl_time_hw :=0;
735: l_tot_addl_time_hw :=0;

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

762: l_tot_relief_duty_hours := l_tot_relief_duty_hours + nvl(l_relief_duty_hours,0);
763: END IF;
764: END LOOP ;
765:
766: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_relief_duty_hours'||l_tot_relief_duty_hours);
767:
768: EXCEPTION
769: WHEN others THEN
770: null;

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

909:
910: l_hourly_pay_variable := lr_extra_assignment_info.aei_information9;
911: l_other_tax_compensation := lr_extra_assignment_info.aei_information12;
912:
913: -- fnd_file.put_line (fnd_file.LOG, 'l_other_tax_compensation'||l_other_tax_compensation);
914: --fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
915:
916:
917: IF l_other_tax_compensation ='Y'

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

910: l_hourly_pay_variable := lr_extra_assignment_info.aei_information9;
911: l_other_tax_compensation := lr_extra_assignment_info.aei_information12;
912:
913: -- fnd_file.put_line (fnd_file.LOG, 'l_other_tax_compensation'||l_other_tax_compensation);
914: --fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
915:
916:
917: IF l_other_tax_compensation ='Y'
918: THEN

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

929: IF csr_balance%FOUND THEN
930:
931: l_oth_comp :=0;
932: 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 ) ;
933: --fnd_file.put_line (fnd_file.LOG, 'l_oth_comp' ||l_oth_comp);
934:
935: IF l_oth_comp > 0 THEN
936:
937: pay_action_information_api.create_action_information

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

983:
984:
985: EXCEPTION
986: WHEN others THEN
987: fnd_file.put_line (fnd_file.LOG, 'Error in Other Compensation'||substr(sqlerrm,1,30));
988: END;
989:
990: END IF; --- End of Validation for Other Tax Compensation in Assignment EIT
991:

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

997: -- Salary Information in Working Time Certificate of Section 12
998: -- has vaiable Additional and Overtime Pay
999: -- Assignment EIT of Income Info has Hourly Pay Variable marked as 'YES'
1000:
1001: --fnd_file.put_line (fnd_file.LOG, 'l_hourly_pay_variable'||l_hourly_pay_variable);
1002:
1003: IF l_hourly_pay_variable = 'Y'
1004: THEN
1005:

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

1016:
1017: IF csr_balance%FOUND THEN
1018: l_overtime_mw := 0;
1019: 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 ) ;
1020: --fnd_file.put_line (fnd_file.LOG, 'l_overtime_mw' ||l_overtime_mw);
1021: IF l_overtime_mw > 0 THEN
1022:
1023: pay_action_information_api.create_action_information
1024: (p_action_information_id => l_action_info_id

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

1069:
1070:
1071: EXCEPTION
1072: WHEN others THEN
1073: fnd_file.put_line (fnd_file.LOG, 'Error in Overtime'||substr(sqlerrm,1,30));
1074: END; -- End of Begin for Overtime Variable Pay
1075:
1076:
1077: ------------------------------------Additional/Supplementary hours - if variable ---

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

1087:
1088: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1089: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1090: CLOSE csr_bg_Get_Defined_Balance_Id;
1091: --fnd_file.put_line (fnd_file.LOG, 'check_addtional' ||l_addl_time_mw);
1092:
1093: IF csr_balance%FOUND THEN
1094:
1095: l_addl_time_mw :=0;

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

1093: IF csr_balance%FOUND THEN
1094:
1095: l_addl_time_mw :=0;
1096: 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 ) ;
1097: --fnd_file.put_line (fnd_file.LOG, 'l_addl_time_mw' ||l_addl_time_mw);
1098: IF l_addl_time_mw > 0 THEN
1099:
1100: pay_action_information_api.create_action_information
1101: (p_action_information_id => l_action_info_id

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

1146:
1147:
1148: EXCEPTION
1149: WHEN others THEN
1150: fnd_file.put_line (fnd_file.LOG, 'Error in Additional'||substr(sqlerrm,1,30));
1151: END; -- End of Begin for Additional Time monthly Wage
1152:
1153: END IF; --- End of IF condition for hourly pay variable
1154: