[Home] [Help]
37: OPEN cur_old_ref_values;
38: FETCH cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: CLOSE cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception; RETURN;
44: END IF;
45: CLOSE cur_old_ref_values;
81: IF new_references.testamur_type IS NOT NULL THEN
82: IF IGS_PS_VAL_AW.crsp_val_tt_closed(
83: new_references.testamur_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
95: new_references.award_cd,
96: new_references.s_award_type,
97: old_references.s_award_type,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS',v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
129:
130: IF UPPER(column_name) = 'CLOSED_IND' OR
131: column_name IS NULL THEN
132: IF ( new_references.closed_ind NOT IN ( 'Y' , 'N' ) ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: IF UPPER(column_name) = 'S_AWARD_TYPE' OR
140: column_name IS NULL THEN
141: IF ( new_references.s_award_type NOT IN ( 'COURSE' , 'HONORARY' , 'MEDAL' , 'PRIZE' ,'ENTRYQUAL') ) THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: IF UPPER(column_name) = 'AWARD_CD' OR
149: column_name IS NULL THEN
150: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) 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;
156:
157: IF UPPER(column_name) = 'CLOSED_IND' OR
158: column_name IS NULL THEN
159: IF ( new_references.closed_ind <> UPPER(new_references.closed_ind) ) THEN
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: END IF;
165:
166: IF UPPER(column_name) = 'S_AWARD_TYPE' OR
167: column_name IS NULL THEN
168: IF ( new_references.s_award_type <> UPPER(new_references.s_award_type) ) THEN
169: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: IF UPPER(column_name) = 'TESTAMUR_TYPE' OR
176: column_name IS NULL THEN
177: IF ( new_references.testamur_type <> UPPER(new_references.testamur_type) ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
184: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952
185: IF UPPER(column_name) = 'GRADING_SCHEMA_CD' OR
186: column_name IS NULL THEN
187: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_CD) THEN
188: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
189: IGS_GE_MSG_STACK.ADD;
190: APP_EXCEPTION.RAISE_EXCEPTION;
191: END IF;
192: END IF;
194: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952
195: IF UPPER(column_name) = 'GS_VERSION_NUMBER' OR
196: column_name IS NULL THEN
197: IF new_references.GS_VERSION_NUMBER < 0 OR new_references.GS_VERSION_NUMBER > 999 THEN
198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
199: IGS_GE_MSG_STACK.ADD;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201: END IF;
202: END IF;
211: NULL;
212: ELSE
213: IF NOT IGS_GR_TESTAMUR_TYPE_PKG.Get_PK_For_Validation (
214: new_references.testamur_type ) THEN
215: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
239: IF NOT IGS_AS_GRD_SCHEMA_PKG.Get_PK_For_Validation (
240: new_references.grading_schema_cd,
241: new_references.gs_version_number
242: ) THEN
243: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
290: OPEN cur_rowid;
291: FETCH cur_rowid INTO lv_rowid;
292: IF (cur_rowid%FOUND) THEN
293: CLOSE cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_TT_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: RETURN;
298: END IF;
321: OPEN cur_rowid;
322: FETCH cur_rowid INTO lv_rowid;
323: IF (cur_rowid%FOUND) THEN
324: CLOSE cur_rowid;
325: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_GS_FK');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: RETURN;
329: END IF;
372: -- Call all the procedures related to Before Insert.
373: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
374: IF Get_PK_For_Validation (
375: new_references.award_cd) THEN
376: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Constraints;
386: Check_Parent_Existance;
387: ELSIF (p_action = 'VALIDATE_INSERT') THEN
388: IF Get_PK_For_Validation (
389: new_references.award_cd ) THEN
390: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Constraints;
439: IF X_LAST_UPDATE_LOGIN IS NULL THEN
440: X_LAST_UPDATE_LOGIN := -1;
441: END IF;
442: ELSE
443: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: END IF;
447:
536: OPEN c1;
537: FETCH c1 INTO tlinfo;
538: IF (c1%NOTFOUND) THEN
539: CLOSE c1;
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: IGS_GE_MSG_STACK.ADD;
542: app_exception.raise_exception;
543: RETURN;
544: END IF;
575:
576: ) THEN
577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: END IF;
583: RETURN;
612: IF X_LAST_UPDATE_LOGIN IS NULL THEN
613: X_LAST_UPDATE_LOGIN := -1;
614: END IF;
615: ELSE
616: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
617: IGS_GE_MSG_STACK.ADD;
618: app_exception.raise_exception;
619: END IF;
620: