[Home] [Help]
32: Open cur_old_ref_values;
33: Fetch cur_old_ref_values INTO old_references;
34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
35: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
76: IF IGS_GR_VAL_CRDP.grdp_val_crdp_iud(
77: new_references.grd_cal_type,
78: new_references.grd_ci_sequence_number,
79: v_message_name) = FALSE THEN
80: Fnd_Message.Set_Name('IGS', v_message_name);
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
101: IF NOT IGS_GR_CRMN_ROUND_PKG.Get_PK_For_Validation (
102: new_references.grd_cal_type,
103: new_references.grd_ci_sequence_number
104: ) THEN
105: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
106: IGS_GE_MSG_STACK.ADD;
107: APP_EXCEPTION.RAISE_EXCEPTION;
108: END IF;
109:
117: ELSE
118: IF NOT IGS_EN_NOM_CMPL_PRD_PKG.Get_PK_For_Validation (
119: new_references.completion_period
120: ) 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:
156: END IF ;
157:
158: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
159: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 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 ;
164: END IF ;
165:
166: IF upper(Column_name) = 'COMPLETION_YEAR' OR COLUMN_NAME IS NULL THEN
167: IF new_references.COMPLETION_YEAR < 1000 OR new_references.COMPLETION_YEAR > 9999 then
168: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception ;
171: END IF;
172: END IF ;
174: IF upper(Column_name) = 'COMPLETION_PERIOD' OR COLUMN_NAME IS NULL THEN
175: --smaddali removed a constraint to check values in list ('E','S','M')
176: --for bug # 2237194 ARCR043 ccr
177: IF new_references.COMPLETION_PERIOD<> upper(NEW_REFERENCES.COMPLETION_PERIOD) 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 ;
182: END IF ;
183:
184: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
185: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
186: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception ;
189: END IF;
190:
241: Open cur_rowid;
242: Fetch cur_rowid INTO lv_rowid;
243: IF (cur_rowid%FOUND) THEN
244: Close cur_rowid;
245: Fnd_Message.Set_Name ('IGS', 'IGS_GR_CRDP_CRD_FK');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: Return;
249: END IF;
290: NEW_REFERENCES.grd_ci_sequence_number,
291: NEW_REFERENCES.completion_year,
292: NEW_REFERENCES.completion_period
293: ) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298:
310: NEW_REFERENCES.grd_ci_sequence_number,
311: NEW_REFERENCES.completion_year,
312: NEW_REFERENCES.completion_period
313: ) THEN
314: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: END IF;
318: check_constraints;
352: if X_LAST_UPDATE_LOGIN is NULL then
353: X_LAST_UPDATE_LOGIN := -1;
354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
421: open c1;
422: fetch c1 into tlinfo;
423: if (c1%notfound) then
424: close c1;
425: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
426: app_exception.raise_exception;
427: return;
428: end if;
429: close c1;