eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CA_DA_INST_OFST_PKG dependencies on IGS_GE_MSG_STACK

Line 46: IGS_GE_MSG_STACK.ADD;

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;
50: Close cur_old_ref_values;

Line 107: IGS_GE_MSG_STACK.ADD;

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;
111: END BeforeRowInsertUpdateDelete1;

Line 139: IGS_GE_MSG_STACK.ADD;

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;
143: END AfterStmtInsertUpdateDelete3;

Line 177: IGS_GE_MSG_STACK.ADD;

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;
181: if upper(column_name) = 'WEEK_OFFSET' or column_name is null Then

Line 185: IGS_GE_MSG_STACK.ADD;

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;
189: if upper(column_name) ='DAY_OFFSET' or column_name is null Then

Line 193: IGS_GE_MSG_STACK.ADD;

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;
197: if upper(column_name) = 'MONTH_OFFSET' or column_name is null Then

Line 201: IGS_GE_MSG_STACK.ADD;

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;
205: if upper(column_name) = 'DT_ALIAS' or column_name is null Then

Line 208: IGS_GE_MSG_STACK.ADD;

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;
212: if upper(column_name) = 'CAL_TYPE' or column_name is null Then

Line 215: IGS_GE_MSG_STACK.ADD;

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;
219: if upper(column_name) = 'OFFSET_DT_ALIAS' or column_name is null Then

Line 222: IGS_GE_MSG_STACK.ADD;

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;
226: if upper(column_name) = 'OFFSET_CAL_TYPE' or column_name is null Then

Line 229: IGS_GE_MSG_STACK.ADD;

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;
233: END Check_Constraints;

Line 256: IGS_GE_MSG_STACK.ADD;

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:
260: END IF;

Line 279: IGS_GE_MSG_STACK.ADD;

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;
283:

Line 371: IGS_GE_MSG_STACK.ADD;

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;
375: Close cur_rowid;

Line 440: IGS_GE_MSG_STACK.ADD;

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;
444: Check_Parent_Existance;

Line 465: IGS_GE_MSG_STACK.ADD;

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;
469: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 544: IGS_GE_MSG_STACK.ADD;

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 (
548: p_action =>'INSERT',

Line 656: IGS_GE_MSG_STACK.ADD;

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;
660: close c1;

Line 681: IGS_GE_MSG_STACK.ADD;

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;
685: end LOCK_ROW;

Line 723: IGS_GE_MSG_STACK.ADD;

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 (
727: p_action =>'UPDATE',