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_OFCNT_PKG dependencies on IGS_GE_MSG_STACK

Line 44: IGS_GE_MSG_STACK.ADD;

40: Fetch cur_old_ref_values INTO old_references;
41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
42: Close cur_old_ref_values;
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: App_Exception.Raise_Exception;
46: Return;
47: END IF;
48: Close cur_old_ref_values;

Line 96: IGS_GE_MSG_STACK.ADD;

92: new_references.s_dt_offset_constraint_type,
93: v_message_name) = FALSE
94: THEN
95: Fnd_Message.Set_Name('IGS',v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: END IF;
99:
100: END IF;

Line 131: IGS_GE_MSG_STACK.ADD;

127: new_references.constraint_condition,
128: new_references.constraint_resolution,
129: v_message_name) = FALSE THEN
130: Fnd_Message.Set_Name('IGS',v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134: END IF;
135: END AfterStmtInsertUpdate3;

Line 172: IGS_GE_MSG_STACK.ADD;

168: If upper(column_name) = 'DAI_SEQUENCE_NUMBER' or column_name is null Then
169: if NEW_REFERENCES.dai_sequence_number <1 OR
170: NEW_REFERENCES.dai_sequence_number > 999999 then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: end if;
175: end if;
176: if upper(column_name) = 'CAL_TYPE' or column_name is null Then

Line 179: IGS_GE_MSG_STACK.ADD;

175: end if;
176: if upper(column_name) = 'CAL_TYPE' or column_name is null Then
177: if NEW_REFERENCES.cal_type <> UPPER(NEW_REFERENCES.cal_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;
183: if upper(column_name) = 'DT_ALIAS' or column_name is null Then

Line 186: IGS_GE_MSG_STACK.ADD;

182: end if;
183: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
184: if NEW_REFERENCES.dt_alias <> UPPER(NEW_REFERENCES.dt_alias)THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: end if;
189: end if;
190:

Line 194: IGS_GE_MSG_STACK.ADD;

190:
191: if upper(column_name) = 'OFFSET_CAL_TYPE' or column_name is null Then
192: if NEW_REFERENCES.offset_cal_type <> UPPER(NEW_REFERENCES.offset_cal_type)THEN
193: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: end if;
197: end if;
198: if upper(column_name) = 'OFFSET_DT_ALIAS' or column_name is null Then

Line 201: IGS_GE_MSG_STACK.ADD;

197: end if;
198: if upper(column_name) = 'OFFSET_DT_ALIAS' or column_name is null Then
199: if NEW_REFERENCES.offset_dt_alias <> UPPER( NEW_REFERENCES.offset_dt_alias) 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) = 'S_DT_OFFSET_CONSTRAINT_TYPE' or column_name is null Then

Line 208: IGS_GE_MSG_STACK.ADD;

204: end if;
205: if upper(column_name) = 'S_DT_OFFSET_CONSTRAINT_TYPE' or column_name is null Then
206: if NEW_REFERENCES.s_dt_offset_constraint_type <> UPPER( NEW_REFERENCES.s_dt_offset_constraint_type ) 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) = 'CONSTRAINT_CONDITION' or column_name is null Then

Line 215: IGS_GE_MSG_STACK.ADD;

211: end if;
212: if upper(column_name) = 'CONSTRAINT_CONDITION' or column_name is null Then
213: if NEW_REFERENCES.constraint_condition NOT IN ('MUST' , 'MUST NOT') 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) = 'CONSTRAINT_RESOLUTION' or column_name is null Then

Line 223: IGS_GE_MSG_STACK.ADD;

219: If upper(column_name) = 'CONSTRAINT_RESOLUTION' or column_name is null Then
220: if NEW_REFERENCES.constraint_resolution < -9 OR
221: NEW_REFERENCES.constraint_resolution > 9 then
222: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: end if;
226: end if;
227: If upper(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER ' or column_name is null Then

Line 231: IGS_GE_MSG_STACK.ADD;

227: If upper(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER ' or column_name is null Then
228: if NEW_REFERENCES.offset_ci_sequence_number < 1 OR
229: NEW_REFERENCES.offset_ci_sequence_number > 999999 then
230: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: end if;
234: end if;
235: If upper(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' or column_name is null Then

Line 239: IGS_GE_MSG_STACK.ADD;

235: If upper(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' or column_name is null Then
236: if NEW_REFERENCES.offset_dai_sequence_number < 1 OR
237: NEW_REFERENCES.offset_dai_sequence_number > 999999 then
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: end if;
242: end if;
243: If upper(column_name) = 'CI_SEQUENCE_NUMBER' or column_name is null Then

Line 247: IGS_GE_MSG_STACK.ADD;

243: If upper(column_name) = 'CI_SEQUENCE_NUMBER' or column_name is null Then
244: if NEW_REFERENCES.ci_sequence_number < 1 OR
245: NEW_REFERENCES.ci_sequence_number > 999999 then
246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: end if;
250: end if;
251:

Line 287: IGS_GE_MSG_STACK.ADD;

283: new_references.offset_cal_type,
284: new_references.offset_ci_sequence_number
285: ) THEN
286: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: END IF;
290:
291: END IF;

Line 376: IGS_GE_MSG_STACK.ADD;

372: Fetch cur_rowid INTO lv_rowid;
373: IF (cur_rowid%FOUND) THEN
374: Close cur_rowid;
375: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAIOC_DAIO_FK');
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: Return;
379: END IF;
380: Close cur_rowid;

Line 449: IGS_GE_MSG_STACK.ADD;

445: new_references.offset_dt_alias ,
446: new_references.offset_dai_sequence_number ,
447: new_references.s_dt_offset_constraint_type ) Then
448: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
449: IGS_GE_MSG_STACK.ADD;
450: App_Exception.Raise_Exception;
451: END IF;
452: CHECK_CONSTRAINTS;
453: Check_Parent_Existance;

Line 474: IGS_GE_MSG_STACK.ADD;

470: new_references.offset_dt_alias ,
471: new_references.offset_dai_sequence_number ,
472: new_references.s_dt_offset_constraint_type ) Then
473: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
474: IGS_GE_MSG_STACK.ADD;
475: App_Exception.Raise_Exception;
476: END IF;
477: CHECK_CONSTRAINTS;
478: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 550: IGS_GE_MSG_STACK.ADD;

546: X_LAST_UPDATE_LOGIN := -1;
547: end if;
548: else
549: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
550: IGS_GE_MSG_STACK.ADD;
551: app_exception.raise_exception;
552: end if;
553: Before_DML (
554: p_action =>'INSERT',

Line 650: IGS_GE_MSG_STACK.ADD;

646: fetch c1 into tlinfo;
647: if (c1%notfound) then
648: close c1;
649: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
650: IGS_GE_MSG_STACK.ADD;
651: app_exception.raise_exception;
652: return;
653: end if;
654: close c1;

Line 662: IGS_GE_MSG_STACK.ADD;

658: ) then
659: null;
660: else
661: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
662: IGS_GE_MSG_STACK.ADD;
663: app_exception.raise_exception;
664: end if;
665: return;
666: end LOCK_ROW;

Line 702: IGS_GE_MSG_STACK.ADD;

698: X_LAST_UPDATE_LOGIN := -1;
699: end if;
700: else
701: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
702: IGS_GE_MSG_STACK.ADD;
703: app_exception.raise_exception;
704: end if;
705: Before_DML (
706: p_action =>'UPDATE',