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 FND_MESSAGE

Line 101: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

97: OPEN cur_old_ref_values;
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;

Line 225: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');

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

Line 233: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');

229: END IF;
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;

Line 241: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');

237: END IF;
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;

Line 249: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_VALUE');

245: END IF;
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;

Line 273: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

269: new_references.person_id,
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:

Line 302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

298: ELSIF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
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:

Line 456: fnd_message.set_name ('IGS', 'IGS_HE_HSPA_SCA_FK');

452: OPEN cur_rowid;
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;

Line 621: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

617: IF ( get_pk_for_validation(
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;

Line 641: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

637: IF ( get_pk_for_validation (
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;

Line 759: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

755: IF (x_last_update_login IS NULL) THEN
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:

Line 988: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

984:
985: EXCEPTION
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;

Line 989: fnd_message.set_token ('ERR_CD', SQLCODE);

985: EXCEPTION
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

Line 1145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

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

Line 1214: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1210: AND ((tlinfo.exclude_flag = x_exclude_flag) OR ((tlinfo.exclude_flag IS NULL) AND (x_exclude_flag IS NULL)))
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:

Line 1322: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

1318: IF (x_last_update_login IS NULL) THEN
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:

Line 1465: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1461: exclude_flag = new_references.exclude_flag
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;

Line 1477: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1473:
1474: EXCEPTION
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;

Line 1478: fnd_message.set_token ('ERR_CD', SQLCODE);

1474: EXCEPTION
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

Line 1739: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1735: DELETE FROM igs_he_st_spa_all
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;