167: EXCEPTION
168: WHEN OTHERS THEN
169: retcode:=2;
170: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
171: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_rultodo.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
173: END IF;
174: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
175: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
168: WHEN OTHERS THEN
169: retcode:=2;
170: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
171: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_rultodo.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
173: END IF;
174: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
175: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
176:
636: EXCEPTION
637: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
638:
639: ROLLBACK TO sp_sua;
640: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
641: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_enrolled_to_invalid.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
642: END IF;
643: l_message_text := FND_MESSAGE.GET;
644:
637: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
638:
639: ROLLBACK TO sp_sua;
640: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
641: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_enrolled_to_invalid.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
642: END IF;
643: l_message_text := FND_MESSAGE.GET;
644:
645: IF l_message_text IS NULL THEN
683:
684: WHEN OTHERS THEN
685:
686: ROLLBACK TO sp_sua;
687: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
688: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_enrolled_to_invalid.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
689: END IF;
690: l_message_text := FND_MESSAGE.GET;
691: IF l_message_text IS NULL THEN
684: WHEN OTHERS THEN
685:
686: ROLLBACK TO sp_sua;
687: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
688: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_enrolled_to_invalid.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
689: END IF;
690: l_message_text := FND_MESSAGE.GET;
691: IF l_message_text IS NULL THEN
692: l_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNEXPECTED_ERR');
1246:
1247: EXCEPTION
1248: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1249: ROLLBACK TO sp_sua;
1250: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_invalid_to_enrolled.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1252: END IF;
1253: l_message_text := FND_MESSAGE.GET;
1254:
1247: EXCEPTION
1248: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1249: ROLLBACK TO sp_sua;
1250: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_invalid_to_enrolled.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1252: END IF;
1253: l_message_text := FND_MESSAGE.GET;
1254:
1255: IF l_message_text IS NULL THEN
1292: END IF;
1293:
1294: WHEN OTHERS THEN
1295: ROLLBACK TO sp_sua;
1296: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_invalid_to_enrolled.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1298: END IF;
1299: l_message_text := FND_MESSAGE.GET;
1300: IF l_message_text IS NULL THEN
1293:
1294: WHEN OTHERS THEN
1295: ROLLBACK TO sp_sua;
1296: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_urule.enrpl_invalid_to_enrolled.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1298: END IF;
1299: l_message_text := FND_MESSAGE.GET;
1300: IF l_message_text IS NULL THEN
1301: l_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNEXPECTED_ERR');