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

Line 432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')

428: -- Bundesland : <>
429: -- Tax Office Name : <>
430: -- Tax Office Code : <>
431: --
432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

Line 434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')

430: -- Tax Office Code : <>
431: --
432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
437: || ': ' || NVL(p_tax_office_rec.tax_office_no, ' '));
438: fnd_file.put_line(fnd_file.output, ' ');

Line 436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
437: || ': ' || NVL(p_tax_office_rec.tax_office_no, ' '));
438: fnd_file.put_line(fnd_file.output, ' ');
439: --
440: --

Line 438: fnd_file.put_line(fnd_file.output, ' ');

434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
437: || ': ' || NVL(p_tax_office_rec.tax_office_no, ' '));
438: fnd_file.put_line(fnd_file.output, ' ');
439: --
440: --
441: -- See if the tax office already exists (by searching by tax office no).
442: --

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

463: --
464: -- Write out status line e.g. Tax office already exists.
465: --
466: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_EXISTS');
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468: fnd_file.put_line(fnd_file.output, '');
469: --
470: --
471: -- Name does not match.

Line 468: fnd_file.put_line(fnd_file.output, '');

464: -- Write out status line e.g. Tax office already exists.
465: --
466: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_EXISTS');
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468: fnd_file.put_line(fnd_file.output, '');
469: --
470: --
471: -- Name does not match.
472: --

Line 482: fnd_file.put_line(fnd_file.output, fnd_message.get);

478: -- The tax office <> already exists with this tax office code.
479: --
480: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_CODE_MATCHES');
481: fnd_message.set_token('NAME', l_tax_office_list(l_loop_index).name);
482: fnd_file.put_line(fnd_file.output, fnd_message.get);
483: fnd_file.put_line(fnd_file.output, '');
484: END IF;
485: END LOOP;
486: END IF;

Line 483: fnd_file.put_line(fnd_file.output, '');

479: --
480: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_CODE_MATCHES');
481: fnd_message.set_token('NAME', l_tax_office_list(l_loop_index).name);
482: fnd_file.put_line(fnd_file.output, fnd_message.get);
483: fnd_file.put_line(fnd_file.output, '');
484: END IF;
485: END LOOP;
486: END IF;
487: --

Line 519: fnd_file.put_line(fnd_file.output, fnd_message.get);

515: -- A tax office with this name already exists but the tax office
516: -- code does not match.
517: --
518: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_NAME_MATCHES');
519: fnd_file.put_line(fnd_file.output, fnd_message.get);
520: fnd_file.put_line(fnd_file.output, '');
521: --
522: --
523: -- Organization is not a tax office.

Line 520: fnd_file.put_line(fnd_file.output, '');

516: -- code does not match.
517: --
518: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_NAME_MATCHES');
519: fnd_file.put_line(fnd_file.output, fnd_message.get);
520: fnd_file.put_line(fnd_file.output, '');
521: --
522: --
523: -- Organization is not a tax office.
524: --

Line 533: fnd_file.put_line(fnd_file.output, fnd_message.get);

529: --
530: -- An organization with this name already exists but it is not a tax office
531: --
532: fnd_message.set_name('PER', 'HR_DE_NOT_A_TAX_OFFICE');
533: fnd_file.put_line(fnd_file.output, fnd_message.get);
534: fnd_file.put_line(fnd_file.output, '');
535: END IF;
536: END IF;
537: END IF;

Line 534: fnd_file.put_line(fnd_file.output, '');

530: -- An organization with this name already exists but it is not a tax office
531: --
532: fnd_message.set_name('PER', 'HR_DE_NOT_A_TAX_OFFICE');
533: fnd_file.put_line(fnd_file.output, fnd_message.get);
534: fnd_file.put_line(fnd_file.output, '');
535: END IF;
536: END IF;
537: END IF;
538: --

Line 564: fnd_file.put_line(fnd_file.output, fnd_message.get);

560: --
561: -- Write out status line e.g. Tax office has been created.
562: --
563: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_CREATED');
564: fnd_file.put_line(fnd_file.output, fnd_message.get);
565: fnd_file.put_line(fnd_file.output, '');
566: --
567: --
568: -- Running in analyse mode so only report the fact that the

Line 565: fnd_file.put_line(fnd_file.output, '');

561: -- Write out status line e.g. Tax office has been created.
562: --
563: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_CREATED');
564: fnd_file.put_line(fnd_file.output, fnd_message.get);
565: fnd_file.put_line(fnd_file.output, '');
566: --
567: --
568: -- Running in analyse mode so only report the fact that the
569: -- tax office will be created.

Line 577: fnd_file.put_line(fnd_file.output, fnd_message.get);

573: --
574: -- Write out status line e.g. Tax office can been created.
575: --
576: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_POSSIBLE');
577: fnd_file.put_line(fnd_file.output, fnd_message.get);
578: fnd_file.put_line(fnd_file.output, '');
579: END IF;
580: END IF;
581: END process_tax_office;

Line 578: fnd_file.put_line(fnd_file.output, '');

574: -- Write out status line e.g. Tax office can been created.
575: --
576: fnd_message.set_name('PER', 'HR_DE_TAX_OFFICE_POSSIBLE');
577: fnd_file.put_line(fnd_file.output, fnd_message.get);
578: fnd_file.put_line(fnd_file.output, '');
579: END IF;
580: END IF;
581: END process_tax_office;
582: --

Line 608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

604: --
605: -- Provider Type : <>
606: -- Provider Name : <>
607: --
608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
609: || ': ' || p_soc_ins_prov_rec.provider_type_description);
610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
611: || ': ' || p_soc_ins_prov_rec.provider_name);
612: fnd_file.put_line(fnd_file.output, ' ');

Line 610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

606: -- Provider Name : <>
607: --
608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
609: || ': ' || p_soc_ins_prov_rec.provider_type_description);
610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
611: || ': ' || p_soc_ins_prov_rec.provider_name);
612: fnd_file.put_line(fnd_file.output, ' ');
613: --
614: --

Line 612: fnd_file.put_line(fnd_file.output, ' ');

608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
609: || ': ' || p_soc_ins_prov_rec.provider_type_description);
610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
611: || ': ' || p_soc_ins_prov_rec.provider_name);
612: fnd_file.put_line(fnd_file.output, ' ');
613: --
614: --
615: -- See if an organization with the same name already exists.
616: --

Line 637: fnd_file.put_line(fnd_file.output, fnd_message.get);

633: --
634: -- Write out status line e.g. The social insurance provider already exists.
635: --
636: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_EXISTS');
637: fnd_file.put_line(fnd_file.output, fnd_message.get);
638: fnd_file.put_line(fnd_file.output, '');
639: --
640: --
641: -- Organization is not a social insurance provider of this type.

Line 638: fnd_file.put_line(fnd_file.output, '');

634: -- Write out status line e.g. The social insurance provider already exists.
635: --
636: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_EXISTS');
637: fnd_file.put_line(fnd_file.output, fnd_message.get);
638: fnd_file.put_line(fnd_file.output, '');
639: --
640: --
641: -- Organization is not a social insurance provider of this type.
642: --

Line 650: fnd_file.put_line(fnd_file.output, fnd_message.get);

646: -- Write out status line e.g. An organization with this name already exists but it is not a <>.
647: --
648: fnd_message.set_name('PER', 'HR_DE_NOT_A_SOCINS_PROV');
649: fnd_message.set_token('TYPE', p_soc_ins_prov_rec.provider_type_description);
650: fnd_file.put_line(fnd_file.output, fnd_message.get);
651: fnd_file.put_line(fnd_file.output, '');
652: END IF;
653: END IF;
654: --

Line 651: fnd_file.put_line(fnd_file.output, '');

647: --
648: fnd_message.set_name('PER', 'HR_DE_NOT_A_SOCINS_PROV');
649: fnd_message.set_token('TYPE', p_soc_ins_prov_rec.provider_type_description);
650: fnd_file.put_line(fnd_file.output, fnd_message.get);
651: fnd_file.put_line(fnd_file.output, '');
652: END IF;
653: END IF;
654: --
655: --

Line 683: fnd_file.put_line(fnd_file.output, fnd_message.get);

679: --
680: -- Write out status line e.g. Social insurance provider has been created.
681: --
682: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_CREATED');
683: fnd_file.put_line(fnd_file.output, fnd_message.get);
684: fnd_file.put_line(fnd_file.output, '');
685: --
686: --
687: -- Running in analyse mode so only report the fact that the

Line 684: fnd_file.put_line(fnd_file.output, '');

680: -- Write out status line e.g. Social insurance provider has been created.
681: --
682: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_CREATED');
683: fnd_file.put_line(fnd_file.output, fnd_message.get);
684: fnd_file.put_line(fnd_file.output, '');
685: --
686: --
687: -- Running in analyse mode so only report the fact that the
688: -- social insurance provider will be created.

Line 696: fnd_file.put_line(fnd_file.output, fnd_message.get);

692: --
693: -- Write out status line e.g. Social insurance provider can been created.
694: --
695: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_POSSIBLE');
696: fnd_file.put_line(fnd_file.output, fnd_message.get);
697: fnd_file.put_line(fnd_file.output, '');
698: END IF;
699: END IF;
700: END process_soc_ins_provider;

Line 697: fnd_file.put_line(fnd_file.output, '');

693: -- Write out status line e.g. Social insurance provider can been created.
694: --
695: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_POSSIBLE');
696: fnd_file.put_line(fnd_file.output, fnd_message.get);
697: fnd_file.put_line(fnd_file.output, '');
698: END IF;
699: END IF;
700: END process_soc_ins_provider;
701: --

Line 730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

726: -- Provider Name : <>
727: -- East Betriebsnummer : <>
728: -- West Betriebsnummer : <>
729: --
730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

Line 732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

728: -- West Betriebsnummer : <>
729: --
730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

Line 734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
737: || ': ' || NVL(p_soc_ins_prov_rec.west_betriebesnumber, ' '));
738: fnd_file.put_line(fnd_file.output, ' ');

Line 736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
737: || ': ' || NVL(p_soc_ins_prov_rec.west_betriebesnumber, ' '));
738: fnd_file.put_line(fnd_file.output, ' ');
739: --
740: --

Line 738: fnd_file.put_line(fnd_file.output, ' ');

734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
737: || ': ' || NVL(p_soc_ins_prov_rec.west_betriebesnumber, ' '));
738: fnd_file.put_line(fnd_file.output, ' ');
739: --
740: --
741: -- See if the mandatory health provider already exists (by searching by east
742: -- and west betriebsnummer).

Line 769: fnd_file.put_line(fnd_file.output, fnd_message.get);

765: --
766: -- Write out status line e.g. Social insurance provider already exists.
767: --
768: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_EXISTS');
769: fnd_file.put_line(fnd_file.output, fnd_message.get);
770: fnd_file.put_line(fnd_file.output, '');
771: --
772: --
773: -- Name does not match.

Line 770: fnd_file.put_line(fnd_file.output, '');

766: -- Write out status line e.g. Social insurance provider already exists.
767: --
768: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_EXISTS');
769: fnd_file.put_line(fnd_file.output, fnd_message.get);
770: fnd_file.put_line(fnd_file.output, '');
771: --
772: --
773: -- Name does not match.
774: --

Line 784: fnd_file.put_line(fnd_file.output, fnd_message.get);

780: -- The social insurance provider <> already exists with these betriebsnummers.
781: --
782: fnd_message.set_name('PER', 'HR_DE_SOCINS_BETRIEBS_MATCHES');
783: fnd_message.set_token('NAME', l_mand_health_prov_list(l_loop_index).name);
784: fnd_file.put_line(fnd_file.output, fnd_message.get);
785: fnd_file.put_line(fnd_file.output, '');
786: END IF;
787: END LOOP;
788: END IF;

Line 785: fnd_file.put_line(fnd_file.output, '');

781: --
782: fnd_message.set_name('PER', 'HR_DE_SOCINS_BETRIEBS_MATCHES');
783: fnd_message.set_token('NAME', l_mand_health_prov_list(l_loop_index).name);
784: fnd_file.put_line(fnd_file.output, fnd_message.get);
785: fnd_file.put_line(fnd_file.output, '');
786: END IF;
787: END LOOP;
788: END IF;
789: --

Line 821: fnd_file.put_line(fnd_file.output, fnd_message.get);

817: -- A social insurance provider with this name already exists but the east
818: -- and west betriebsnummers do not match.
819: --
820: fnd_message.set_name('PER', 'HR_DE_SOCINS_NAME_MATCHES');
821: fnd_file.put_line(fnd_file.output, fnd_message.get);
822: fnd_file.put_line(fnd_file.output, '');
823: --
824: --
825: -- Organization is not a mandatory health provider.

Line 822: fnd_file.put_line(fnd_file.output, '');

818: -- and west betriebsnummers do not match.
819: --
820: fnd_message.set_name('PER', 'HR_DE_SOCINS_NAME_MATCHES');
821: fnd_file.put_line(fnd_file.output, fnd_message.get);
822: fnd_file.put_line(fnd_file.output, '');
823: --
824: --
825: -- Organization is not a mandatory health provider.
826: --

Line 834: fnd_file.put_line(fnd_file.output, fnd_message.get);

830: -- Write out status line e.g. An organization with this name already exists but it is not a <>.
831: --
832: fnd_message.set_name('PER', 'HR_DE_NOT_A_SOCINS_PROV');
833: fnd_message.set_token('TYPE', p_soc_ins_prov_rec.provider_type_description);
834: fnd_file.put_line(fnd_file.output, fnd_message.get);
835: fnd_file.put_line(fnd_file.output, '');
836: END IF;
837: END IF;
838: END IF;

Line 835: fnd_file.put_line(fnd_file.output, '');

831: --
832: fnd_message.set_name('PER', 'HR_DE_NOT_A_SOCINS_PROV');
833: fnd_message.set_token('TYPE', p_soc_ins_prov_rec.provider_type_description);
834: fnd_file.put_line(fnd_file.output, fnd_message.get);
835: fnd_file.put_line(fnd_file.output, '');
836: END IF;
837: END IF;
838: END IF;
839: --

Line 868: fnd_file.put_line(fnd_file.output, fnd_message.get);

864: --
865: -- Write out status line e.g. Social insurance provider has been created.
866: --
867: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_CREATED');
868: fnd_file.put_line(fnd_file.output, fnd_message.get);
869: fnd_file.put_line(fnd_file.output, '');
870: --
871: --
872: -- Running in analyse mode so only report the fact that the

Line 869: fnd_file.put_line(fnd_file.output, '');

865: -- Write out status line e.g. Social insurance provider has been created.
866: --
867: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_CREATED');
868: fnd_file.put_line(fnd_file.output, fnd_message.get);
869: fnd_file.put_line(fnd_file.output, '');
870: --
871: --
872: -- Running in analyse mode so only report the fact that the
873: -- social insurance provider will be created.

Line 881: fnd_file.put_line(fnd_file.output, fnd_message.get);

877: --
878: -- Write out status line e.g. Social insurance provider can been created.
879: --
880: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_POSSIBLE');
881: fnd_file.put_line(fnd_file.output, fnd_message.get);
882: fnd_file.put_line(fnd_file.output, '');
883: END IF;
884: END IF;
885: END process_mand_health_provider;

Line 882: fnd_file.put_line(fnd_file.output, '');

878: -- Write out status line e.g. Social insurance provider can been created.
879: --
880: fnd_message.set_name('PER', 'HR_DE_SOCINS_PROV_POSSIBLE');
881: fnd_file.put_line(fnd_file.output, fnd_message.get);
882: fnd_file.put_line(fnd_file.output, '');
883: END IF;
884: END IF;
885: END process_mand_health_provider;
886: --

Line 945: fnd_file.put_line(fnd_file.output, ' ');

941: --
942: --
943: -- Write heading for output file.
944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));

Line 946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));

942: --
943: -- Write heading for output file.
944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '

Line 947: fnd_file.put_line(fnd_file.output, ' ');

943: -- Write heading for output file.
944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL

Line 948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '

944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)

Line 950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '

946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');

Line 954: fnd_file.put_line(fnd_file.output, ' ');

950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');
955: fnd_file.put_line(fnd_file.output, ' ');
956: --
957: --
958: -- Fetch the first tax office definition.

Line 955: fnd_file.put_line(fnd_file.output, ' ');

951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');
955: fnd_file.put_line(fnd_file.output, ' ');
956: --
957: --
958: -- Fetch the first tax office definition.
959: --

Line 1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')

1004: -- Bundesland : <>
1005: -- Tax Office Name : <>
1006: -- Tax Office Code : <>
1007: --
1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

Line 1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')

1006: -- Tax Office Code : <>
1007: --
1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
1013: || ': ' || NVL(l_tax_office_rec.tax_office_no, ' '));
1014: fnd_file.put_line(fnd_file.output, ' ');

Line 1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
1013: || ': ' || NVL(l_tax_office_rec.tax_office_no, ' '));
1014: fnd_file.put_line(fnd_file.output, ' ');
1015: --
1016: --

Line 1014: fnd_file.put_line(fnd_file.output, ' ');

1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
1013: || ': ' || NVL(l_tax_office_rec.tax_office_no, ' '));
1014: fnd_file.put_line(fnd_file.output, ' ');
1015: --
1016: --
1017: -- Output the error that was raised.
1018: --

Line 1019: fnd_file.put_line(fnd_file.log, SQLERRM);

1015: --
1016: --
1017: -- Output the error that was raised.
1018: --
1019: fnd_file.put_line(fnd_file.log, SQLERRM);
1020: fnd_file.put_line(fnd_file.log, '');
1021: --
1022: --
1023: -- Close the cursor.

Line 1020: fnd_file.put_line(fnd_file.log, '');

1016: --
1017: -- Output the error that was raised.
1018: --
1019: fnd_file.put_line(fnd_file.log, SQLERRM);
1020: fnd_file.put_line(fnd_file.log, '');
1021: --
1022: --
1023: -- Close the cursor.
1024: --

Line 1099: fnd_file.put_line(fnd_file.output, ' ');

1095: --
1096: --
1097: -- Write heading for output file.
1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));

Line 1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));

1096: --
1097: -- Write heading for output file.
1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '

Line 1101: fnd_file.put_line(fnd_file.output, ' ');

1097: -- Write heading for output file.
1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL

Line 1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '

1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)

Line 1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '

1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');

Line 1108: fnd_file.put_line(fnd_file.output, ' ');

1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');
1109: fnd_file.put_line(fnd_file.output, ' ');
1110: --
1111: --
1112: -- Fetch the first social insurance provider definition.

Line 1109: fnd_file.put_line(fnd_file.output, ' ');

1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');
1109: fnd_file.put_line(fnd_file.output, ' ');
1110: --
1111: --
1112: -- Fetch the first social insurance provider definition.
1113: --

Line 1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

1175: -- Provider Name : <>
1176: -- East Betriebsnummer : <>
1177: -- West Betriebsnummer : <>
1178: --
1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

Line 1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

1177: -- West Betriebsnummer : <>
1178: --
1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

Line 1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
1186: || ': ' || NVL(l_soc_ins_prov_rec.west_betriebesnumber, ' '));
1187: fnd_file.put_line(fnd_file.log, ' ');

Line 1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
1186: || ': ' || NVL(l_soc_ins_prov_rec.west_betriebesnumber, ' '));
1187: fnd_file.put_line(fnd_file.log, ' ');
1188: ELSE
1189: --

Line 1187: fnd_file.put_line(fnd_file.log, ' ');

1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
1186: || ': ' || NVL(l_soc_ins_prov_rec.west_betriebesnumber, ' '));
1187: fnd_file.put_line(fnd_file.log, ' ');
1188: ELSE
1189: --
1190: --
1191: -- Write out header line for the social insurance provider e.g.

Line 1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

1192: --
1193: -- Provider Type : <>
1194: -- Provider Name : <>
1195: --
1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1197: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1199: || ': ' || l_soc_ins_prov_rec.provider_name);
1200: fnd_file.put_line(fnd_file.output, ' ');

Line 1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

1194: -- Provider Name : <>
1195: --
1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1197: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1199: || ': ' || l_soc_ins_prov_rec.provider_name);
1200: fnd_file.put_line(fnd_file.output, ' ');
1201: END IF;
1202: --

Line 1200: fnd_file.put_line(fnd_file.output, ' ');

1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1197: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1199: || ': ' || l_soc_ins_prov_rec.provider_name);
1200: fnd_file.put_line(fnd_file.output, ' ');
1201: END IF;
1202: --
1203: --
1204: -- Output the error that was raised.

Line 1206: fnd_file.put_line(fnd_file.log, SQLERRM);

1202: --
1203: --
1204: -- Output the error that was raised.
1205: --
1206: fnd_file.put_line(fnd_file.log, SQLERRM);
1207: fnd_file.put_line(fnd_file.log, '');
1208: --
1209: --
1210: -- Close the cursor.

Line 1207: fnd_file.put_line(fnd_file.log, '');

1203: --
1204: -- Output the error that was raised.
1205: --
1206: fnd_file.put_line(fnd_file.log, SQLERRM);
1207: fnd_file.put_line(fnd_file.log, '');
1208: --
1209: --
1210: -- Close the cursor.
1211: --