[Home] [Help]
42: Open cur_old_ref_values;
43: Fetch cur_old_ref_values INTO old_references;
44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
104: THEN
105: IF IGS_PS_VAL_CTY.crsp_val_cty_govt (
106: new_references.govt_course_type,
107: v_message_name) = FALSE THEN
108: Fnd_Message.Set_Name('IGS',v_message_name);
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
119: THEN
120: IF IGS_PS_VAL_CTY.crsp_val_cty_group (
121: new_references.course_type_group_cd,
122: v_message_name) = FALSE THEN
123: Fnd_Message.Set_Name('IGS',v_message_name);
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
131: IF IGS_PS_VAL_CTY.crsp_val_cty_award (
132: new_references.course_type,
133: new_references.award_course_ind,
134: v_message_name) = FALSE THEN
135: Fnd_Message.Set_Name('IGS',v_message_name);
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
241: IF upper(column_name)= 'COURSE_TYPE' OR
242: column_name is null THEN
243: IF new_references.course_type <> UPPER(new_references.course_type )
244: THEN
245: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;
251: IF upper(column_name)= 'COURSE_TYPE_GROUP_CD' OR
252: column_name is null THEN
253: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd )
254: THEN
255: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
261: IF upper(column_name)= 'TAC_COURSE_LEVEL' OR
262: column_name is null THEN
263: IF new_references.tac_course_level <> UPPER(new_references.tac_course_level)
264: THEN
265: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: END IF;
269: END IF;
271: IF upper(column_name)= 'RESEARCH_TYPE_IND' OR
272: column_name is null THEN
273: IF new_references.research_type_ind NOT IN ( 'Y' , 'N' )
274: THEN
275: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: END IF;
279: END IF;
281: IF upper(column_name)= 'CLOSED_IND' OR
282: column_name is null THEN
283: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
284: THEN
285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: END IF;
289: END IF;
291: IF upper(column_name)= 'AWARD_COURSE_IND' OR
292: column_name is null THEN
293: IF new_references.award_course_ind NOT IN ( 'Y' , 'N' )
294: THEN
295: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299: END IF;
308: ELSE
309: IF NOT IGS_PS_TYPE_GRP_PKG.Get_PK_For_Validation (
310: new_references.course_type_group_cd
311: )THEN
312: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: END IF;
321: ELSE
322: IF NOT IGS_PS_GOVT_TYPE_PKG.Get_PK_For_Validation (
323: new_references.govt_course_type
324: )THEN
325: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: END IF;
334: ELSE
335: IF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
336: new_references.enrolment_cat
337: )THEN
338: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: END IF;
342: END IF;
385: Open cur_rowid;
386: Fetch cur_rowid INTO lv_rowid;
387: IF (cur_rowid%FOUND) THEN
388: Close cur_rowid;
389: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CTY_CTG_FK');
390: IGS_GE_MSG_STACK.ADD;
391: App_Exception.Raise_Exception;
392: Return;
393: END IF;
411: Open cur_rowid;
412: Fetch cur_rowid INTO lv_rowid;
413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CTY_GCT_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
436: Open cur_rowid;
437: Fetch cur_rowid INTO lv_rowid;
438: IF (cur_rowid%FOUND) THEN
439: Close cur_rowid;
440: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CTY_CTG_FK');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: Return;
444: END IF;
498: BeforeRowInsertUpdate( p_inserting => TRUE,p_updating=>FALSE);
499: IF Get_PK_For_Validation(
500: new_references.course_type
501: ) THEN
502: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
503: IGS_GE_MSG_STACK.ADD;
504: App_Exception.Raise_Exception;
505: END IF;
506: Check_Constraints;
513: ELSIF (p_action = 'VALIDATE_INSERT') THEN
514: IF Get_PK_For_Validation(
515: new_references.course_type
516: ) THEN
517: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
518: IGS_GE_MSG_STACK.ADD;
519: App_Exception.Raise_Exception;
520: END IF;
521: Check_Constraints;
571: if X_LAST_UPDATE_LOGIN is NULL then
572: X_LAST_UPDATE_LOGIN := -1;
573: end if;
574: else
575: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: end if;
579: Before_DML( p_action => 'INSERT',
682: open c1;
683: fetch c1 into tlinfo;
684: if (c1%notfound) then
685: close c1;
686: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
687: IGS_GE_MSG_STACK.ADD;
688: app_exception.raise_exception;
689: return;
690: end if;
712: AND (X_FIN_AID_PROGRAM_TYPE IS NULL)))
713: ) then
714: null;
715: else
716: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
717: IGS_GE_MSG_STACK.ADD;
718: app_exception.raise_exception;
719: end if;
720: return;
751: if X_LAST_UPDATE_LOGIN is NULL then
752: X_LAST_UPDATE_LOGIN := -1;
753: end if;
754: else
755: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
756: IGS_GE_MSG_STACK.ADD;
757: app_exception.raise_exception;
758: end if;
759: Before_DML( p_action => 'UPDATE',