[Home] [Help]
76: Open cur_old_ref_values;
77: Fetch cur_old_ref_values INTO old_references;
78: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
79: Close cur_old_ref_values;
80: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: Return;
84: END IF;
182:
183: IF UPPER(Column_Name) = 'COURSE_CD' OR
184: Column_Name IS NULL THEN
185: IF new_references.COURSE_CD <> UPPER(new_references.course_cd) THEN
186: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191:
192: IF UPPER(Column_Name) = 'APPEAL_OUTCOME_TYPE' OR
193: Column_Name IS NULL THEN
194: IF new_references.APPEAL_OUTCOME_TYPE <> UPPER(new_references.appeal_outcome_type) THEN
195: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: END IF;
201:
202: IF UPPER(Column_Name) = 'DECISION_STATUS' OR
203: Column_Name IS NULL THEN
204: IF new_references.DECISION_STATUS <> UPPER(new_references.decision_status) THEN
205: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210:
211: IF UPPER(Column_Name) = 'DURATION_TYPE' OR
212: Column_Name IS NULL THEN
213: IF new_references.DURATION_TYPE <> UPPER(new_references.duration_type) THEN
214: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
219:
220: IF UPPER(Column_Name) = 'ENCMB_COURSE_GROUP_CD' OR
221: Column_Name IS NULL THEN
222: IF new_references.ENCMB_COURSE_GROUP_CD <> UPPER(new_references.encmb_course_group_cd) THEN
223: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
228:
229: IF UPPER(Column_Name) = 'HIST_WHO' OR
230: Column_Name IS NULL THEN
231: IF new_references.HIST_WHO <> UPPER(new_references.hist_who) THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: END IF;
237:
238: IF UPPER(Column_Name) = 'PRG_CAL_TYPE' OR
239: Column_Name IS NULL THEN
240: IF new_references.PRG_CAL_TYPE <> UPPER(new_references.prg_cal_type) THEN
241: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246:
247: IF UPPER(Column_Name) = 'PROGRESSION_OUTCOME_TYPE' OR
248: Column_Name IS NULL THEN
249: IF new_references.PROGRESSION_OUTCOME_TYPE <> UPPER(new_references.progression_outcome_type) THEN
250: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: END IF;
255:
256: IF UPPER(Column_Name) = 'PROGRESSION_RULE_CAT' OR
257: Column_Name IS NULL THEN
258: IF new_references.PROGRESSION_RULE_CAT <> UPPER(new_references.progression_rule_cat) THEN
259: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:
265: IF UPPER(Column_Name) = 'RESTRICTED_ATTENDANCE_TYPE' OR
266: Column_Name IS NULL THEN
267: IF new_references.RESTRICTED_ATTENDANCE_TYPE <> UPPER(new_references.restricted_attendance_type) THEN
268: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
299: new_references.person_id,
300: new_references.course_cd,
301: new_references.sequence_number
302: ) THEN
303: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307:
380: Open cur_rowid;
381: Fetch cur_rowid INTO lv_rowid;
382: IF (cur_rowid%FOUND) THEN
383: Close cur_rowid;
384: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception;
387: Return;
388: END IF;
503: new_references.person_id,
504: new_references.course_cd,
505: new_references.sequence_number,
506: new_references.hist_start_dt) THEN
507: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511: Check_Constraints;
524: new_references.person_id,
525: new_references.course_cd,
526: new_references.sequence_number,
527: new_references.hist_start_dt) THEN
528: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
529: IGS_GE_MSG_STACK.ADD;
530: App_Exception.Raise_Exception;
531: END IF;
532: Check_Constraints;
645: if X_LAST_UPDATE_LOGIN is NULL then
646: X_LAST_UPDATE_LOGIN := -1;
647: end if;
648: else
649: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
650: IGS_GE_MSG_STACK.ADD;
651: app_exception.raise_exception;
652: end if;
653: Before_DML(
883: begin
884: open c1;
885: fetch c1 into tlinfo;
886: if (c1%notfound) then
887: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
888: IGS_GE_MSG_STACK.ADD;
889: close c1;
890: app_exception.raise_exception;
891: return;
985: AND (X_SHOW_CAUSE_OUTCOME_TYPE is null)))
986: ) then
987: null;
988: else
989: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
990: IGS_GE_MSG_STACK.ADD;
991: app_exception.raise_exception;
992: end if;
993: return;
1060: if X_LAST_UPDATE_LOGIN is NULL then
1061: X_LAST_UPDATE_LOGIN := -1;
1062: end if;
1063: else
1064: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1065: IGS_GE_MSG_STACK.ADD;
1066: app_exception.raise_exception;
1067: end if;
1068: Before_DML(