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_PS_FACLTY_DISP_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: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;
53:

Line 103: App_Exception.Raise_Exception;

99: Column_Name IS NULL THEN
100: IF NOT (new_references.displn_unit_type IN ('DISCIPLINE', 'UNIT')) THEN
101: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107:

Line 130: app_exception.raise_exception;

126: ,new_references.person_id
127: ) THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
129: IGS_GE_MSG_STACK.ADD;
130: app_exception.raise_exception;
131: END IF;
132: END Check_Uniqueness ;
133: PROCEDURE Check_Parent_Existance AS
134: /*************************************************************

Line 155: App_Exception.Raise_Exception;

151: new_references.person_id
152: ) THEN
153: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157:
158: --- Special Condition to check in 2 tables (The ARC Relationship )
159: IF new_references.displn_unit_type = 'UNIT' THEN

Line 170: App_Exception.Raise_Exception;

166: 1
167: ) THEN
168: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172:
173: ELSE --- (Arc Relation)
174:

Line 183: App_Exception.Raise_Exception;

179: new_references.displn_unit_cd
180: ) THEN
181: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185:
186: END IF; ---- (ARC Relation)
187: END Check_Parent_Existance;

Line 294: App_Exception.Raise_Exception;

290: IF (cur_rowid%FOUND) THEN
291: Close cur_rowid;
292: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FDS_PE_FK');
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: Return;
296: END IF;
297: Close cur_rowid;
298:

Line 333: App_Exception.Raise_Exception;

329: IF (cur_rowid%FOUND) THEN
330: Close cur_rowid;
331: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FDS_UV_FK');
332: IGS_GE_MSG_STACK.ADD;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;
336: Close cur_rowid;
337:

Line 387: App_Exception.Raise_Exception;

383: IF Get_Pk_For_Validation(
384: new_references.displn_unit_id) THEN
385: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Uniqueness;
390: Check_Constraints;
391: Check_Parent_Existance;

Line 407: App_Exception.Raise_Exception;

403: IF Get_PK_For_Validation (
404: new_references.displn_unit_id) THEN
405: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
406: IGS_GE_MSG_STACK.ADD;
407: App_Exception.Raise_Exception;
408: END IF;
409: Check_Uniqueness;
410: Check_Constraints;
411: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 495: app_exception.raise_exception;

491: end if;
492: else
493: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: SELECT IGS_PS_DISPLN_UNIT_CD_S.nextval into x_DISPLN_UNIT_ID FROM dual;
498: Before_DML(
499: p_action=>'INSERT',

Line 555: app_exception.raise_exception;

551: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
552: fnd_message.set_token ('ERR_CD', SQLCODE);
553: igs_ge_msg_stack.add;
554: igs_sc_gen_001.unset_ctx('R');
555: app_exception.raise_exception;
556: ELSE
557: igs_sc_gen_001.unset_ctx('R');
558: RAISE;
559: END IF;

Line 594: app_exception.raise_exception;

590: if (c1%notfound) then
591: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
592: IGS_GE_MSG_STACK.ADD;
593: close c1;
594: app_exception.raise_exception;
595: return;
596: end if;
597: close c1;
598: if ( ( tlinfo.DISPLN_UNIT_TYPE = X_DISPLN_UNIT_TYPE)

Line 606: app_exception.raise_exception;

602: null;
603: else
604: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
605: IGS_GE_MSG_STACK.ADD;
606: app_exception.raise_exception;
607: end if;
608: return;
609: end LOCK_ROW;
610: Procedure UPDATE_ROW (

Line 649: app_exception.raise_exception;

645: end if;
646: else
647: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
648: IGS_GE_MSG_STACK.ADD;
649: app_exception.raise_exception;
650: end if;
651: Before_DML(
652: p_action=>'UPDATE',
653: x_rowid=>X_ROWID,

Line 678: app_exception.raise_exception;

674: if (sql%notfound) then
675: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
676: igs_ge_msg_stack.add;
677: igs_sc_gen_001.unset_ctx('R');
678: app_exception.raise_exception;
679: end if;
680: IF (x_mode = 'S') THEN
681: igs_sc_gen_001.unset_ctx('R');
682: END IF;

Line 696: app_exception.raise_exception;

692: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
693: fnd_message.set_token ('ERR_CD', SQLCODE);
694: igs_ge_msg_stack.add;
695: igs_sc_gen_001.unset_ctx('R');
696: app_exception.raise_exception;
697: ELSE
698: igs_sc_gen_001.unset_ctx('R');
699: RAISE;
700: END IF;

Line 777: app_exception.raise_exception;

773: if (sql%notfound) then
774: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
775: igs_ge_msg_stack.add;
776: igs_sc_gen_001.unset_ctx('R');
777: app_exception.raise_exception;
778: end if;
779: IF (x_mode = 'S') THEN
780: igs_sc_gen_001.unset_ctx('R');
781: END IF;