[Home] [Help]
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;
55:
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:
113:
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:
124:
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:
135: -- The following code checks for check constraints on the Columns.
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:
145:
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:
171:
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
200: ((new_references.test_segment_id IS NULL))) THEN
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;
212:
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;
362:
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;
399:
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;
457: Check_Parent_Existance;
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;
478: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
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;
567: Before_DML(
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;
656: close c1;
657: if ( ( tlinfo.MAX_SCORE = X_MAX_SCORE)
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;
671: Procedure UPDATE_ROW (
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',
716: x_rowid=>X_ROWID,