[Home] [Help]
41: Open cur_old_ref_values;
42: Fetch cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
44: Close cur_old_ref_values;
45: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: Return;
49: END IF;
102: old_references.offset_cal_type,
103: old_references.offset_ci_sequence_number,
104: v_message_name) = FALSE
105: THEN
106: Fnd_Message.Set_Name('IGS',v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: APP_EXCEPTION.RAISE_EXCEPTION;
109: END IF;
110: END IF;
134: NVL (new_references.offset_cal_type, old_references.offset_cal_type),
135: NVL (new_references.offset_ci_sequence_number, old_references.offset_ci_sequence_number),
136: v_message_name) = FALSE
137: THEN
138: Fnd_Message.Set_Name('IGS',v_message_name);
139: IGS_GE_MSG_STACK.ADD;
140: APP_EXCEPTION.RAISE_EXCEPTION;
141: END IF;
142: END IF;
172: end if;
173: If upper(column_name) = 'YEAR_OFFSET' or column_name is null Then
174: if NEW_REFERENCES.year_offset < -9 OR
175: NEW_REFERENCES.year_offset > 9 then
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: end if;
180: end if;
180: end if;
181: if upper(column_name) = 'WEEK_OFFSET' or column_name is null Then
182: if NEW_REFERENCES.week_offset < -99 OR
183: NEW_REFERENCES.week_offset > 99 then
184: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: end if;
188: end if;
188: end if;
189: if upper(column_name) ='DAY_OFFSET' or column_name is null Then
190: if NEW_REFERENCES.day_offset < -999 OR
191: NEW_REFERENCES.day_offset > 999 then
192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: end if;
196: end if;
196: end if;
197: if upper(column_name) = 'MONTH_OFFSET' or column_name is null Then
198: if NEW_REFERENCES.month_offset < -99 OR
199: NEW_REFERENCES.month_offset > 99 then
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: end if;
204: end if;
203: end if;
204: end if;
205: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
206: if NEW_REFERENCES.dt_alias <> UPPER( NEW_REFERENCES.dt_alias) then
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: end if;
211: end if;
210: end if;
211: end if;
212: if upper(column_name) = 'CAL_TYPE' or column_name is null Then
213: if NEW_REFERENCES.cal_type <> UPPER( NEW_REFERENCES.cal_type) then
214: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: end if;
218: end if;
217: end if;
218: end if;
219: if upper(column_name) = 'OFFSET_DT_ALIAS' or column_name is null Then
220: if NEW_REFERENCES.offset_dt_alias <> UPPER( NEW_REFERENCES.offset_dt_alias) then
221: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;
224: end if;
225: end if;
224: end if;
225: end if;
226: if upper(column_name) = 'OFFSET_CAL_TYPE' or column_name is null Then
227: if NEW_REFERENCES.offset_cal_type <> UPPER( NEW_REFERENCES.offset_cal_type) then
228: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: end if;
232: end if;
251: new_references.dai_sequence_number,
252: new_references.cal_type,
253: new_references.ci_sequence_number
254: ) THEN
255: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259:
274: new_references.offset_dai_sequence_number,
275: new_references.offset_cal_type,
276: new_references.offset_ci_sequence_number
277: ) THEN
278: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
366: Open cur_rowid;
367: Fetch cur_rowid INTO lv_rowid;
368: IF (cur_rowid%FOUND) THEN
369: Close cur_rowid;
370: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAIO_DAI_FK');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: Return;
374: END IF;
435: new_references.offset_dt_alias ,
436: new_references.offset_dai_sequence_number ,
437: new_references.offset_cal_type ,
438: new_references.offset_ci_sequence_number )THEN
439: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
440: IGS_GE_MSG_STACK.ADD;
441: App_Exception.Raise_Exception;
442: END IF;
443: CHECK_CONSTRAINTS;
460: new_references.offset_dt_alias ,
461: new_references.offset_dai_sequence_number ,
462: new_references.offset_cal_type ,
463: new_references.offset_ci_sequence_number )THEN
464: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467: END IF;
468: CHECK_CONSTRAINTS;
539: if X_LAST_UPDATE_LOGIN is NULL then
540: X_LAST_UPDATE_LOGIN := -1;
541: end if;
542: else
543: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
544: IGS_GE_MSG_STACK.ADD;
545: app_exception.raise_exception;
546: end if;
547: Before_DML (
651: open c1;
652: fetch c1 into tlinfo;
653: if (c1%notfound) then
654: close c1;
655: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: return;
659: end if;
676: AND (X_OFST_OVERRIDE is null)))
677: ) then
678: null;
679: else
680: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
681: IGS_GE_MSG_STACK.ADD;
682: app_exception.raise_exception;
683: end if;
684: return;
718: if X_LAST_UPDATE_LOGIN is NULL then
719: X_LAST_UPDATE_LOGIN := -1;
720: end if;
721: else
722: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
723: IGS_GE_MSG_STACK.ADD;
724: app_exception.raise_exception;
725: end if;
726: Before_DML (