DBA Data[Home] [Help]

APPS.BEN_DM_INPUT_FILE_PKG dependencies on FND_FILE

Line 422: fnd_file.put_line(fnd_file.output,'Following records from the input file have been skipped because one or more of the dependents do not have an SSN');

418: l_inp_rec(i).process_flag = 'N' then
419:
420: l_skip_count := nvl(l_skip_count,0) +1;
421: if l_skip_count = 1 then
422: fnd_file.put_line(fnd_file.output,'Following records from the input file have been skipped because one or more of the dependents do not have an SSN');
423: end if;
424: fnd_file.put_line(fnd_file.output,
425: l_inp_rec(i).source_bg||p_delimiter||
426: l_inp_rec(i).source_ssn||p_delimiter||

Line 424: fnd_file.put_line(fnd_file.output,

420: l_skip_count := nvl(l_skip_count,0) +1;
421: if l_skip_count = 1 then
422: fnd_file.put_line(fnd_file.output,'Following records from the input file have been skipped because one or more of the dependents do not have an SSN');
423: end if;
424: fnd_file.put_line(fnd_file.output,
425: l_inp_rec(i).source_bg||p_delimiter||
426: l_inp_rec(i).source_ssn||p_delimiter||
427: l_inp_rec(i).source_person_id||p_delimiter||
428: l_inp_rec(i).target_bg||p_delimiter||

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

436: exception
437: when utl_file.invalid_path then
438: rollback;
439: fnd_message.set_name('BEN', 'BEN_91874_EXT_DRCTRY_ERR'); --9999
440: fnd_file.put_line(fnd_file.log, fnd_message.get);
441: if utl_file.is_open(l_file_handle) then
442: utl_file.fclose(l_file_handle);
443: end if;
444: fnd_message.raise_error;

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

445: --
446: when utl_file.invalid_mode then
447: rollback;
448: fnd_message.set_name('BEN', 'BEN_92249_UTL_INVLD_MODE');
449: fnd_file.put_line(fnd_file.log, fnd_message.get);
450: if utl_file.is_open(l_file_handle) then
451: utl_file.fclose(l_file_handle);
452: end if;
453: fnd_message.raise_error;

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

454: --
455: when utl_file.invalid_filehandle then
456: rollback;
457: fnd_message.set_name('BEN', 'BEN_92250_UTL_INVLD_FILEHANDLE');
458: fnd_file.put_line(fnd_file.log, fnd_message.get);
459: if utl_file.is_open(l_file_handle) then
460: utl_file.fclose(l_file_handle);
461: end if;
462: fnd_message.raise_error;

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

463: --
464: when utl_file.invalid_operation then
465: rollback;
466: fnd_message.set_name('BEN', 'BEN_92251_UTL_INVLD_OPER');
467: fnd_file.put_line(fnd_file.log, fnd_message.get);
468: if utl_file.is_open(l_file_handle) then
469: utl_file.fclose(l_file_handle);
470: end if;
471: fnd_message.raise_error;

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

472: --
473: when utl_file.read_error then
474: rollback;
475: fnd_message.set_name('BEN', 'BEN_92252_UTL_READ_ERROR');
476: fnd_file.put_line(fnd_file.log, fnd_message.get);
477: if utl_file.is_open(l_file_handle) then
478: utl_file.fclose(l_file_handle);
479: end if;
480: fnd_message.raise_error;

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

481: --
482: when utl_file.internal_error then
483: rollback;
484: fnd_message.set_name('BEN', 'BEN_92253_UTL_INTRNL_ERROR');
485: fnd_file.put_line(fnd_file.log, fnd_message.get);
486: if utl_file.is_open(l_file_handle) then
487: utl_file.fclose(l_file_handle);
488: end if;
489: fnd_message.raise_error;

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

490: --
491: when utl_file.invalid_maxlinesize then
492: rollback;
493: fnd_message.set_name ('BEN' ,'BEN_92492_UTL_LINESIZE_ERROR');
494: fnd_file.put_line(fnd_file.log , fnd_message.get );
495: if utl_file.is_open(l_file_handle) then
496: utl_file.fclose(l_file_handle);
497: end if;
498: fnd_message.raise_error ;

Line 502: fnd_file.put_line(fnd_file.log , 'One ore more fields missing in this Record: '||substr(l_line_text,1,80));

498: fnd_message.raise_error ;
499: --
500: when g_missing_fields then
501: rollback;
502: fnd_file.put_line(fnd_file.log , 'One ore more fields missing in this Record: '||substr(l_line_text,1,80));
503: if utl_file.is_open(l_file_handle) then
504: utl_file.fclose(l_file_handle);
505: end if;
506: raise;

Line 510: fnd_file.put_line(fnd_file.log , 'Invalid fields in this Record: '||substr(l_line_text,1,80));

506: raise;
507: --
508: when g_invalid_record then
509: rollback;
510: fnd_file.put_line(fnd_file.log , 'Invalid fields in this Record: '||substr(l_line_text,1,80));
511: if utl_file.is_open(l_file_handle) then
512: utl_file.fclose(l_file_handle);
513: end if;
514: raise;