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

Line 57: App_Exception.Raise_Exception;

53: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
54: Close cur_old_ref_values;
55: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
56: IGS_GE_MSG_STACK.ADD;
57: App_Exception.Raise_Exception;
58: Return;
59: END IF;
60: Close cur_old_ref_values;
61:

Line 124: App_Exception.Raise_Exception ;

120: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
121: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
122: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception ;
125: END IF;
126: END IF;
127: IF upper(column_name) = 'FINAL_TITLE_IND' OR COLUMN_NAME IS NULL THEN
128: IF new_references.FINAL_TITLE_IND <> upper(NEW_REFERENCES.FINAL_TITLE_IND) OR

Line 132: App_Exception.Raise_Exception ;

128: IF new_references.FINAL_TITLE_IND <> upper(NEW_REFERENCES.FINAL_TITLE_IND) OR
129: new_references.FINAL_TITLE_IND NOT IN ('Y', 'N') then
130: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception ;
133: END IF;
134: END IF;
135: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
136: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then

Line 139: App_Exception.Raise_Exception ;

135: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
136: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
137: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception ;
140: END IF;
141: END IF;
142: IF upper(column_name) = 'LIBRARY_CATALOGUE_NUMBER' OR COLUMN_NAME IS NULL THEN
143: IF new_references.LIBRARY_CATALOGUE_NUMBER <> NEW_REFERENCES.LIBRARY_CATALOGUE_NUMBER then

Line 146: App_Exception.Raise_Exception ;

142: IF upper(column_name) = 'LIBRARY_CATALOGUE_NUMBER' OR COLUMN_NAME IS NULL THEN
143: IF new_references.LIBRARY_CATALOGUE_NUMBER <> NEW_REFERENCES.LIBRARY_CATALOGUE_NUMBER then
144: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception ;
147: END IF;
148: END IF;
149: IF upper(column_name)= 'THESIS_FORMAT' OR COLUMN_NAME IS NULL THEN
150: IF new_references.THESIS_FORMAT <> NEW_REFERENCES.THESIS_FORMAT then

Line 153: App_Exception.Raise_Exception ;

149: IF upper(column_name)= 'THESIS_FORMAT' OR COLUMN_NAME IS NULL THEN
150: IF new_references.THESIS_FORMAT <> NEW_REFERENCES.THESIS_FORMAT then
151: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception ;
154: END IF;
155: END IF;
156: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN
157: IF new_references.THESIS_RESULT_CD <> upper(NEW_REFERENCES.THESIS_RESULT_CD) then

Line 160: App_Exception.Raise_Exception ;

156: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN
157: IF new_references.THESIS_RESULT_CD <> upper(NEW_REFERENCES.THESIS_RESULT_CD) then
158: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception ;
161: END IF;
162: END IF;
163: END Check_Constraints ;
164:

Line 275: App_Exception.Raise_Exception;

271: new_references.hist_start_dt
272: ) THEN
273: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: END IF;
277: Check_Constraints;
278: ELSIF (p_action = 'UPDATE') THEN
279: -- Call all the procedures related to Before Update.

Line 290: App_Exception.Raise_Exception;

286: new_references.hist_start_dt
287: ) THEN
288: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292: Check_Constraints;
293: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
294: Check_Constraints;

Line 349: app_exception.raise_exception;

345: end if;
346: else
347: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
348: IGS_GE_MSG_STACK.ADD;
349: app_exception.raise_exception;
350: end if;
351:
352: Before_DML (
353: p_action => 'INSERT',

Line 505: app_exception.raise_exception;

501: fetch c1 into tlinfo;
502: if (c1%notfound) then
503: close c1;
504: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
505: app_exception.raise_exception;
506: return;
507: end if;
508: close c1;
509:

Line 562: app_exception.raise_exception;

558: ) then
559: null;
560: else
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: app_exception.raise_exception;
563: end if;
564: return;
565: end LOCK_ROW;
566:

Line 612: app_exception.raise_exception;

608: end if;
609: else
610: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
611: IGS_GE_MSG_STACK.ADD;
612: app_exception.raise_exception;
613: end if;
614:
615: Before_DML (
616: p_action => 'UPDATE',