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 ) ;
317: hr_utility.set_location('Exiting'||l_proc, 15);
318:
319: END write_style_sheet;
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:
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 ) ;
467: hr_utility.set_location('Exiting'||l_proc, 15);
468:
469:
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:
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: --
2560: WHEN utl_file.invalid_mode then
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');
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');
2562: fnd_file.put_line(fnd_file.log, fnd_message.get);
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: --
2565: WHEN utl_file.invalid_filehandle then
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');
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');
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
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: --
2570: WHEN utl_file.invalid_operation then
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');
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');
2572: fnd_file.put_line(fnd_file.log, fnd_message.get);
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: --
2575: WHEN utl_file.read_error then
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');
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');
2577: fnd_file.put_line(fnd_file.log, fnd_message.get);
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: --
2580:
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
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
2582: hr_utility.set_location( 'other exception raised ' , 99 ) ;
2579: --
2580:
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: --
2580:
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 ;
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: --
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: --
2590: END;