DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on HR_UTILITY

Line 186: hr_utility.trace('In get_asg_xml');

182: and ppa1.action_status = 'C'
183: and ppa1.effective_date = ppa.effective_date;
184:
185: begin
186: hr_utility.trace('In get_asg_xml');
187:
188: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
189:
190: open c_get_params;

Line 200: hr_utility.trace('l_aa_id ' ||l_aa_id);

196: l_instructions,
197: l_prov;
198: close c_get_params;
199:
200: hr_utility.trace('l_aa_id ' ||l_aa_id);
201: hr_utility.trace('l_pa_id ' ||l_pa_id);
202: hr_utility.trace('l_type ' ||l_type);
203: hr_utility.trace('l_print ' ||l_print);
204: hr_utility.trace('l_prov ' ||l_prov);

Line 201: hr_utility.trace('l_pa_id ' ||l_pa_id);

197: l_prov;
198: close c_get_params;
199:
200: hr_utility.trace('l_aa_id ' ||l_aa_id);
201: hr_utility.trace('l_pa_id ' ||l_pa_id);
202: hr_utility.trace('l_type ' ||l_type);
203: hr_utility.trace('l_print ' ||l_print);
204: hr_utility.trace('l_prov ' ||l_prov);
205:

Line 202: hr_utility.trace('l_type ' ||l_type);

198: close c_get_params;
199:
200: hr_utility.trace('l_aa_id ' ||l_aa_id);
201: hr_utility.trace('l_pa_id ' ||l_pa_id);
202: hr_utility.trace('l_type ' ||l_type);
203: hr_utility.trace('l_print ' ||l_print);
204: hr_utility.trace('l_prov ' ||l_prov);
205:
206: l_output_location := get_outfile;

Line 203: hr_utility.trace('l_print ' ||l_print);

199:
200: hr_utility.trace('l_aa_id ' ||l_aa_id);
201: hr_utility.trace('l_pa_id ' ||l_pa_id);
202: hr_utility.trace('l_type ' ||l_type);
203: hr_utility.trace('l_print ' ||l_print);
204: hr_utility.trace('l_prov ' ||l_prov);
205:
206: l_output_location := get_outfile;
207:

Line 204: hr_utility.trace('l_prov ' ||l_prov);

200: hr_utility.trace('l_aa_id ' ||l_aa_id);
201: hr_utility.trace('l_pa_id ' ||l_pa_id);
202: hr_utility.trace('l_type ' ||l_type);
203: hr_utility.trace('l_print ' ||l_print);
204: hr_utility.trace('l_prov ' ||l_prov);
205:
206: l_output_location := get_outfile;
207:
208: l_iana_charset := get_IANA_charset;

Line 250: hr_utility.trace('sqleerm ' || SQLERRM);

246: pay_core_files.write_to_magtape_lob(l_trailer_xml);
247:
248: exception
249: when others then
250: hr_utility.trace('sqleerm ' || SQLERRM);
251: raise;
252: end;
253:
254:

Line 886: hr_utility.trace('sqleerm '|| sqlerrm);

882: pay_core_files.write_to_magtape_lob(l_employee_xml);
883:
884: exception
885: when others then
886: hr_utility.trace('sqleerm '|| sqlerrm);
887: hr_utility.raise_error;
888: end;
889:
890:

Line 887: hr_utility.raise_error;

883:
884: exception
885: when others then
886: hr_utility.trace('sqleerm '|| sqlerrm);
887: hr_utility.raise_error;
888: end;
889:
890:
891: function create_xml_string (p_employer_name varchar2,

Line 1028: hr_utility.trace('XML string :' ||l_single_xml);

1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1025: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1027:
1028: hr_utility.trace('XML string :' ||l_single_xml);
1029:
1030: return l_single_xml;
1031:
1032: exception

Line 1034: hr_utility.trace('sqleerm ' || sqlerrm);

1030: return l_single_xml;
1031:
1032: exception
1033: when others then
1034: hr_utility.trace('sqleerm ' || sqlerrm);
1035: hr_utility.raise_error;
1036:
1037: end create_xml_string;
1038:

Line 1035: hr_utility.raise_error;

1031:
1032: exception
1033: when others then
1034: hr_utility.trace('sqleerm ' || sqlerrm);
1035: hr_utility.raise_error;
1036:
1037: end create_xml_string;
1038:
1039:

Line 1079: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );

1075: TEMP_UTL varchar2(512);
1076: l_log varchar2(100);
1077: l_out varchar2(100);
1078: begin
1079: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );
1080:
1081: if g_temp_dir is null then
1082: -- use first entry of utl_file_dir as the g_temp_dir
1083: select translate(ltrim(value),',',' ')

Line 1100: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );

1096: if (TEMP_UTL is null or g_temp_dir is null ) then
1097: raise no_data_found;
1098: end if;
1099: end if;
1100: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );
1101:
1102: FND_FILE.get_names(l_log,l_out);
1103:
1104: l_out := g_temp_dir ||'/'||l_out;

Line 1105: hr_utility.trace('In get_out_file,l_out ' ||l_out );

1101:
1102: FND_FILE.get_names(l_log,l_out);
1103:
1104: l_out := g_temp_dir ||'/'||l_out;
1105: hr_utility.trace('In get_out_file,l_out ' ||l_out );
1106:
1107: return l_out;
1108:
1109: exception

Line 1132: hr_utility.trace('IANA Charset = '||lv_iana_charset);

1128: open csr_get_iana_charset;
1129: fetch csr_get_iana_charset into lv_iana_charset;
1130: close csr_get_iana_charset;
1131:
1132: hr_utility.trace('IANA Charset = '||lv_iana_charset);
1133: return (lv_iana_charset);
1134:
1135: end get_IANA_charset;
1136: