DBA Data[Home] [Help]

APPS.BEN_EXT_XML_WRITE dependencies on FND_MESSAGE

Line 315: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');

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;

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 465: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');

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:

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 2556: fnd_message.set_name('BEN', 'BEN_92254_UTL_INVLD_PATH');

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

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 2558: fnd_message.raise_error;

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

Line 2561: fnd_message.set_name('BEN', 'BEN_92249_UTL_INVLD_MODE');

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

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 2563: 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');
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2566: fnd_message.set_name('BEN', 'BEN_92250_UTL_INVLD_FILEHANDLE');

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

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 2568: 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');
2572: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2571: fnd_message.set_name('BEN', 'BEN_92251_UTL_INVLD_OPER');

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

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 2573: 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');
2577: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2576: fnd_message.set_name('BEN', 'BEN_92252_UTL_READ_ERROR');

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:

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 2578: 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
2582: hr_utility.set_location( 'other exception raised ' , 99 ) ;

Line 2583: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

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

Line 2584: fnd_message.set_token('2',substr(sqlerrm,1,200));

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 ;

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

Line 2586: fnd_message.raise_error;

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;