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.BEN_EXT_XML_WRITE dependencies on UTL_FILE

Line 227: file_handle utl_file.file_type;

223: p_ext_rslt_id in number,
224: p_ext_dfn_tag in varchar2,
225: p_ext_file_tag in varchar2) is
226:
227: file_handle utl_file.file_type;
228: l_var varchar2(4000) ;
229: l_proc varchar2(72) := g_package||'write_style_sheet';
230: l_max_ext_line_size Number := 32767 ;
231: l_output_name ben_ext_rslt.output_name%type ;

Line 241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );

237: l_output_name := nvl(p_file_name, 'benxxssh') || '.xsl' ;
238: --
239:
240: hr_Utility.set_location('out put '||l_output_name|| ' / '|| p_drctry_name, 5);
241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');

Line 244: utl_file.put_line(file_handle, '');

240: hr_Utility.set_location('out put '||l_output_name|| ' / '|| p_drctry_name, 5);
241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');
247: utl_file.put_line(file_handle, ' ');
248:

Line 245: utl_file.put_line(file_handle, '');

241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');
247: utl_file.put_line(file_handle, ' ');
248:
249: hr_Utility.set_location(' after header ', 5);

Line 246: utl_file.put_line(file_handle, '');

242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');
247: utl_file.put_line(file_handle, ' ');
248:
249: hr_Utility.set_location(' after header ', 5);
250: l_var := '

Line 247: utl_file.put_line(file_handle, ' ');

243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');
247: utl_file.put_line(file_handle, ' ');
248:
249: hr_Utility.set_location(' after header ', 5);
250: l_var := '
251:

Line 260: utl_file.put_line(file_handle, l_var);

256: End Date :
257:
258:
259: ' ;
260: utl_file.put_line(file_handle, l_var);
261: -- this is record level , there can be multiple rec with diff tag so relative path is used
262: l_var := '
263:
264:

Line 269: utl_file.put_line(file_handle, l_var);

265:
266:
' ;
269: utl_file.put_line(file_handle, l_var);
270: l_var := '
271: ';
272: utl_file.put_line(file_handle, l_var);
273:

Line 272: utl_file.put_line(file_handle, l_var);

268: ' ;
269: utl_file.put_line(file_handle, l_var);
270: l_var := '
271: ';
272: utl_file.put_line(file_handle, l_var);
273:
274: for j in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
275: l_var := '
276:

Line 279: utl_file.put_line(file_handle, l_var);

275: l_var := '
276:
277:

278: ';
279: utl_file.put_line(file_handle, l_var);
280: end loop ;
281: l_var := '
282:
283:
Line 288: utl_file.put_line(file_handle, l_var);

284:
285:
286:
';
287:
288: utl_file.put_line(file_handle, l_var);
289: for j in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
290: l_var := '
291:
292:
Line 294: utl_file.put_line(file_handle, l_var);

290: l_var := '
291:
292:

293: ' ;
294: utl_file.put_line(file_handle, l_var);
295: end loop ;
296: l_var := '
297:
298:
Line 300: utl_file.put_line(file_handle, l_var);

296: l_var := '
297:
298:
299: ' ;
300: utl_file.put_line(file_handle, l_var);
301: l_var := '

267:
268:

302:
303: ' ;
304:

Line 306: utl_file.put_line(file_handle,l_var );

302:
303: ' ;
304:
305: hr_Utility.set_location('out put '||l_var, 5);
306: utl_file.put_line(file_handle,l_var );
307: ---
308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');
310: utl_file.put_line(file_handle, '');

Line 308: utl_file.put_line(file_handle, ' ');

304:
305: hr_Utility.set_location('out put '||l_var, 5);
306: utl_file.put_line(file_handle,l_var );
307: ---
308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');
310: utl_file.put_line(file_handle, '');
311: ---
312: utl_file.fclose(file_handle);

Line 309: utl_file.put_line(file_handle, '');

305: hr_Utility.set_location('out put '||l_var, 5);
306: utl_file.put_line(file_handle,l_var );
307: ---
308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');
310: utl_file.put_line(file_handle, '');
311: ---
312: utl_file.fclose(file_handle);
313:

Line 310: utl_file.put_line(file_handle, '');

306: utl_file.put_line(file_handle,l_var );
307: ---
308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');
310: utl_file.put_line(file_handle, '');
311: ---
312: utl_file.fclose(file_handle);
313:
314: -- write to logfile the record count

Line 312: utl_file.fclose(file_handle);

308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');
310: utl_file.put_line(file_handle, '');
311: ---
312: utl_file.fclose(file_handle);
313:
314: -- write to logfile the record count
315: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');
316: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;

Line 330: file_handle utl_file.file_type;

326: p_ext_rslt_id in number,
327: p_ext_dfn_tag in varchar2,
328: p_ext_file_tag in varchar2) is
329:
330: file_handle utl_file.file_type;
331: l_var varchar2(4000) ;
332: l_proc varchar2(72) := g_package||'write_schema';
333: l_max_ext_line_size Number := 32767 ;
334: l_output_name ben_ext_rslt.output_name%type ;

Line 344: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );

340: l_output_name := nvl(p_file_name,'benxxsch' ) || '.xsd' ;
341: --l_output_name := 'benxxsch.xsd' ;
342:
343: --
344: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
345: --- Write the xml header
346: utl_file.put_line(file_handle, '');
347: utl_file.put_line(file_handle, '');
348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');

Line 346: utl_file.put_line(file_handle, '');

342:
343: --
344: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
345: --- Write the xml header
346: utl_file.put_line(file_handle, '');
347: utl_file.put_line(file_handle, '');
348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');
349: -- utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext">');
350: ----- Element Type

Line 347: utl_file.put_line(file_handle, '');

343: --
344: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
345: --- Write the xml header
346: utl_file.put_line(file_handle, '');
347: utl_file.put_line(file_handle, '');
348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');
349: -- utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext">');
350: ----- Element Type
351: for i in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop

Line 348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');

344: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
345: --- Write the xml header
346: utl_file.put_line(file_handle, '');
347: utl_file.put_line(file_handle, '');
348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');
349: -- utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext">');
350: ----- Element Type
351: for i in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
352: l_var := '

Line 349: -- utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext">');

345: --- Write the xml header
346: utl_file.put_line(file_handle, '');
347: utl_file.put_line(file_handle, '');
348: -- utl_file.put_line(file_handle, ' targetNamespace="http://www.oracle.com/xml/OAB/ext"');
349: -- utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext">');
350: ----- Element Type
351: for i in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
352: l_var := '
353:

Line 367: utl_file.put_line(file_handle,l_var );

363:
364:
365:
366: ' ;
367: utl_file.put_line(file_handle,l_var );
368: end loop ;
369:
370: ---- Creating for the record set
371: l_var :='

Line 375: utl_file.put_line(file_handle,l_var );

371: l_var :='
372:
373:
374: ' ;
375: utl_file.put_line(file_handle,l_var );
376: for i in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
377: l_var := ' ' ;
378: utl_file.put_line(file_handle,l_var );
379: end loop ;

Line 378: utl_file.put_line(file_handle,l_var );

374: ' ;
375: utl_file.put_line(file_handle,l_var );
376: for i in g_elmt_tag_tbl.first .. g_elmt_tag_tbl.last loop
377: l_var := ' ' ;
378: utl_file.put_line(file_handle,l_var );
379: end loop ;
380: l_var := '
381:
382:

Line 385: utl_file.put_line(file_handle,l_var );

381:
382:
383:
384: ' ;
385: utl_file.put_line(file_handle,l_var );
386:
387:
388: --- Creating for the records
389: for i in g_rcd_tag_tbl.first .. g_rcd_tag_tbl.last loop

Line 402: utl_file.put_line(file_handle,l_var );

398:
399:
400:
401: ' ;
402: utl_file.put_line(file_handle,l_var );
403: end loop ;
404:
405:
406: --- File type

Line 411: utl_file.put_line(file_handle,l_var );

407: l_var := '
408:
409:
410: ';
411: utl_file.put_line(file_handle,l_var );
412: for i in g_rcd_tag_tbl.first .. g_rcd_tag_tbl.last loop
413: l_var := ' ' ;
414: utl_file.put_line(file_handle,l_var );
415: end loop;

Line 414: utl_file.put_line(file_handle,l_var );

410: ';
411: utl_file.put_line(file_handle,l_var );
412: for i in g_rcd_tag_tbl.first .. g_rcd_tag_tbl.last loop
413: l_var := ' ' ;
414: utl_file.put_line(file_handle,l_var );
415: end loop;
416: l_var := '
417:
418:

Line 423: utl_file.put_line(file_handle, l_var);

419:
420:
421: ' ;
422:
423: utl_file.put_line(file_handle, l_var);
424:
425:
426:
427:

Line 435: utl_file.put_line(file_handle,l_var );

431: l_var := '
432:
433:
434: ';
435: utl_file.put_line(file_handle,l_var );
436: l_var := ' ' ;
437: utl_file.put_line(file_handle,l_var );
438: l_var := '
439:

Line 437: utl_file.put_line(file_handle,l_var );

433:
434: ';
435: utl_file.put_line(file_handle,l_var );
436: l_var := ' ' ;
437: utl_file.put_line(file_handle,l_var );
438: l_var := '
439:
440:
441:

Line 448: utl_file.put_line(file_handle, l_var);

444:
445:
446: ' ;
447:
448: utl_file.put_line(file_handle, l_var);
449: l_var := '
450:
451:
452:

Line 460: utl_file.put_line(file_handle,l_var );

456:
457: ' ;
458:
459: --- Closing Root
460: utl_file.put_line(file_handle,l_var );
461: --- Closing the file
462: utl_file.fclose(file_handle);
463:
464: -- write to logfile the record count

Line 462: utl_file.fclose(file_handle);

458:
459: --- Closing Root
460: utl_file.put_line(file_handle,l_var );
461: --- Closing the file
462: utl_file.fclose(file_handle);
463:
464: -- write to logfile the record count
465: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');
466: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;

Line 1189: file_handle utl_file.file_type;

1185: p_source in varchar2 default 'BENXWRIT' ) is
1186:
1187: --
1188: --
1189: file_handle utl_file.file_type;
1190: --
1191: cursor c_xrd is
1192: select xrd.ext_rcd_id,
1193: xrd.person_id,

Line 1744: file_handle := utl_file.fopen (l_directory_name ,l_output_name,'w' , l_max_ext_line_size );

1740: end if ;
1741:
1742:
1743: if l_cm_display_flag <> 'Y' then
1744: file_handle := utl_file.fopen (l_directory_name ,l_output_name,'w' , l_max_ext_line_size );
1745: end if ;
1746:
1747: g_dfn_tag := nvl(l_ext_file.xml_tag_name,l_dfn_defa_tag) ;
1748: g_file_tag := nvl(l_ext_file.file_xml_tag_name,l_file_defa_tag ) ;

Line 1757: utl_file.put_line(file_handle, l_var);

1753: l_var := l_var || '<'||nvl(l_ext_file.xml_tag_name,l_dfn_defa_tag )||'>' ;
1754: if l_cm_display_flag = 'Y' then
1755: fnd_file.put_line(fnd_file.OUTPUT, l_var);
1756: else
1757: utl_file.put_line(file_handle, l_var);
1758: end if ;
1759: else
1760: --- Write the xml header
1761: if l_cm_display_flag = 'Y' then

Line 1764: utl_file.put_line(file_handle, '');

1760: --- Write the xml header
1761: if l_cm_display_flag = 'Y' then
1762: fnd_file.put_line(fnd_file.OUTPUT, '');
1763: else
1764: utl_file.put_line(file_handle, '');
1765: end if ;
1766:
1767: --utl_file.put_line(file_handle, '');
1768: -- Write the refference to style sheet, assume the style sheet in current directory

Line 1767: --utl_file.put_line(file_handle, '');

1763: else
1764: utl_file.put_line(file_handle, '');
1765: end if ;
1766:
1767: --utl_file.put_line(file_handle, '');
1768: -- Write the refference to style sheet, assume the style sheet in current directory
1769: if l_cm_display_flag = 'Y' then
1770: null ;
1771: --fnd_file.put_line(fnd_file.OUTPUT, '');

Line 1774: utl_file.put_line(file_handle, '');

1770: null ;
1771: --fnd_file.put_line(fnd_file.OUTPUT, '');
1772: else
1773:
1774: utl_file.put_line(file_handle, '');
1775: end if ;
1776:
1777: -- utl_file.put_line(file_handle, '');
1778:

Line 1777: -- utl_file.put_line(file_handle, '');

1773:
1774: utl_file.put_line(file_handle, '');
1775: end if ;
1776:
1777: -- utl_file.put_line(file_handle, '');
1778:
1779: -- write the xml root element with reference to Schemea , the assumption is
1780: -- again the schema doc is avaialble in currect dir
1781:

Line 1784: --utl_file.put_line(file_handle, l_var);

1780: -- again the schema doc is avaialble in currect dir
1781:
1782: --l_var:=' 1783: --l_var:='<'||nvl(l_ext_file.xml_tag_name,l_dfn_defa_tag )||' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ' ;
1784: --utl_file.put_line(file_handle, l_var);
1785:
1786: --if l_cm_display_flag = 'Y' then
1787: -- fnd_file.put_line(fnd_file.OUTPUT, l_var);
1788: --else

Line 1789: -- utl_file.put_line(file_handle, l_var);

1785:
1786: --if l_cm_display_flag = 'Y' then
1787: -- fnd_file.put_line(fnd_file.OUTPUT, l_var);
1788: --else
1789: -- utl_file.put_line(file_handle, l_var);
1790: -- end if ;
1791:
1792: ---utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext" ');
1793: --- utl_file.put_line(file_handle, ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ');

Line 1792: ---utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext" ');

1788: --else
1789: -- utl_file.put_line(file_handle, l_var);
1790: -- end if ;
1791:
1792: ---utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext" ');
1793: --- utl_file.put_line(file_handle, ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ');
1794: l_var:='<'||nvl(l_ext_file.xml_tag_name,l_dfn_defa_tag )||' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ' ;
1795: if l_cm_display_flag = 'Y' then
1796: --fnd_file.put_line(fnd_file.OUTPUT, l_var);

Line 1793: --- utl_file.put_line(file_handle, ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ');

1789: -- utl_file.put_line(file_handle, l_var);
1790: -- end if ;
1791:
1792: ---utl_file.put_line(file_handle, ' xmlns="http://www.oracle.com/xml/OAB/ext" ');
1793: --- utl_file.put_line(file_handle, ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ');
1794: l_var:='<'||nvl(l_ext_file.xml_tag_name,l_dfn_defa_tag )||' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ' ;
1795: if l_cm_display_flag = 'Y' then
1796: --fnd_file.put_line(fnd_file.OUTPUT, l_var);
1797: --fnd_file.put_line(fnd_file.OUTPUT, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');

Line 1800: utl_file.put_line(file_handle, l_var);

1796: --fnd_file.put_line(fnd_file.OUTPUT, l_var);
1797: --fnd_file.put_line(fnd_file.OUTPUT, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');
1798: null ;
1799: else
1800: utl_file.put_line(file_handle, l_var);
1801: utl_file.put_line(file_handle, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');
1802: end if ;
1803:
1804: end if ;

Line 1801: utl_file.put_line(file_handle, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');

1797: --fnd_file.put_line(fnd_file.OUTPUT, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');
1798: null ;
1799: else
1800: utl_file.put_line(file_handle, l_var);
1801: utl_file.put_line(file_handle, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');
1802: end if ;
1803:
1804: end if ;
1805:

Line 1813: --utl_file.put_line(file_handle, l_var );

1809: 'effective_date="'||l_ext_file.eff_dt|| '" '||
1810: 'start_time="' || l_ext_file.run_strt_dt || '" '||
1811: 'end_time="' || l_ext_file.run_end_dt || '" > ' ;
1812:
1813: --utl_file.put_line(file_handle, l_var );
1814:
1815: if l_cm_display_flag = 'Y' then
1816: fnd_file.put_line(fnd_file.OUTPUT, l_var);
1817: else

Line 1818: utl_file.put_line(file_handle, l_var);

1814:
1815: if l_cm_display_flag = 'Y' then
1816: fnd_file.put_line(fnd_file.OUTPUT, l_var);
1817: else
1818: utl_file.put_line(file_handle, l_var);
1819: end if ;
1820:
1821: p_rec_count := 0 ;
1822: ---- Loop the the record

Line 2154: utl_file.put_line(file_handle, '');

2150:
2151: if l_cm_display_flag = 'Y' then
2152: fnd_file.put_line(fnd_file.OUTPUT, '');
2153: else
2154: utl_file.put_line(file_handle, '');
2155: end if ;
2156:
2157: --utl_file.put_line(file_handle, '');
2158: ---- whether close the lowlevel code

Line 2157: --utl_file.put_line(file_handle, '');

2153: else
2154: utl_file.put_line(file_handle, '');
2155: end if ;
2156:
2157: --utl_file.put_line(file_handle, '');
2158: ---- whether close the lowlevel code
2159: end if ;
2160: end if ;
2161: end if ;

Line 2187: --utl_file.put_line(file_handle, l_var );

2183: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;
2184: l_low_lvl_name := get_low_lvl_name(l_prv_low_lvl_cd) ;
2185: hr_utility.set_location(' close level ' || l_low_lvl_name , 99 );
2186: l_var:= ' ' ;
2187: --utl_file.put_line(file_handle, l_var );
2188: if l_cm_display_flag = 'Y' then
2189: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2190: else
2191: utl_file.put_line(file_handle, l_var);

Line 2191: utl_file.put_line(file_handle, l_var);

2187: --utl_file.put_line(file_handle, l_var );
2188: if l_cm_display_flag = 'Y' then
2189: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2190: else
2191: utl_file.put_line(file_handle, l_var);
2192: end if ;
2193: add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;
2194: end loop ;
2195: --- if previous level si 'p' assume the loop completed

Line 2203: --utl_file.put_line(file_handle, '');

2199: l_prv_low_lvl_cd := null ;
2200: end if ;
2201: else
2202: -- l_Low_lvl_grouping
2203: --utl_file.put_line(file_handle, '');
2204: if l_cm_display_flag = 'Y' then
2205: fnd_file.put_line(fnd_file.OUTPUT, '' );
2206: else
2207: utl_file.put_line(file_handle, '' );

Line 2207: utl_file.put_line(file_handle, '' );

2203: --utl_file.put_line(file_handle, '');
2204: if l_cm_display_flag = 'Y' then
2205: fnd_file.put_line(fnd_file.OUTPUT, '' );
2206: else
2207: utl_file.put_line(file_handle, '' );
2208: end if ;
2209: end if ;
2210: end if ;
2211: end if ;

Line 2223: --utl_file.put_line(file_handle, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||

2219: open c_per_info(l_xrd.person_id,l_ext_file.eff_dt) ;
2220: fetch c_per_info into l_name, l_employee_number ;
2221: close c_per_info ;
2222: if l_Low_lvl_grouping = 'N' then
2223: --utl_file.put_line(file_handle, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||
2224: -- '" employee_number="'|| l_employee_number||'">');
2225: if l_cm_display_flag = 'Y' then
2226: fnd_file.put_line(fnd_file.OUTPUT, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||
2227: '" employee_number="'|| l_employee_number||'">');

Line 2229: utl_file.put_line(file_handle, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||

2225: if l_cm_display_flag = 'Y' then
2226: fnd_file.put_line(fnd_file.OUTPUT, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||
2227: '" employee_number="'|| l_employee_number||'">');
2228: else
2229: utl_file.put_line(file_handle, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||
2230: '" employee_number="'|| l_employee_number||'">');
2231: end if ;
2232:
2233: end if ;

Line 2276: --utl_file.put_line(file_handle, l_var );

2272: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2273: l_var := '<'||l_low_lvl_name || ' Low_Level_Code="' ||l_ext_rcd.low_lvl_cd || '"> ' ;
2274: end if ;
2275:
2276: --utl_file.put_line(file_handle, l_var );
2277: if l_cm_display_flag = 'Y' then
2278: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2279: else
2280: utl_file.put_line(file_handle, l_var);

Line 2280: utl_file.put_line(file_handle, l_var);

2276: --utl_file.put_line(file_handle, l_var );
2277: if l_cm_display_flag = 'Y' then
2278: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2279: else
2280: utl_file.put_line(file_handle, l_var);
2281: end if ;
2282:
2283: add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
2284: l_prv_low_lvl_cd := l_ext_rcd.low_lvl_cd ;

Line 2301: --utl_file.put_line(file_handle, l_var );

2297: nvl(l_xrd.group_val_01,'-1') = nvl(g_prev_grop_val,'-1') then
2298: -- close the previous element and open a new element
2299: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2300: l_var:= ' ' ;
2301: --utl_file.put_line(file_handle, l_var );
2302: if l_cm_display_flag = 'Y' then
2303: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2304: else
2305: utl_file.put_line(file_handle, l_var);

Line 2305: utl_file.put_line(file_handle, l_var);

2301: --utl_file.put_line(file_handle, l_var );
2302: if l_cm_display_flag = 'Y' then
2303: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2304: else
2305: utl_file.put_line(file_handle, l_var);
2306: end if ;
2307: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2308: l_var := '<'||l_low_lvl_name || ' Low_Level_Code="'|| l_ext_rcd.low_lvl_cd || '"> ' ;
2309: --utl_file.put_line(file_handle, l_var );

Line 2309: --utl_file.put_line(file_handle, l_var );

2305: utl_file.put_line(file_handle, l_var);
2306: end if ;
2307: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2308: l_var := '<'||l_low_lvl_name || ' Low_Level_Code="'|| l_ext_rcd.low_lvl_cd || '"> ' ;
2309: --utl_file.put_line(file_handle, l_var );
2310: if l_cm_display_flag = 'Y' then
2311: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2312: else
2313: utl_file.put_line(file_handle, l_var);

Line 2313: utl_file.put_line(file_handle, l_var);

2309: --utl_file.put_line(file_handle, l_var );
2310: if l_cm_display_flag = 'Y' then
2311: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2312: else
2313: utl_file.put_line(file_handle, l_var);
2314: end if ;
2315:
2316: l_prev_levl_found := 'Y' ;
2317: exit ;

Line 2322: --utl_file.put_line(file_handle, l_var );

2318:
2319: elsif (determine_sub_low_lvl(l_prv_low_lvl_cd,l_ext_rcd.low_lvl_cd,l_xrd.group_val_01)) ='Y' then
2320: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2321: l_var := '<'||l_low_lvl_name || ' Low_Level_Code="'|| l_ext_rcd.low_lvl_cd || '"> ' ;
2322: --utl_file.put_line(file_handle, l_var );
2323: if l_cm_display_flag = 'Y' then
2324: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2325: else
2326: utl_file.put_line(file_handle, l_var);

Line 2326: utl_file.put_line(file_handle, l_var);

2322: --utl_file.put_line(file_handle, l_var );
2323: if l_cm_display_flag = 'Y' then
2324: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2325: else
2326: utl_file.put_line(file_handle, l_var);
2327: end if ;
2328: add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
2329: l_prv_low_lvl_cd := l_ext_rcd.low_lvl_cd ;
2330: l_prev_levl_found := 'Y' ;

Line 2337: --utl_file.put_line(file_handle, l_var );

2333: add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;
2334: l_low_lvl_name := get_low_lvl_name(l_prv_low_lvl_cd) ;
2335: hr_utility.set_location( ' closingi prv levl ' || l_low_lvl_name , 99 ) ;
2336: l_var:= ' ' ;
2337: --utl_file.put_line(file_handle, l_var );
2338: if l_cm_display_flag = 'Y' then
2339: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2340: else
2341: utl_file.put_line(file_handle, l_var);

Line 2341: utl_file.put_line(file_handle, l_var);

2337: --utl_file.put_line(file_handle, l_var );
2338: if l_cm_display_flag = 'Y' then
2339: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2340: else
2341: utl_file.put_line(file_handle, l_var);
2342: end if ;
2343:
2344: end if ;
2345: end loop ;

Line 2350: --utl_file.put_line(file_handle, l_var );

2346: --- if the previous level not found then it is the new level
2347: if l_prev_levl_found = 'N' then
2348: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;
2349: l_var := '<'||l_low_lvl_name || ' Low_Level_Code="'|| l_ext_rcd.low_lvl_cd || '"> ' ;
2350: --utl_file.put_line(file_handle, l_var );
2351: if l_cm_display_flag = 'Y' then
2352: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2353: else
2354: utl_file.put_line(file_handle, l_var);

Line 2354: utl_file.put_line(file_handle, l_var);

2350: --utl_file.put_line(file_handle, l_var );
2351: if l_cm_display_flag = 'Y' then
2352: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2353: else
2354: utl_file.put_line(file_handle, l_var);
2355: end if ;
2356: add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
2357: l_prv_low_lvl_cd := l_ext_rcd.low_lvl_cd ;
2358: end if ;

Line 2371: --utl_file.put_line(file_handle, l_var );

2367: l_var:= '<'||nvl(l_ext_rcd.xml_tag_name,l_rcd_defa_tag)||' ext_rec_name="'||l_ext_rcd.name || '" '||
2368: 'ext_rec_seq="' || l_ext_rcd.seq_num || '" '||
2369: 'ext_rec_type="'||l_ext_rcd.rcd_type_cd || '" '||
2370: 'ext_rec_person="'||l_xrd.person_id || '" > ' ;
2371: --utl_file.put_line(file_handle, l_var );
2372: if l_cm_display_flag = 'Y' then
2373: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2374: else
2375: utl_file.put_line(file_handle, l_var);

Line 2375: utl_file.put_line(file_handle, l_var);

2371: --utl_file.put_line(file_handle, l_var );
2372: if l_cm_display_flag = 'Y' then
2373: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2374: else
2375: utl_file.put_line(file_handle, l_var);
2376: end if ;
2377: load_tags(p_tag_table => g_rcd_tag_tbl ,
2378: p_tag => nvl(l_ext_rcd.xml_tag_name,l_rcd_defa_tag)
2379: ) ;

Line 2394: --utl_file.put_line(file_handle, l_var);

2390: l_var:= '<'||nvl(l_ext_rcd.xml_tag_name,l_rcd_defa_tag)|| '>' ;
2391: else
2392: l_var:= '' ;
2393: end if ;
2394: --utl_file.put_line(file_handle, l_var);
2395: if l_cm_display_flag = 'Y' then
2396: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2397: else
2398: utl_file.put_line(file_handle, l_var);

Line 2398: utl_file.put_line(file_handle, l_var);

2394: --utl_file.put_line(file_handle, l_var);
2395: if l_cm_display_flag = 'Y' then
2396: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2397: else
2398: utl_file.put_line(file_handle, l_var);
2399: end if ;
2400: --
2401:
2402: open c_elmt (l_xrd.ext_rcd_id) ;

Line 2431: --utl_file.put_line(file_handle, l_var );

2427:
2428: l_var := l_var|| '>'||l_elm_val||'';
2429: --
2430:
2431: --utl_file.put_line(file_handle, l_var );
2432: if l_cm_display_flag = 'Y' then
2433: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2434: else
2435: utl_file.put_line(file_handle, l_var);

Line 2435: utl_file.put_line(file_handle, l_var);

2431: --utl_file.put_line(file_handle, l_var );
2432: if l_cm_display_flag = 'Y' then
2433: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2434: else
2435: utl_file.put_line(file_handle, l_var);
2436: end if ;
2437:
2438: Load_tags(p_tag_table => g_elmt_tag_tbl ,
2439: p_tag => nvl(l_elm_xml_tag_name,l_elmt_defa_tag)

Line 2451: --utl_file.put_line(file_handle,l_var );

2447: else
2448: l_var:= '' ;
2449: end if ;
2450:
2451: --utl_file.put_line(file_handle,l_var );
2452: if l_cm_display_flag = 'Y' then
2453: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2454: else
2455: utl_file.put_line(file_handle, l_var);

Line 2455: utl_file.put_line(file_handle, l_var);

2451: --utl_file.put_line(file_handle,l_var );
2452: if l_cm_display_flag = 'Y' then
2453: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2454: else
2455: utl_file.put_line(file_handle, l_var);
2456: end if ;
2457: end if ;
2458:
2459: end loop ;

Line 2468: --utl_file.put_line(file_handle, l_var );

2464: for j in REVERSE 1 .. g_low_lvl_tbl.count loop
2465: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;
2466: l_low_lvl_name := get_low_lvl_name(l_prv_low_lvl_cd) ;
2467: l_var:= ' ' ;
2468: --utl_file.put_line(file_handle, l_var );
2469: if l_cm_display_flag = 'Y' then
2470: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2471: else
2472: utl_file.put_line(file_handle, l_var);

Line 2472: utl_file.put_line(file_handle, l_var);

2468: --utl_file.put_line(file_handle, l_var );
2469: if l_cm_display_flag = 'Y' then
2470: fnd_file.put_line(fnd_file.OUTPUT, l_var);
2471: else
2472: utl_file.put_line(file_handle, l_var);
2473: end if ;
2474: end loop ;
2475: g_low_lvl_tbl.delete ;
2476: else

Line 2477: --utl_file.put_line(file_handle, '');

2473: end if ;
2474: end loop ;
2475: g_low_lvl_tbl.delete ;
2476: else
2477: --utl_file.put_line(file_handle, '');
2478: if l_cm_display_flag = 'Y' then
2479: fnd_file.put_line(fnd_file.OUTPUT, '');
2480: fnd_file.put_line(fnd_file.OUTPUT, '' );
2481: else

Line 2482: utl_file.put_line(file_handle, '');

2478: if l_cm_display_flag = 'Y' then
2479: fnd_file.put_line(fnd_file.OUTPUT, '');
2480: fnd_file.put_line(fnd_file.OUTPUT, '' );
2481: else
2482: utl_file.put_line(file_handle, '');
2483: utl_file.put_line(file_handle, '');
2484: end if ;
2485: -- l_Low_lvl_grouping
2486: --utl_file.put_line(file_handle, '');

Line 2483: utl_file.put_line(file_handle, '');

2479: fnd_file.put_line(fnd_file.OUTPUT, '');
2480: fnd_file.put_line(fnd_file.OUTPUT, '' );
2481: else
2482: utl_file.put_line(file_handle, '');
2483: utl_file.put_line(file_handle, '');
2484: end if ;
2485: -- l_Low_lvl_grouping
2486: --utl_file.put_line(file_handle, '');
2487: end if ;

Line 2486: --utl_file.put_line(file_handle, '');

2482: utl_file.put_line(file_handle, '');
2483: utl_file.put_line(file_handle, '');
2484: end if ;
2485: -- l_Low_lvl_grouping
2486: --utl_file.put_line(file_handle, '');
2487: end if ;
2488:
2489: --utl_file.put_line(file_handle,l_var );
2490: if l_cm_display_flag = 'Y' then

Line 2489: --utl_file.put_line(file_handle,l_var );

2485: -- l_Low_lvl_grouping
2486: --utl_file.put_line(file_handle, '');
2487: end if ;
2488:
2489: --utl_file.put_line(file_handle,l_var );
2490: if l_cm_display_flag = 'Y' then
2491: fnd_file.put_line(fnd_file.OUTPUT, '' );
2492: --fnd_file.put_line(fnd_file.OUTPUT, '');
2493: if p_output_type <> 'X' then

Line 2497: utl_file.put_line(file_handle, '');

2493: if p_output_type <> 'X' then
2494: fnd_file.put_line(fnd_file.OUTPUT, '' );
2495: end if ;
2496: else
2497: utl_file.put_line(file_handle, '');
2498: --utl_file.put_line(file_handle, '');
2499: utl_file.put_line(file_handle, '');
2500: utl_file.fclose(file_handle);
2501: end if;

Line 2498: --utl_file.put_line(file_handle, '');

2494: fnd_file.put_line(fnd_file.OUTPUT, '' );
2495: end if ;
2496: else
2497: utl_file.put_line(file_handle, '');
2498: --utl_file.put_line(file_handle, '');
2499: utl_file.put_line(file_handle, '');
2500: utl_file.fclose(file_handle);
2501: end if;
2502:

Line 2499: utl_file.put_line(file_handle, '');

2495: end if ;
2496: else
2497: utl_file.put_line(file_handle, '');
2498: --utl_file.put_line(file_handle, '');
2499: utl_file.put_line(file_handle, '');
2500: utl_file.fclose(file_handle);
2501: end if;
2502:
2503:

Line 2500: utl_file.fclose(file_handle);

2496: else
2497: utl_file.put_line(file_handle, '');
2498: --utl_file.put_line(file_handle, '');
2499: utl_file.put_line(file_handle, '');
2500: utl_file.fclose(file_handle);
2501: end if;
2502:
2503:
2504: if p_output_type <> 'X' and l_cm_display_flag <> 'Y' then --- pdf

Line 2555: WHEN utl_file.invalid_path then

2551: --
2552: --
2553: EXCEPTION
2554: --
2555: WHEN utl_file.invalid_path then
2556: fnd_message.set_name('BEN', 'BEN_92254_UTL_INVLD_PATH');
2557: fnd_file.put_line(fnd_file.log, fnd_message.get);
2558: fnd_message.raise_error;
2559: --

Line 2560: WHEN utl_file.invalid_mode then

2556: fnd_message.set_name('BEN', 'BEN_92254_UTL_INVLD_PATH');
2557: fnd_file.put_line(fnd_file.log, fnd_message.get);
2558: fnd_message.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: fnd_message.set_name('BEN', 'BEN_92249_UTL_INVLD_MODE');
2562: fnd_file.put_line(fnd_file.log, fnd_message.get);
2563: fnd_message.raise_error;
2564: --

Line 2565: WHEN utl_file.invalid_filehandle then

2561: fnd_message.set_name('BEN', 'BEN_92249_UTL_INVLD_MODE');
2562: fnd_file.put_line(fnd_file.log, fnd_message.get);
2563: fnd_message.raise_error;
2564: --
2565: WHEN utl_file.invalid_filehandle then
2566: fnd_message.set_name('BEN', 'BEN_92250_UTL_INVLD_FILEHANDLE');
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
2568: fnd_message.raise_error;
2569: --

Line 2570: WHEN utl_file.invalid_operation then

2566: fnd_message.set_name('BEN', 'BEN_92250_UTL_INVLD_FILEHANDLE');
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
2568: fnd_message.raise_error;
2569: --
2570: WHEN utl_file.invalid_operation then
2571: fnd_message.set_name('BEN', 'BEN_92251_UTL_INVLD_OPER');
2572: fnd_file.put_line(fnd_file.log, fnd_message.get);
2573: fnd_message.raise_error;
2574: --

Line 2575: WHEN utl_file.read_error then

2571: fnd_message.set_name('BEN', 'BEN_92251_UTL_INVLD_OPER');
2572: fnd_file.put_line(fnd_file.log, fnd_message.get);
2573: fnd_message.raise_error;
2574: --
2575: WHEN utl_file.read_error then
2576: fnd_message.set_name('BEN', 'BEN_92252_UTL_READ_ERROR');
2577: fnd_file.put_line(fnd_file.log, fnd_message.get);
2578: fnd_message.raise_error;
2579: --