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

Line 77: App_Exception.Raise_Exception;

73: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
74: Close cur_old_ref_values;
75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: Return;
79: END IF;
80: Close cur_old_ref_values;
81:

Line 169: App_Exception.Raise_Exception;

165: Column_Name IS NULL THEN
166: IF NOT (new_references.state_percentile>=0 and new_references.state_percentile<=100) THEN
167: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172:
173: -- The following code checks for check constraints on the Columns.

Line 179: App_Exception.Raise_Exception;

175: Column_Name IS NULL THEN
176: IF NOT (new_references.percentile_year_rank>=0) THEN
177: Fnd_Message.Set_Name('IGS','IGS_AD_PCTLYR_RANK_NOT_LT_0');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
182:
183: -- The following code checks for check constraints on the Columns.

Line 190: App_Exception.Raise_Exception;

186: IF NOT (new_references.score_band_lower>=0
187: OR new_references.score_band_lower IS NULL) THEN
188: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193:
194: -- The following code checks for check constraints on the Columns.

Line 201: App_Exception.Raise_Exception;

197: IF NOT (new_references.score_band_upper>=0
198: OR new_references.score_band_upper IS NULL) THEN
199: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204:
205: -- The following code checks for check constraints on the Columns.

Line 211: App_Exception.Raise_Exception;

207: Column_Name IS NULL THEN
208: IF NOT (new_references.percentile>=0 and new_references.percentile<=100) THEN
209: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: END IF;
214:
215: -- The following code checks for check constraints on the Columns.

Line 221: App_Exception.Raise_Exception;

217: Column_Name IS NULL THEN
218: IF NOT (new_references.national_percentile>=0 and new_references.national_percentile<=100) THEN
219: Fnd_Message.Set_Name('IGS','IGS_IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: END IF;
224:
225: -- The following code checks for check constraints on the Columns.

Line 231: App_Exception.Raise_Exception;

227: Column_Name IS NULL THEN
228: IF NOT (new_references.test_score>=0) THEN
229: Fnd_Message.Set_Name('IGS','IGS_AD_SCORE_NOT_LT_ZERO');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;
234:
235:

Line 257: app_exception.raise_exception;

253: ,new_references.test_segment_id
254: ) THEN
255: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
256: IGS_GE_MSG_STACK.ADD;
257: app_exception.raise_exception;
258: END IF;
259: END Check_Uniqueness ;
260: PROCEDURE Check_Parent_Existance AS
261: /*************************************************************

Line 285: App_Exception.Raise_Exception;

281: ) THEN
282: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_IRREGULARITY'));
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287:
288: IF (((old_references.test_results_id = new_references.test_results_id)) OR
289: ((new_references.test_results_id IS NULL))) THEN

Line 297: App_Exception.Raise_Exception;

293: ) THEN
294: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_RESULT'));
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299:
300: IF (((old_references.test_segment_id = new_references.test_segment_id)) OR
301: ((new_references.test_segment_id IS NULL))) THEN

Line 310: App_Exception.Raise_Exception;

306: ) THEN
307: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_SEGMNT'));
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312:
313: END Check_Parent_Existance;
314:

Line 419: App_Exception.Raise_Exception;

415: IF (cur_rowid%FOUND) THEN
416: Close cur_rowid;
417: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ACDC_FK');
418: IGS_GE_MSG_STACK.ADD;
419: App_Exception.Raise_Exception;
420: Return;
421: END IF;
422: Close cur_rowid;
423:

Line 456: App_Exception.Raise_Exception;

452: IF (cur_rowid%FOUND) THEN
453: Close cur_rowid;
454: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATR_FK');
455: IGS_GE_MSG_STACK.ADD;
456: App_Exception.Raise_Exception;
457: Return;
458: END IF;
459: Close cur_rowid;
460:

Line 493: App_Exception.Raise_Exception;

489: IF (cur_rowid%FOUND) THEN
490: Close cur_rowid;
491: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATS_FK');
492: IGS_GE_MSG_STACK.ADD;
493: App_Exception.Raise_Exception;
494: Return;
495: END IF;
496: Close cur_rowid;
497:

Line 594: App_Exception.Raise_Exception;

590: testResult := fnd_message.get();
591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');
592: fnd_message.set_token('RECORD',testResult);
593: igs_ge_msg_stack.add;
594: App_Exception.Raise_Exception;
595: END update_parent_composite_score;
596:
597: PROCEDURE validate_record(p_error OUT NOCOPY BOOLEAN,
598: p_message OUT NOCOPY VARCHAR2,

Line 907: App_Exception.Raise_Exception;

903: IF Get_Pk_For_Validation(
904: new_references.tst_rslt_dtls_id) THEN
905: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
906: IGS_GE_MSG_STACK.ADD;
907: App_Exception.Raise_Exception;
908: END IF;
909:
910: validate_record(l_error,l_message_name,l_entity1,l_entity2,l_entity3);
911:

Line 925: App_Exception.Raise_Exception;

921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
923: END IF;
924: IGS_GE_MSG_STACK.ADD;
925: App_Exception.Raise_Exception;
926: END IF;
927: Check_Uniqueness;
928: Check_Constraints;
929: Check_Parent_Existance;

Line 948: App_Exception.Raise_Exception;

944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
946: END IF;
947: IGS_GE_MSG_STACK.ADD;
948: App_Exception.Raise_Exception;
949: END IF;
950:
951: Check_Uniqueness;
952: Check_Constraints;

Line 963: App_Exception.Raise_Exception;

959: IF Get_PK_For_Validation (
960: new_references.tst_rslt_dtls_id) THEN
961: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
962: IGS_GE_MSG_STACK.ADD;
963: App_Exception.Raise_Exception;
964: END IF;
965:
966: Check_Uniqueness;
967: Check_Constraints;

Line 1158: app_exception.raise_exception;

1154: end if;
1155: else
1156: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1157: IGS_GE_MSG_STACK.ADD;
1158: app_exception.raise_exception;
1159: end if;
1160:
1161: X_TST_RSLT_DTLS_ID := -1;
1162: Before_DML(

Line 1315: app_exception.raise_exception;

1311: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1312: fnd_message.set_token ('ERR_CD', SQLCODE);
1313: igs_ge_msg_stack.add;
1314: igs_sc_gen_001.unset_ctx('R');
1315: app_exception.raise_exception;
1316: ELSE
1317: igs_sc_gen_001.unset_ctx('R');
1318: RAISE;
1319: END IF;

Line 1410: app_exception.raise_exception;

1406: if (c1%notfound) then
1407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1408: IGS_GE_MSG_STACK.ADD;
1409: close c1;
1410: app_exception.raise_exception;
1411: return;
1412: end if;
1413: close c1;
1414: if ( ( tlinfo.TEST_RESULTS_ID = X_TEST_RESULTS_ID)

Line 1508: app_exception.raise_exception;

1504: null;
1505: else
1506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1507: IGS_GE_MSG_STACK.ADD;
1508: app_exception.raise_exception;
1509: end if;
1510: return;
1511: end LOCK_ROW;
1512: Procedure UPDATE_ROW (

Line 1589: app_exception.raise_exception;

1585: end if;
1586: else
1587: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1588: IGS_GE_MSG_STACK.ADD;
1589: app_exception.raise_exception;
1590: end if;
1591: Before_DML(
1592: p_action=>'UPDATE',
1593: x_rowid=>X_ROWID,

Line 1693: app_exception.raise_exception;

1689: if (sql%notfound) then
1690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1691: igs_ge_msg_stack.add;
1692: igs_sc_gen_001.unset_ctx('R');
1693: app_exception.raise_exception;
1694: end if;
1695: IF (x_mode = 'S') THEN
1696: igs_sc_gen_001.unset_ctx('R');
1697: END IF;

Line 1712: app_exception.raise_exception;

1708: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1709: fnd_message.set_token ('ERR_CD', SQLCODE);
1710: igs_ge_msg_stack.add;
1711: igs_sc_gen_001.unset_ctx('R');
1712: app_exception.raise_exception;
1713: ELSE
1714: igs_sc_gen_001.unset_ctx('R');
1715: RAISE;
1716: END IF;

Line 1883: app_exception.raise_exception;

1879: if (sql%notfound) then
1880: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1881: igs_ge_msg_stack.add;
1882: igs_sc_gen_001.unset_ctx('R');
1883: app_exception.raise_exception;
1884: end if;
1885: IF (x_mode = 'S') THEN
1886: igs_sc_gen_001.unset_ctx('R');
1887: END IF;