36:
37: IF l_temp IS NOT NULL THEN
38:
39: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');
40: IGS_GE_MSG_STACK.ADD;
41: app_exception.Raise_Exception;
42:
43: END IF;
44:
90: Fetch cur_old_ref_values INTO old_references;
91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;
98: Close cur_old_ref_values;
162: Column_Name IS NULL THEN
163: IF NOT (new_references.total_cp_earned >=0) THEN
164: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_EARNED'));
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170:
173: Column_Name IS NULL THEN
174: IF NOT (new_references.total_gpa_units >=0) THEN
175: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_GPA_UNITS'));
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
181:
184: Column_Name IS NULL THEN
185: IF NOT (new_references.total_unit_gp >= 0) THEN
186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_UNIT_GP'));
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
194: IF Upper(Column_Name) = 'END_DATE' OR
195: Column_Name IS NULL THEN
196: IF ( NOT (new_references.end_date > new_references.start_date) OR new_references.start_date > SYSDATE ) THEN
197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ST_DT_ED_DT');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:
205: Column_Name IS NULL THEN
206: IF NOT (new_references.total_cp_attempted >=0) THEN
207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_ATTEMPTED'));
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213:
235: new_references.transcript_id
236: ) THEN
237: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT'));
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242:
243: END Check_Parent_Existance;
326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATD_ATRN_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
392: Null;
393: IF Get_Pk_For_Validation(
394: new_references.term_details_id) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;
400: Check_Parent_Existance;
413: -- Call all the procedures related to Before Insert.
414: IF Get_PK_For_Validation (
415: new_references.term_details_id) THEN
416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Constraints;
421: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
520: X_PROGRAM_UPDATE_DATE := SYSDATE;
521: end if;
522: else
523: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
524: IGS_GE_MSG_STACK.ADD;
525: app_exception.raise_exception;
526: end if;
527:
528: X_TERM_DETAILS_ID := -1;
606: WHEN OTHERS THEN
607: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
609: fnd_message.set_token ('ERR_CD', SQLCODE);
610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;
613: ELSE
614: igs_sc_gen_001.unset_ctx('R');
657: open c1;
658: fetch c1 into tlinfo;
659: if (c1%notfound) then
660: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
661: IGS_GE_MSG_STACK.ADD;
662: close c1;
663: app_exception.raise_exception;
664: return;
665: end if;
686: ) then
687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;
694: end LOCK_ROW;
739: X_LAST_UPDATE_LOGIN := -1;
740: end if;
741: else
742: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
743: IGS_GE_MSG_STACK.ADD;
744: app_exception.raise_exception;
745: end if;
746: Before_DML(
747: p_action=>'UPDATE',
798: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
799: where ROWID = X_ROWID;
800: if (sql%notfound) then
801: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
802: igs_ge_msg_stack.add;
803: igs_sc_gen_001.unset_ctx('R');
804: app_exception.raise_exception;
805: end if;
806: IF (x_mode = 'S') THEN
816: WHEN OTHERS THEN
817: IF (SQLCODE = (-28115)) THEN
818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
819: fnd_message.set_token ('ERR_CD', SQLCODE);
820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;
823: ELSE
824: igs_sc_gen_001.unset_ctx('R');
915: delete from IGS_AD_TERM_DETAILS
916: where ROWID = X_ROWID;
917: if (sql%notfound) then
918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: end if;
923: IF (x_mode = 'S') THEN