1637: END LOOP;
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2003');
1643: fnd_file.put_line(fnd_file.log, fnd_message.get);
1644: App_Exception.Raise_Exception;
1645:
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2003');
1643: fnd_file.put_line(fnd_file.log, fnd_message.get);
1644: App_Exception.Raise_Exception;
1645:
1646: END proc_tranin_2003;
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2003');
1643: fnd_file.put_line(fnd_file.log, fnd_message.get);
1644: App_Exception.Raise_Exception;
1645:
1646: END proc_tranin_2003;
1647:
1935: END LOOP;
1936:
1937: EXCEPTION
1938: WHEN OTHERS THEN
1939: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1940: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2004'||' - '||SQLERRM);
1941: fnd_file.put_line(fnd_file.log, fnd_message.get);
1942: App_Exception.Raise_Exception;
1943:
1936:
1937: EXCEPTION
1938: WHEN OTHERS THEN
1939: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1940: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2004'||' - '||SQLERRM);
1941: fnd_file.put_line(fnd_file.log, fnd_message.get);
1942: App_Exception.Raise_Exception;
1943:
1944: END proc_tranin_2004;
1937: EXCEPTION
1938: WHEN OTHERS THEN
1939: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1940: Fnd_Message.Set_Token('NAME','igs_uc_tran_processor_pkg.proc_tranin_2004'||' - '||SQLERRM);
1941: fnd_file.put_line(fnd_file.log, fnd_message.get);
1942: App_Exception.Raise_Exception;
1943:
1944: END proc_tranin_2004;
1945:
1975:
1976: BEGIN
1977: --To generate the Header Line in the Log File
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',105,'-'));
1979: FND_MESSAGE.SET_NAME('IGS','IGS_UC_TRANS_LOG_HEADER');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1981: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',105,'-'));
1982:
1983: -- get the ucas configured cycle
1976: BEGIN
1977: --To generate the Header Line in the Log File
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',105,'-'));
1979: FND_MESSAGE.SET_NAME('IGS','IGS_UC_TRANS_LOG_HEADER');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1981: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',105,'-'));
1982:
1983: -- get the ucas configured cycle
1984: OPEN cur_cycle;
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: ROLLBACK;
2001: retcode :=2;
2002: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2003: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_TRAN_PROCESSOR_PKG.TRANS_WRITE'||' - '||SQLERRM);
2004: Errbuf := FND_MESSAGE.GET;
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,Errbuf);
2006: app_exception.raise_exception;
1999: WHEN OTHERS THEN
2000: ROLLBACK;
2001: retcode :=2;
2002: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2003: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_TRAN_PROCESSOR_PKG.TRANS_WRITE'||' - '||SQLERRM);
2004: Errbuf := FND_MESSAGE.GET;
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,Errbuf);
2006: app_exception.raise_exception;
2007:
2000: ROLLBACK;
2001: retcode :=2;
2002: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2003: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_TRAN_PROCESSOR_PKG.TRANS_WRITE'||' - '||SQLERRM);
2004: Errbuf := FND_MESSAGE.GET;
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,Errbuf);
2006: app_exception.raise_exception;
2007:
2008: END trans_write;