[Home] [Help]
89: Open cur_old_ref_values;
90: Fetch cur_old_ref_values INTO old_references;
91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;
200: IF upper(column_name)= 'GENERIC_COURSE_IND' OR
201: column_name is null THEN
202: IF new_references.generic_course_ind NOT IN ( 'Y' , 'N' )
203: THEN
204: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209: IF upper(column_name)= 'COUNT_INTRMSN_IN_TIME_IND' OR
210: column_name is null THEN
211: IF new_references.count_intrmsn_in_time_ind NOT IN ( 'Y' , 'N' )
212: THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: END IF;
219: column_name is null THEN
220: IF new_references.external_adv_stnd_limit < 0 OR
221: new_references.external_adv_stnd_limit > 9999.999
222: THEN
223: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
229: column_name is null THEN
230: IF new_references.std_annual_load < 0 OR
231: new_references.std_annual_load > 9999.999
232: THEN
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
239: column_name is null THEN
240: IF new_references.internal_adv_stnd_limit < 0 OR
241: new_references.internal_adv_stnd_limit > 9999.999
242: THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248: IF upper(column_name)= 'INTRMSN_ALLOWED_IND' OR
249: column_name is null THEN
250: IF new_references.intrmsn_allowed_ind NOT IN ( 'Y' , 'N' )
251: THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: IF upper(column_name)= 'GRADUATE_STUDENTS_IND' OR
258: column_name is null THEN
259: IF new_references.graduate_students_ind NOT IN ( 'Y' , 'N' )
260: THEN
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: END IF;
266: IF upper(column_name)= 'ABBREVIATION' OR
267: column_name is null THEN
268: IF new_references.abbreviation<> UPPER(new_references.abbreviation)
269: THEN
270: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
276: IF upper(column_name)= 'COURSE_CD' OR
277: column_name is null THEN
278: IF new_references.course_cd <> UPPER(new_references.course_cd )
279: THEN
280: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: END IF;
286: IF upper(column_name)= 'COURSE_STATUS' OR
287: column_name is null THEN
288: IF new_references.course_status <> UPPER(new_references.course_status)
289: THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: END IF;
296: IF upper(column_name)= 'COURSE_TYPE' OR
297: column_name is null THEN
298: IF new_references.course_type <> UPPER(new_references.course_type)
299: THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
305: IF upper(column_name)= 'GOVT_SPECIAL_COURSE_TYPE' OR
306: column_name is null THEN
307: IF new_references.govt_special_course_type <> UPPER(new_references.govt_special_course_type )
308: THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
315: IF upper(column_name)= 'SUPP_EXAM_PERMITTED_IND' OR
316: column_name is null THEN
317: IF new_references.supp_exam_permitted_ind <> UPPER(new_references.supp_exam_permitted_ind )
318: THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
324:
325: IF upper(column_name)= 'MAX_WLST_PER_STUD' OR column_name is null THEN
326: IF new_references.max_wlst_per_stud < 0 OR
327: new_references.max_wlst_per_stud > 9999 THEN
328: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;
333:
334: IF upper(column_name)= 'ANNUAL_INSTRUCTION_TIME' OR column_name is null THEN
335: IF new_references.annual_instruction_time < 1 OR
336: new_references.annual_instruction_time > 99.99 THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
509: new_references.course_cd ,
510: new_references.version_number,
511: new_references.hist_start_dt
512: ) THEN
513: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
514: IGS_GE_MSG_STACK.ADD;
515: App_Exception.Raise_Exception;
516: END IF;
517: Check_Constraints;
525: new_references.course_cd ,
526: new_references.version_number,
527: new_references.hist_start_dt
528: ) THEN
529: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
530: IGS_GE_MSG_STACK.ADD;
531: App_Exception.Raise_Exception;
532: END IF;
533: Check_Constraints;
633: if X_LAST_UPDATE_LOGIN is NULL then
634: X_LAST_UPDATE_LOGIN := -1;
635: end if;
636: else
637: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: end if;
641: before_dml( p_action => 'INSERT',
934: OPEN c1;
935: FETCH c1 INTO tlinfo;
936: IF (c1%notfound) THEN
937: CLOSE c1;
938: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
939: IGS_GE_MSG_STACK.ADD;
940: app_exception.raise_exception;
941: RETURN;
942: END IF;
1071: AND (x_annual_instruction_time IS NULL)))
1072: ) THEN
1073: NULL;
1074: ELSE
1075: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: END IF;
1079: RETURN;
1159: IF X_LAST_UPDATE_LOGIN IS NULL THEN
1160: X_LAST_UPDATE_LOGIN := -1;
1161: END IF;
1162: ELSE
1163: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1164: IGS_GE_MSG_STACK.ADD;
1165: app_exception.raise_exception;
1166: END IF;
1167: before_dml( p_action => 'UPDATE',