160: IF c_header%NOTFOUND THEN
161: CLOSE c_header;
162: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
163: -- Message : Response File uploaded is not complete.
164: igs_ge_msg_stack.add;
165: RAISE FILE_NOT_LOADED;
166: END IF;
167: CLOSE c_header;
168:
174: OR l_dl_file_type = 'INVALID-FILE'
175: OR l_dl_file_type <> 'DL_CHG_ACK' THEN
176: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
177: -- Message : This is not a valid file
178: igs_ge_msg_stack.add;
179: RAISE FILE_NOT_LOADED;
180: END IF;
181:
182: -- pssahni 07-Feb-2005
204: l_reject_rec, l_pending_rec;
205: IF c_trailer%NOTFOUND THEN
206: CLOSE c_trailer;
207: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
208: igs_ge_msg_stack.add;
209: RAISE FILE_NOT_LOADED;
210: END IF;
211: CLOSE c_trailer;
212:
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;
221: RAISE FILE_NOT_LOADED;
222: END IF;
223:
224: -- Check if the File already Loaded earlier or not
287: END LOOP;
288: IF l_actual_rec <> l_number_rec THEN
289: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
290: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
291: igs_ge_msg_stack.add;
292: RAISE FILE_NOT_LOADED;
293: END IF;
294:
295: END IF; -- End of condition for VERSION.
308: RAISE;
309: WHEN OTHERS THEN
310: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
311: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.dl_load_data'||sqlerrm);
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END dl_load_data;
315:
316:
608: WHEN FILE_NOT_LOADED THEN
609: ROLLBACK;
610: retcode := 2;
611: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
612: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
613: WHEN FILE_ALREADY_LOADED THEN
614: ROLLBACK;
615: retcode := 2;
616: errbuf := fnd_message.get_string('IGF','IGF_GE_BATCH_ALEARDY_LOADED');
613: WHEN FILE_ALREADY_LOADED THEN
614: ROLLBACK;
615: retcode := 2;
616: errbuf := fnd_message.get_string('IGF','IGF_GE_BATCH_ALEARDY_LOADED');
617: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
618:
619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;
621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');
625: WHEN OTHERS THEN
626: ROLLBACK;
627: retcode := 2;
628: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
629: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
630: END dl_chg_ack;
631:
632:
633:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
679: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_dl_chg_resp');
680: igs_ge_msg_stack.add;
681: app_exception.raise_exception;
682: END upd_dl_chg_resp;
683:
684:
764: EXCEPTION
765: WHEN others THEN
766: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
767: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_loan_record');
768: igs_ge_msg_stack.add;
769: app_exception.raise_exception;
770: END upd_loan_record;
771:
772:
1011: EXCEPTION
1012: WHEN others THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_lor_loc_record');
1015: igs_ge_msg_stack.add;
1016: app_exception.raise_exception;
1017: END upd_lor_loc_record;
1018:
1019: