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_AS_SU_ATMPT_PAT_PKG dependencies on APP_EXCEPTION

Line 49: APP_EXCEPTION.RAISE_EXCEPTION;

45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: Close cur_old_ref_values;
49: APP_EXCEPTION.RAISE_EXCEPTION;
50:
51: Return;
52: END IF;
53: Close cur_old_ref_values;

Line 116: APP_EXCEPTION.RAISE_EXCEPTION;

112: v_message_name,
113: new_references.uoo_id) = FALSE THEN
114: FND_MESSAGE.SET_NAME('IGS',v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117:
118: END IF;
119: OPEN c_sua( new_references.person_id,
120: new_references.course_cd,

Line 147: FND_MESSAGE.SET_NAME('IGS',v_message_name); APP_EXCEPTION.RAISE_EXCEPTION;

143: new_references.s_default_ind,
144: 'Y', -- Called from database trigger.
145: v_message_name,
146: new_references.uoo_id) = FALSE THEN
147: FND_MESSAGE.SET_NAME('IGS',v_message_name); APP_EXCEPTION.RAISE_EXCEPTION;
148: IGS_GE_MSG_STACK.ADD;
149: END IF;
150: END IF;
151: END IF;

Line 184: APP_EXCEPTION.RAISE_EXCEPTION;

180: v_message_name,
181: new_references.uoo_id) = FALSE THEN
182: FND_MESSAGE.SET_NAME('IGS',v_message_name);
183: IGS_GE_MSG_STACK.ADD;
184: APP_EXCEPTION.RAISE_EXCEPTION;
185: END IF;
186: -- Validate there is only one active instance of the pattern for the student..
187: -- Cannot call assp_val_suaap_activ because trigger will be mutating.
188: -- Save the rowid of the current row.

Line 214: APP_EXCEPTION.RAISE_EXCEPTION;

210: v_message_name,
211: new_references.uoo_id) = FALSE THEN
212: FND_MESSAGE.SET_NAME('IGS',v_message_name);
213: IGS_GE_MSG_STACK.ADD;
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: -- Logically delete unit_ass_pattern_items within the pattern to the student
217: -- (IGS_AS_SU_ATMPT_ITM).
218: -- Store away the rowid as the routine IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI will cause the

Line 244: APP_EXCEPTION.RAISE_EXCEPTION;

240: new_references.uoo_id
241: )THEN
242: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245:
246: END IF;
247: IF (((old_references.ass_pattern_id = new_references.ass_pattern_id)) OR
248: ((new_references.ass_pattern_id IS NULL))) THEN

Line 254: APP_EXCEPTION.RAISE_EXCEPTION;

250: ELSIF NOT IGS_AS_UNTAS_PATTERN_PKG.Get_UK_For_Validation (
251: new_references.ass_pattern_id ) THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: APP_EXCEPTION.RAISE_EXCEPTION;
255:
256: END IF;
257: END Check_Parent_Existance;
258: -------------------------------------------------------------------------------------------

Line 311: APP_EXCEPTION.RAISE_EXCEPTION;

307: IF (cur_rowid%FOUND) THEN
308: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SUAAP_SUA_FK');
309: IGS_GE_MSG_STACK.ADD;
310: Close cur_rowid;
311: APP_EXCEPTION.RAISE_EXCEPTION;
312:
313: Return;
314: END IF;
315: Close cur_rowid;

Line 332: APP_EXCEPTION.RAISE_EXCEPTION;

328: IF (cur_rowid%FOUND) THEN
329: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SUAAP_SUA_FK');
330: IGS_GE_MSG_STACK.ADD;
331: Close cur_rowid;
332: APP_EXCEPTION.RAISE_EXCEPTION;
333:
334: Return;
335: END IF;
336: Close cur_rowid;

Line 388: APP_EXCEPTION.RAISE_EXCEPTION;

384: NEW_REFERENCES.creation_dt,
385: NEW_REFERENCES.uoo_id) THEN
386: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
387: IGS_GE_MSG_STACK.ADD;
388: APP_EXCEPTION.RAISE_EXCEPTION;
389: END IF;
390:
391: Check_Constraints;
392:

Line 412: APP_EXCEPTION.RAISE_EXCEPTION;

408: new_references.creation_dt,
409: new_references.uoo_id) THEN
410: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
411: IGS_GE_MSG_STACK.ADD;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413: END IF;
414:
415: Check_Constraints;
416: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 480: APP_EXCEPTION.RAISE_EXCEPTION;

476: end if;
477: else
478: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: APP_EXCEPTION.RAISE_EXCEPTION;
481: end if;
482: Before_DML(
483: p_action=>'INSERT',
484: x_rowid=>X_ROWID,

Line 576: APP_EXCEPTION.RAISE_EXCEPTION;

572: fetch c1 into tlinfo;
573: if (c1%notfound) then
574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
575: IGS_GE_MSG_STACK.ADD;
576: APP_EXCEPTION.RAISE_EXCEPTION;
577: close c1;
578: return;
579: end if;
580: close c1;

Line 590: APP_EXCEPTION.RAISE_EXCEPTION;

586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: APP_EXCEPTION.RAISE_EXCEPTION;
591: end if;
592: return;
593: end LOCK_ROW;
594: procedure UPDATE_ROW (

Line 632: APP_EXCEPTION.RAISE_EXCEPTION;

628: end if;
629: else
630: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
631: IGS_GE_MSG_STACK.ADD;
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: end if;
634: Before_DML(
635: p_action=>'UPDATE',
636: x_rowid=>X_ROWID,

Line 772: APP_EXCEPTION.RAISE_EXCEPTION;

768: column_name is null Then
769: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
770: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
771: IGS_GE_MSG_STACK.ADD;
772: APP_EXCEPTION.RAISE_EXCEPTION;
773: END IF;
774: END IF;
775:
776:

Line 782: APP_EXCEPTION.RAISE_EXCEPTION;

778: column_name is null Then
779: IF new_references.S_DEFAULT_IND NOT IN ('Y','N') Then
780: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
781: IGS_GE_MSG_STACK.ADD;
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END IF;
784: END IF;
785:
786: