[Home] [Help]
34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
75: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
76: new_references.course_cd,
77: new_references.version_number,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: -- Validate the IGS_PS_COURSE Stage Type is not closed
83: -- Validate the IGS_PS_COURSE Stage Type is not closed
84: IF IGS_PS_VAL_CST.crsp_val_cstt_closed(
85: new_references.course_stage_type,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: ELSE
92: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
93: old_references.course_cd,
94: old_references.version_number,
95: v_message_name) = FALSE THEN
96: Fnd_Message.Set_Name('IGS',v_message_name);
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
118: NEW_REFERENCES.version_number,
119: NEW_REFERENCES.sequence_number,
120: NEW_REFERENCES.course_stage_type,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS',v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
147: IF upper(column_name)= 'COURSE_CD' OR
148: column_name is null THEN
149: IF new_references.course_cd <> UPPER(new_references.course_cd)
150: THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
157: IF upper(column_name)= 'COURSE_STAGE_TYPE' OR
158: column_name is null THEN
159: IF new_references.course_stage_type <> UPPER(new_references.course_stage_type)
160: THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;
168: column_name is null THEN
169: IF new_references.sequence_number < 1 OR
170: new_references.sequence_number > 999999
171: THEN
172: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
188: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
189: new_references.course_cd,
190: new_references.version_number
191: )THEN
192: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
201: ELSE
202: IF NOT IGS_PS_STAGE_TYPE_PKG.Get_PK_For_Validation (
203: new_references.course_stage_type
204: )THEN
205: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
269: Open cur_rowid;
270: Fetch cur_rowid INTO lv_rowid;
271: IF (cur_rowid%FOUND) THEN
272: Close cur_rowid;
273: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CST_CRV_FK');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: Return;
277: END IF;
295: Open cur_rowid;
296: Fetch cur_rowid INTO lv_rowid;
297: IF (cur_rowid%FOUND) THEN
298: Close cur_rowid;
299: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CST_CSTT_FK');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: Return;
303: END IF;
345: new_references.version_number ,
346: new_references.course_cd ,
347: new_references.sequence_number
348: ) THEN
349: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353: Check_Constraints;
365: IF Get_PK_For_Validation(
366: new_references.version_number ,
367: new_references.course_cd ,
368: new_references.sequence_number ) THEN
369: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
370: IGS_GE_MSG_STACK.ADD;
371: App_Exception.Raise_Exception;
372: END IF;
373: Check_Constraints;
427: if X_LAST_UPDATE_LOGIN is NULL then
428: X_LAST_UPDATE_LOGIN := -1;
429: end if;
430: else
431: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: end if;
435:
510: open c1;
511: fetch c1 into tlinfo;
512: if (c1%notfound) then
513: close c1;
514: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
515: IGS_GE_MSG_STACK.ADD;
516: app_exception.raise_exception;
517: return;
518: end if;
527: AND (X_COMMENTS is null)))
528: ) then
529: null;
530: else
531: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
532: IGS_GE_MSG_STACK.ADD;
533: app_exception.raise_exception;
534: end if;
535: return;
562: if X_LAST_UPDATE_LOGIN is NULL then
563: X_LAST_UPDATE_LOGIN := -1;
564: end if;
565: else
566: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
567: IGS_GE_MSG_STACK.ADD;
568: app_exception.raise_exception;
569: end if;
570: