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 APP_EXCEPTION

Line 47: App_Exception.Raise_Exception;

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

Line 108: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 140: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 178: App_Exception.Raise_Exception;

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
182: if NEW_REFERENCES.week_offset < -99 OR

Line 186: App_Exception.Raise_Exception;

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
190: if NEW_REFERENCES.day_offset < -999 OR

Line 194: App_Exception.Raise_Exception;

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
198: if NEW_REFERENCES.month_offset < -99 OR

Line 202: App_Exception.Raise_Exception;

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

Line 209: App_Exception.Raise_Exception;

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

Line 216: App_Exception.Raise_Exception;

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

Line 223: App_Exception.Raise_Exception;

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

Line 230: App_Exception.Raise_Exception;

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

Line 257: App_Exception.Raise_Exception;

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

Line 280: App_Exception.Raise_Exception;

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:
284: END Check_Parent_Existance;

Line 372: App_Exception.Raise_Exception;

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

Line 441: App_Exception.Raise_Exception;

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

Line 466: App_Exception.Raise_Exception;

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

Line 545: app_exception.raise_exception;

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

Line 657: app_exception.raise_exception;

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

Line 682: app_exception.raise_exception;

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

Line 724: app_exception.raise_exception;

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