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_CA_T4A_XML dependencies on HR_UTILITY

Line 92: hr_utility.trace('Closing temp_lob' );

88: text_size,
89: raw_data);
90:
91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
92: hr_utility.trace('Closing temp_lob' );
93: dbms_lob.close(temp_blob);
94: hr_utility.trace('Closed temp_lob' );
95: END IF;
96:

Line 94: hr_utility.trace('Closed temp_lob' );

90:
91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
92: hr_utility.trace('Closing temp_lob' );
93: dbms_lob.close(temp_blob);
94: hr_utility.trace('Closed temp_lob' );
95: END IF;
96:
97: return temp_blob;
98: END;

Line 224: hr_utility.trace('In get_final_xml 10');

220: lookup_code = p_lookup_code;
221:
222: begin
223:
224: hr_utility.trace('In get_final_xml 10');
225: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
226: -- hr_utility.trace('p_output_location '||p_output_location);
227:
228: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

Line 225: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

221:
222: begin
223:
224: hr_utility.trace('In get_final_xml 10');
225: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
226: -- hr_utility.trace('p_output_location '||p_output_location);
227:
228: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
229:

Line 226: -- hr_utility.trace('p_output_location '||p_output_location);

222: begin
223:
224: hr_utility.trace('In get_final_xml 10');
225: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
226: -- hr_utility.trace('p_output_location '||p_output_location);
227:
228: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
229:
230: l_header_xml_string := ''||EOL;

Line 231: hr_utility.trace('In get_final_xml 20');

227:
228: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
229:
230: l_header_xml_string := ''||EOL;
231: hr_utility.trace('In get_final_xml 20');
232:
233: select paa.payroll_action_id
234: into l_pa_id
235: from pay_assignment_actions paa

Line 241: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);

237:
238: lv_negative_bal_flag := 'N';
239: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_assignment_action_id ,
240: 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
241: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
242:
243: if (lv_negative_bal_flag is NULL or lv_negative_bal_flag = 'N') then
244: g_err_emp := NULL;
245: fetch_t4a_xml(p_assignment_action_id,

Line 251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));

247: 'Y',
248: 'get_final_xml',
249: p_xml_blob
250: );
251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:

Line 252: hr_utility.trace('1. final 1. XML l_final_xml '||

248: 'get_final_xml',
249: p_xml_blob
250: );
251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:
256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

Line 254: hr_utility.trace('In get_final_xml 30');

250: );
251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:
256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
258:

Line 257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:
256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
258:
259: IF l_is_temp_final_xml = 1 THEN
260: DBMS_LOB.FREETEMPORARY(l_final_xml);
261: END IF;

Line 267: hr_utility.trace('In get_final_xml 40');

263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
265: l_final_xml := append_to_lob(l_header_xml_string);
266: dbms_lob.append(l_final_xml,p_xml_blob);
267: hr_utility.trace('In get_final_xml 40');
268:
269: l_trailer_xml := ''||EOL;
270:
271: hr_utility.trace('In get_final_xml 50');

Line 271: hr_utility.trace('In get_final_xml 50');

267: hr_utility.trace('In get_final_xml 40');
268:
269: l_trailer_xml := ''||EOL;
270:
271: hr_utility.trace('In get_final_xml 50');
272: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);

Line 278: hr_utility.trace('Closing l_final_xml' );

274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);
276:
277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );

Line 282: hr_utility.trace('Closing p_xml_blob' );

278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );

Line 286: hr_utility.trace('Closing l_temp_blob' );

282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );
287: dbms_lob.close(l_temp_blob);
288: END IF;
289: hr_utility.trace('In get_final_xml 60');
290:

Line 289: hr_utility.trace('In get_final_xml 60');

285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );
287: dbms_lob.close(l_temp_blob);
288: END IF;
289: hr_utility.trace('In get_final_xml 60');
290:
291: else -- lv_negative_bal_flag = 'Y'
292: hr_utility.trace('Negative employee');
293: OPEN cur_get_meaning('NEG');

Line 292: hr_utility.trace('Negative employee');

288: END IF;
289: hr_utility.trace('In get_final_xml 60');
290:
291: else -- lv_negative_bal_flag = 'Y'
292: hr_utility.trace('Negative employee');
293: OPEN cur_get_meaning('NEG');
294: FETCH cur_get_meaning
295: INTO l_err_msg;
296: CLOSE cur_get_meaning;

Line 300: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

296: CLOSE cur_get_meaning;
297:
298: l_err_msg := 'Error:'||l_err_msg;
299: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
300: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
301:
302: IF l_is_temp_final_xml = 1 THEN
303: DBMS_LOB.FREETEMPORARY(l_final_xml);
304: END IF;

Line 309: hr_utility.trace('In get_final_xml 61');

305:
306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );
312: dbms_lob.close(l_final_xml);
313: END IF;

Line 311: hr_utility.trace('Closing l_final_xml' );

307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );
312: dbms_lob.close(l_final_xml);
313: END IF;
314: hr_utility.trace('In get_final_xml 62');
315: end if;

Line 314: hr_utility.trace('In get_final_xml 62');

310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );
312: dbms_lob.close(l_final_xml);
313: END IF;
314: hr_utility.trace('In get_final_xml 62');
315: end if;
316: hr_utility.trace('In get_final_xml 65');
317: return l_final_xml;
318:

Line 316: hr_utility.trace('In get_final_xml 65');

312: dbms_lob.close(l_final_xml);
313: END IF;
314: hr_utility.trace('In get_final_xml 62');
315: end if;
316: hr_utility.trace('In get_final_xml 65');
317: return l_final_xml;
318:
319: exception
320: when others then

Line 321: hr_utility.trace('In get_final_xml 70');

317: return l_final_xml;
318:
319: exception
320: when others then
321: hr_utility.trace('In get_final_xml 70');
322:
323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);

Line 324: hr_utility.trace('Raising exception and Closing l_final_xml' );

320: when others then
321: hr_utility.trace('In get_final_xml 70');
322:
323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );

Line 328: hr_utility.trace('Raising exception and Closing p_xml_string' );

324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
332: hr_utility.trace('Closing l_temp_blob' );

Line 332: hr_utility.trace('Closing l_temp_blob' );

328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
332: hr_utility.trace('Closing l_temp_blob' );
333: dbms_lob.close(l_temp_blob);
334: END IF;
335:
336: hr_utility.trace('sqleerm ' || SQLERRM);

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

332: hr_utility.trace('Closing l_temp_blob' );
333: dbms_lob.close(l_temp_blob);
334: END IF;
335:
336: hr_utility.trace('sqleerm ' || SQLERRM);
337: raise;
338: end get_final_xml;
339:
340: procedure get_asg_xml is

Line 370: hr_utility.trace('Entering in get_asg_xml');

366: and ppa1.action_status = 'C'
367: and ppa1.effective_date = ppa.effective_date;
368:
369: begin
370: hr_utility.trace('Entering in get_asg_xml');
371: open c_get_params;
372: fetch c_get_params into
373: l_aa_id,
374: l_pa_id,

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

373: l_aa_id,
374: l_pa_id,
375: p_print; -- Added for Bug 12943928
376: close c_get_params;
377: hr_utility.trace('l_aa_id '||l_aa_id);
378: hr_utility.trace('l_pa_id '||l_pa_id);
379: hr_utility.trace('p_print '||p_print);
380: fetch_t4a_xml(l_aa_id,
381: l_pa_id,

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

374: l_pa_id,
375: p_print; -- Added for Bug 12943928
376: close c_get_params;
377: hr_utility.trace('l_aa_id '||l_aa_id);
378: hr_utility.trace('l_pa_id '||l_pa_id);
379: hr_utility.trace('p_print '||p_print);
380: fetch_t4a_xml(l_aa_id,
381: l_pa_id,
382: p_print,

Line 379: hr_utility.trace('p_print '||p_print);

375: p_print; -- Added for Bug 12943928
376: close c_get_params;
377: hr_utility.trace('l_aa_id '||l_aa_id);
378: hr_utility.trace('l_pa_id '||l_pa_id);
379: hr_utility.trace('p_print '||p_print);
380: fetch_t4a_xml(l_aa_id,
381: l_pa_id,
382: p_print,
383: 'get_asg_xml',

Line 385: hr_utility.trace('Leaving from get_asg_xml');

381: l_pa_id,
382: p_print,
383: 'get_asg_xml',
384: l_xml_blob);
385: hr_utility.trace('Leaving from get_asg_xml');
386: end get_asg_xml;
387:
388: /* this procedure used to genarate XML data for both
389: Concurrent program and Online T4A */

Line 591: hr_utility.trace('Entering in fetch_t4a_xml');

587: and paa.tax_unit_id = hou.organization_id;
588:
589: begin
590:
591: hr_utility.trace('Entering in fetch_t4a_xml');
592: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
593: l_aa_id := p_aa_id;
594: l_pa_id := p_pa_id;
595: hr_utility.trace('l_aa_id ' ||l_aa_id);

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

591: hr_utility.trace('Entering in fetch_t4a_xml');
592: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
593: l_aa_id := p_aa_id;
594: l_pa_id := p_pa_id;
595: hr_utility.trace('l_aa_id ' ||l_aa_id);
596: hr_utility.trace('l_pa_id ' ||l_pa_id);
597: hr_utility.trace('p_print ' ||p_print);
598:
599: if ( g_err_emp = 'Y' ) then

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

592: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
593: l_aa_id := p_aa_id;
594: l_pa_id := p_pa_id;
595: hr_utility.trace('l_aa_id ' ||l_aa_id);
596: hr_utility.trace('l_pa_id ' ||l_pa_id);
597: hr_utility.trace('p_print ' ||p_print);
598:
599: if ( g_err_emp = 'Y' ) then
600: l_aa_id := g_aa_id;

Line 597: hr_utility.trace('p_print ' ||p_print);

593: l_aa_id := p_aa_id;
594: l_pa_id := p_pa_id;
595: hr_utility.trace('l_aa_id ' ||l_aa_id);
596: hr_utility.trace('l_pa_id ' ||l_pa_id);
597: hr_utility.trace('p_print ' ||p_print);
598:
599: if ( g_err_emp = 'Y' ) then
600: l_aa_id := g_aa_id;
601: l_pa_id := g_pa_id;

Line 658: hr_utility.trace('lv_employer_address ' ||lv_employer_address);

654: lv_employer_address3||'\r'||
655: lv_employer_city||' '||lv_employer_province||' '||
656: lv_employer_country||' '||lv_employer_postal_code;
657: end if;
658: hr_utility.trace('lv_employer_address ' ||lv_employer_address);
659:
660: else
661:
662: open cur_gre_name;

Line 874: hr_utility.trace('g_err_emp ='||g_err_emp);

870: l_footnote_value4 := c_t4a_footnote_rec.value;
871: end if;
872: end loop;
873:
874: hr_utility.trace('g_err_emp ='||g_err_emp);
875:
876: OPEN cur_get_meaning(l_msg_code);
877: FETCH cur_get_meaning
878: INTO l_err_msg;

Line 963: hr_utility.trace('correct employee count '||g_other_info_list.count||' '||num_other_info);

959:
960: --l_show_page3 := 'N';
961:
962: --if other information is existed
963: hr_utility.trace('correct employee count '||g_other_info_list.count||' '||num_other_info);
964:
965: l_type := pay_magtape_generic.get_parameter_value('TYPE'); -- Added for #5046003
966:
967: if trim(called_from) = 'get_final_xml' then

Line 971: hr_utility.trace('l_type value is '||l_type);

967: if trim(called_from) = 'get_final_xml' then
968: l_type := 'T4PAPER';
969: end if;
970:
971: hr_utility.trace('l_type value is '||l_type);
972:
973: -- format was changed for other info data and new datatype 'X' was used for code
974: -- '034' and for code '036'
975: -- for 2010 T4A PDF template

Line 986: hr_utility.trace('Entering another page '||'l_i '||l_i||' l_m '||l_m);

982: loop
983: if l_other_amount(l_j) <> '0' and l_other_amount(l_j) is not null then
984:
985: if l_i = 0 and mod(l_m,12) = 1 then
986: hr_utility.trace('Entering another page '||'l_i '||l_i||' l_m '||l_m);
987:
988: -- Added l_other_info_count for bug 10624469
989: l_other_info_count := l_other_info_count +1;
990:

Line 1000: hr_utility.trace('l_box61_xml value is '||l_box61_xml);

996: else
997: l_box61_xml := null;
998: end if;
999:
1000: hr_utility.trace('l_box61_xml value is '||l_box61_xml);
1001:
1002: l_employee_xml := l_employee_xml ||
1003: l_box61_xml||
1004: pay_ca_t4_mag.convert_2_xml(l_year, 'year_'||i,'T')||

Line 1027: hr_utility.trace('Entering another page '||'l_i '||l_i||' l_m '||l_m);

1023:
1024: end if; --l_i = 0 and l_m%12 = 1
1025:
1026: if l_i > 0 and mod(l_m,12) = 1 then
1027: hr_utility.trace('Entering another page '||'l_i '||l_i||' l_m '||l_m);
1028:
1029: -- Added l_other_info_count for bug 10624469
1030: l_other_info_count := l_other_info_count +1;
1031:

Line 1042: hr_utility.trace('l_box61_xml value is '||l_box61_xml);

1038: else
1039: l_box61_xml := null;
1040: end if;
1041:
1042: hr_utility.trace('l_box61_xml value is '||l_box61_xml);
1043:
1044: l_employee_xml := l_employee_xml ||
1045: l_box61_xml||
1046: pay_ca_t4_mag.convert_2_xml(l_year, 'year_'||i,'T')||

Line 1090: hr_utility.trace('l_k ='||l_k||' l_i ='||l_i);

1086: 'oth_amnt'||l_k||'_2','T');
1087: end if; -- if l_other_code(l_j) = '034'
1088: l_k:=l_k+1; l_m:=l_m+1;
1089: if l_k > 12 then
1090: hr_utility.trace('l_k ='||l_k||' l_i ='||l_i);
1091: l_k := 1;
1092: l_i := l_i+1;
1093: end if;
1094: end if; -- l_other_amount(l_j) <> '0' and l_other_amount(l_j) is not null

Line 1104: hr_utility.trace('No of other info pages count '||l_other_info_count);

1100:
1101: l_employee_xml := trim(l_employee_xml);
1102:
1103: -- for bug 10624469
1104: hr_utility.trace('No of other info pages count '||l_other_info_count);
1105:
1106: -- l_other_info_count > 1 for bug 10624469
1107: hr_utility.trace('l_other_info_count before if cond '||l_other_info_count);
1108: hr_utility.trace('mod l_other_info_count before if cond '||mod(l_other_info_count,2));

Line 1107: hr_utility.trace('l_other_info_count before if cond '||l_other_info_count);

1103: -- for bug 10624469
1104: hr_utility.trace('No of other info pages count '||l_other_info_count);
1105:
1106: -- l_other_info_count > 1 for bug 10624469
1107: hr_utility.trace('l_other_info_count before if cond '||l_other_info_count);
1108: hr_utility.trace('mod l_other_info_count before if cond '||mod(l_other_info_count,2));
1109:
1110: /* if l_other_info_count > 1 and trim(called_from) <> 'get_final_xml' then
1111: if l_type ='T4PAPER' and mod(l_other_info_count,2)=0 then

Line 1108: hr_utility.trace('mod l_other_info_count before if cond '||mod(l_other_info_count,2));

1104: hr_utility.trace('No of other info pages count '||l_other_info_count);
1105:
1106: -- l_other_info_count > 1 for bug 10624469
1107: hr_utility.trace('l_other_info_count before if cond '||l_other_info_count);
1108: hr_utility.trace('mod l_other_info_count before if cond '||mod(l_other_info_count,2));
1109:
1110: /* if l_other_info_count > 1 and trim(called_from) <> 'get_final_xml' then
1111: if l_type ='T4PAPER' and mod(l_other_info_count,2)=0 then
1112: l_employee_xml := l_employee_xml||''||'T4ABLANKPAPER'||''||EOL;

Line 1130: hr_utility.trace('ERROR employee count '||g_other_info_list.count||' '||num_other_info);

1126: ||''||EOL;
1127: elsif trim(called_from) = 'get_final_xml' then
1128: l_employee_xml := pay_ca_t4_mag.convert_2_xml(l_err_msg, 'Errmsg','T')||EOL;
1129: else
1130: hr_utility.trace('ERROR employee count '||g_other_info_list.count||' '||num_other_info);
1131: l_employee_xml := '' || EOL||
1132: pay_ca_t4_mag.convert_2_xml(l_year, 'year_f','T')||
1133: pay_ca_t4_mag.convert_2_xml(l_last_nm, 'last_nm_f','T')||
1134: pay_ca_t4_mag.convert_2_xml(l_first_nm, 'first_nm_f','T')||

Line 1188: hr_utility.trace('calling from '||called_from);

1184: end loop;
1185: l_employee_xml :=l_employee_xml||pay_ca_t4_mag.convert_2_xml(l_err_msg, 'Errmsg','T')||''||EOL;
1186: end if;
1187:
1188: hr_utility.trace('calling from '||called_from);
1189: if trim(called_from) = 'get_asg_xml' then
1190: hr_utility.trace('before writing in magtape');
1191: pay_core_files.write_to_magtape_lob(l_employee_xml);
1192: hr_utility.trace('after writing in magtape');

Line 1190: hr_utility.trace('before writing in magtape');

1186: end if;
1187:
1188: hr_utility.trace('calling from '||called_from);
1189: if trim(called_from) = 'get_asg_xml' then
1190: hr_utility.trace('before writing in magtape');
1191: pay_core_files.write_to_magtape_lob(l_employee_xml);
1192: hr_utility.trace('after writing in magtape');
1193: end if;
1194:

Line 1192: hr_utility.trace('after writing in magtape');

1188: hr_utility.trace('calling from '||called_from);
1189: if trim(called_from) = 'get_asg_xml' then
1190: hr_utility.trace('before writing in magtape');
1191: pay_core_files.write_to_magtape_lob(l_employee_xml);
1192: hr_utility.trace('after writing in magtape');
1193: end if;
1194:
1195: if trim(called_from) = 'get_final_xml' then
1196: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);

Line 1206: hr_utility.trace('Closing p_xml_blob' );

1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
1203: p_xml_blob := append_to_lob(l_employee_xml);
1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1206: hr_utility.trace('Closing p_xml_blob' );
1207: dbms_lob.close(p_xml_blob);
1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;
1210: end if;

Line 1208: hr_utility.trace('closed p_xml_blob');

1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1206: hr_utility.trace('Closing p_xml_blob' );
1207: dbms_lob.close(p_xml_blob);
1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;
1210: end if;
1211: hr_utility.trace(l_employee_xml);
1212: hr_utility.trace('Leaving fetch_t4a_xml');

Line 1211: hr_utility.trace(l_employee_xml);

1207: dbms_lob.close(p_xml_blob);
1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;
1210: end if;
1211: hr_utility.trace(l_employee_xml);
1212: hr_utility.trace('Leaving fetch_t4a_xml');
1213:
1214: exception
1215: when others then

Line 1212: hr_utility.trace('Leaving fetch_t4a_xml');

1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;
1210: end if;
1211: hr_utility.trace(l_employee_xml);
1212: hr_utility.trace('Leaving fetch_t4a_xml');
1213:
1214: exception
1215: when others then
1216: hr_utility.trace('sqleerm ' || SQLERRM);

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

1212: hr_utility.trace('Leaving fetch_t4a_xml');
1213:
1214: exception
1215: when others then
1216: hr_utility.trace('sqleerm ' || SQLERRM);
1217: raise;
1218: end fetch_t4a_xml;
1219:
1220: