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_OR_UNIT_LOC_PKG dependencies on APP_EXCEPTION

Line 32: App_Exception.Raise_Exception;

28: Fetch cur_old_ref_values INTO old_references;
29: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
30: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
31: IGS_GE_MSG_STACK.ADD;
32: App_Exception.Raise_Exception;
33: Close cur_old_ref_values;
34: Return;
35: END IF;
36: Close cur_old_ref_values;

Line 72: App_Exception.Raise_Exception ;

68: new_references.location_cd,
69: v_message_name) = FALSE THEN
70: Fnd_Message.Set_Name('IGS',v_message_name);
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception ;
73: END IF;
74: END IF;
75: END BeforeRowInsertUpdate1;
76:

Line 88: App_Exception.Raise_Exception;

84: new_references.location_cd ,
85: 'N' )THEN
86: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89:
90: END IF;
91: END IF;
92: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 104: App_Exception.Raise_Exception;

100: new_references.start_dt
101: )THEN
102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105:
106: END IF;
107: END IF;
108: END Check_Parent_Existance;

Line 150: App_Exception.Raise_Exception;

146: IF (cur_rowid%FOUND) THEN
147: Close cur_rowid;
148: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OUL_LOC_FK');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: Return;
152: END IF;
153: Close cur_rowid;
154: END GET_FK_IGS_AD_LOCATION;

Line 173: App_Exception.Raise_Exception;

169: IF (cur_rowid%FOUND) THEN
170: Close cur_rowid;
171: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OUL_OU_FK');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
175: END IF;
176: Close cur_rowid;
177: END GET_FK_IGS_OR_UNIT;

Line 215: App_Exception.Raise_Exception;

211: new_references.location_cd
212: )THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216:
217: END IF;
218: Check_Parent_Existance;
219: Check_Constraints ;

Line 237: App_Exception.Raise_Exception;

233: new_references.location_cd
234: )THEN
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238:
239: END IF;
240: Check_Constraints ;
241:

Line 292: app_exception.raise_exception;

288: end if;
289: else
290: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
291: IGS_GE_MSG_STACK.ADD;
292: app_exception.raise_exception;
293: end if;
294: Before_DML(
295: p_action=>'INSERT',
296: x_rowid=>X_ROWID,

Line 354: app_exception.raise_exception;

350: open c1;
351: fetch c1 into tlinfo;
352: if (c1%notfound) then
353: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
354: app_exception.raise_exception;
355: close c1;
356: return;
357: end if;
358: close c1;

Line 409: App_Exception.Raise_Exception ;

405: IF upper(Column_name) = 'LOCATION_CD' OR COLUMN_NAME IS NULL THEN
406: IF new_references.LOCATION_CD <> upper(new_references.LOCATION_CD) then
407: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception ;
410: END IF;
411:
412: END IF ;
413: