551: end if;
552: -- Set retcode to 2, indicating an ERROR to the ConcMgr
553: retcode := 2;
554:
555: fnd_message.set_name('PAY','PAY_NL_ORG_ID');
556: fnd_message.set_token('ERNUM',l_rec_client_num);
557: fnd_message.set_token('SUBERNUM',l_rec_sub_emplr_num);
558:
559: -- Return the message to the ConcMgr (This msg will appear in the log file)
552: -- Set retcode to 2, indicating an ERROR to the ConcMgr
553: retcode := 2;
554:
555: fnd_message.set_name('PAY','PAY_NL_ORG_ID');
556: fnd_message.set_token('ERNUM',l_rec_client_num);
557: fnd_message.set_token('SUBERNUM',l_rec_sub_emplr_num);
558:
559: -- Return the message to the ConcMgr (This msg will appear in the log file)
560: errbuf := fnd_message.get();
553: retcode := 2;
554:
555: fnd_message.set_name('PAY','PAY_NL_ORG_ID');
556: fnd_message.set_token('ERNUM',l_rec_client_num);
557: fnd_message.set_token('SUBERNUM',l_rec_sub_emplr_num);
558:
559: -- Return the message to the ConcMgr (This msg will appear in the log file)
560: errbuf := fnd_message.get();
561:
556: fnd_message.set_token('ERNUM',l_rec_client_num);
557: fnd_message.set_token('SUBERNUM',l_rec_sub_emplr_num);
558:
559: -- Return the message to the ConcMgr (This msg will appear in the log file)
560: errbuf := fnd_message.get();
561:
562:
563:
564: WHEN e_fatal_error
600: end if;
601:
602: retcode := c_error;
603:
604: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_OPERATION');
605: fnd_message.set_token('FILENAME',l_filename);
606: fnd_message.set_token('LOCATION',l_location);
607:
608: errbuf := fnd_message.get();
601:
602: retcode := c_error;
603:
604: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_OPERATION');
605: fnd_message.set_token('FILENAME',l_filename);
606: fnd_message.set_token('LOCATION',l_location);
607:
608: errbuf := fnd_message.get();
609:
602: retcode := c_error;
603:
604: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_OPERATION');
605: fnd_message.set_token('FILENAME',l_filename);
606: fnd_message.set_token('LOCATION',l_location);
607:
608: errbuf := fnd_message.get();
609:
610:
604: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_OPERATION');
605: fnd_message.set_token('FILENAME',l_filename);
606: fnd_message.set_token('LOCATION',l_location);
607:
608: errbuf := fnd_message.get();
609:
610:
611: WHEN UTL_FILE.internal_error
612: -- Unspecified internal error
621: end if;
622:
623: retcode := c_error;
624:
625: fnd_message.set_name('PAY','PAY_NL_FILE_INTERNAL_ERROR');
626: fnd_message.set_token('FILENAME',l_filename);
627: fnd_message.set_token('LOCATION',l_location);
628:
629: errbuf := fnd_message.get();
622:
623: retcode := c_error;
624:
625: fnd_message.set_name('PAY','PAY_NL_FILE_INTERNAL_ERROR');
626: fnd_message.set_token('FILENAME',l_filename);
627: fnd_message.set_token('LOCATION',l_location);
628:
629: errbuf := fnd_message.get();
630:
623: retcode := c_error;
624:
625: fnd_message.set_name('PAY','PAY_NL_FILE_INTERNAL_ERROR');
626: fnd_message.set_token('FILENAME',l_filename);
627: fnd_message.set_token('LOCATION',l_location);
628:
629: errbuf := fnd_message.get();
630:
631:
625: fnd_message.set_name('PAY','PAY_NL_FILE_INTERNAL_ERROR');
626: fnd_message.set_token('FILENAME',l_filename);
627: fnd_message.set_token('LOCATION',l_location);
628:
629: errbuf := fnd_message.get();
630:
631:
632: WHEN UTL_FILE.invalid_mode
633: -- Invalid string specified for file mode
642: end if;
643:
644: retcode := c_error;
645:
646: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_MODE');
647: fnd_message.set_token('FILENAME',l_filename);
648: fnd_message.set_token('LOCATION',l_location);
649:
650: errbuf := fnd_message.get();
643:
644: retcode := c_error;
645:
646: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_MODE');
647: fnd_message.set_token('FILENAME',l_filename);
648: fnd_message.set_token('LOCATION',l_location);
649:
650: errbuf := fnd_message.get();
651:
644: retcode := c_error;
645:
646: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_MODE');
647: fnd_message.set_token('FILENAME',l_filename);
648: fnd_message.set_token('LOCATION',l_location);
649:
650: errbuf := fnd_message.get();
651:
652:
646: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_MODE');
647: fnd_message.set_token('FILENAME',l_filename);
648: fnd_message.set_token('LOCATION',l_location);
649:
650: errbuf := fnd_message.get();
651:
652:
653: WHEN UTL_FILE.invalid_path
654: -- Directory or filename is invalid or not accessible
659: END IF;
660:
661: retcode := c_error;
662:
663: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_PATH');
664:
665: errbuf := fnd_message.get();
666:
667:
661: retcode := c_error;
662:
663: fnd_message.set_name('PAY','PAY_NL_FILE_INVALID_PATH');
664:
665: errbuf := fnd_message.get();
666:
667:
668: if g_debug then
669: hr_utility.set_location (l_proc, 550);
683:
684: retcode := c_error;
685:
686:
687: fnd_message.set_name('PAY','PAY_NL_INVALID_FILE_HANDLE');
688: fnd_message.set_token('FILENAME',l_filename);
689: fnd_message.set_token('LOCATION',l_location);
690:
691: errbuf := fnd_message.get();
684: retcode := c_error;
685:
686:
687: fnd_message.set_name('PAY','PAY_NL_INVALID_FILE_HANDLE');
688: fnd_message.set_token('FILENAME',l_filename);
689: fnd_message.set_token('LOCATION',l_location);
690:
691: errbuf := fnd_message.get();
692:
685:
686:
687: fnd_message.set_name('PAY','PAY_NL_INVALID_FILE_HANDLE');
688: fnd_message.set_token('FILENAME',l_filename);
689: fnd_message.set_token('LOCATION',l_location);
690:
691: errbuf := fnd_message.get();
692:
693:
687: fnd_message.set_name('PAY','PAY_NL_INVALID_FILE_HANDLE');
688: fnd_message.set_token('FILENAME',l_filename);
689: fnd_message.set_token('LOCATION',l_location);
690:
691: errbuf := fnd_message.get();
692:
693:
694: WHEN UTL_FILE.read_error
695:
704: hr_utility.set_location (l_proc, 650);
705: end if;
706:
707:
708: fnd_message.set_name('PAY','PAY_NL_FILE_READ_ERROR');
709: fnd_message.set_token('FILENAME',l_filename);
710: fnd_message.set_token('LOCATION',l_location);
711:
712: errbuf := fnd_message.get();
705: end if;
706:
707:
708: fnd_message.set_name('PAY','PAY_NL_FILE_READ_ERROR');
709: fnd_message.set_token('FILENAME',l_filename);
710: fnd_message.set_token('LOCATION',l_location);
711:
712: errbuf := fnd_message.get();
713:
706:
707:
708: fnd_message.set_name('PAY','PAY_NL_FILE_READ_ERROR');
709: fnd_message.set_token('FILENAME',l_filename);
710: fnd_message.set_token('LOCATION',l_location);
711:
712: errbuf := fnd_message.get();
713:
714:
708: fnd_message.set_name('PAY','PAY_NL_FILE_READ_ERROR');
709: fnd_message.set_token('FILENAME',l_filename);
710: fnd_message.set_token('LOCATION',l_location);
711:
712: errbuf := fnd_message.get();
713:
714:
715:
716: END iza_upload;