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

Line 3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));

3079: hr_utility.trace(to_char(SQLCODE)||SQLERRM||'Program error contact support');
3080: hr_utility.trace('Entered the main program exception handler');
3081: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3082:
3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

Line 3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));

3080: hr_utility.trace('Entered the main program exception handler');
3081: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3082:
3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3088:

Line 3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);

3081: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3082:
3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3088:
3089: rollback to GEO_UPDATE_SAVEPOINT;

Line 3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);

3082:
3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3088:
3089: rollback to GEO_UPDATE_SAVEPOINT;
3090:

Line 3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

3083: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3084: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3085: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3086: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3087: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3088:
3089: rollback to GEO_UPDATE_SAVEPOINT;
3090:
3091: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',170);

Line 3357: fnd_file.put_line(fnd_file.log, 'Exception update_taxability_rules' );

3353: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
3354: rollback;
3355: hr_utility.set_location('pay_us_geo_upd_pkg.update_taxability_rules',6);
3356:
3357: fnd_file.put_line(fnd_file.log, 'Exception update_taxability_rules' );
3358: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3359:
3360: raise_application_error(-20001,l_error_message_text);
3361:

Line 3358: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

3354: rollback;
3355: hr_utility.set_location('pay_us_geo_upd_pkg.update_taxability_rules',6);
3356:
3357: fnd_file.put_line(fnd_file.log, 'Exception update_taxability_rules' );
3358: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3359:
3360: raise_application_error(-20001,l_error_message_text);
3361:
3362:

Line 3552: fnd_file.put_line(fnd_file.log, 'Exception update_org_info' );

3548: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
3549: rollback;
3550: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',6);
3551:
3552: fnd_file.put_line(fnd_file.log, 'Exception update_org_info' );
3553: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3554:
3555: raise_application_error(-20001,l_error_message_text);
3556:

Line 3553: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

3549: rollback;
3550: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',6);
3551:
3552: fnd_file.put_line(fnd_file.log, 'Exception update_org_info' );
3553: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3554:
3555: raise_application_error(-20001,l_error_message_text);
3556:
3557: END update_org_info;

Line 3896: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );

3892: ' Program error contact support';
3893: rollback;
3894: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',11);
3895:
3896: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
3897: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3898:
3899: raise_application_error(-20001,l_error_message_text);
3900:

Line 3897: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

3893: rollback;
3894: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',11);
3895:
3896: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
3897: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3898:
3899: raise_application_error(-20001,l_error_message_text);
3900:
3901: hr_utility.set_location('before commit ',5);

Line 4238: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );

4234: hr_utility.trace('Entering pay_us_geo_upd_pkg. group_level_balance - 7005');
4235: hr_utility.trace('l_error_message_text - ' ||l_error_message_text);
4236:
4237:
4238: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
4239: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4240:
4241:
4242: rollback;

Line 4239: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

4235: hr_utility.trace('l_error_message_text - ' ||l_error_message_text);
4236:
4237:
4238: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
4239: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4240:
4241:
4242: rollback;
4243: