[Home] [Help]
48: OPEN cur_old_ref_values;
49: FETCH cur_old_ref_values INTO old_references;
50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
51: CLOSE cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: RETURN;
56: END IF;
101: new_references.transfer_course_cd,
102: new_references.transfer_dt,
103: v_message_name) = FALSE THEN
104:
105: Fnd_Message.Set_Name('IGS', v_message_name);
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
127:
128: IF UPPER(column_name) = 'COURSE_CD' OR
129: column_name IS NULL THEN
130: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF UPPER(column_name) = 'TRANSFER_COURSE_CD' OR
138: column_name IS NULL THEN
139: IF new_references.transfer_course_cd <> UPPER(new_references.transfer_course_cd) THEN
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
156: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (
157: new_references.person_id,
158: new_references.transfer_course_cd
159: ) THEN
160: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: --Uncommented This
163: App_Exception.Raise_Exception;
164:
175: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (
176: new_references.person_id,
177: new_references.transfer_course_cd
178: ) THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
191: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation(
192: new_references.effective_term_cal_type,
193: new_references.effective_term_sequence_num) THEN
194:
195: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198:
199: END IF;
264: OPEN cur_rowid;
265: FETCH cur_rowid INTO lv_rowid;
266: IF (cur_rowid%FOUND) THEN
267: CLOSE cur_rowid;
268: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCT_SCA_FK');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: RETURN;
272: END IF;
331: new_references.course_cd,
332: new_references.transfer_course_cd,
333: new_references.transfer_dt
334: ) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: Check_Constraints;
353: new_references.course_cd,
354: new_references.transfer_course_cd,
355: new_references.transfer_dt
356: ) THEN
357: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
358: IGS_GE_MSG_STACK.ADD;
359: App_Exception.Raise_Exception;
360: END IF;
361: Check_Constraints;
470: IF X_LAST_UPDATE_LOGIN IS NULL THEN
471: X_LAST_UPDATE_LOGIN := -1;
472: END IF;
473: ELSE
474: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: END IF;
478: Before_DML( p_action => 'INSERT',
582: OPEN c1;
583: FETCH c1 INTO tlinfo;
584: IF (c1%NOTFOUND) THEN
585: CLOSE c1;
586: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
587: IGS_GE_MSG_STACK.ADD;
588: app_exception.raise_exception;
589: RETURN;
590: END IF;
633:
634: ) THEN
635: NULL;
636: ELSE
637: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: END IF;
641: RETURN;
677: IF X_LAST_UPDATE_LOGIN IS NULL THEN
678: X_LAST_UPDATE_LOGIN := -1;
679: END IF;
680: ELSE
681: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
682: IGS_GE_MSG_STACK.ADD;
683: app_exception.raise_exception;
684: END IF;
685: Before_DML( p_action => 'UPDATE',