1: PACKAGE BODY igs_he_import_popdlhe AS
2: /* $Header: IGSHE26B.pls 120.1 2006/02/08 20:03:59 anwest noship $ */
3:
4: TYPE popdlhe_dtls IS RECORD (
5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
424: END IF;
425:
426: ROLLBACK;
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: errbuf := fnd_message.get ;
431: retcode := 2;
432:
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
541: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.validate_popdlhe - ' ||SQLERRM);
542: fnd_file.put_line(fnd_file.log, fnd_message.get);
543: App_Exception.Raise_Exception;
544:
545: END validate_popdlhe;
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
611: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.get_person_id - ' ||SQLERRM);
612: fnd_file.put_line(fnd_file.log, fnd_message.get);
613: App_Exception.Raise_Exception;
614:
615: END get_person_id;
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
674: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.log_results - ' ||SQLERRM);
675: fnd_file.put_line(fnd_file.log, fnd_message.get);
676: App_Exception.Raise_Exception;
677:
678: END log_results;
676: App_Exception.Raise_Exception;
677:
678: END log_results;
679:
680: END igs_he_import_popdlhe;