[Home] [Help]
30: -- Populate Old Values.
31: Open cur_old_ref_values;
32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Close cur_old_ref_values;
38: Return;
65: -- Validate the admission category closed indicator.
66: IF IGS_AD_VAL_ACCT.admp_val_ac_closed (
67: new_references.admission_cat,
68: v_message_name) = FALSE THEN
69: Fnd_Message.Set_Name('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: App_Exception.Raise_Exception;
72: END IF;
73: -- Validate the course type closed indicator.
73: -- Validate the course type closed indicator.
74: IF IGS_AS_VAL_ACOT.crsp_val_cty_closed (
75: new_references.course_type,
76: v_message_name) = FALSE THEN
77: Fnd_Message.Set_Name('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END BeforeRowInsert1;
93: new_references.course_type := column_value;
94: END IF;
95: IF upper(column_name) = 'ADMISSION_CAT' OR column_name is null Then
96: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
100: END IF;
101: END IF;
102: IF upper(column_name) = 'COURSE_TYPE' OR column_name is null Then
103: IF new_references.course_type <> UPPER(new_references.course_type ) Then
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
117: NULL;
118: ELSE
119: IF NOT IGS_AD_CAT_PKG.Get_PK_For_Validation (
120: new_references.admission_cat , 'N' ) THEN
121: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
129: NULL;
130: ELSE
131: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
132: new_references.course_type ) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
177: Open cur_rowid;
178: Fetch cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: Close cur_rowid;
181: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACCT_AC_FK');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: Return;
185: END IF;
216: BeforeRowInsert1 ( p_inserting => TRUE );
217: IF Get_PK_For_Validation (
218: new_references.admission_cat,
219: new_references.course_type ) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: Check_Constraints;
230: ELSIF (p_action = 'VALIDATE_INSERT') THEN
231: IF Get_PK_For_Validation (
232: new_references.admission_cat,
233: new_references.course_type ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: Check_Constraints;
277: if X_LAST_UPDATE_LOGIN is NULL then
278: X_LAST_UPDATE_LOGIN := -1;
279: end if;
280: else
281: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
282: IGS_GE_MSG_STACK.ADD;
283: app_exception.raise_exception;
284: end if;
285:
340: begin
341: open c1;
342: fetch c1 into tlinfo;
343: if (c1%notfound) then
344: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: close c1;
348: return;