DBA Data[Home] [Help]

APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_EN_VAL_BULKRULE

Line 1: PACKAGE BODY IGS_EN_VAL_BULKRULE AS

1: PACKAGE BODY IGS_EN_VAL_BULKRULE AS
2: /* $Header: IGSEN28B.pls 120.2 2006/05/02 23:54:29 ckasu noship $ */
3: /* smaddali modified all the procedures , added new parameters during
4: nov 2001 build of enrollment processes dld , bug#1832130 */
5: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

Line 137: IGS_EN_VAL_BULKRULE.enrp_val_sca_urule(

133: -- Call routine to process individual student Course
134: -- attempt.
135: --added 4 new parameters to this call for enrollment processes dld
136:
137: IGS_EN_VAL_BULKRULE.enrp_val_sca_urule(
138: p_acad_cal_type,
139: p_acad_sequence_number,
140: v_st_rec.person_id,
141: v_sca_rec.course_cd,

Line 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);

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:

Line 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);

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

Line 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);

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');

Line 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);

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

Line 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);

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');

Line 1415: END IGS_EN_VAL_BULKRULE;

1411: IGS_GE_MSG_STACK.ADD;
1412: App_Exception.Raise_Exception;
1413: END;
1414: END enrp_val_sca_urule;
1415: END IGS_EN_VAL_BULKRULE;