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

Line 167: fnd_file.put_line (fnd_file.LOG

163: INTO lr_parameter_info;
164:
165: CLOSE csr_parameter_info;
166:
167: fnd_file.put_line (fnd_file.LOG
168: , 'lr_parameter_info.STILL_EMPLOYED '
169: || lr_parameter_info.still_employed
170: );
171: --logger ('Entering ', l_proc);

Line 612: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');

608: -- *****************************************************************************
609: -- *****************************************************************************
610: BEGIN
611: -- *****************************************************************************
612: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');
613: g_payroll_action_id := p_payroll_action_id;
614: g_business_group_id := NULL;
615: g_effective_date := NULL;
616: g_person_id := NULL;

Line 874: fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);

870: --logger ('l_org_number', l_org_number);
871: --logger ('l_location_id', l_location_id);
872: l_one_year_date := ADD_MONTHS (l_report_effective_date, -12);
873:
874: fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);
875:
876: /*
877: three conditions
878: one if the date is greater than the reporting date, pass reporting date

Line 1128: fnd_file.put_line (fnd_file.LOG, 'set Tax unit');

1124: ------------------------------------------------------
1125:
1126: pay_balance_pkg.set_context ('TAX_UNIT_ID', l_legal_employer_id);
1127:
1128: fnd_file.put_line (fnd_file.LOG, 'set Tax unit');
1129:
1130: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', l_local_unit_id);
1131:
1132:

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

1135: SELECT last_day(l_report_start_date)
1136: INTO l_reporting_date
1137: FROM DUAL;
1138:
1139: -- fnd_file.put_line (fnd_file.LOG, 'l_reporting_date' ||l_reporting_date);
1140:
1141: l_overtime_hours :=0;
1142: l_tot_overtime_hours :=0;
1143:

Line 1158: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours - First' ||l_tot_overtime_hours);

1154: END LOOP ;
1155:
1156: value_month_year(l_count_year).tot_overtime_hours(l_currentmonth) := l_tot_overtime_hours;
1157:
1158: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours - First' ||l_tot_overtime_hours);
1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: fnd_file.put_line (fnd_file.LOG, 'Error for overtime First'||substr(sqlerrm,1,30));

Line 1162: fnd_file.put_line (fnd_file.LOG, 'Error for overtime First'||substr(sqlerrm,1,30));

1158: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours - First' ||l_tot_overtime_hours);
1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: fnd_file.put_line (fnd_file.LOG, 'Error for overtime First'||substr(sqlerrm,1,30));
1163: null;
1164: END;
1165:
1166:

Line 1190: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours - First' ||l_tot_addl_time_hours);

1186: END LOOP ;
1187:
1188: value_month_year(l_count_year).tot_addl_time_hours(l_currentmonth) := l_tot_addl_time_hours ;
1189:
1190: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours - First' ||l_tot_addl_time_hours);
1191:
1192: EXCEPTION
1193: WHEN others THEN
1194: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));

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

1190: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours - First' ||l_tot_addl_time_hours);
1191:
1192: EXCEPTION
1193: WHEN others THEN
1194: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
1195: null;
1196: END;
1197:
1198:

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

1216: ,l_reporting_date
1217: ,l_legal_employer_id
1218: ,l_local_unit_id
1219: );
1220: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours ' ||l_sick_pay_hours);
1221: l_waiting_hours := get_defined_balance_value ('TOTAL_WAITING_HOURS_ASG_RUN'
1222: ,g_assignment_id
1223: ,l_reporting_date
1224: ,l_legal_employer_id

Line 1227: fnd_file.put_line (fnd_file.LOG, '$$$ l_waitng_hours ' ||l_waiting_hours);

1223: ,l_reporting_date
1224: ,l_legal_employer_id
1225: ,l_local_unit_id
1226: );
1227: fnd_file.put_line (fnd_file.LOG, '$$$ l_waitng_hours ' ||l_waiting_hours);
1228:
1229: l_tot_absence_hours := l_tot_absence_hours + nvl(l_sick_pay_hours,0)+ nvl(l_waiting_hours,0);
1230: -- Bug#9272420 issue#5 fix ends
1231:

Line 1234: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours - First' ||l_tot_absence_hours);

1230: -- Bug#9272420 issue#5 fix ends
1231:
1232: value_month_year(l_count_year).tot_absence_hours(l_currentmonth) := l_tot_absence_hours;
1233:
1234: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours - First' ||l_tot_absence_hours);
1235:
1236: EXCEPTION
1237: WHEN others THEN
1238: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));

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

1234: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours - First' ||l_tot_absence_hours);
1235:
1236: EXCEPTION
1237: WHEN others THEN
1238: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));
1239: null;
1240: END;
1241:
1242:

Line 1646: --fnd_file.put_line (fnd_file.LOG, 'l_local_unit_id'||l_local_unit_id);

1642:
1643: -- *****************************************************************************
1644: -- EMployer and Signs
1645:
1646: --fnd_file.put_line (fnd_file.LOG, 'l_local_unit_id'||l_local_unit_id);
1647: --fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);
1648:
1649: OPEN csr_contact_details (l_legal_employer_id);
1650:

Line 1647: --fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);

1643: -- *****************************************************************************
1644: -- EMployer and Signs
1645:
1646: --fnd_file.put_line (fnd_file.LOG, 'l_local_unit_id'||l_local_unit_id);
1647: --fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);
1648:
1649: OPEN csr_contact_details (l_legal_employer_id);
1650:
1651: FETCH csr_contact_details

Line 1659: --fnd_file.put_line (fnd_file.LOG, 'l_phone_number'||l_phone_number);

1655:
1656:
1657: l_phone_number := lr_contact_details.org_information3;
1658: --logger ('l_phone_number', l_phone_number);
1659: --fnd_file.put_line (fnd_file.LOG, 'l_phone_number'||l_phone_number);
1660:
1661: OPEN csr_address_details (l_location_id);
1662:
1663: FETCH csr_address_details

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

1938: SELECT last_day(l_report_start_date)
1939: INTO l_reporting_date
1940: FROM DUAL;
1941:
1942: fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
1943:
1944: l_overtime_hours :=0;
1945: l_tot_overtime_hours :=0;
1946: value_month_year(i).tot_overtime_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_overtime_hours;

Line 1961: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours' ||l_tot_overtime_hours);

1957: END LOOP ;
1958:
1959: value_month_year(i).tot_overtime_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_overtime_hours;
1960:
1961: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours' ||l_tot_overtime_hours);
1962:
1963: EXCEPTION
1964: WHEN others THEN
1965: fnd_file.put_line (fnd_file.LOG, 'Error for overtime'||substr(sqlerrm,1,30));

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

1961: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours' ||l_tot_overtime_hours);
1962:
1963: EXCEPTION
1964: WHEN others THEN
1965: fnd_file.put_line (fnd_file.LOG, 'Error for overtime'||substr(sqlerrm,1,30));
1966: null;
1967: END;
1968:
1969:

Line 1992: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours' ||l_tot_addl_time_hours);

1988:
1989: value_month_year(i).tot_addl_time_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_addl_time_hours ;
1990:
1991:
1992: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours' ||l_tot_addl_time_hours);
1993: EXCEPTION
1994: WHEN others THEN
1995: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
1996: null;

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

1991:
1992: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours' ||l_tot_addl_time_hours);
1993: EXCEPTION
1994: WHEN others THEN
1995: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
1996: null;
1997: END;
1998:
1999:

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

2017: ,l_reporting_date
2018: ,l_legal_employer_id
2019: ,l_local_unit_id
2020: );
2021: fnd_file.put_line (fnd_file.LOG, '$$$ l_sick_pay_hours ' ||l_sick_pay_hours);
2022: l_waiting_hours := get_defined_balance_value ('TOTAL_WAITING_HOURS_ASG_RUN'
2023: ,g_assignment_id
2024: ,l_reporting_date
2025: ,l_legal_employer_id

Line 2028: fnd_file.put_line (fnd_file.LOG, '$$$ l_waitng_hours ' ||l_waiting_hours);

2024: ,l_reporting_date
2025: ,l_legal_employer_id
2026: ,l_local_unit_id
2027: );
2028: fnd_file.put_line (fnd_file.LOG, '$$$ l_waitng_hours ' ||l_waiting_hours);
2029:
2030: l_tot_absence_hours := l_tot_absence_hours + nvl(l_sick_pay_hours,0)+ nvl(l_waiting_hours,0);
2031: -- Bug#9272420 issue#5 fix
2032:

Line 2035: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours' ||l_tot_absence_hours);

2031: -- Bug#9272420 issue#5 fix
2032:
2033: value_month_year(i).tot_absence_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_absence_hours;
2034:
2035: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours' ||l_tot_absence_hours);
2036:
2037: EXCEPTION
2038: WHEN others THEN
2039: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));

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

2035: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours' ||l_tot_absence_hours);
2036:
2037: EXCEPTION
2038: WHEN others THEN
2039: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));
2040: null;
2041: END;
2042:
2043:

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

2283: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
2284: END IF;
2285: EXCEPTION
2286: WHEN others THEN
2287: fnd_file.put_line (fnd_file.LOG, 'Error for archive'||substr(sqlerrm,1,30));
2288: null;
2289: /* EXCEPTION
2290: WHEN OTHERS
2291: THEN

Line 2333: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');

2329: ,80
2330: );
2331: END IF;
2332:
2333: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
2334: g_payroll_action_id := p_payroll_action_id;
2335: g_business_group_id := NULL;
2336: g_effective_date := NULL;
2337: g_person_id := NULL;

Line 2347: fnd_file.put_line

2343: ,g_assignment_id
2344: ,g_still_employed
2345: ,g_income_salary_year
2346: );
2347: fnd_file.put_line
2348: (fnd_file.LOG
2349: ,'In the INITIALIZATION_CODE After Initiliazing the global parameter '
2350: );
2351:

Line 2348: (fnd_file.LOG

2344: ,g_still_employed
2345: ,g_income_salary_year
2346: );
2347: fnd_file.put_line
2348: (fnd_file.LOG
2349: ,'In the INITIALIZATION_CODE After Initiliazing the global parameter '
2350: );
2351:
2352: IF g_debug

Line 2458: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);

2454:
2455: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2456: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2457:
2458: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2459:
2460: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2461: l_return_balance_value :=
2462: TO_CHAR

Line 3122: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');

3118: END;
3119: ELSE
3120: l_payroll_action_id := p_payroll_action_id;
3121: End if; --issue#4 Fix that will give data for request set run and when no archieve id is choosen
3122: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
3123: fnd_file.put_line (fnd_file.LOG
3124: , 'p_payroll_action_id ' || p_payroll_action_id
3125: );
3126:

Line 3123: fnd_file.put_line (fnd_file.LOG

3119: ELSE
3120: l_payroll_action_id := p_payroll_action_id;
3121: End if; --issue#4 Fix that will give data for request set run and when no archieve id is choosen
3122: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
3123: fnd_file.put_line (fnd_file.LOG
3124: , 'p_payroll_action_id ' || p_payroll_action_id
3125: );
3126:
3127: /* Structure of Xml should look like this

Line 3172: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.person_number'||lr_wtc_person1.person_number);

3168: INTO lr_wtc_person3;
3169:
3170: CLOSE csr_wtc_person3;
3171:
3172: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.person_number'||lr_wtc_person1.person_number);
3173: ---------------------------------------------------------------------------------------------------------------
3174: --New Format of Person Number (of Ten Digits)
3175: ---------------------------------------------------------------------------------------------------------------
3176: --add_tag_value ('PERSON_NUMBER', lr_wtc_person1.person_number);

Line 3224: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.emp_first_name'||lr_wtc_person1.emp_first_name);

3220:
3221: add_tag_value ('EMP_LAST_NAME', lr_wtc_person1.emp_last_name);
3222: add_tag_value ('EMP_FIRST_NAME', lr_wtc_person1.emp_first_name);
3223:
3224: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.emp_first_name'||lr_wtc_person1.emp_first_name);
3225: fnd_file.put_line (fnd_file.LOG, 'l_digit10'||l_digit10);
3226:
3227: ---------------------------------------------------------------------------------------------------------------
3228: -- Change the date format for hired_from (YYYYMMDD)

Line 3225: fnd_file.put_line (fnd_file.LOG, 'l_digit10'||l_digit10);

3221: add_tag_value ('EMP_LAST_NAME', lr_wtc_person1.emp_last_name);
3222: add_tag_value ('EMP_FIRST_NAME', lr_wtc_person1.emp_first_name);
3223:
3224: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.emp_first_name'||lr_wtc_person1.emp_first_name);
3225: fnd_file.put_line (fnd_file.LOG, 'l_digit10'||l_digit10);
3226:
3227: ---------------------------------------------------------------------------------------------------------------
3228: -- Change the date format for hired_from (YYYYMMDD)
3229: ----------------------------------------------------------------------------------------------------------------

Line 3274: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.hired_to'||lr_wtc_person1.hired_to);

3270: gplsqltable (l_counter).tagvalue := TO_CHAR (l_digit10);
3271: l_counter := l_counter
3272: + 1;
3273:
3274: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.hired_to'||lr_wtc_person1.hired_to);
3275:
3276: ---------------------------------------------------------------------------------------------------------------
3277: -- Change the date format for hired_to (YYYYMMDD)
3278: ----------------------------------------------------------------------------------------------------------------

Line 3447: fnd_file.put_line (fnd_file.LOG, 'time_limited_check_box'||time_limited_check_box);

3443:
3444: END IF ;
3445:
3446:
3447: fnd_file.put_line (fnd_file.LOG, 'time_limited_check_box'||time_limited_check_box);
3448: fnd_file.put_line (fnd_file.LOG, ' lr_wtc_person1.employment_end_date'|| lr_wtc_person1.employment_end_date);
3449:
3450:
3451: add_tag_value ('TIME_LIMITED_CHECK_BOX', time_limited_check_box);

Line 3448: fnd_file.put_line (fnd_file.LOG, ' lr_wtc_person1.employment_end_date'|| lr_wtc_person1.employment_end_date);

3444: END IF ;
3445:
3446:
3447: fnd_file.put_line (fnd_file.LOG, 'time_limited_check_box'||time_limited_check_box);
3448: fnd_file.put_line (fnd_file.LOG, ' lr_wtc_person1.employment_end_date'|| lr_wtc_person1.employment_end_date);
3449:
3450:
3451: add_tag_value ('TIME_LIMITED_CHECK_BOX', time_limited_check_box);
3452:

Line 4463: fnd_file.put_line (fnd_file.LOG

4459: /* Proc to Add the tag value and Name */
4460: PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2)
4461: IS
4462: BEGIN
4463: fnd_file.put_line (fnd_file.LOG
4464: , p_display || ' ==> ' || p_value
4465: );
4466: END logger;
4467: /* End of Proc to Add the tag value and Name */