APPS.PSP_SUM_TRANS dependencies on FND_FILE

Line 266: psp_message_s.print_error(p_mode => FND_FILE.LOG,

262: p_msg_index_out => l_msg_count); */
263:
264: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
265: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
266: psp_message_s.print_error(p_mode => FND_FILE.LOG,
267: p_print_header => FND_API.G_TRUE);
268: retcode := 2;
269: WHEN OTHERS THEN
270:

Line 295: psp_message_s.print_error(p_mode => FND_FILE.LOG,

291: p_msg_index_out => l_msg_count); */
292:
293: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
294: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
295: psp_message_s.print_error(p_mode => FND_FILE.LOG,
296: p_print_header => FND_API.G_TRUE);
297: retcode := 2;
298: END;
299:

Line 6124: ---fnd_file.put_line(fnd_file.log,'before emp count');

6120:
6121: open check_emp_overlap;
6122: fetch check_emp_overlap into l_emp_overlap_count;
6123: close check_emp_overlap;
6124: ---fnd_file.put_line(fnd_file.log,'before emp count');
6125: if l_emp_overlap_count > 0 then
6126:
6127: open check_emp_match_option;
6128: fetch check_emp_match_option into l_count_emp_match;

Line 6130: ---fnd_file.put_line(fnd_file.log,'l_count_emp_match = '||l_count_emp_match);

6126:
6127: open check_emp_match_option;
6128: fetch check_emp_match_option into l_count_emp_match;
6129: close check_emp_match_option;
6130: ---fnd_file.put_line(fnd_file.log,'l_count_emp_match = '||l_count_emp_match);
6131: hr_utility.trace( 'SandT_Supercede--> Main Loop Entered');
6132: hr_utility.trace( 'SandT_Supercede--> reqid string, p_source_type, template_id ='||
6133: l_supercede_reqid_str||':'||p_source_type||':'||t_template_id(k));
6134: if l_count_emp_match > 0 then

Line 6165: ---fnd_file.put_line(fnd_file.log,'t_efforts_table '||t_efforts_table.count);

6161: elsif p_source_type in ('N','O') then
6162: open payroll_asg_er_supercede;
6163: fetch payroll_asg_er_supercede bulk collect into t_efforts_table, t_person_table, t_sum_line_id;
6164: close payroll_asg_er_Supercede;
6165: ---fnd_file.put_line(fnd_file.log,'t_efforts_table '||t_efforts_table.count);
6166: else
6167: open all_asg_er_supercede;
6168: fetch all_asg_er_supercede bulk collect into t_efforts_table, t_person_table, t_sum_line_id;
6169: close all_asg_er_Supercede;

Line 6173: --fnd_file.put_line(fnd_file.log, 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);

6169: close all_asg_er_Supercede;
6170: end if; --- source type adjustments
6171: end if;
6172: hr_utility.trace( 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);
6173: --fnd_file.put_line(fnd_file.log, 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);
6174: open supercede_tolerance(t_template_id(k));
6175: fetch supercede_tolerance into l_tolerance_amt, l_tolerance_percent;
6176: close supercede_tolerance;
6177: hr_utility.trace( 'SandT_Supercede--> get_tolerance limits AMT, %'||