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 727: fnd_file.put_line(fnd_file.log, 'Inside Archive_deinit procedure');

723: --
724: --
725:
726: begin
727: fnd_file.put_line(fnd_file.log, 'Inside Archive_deinit procedure');
728: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
729: retcode := 0;
730: fnd_file.put_line(fnd_file.log, 'p_payroll_action_id: ' || to_char(p_payroll_action_id));
731: open c_parameters(p_payroll_action_id);

Line 730: fnd_file.put_line(fnd_file.log, 'p_payroll_action_id: ' || to_char(p_payroll_action_id));

726: begin
727: fnd_file.put_line(fnd_file.log, 'Inside Archive_deinit procedure');
728: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
729: retcode := 0;
730: fnd_file.put_line(fnd_file.log, 'p_payroll_action_id: ' || to_char(p_payroll_action_id));
731: open c_parameters(p_payroll_action_id);
732:
733: fetch c_parameters into leg_param,
734: l_patch_name,

Line 737: fnd_file.put_line(fnd_file.log, 'leg_param: ' || to_char(leg_param));

733: fetch c_parameters into leg_param,
734: l_patch_name,
735: l_mode;
736: close c_parameters;
737: fnd_file.put_line(fnd_file.log, 'leg_param: ' || to_char(leg_param));
738: fnd_file.put_line(fnd_file.log, 'l_patch_name: ' || l_patch_name);
739: fnd_file.put_line(fnd_file.log, 'l_mode: ' || l_mode);
740: /***** submit the geocode reports ****/
741:

Line 738: fnd_file.put_line(fnd_file.log, 'l_patch_name: ' || l_patch_name);

734: l_patch_name,
735: l_mode;
736: close c_parameters;
737: fnd_file.put_line(fnd_file.log, 'leg_param: ' || to_char(leg_param));
738: fnd_file.put_line(fnd_file.log, 'l_patch_name: ' || l_patch_name);
739: fnd_file.put_line(fnd_file.log, 'l_mode: ' || l_mode);
740: /***** submit the geocode reports ****/
741:
742: pay_us_geocode_report_pkg.extract_data( errbuf

Line 739: fnd_file.put_line(fnd_file.log, 'l_mode: ' || l_mode);

735: l_mode;
736: close c_parameters;
737: fnd_file.put_line(fnd_file.log, 'leg_param: ' || to_char(leg_param));
738: fnd_file.put_line(fnd_file.log, 'l_patch_name: ' || l_patch_name);
739: fnd_file.put_line(fnd_file.log, 'l_mode: ' || l_mode);
740: /***** submit the geocode reports ****/
741:
742: pay_us_geocode_report_pkg.extract_data( errbuf
743: ,retcode

Line 757: fnd_file.put_line(fnd_file.log, ' lv_cur_geo_patch = ' || lv_cur_geo_patch);

753: close c_get_params;
754:
755: --hr_utility.trace(' lv_cur_geo_patch = ' || lv_cur_geo_patch);
756: --hr_utility.trace('archive deinit ln_patch_number = ' || ln_patch_number);
757: fnd_file.put_line(fnd_file.log, ' lv_cur_geo_patch = ' || lv_cur_geo_patch);
758: fnd_file.put_line(fnd_file.log, 'archive deinit ln_patch_number = ' || ln_patch_number);
759: --
760: open c_geo_check(lv_cur_geo_patch, ln_patch_number);
761: fetch c_geo_check into ln_patch_id;

Line 758: fnd_file.put_line(fnd_file.log, 'archive deinit ln_patch_number = ' || ln_patch_number);

754:
755: --hr_utility.trace(' lv_cur_geo_patch = ' || lv_cur_geo_patch);
756: --hr_utility.trace('archive deinit ln_patch_number = ' || ln_patch_number);
757: fnd_file.put_line(fnd_file.log, ' lv_cur_geo_patch = ' || lv_cur_geo_patch);
758: fnd_file.put_line(fnd_file.log, 'archive deinit ln_patch_number = ' || ln_patch_number);
759: --
760: open c_geo_check(lv_cur_geo_patch, ln_patch_number);
761: fetch c_geo_check into ln_patch_id;
762: if c_geo_check%found then

Line 764: fnd_file.put_line(fnd_file.log, 'c_geo_check%found');

760: open c_geo_check(lv_cur_geo_patch, ln_patch_number);
761: fetch c_geo_check into ln_patch_id;
762: if c_geo_check%found then
763:
764: fnd_file.put_line(fnd_file.log, 'c_geo_check%found');
765: open c_geo_upd(ln_patch_id, 'P');
766: fetch c_geo_upd into lc_error;
767: if c_geo_upd%found then
768: fnd_file.put_line(fnd_file.log, 'c_geo_upd%found');

Line 768: fnd_file.put_line(fnd_file.log, 'c_geo_upd%found');

764: fnd_file.put_line(fnd_file.log, 'c_geo_check%found');
765: open c_geo_upd(ln_patch_id, 'P');
766: fetch c_geo_upd into lc_error;
767: if c_geo_upd%found then
768: fnd_file.put_line(fnd_file.log, 'c_geo_upd%found');
769: update pay_patch_status
770: set status = 'E'
771: where id = ln_patch_id;
772:

Line 774: fnd_file.put_line(fnd_file.log, 'c_geo_upd%notfound');

770: set status = 'E'
771: where id = ln_patch_id;
772:
773: else
774: fnd_file.put_line(fnd_file.log, 'c_geo_upd%notfound');
775: update pay_patch_status
776: set status = 'C',
777: phase = null,
778: process_type = null,

Line 785: fnd_file.put_line(fnd_file.log, 'c_geo_check%notfound');

781:
782: end if;
783: close c_geo_upd;
784: else /* c_geo_check%found */
785: fnd_file.put_line(fnd_file.log, 'c_geo_check%notfound');
786: end if;
787: close c_geo_check;
788:
789: /* EXCEPTION

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

3372: hr_utility.trace(to_char(SQLCODE)||SQLERRM||'Program error contact support');
3373: hr_utility.trace('Entered the main program exception handler');
3374: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3375:
3376: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3377: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3378: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3379: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3380: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));

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

3373: hr_utility.trace('Entered the main program exception handler');
3374: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3375:
3376: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3377: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3378: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3379: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3380: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3381:

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

3374: hr_utility.trace('The code failed at process type of: '||l_proc_stage);
3375:
3376: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3377: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3378: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3379: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3380: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3381:
3382: rollback to GEO_UPDATE_SAVEPOINT;

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

3375:
3376: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3377: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3378: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3379: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3380: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3381:
3382: rollback to GEO_UPDATE_SAVEPOINT;
3383:

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

3376: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Person id = ' || to_char(main_person_id));
3377: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Assignment id = ' || to_char(main_assign_id));
3378: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' Old Jurisdiction Code = ' || main_old_juri_code);
3379: fnd_file.put_line(fnd_file.log, 'Exception ' || l_proc_stage || ' New Jurisdiction Code = ' || main_new_juri_code);
3380: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3381:
3382: rollback to GEO_UPDATE_SAVEPOINT;
3383:
3384: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',170);

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

3646: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
3647: rollback;
3648: hr_utility.set_location('pay_us_geo_upd_pkg.update_taxability_rules',6);
3649:
3650: fnd_file.put_line(fnd_file.log, 'Exception update_taxability_rules' );
3651: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3652:
3653: raise_application_error(-20001,l_error_message_text);
3654:

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

3647: rollback;
3648: hr_utility.set_location('pay_us_geo_upd_pkg.update_taxability_rules',6);
3649:
3650: fnd_file.put_line(fnd_file.log, 'Exception update_taxability_rules' );
3651: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3652:
3653: raise_application_error(-20001,l_error_message_text);
3654:
3655:

Line 3786: fnd_file.put_line(fnd_file.log, l_description);

3782: l_county_name_change.new_county_name||'. Corresponding Person Address Records Updated.';
3783:
3784: IF P_CALL = 'EXTERNAL' THEN
3785:
3786: fnd_file.put_line(fnd_file.log, l_description);
3787:
3788: END IF;
3789:
3790: write_message(

Line 3855: fnd_file.put_line(fnd_file.log, l_description);

3851: l_county_name_change.new_county_name||'. Corresponding Location Address Records Updated.';
3852:
3853: IF P_CALL = 'EXTERNAL' THEN
3854:
3855: fnd_file.put_line(fnd_file.log, l_description);
3856:
3857: END IF;
3858:
3859: write_message(

Line 3886: fnd_file.put_line(fnd_file.log, 'Exception update_county_name' );

3882: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
3883: rollback;
3884: hr_utility.set_location('pay_us_geo_upd_pkg.update_county_name',11);
3885:
3886: fnd_file.put_line(fnd_file.log, 'Exception update_county_name' );
3887: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3888:
3889: raise_application_error(-20001,l_error_message_text);
3890:

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

3883: rollback;
3884: hr_utility.set_location('pay_us_geo_upd_pkg.update_county_name',11);
3885:
3886: fnd_file.put_line(fnd_file.log, 'Exception update_county_name' );
3887: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
3888:
3889: raise_application_error(-20001,l_error_message_text);
3890:
3891: END update_county_name;

Line 4628: fnd_file.put_line(fnd_file.log, 'Exception update_city_name' );

4624: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
4625: ROLLBACK;
4626: hr_utility.set_location('pay_us_geo_upd_pkg.update_city_name',99);
4627:
4628: fnd_file.put_line(fnd_file.log, 'Exception update_city_name' );
4629: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4630:
4631: raise_application_error(-20001,l_error_message_text);
4632:

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

4625: ROLLBACK;
4626: hr_utility.set_location('pay_us_geo_upd_pkg.update_city_name',99);
4627:
4628: fnd_file.put_line(fnd_file.log, 'Exception update_city_name' );
4629: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4630:
4631: raise_application_error(-20001,l_error_message_text);
4632:
4633: END update_city_name;

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

4820: l_error_message_text := to_char(SQLCODE)||SQLERRM||' Program error contact support';
4821: rollback;
4822: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',6);
4823:
4824: fnd_file.put_line(fnd_file.log, 'Exception update_org_info' );
4825: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4826:
4827: raise_application_error(-20001,l_error_message_text);
4828:

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

4821: rollback;
4822: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',6);
4823:
4824: fnd_file.put_line(fnd_file.log, 'Exception update_org_info' );
4825: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
4826:
4827: raise_application_error(-20001,l_error_message_text);
4828:
4829: END update_org_info;

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

5164: ' Program error contact support';
5165: rollback;
5166: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',11);
5167:
5168: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
5169: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
5170:
5171: raise_application_error(-20001,l_error_message_text);
5172:

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

5165: rollback;
5166: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',11);
5167:
5168: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
5169: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
5170:
5171: raise_application_error(-20001,l_error_message_text);
5172:
5173: hr_utility.set_location('before commit ',5);

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

5506: hr_utility.trace('Entering pay_us_geo_upd_pkg. group_level_balance - 7005');
5507: hr_utility.trace('l_error_message_text - ' ||l_error_message_text);
5508:
5509:
5510: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
5511: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
5512:
5513:
5514: rollback;

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

5507: hr_utility.trace('l_error_message_text - ' ||l_error_message_text);
5508:
5509:
5510: fnd_file.put_line(fnd_file.log, 'Exception update_ca_emp_info' );
5511: fnd_file.put_line(fnd_file.log, 'sql error ' || sqlcode || ' - ' || substr(sqlerrm,1,80));
5512:
5513:
5514: rollback;
5515: