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 APP_EXCEPTION

Line 45: App_Exception.Raise_Exception;

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

Line 97: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 132: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 173: App_Exception.Raise_Exception;

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
177: if NEW_REFERENCES.cal_type <> UPPER(NEW_REFERENCES.cal_type )THEN

Line 180: App_Exception.Raise_Exception;

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
184: if NEW_REFERENCES.dt_alias <> UPPER(NEW_REFERENCES.dt_alias)THEN

Line 187: App_Exception.Raise_Exception;

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

Line 195: App_Exception.Raise_Exception;

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
199: if NEW_REFERENCES.offset_dt_alias <> UPPER( NEW_REFERENCES.offset_dt_alias) then

Line 202: App_Exception.Raise_Exception;

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
206: if NEW_REFERENCES.s_dt_offset_constraint_type <> UPPER( NEW_REFERENCES.s_dt_offset_constraint_type ) then

Line 209: App_Exception.Raise_Exception;

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
213: if NEW_REFERENCES.constraint_condition NOT IN ('MUST' , 'MUST NOT') then

Line 216: App_Exception.Raise_Exception;

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
220: if NEW_REFERENCES.constraint_resolution < -9 OR

Line 224: App_Exception.Raise_Exception;

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
228: if NEW_REFERENCES.offset_ci_sequence_number < 1 OR

Line 232: App_Exception.Raise_Exception;

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
236: if NEW_REFERENCES.offset_dai_sequence_number < 1 OR

Line 240: App_Exception.Raise_Exception;

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
244: if NEW_REFERENCES.ci_sequence_number < 1 OR

Line 248: App_Exception.Raise_Exception;

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

Line 288: App_Exception.Raise_Exception;

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

Line 377: App_Exception.Raise_Exception;

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

Line 450: App_Exception.Raise_Exception;

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

Line 475: App_Exception.Raise_Exception;

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
479: Check_Constraints;

Line 551: app_exception.raise_exception;

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',
555: x_rowid =>X_ROWID,

Line 651: app_exception.raise_exception;

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

Line 663: app_exception.raise_exception;

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

Line 703: app_exception.raise_exception;

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',
707: x_rowid =>X_ROWID,