[Home] [Help]
46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;
104: IF Upper(Column_Name) = 'MIN_SCORE' OR
105: Column_Name IS NULL THEN
106: IF NOT (new_references.min_score >= 0) THEN
107: Fnd_Message.Set_Name('IGS','IGS_AD_MIN_NOT_LT_0');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:
115: IF Upper(Column_Name) = 'MIN_SCORE' OR
116: Column_Name IS NULL THEN
117: IF NOT (new_references.min_score <= new_references.max_score) THEN
118: Fnd_Message.Set_Name('IGS','IGS_AD_MIN_NOT_GT_MAX');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
126: IF Upper(Column_Name) = 'MAX_SCORE' OR
127: Column_Name IS NULL THEN
128: IF NOT (new_references.max_score >= new_references.min_score) THEN
129: Fnd_Message.Set_Name('IGS','IGS_AD_MAX_NOT_LT_MIN');
130: IGS_GE_MSG_STACK.ADD;
131: App_Exception.Raise_Exception;
132: END IF;
133: END IF;
134:
136: IF Upper(Column_Name) = 'DEFINITION_LEVEL' OR
137: Column_Name IS NULL THEN
138: IF NOT (new_references.definition_level IN ('T','S')) THEN
139: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:
162: new_references.admission_test_type,
163: new_references.test_segment_id
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 ;
170:
191: new_references.admission_test_type,
192: 'N'
193: ) THEN
194: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198:
199: IF (((old_references.test_segment_id = new_references.test_segment_id)) OR
203: new_references.test_segment_id ,
204: 'N'
205: ) THEN
206: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210:
211: END Check_Parent_Existance;
353: Fetch cur_rowid INTO lv_rowid;
354: IF (cur_rowid%FOUND) THEN
355: Close cur_rowid;
356: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUH_ADMTT_FK');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: Return;
360: END IF;
361: Close cur_rowid;
390: Fetch cur_rowid INTO lv_rowid;
391: IF (cur_rowid%FOUND) THEN
392: Close cur_rowid;
393: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUH_ATS_FK');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: Return;
397: END IF;
398: Close cur_rowid;
448: Null;
449: IF Get_Pk_For_Validation(
450: new_references.up_header_id) THEN
451: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454: END IF;
455: Check_Constraints;
456: Check_Uniqueness;
469: -- Call all the procedures related to Before Insert.
470: IF Get_PK_For_Validation (
471: new_references.up_header_id) THEN
472: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: Check_Constraints;
477: Check_Uniqueness;
558: X_LAST_UPDATE_LOGIN := -1;
559: end if;
560: else
561: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
562: IGS_GE_MSG_STACK.ADD;
563: app_exception.raise_exception;
564: end if;
565:
566: X_UP_HEADER_ID := -1;
647: open c1;
648: fetch c1 into tlinfo;
649: if (c1%notfound) then
650: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
651: IGS_GE_MSG_STACK.ADD;
652: close c1;
653: app_exception.raise_exception;
654: return;
655: end if;
662: ) then
663: null;
664: else
665: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
666: IGS_GE_MSG_STACK.ADD;
667: app_exception.raise_exception;
668: end if;
669: return;
670: end LOCK_ROW;
707: X_LAST_UPDATE_LOGIN := -1;
708: end if;
709: else
710: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
711: IGS_GE_MSG_STACK.ADD;
712: app_exception.raise_exception;
713: end if;
714: Before_DML(
715: p_action=>'UPDATE',