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.PER_FR_ELECTION dependencies on FND_FILE

Line 201: fnd_file.put_line(FND_FILE.LOG,

197: Fnd_message.set_name('PER'
198: ,'HR_7449_PLK_COLUMN_NULL');
199: Fnd_message.set_token('COLUMN_NAME'
200: ,p_field);
201: fnd_file.put_line(FND_FILE.LOG,
202: l_error_flag ||': '|| fnd_message.get);
203: l_error_count := l_error_count + 1;
204: end if;
205: end;

Line 218: fnd_file.put_line(FND_FILE.LOG,

214: else
215: Fnd_message.set_name('PER'
216: ,'HR_7944_CHECK_FMT_BAD_FORMAT');
217: --
218: fnd_file.put_line(FND_FILE.LOG,
219: l_warning_flag ||': '|| fnd_message.get ||' : '||p_field);
220: l_warning_count := l_warning_count + 1;
221: end if;
222: end;

Line 231: fnd_file.put_line(FND_FILE.LOG,

227: Begin
228: If p_election_college = '2' and p_voting_place = '2' then
229: Fnd_message.set_name('PER','HR_7944_CHECK_FMT_BAD_FORMAT');
230: --
231: fnd_file.put_line(FND_FILE.LOG,
232: l_warning_flag ||': '|| fnd_message.get ||' : '||p_field);
233: l_warning_count := l_warning_count + 1;
234: end if;
235: end;

Line 368: Fnd_file.put_line(FND_FILE.OUTPUT,l_start_rec);

364: '000' ||
365: rpad(' ',1,' ') ||
366: substr(rep_est.SIRET,1,14) ||
367: rpad(' ',527,' ');
368: Fnd_file.put_line(FND_FILE.OUTPUT,l_start_rec);
369:
370: Fnd_file.put_line(FND_FILE.LOG,null);
371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);
372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);

Line 370: Fnd_file.put_line(FND_FILE.LOG,null);

366: substr(rep_est.SIRET,1,14) ||
367: rpad(' ',527,' ');
368: Fnd_file.put_line(FND_FILE.OUTPUT,l_start_rec);
369:
370: Fnd_file.put_line(FND_FILE.LOG,null);
371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);
372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);
373: Fnd_file.put_line(FND_FILE.LOG, rpad(substr(rep_est.SIRET,1,14),REPORTING_SIRET_LOG,' '));
374:

Line 371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);

367: rpad(' ',527,' ');
368: Fnd_file.put_line(FND_FILE.OUTPUT,l_start_rec);
369:
370: Fnd_file.put_line(FND_FILE.LOG,null);
371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);
372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);
373: Fnd_file.put_line(FND_FILE.LOG, rpad(substr(rep_est.SIRET,1,14),REPORTING_SIRET_LOG,' '));
374:
375: -- Mandatory Validation

Line 372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);

368: Fnd_file.put_line(FND_FILE.OUTPUT,l_start_rec);
369:
370: Fnd_file.put_line(FND_FILE.LOG,null);
371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);
372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);
373: Fnd_file.put_line(FND_FILE.LOG, rpad(substr(rep_est.SIRET,1,14),REPORTING_SIRET_LOG,' '));
374:
375: -- Mandatory Validation
376: -- reporting establishment SIRET

Line 373: Fnd_file.put_line(FND_FILE.LOG, rpad(substr(rep_est.SIRET,1,14),REPORTING_SIRET_LOG,' '));

369:
370: Fnd_file.put_line(FND_FILE.LOG,null);
371: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_title);
372: Fnd_file.put_line(FND_FILE.LOG,l_rep_est_underline);
373: Fnd_file.put_line(FND_FILE.LOG, rpad(substr(rep_est.SIRET,1,14),REPORTING_SIRET_LOG,' '));
374:
375: -- Mandatory Validation
376: -- reporting establishment SIRET
377:

Line 443: Fnd_file.put_line(FND_FILE.OUTPUT,l_est_head_rec);

439: -- Output the establishment header record as long as the estab
440: -- has at least one employee meeting the criteria
441:
442: if l_person_count = 0 then -- 1st person being processed
443: Fnd_file.put_line(FND_FILE.OUTPUT,l_est_head_rec);
444:
445: Fnd_file.put_line(FND_FILE.LOG,null);
446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);
447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);

Line 445: Fnd_file.put_line(FND_FILE.LOG,null);

441:
442: if l_person_count = 0 then -- 1st person being processed
443: Fnd_file.put_line(FND_FILE.OUTPUT,l_est_head_rec);
444:
445: Fnd_file.put_line(FND_FILE.LOG,null);
446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);
447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);
448: Fnd_file.put_line(FND_FILE.LOG,l_est_head_log);
449:

Line 446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);

442: if l_person_count = 0 then -- 1st person being processed
443: Fnd_file.put_line(FND_FILE.OUTPUT,l_est_head_rec);
444:
445: Fnd_file.put_line(FND_FILE.LOG,null);
446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);
447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);
448: Fnd_file.put_line(FND_FILE.LOG,l_est_head_log);
449:
450: -- Perform validation for the establishment

Line 447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);

443: Fnd_file.put_line(FND_FILE.OUTPUT,l_est_head_rec);
444:
445: Fnd_file.put_line(FND_FILE.LOG,null);
446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);
447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);
448: Fnd_file.put_line(FND_FILE.LOG,l_est_head_log);
449:
450: -- Perform validation for the establishment
451: mandatory_check(decode_lookup('FR_WORKERS_ELECTION','SIRET')

Line 448: Fnd_file.put_line(FND_FILE.LOG,l_est_head_log);

444:
445: Fnd_file.put_line(FND_FILE.LOG,null);
446: Fnd_file.put_line(FND_FILE.LOG,l_est_head_title);
447: Fnd_file.put_line(FND_FILE.LOG,l_est_head_underline);
448: Fnd_file.put_line(FND_FILE.LOG,l_est_head_log);
449:
450: -- Perform validation for the establishment
451: mandatory_check(decode_lookup('FR_WORKERS_ELECTION','SIRET')
452: , est.SIRET);

Line 470: Fnd_file.put_line(FND_FILE.LOG,null);

466: naf_code_check(decode_lookup('FR_WORKERS_ELECTION','NAF_CODE')
467: , est.NAF_CODE);
468:
469:
470: Fnd_file.put_line(FND_FILE.LOG,null);
471: Fnd_file.put_line(FND_FILE.LOG,l_person_title);
472: Fnd_file.put_line(FND_FILE.LOG,l_person_underline);
473:
474: End if;

Line 471: Fnd_file.put_line(FND_FILE.LOG,l_person_title);

467: , est.NAF_CODE);
468:
469:
470: Fnd_file.put_line(FND_FILE.LOG,null);
471: Fnd_file.put_line(FND_FILE.LOG,l_person_title);
472: Fnd_file.put_line(FND_FILE.LOG,l_person_underline);
473:
474: End if;
475:

Line 472: Fnd_file.put_line(FND_FILE.LOG,l_person_underline);

468:
469:
470: Fnd_file.put_line(FND_FILE.LOG,null);
471: Fnd_file.put_line(FND_FILE.LOG,l_person_title);
472: Fnd_file.put_line(FND_FILE.LOG,l_person_underline);
473:
474: End if;
475:
476: l_person_rec :=

Line 526: Fnd_file.put_line(FND_FILE.OUTPUT,l_person_rec);

522: rpad(Per.ELECTORAL_COLLEGE,ELECTORAL_COLLEGE_LOG,' ') || ' ' ||
523: rpad(Est.SECTION,SECTION_LOG,' ') || ' ' ||
524: rpad(Per.VOTING_PLACE,VOTING_PLACE_LOG,' ');
525:
526: Fnd_file.put_line(FND_FILE.OUTPUT,l_person_rec);
527:
528: Fnd_file.put_line(FND_FILE.LOG,l_person_log);
529:
530: -- Perform mandataory checks for people

Line 528: Fnd_file.put_line(FND_FILE.LOG,l_person_log);

524: rpad(Per.VOTING_PLACE,VOTING_PLACE_LOG,' ');
525:
526: Fnd_file.put_line(FND_FILE.OUTPUT,l_person_rec);
527:
528: Fnd_file.put_line(FND_FILE.LOG,l_person_log);
529:
530: -- Perform mandataory checks for people
531:
532: mandatory_check(decode_lookup('FR_WORKERS_ELECTION','SS_NUMBER')

Line 581: Fnd_file.put_line(FND_FILE.OUTPUT, l_est_footer_rec);

577: || rpad(' ',312,' ')
578: || lpad(to_char(l_person_count),6,'0')
579: || rpad(' ',224,' ');
580:
581: Fnd_file.put_line(FND_FILE.OUTPUT, l_est_footer_rec);
582:
583: End if;
584:
585:

Line 593: Fnd_file.put_line(FND_FILE.OUTPUT, l_end_rec);

589: l_end_rec := rpad('9',19,'9')
590: || '990'
591: || rpad(' ',542,' ');
592:
593: Fnd_file.put_line(FND_FILE.OUTPUT, l_end_rec);
594:
595: fnd_file.put_line(FND_FILE.LOG,null);
596: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','WARNING') || ' : ' ||
597: to_char(l_warning_count));

Line 595: fnd_file.put_line(FND_FILE.LOG,null);

591: || rpad(' ',542,' ');
592:
593: Fnd_file.put_line(FND_FILE.OUTPUT, l_end_rec);
594:
595: fnd_file.put_line(FND_FILE.LOG,null);
596: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','WARNING') || ' : ' ||
597: to_char(l_warning_count));
598: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','ERROR') || ' : ' ||
599: to_char(l_error_count));

Line 596: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','WARNING') || ' : ' ||

592:
593: Fnd_file.put_line(FND_FILE.OUTPUT, l_end_rec);
594:
595: fnd_file.put_line(FND_FILE.LOG,null);
596: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','WARNING') || ' : ' ||
597: to_char(l_warning_count));
598: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','ERROR') || ' : ' ||
599: to_char(l_error_count));
600:

Line 598: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','ERROR') || ' : ' ||

594:
595: fnd_file.put_line(FND_FILE.LOG,null);
596: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','WARNING') || ' : ' ||
597: to_char(l_warning_count));
598: fnd_file.put_line(FND_FILE.LOG,decode_lookup('FR_WORKERS_ELECTION','ERROR') || ' : ' ||
599: to_char(l_error_count));
600:
601: retcode := 0;
602: end;