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 FND_FILE

Line 316: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;

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 ) ;
317: hr_utility.set_location('Exiting'||l_proc, 15);
318:
319: END write_style_sheet;
320:

Line 466: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;

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 ) ;
467: hr_utility.set_location('Exiting'||l_proc, 15);
468:
469:
470:

Line 1755: fnd_file.put_line(fnd_file.OUTPUT, l_var);

1751:
1752: 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

Line 1762: fnd_file.put_line(fnd_file.OUTPUT, '');

1758: end if ;
1759: else
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:

Line 1771: --fnd_file.put_line(fnd_file.OUTPUT, '');

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, '');
1772: else
1773:
1774: utl_file.put_line(file_handle, '');
1775: end if ;

Line 1787: -- fnd_file.put_line(fnd_file.OUTPUT, 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
1789: -- utl_file.put_line(file_handle, l_var);
1790: -- end if ;
1791:

Line 1796: --fnd_file.put_line(fnd_file.OUTPUT, l_var);

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">');
1798: null ;
1799: else
1800: utl_file.put_line(file_handle, l_var);

Line 1797: --fnd_file.put_line(fnd_file.OUTPUT, ' xsi:noNamespaceSchemaLocation="'|| nvl(l_file_name,'benxxsch')||'.xsd">');

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">');
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">');

Line 1816: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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
1818: utl_file.put_line(file_handle, l_var);
1819: end if ;
1820:

Line 2152: fnd_file.put_line(fnd_file.OUTPUT, '');

2148: if l_new_rec <> -1 then
2149: hr_utility.set_location(' close record ' || l_ext_rcd.xml_tag_name , 99 );
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:

Line 2189: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2192: end if ;
2193: add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;

Line 2205: fnd_file.put_line(fnd_file.OUTPUT, '' );

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, '' );
2208: end if ;
2209: end if ;

Line 2226: fnd_file.put_line(fnd_file.OUTPUT, '<'||'oabext_person_record_set'||' person_name="'||ext_xml_encode(l_name)||

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||'">');
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||'">');

Line 2278: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2281: end if ;
2282:

Line 2303: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2306: end if ;
2307: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;

Line 2311: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2314: end if ;
2315:

Line 2324: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2327: end if ;
2328: add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;

Line 2339: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2342: end if ;
2343:

Line 2352: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2355: end if ;
2356: add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;

Line 2373: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2376: end if ;
2377: load_tags(p_tag_table => g_rcd_tag_tbl ,

Line 2396: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2399: end if ;
2400: --

Line 2433: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2436: end if ;
2437:

Line 2453: fnd_file.put_line(fnd_file.OUTPUT, 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);
2456: end if ;
2457: end if ;

Line 2470: fnd_file.put_line(fnd_file.OUTPUT, l_var);

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);
2473: end if ;
2474: end loop ;

Line 2479: fnd_file.put_line(fnd_file.OUTPUT, '');

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
2482: utl_file.put_line(file_handle, '');
2483: utl_file.put_line(file_handle, '');

Line 2480: fnd_file.put_line(fnd_file.OUTPUT, '' );

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
2482: utl_file.put_line(file_handle, '');
2483: utl_file.put_line(file_handle, '');
2484: end if ;

Line 2491: fnd_file.put_line(fnd_file.OUTPUT, '' );

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
2494: fnd_file.put_line(fnd_file.OUTPUT, '' );
2495: end if ;

Line 2492: --fnd_file.put_line(fnd_file.OUTPUT, '');

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
2494: fnd_file.put_line(fnd_file.OUTPUT, '' );
2495: end if ;
2496: else

Line 2494: fnd_file.put_line(fnd_file.OUTPUT, '' );

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
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, '');

Line 2557: fnd_file.put_line(fnd_file.log, fnd_message.get);

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: --
2560: WHEN utl_file.invalid_mode then
2561: fnd_message.set_name('BEN', 'BEN_92249_UTL_INVLD_MODE');

Line 2562: 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: --
2565: WHEN utl_file.invalid_filehandle then
2566: fnd_message.set_name('BEN', 'BEN_92250_UTL_INVLD_FILEHANDLE');

Line 2567: 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: --
2570: WHEN utl_file.invalid_operation then
2571: fnd_message.set_name('BEN', 'BEN_92251_UTL_INVLD_OPER');

Line 2572: 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: --
2575: WHEN utl_file.read_error then
2576: fnd_message.set_name('BEN', 'BEN_92252_UTL_READ_ERROR');

Line 2577: 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: --
2580:
2581: WHEN others THEN

Line 2585: fnd_file.put_line(fnd_file.log, fnd_message.get);

2581: WHEN others THEN
2582: hr_utility.set_location( 'other exception raised ' , 99 ) ;
2583: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2584: fnd_message.set_token('2',substr(sqlerrm,1,200));
2585: fnd_file.put_line(fnd_file.log, fnd_message.get);
2586: fnd_message.raise_error;
2587: --
2588: END ;
2589: --