787: END;
788:
789: EXCEPTION
790: WHEN UTL_FILE.INVALID_PATH THEN
791: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
792: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
793: user_error := substrb(fnd_message.get, 1, 255);
794:
795: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_PATH');
788:
789: EXCEPTION
790: WHEN UTL_FILE.INVALID_PATH THEN
791: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
792: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
793: user_error := substrb(fnd_message.get, 1, 255);
794:
795: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_PATH');
796: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
789: EXCEPTION
790: WHEN UTL_FILE.INVALID_PATH THEN
791: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
792: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
793: user_error := substrb(fnd_message.get, 1, 255);
794:
795: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_PATH');
796: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
797:
791: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
792: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
793: user_error := substrb(fnd_message.get, 1, 255);
794:
795: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_PATH');
796: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
797:
798: raise_application_error(-20100, user_error);
799:
792: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
793: user_error := substrb(fnd_message.get, 1, 255);
794:
795: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_PATH');
796: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
797:
798: raise_application_error(-20100, user_error);
799:
800: WHEN UTL_FILE.INVALID_MODE THEN
797:
798: raise_application_error(-20100, user_error);
799:
800: WHEN UTL_FILE.INVALID_MODE THEN
801: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
802: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
798: raise_application_error(-20100, user_error);
799:
800: WHEN UTL_FILE.INVALID_MODE THEN
801: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
802: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
806: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
799:
800: WHEN UTL_FILE.INVALID_MODE THEN
801: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
802: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
806: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
807: fnd_message.set_token('FILE_MODE', 'w', FALSE);
801: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
802: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
806: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
807: fnd_message.set_token('FILE_MODE', 'w', FALSE);
808:
809: raise_application_error(-20100, user_error);
802: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
806: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
807: fnd_message.set_token('FILE_MODE', 'w', FALSE);
808:
809: raise_application_error(-20100, user_error);
810:
803: user_error := substrb(fnd_message.get, 1, 255);
804:
805: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_MODE');
806: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
807: fnd_message.set_token('FILE_MODE', 'w', FALSE);
808:
809: raise_application_error(-20100, user_error);
810:
811: WHEN UTL_FILE.INVALID_OPERATION THEN
808:
809: raise_application_error(-20100, user_error);
810:
811: WHEN UTL_FILE.INVALID_OPERATION THEN
812: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
813: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
809: raise_application_error(-20100, user_error);
810:
811: WHEN UTL_FILE.INVALID_OPERATION THEN
812: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
813: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
817: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
810:
811: WHEN UTL_FILE.INVALID_OPERATION THEN
812: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
813: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
817: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
818: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
812: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
813: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
817: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
818: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
819:
820: raise_application_error(-20100, user_error);
813: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
817: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
818: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
819:
820: raise_application_error(-20100, user_error);
821:
814: user_error := substrb(fnd_message.get, 1, 255);
815:
816: fnd_message.set_name('FND','CONC-TEMPFILE_INVALID_OPERATN');
817: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
818: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
819:
820: raise_application_error(-20100, user_error);
821:
822: WHEN UTL_FILE.INVALID_MAXLINESIZE THEN
819:
820: raise_application_error(-20100, user_error);
821:
822: WHEN UTL_FILE.INVALID_MAXLINESIZE THEN
823: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
824: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
820: raise_application_error(-20100, user_error);
821:
822: WHEN UTL_FILE.INVALID_MAXLINESIZE THEN
823: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
824: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
828: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
821:
822: WHEN UTL_FILE.INVALID_MAXLINESIZE THEN
823: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
824: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
828: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
829: fnd_message.set_token('MAXLINE', MAX_LINESIZE, FALSE);
823: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
824: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
828: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
829: fnd_message.set_token('MAXLINE', MAX_LINESIZE, FALSE);
830:
831: raise_application_error(-20100, user_error);
824: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
828: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
829: fnd_message.set_token('MAXLINE', MAX_LINESIZE, FALSE);
830:
831: raise_application_error(-20100, user_error);
832:
825: user_error := substrb(fnd_message.get, 1, 255);
826:
827: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_MAXLINESIZE');
828: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
829: fnd_message.set_token('MAXLINE', MAX_LINESIZE, FALSE);
830:
831: raise_application_error(-20100, user_error);
832:
833: WHEN UTL_FILE.WRITE_ERROR THEN
830:
831: raise_application_error(-20100, user_error);
832:
833: WHEN UTL_FILE.WRITE_ERROR THEN
834: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
835: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
831: raise_application_error(-20100, user_error);
832:
833: WHEN UTL_FILE.WRITE_ERROR THEN
834: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
835: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
839: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
832:
833: WHEN UTL_FILE.WRITE_ERROR THEN
834: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
835: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
839: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
840: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
834: fnd_message.set_name('FND', 'CONC-FILE_ERROR');
835: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
839: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
840: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
841:
842: raise_application_error(-20100, user_error);
835: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
839: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
840: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
841:
842: raise_application_error(-20100, user_error);
843:
836: user_error := substrb(fnd_message.get, 1, 255);
837:
838: fnd_message.set_name('FND', 'CONC-TEMPFILE_WRITE_ERROR');
839: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
840: fnd_message.set_token('TEMP_DIR', TEMP_DIR, FALSE);
841:
842: raise_application_error(-20100, user_error);
843:
844: WHEN DELETE_ERROR THEN
841:
842: raise_application_error(-20100, user_error);
843:
844: WHEN DELETE_ERROR THEN
845: fnd_message.set_name('FND', 'DELETE_ERROR');
846: raise_application_error(-20100, 'DELETE_ERROR');
847:
848: WHEN FOREIGN_KEY_ERROR THEN
849: fnd_message.set_name('FND', 'FOREIGN_KEY_ERROR');
845: fnd_message.set_name('FND', 'DELETE_ERROR');
846: raise_application_error(-20100, 'DELETE_ERROR');
847:
848: WHEN FOREIGN_KEY_ERROR THEN
849: fnd_message.set_name('FND', 'FOREIGN_KEY_ERROR');
850: raise_application_error(-20100, 'FOREIGN_KEY_ERROR');
851:
852: WHEN OTHERS THEN
853: app_exception.raise_exception;