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

Line 497: fnd_file.put_line(fnd_file.log,null);

493: -- Set up error text for this person
494: fnd_message.set_name('PER','PER_74855_ASS_INV_RECORD');
495: fnd_message.set_token('FULL_NAME',l_fullname);
496: l_error_text := fnd_message.get;
497: fnd_file.put_line(fnd_file.log,null);
498: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
499: fnd_file.put_line(FND_FILE.LOG,NULL);
500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));
501: END IF;

Line 498: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));

494: fnd_message.set_name('PER','PER_74855_ASS_INV_RECORD');
495: fnd_message.set_token('FULL_NAME',l_fullname);
496: l_error_text := fnd_message.get;
497: fnd_file.put_line(fnd_file.log,null);
498: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
499: fnd_file.put_line(FND_FILE.LOG,NULL);
500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));
501: END IF;
502: --

Line 499: fnd_file.put_line(FND_FILE.LOG,NULL);

495: fnd_message.set_token('FULL_NAME',l_fullname);
496: l_error_text := fnd_message.get;
497: fnd_file.put_line(fnd_file.log,null);
498: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
499: fnd_file.put_line(FND_FILE.LOG,NULL);
500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));
501: END IF;
502: --
503: fnd_file.put_line(FND_FILE.LOG,REPLACE(p_field,fnd_global.local_chr(13),NULL));

Line 500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));

496: l_error_text := fnd_message.get;
497: fnd_file.put_line(fnd_file.log,null);
498: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
499: fnd_file.put_line(FND_FILE.LOG,NULL);
500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));
501: END IF;
502: --
503: fnd_file.put_line(FND_FILE.LOG,REPLACE(p_field,fnd_global.local_chr(13),NULL));
504: --

Line 503: fnd_file.put_line(FND_FILE.LOG,REPLACE(p_field,fnd_global.local_chr(13),NULL));

499: fnd_file.put_line(FND_FILE.LOG,NULL);
500: fnd_file.put_line(FND_FILE.LOG,REPLACE(l_error_text,fnd_global.local_chr(13),NULL));
501: END IF;
502: --
503: fnd_file.put_line(FND_FILE.LOG,REPLACE(p_field,fnd_global.local_chr(13),NULL));
504: --
505: l_error := TRUE;
506: --
507: END write_error;

Line 514: fnd_file.put(FND_FILE.LOG,upper(p_column)||': ');

510: p_first_time in varchar2) IS
511: --
512: procedure write_column (p_column in varchar2) is
513: begin
514: fnd_file.put(FND_FILE.LOG,upper(p_column)||': ');
515: end write_column;
516: --
517: procedure write_field (p_field in varchar2) is
518: begin

Line 519: fnd_file.put(FND_FILE.LOG,p_field||' ');

515: end write_column;
516: --
517: procedure write_field (p_field in varchar2) is
518: begin
519: fnd_file.put(FND_FILE.LOG,p_field||' ');
520: end write_field;
521: --
522: procedure seperator is
523: begin

Line 524: fnd_file.put_line(fnd_file.log,null);

520: end write_field;
521: --
522: procedure seperator is
523: begin
524: fnd_file.put_line(fnd_file.log,null);
525: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
526: end seperator;
527: --
528: procedure write_header is

Line 525: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));

521: --
522: procedure seperator is
523: begin
524: fnd_file.put_line(fnd_file.log,null);
525: fnd_file.put_line(fnd_file.log,rpad('-',200,'-'));
526: end seperator;
527: --
528: procedure write_header is
529: begin

Line 530: fnd_file.put_line(FND_FILE.LOG,NULL);

526: end seperator;
527: --
528: procedure write_header is
529: begin
530: fnd_file.put_line(FND_FILE.LOG,NULL);
531: seperator;
532: fnd_file.put_line(FND_FILE.LOG,NULL);
533: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','HEADER'));
534: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));

Line 532: fnd_file.put_line(FND_FILE.LOG,NULL);

528: procedure write_header is
529: begin
530: fnd_file.put_line(FND_FILE.LOG,NULL);
531: seperator;
532: fnd_file.put_line(FND_FILE.LOG,NULL);
533: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','HEADER'));
534: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));
535: write_field(l_identifier);
536: write_column(fnd_message.get_string('PER','PER_74856_NULL_URSSAF'));

Line 533: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','HEADER'));

529: begin
530: fnd_file.put_line(FND_FILE.LOG,NULL);
531: seperator;
532: fnd_file.put_line(FND_FILE.LOG,NULL);
533: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','HEADER'));
534: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));
535: write_field(l_identifier);
536: write_column(fnd_message.get_string('PER','PER_74856_NULL_URSSAF'));
537: write_field(l_urssaf_code);

Line 542: fnd_file.put_line(FND_FILE.LOG,NULL);

538: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AR_PAR_LOT'));
539: write_field(REPLACE(p_batch,'Y','O'));
540: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_AR_LOT'));
541: write_field(p_fax);
542: fnd_file.put_line(FND_FILE.LOG,NULL);
543: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_SUP_AR_LOT'));
544: write_field(p_acknowledgement);
545: write_column(fnd_message.get_string('PER','PER_74858_NULL_EMAIL'));
546: write_field(p_email_address);

Line 551: fnd_file.put_line(FND_FILE.LOG,NULL);

547: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_CREATION'));
548: write_field(TO_CHAR(sysdate,'DDMMYYYY'));
549: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','H_CREATION'));
550: write_field(TO_CHAR(sysdate,'HHMI'));
551: fnd_file.put_line(FND_FILE.LOG,NULL);
552: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYER'));
553: write_column(fnd_message.get_string('PER','PER_74860_NULL_SIRET'));
554: write_field(p_app.siret);
555: write_column(fnd_message.get_string('PER','PER_74859_NULL_NAF'));

Line 552: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYER'));

548: write_field(TO_CHAR(sysdate,'DDMMYYYY'));
549: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','H_CREATION'));
550: write_field(TO_CHAR(sysdate,'HHMI'));
551: fnd_file.put_line(FND_FILE.LOG,NULL);
552: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYER'));
553: write_column(fnd_message.get_string('PER','PER_74860_NULL_SIRET'));
554: write_field(p_app.siret);
555: write_column(fnd_message.get_string('PER','PER_74859_NULL_NAF'));
556: write_field(p_app.naf_code);

Line 559: fnd_file.put_line(FND_FILE.LOG,NULL);

555: write_column(fnd_message.get_string('PER','PER_74859_NULL_NAF'));
556: write_field(p_app.naf_code);
557: write_column(fnd_message.get_string('PER','PER_74856_NULL_URSSAF'));
558: write_field(l_urssaf_code);
559: fnd_file.put_line(FND_FILE.LOG,NULL);
560: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_RAISON_SOC_1'));
561: write_field(p_app.est_name);
562: write_column(fnd_message.get_string('PER','PER_74861_NULL_ADDRESS1'));
563: write_field(p_app.loc_address1);

Line 564: fnd_file.put_line(FND_FILE.LOG,NULL);

560: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_RAISON_SOC_1'));
561: write_field(p_app.est_name);
562: write_column(fnd_message.get_string('PER','PER_74861_NULL_ADDRESS1'));
563: write_field(p_app.loc_address1);
564: fnd_file.put_line(FND_FILE.LOG,NULL);
565: write_column(fnd_message.get_string('PER','PER_74862_NULL_ADDRESS2'));
566: write_field(p_app.loc_address2);
567: write_column(fnd_message.get_string('PER','PER_74863_NULL_POST_CODE'));
568: write_field(p_app.loc_postal);

Line 569: fnd_file.put_line(FND_FILE.LOG,NULL);

565: write_column(fnd_message.get_string('PER','PER_74862_NULL_ADDRESS2'));
566: write_field(p_app.loc_address2);
567: write_column(fnd_message.get_string('PER','PER_74863_NULL_POST_CODE'));
568: write_field(p_app.loc_postal);
569: fnd_file.put_line(FND_FILE.LOG,NULL);
570: -- Added for bug #5240132
571: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_CITY_EMP'));
572: write_field(p_app.loc_town);
573: --

Line 579: fnd_file.put_line(FND_FILE.LOG,NULL);

575: write_field(p_app.loc_telephone);
576: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_EMP'));
577: write_field(p_fax);
578: -- Added for bug #5240132
579: fnd_file.put_line(FND_FILE.LOG,NULL);
580: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CORRESPOND_ADR'));
581: write_column(fnd_message.get_string('PER','PER_74861_NULL_ADDRESS1'));
582: write_field(r_estab_addr.address_line_1);
583: write_column(fnd_message.get_string('PER','PER_74862_NULL_ADDRESS2'));

Line 580: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CORRESPOND_ADR'));

576: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_EMP'));
577: write_field(p_fax);
578: -- Added for bug #5240132
579: fnd_file.put_line(FND_FILE.LOG,NULL);
580: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CORRESPOND_ADR'));
581: write_column(fnd_message.get_string('PER','PER_74861_NULL_ADDRESS1'));
582: write_field(r_estab_addr.address_line_1);
583: write_column(fnd_message.get_string('PER','PER_74862_NULL_ADDRESS2'));
584: write_field(r_estab_addr.address_line_2);

Line 585: fnd_file.put_line(FND_FILE.LOG,NULL);

581: write_column(fnd_message.get_string('PER','PER_74861_NULL_ADDRESS1'));
582: write_field(r_estab_addr.address_line_1);
583: write_column(fnd_message.get_string('PER','PER_74862_NULL_ADDRESS2'));
584: write_field(r_estab_addr.address_line_2);
585: fnd_file.put_line(FND_FILE.LOG,NULL);
586: write_column(fnd_message.get_string('PER','PER_74863_NULL_POST_CODE'));
587: write_field(r_estab_addr.postal_code);
588: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_CITY_EMP'));
589: write_field(r_estab_addr.town_or_city);

Line 590: fnd_file.put_line(FND_FILE.LOG,NULL);

586: write_column(fnd_message.get_string('PER','PER_74863_NULL_POST_CODE'));
587: write_field(r_estab_addr.postal_code);
588: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_CITY_EMP'));
589: write_field(r_estab_addr.town_or_city);
590: fnd_file.put_line(FND_FILE.LOG,NULL);
591: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));
592: write_field(r_estab_addr.telephone_number_1);
593: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_EMP'));
594: write_field(r_estab_addr.telephone_number_2);

Line 604: fnd_file.put_line(FND_FILE.LOG,NULL);

600: l_trace := 'Writing report header';
601: write_header;
602: ELSE
603: l_trace := 'Writing report body';
604: fnd_file.put_line(FND_FILE.LOG,NULL);
605: seperator;
606: fnd_file.put_line(FND_FILE.LOG,NULL);
607: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYEE'));
608: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','R_DOSSIER'));

Line 606: fnd_file.put_line(FND_FILE.LOG,NULL);

602: ELSE
603: l_trace := 'Writing report body';
604: fnd_file.put_line(FND_FILE.LOG,NULL);
605: seperator;
606: fnd_file.put_line(FND_FILE.LOG,NULL);
607: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYEE'));
608: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','R_DOSSIER'));
609: write_field(p_app.app_employee_number);
610: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_PATRO_SAL'));

Line 607: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYEE'));

603: l_trace := 'Writing report body';
604: fnd_file.put_line(FND_FILE.LOG,NULL);
605: seperator;
606: fnd_file.put_line(FND_FILE.LOG,NULL);
607: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','EMPLOYEE'));
608: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','R_DOSSIER'));
609: write_field(p_app.app_employee_number);
610: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_PATRO_SAL'));
611: write_field(p_app.nom_de_naiss);

Line 614: fnd_file.put_line(FND_FILE.LOG,NULL);

610: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_PATRO_SAL'));
611: write_field(p_app.nom_de_naiss);
612: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_EPX_SAL'));
613: write_field(p_app.nom_marital);
614: fnd_file.put_line(FND_FILE.LOG,NULL);
615: write_column(fnd_message.get_string('PER','PER_74865_NULL_FIRST_NAME'));
616: write_field(p_app.app_first_name);
617: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_SEXE_SAL'));
618: write_field(p_app.app_sex);

Line 621: fnd_file.put_line(FND_FILE.LOG,NULL);

617: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_SEXE_SAL'));
618: write_field(p_app.app_sex);
619: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_SECU_SOC'));
620: write_field(p_app.app_ni);
621: fnd_file.put_line(FND_FILE.LOG,NULL);
622: write_column(fnd_message.get_string('PER','PER_74866_NULL_DOB'));
623: write_field(p_app.app_dob);
624: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NATION_SAL'));
625: write_field(l_nationality);

Line 628: fnd_file.put_line(FND_FILE.LOG,NULL);

624: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NATION_SAL'));
625: write_field(l_nationality);
626: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_LIEU_NAISS_SAL'));
627: write_field(NVL(p_app.app_town_birth,l_coun_of_birth));
628: fnd_file.put_line(FND_FILE.LOG,NULL);
629: write_column(fnd_message.get_string('PER','PER_74867_NULL_COUNTRY'));
630: write_field(l_coun_of_birth);
631: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_ADR_SAL_1'));
632: write_field(p_app.app_address1);

Line 635: fnd_file.put_line(FND_FILE.LOG,NULL);

631: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_ADR_SAL_1'));
632: write_field(p_app.app_address1);
633: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_ADR_SAL_2'));
634: write_field(p_app.app_address2);
635: fnd_file.put_line(FND_FILE.LOG,NULL);
636: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_POST_SAL'));
637: write_field(p_app.app_pos_code);
638: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_BUR_DIST_SAL'));
639: write_field(p_app.app_town);

Line 644: fnd_file.put_line(FND_FILE.LOG,NULL);

640: write_column(fnd_message.get_string('PER','PER_74868_NULL_HIRE_DATE'));
641: write_field(l_from_date);
642: write_column(fnd_message.get_string('PER','PER_74883_START_TIME'));
643: write_field(p_app.start_time);
644: fnd_file.put_line(FND_FILE.LOG,NULL);
645: fnd_file.put_line(FND_FILE.LOG,'---------------');
646: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','OTHER'));
647: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_MT_DCL'));
648: write_field(l_medical);

Line 645: fnd_file.put_line(FND_FILE.LOG,'---------------');

641: write_field(l_from_date);
642: write_column(fnd_message.get_string('PER','PER_74883_START_TIME'));
643: write_field(p_app.start_time);
644: fnd_file.put_line(FND_FILE.LOG,NULL);
645: fnd_file.put_line(FND_FILE.LOG,'---------------');
646: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','OTHER'));
647: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_MT_DCL'));
648: write_field(l_medical);
649: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ETAB'));

Line 646: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','OTHER'));

642: write_column(fnd_message.get_string('PER','PER_74883_START_TIME'));
643: write_field(p_app.start_time);
644: fnd_file.put_line(FND_FILE.LOG,NULL);
645: fnd_file.put_line(FND_FILE.LOG,'---------------');
646: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','OTHER'));
647: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_MT_DCL'));
648: write_field(l_medical);
649: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ETAB'));
650: write_field(l_est_total);

Line 657: fnd_file.put_line(FND_FILE.LOG,NULL);

653: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_EMPLOI'));
654: write_field(p_app.app_emp_code);
655: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_FORMATION'));
656: write_field(p_app.app_training_level);
657: fnd_file.put_line(FND_FILE.LOG,NULL);
658: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_QUALIF'));
659: write_field(p_app.app_qual_code);
660: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_AV_EMBAUCHE'));
661: write_field(p_app.app_status_before_hire);

Line 668: fnd_file.put_line(FND_FILE.LOG,NULL);

664: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_HEBDO'));
665: write_field(l_working_hours);
666: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_TYPE_CONTRAT'));
667: write_field(p_app.app_contract_cat);
668: fnd_file.put_line(FND_FILE.LOG,NULL);
669: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_FIN_CDD'));
670: write_field(p_app.con_end_date);
671: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_NON_EMBAUCHE'));
672: write_field(p_app.proposed_end_date);

Line 677: fnd_file.put_line(FND_FILE.LOG,NULL);

673: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_SALAIRE_MM'));
674: write_field(to_char(ROUND(p_app.app_proposed_monthly_salary)));
675: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_TRAVAIL'));
676: write_field(l_monthly_hours);
677: fnd_file.put_line(FND_FILE.LOG,NULL);
678: fnd_file.put_line(FND_FILE.LOG,'---------------');
679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));
680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);

Line 678: fnd_file.put_line(FND_FILE.LOG,'---------------');

674: write_field(to_char(ROUND(p_app.app_proposed_monthly_salary)));
675: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_TRAVAIL'));
676: write_field(l_monthly_hours);
677: fnd_file.put_line(FND_FILE.LOG,NULL);
678: fnd_file.put_line(FND_FILE.LOG,'---------------');
679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));
680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);
682: fnd_file.put_line(FND_FILE.LOG,NULL);

Line 679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));

675: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_TRAVAIL'));
676: write_field(l_monthly_hours);
677: fnd_file.put_line(FND_FILE.LOG,NULL);
678: fnd_file.put_line(FND_FILE.LOG,'---------------');
679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));
680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);
682: fnd_file.put_line(FND_FILE.LOG,NULL);
683: fnd_file.put_line(FND_FILE.LOG,'---------------');

Line 682: fnd_file.put_line(FND_FILE.LOG,NULL);

678: fnd_file.put_line(FND_FILE.LOG,'---------------');
679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));
680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);
682: fnd_file.put_line(FND_FILE.LOG,NULL);
683: fnd_file.put_line(FND_FILE.LOG,'---------------');
684: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','ADMIN'));
685: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREMIERE_EMB'));
686: write_field('N');

Line 683: fnd_file.put_line(FND_FILE.LOG,'---------------');

679: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','REGISTRATION'));
680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);
682: fnd_file.put_line(FND_FILE.LOG,NULL);
683: fnd_file.put_line(FND_FILE.LOG,'---------------');
684: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','ADMIN'));
685: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREMIERE_EMB'));
686: write_field('N');
687: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CERTIF'));

Line 684: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','ADMIN'));

680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));
681: write_field(p_app.app_titulair);
682: fnd_file.put_line(FND_FILE.LOG,NULL);
683: fnd_file.put_line(FND_FILE.LOG,'---------------');
684: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','ADMIN'));
685: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREMIERE_EMB'));
686: write_field('N');
687: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CERTIF'));
688: write_field(REPLACE(p_dads,'Y','O'));

Line 691: fnd_file.put_line(FND_FILE.LOG,NULL);

687: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CERTIF'));
688: write_field(REPLACE(p_dads,'Y','O'));
689: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CHOM'));
690: write_field(p_app.app_assedic);
691: fnd_file.put_line(FND_FILE.LOG,NULL);
692: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_IMMA'));
693: write_field(p_app.app_request_ni);
694: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_MT'));
695: write_field(p_app.app_inform_mt);

Line 698: fnd_file.put_line(FND_FILE.LOG,NULL);

694: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_MT'));
695: write_field(p_app.app_inform_mt);
696: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PMF5'));
697: write_field(REPLACE(p_pmf5,'Y','O'));
698: fnd_file.put_line(FND_FILE.LOG,NULL);
699: -- Removed for bug#4083763
700: --write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREM'));
701: --write_field(REPLACE(p_prem,'Y','O'));
702: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_TP'));

Line 704: fnd_file.put_line(FND_FILE.LOG,NULL);

700: --write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREM'));
701: --write_field(REPLACE(p_prem,'Y','O'));
702: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_TP'));
703: write_field(p_app.app_pt_exon);
704: fnd_file.put_line(FND_FILE.LOG,NULL);
705: fnd_file.put_line(FND_FILE.LOG,'---------------');
706: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CONTACT'));
707: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_RESP'));
708: write_field(p_contact_name);

Line 705: fnd_file.put_line(FND_FILE.LOG,'---------------');

701: --write_field(REPLACE(p_prem,'Y','O'));
702: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_TP'));
703: write_field(p_app.app_pt_exon);
704: fnd_file.put_line(FND_FILE.LOG,NULL);
705: fnd_file.put_line(FND_FILE.LOG,'---------------');
706: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CONTACT'));
707: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_RESP'));
708: write_field(p_contact_name);
709: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_RESP'));

Line 706: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CONTACT'));

702: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_TP'));
703: write_field(p_app.app_pt_exon);
704: fnd_file.put_line(FND_FILE.LOG,NULL);
705: fnd_file.put_line(FND_FILE.LOG,'---------------');
706: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','CONTACT'));
707: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_RESP'));
708: write_field(p_contact_name);
709: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_RESP'));
710: write_field(p_contact_telephone);

Line 793: fnd_file.put_line(FND_FILE.LOG,REPLACE(fnd_message.get_string('PER','PER_74857_NULL_PERSON_ESTAB'),fnd_global.local_chr(13),NULL));

789: --
790: l_date := fnd_date.canonical_to_date(p_date);
791: IF p_person_id IS NULL AND p_establishment_id IS NULL THEN
792: l_trace := 'Writing to error log1';
793: fnd_file.put_line(FND_FILE.LOG,REPLACE(fnd_message.get_string('PER','PER_74857_NULL_PERSON_ESTAB'),fnd_global.local_chr(13),NULL));
794: l_error := TRUE;
795: END IF;
796: --
797: --FOR r_app IN c_app LOOP

Line 1074: fnd_file.put_line(FND_FILE.OUTPUT,l_text);

1070: --
1071: ||RPAD(NVL(r_app.app_pt_exon,' '),1) -- I_TP
1072: ||RPAD(' ',11); -- Reserved by URSSAF
1073: --
1074: fnd_file.put_line(FND_FILE.OUTPUT,l_text);
1075: --
1076: write_report(r_app,'N');
1077: --
1078: l_trace := 'Updating per_assignment_extra_info';