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

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

115: text_size,
116: raw_data);
117:
118: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
119: hr_utility.trace('Closing temp_lob' );
120: dbms_lob.close(temp_blob);
121: END IF;
122:
123: return temp_blob;

Line 229: hr_utility.trace('get_ei_earnings_display_flag p_aa_id :' ||p_aa_id);

225:
226: lv_ei_display_flag number;
227: begin
228: lv_ei_display_flag :=1;
229: hr_utility.trace('get_ei_earnings_display_flag p_aa_id :' ||p_aa_id);
230: begin
231: select count(1) into lv_ei_display_flag
232: from ff_archive_items fai,
233: ff_database_items fdi

Line 243: hr_utility.trace('lv_ei_display_flag :' ||lv_ei_display_flag);

239: when others then
240: lv_ei_display_flag :=1;
241: end;
242:
243: hr_utility.trace('lv_ei_display_flag :' ||lv_ei_display_flag);
244:
245: return lv_ei_display_flag;
246:
247: end get_ei_earnings_display_flag;

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

308:
309: /*End Bug#10359114 */
310:
311: begin
312: hr_utility.trace('In get_asg_xml');
313:
314: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
315:
316: open c_get_params;

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

322: l_instructions,
323: l_prov;
324: close c_get_params;
325:
326: hr_utility.trace('l_aa_id ' ||l_aa_id);
327: hr_utility.trace('l_pa_id ' ||l_pa_id);
328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);

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

323: l_prov;
324: close c_get_params;
325:
326: hr_utility.trace('l_aa_id ' ||l_aa_id);
327: hr_utility.trace('l_pa_id ' ||l_pa_id);
328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);
331: /*Added for Bug#10359114 */

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

324: close c_get_params;
325:
326: hr_utility.trace('l_aa_id ' ||l_aa_id);
327: hr_utility.trace('l_pa_id ' ||l_pa_id);
328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);
331: /*Added for Bug#10359114 */
332: open c_get_report_type(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

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

325:
326: hr_utility.trace('l_aa_id ' ||l_aa_id);
327: hr_utility.trace('l_pa_id ' ||l_pa_id);
328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);
331: /*Added for Bug#10359114 */
332: open c_get_report_type(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
333: fetch c_get_report_type into l_report_type;

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

326: hr_utility.trace('l_aa_id ' ||l_aa_id);
327: hr_utility.trace('l_pa_id ' ||l_pa_id);
328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);
331: /*Added for Bug#10359114 */
332: open c_get_report_type(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
333: fetch c_get_report_type into l_report_type;
334: close c_get_report_type;

Line 338: hr_utility.trace('Need to fetch the Archiver Action IDs for Cancel PDF');

334: close c_get_report_type;
335:
336: if l_report_type = 'PAYCAT4CLPDF' then
337:
338: hr_utility.trace('Need to fetch the Archiver Action IDs for Cancel PDF');
339:
340: open c_get_arch_action_ids(l_aa_id);
341: fetch c_get_arch_action_ids into l_aa_id,l_pa_id;
342: close c_get_arch_action_ids;

Line 362: hr_utility.trace('before fetch_t4_xml');

358: ''||EOL;
359:
360: pay_core_files.write_to_magtape_lob(l_header_xml);
361:
362: hr_utility.trace('before fetch_t4_xml');
363: fetch_t4_xml(l_aa_id,
364: l_pa_id,
365: l_type,
366: l_print,

Line 372: hr_utility.trace('after fetch_t4_xml');

368: ,l_instructions /*11066853 */
369: ,'get_asg_xml'
370: ,p_xml_blob
371: );
372: hr_utility.trace('after fetch_t4_xml');
373:
374: if --((l_type = 'T4ERPAPER') or Bug 8500150
375: (l_instructions is null) then
376:

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

392: pay_core_files.write_to_magtape_lob(l_trailer_xml);
393:
394: exception
395: when others then
396: hr_utility.trace('sqleerm ' || SQLERRM);
397: raise;
398: end;
399:
400: /*

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

429: lookup_code = p_lookup_code;
430:
431: begin
432:
433: hr_utility.trace('In get_final_xml 10');
434: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
435: hr_utility.trace('p_province '||p_province);
436: hr_utility.trace('p_output_location '||p_output_location);
437:

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

430:
431: begin
432:
433: hr_utility.trace('In get_final_xml 10');
434: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
435: hr_utility.trace('p_province '||p_province);
436: hr_utility.trace('p_output_location '||p_output_location);
437:
438: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

Line 435: hr_utility.trace('p_province '||p_province);

431: begin
432:
433: hr_utility.trace('In get_final_xml 10');
434: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
435: hr_utility.trace('p_province '||p_province);
436: hr_utility.trace('p_output_location '||p_output_location);
437:
438: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
439: l_iana_charset := get_IANA_charset;

Line 436: hr_utility.trace('p_output_location '||p_output_location);

432:
433: hr_utility.trace('In get_final_xml 10');
434: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
435: hr_utility.trace('p_province '||p_province);
436: hr_utility.trace('p_output_location '||p_output_location);
437:
438: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
439: l_iana_charset := get_IANA_charset;
440:

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

447: ''||EOL||
448: ''||EOL||
449: ''||EOL||
450: ''||EOL;
451: hr_utility.trace('In get_final_xml 20');
452:
453: select paa.payroll_action_id
454: into l_pa_id
455: from pay_assignment_actions paa

Line 457: hr_utility.trace('payroll_action_id '||l_pa_id);

453: select paa.payroll_action_id
454: into l_pa_id
455: from pay_assignment_actions paa
456: where paa.assignment_action_id = p_assignment_action_id;
457: hr_utility.trace('payroll_action_id '||l_pa_id);
458:
459: lv_negative_bal_flag := 'N';
460: lv_negative_bal_flag :=
461: pay_ca_archive_utils.get_archive_value(p_assignment_action_id, p_province,

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

461: pay_ca_archive_utils.get_archive_value(p_assignment_action_id, p_province,
462: 'JURISDICTION_CODE',
463: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
464:
465: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
466: if (lv_negative_bal_flag is NULL or lv_negative_bal_flag = 'N') then
467: fetch_t4_xml(p_assignment_action_id,
468: l_pa_id,
469: 'T4PAPER',

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

472: ,'Y'
473: ,'get_final_xml'
474: ,p_xml_blob
475: );
476: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
477: hr_utility.trace('1. final 1. XML l_final_xml '||
478: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
479: hr_utility.trace('In get_final_xml 30');
480:

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

473: ,'get_final_xml'
474: ,p_xml_blob
475: );
476: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
477: hr_utility.trace('1. final 1. XML l_final_xml '||
478: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
479: hr_utility.trace('In get_final_xml 30');
480:
481: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

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

475: );
476: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
477: hr_utility.trace('1. final 1. XML l_final_xml '||
478: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
479: hr_utility.trace('In get_final_xml 30');
480:
481: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
482: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
483:

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

478: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
479: hr_utility.trace('In get_final_xml 30');
480:
481: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
482: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
483:
484: IF l_is_temp_final_xml = 1 THEN
485: DBMS_LOB.FREETEMPORARY(l_final_xml);
486: END IF;

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

488: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
489: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
490: l_final_xml := append_to_lob(l_final_xml_string);
491: dbms_lob.append(l_final_xml,p_xml_blob);
492: hr_utility.trace('In get_final_xml 40');
493:
494: l_trailer_xml := ''||EOL||
495: ''||EOL||
496: ''|| EOL||

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

498: ''||EOL||
499: ''||EOL||
500: ''||EOL;
501:
502: hr_utility.trace('In get_final_xml 50');
503: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
504: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
505: l_temp_blob := append_to_lob(l_trailer_xml);
506: dbms_lob.append(l_final_xml,l_temp_blob);

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

505: l_temp_blob := append_to_lob(l_trailer_xml);
506: dbms_lob.append(l_final_xml,l_temp_blob);
507:
508: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
509: hr_utility.trace('Closing l_final_xml' );
510: dbms_lob.close(l_final_xml);
511: END IF;
512: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
513: hr_utility.trace('Closing p_xml_blob' );

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

509: hr_utility.trace('Closing l_final_xml' );
510: dbms_lob.close(l_final_xml);
511: END IF;
512: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
513: hr_utility.trace('Closing p_xml_blob' );
514: dbms_lob.close(p_xml_blob);
515: END IF;
516: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
517: hr_utility.trace('Closing l_temp_blob' );

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

513: hr_utility.trace('Closing p_xml_blob' );
514: dbms_lob.close(p_xml_blob);
515: END IF;
516: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
517: hr_utility.trace('Closing l_temp_blob' );
518: dbms_lob.close(l_temp_blob);
519: END IF;
520: hr_utility.trace('In get_final_xml 60');
521:

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

516: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
517: hr_utility.trace('Closing l_temp_blob' );
518: dbms_lob.close(l_temp_blob);
519: END IF;
520: hr_utility.trace('In get_final_xml 60');
521:
522: else -- lv_negative_bal_flag = 'Y'
523: hr_utility.trace('Negative employee');
524: OPEN cur_get_meaning('NEG');

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

519: END IF;
520: hr_utility.trace('In get_final_xml 60');
521:
522: else -- lv_negative_bal_flag = 'Y'
523: hr_utility.trace('Negative employee');
524: OPEN cur_get_meaning('NEG');
525: FETCH cur_get_meaning
526: INTO l_err_msg;
527: CLOSE cur_get_meaning;

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

527: CLOSE cur_get_meaning;
528:
529: l_err_msg := 'Error:'||l_err_msg;
530: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
531: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
532:
533: IF l_is_temp_final_xml = 1 THEN
534: DBMS_LOB.FREETEMPORARY(l_final_xml);
535: END IF;

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

536:
537: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
538: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
539: l_final_xml := append_to_lob(l_err_msg);
540: hr_utility.trace('In get_final_xml 61');
541: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
542: hr_utility.trace('Closing l_final_xml' );
543: dbms_lob.close(l_final_xml);
544: END IF;

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

538: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
539: l_final_xml := append_to_lob(l_err_msg);
540: hr_utility.trace('In get_final_xml 61');
541: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
542: hr_utility.trace('Closing l_final_xml' );
543: dbms_lob.close(l_final_xml);
544: END IF;
545: hr_utility.trace('In get_final_xml 62');
546: end if;

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

541: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
542: hr_utility.trace('Closing l_final_xml' );
543: dbms_lob.close(l_final_xml);
544: END IF;
545: hr_utility.trace('In get_final_xml 62');
546: end if;
547: hr_utility.trace('In get_final_xml 65');
548: return l_final_xml;
549:

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

543: dbms_lob.close(l_final_xml);
544: END IF;
545: hr_utility.trace('In get_final_xml 62');
546: end if;
547: hr_utility.trace('In get_final_xml 65');
548: return l_final_xml;
549:
550: exception
551: when others then

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

548: return l_final_xml;
549:
550: exception
551: when others then
552: hr_utility.trace('In get_final_xml 70');
553:
554: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
555: hr_utility.trace('Raising exception and Closing l_final_xml' );
556: dbms_lob.close(l_final_xml);

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

551: when others then
552: hr_utility.trace('In get_final_xml 70');
553:
554: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
555: hr_utility.trace('Raising exception and Closing l_final_xml' );
556: dbms_lob.close(l_final_xml);
557: END IF;
558: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
559: hr_utility.trace('Raising exception and Closing p_xml_string' );

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

555: hr_utility.trace('Raising exception and Closing l_final_xml' );
556: dbms_lob.close(l_final_xml);
557: END IF;
558: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
559: hr_utility.trace('Raising exception and Closing p_xml_string' );
560: dbms_lob.close(p_xml_blob);
561: END IF;
562: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
563: hr_utility.trace('Closing l_temp_blob' );

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

559: hr_utility.trace('Raising exception and Closing p_xml_string' );
560: dbms_lob.close(p_xml_blob);
561: END IF;
562: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
563: hr_utility.trace('Closing l_temp_blob' );
564: dbms_lob.close(l_temp_blob);
565: END IF;
566:
567: hr_utility.trace('sqleerm ' || SQLERRM);

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

563: hr_utility.trace('Closing l_temp_blob' );
564: dbms_lob.close(l_temp_blob);
565: END IF;
566:
567: hr_utility.trace('sqleerm ' || SQLERRM);
568: raise;
569: end get_final_xml;
570:
571:

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

1245: lv_other_code6 := null;
1246: lv_other_amount6 := null;
1247:
1248: end loop;
1249: hr_utility.trace('calling from '||called_from);
1250: if trim(called_from) = 'get_asg_xml' then
1251: hr_utility.trace('before writing in magtape');
1252: pay_core_files.write_to_magtape_lob(l_employee_xml);
1253: hr_utility.trace('after writing in magtape');

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

1247:
1248: end loop;
1249: hr_utility.trace('calling from '||called_from);
1250: if trim(called_from) = 'get_asg_xml' then
1251: hr_utility.trace('before writing in magtape');
1252: pay_core_files.write_to_magtape_lob(l_employee_xml);
1253: hr_utility.trace('after writing in magtape');
1254: end if;
1255:

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

1249: hr_utility.trace('calling from '||called_from);
1250: if trim(called_from) = 'get_asg_xml' then
1251: hr_utility.trace('before writing in magtape');
1252: pay_core_files.write_to_magtape_lob(l_employee_xml);
1253: hr_utility.trace('after writing in magtape');
1254: end if;
1255:
1256: if trim(called_from) = 'get_final_xml' then
1257: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);

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

1263: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
1264: p_xml_blob := append_to_lob(l_employee_xml);
1265:
1266: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1267: hr_utility.trace('Closing p_xml_blob' );
1268: dbms_lob.close(p_xml_blob);
1269: hr_utility.trace('closed p_xml_blob');
1270: END IF;
1271: end if;

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

1265:
1266: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1267: hr_utility.trace('Closing p_xml_blob' );
1268: dbms_lob.close(p_xml_blob);
1269: hr_utility.trace('closed p_xml_blob');
1270: END IF;
1271: end if;
1272: hr_utility.trace('leaving fetch_t4_xml');
1273:

Line 1272: hr_utility.trace('leaving fetch_t4_xml');

1268: dbms_lob.close(p_xml_blob);
1269: hr_utility.trace('closed p_xml_blob');
1270: END IF;
1271: end if;
1272: hr_utility.trace('leaving fetch_t4_xml');
1273:
1274: exception
1275: when others then
1276: hr_utility.trace('sqleerm '|| sqlerrm);

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

1272: hr_utility.trace('leaving fetch_t4_xml');
1273:
1274: exception
1275: when others then
1276: hr_utility.trace('sqleerm '|| sqlerrm);
1277: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1278: hr_utility.trace('Closing p_xml_blob' );
1279: dbms_lob.close(p_xml_blob);
1280: END IF;

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

1274: exception
1275: when others then
1276: hr_utility.trace('sqleerm '|| sqlerrm);
1277: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1278: hr_utility.trace('Closing p_xml_blob' );
1279: dbms_lob.close(p_xml_blob);
1280: END IF;
1281: hr_utility.raise_error;
1282: end;

Line 1281: hr_utility.raise_error;

1277: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1278: hr_utility.trace('Closing p_xml_blob' );
1279: dbms_lob.close(p_xml_blob);
1280: END IF;
1281: hr_utility.raise_error;
1282: end;
1283:
1284:
1285: function create_xml_string (p_employer_name varchar2,

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

1480: --fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1481: l_single_xml := l_single_xml||''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1482: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1483:
1484: hr_utility.trace('XML string :' ||l_single_xml);
1485:
1486: return l_single_xml;
1487:
1488: exception

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

1486: return l_single_xml;
1487:
1488: exception
1489: when others then
1490: hr_utility.trace('sqleerm ' || sqlerrm);
1491: hr_utility.raise_error;
1492:
1493: end create_xml_string;
1494:

Line 1491: hr_utility.raise_error;

1487:
1488: exception
1489: when others then
1490: hr_utility.trace('sqleerm ' || sqlerrm);
1491: hr_utility.raise_error;
1492:
1493: end create_xml_string;
1494:
1495: procedure get_header_xml

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

1530: TEMP_UTL varchar2(512);
1531: l_log varchar2(100);
1532: l_out varchar2(100);
1533: begin
1534: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );
1535:
1536: if g_temp_dir is null then
1537: -- use first entry of utl_file_dir as the g_temp_dir
1538: select translate(ltrim(value),',',' ')

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

1551: if (TEMP_UTL is null or g_temp_dir is null ) then
1552: raise no_data_found;
1553: end if;
1554: end if;
1555: hr_utility.trace('In get_out_file,g_temp_dir ' ||g_temp_dir );
1556:
1557: FND_FILE.get_names(l_log,l_out);
1558:
1559: l_out := g_temp_dir ||'/'||l_out;

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

1556:
1557: FND_FILE.get_names(l_log,l_out);
1558:
1559: l_out := g_temp_dir ||'/'||l_out;
1560: hr_utility.trace('In get_out_file,l_out ' ||l_out );
1561:
1562: return l_out;
1563:
1564: exception

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

1583: open csr_get_iana_charset;
1584: fetch csr_get_iana_charset into lv_iana_charset;
1585: close csr_get_iana_charset;
1586:
1587: hr_utility.trace('IANA Charset = '||lv_iana_charset);
1588: return (lv_iana_charset);
1589:
1590: end get_IANA_charset;
1591: