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 HR_GENERAL

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 534: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));

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);
538: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AR_PAR_LOT'));

Line 538: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AR_PAR_LOT'));

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

Line 540: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_AR_LOT'));

536: write_column(fnd_message.get_string('PER','PER_74856_NULL_URSSAF'));
537: write_field(l_urssaf_code);
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);

Line 543: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_SUP_AR_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);
547: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_CREATION'));

Line 547: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_CREATION'));

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

Line 549: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','H_CREATION'));

545: write_column(fnd_message.get_string('PER','PER_74858_NULL_EMAIL'));
546: write_field(p_email_address);
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'));

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 560: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_RAISON_SOC_1'));

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);
564: fnd_file.put_line(FND_FILE.LOG,NULL);

Line 571: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_CITY_EMP'));

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: --
574: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));
575: write_field(p_app.loc_telephone);

Line 574: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));

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: --
574: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));
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

Line 576: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_EMP'));

572: write_field(p_app.loc_town);
573: --
574: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));
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'));

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 588: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_CITY_EMP'));

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

Line 591: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_EMP'));

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

Line 593: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_FAX_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);
595: --
596: end write_header;
597: --

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 608: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','R_DOSSIER'));

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);
612: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_EPX_SAL'));

Line 610: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_PATRO_SAL'));

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

Line 612: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_EPX_SAL'));

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

Line 617: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_SEXE_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);
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);

Line 619: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_SECU_SOC'));

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

Line 624: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NATION_SAL'));

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

Line 626: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_LIEU_NAISS_SAL'));

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

Line 631: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_ADR_SAL_1'));

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

Line 633: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_ADR_SAL_2'));

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

Line 636: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_POST_SAL'));

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);
640: write_column(fnd_message.get_string('PER','PER_74868_NULL_HIRE_DATE'));

Line 638: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_BUR_DIST_SAL'));

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

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 647: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_MT_DCL'));

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);
651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));

Line 649: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ETAB'));

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);
651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));
652: write_field(l_ent_total);
653: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_EMPLOI'));

Line 651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));

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);
651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));
652: write_field(l_ent_total);
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'));

Line 653: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_EMPLOI'));

649: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ETAB'));
650: write_field(l_est_total);
651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));
652: write_field(l_ent_total);
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);

Line 655: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_FORMATION'));

651: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_EFFECTIF_ENTR'));
652: write_field(l_ent_total);
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);

Line 658: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_QUALIF'));

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);
662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));

Line 660: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_AV_EMBAUCHE'));

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);
662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));
663: write_field(l_probation_period);
664: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_HEBDO'));

Line 662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));

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);
662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));
663: write_field(l_probation_period);
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'));

Line 664: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_HEBDO'));

660: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_AV_EMBAUCHE'));
661: write_field(p_app.app_status_before_hire);
662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));
663: write_field(l_probation_period);
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);

Line 666: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','C_TYPE_CONTRAT'));

662: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_JJ_ESSAI'));
663: write_field(l_probation_period);
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);

Line 669: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_FIN_CDD'));

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);
673: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_SALAIRE_MM'));

Line 671: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_NON_EMBAUCHE'));

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

Line 673: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_SALAIRE_MM'));

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

Line 675: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_HH_TRAVAIL'));

671: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','D_NON_EMBAUCHE'));
672: write_field(p_app.proposed_end_date);
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'));

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 680: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_AGENT_TITU'));

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,'---------------');
684: fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('FR_DUE_FIELDS','ADMIN'));

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 685: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREMIERE_EMB'));

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'));
689: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CHOM'));

Line 687: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CERTIF'));

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

Line 689: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_CHOM'));

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

Line 692: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_IMMA'));

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);
696: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PMF5'));

Line 694: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_MT'));

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

Line 696: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PMF5'));

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

Line 700: --write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_PREM'));

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'));
703: write_field(p_app.app_pt_exon);
704: fnd_file.put_line(FND_FILE.LOG,NULL);

Line 702: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','I_TP'));

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

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 707: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','L_NOM_RESP'));

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);
711: END IF;

Line 709: write_column(hr_general.decode_lookup('FR_DUE_FIELDS','N_TEL_RESP'));

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);
711: END IF;
712: END write_report;
713: ----------------------------

Line 774: write_error(p_field => hr_general.decode_lookup('FR_DUE_FIELDS','L_NATION_SAL'));

770: write_error(p_field => fnd_message.get_string('PER','PER_74883_START_TIME'));
771: END IF;
772: --
773: IF p_app.app_nat_code IS NULL THEN
774: write_error(p_field => hr_general.decode_lookup('FR_DUE_FIELDS','L_NATION_SAL'));
775: END IF;
776: --
777: -- Added for bug#4083763
778: -- as L_IDENT_EMT is manadatory

Line 780: write_error(p_field => hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));

776: --
777: -- Added for bug#4083763
778: -- as L_IDENT_EMT is manadatory
779: IF l_identifier IS NULL THEN
780: write_error(p_field => hr_general.decode_lookup('FR_DUE_FIELDS','L_IDENT_EMT'));
781: END IF;
782: --
783: END validate_record;
784: ----------------------------

Line 892: l_medical := hr_general.decode_lookup(p_lookup_type => 'FR_WORK_MEDICAL_SERVICE',

888: null;
889: ELSE
890: --
891: /* Get the medical code */
892: l_medical := hr_general.decode_lookup(p_lookup_type => 'FR_WORK_MEDICAL_SERVICE',
893: p_lookup_code => r_app.aei_information1);
894: --
895: IF l_medical IS NULL THEN
896: l_medical := ' ';

Line 902: l_nationality := hr_general.decode_lookup(p_lookup_type => 'NATIONALITY',

898: l_medical := 'MT'||r_app.aei_information1;
899: END IF;
900: --
901: /* Get the nationality */
902: l_nationality := hr_general.decode_lookup(p_lookup_type => 'NATIONALITY',
903: p_lookup_code => r_app.app_nat_code);
904: --
905: /* Get the nationality type */
906: l_trace := 'Nationality - Alternate Lookup';

Line 953: l_naf_meaning := hr_general.decode_lookup(p_lookup_type => 'FR_NAF_CODE',

949: l_working_hours := fnd_number.number_to_canonical(round(r_app.app_hours*l_units_in_weeks));
950: END IF;
951: --
952: /*Get the NAF meaning*/
953: l_naf_meaning := hr_general.decode_lookup(p_lookup_type => 'FR_NAF_CODE',
954: p_lookup_code => r_app.naf_code);
955: --
956: /*Get rid of characters from start_time field*/
957: r_app.start_time := REPLACE(TRANSLATE(r_app.start_time,TRANSLATE(r_app.start_time,'0123456789','*'),'*'),'*',null);