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 APP_EXCEPTION

Line 103: app_exception.raise_exception;

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;
107:

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

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
231: column_name IS NULL THEN

Line 235: APP_EXCEPTION.RAISE_EXCEPTION;

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
239: column_name IS NULL THEN

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

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
247: column_name IS NULL THEN

Line 251: APP_EXCEPTION.RAISE_EXCEPTION;

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;
255:

Line 275: app_exception.raise_exception;

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;
279:

Line 304: app_exception.raise_exception;

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;
308:

Line 458: app_exception.raise_exception;

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;
462:

Line 623: app_exception.raise_exception;

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;
627: ELSIF (p_action = 'UPDATE') THEN

Line 643: app_exception.raise_exception;

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
647: check_uniqueness;

Line 761: app_exception.raise_exception;

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
765: INTO x_hesa_st_spa_id

Line 992: app_exception.raise_exception;

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');
995: RAISE;
996: END IF;

Line 1148: app_exception.raise_exception;

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;
1151: CLOSE c1;
1152:

Line 1216: app_exception.raise_exception;

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;
1220:

Line 1324: app_exception.raise_exception;

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(
1328: p_action => 'UPDATE',

Line 1468: app_exception.raise_exception;

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
1471: igs_sc_gen_001.unset_ctx('R');
1472: END IF;

Line 1481: app_exception.raise_exception;

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');
1484: RAISE;
1485: END IF;

Line 1742: app_exception.raise_exception;

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
1745: igs_sc_gen_001.unset_ctx('R');
1746: END IF;