[Home] [Help]
38: Open cur_old_ref_values;
39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
89: new_references.grd_cal_type,
90: new_references.grd_ci_sequence_number,
91: new_references.ceremony_number,
92: v_message_name) = FALSE THEN
93: Fnd_Message.Set_Name('IGS', v_message_name);
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;
104: new_references.award_course_cd,
105: new_references.award_crs_version_number,
106: new_references.award_cd,
107: v_message_name) = FALSE THEN
108: Fnd_Message.Set_Name('IGS', v_message_name);
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
140: new_references.award_crs_version_number,
141: new_references.award_cd,
142: new_references.us_group_number,
143: v_message_name) = FALSE THEN
144: Fnd_Message.Set_Name('IGS', v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: v_rowid_saved := TRUE;
161: NEW_REFERENCES.award_crs_version_number,
162: NEW_REFERENCES.award_cd,
163: NEW_REFERENCES.order_in_award
164: ) THEN
165: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END Check_Uniqueness;
192: new_references.award_course_cd,
193: new_references.award_crs_version_number,
194: new_references.award_cd
195: ) THEN
196: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
290: Open cur_rowid;
291: Fetch cur_rowid INTO lv_rowid;
292: IF (cur_rowid%FOUND) THEN
293: Close cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUSG_AWC_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: Return;
298: END IF;
352: NEW_REFERENCES.award_crs_version_number,
353: NEW_REFERENCES.award_cd,
354: NEW_REFERENCES.us_group_number
355: ) THEN
356: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359:
360: END IF;
381: NEW_REFERENCES.award_crs_version_number,
382: NEW_REFERENCES.award_cd,
383: NEW_REFERENCES.us_group_number
384: ) THEN
385: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388:
389: END IF;
454: if X_LAST_UPDATE_LOGIN is NULL then
455: X_LAST_UPDATE_LOGIN := -1;
456: end if;
457: else
458: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
459: IGS_GE_MSG_STACK.ADD;
460: app_exception.raise_exception;
461: end if;
462:
549: open c1;
550: fetch c1 into tlinfo;
551: if (c1%notfound) then
552: close c1;
553: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
554: app_exception.raise_exception;
555: return;
556: end if;
557: close c1;
563: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
564: ) then
565: null;
566: else
567: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
568: app_exception.raise_exception;
569: end if;
570: return;
571: end LOCK_ROW;
601: if X_LAST_UPDATE_LOGIN is NULL then
602: X_LAST_UPDATE_LOGIN := -1;
603: end if;
604: else
605: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: end if;
609:
785:
786: IF upper(Column_name) = 'US_GROUP_NUMBER' OR column_name IS NULL then
787: IF new_references.us_group_number < 0 OR
788: new_references.us_group_number > 999999 THEN
789: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
790: IGS_GE_MSG_STACK.ADD;
791: App_Exception.Raise_Exception;
792: END IF;
793: END IF;
792: END IF;
793: END IF;
794: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
795: IF new_references.closed_ind NOT IN('Y','N') THEN
796: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
797: IGS_GE_MSG_STACK.ADD;
798: App_Exception.Raise_Exception;
799: END IF;
800: END IF;
801:
802: IF upper(Column_name) = 'ORDER_IN_AWARD' OR column_name IS NULL then
803: IF new_references.ORDER_IN_AWARD < 0 OR
804: new_references.ORDER_IN_AWARD > 999 THEN
805: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
806: IGS_GE_MSG_STACK.ADD;
807: App_Exception.Raise_Exception;
808: END IF;
809: END IF;
810:
811:
812: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
813: IF new_references.award_cd <> UPPER(new_references.award_cd) THEN
814: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
815: IGS_GE_MSG_STACK.ADD;
816: App_Exception.Raise_Exception;
817: END IF;
818: END IF;
820:
821:
822: IF upper(Column_name) = 'AWARD_COURSE_CD' OR column_name IS NULL then
823: IF new_references.award_course_cd <> UPPER(new_references.award_course_cd) THEN
824: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
825: IGS_GE_MSG_STACK.ADD;
826: App_Exception.Raise_Exception;
827: END IF;
828: END IF;
828: END IF;
829:
830: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then
831: IF new_references.grd_cal_type <> UPPER(new_references.grd_cal_type) THEN
832: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
833: App_Exception.Raise_Exception;
834: END IF;
835: END IF;
836: