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

Line 44: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

82: new_references.FIELD_OF_STUDY,
83: v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name ('IGS', v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: IF p_inserting OR
90: p_updating OR

Line 103: App_Exception.Raise_Exception;

99: new_references.ca_sequence_number,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name ('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106: END IF;
107: END BeforeRowInsertUpdateDelete1;

Line 129: App_Exception.Raise_Exception ;

125: IF upper(column_name) = 'FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN
126: IF new_references.FIELD_OF_STUDY <> upper(new_references.FIELD_OF_STUDY) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;
132:
133: IF upper(column_name) = 'PERCENTAGE' OR COLUMN_NAME IS NULL THEN

Line 137: App_Exception.Raise_Exception ;

133: IF upper(column_name) = 'PERCENTAGE' OR COLUMN_NAME IS NULL THEN
134: IF new_references.PERCENTAGE < 1 OR new_references.PERCENTAGE > 100 THEN
135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception ;
138: END IF;
139: END IF;
140:
141: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 145: App_Exception.Raise_Exception ;

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

Line 167: App_Exception.Raise_Exception;

163: new_references.ca_sequence_number
164: ) THEN
165: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170:
171: IF (((old_references.field_of_study = new_references.field_of_study)) OR

Line 180: App_Exception.Raise_Exception;

176: new_references.field_of_study
177: ) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184: END Check_Parent_Existance;

Line 238: App_Exception.Raise_Exception;

234: IF (cur_rowid%FOUND) THEN
235: Close cur_rowid;
236: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CAFOS_CA_FK');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: Return;
240: END IF;
241: Close cur_rowid;
242:

Line 286: App_Exception.Raise_Exception;

282: ) THEN
283:
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288: Check_Constraints;
289: Check_Parent_Existance;
290: ELSIF (p_action = 'UPDATE') THEN

Line 307: App_Exception.Raise_Exception;

303: ) THEN
304:
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: Check_Constraints;
310: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
311: Check_Constraints;

Line 347: app_exception.raise_exception;

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

Line 408: app_exception.raise_exception;

404: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
405: fnd_message.set_token ('ERR_CD', SQLCODE);
406: igs_ge_msg_stack.add;
407: igs_sc_gen_001.unset_ctx('R');
408: app_exception.raise_exception;
409: ELSE
410: igs_sc_gen_001.unset_ctx('R');
411: RAISE;
412: END IF;

Line 436: app_exception.raise_exception;

432: fetch c1 into tlinfo;
433: if (c1%notfound) then
434: close c1;
435: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
436: app_exception.raise_exception;
437: return;
438: end if;
439: close c1;
440:

Line 446: app_exception.raise_exception;

442: ) then
443: null;
444: else
445: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
446: app_exception.raise_exception;
447: end if;
448: return;
449: end LOCK_ROW;
450:

Line 479: app_exception.raise_exception;

475: end if;
476: else
477: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
478: IGS_GE_MSG_STACK.ADD;
479: app_exception.raise_exception;
480: end if;
481:
482: Before_DML (
483: p_action => 'UPDATE',

Line 510: app_exception.raise_exception;

506: if (sql%notfound) then
507: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
508: igs_ge_msg_stack.add;
509: igs_sc_gen_001.unset_ctx('R');
510: app_exception.raise_exception;
511: end if;
512: IF (x_mode = 'S') THEN
513: igs_sc_gen_001.unset_ctx('R');
514: END IF;

Line 524: app_exception.raise_exception;

520: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
521: fnd_message.set_token ('ERR_CD', SQLCODE);
522: igs_ge_msg_stack.add;
523: igs_sc_gen_001.unset_ctx('R');
524: app_exception.raise_exception;
525: ELSE
526: igs_sc_gen_001.unset_ctx('R');
527: RAISE;
528: END IF;

Line 590: app_exception.raise_exception;

586: if (sql%notfound) then
587: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
588: igs_ge_msg_stack.add;
589: igs_sc_gen_001.unset_ctx('R');
590: app_exception.raise_exception;
591: end if;
592: IF (x_mode = 'S') THEN
593: igs_sc_gen_001.unset_ctx('R');
594: END IF;