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_HE_ST_SPA_ALL_PKG dependencies on IGS_GE_MSG_STACK

Line 102: igs_ge_msg_stack.add;

98: FETCH cur_old_ref_values INTO old_references;
99: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
100: CLOSE cur_old_ref_values;
101: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: RETURN;
105: END IF;
106: CLOSE cur_old_ref_values;

Line 226: IGS_GE_MSG_STACK.ADD;

222: IF UPPER(column_name) = 'ASSOCIATE_UCAS_NUMBER' OR
223: column_name IS NULL THEN
224: IF new_references.associate_ucas_number NOT IN ( 'Y' , 'N') THEN
225: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: END IF;
230: IF UPPER(column_name) = 'ASSOCIATE_SCOTT_CAND' OR

Line 234: IGS_GE_MSG_STACK.ADD;

230: IF UPPER(column_name) = 'ASSOCIATE_SCOTT_CAND' OR
231: column_name IS NULL THEN
232: IF new_references.associate_scott_cand NOT IN ( 'Y' , 'N') THEN
233: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: APP_EXCEPTION.RAISE_EXCEPTION;
236: END IF;
237: END IF;
238: IF UPPER(column_name) = 'ASSOCIATE_TEACH_REF_NUM' OR

Line 242: IGS_GE_MSG_STACK.ADD;

238: IF UPPER(column_name) = 'ASSOCIATE_TEACH_REF_NUM' OR
239: column_name IS NULL THEN
240: IF new_references.associate_teach_ref_num NOT IN ( 'Y' , 'N') 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: IF UPPER(column_name) = 'ASSOCIATE_NHS_REG_NUM' OR

Line 250: IGS_GE_MSG_STACK.ADD;

246: IF UPPER(column_name) = 'ASSOCIATE_NHS_REG_NUM' OR
247: column_name IS NULL THEN
248: IF new_references.associate_nhs_reg_num NOT IN ( 'Y' , 'N') THEN
249: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: APP_EXCEPTION.RAISE_EXCEPTION;
252: END IF;
253: END IF;
254: END check_constraints;

Line 274: igs_ge_msg_stack.add;

270: new_references.course_cd
271: )
272: ) THEN
273: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277:
278: END check_uniqueness;

Line 303: igs_ge_msg_stack.add;

299: new_references.person_id,
300: new_references.course_cd
301: ) THEN
302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306:
307: END check_parent_existance;

Line 457: igs_ge_msg_stack.add;

453: FETCH cur_rowid INTO lv_rowid;
454: IF (cur_rowid%FOUND) THEN
455: CLOSE cur_rowid;
456: fnd_message.set_name ('IGS', 'IGS_HE_HSPA_SCA_FK');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: RETURN;
460: END IF;
461: CLOSE cur_rowid;

Line 622: igs_ge_msg_stack.add;

618: new_references.hesa_st_spa_id
619: )
620: ) THEN
621: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
622: igs_ge_msg_stack.add;
623: app_exception.raise_exception;
624: END IF;
625: check_uniqueness;
626: check_parent_existance;

Line 642: igs_ge_msg_stack.add;

638: new_references.hesa_st_spa_id
639: )
640: ) THEN
641: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645: check_uniqueness;
646: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 760: igs_ge_msg_stack.add;

756: x_last_update_login := -1;
757: END IF;
758: ELSE
759: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
760: igs_ge_msg_stack.add;
761: app_exception.raise_exception;
762: END IF;
763:
764: SELECT igs_he_st_spa_all_s.NEXTVAL

Line 990: igs_ge_msg_stack.add;

986: WHEN OTHERS THEN
987: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
988: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
989: fnd_message.set_token ('ERR_CD', SQLCODE);
990: igs_ge_msg_stack.add;
991: igs_sc_gen_001.unset_ctx('R');
992: app_exception.raise_exception;
993: ELSE
994: igs_sc_gen_001.unset_ctx('R');

Line 1146: igs_ge_msg_stack.add;

1142: OPEN c1;
1143: FETCH c1 INTO tlinfo;
1144: IF (c1%notfound) THEN
1145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1146: igs_ge_msg_stack.add;
1147: CLOSE c1;
1148: app_exception.raise_exception;
1149: RETURN;
1150: END IF;

Line 1215: igs_ge_msg_stack.add;

1211: ) THEN
1212: NULL;
1213: ELSE
1214: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1215: igs_ge_msg_stack.add;
1216: app_exception.raise_exception;
1217: END IF;
1218:
1219: RETURN;

Line 1323: igs_ge_msg_stack.add;

1319: x_last_update_login := -1;
1320: END IF;
1321: ELSE
1322: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1323: igs_ge_msg_stack.add;
1324: app_exception.raise_exception;
1325: END IF;
1326:
1327: before_dml(

Line 1466: igs_ge_msg_stack.add;

1462: WHERE rowid = x_rowid;
1463:
1464: IF (SQL%NOTFOUND) THEN
1465: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1466: igs_ge_msg_stack.add;
1467: igs_sc_gen_001.unset_ctx('R');
1468: app_exception.raise_exception;
1469: END IF;
1470: IF (x_mode = 'S') THEN

Line 1479: igs_ge_msg_stack.add;

1475: WHEN OTHERS THEN
1476: IF (SQLCODE = (-28115)) THEN
1477: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1478: fnd_message.set_token ('ERR_CD', SQLCODE);
1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: ELSE
1483: igs_sc_gen_001.unset_ctx('R');

Line 1740: igs_ge_msg_stack.add;

1736: WHERE rowid = x_rowid;
1737:
1738: IF (SQL%NOTFOUND) THEN
1739: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1740: igs_ge_msg_stack.add;
1741: igs_sc_gen_001.unset_ctx('R');
1742: app_exception.raise_exception;
1743: END IF;
1744: IF (x_mode = 'S') THEN