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 610: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1210: END LOOP ;
1211:
1212: value_month_year(l_count_year).tot_absence_hours(l_currentmonth) := l_tot_absence_hours;
1213:
1214: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours - First' ||l_tot_absence_hours);
1215:
1216: EXCEPTION
1217: WHEN others THEN
1218: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));

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

1214: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours - First' ||l_tot_absence_hours);
1215:
1216: EXCEPTION
1217: WHEN others THEN
1218: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));
1219: null;
1220: END;
1221:
1222:

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

1622:
1623: -- *****************************************************************************
1624: -- EMployer and Signs
1625:
1626: --fnd_file.put_line (fnd_file.LOG, 'l_local_unit_id'||l_local_unit_id);
1627: --fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);
1628:
1629: OPEN csr_contact_details (l_legal_employer_id);
1630:

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

1623: -- *****************************************************************************
1624: -- EMployer and Signs
1625:
1626: --fnd_file.put_line (fnd_file.LOG, 'l_local_unit_id'||l_local_unit_id);
1627: --fnd_file.put_line (fnd_file.LOG, 'l_legal_employer_id'||l_legal_employer_id);
1628:
1629: OPEN csr_contact_details (l_legal_employer_id);
1630:
1631: FETCH csr_contact_details

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

1635:
1636:
1637: l_phone_number := lr_contact_details.org_information3;
1638: --logger ('l_phone_number', l_phone_number);
1639: --fnd_file.put_line (fnd_file.LOG, 'l_phone_number'||l_phone_number);
1640:
1641: OPEN csr_address_details (l_location_id);
1642:
1643: FETCH csr_address_details

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

1916: SELECT last_day(l_report_start_date)
1917: INTO l_reporting_date
1918: FROM DUAL;
1919:
1920: fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
1921:
1922: l_overtime_hours :=0;
1923: l_tot_overtime_hours :=0;
1924: value_month_year(i).tot_overtime_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_overtime_hours;

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

1935: END LOOP ;
1936:
1937: value_month_year(i).tot_overtime_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_overtime_hours;
1938:
1939: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours' ||l_tot_overtime_hours);
1940:
1941: EXCEPTION
1942: WHEN others THEN
1943: fnd_file.put_line (fnd_file.LOG, 'Error for overtime'||substr(sqlerrm,1,30));

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

1939: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_overtime_hours' ||l_tot_overtime_hours);
1940:
1941: EXCEPTION
1942: WHEN others THEN
1943: fnd_file.put_line (fnd_file.LOG, 'Error for overtime'||substr(sqlerrm,1,30));
1944: null;
1945: END;
1946:
1947:

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

1966:
1967: value_month_year(i).tot_addl_time_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_addl_time_hours ;
1968:
1969:
1970: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours' ||l_tot_addl_time_hours);
1971: EXCEPTION
1972: WHEN others THEN
1973: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
1974: null;

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

1969:
1970: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_addl_time_hours' ||l_tot_addl_time_hours);
1971: EXCEPTION
1972: WHEN others THEN
1973: fnd_file.put_line (fnd_file.LOG, 'Error'||substr(sqlerrm,1,30));
1974: null;
1975: END;
1976:
1977:

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

1991: END LOOP ;
1992:
1993: value_month_year(i).tot_absence_hours(lr_se_wtc_time_worked_info.aei_information2) := l_tot_absence_hours;
1994:
1995: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours' ||l_tot_absence_hours);
1996:
1997: EXCEPTION
1998: WHEN others THEN
1999: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));

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

1995: -- fnd_file.put_line (fnd_file.LOG, 'l_tot_absence_hours' ||l_tot_absence_hours);
1996:
1997: EXCEPTION
1998: WHEN others THEN
1999: fnd_file.put_line (fnd_file.LOG, 'Error for absence'||substr(sqlerrm,1,30));
2000: null;
2001: END;
2002:
2003:

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

2243: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
2244: END IF;
2245: EXCEPTION
2246: WHEN others THEN
2247: fnd_file.put_line (fnd_file.LOG, 'Error for archive'||substr(sqlerrm,1,30));
2248: null;
2249: /* EXCEPTION
2250: WHEN OTHERS
2251: THEN

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

2289: ,80
2290: );
2291: END IF;
2292:
2293: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
2294: g_payroll_action_id := p_payroll_action_id;
2295: g_business_group_id := NULL;
2296: g_effective_date := NULL;
2297: g_person_id := NULL;

Line 2307: fnd_file.put_line

2303: ,g_assignment_id
2304: ,g_still_employed
2305: ,g_income_salary_year
2306: );
2307: fnd_file.put_line
2308: (fnd_file.LOG
2309: ,'In the INITIALIZATION_CODE After Initiliazing the global parameter '
2310: );
2311:

Line 2308: (fnd_file.LOG

2304: ,g_still_employed
2305: ,g_income_salary_year
2306: );
2307: fnd_file.put_line
2308: (fnd_file.LOG
2309: ,'In the INITIALIZATION_CODE After Initiliazing the global parameter '
2310: );
2311:
2312: IF g_debug

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

2414:
2415: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2416: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2417:
2418: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2419:
2420: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2421: l_return_balance_value :=
2422: TO_CHAR

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

3077: NULL;
3078: END;
3079: ELSE
3080: l_payroll_action_id := p_payroll_action_id;
3081: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
3082: fnd_file.put_line (fnd_file.LOG
3083: , 'p_payroll_action_id ' || p_payroll_action_id
3084: );
3085:

Line 3082: fnd_file.put_line (fnd_file.LOG

3078: END;
3079: ELSE
3080: l_payroll_action_id := p_payroll_action_id;
3081: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
3082: fnd_file.put_line (fnd_file.LOG
3083: , 'p_payroll_action_id ' || p_payroll_action_id
3084: );
3085:
3086: /* Structure of Xml should look like this

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

3127: INTO lr_wtc_person3;
3128:
3129: CLOSE csr_wtc_person3;
3130:
3131: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.person_number'||lr_wtc_person1.person_number);
3132: ---------------------------------------------------------------------------------------------------------------
3133: --New Format of Person Number (of Ten Digits)
3134: ---------------------------------------------------------------------------------------------------------------
3135: --add_tag_value ('PERSON_NUMBER', lr_wtc_person1.person_number);

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

3179:
3180: add_tag_value ('EMP_LAST_NAME', lr_wtc_person1.emp_last_name);
3181: add_tag_value ('EMP_FIRST_NAME', lr_wtc_person1.emp_first_name);
3182:
3183: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.emp_first_name'||lr_wtc_person1.emp_first_name);
3184: fnd_file.put_line (fnd_file.LOG, 'l_digit10'||l_digit10);
3185:
3186: ---------------------------------------------------------------------------------------------------------------
3187: -- Change the date format for hired_from (YYYYMMDD)

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

3180: add_tag_value ('EMP_LAST_NAME', lr_wtc_person1.emp_last_name);
3181: add_tag_value ('EMP_FIRST_NAME', lr_wtc_person1.emp_first_name);
3182:
3183: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.emp_first_name'||lr_wtc_person1.emp_first_name);
3184: fnd_file.put_line (fnd_file.LOG, 'l_digit10'||l_digit10);
3185:
3186: ---------------------------------------------------------------------------------------------------------------
3187: -- Change the date format for hired_from (YYYYMMDD)
3188: ----------------------------------------------------------------------------------------------------------------

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

3229: gplsqltable (l_counter).tagvalue := TO_CHAR (l_digit10);
3230: l_counter := l_counter
3231: + 1;
3232:
3233: fnd_file.put_line (fnd_file.LOG, 'lr_wtc_person1.hired_to'||lr_wtc_person1.hired_to);
3234:
3235: ---------------------------------------------------------------------------------------------------------------
3236: -- Change the date format for hired_to (YYYYMMDD)
3237: ----------------------------------------------------------------------------------------------------------------

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

3402:
3403: END IF ;
3404:
3405:
3406: fnd_file.put_line (fnd_file.LOG, 'time_limited_check_box'||time_limited_check_box);
3407: fnd_file.put_line (fnd_file.LOG, ' lr_wtc_person1.employment_end_date'|| lr_wtc_person1.employment_end_date);
3408:
3409:
3410: add_tag_value ('TIME_LIMITED_CHECK_BOX', time_limited_check_box);

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

3403: END IF ;
3404:
3405:
3406: fnd_file.put_line (fnd_file.LOG, 'time_limited_check_box'||time_limited_check_box);
3407: fnd_file.put_line (fnd_file.LOG, ' lr_wtc_person1.employment_end_date'|| lr_wtc_person1.employment_end_date);
3408:
3409:
3410: add_tag_value ('TIME_LIMITED_CHECK_BOX', time_limited_check_box);
3411:

Line 4422: fnd_file.put_line (fnd_file.LOG

4418: /* Proc to Add the tag value and Name */
4419: PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2)
4420: IS
4421: BEGIN
4422: fnd_file.put_line (fnd_file.LOG
4423: , p_display || ' ==> ' || p_value
4424: );
4425: END logger;
4426: /* End of Proc to Add the tag value and Name */