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

Line 63: App_Exception.Raise_Exception;

59: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
60: Close cur_old_ref_values;
61: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
62: IGS_GE_MSG_STACK.ADD;
63: App_Exception.Raise_Exception;
64: Return;
65: END IF;
66: Close cur_old_ref_values;
67:

Line 153: App_Exception.Raise_Exception;

149: Column_Name IS NULL THEN
150: IF NOT (new_references.closed_ind IN ('Y','N')) 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:
157: -- The following code checks for check constraints on the Columns.

Line 163: App_Exception.Raise_Exception;

159: Column_Name IS NULL THEN
160: IF NOT (new_references.percentile_year_rank_ind IN ('Y','N')) THEN
161: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;
166:
167: -- The following code checks for check constraints on the Columns.

Line 173: App_Exception.Raise_Exception;

169: Column_Name IS NULL THEN
170: IF NOT (new_references.percentile_ind IN ('Y','N')) 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:
177: -- The following code checks for check constraints on the Columns.

Line 183: App_Exception.Raise_Exception;

179: Column_Name IS NULL THEN
180: IF NOT (new_references.score_band_lower_ind IN ('Y','N')) THEN
181: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: END IF;
186:
187: -- The following code checks for check constraints on the Columns.

Line 193: App_Exception.Raise_Exception;

189: Column_Name IS NULL THEN
190: IF NOT (new_references.min_score >= 0) THEN
191: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196:
197: -- The following code checks for check constraints on the Columns.

Line 203: App_Exception.Raise_Exception;

199: Column_Name IS NULL THEN
200: IF NOT (new_references.include_in_comp_score IN ('Y','N')) THEN
201: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205: END IF;
206:
207: -- The following code checks for check constraints on the Columns.

Line 213: App_Exception.Raise_Exception;

209: Column_Name IS NULL THEN
210: IF NOT (new_references.state_percentile_ind IN ('Y','N')) THEN
211: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216:
217: -- The following code checks for check constraints on the Columns.

Line 223: App_Exception.Raise_Exception;

219: Column_Name IS NULL THEN
220: IF NOT (new_references.irregularity_code_ind IN ('Y','N')) 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:
227: -- The following code checks for check constraints on the Columns.

Line 233: App_Exception.Raise_Exception;

229: Column_Name IS NULL THEN
230: IF NOT (new_references.score_ind IN ('Y','N')) THEN
231: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
232: IGS_GE_MSG_STACK.ADD;
233: App_Exception.Raise_Exception;
234: END IF;
235: END IF;
236:
237: -- The following code checks for check constraints on the Columns.

Line 243: App_Exception.Raise_Exception;

239: Column_Name IS NULL THEN
240: IF NOT (new_references.max_score >=0 and new_references.max_score > new_references.min_score) THEN
241: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246:
247: -- The following code checks for check constraints on the Columns.

Line 253: App_Exception.Raise_Exception;

249: Column_Name IS NULL THEN
250: IF NOT (new_references.national_percentile_ind IN ('Y','N')) THEN
251: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
252: IGS_GE_MSG_STACK.ADD;
253: App_Exception.Raise_Exception;
254: END IF;
255: END IF;
256:
257: -- The following code checks for check constraints on the Columns.

Line 263: App_Exception.Raise_Exception;

259: Column_Name IS NULL THEN
260: IF NOT (new_references.score_band_upper_ind IN ('Y','N')) THEN
261: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: END IF;
266:
267:

Line 289: app_exception.raise_exception;

285: ,new_references.test_segment_name
286: ) THEN
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: app_exception.raise_exception;
290:
291: END IF;
292:
293: IF new_references.segment_type = 'SCORE' THEN

Line 300: app_exception.raise_exception;

296: new_references.segment_group
297: ) THEN
298: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_UNIQUE_SEG_GRP');
299: IGS_GE_MSG_STACK.ADD;
300: app_exception.raise_exception;
301: END IF;
302: END IF;
303: END Check_Uniqueness ;
304: PROCEDURE Check_Child_Existance IS

Line 361: App_Exception.Raise_Exception;

357: IF (cur_rowid%FOUND) THEN
358: Close cur_rowid;
359: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ADTT_ADTS_FK');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: Return;
363: END IF;
364:
365: Close cur_rowid;

Line 561: App_Exception.Raise_Exception;

557: IF Get_Pk_For_Validation(
558: new_references.test_segment_id) THEN
559: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception;
562: END IF;
563: Check_Uniqueness;
564: Check_Constraints;
565: ELSIF (p_action = 'UPDATE') THEN

Line 580: App_Exception.Raise_Exception;

576: IF Get_PK_For_Validation (
577: new_references.test_segment_id) THEN
578: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
579: IGS_GE_MSG_STACK.ADD;
580: App_Exception.Raise_Exception;
581: END IF;
582: Check_Uniqueness;
583: Check_Constraints;
584: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 689: app_exception.raise_exception;

685: end if;
686: else
687: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
688: IGS_GE_MSG_STACK.ADD;
689: app_exception.raise_exception;
690: end if;
691:
692: X_TEST_SEGMENT_ID := -1;
693:

Line 799: app_exception.raise_exception;

795: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
796: fnd_message.set_token ('ERR_CD', SQLCODE);
797: igs_ge_msg_stack.add;
798: igs_sc_gen_001.unset_ctx('R');
799: app_exception.raise_exception;
800: ELSE
801: igs_sc_gen_001.unset_ctx('R');
802: RAISE;
803: END IF;

Line 868: app_exception.raise_exception;

864: if (c1%notfound) then
865: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
866: IGS_GE_MSG_STACK.ADD;
867: close c1;
868: app_exception.raise_exception;
869: return;
870: end if;
871: close c1;
872: if ( (tlinfo.MIN_SCORE = X_MIN_SCORE)

Line 894: app_exception.raise_exception;

890: null;
891: else
892: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
893: IGS_GE_MSG_STACK.ADD;
894: app_exception.raise_exception;
895: end if;
896: return;
897: end LOCK_ROW;
898: Procedure UPDATE_ROW (

Line 954: app_exception.raise_exception;

950: end if;
951: else
952: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
953: IGS_GE_MSG_STACK.ADD;
954: app_exception.raise_exception;
955: end if;
956: Before_DML(
957: p_action=>'UPDATE',
958: x_rowid=>X_ROWID,

Line 1012: app_exception.raise_exception;

1008: if (sql%notfound) then
1009: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1010: igs_ge_msg_stack.add;
1011: igs_sc_gen_001.unset_ctx('R');
1012: app_exception.raise_exception;
1013: end if;
1014: IF (x_mode = 'S') THEN
1015: igs_sc_gen_001.unset_ctx('R');
1016: END IF;

Line 1030: app_exception.raise_exception;

1026: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1027: fnd_message.set_token ('ERR_CD', SQLCODE);
1028: igs_ge_msg_stack.add;
1029: igs_sc_gen_001.unset_ctx('R');
1030: app_exception.raise_exception;
1031: ELSE
1032: igs_sc_gen_001.unset_ctx('R');
1033: RAISE;
1034: END IF;

Line 1156: app_exception.raise_exception;

1152: if (sql%notfound) then
1153: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1154: igs_ge_msg_stack.add;
1155: igs_sc_gen_001.unset_ctx('R');
1156: app_exception.raise_exception;
1157: end if;
1158: IF (x_mode = 'S') THEN
1159: igs_sc_gen_001.unset_ctx('R');
1160: END IF;