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_UC_QUAL_DETS_PKG dependencies on FND_MESSAGE

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

53: OPEN cur_old_ref_values;
54: FETCH cur_old_ref_values INTO old_references;
55: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
56: CLOSE cur_old_ref_values;
57: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
58: igs_ge_msg_stack.add;
59: app_exception.raise_exception;
60: RETURN;
61: END IF;

Line 117: fnd_message.set_name ('IGS', 'IGS_PE_QUAL_DUP_EXISTS');

113: new_references.awarding_body,
114: new_references.approved_result
115: )
116: ) THEN
117: fnd_message.set_name ('IGS', 'IGS_PE_QUAL_DUP_EXISTS');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:

Line 203: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

199: UPPER(TRIM(new_references.grading_schema_cd)),
200: new_references.version_number,
201: UPPER(TRIM(new_references.claimed_result))
202: ) THEN
203: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_CLAIM_RSLT'));
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;

Line 204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_CLAIM_RSLT'));

200: new_references.version_number,
201: UPPER(TRIM(new_references.claimed_result))
202: ) THEN
203: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_CLAIM_RSLT'));
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208:

Line 221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

217: UPPER(TRIM(new_references.grading_schema_cd)),
218: new_references.version_number,
219: UPPER(TRIM(new_references.predicted_result))
220: ) THEN
221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_PRD_RSLT'));
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_PRD_RSLT'));

218: new_references.version_number,
219: UPPER(TRIM(new_references.predicted_result))
220: ) THEN
221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_PRD_RSLT'));
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226:

Line 239: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

235: UPPER(TRIM(new_references.grading_schema_cd)),
236: new_references.version_number,
237: UPPER(TRIM(new_references.approved_result))
238: ) THEN
239: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_APRD_RSLT'));
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;

Line 240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_APRD_RSLT'));

236: new_references.version_number,
237: UPPER(TRIM(new_references.approved_result))
238: ) THEN
239: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRD_SCHEMA_APRD_RSLT'));
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244:

Line 251: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

247: NULL;
248: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
249: UPPER(TRIM(new_references.exam_level))
250: ) THEN
251: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXAM_LEVEL'));
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;

Line 252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXAM_LEVEL'));

248: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
249: UPPER(TRIM(new_references.exam_level))
250: ) THEN
251: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXAM_LEVEL'));
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256:

Line 263: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

259: NULL;
260: ELSIF NOT igs_ps_fld_of_study_pkg.get_pk_for_validation (
261: UPPER(TRIM(new_references.subject_code))
262: ) THEN
263: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUBJECT'));
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;

Line 264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUBJECT'));

260: ELSIF NOT igs_ps_fld_of_study_pkg.get_pk_for_validation (
261: UPPER(TRIM(new_references.subject_code))
262: ) THEN
263: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUBJECT'));
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;
268:

Line 275: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

271: NULL;
272: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
273: new_references.person_id
274: ) THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;

Line 276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));

272: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
273: new_references.person_id
274: ) THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280:

Line 362: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

358: OPEN cur_rowid;
359: FETCH cur_rowid INTO lv_rowid;
360: IF (cur_rowid%FOUND) THEN
361: CLOSE cur_rowid;
362: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: RETURN;
366: END IF;

Line 397: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

393: OPEN cur_rowid;
394: FETCH cur_rowid INTO lv_rowid;
395: IF (cur_rowid%FOUND) THEN
396: CLOSE cur_rowid;
397: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
398: igs_ge_msg_stack.add;
399: app_exception.raise_exception;
400: RETURN;
401: END IF;

Line 432: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

428: OPEN cur_rowid;
429: FETCH cur_rowid INTO lv_rowid;
430: IF (cur_rowid%FOUND) THEN
431: CLOSE cur_rowid;
432: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: RETURN;
436: END IF;

Line 467: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

463: OPEN cur_rowid;
464: FETCH cur_rowid INTO lv_rowid;
465: IF (cur_rowid%FOUND) THEN
466: CLOSE cur_rowid;
467: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
468: igs_ge_msg_stack.add;
469: app_exception.raise_exception;
470: RETURN;
471: END IF;

Line 504: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

500: OPEN cur_rowid;
501: FETCH cur_rowid INTO lv_rowid;
502: IF (cur_rowid%FOUND) THEN
503: CLOSE cur_rowid;
504: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: RETURN;
508: END IF;

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

576: IF ( get_pk_for_validation(
577: new_references.qual_dets_id
578: )
579: ) THEN
580: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
581: igs_ge_msg_stack.add;
582: app_exception.raise_exception;
583: END IF;
584: check_parent_existance;

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

595: IF ( get_pk_for_validation (
596: new_references.qual_dets_id
597: )
598: ) THEN
599: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
600: igs_ge_msg_stack.add;
601: app_exception.raise_exception;
602: END IF;
603: check_uniqueness;

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

660: IF (x_last_update_login IS NULL) THEN
661: x_last_update_login := -1;
662: END IF;
663: ELSE
664: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
665: igs_ge_msg_stack.add;
666: app_exception.raise_exception;
667: END IF;
668:

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

757:
758: EXCEPTION
759: WHEN OTHERS THEN
760: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
761: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
762: fnd_message.set_token ('ERR_CD', SQLCODE);
763: igs_ge_msg_stack.add;
764: igs_sc_gen_001.unset_ctx('R');
765: app_exception.raise_exception;

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

758: EXCEPTION
759: WHEN OTHERS THEN
760: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
761: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
762: fnd_message.set_token ('ERR_CD', SQLCODE);
763: igs_ge_msg_stack.add;
764: igs_sc_gen_001.unset_ctx('R');
765: app_exception.raise_exception;
766: ELSE

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

823:
824: OPEN c1;
825: FETCH c1 INTO tlinfo;
826: IF (c1%notfound) THEN
827: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
828: igs_ge_msg_stack.add;
829: CLOSE c1;
830: app_exception.raise_exception;
831: RETURN;

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

849: AND (tlinfo.imported_date = x_imported_date)
850: ) THEN
851: NULL;
852: ELSE
853: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
854: igs_ge_msg_stack.add;
855: app_exception.raise_exception;
856: END IF;
857:

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

907: IF (x_last_update_login IS NULL) THEN
908: x_last_update_login := -1;
909: END IF;
910: ELSE
911: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
912: igs_ge_msg_stack.add;
913: app_exception.raise_exception;
914: END IF;
915:

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

962: last_update_login = x_last_update_login
963: WHERE rowid = x_rowid;
964:
965: IF (SQL%NOTFOUND) THEN
966: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
967: igs_ge_msg_stack.add;
968: igs_sc_gen_001.unset_ctx('R');
969: app_exception.raise_exception;
970: END IF;

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

974:
975: EXCEPTION
976: WHEN OTHERS THEN
977: IF (SQLCODE = (-28115)) THEN
978: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
979: fnd_message.set_token ('ERR_CD', SQLCODE);
980: igs_ge_msg_stack.add;
981: igs_sc_gen_001.unset_ctx('R');
982: app_exception.raise_exception;

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

975: EXCEPTION
976: WHEN OTHERS THEN
977: IF (SQLCODE = (-28115)) THEN
978: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
979: fnd_message.set_token ('ERR_CD', SQLCODE);
980: igs_ge_msg_stack.add;
981: igs_sc_gen_001.unset_ctx('R');
982: app_exception.raise_exception;
983: ELSE

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

1100: DELETE FROM igs_uc_qual_dets
1101: WHERE rowid = x_rowid;
1102:
1103: IF (SQL%NOTFOUND) THEN
1104: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1105: igs_ge_msg_stack.add;
1106: igs_sc_gen_001.unset_ctx('R');
1107: app_exception.raise_exception;
1108: END IF;