[Home] [Help]
66: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
67: Close cur_old_ref_values;
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: Return;
72: END IF;
73: Close cur_old_ref_values;
74:
148: new_references.course_cd,
149: v_message_name) = FALSE THEN
150: fnd_message.set_name('IGS',v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: app_exception.raise_exception;
153: END IF;
154: -- Validate for start_dt > end_dt
155: IF igs_ad_val_edtl.genp_val_strt_end_dt (
156: new_references.start_dt,
157: new_references.end_dt,
158: v_message_name) = FALSE THEN
159: fnd_message.set_name('IGS',v_message_name);
160: IGS_GE_MSG_STACK.ADD;
161: app_exception.raise_exception;
162: END IF;
163: END IF;
164: END IF;
165:
193: NEW_REFERENCES.end_dt,
194: v_message_name) = FALSE THEN
195: fnd_message.set_name('IGS',v_message_name);
196: IGS_GE_MSG_STACK.ADD;
197: app_exception.raise_exception;
198: END IF;
199: END IF;
200: END IF;
201:
283: if new_references.voluntary_ind not IN ('Y','N') OR
284: new_references.voluntary_ind <> upper(new_references.voluntary_ind) then
285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: end if;
289: end if;
290:
291: IF upper(column_name) = 'COND_RETURN_FLAG' OR
294: AND new_references.COND_RETURN_FLAG IS NOT NULL THEN
295: --
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: END IF;
301:
302: IF upper(column_name) = 'APPROVED' OR
303: column_name is null then
304: if new_references.approved NOT IN ('Y','N') THEN
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: end if;
309: end if;
310:
311: IF upper(column_name) = 'COURSE_CD' OR
312: column_name is null then
313: if new_references.course_cd <> upper(new_references.course_cd) then
314: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: end if;
318: end if;
319: END check_constraints;
320:
353: new_references.course_cd
354: ) Then
355: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: end if;
359: END IF;
360:
361: IF ((old_references.intermission_type = new_references.intermission_type) OR
366: new_references.intermission_type
367: ) Then
368: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: end if;
372: END IF;
373:
374: IF ((old_references.APPROVER_ID = new_references.APPROVER_ID) OR
382: ELSE
383: Close cur_rowid_HP;
384: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception;
387: END IF;
388: END IF;
389:
390: IF ((old_references.INSTITUTION_NAME = new_references.INSTITUTION_NAME) OR
398: ELSE
399: Close cur_exists_ioie;
400: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
401: IGS_GE_MSG_STACK.ADD;
402: App_Exception.Raise_Exception;
403: END IF;
404: END IF;
405:
406: END Check_Parent_Existance;
591: new_references.logical_delete_date
592: ) THEN
593: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
594: IGS_GE_MSG_STACK.ADD;
595: App_Exception.Raise_Exception;
596: end if;
597: Check_constraints;
598: Check_Parent_Existance;
599: ELSIF (p_action = 'UPDATE') THEN
619: new_references.logical_delete_date
620: ) THEN
621: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
622: IGS_GE_MSG_STACK.ADD;
623: App_Exception.Raise_Exception;
624: end if;
625: Check_constraints;
626: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
627: Check_constraints;
738: end if;
739: else
740: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
741: IGS_GE_MSG_STACK.ADD;
742: app_exception.raise_exception;
743: end if;
744:
745: Before_DML(
746: p_action => 'INSERT',
900: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
901: fnd_message.set_token ('ERR_CD', SQLCODE);
902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;
905: ELSE
906: igs_sc_gen_001.unset_ctx('R');
907: RAISE;
908: END IF;
993: if (c1%notfound) then
994: close c1;
995: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
996: IGS_GE_MSG_STACK.ADD;
997: app_exception.raise_exception;
998: return;
999: end if;
1000: close c1;
1001:
1094: null;
1095: else
1096: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1097: IGS_GE_MSG_STACK.ADD;
1098: app_exception.raise_exception;
1099: end if;
1100: return;
1101: end LOCK_ROW;
1102:
1159: end if;
1160: else
1161: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1162: IGS_GE_MSG_STACK.ADD;
1163: app_exception.raise_exception;
1164: end if;
1165:
1166: Before_DML(
1167: p_action => 'UPDATE',
1254: if (sql%notfound) then
1255: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1256: igs_ge_msg_stack.add;
1257: igs_sc_gen_001.unset_ctx('R');
1258: app_exception.raise_exception;
1259: end if;
1260: IF (x_mode = 'S') THEN
1261: igs_sc_gen_001.unset_ctx('R');
1262: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE
1279: igs_sc_gen_001.unset_ctx('R');
1280: RAISE;
1281: END IF;
1438: if (sql%notfound) then
1439: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1440: igs_ge_msg_stack.add;
1441: igs_sc_gen_001.unset_ctx('R');
1442: app_exception.raise_exception;
1443: end if;
1444: IF (x_mode = 'S') THEN
1445: igs_sc_gen_001.unset_ctx('R');
1446: END IF;