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 APP_EXCEPTION

Line 59: app_exception.raise_exception;

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

Line 119: app_exception.raise_exception;

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

Line 206: App_Exception.Raise_Exception;

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
210: (old_references.version_number = new_references.version_number) AND

Line 224: App_Exception.Raise_Exception;

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
228: (old_references.version_number = new_references.version_number) AND

Line 242: App_Exception.Raise_Exception;

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
246: ((new_references.exam_level IS NULL))) THEN

Line 254: App_Exception.Raise_Exception;

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
258: ((new_references.subject_code IS NULL))) THEN

Line 266: App_Exception.Raise_Exception;

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
270: ((new_references.person_id IS NULL))) THEN

Line 278: App_Exception.Raise_Exception;

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

Line 364: app_exception.raise_exception;

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

Line 399: app_exception.raise_exception;

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

Line 434: app_exception.raise_exception;

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

Line 469: app_exception.raise_exception;

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

Line 506: app_exception.raise_exception;

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

Line 582: app_exception.raise_exception;

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

Line 601: app_exception.raise_exception;

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
605: Check_Child_Existance;

Line 666: app_exception.raise_exception;

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
670: INTO x_qual_dets_id

Line 765: app_exception.raise_exception;

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');
768: RAISE;
769: END IF;

Line 830: app_exception.raise_exception;

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;
833: CLOSE c1;
834:

Line 855: app_exception.raise_exception;

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

Line 913: app_exception.raise_exception;

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

Line 969: app_exception.raise_exception;

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

Line 982: app_exception.raise_exception;

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');
985: RAISE;
986: END IF;

Line 1107: app_exception.raise_exception;

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