[Home] [Help]
72: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: Close cur_old_ref_values;
76: App_Exception.Raise_Exception;
77: Return;
78: END IF;
79: Close cur_old_ref_values;
80:
154: IF IGS_AS_VAL_AI.assp_val_atyp_closed(new_references.assessment_type,
155: v_message_name) = FALSE THEN
156: Fnd_Message.Set_Name('IGS', v_message_name);
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161: -- Validate that inserts/updates are allowed
162: IF p_inserting OR p_updating THEN
178: new_references.ass_length_or_duration,
179: v_message_name) = FALSE THEN
180: Fnd_Message.Set_Name('IGS', v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: --
185: -- Validate exam times
186: IF IGS_AS_VAL_AI.assp_val_ai_ex_times(new_references.assessment_type,
188: new_references.exam_perusal_time,
189: v_message_name) = FALSE THEN
190: Fnd_Message.Set_Name('IGS', v_message_name);
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194: END IF;
195:
196:
222: v_message_name) = FALSE THEN
223: -- Error.
224: Fnd_Message.Set_Name('IGS', v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228:
229:
230: END IF;
250: new_references.assessment_type
251: ))THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256:
257: END IF;
258:
276: column_name is null Then
277: IF new_references.assessment_type <> UPPER(new_references.assessment_type) Then
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:
284: IF upper(column_name) = 'ASS_LENGTH_OR_DURATION' OR
285: column_name is null Then
286: IF new_references.ass_length_or_duration <> UPPER(new_references.ass_length_or_duration) Then
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: END IF;
292:
293: IF upper(column_name) = 'EXAM_SCHEDULED_IND' OR
294: column_name is null Then
295: IF new_references.exam_scheduled_ind <> UPPER(new_references.exam_scheduled_ind) OR new_references.exam_scheduled_ind NOT IN ( 'Y' , 'N' ) Then
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: END Check_Constraints;
374: IF (cur_rowid%FOUND) THEN
375: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AI_ATYP_FK');
376: IGS_GE_MSG_STACK.ADD;
377: Close cur_rowid;
378: App_Exception.Raise_Exception;
379: Return;
380: END IF;
381: Close cur_rowid;
382:
494: new_references.ass_id
495: ) THEN
496: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: END IF;
500:
501: Check_Constraints;
502: Check_Parent_Existance;
514: new_references.ass_id
515: ) THEN
516: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
517: IGS_GE_MSG_STACK.ADD;
518: App_Exception.Raise_Exception;
519: END IF;
520: Check_Constraints;
521: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
522: Check_Constraints;
594: end if;
595: else
596: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600: Before_DML(
601: p_action=>'INSERT',
602: x_rowid=>X_ROWID,
849: if (c1%notfound) then
850: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
851: IGS_GE_MSG_STACK.ADD;
852: close c1;
853: app_exception.raise_exception;
854: return;
855: end if;
856: close c1;
857:
928: null;
929: else
930: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
931: IGS_GE_MSG_STACK.ADD;
932: app_exception.raise_exception;
933: end if;
934: return;
935: end LOCK_ROW;
936:
997: end if;
998: else
999: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1000: IGS_GE_MSG_STACK.ADD;
1001: app_exception.raise_exception;
1002: end if;
1003: Before_DML(
1004: p_action=>'UPDATE',
1005: x_rowid=>X_ROWID,