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 IGS_GE_MSG_STACK

Line 76: IGS_GE_MSG_STACK.ADD;

72: Fetch cur_old_ref_values INTO old_references;
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;

Line 168: IGS_GE_MSG_STACK.ADD;

164: IF Upper(Column_Name) = 'STATE_PERCENTILE' OR
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:

Line 178: IGS_GE_MSG_STACK.ADD;

174: IF Upper(Column_Name) = 'PERCENTILE_YEAR_RANK' OR
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:

Line 189: IGS_GE_MSG_STACK.ADD;

185: Column_Name IS NULL THEN
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:

Line 200: IGS_GE_MSG_STACK.ADD;

196: Column_Name IS NULL THEN
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:

Line 210: IGS_GE_MSG_STACK.ADD;

206: IF Upper(Column_Name) = 'PERCENTILE' OR
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:

Line 220: IGS_GE_MSG_STACK.ADD;

216: IF Upper(Column_Name) = 'NATIONAL_PERCENTILE' OR
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:

Line 230: IGS_GE_MSG_STACK.ADD;

226: IF Upper(Column_Name) = 'TEST_SCORE' OR
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:

Line 256: IGS_GE_MSG_STACK.ADD;

252: new_references.test_results_id
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

Line 284: IGS_GE_MSG_STACK.ADD;

280: 'N'
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

Line 296: IGS_GE_MSG_STACK.ADD;

292: new_references.test_results_id
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

Line 309: IGS_GE_MSG_STACK.ADD;

305: 'N'
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;

Line 418: IGS_GE_MSG_STACK.ADD;

414: Fetch cur_rowid INTO lv_rowid;
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;

Line 455: IGS_GE_MSG_STACK.ADD;

451: Fetch cur_rowid INTO lv_rowid;
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;

Line 492: IGS_GE_MSG_STACK.ADD;

488: Fetch cur_rowid INTO lv_rowid;
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;

Line 593: igs_ge_msg_stack.add;

589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');
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,

Line 906: IGS_GE_MSG_STACK.ADD;

902: Null;
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);

Line 924: IGS_GE_MSG_STACK.ADD;

920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
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;

Line 947: IGS_GE_MSG_STACK.ADD;

943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
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;

Line 962: IGS_GE_MSG_STACK.ADD;

958: -- Call all the procedures related to Before Insert.
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;

Line 1157: IGS_GE_MSG_STACK.ADD;

1153: X_PROGRAM_UPDATE_DATE := SYSDATE;
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;

Line 1313: igs_ge_msg_stack.add;

1309: WHEN OTHERS THEN
1310: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 1408: IGS_GE_MSG_STACK.ADD;

1404: open c1;
1405: fetch c1 into tlinfo;
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;

Line 1507: IGS_GE_MSG_STACK.ADD;

1503: ) then
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;

Line 1588: IGS_GE_MSG_STACK.ADD;

1584: X_LAST_UPDATE_LOGIN := -1;
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',

Line 1691: igs_ge_msg_stack.add;

1687: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
1688: where ROWID = X_ROWID;
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

Line 1710: igs_ge_msg_stack.add;

1706: WHEN OTHERS THEN
1707: IF (SQLCODE = (-28115)) THEN
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');

Line 1881: igs_ge_msg_stack.add;

1877: delete from IGS_AD_TST_RSLT_DTLS
1878: where ROWID = X_ROWID;
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