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 IGS_GE_MSG_STACK

Line 58: igs_ge_msg_stack.add;

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;
62: CLOSE cur_old_ref_values;

Line 118: igs_ge_msg_stack.add;

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:
122: END check_uniqueness;

Line 205: IGS_GE_MSG_STACK.ADD;

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:
209: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND

Line 223: IGS_GE_MSG_STACK.ADD;

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:
227: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND

Line 241: IGS_GE_MSG_STACK.ADD;

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:
245: IF (((old_references.exam_level = new_references.exam_level)) OR

Line 253: IGS_GE_MSG_STACK.ADD;

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:
257: IF (((old_references.subject_code = new_references.subject_code)) OR

Line 265: IGS_GE_MSG_STACK.ADD;

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:
269: IF (((old_references.person_id = new_references.person_id)) OR

Line 277: IGS_GE_MSG_STACK.ADD;

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:
281: END check_parent_existance;

Line 363: igs_ge_msg_stack.add;

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;
367: CLOSE cur_rowid;

Line 398: igs_ge_msg_stack.add;

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;
402: CLOSE cur_rowid;

Line 433: igs_ge_msg_stack.add;

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;
437: CLOSE cur_rowid;

Line 468: igs_ge_msg_stack.add;

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;
472: CLOSE cur_rowid;

Line 505: igs_ge_msg_stack.add;

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;
509: CLOSE cur_rowid;

Line 581: igs_ge_msg_stack.add;

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

Line 600: igs_ge_msg_stack.add;

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

Line 665: igs_ge_msg_stack.add;

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:
669: SELECT igs_uc_qual_dets_s.NEXTVAL

Line 763: igs_ge_msg_stack.add;

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
767: igs_sc_gen_001.unset_ctx('R');

Line 828: igs_ge_msg_stack.add;

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

Line 854: igs_ge_msg_stack.add;

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:
858: RETURN;

Line 912: igs_ge_msg_stack.add;

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:
916: before_dml(

Line 967: igs_ge_msg_stack.add;

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;
971: IF (x_mode = 'S') THEN

Line 980: igs_ge_msg_stack.add;

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
984: igs_sc_gen_001.unset_ctx('R');

Line 1105: igs_ge_msg_stack.add;

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;
1109: IF (x_mode = 'S') THEN