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

Line 41: App_Exception.Raise_Exception;

37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:

Line 83: App_Exception.Raise_Exception;

79: new_references.course_cd,
80: v_message_name) = FALSE THEN
81: Fnd_Message.Set_Name('IGS', v_message_name);
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86: IF p_deleting THEN
87: IF IGS_EN_VAL_SCSR.enrp_val_scsr_scas(

Line 93: App_Exception.Raise_Exception;

89: old_references.course_cd,
90: v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS', v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
96: -- Validate the completed date
97: IF p_inserting THEN

Line 103: App_Exception.Raise_Exception;

99: new_references.completed_dt,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106: -- Validate the expiry date
107: IF p_inserting OR p_updating THEN

Line 115: App_Exception.Raise_Exception;

111: new_references.expiry_dt,
112: v_message_name) = FALSE THEN
113: Fnd_Message.Set_Name('IGS', v_message_name);
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118: END IF;
119: -- Validate the special requirement code is not closed

Line 126: App_Exception.Raise_Exception;

122: new_references.special_requirement_cd,
123: v_message_name) = FALSE THEN
124: Fnd_Message.Set_Name('IGS', v_message_name);
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;
129:
130:

Line 152: App_Exception.Raise_Exception;

148: new_references.expiry_dt,
149: v_message_name) = FALSE THEN
150: Fnd_Message.Set_Name('IGS', v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155:
156: END AfterRowInsertUpdate2;

Line 180: App_Exception.Raise_Exception;

176: column_name is null Then
177: IF new_references.course_cd <> UPPER(new_references.course_cd) Then
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184: IF upper(column_name) = 'SPECIAL_REQUIREMENT_CD' OR

Line 189: App_Exception.Raise_Exception;

185: column_name is null Then
186: IF new_references.special_requirement_cd <> UPPER(new_references.special_requirement_cd) Then
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
193: IF upper(column_name) = 'REFERENCE' OR

Line 198: App_Exception.Raise_Exception;

194: column_name is null Then
195: IF new_references.reference <> UPPER(new_references.reference) Then
196: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
201: END check_constraints;
202:

Line 218: App_Exception.Raise_Exception;

214: new_references.course_cd
215: ) THEN
216: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END IF;
220: END IF;
221:
222: IF (((old_references.special_requirement_cd = new_references.special_requirement_cd)) OR

Line 231: App_Exception.Raise_Exception;

227: new_references.special_requirement_cd
228: ) THEN
229: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;
234: END Check_Parent_Existance;
235:

Line 288: App_Exception.Raise_Exception;

284: IF (cur_rowid%FOUND) THEN
285: Close cur_rowid;
286: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCSR_SCA_FK');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: Return;
290: END IF;
291: Close cur_rowid;
292:

Line 314: App_Exception.Raise_Exception;

310: IF (cur_rowid%FOUND) THEN
311: Close cur_rowid;
312: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCSR_SRQ_FK');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: Return;
316: END IF;
317: Close cur_rowid;
318:

Line 367: App_Exception.Raise_Exception;

363: new_references.completed_dt
364: ) THEN
365: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
366: IGS_GE_MSG_STACK.ADD;
367: App_Exception.Raise_Exception;
368: END IF;
369: Check_Constraints;
370: Check_Parent_Existance;
371: ELSIF (p_action = 'UPDATE') THEN

Line 388: App_Exception.Raise_Exception;

384: new_references.completed_dt
385: ) 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: Check_Constraints;
391: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
392: Check_Constraints;

Line 453: app_exception.raise_exception;

449: end if;
450: else
451: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
452: IGS_GE_MSG_STACK.ADD;
453: app_exception.raise_exception;
454: end if;
455:
456: Before_DML(
457: p_action => 'INSERT',

Line 529: app_exception.raise_exception;

525: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
526: fnd_message.set_token ('ERR_CD', SQLCODE);
527: igs_ge_msg_stack.add;
528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: ELSE
531: igs_sc_gen_001.unset_ctx('R');
532: RAISE;
533: END IF;

Line 563: app_exception.raise_exception;

559: if (c1%notfound) then
560: close c1;
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: IGS_GE_MSG_STACK.ADD;
563: app_exception.raise_exception;
564: return;
565: end if;
566: close c1;
567:

Line 582: app_exception.raise_exception;

578: null;
579: else
580: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
581: IGS_GE_MSG_STACK.ADD;
582: app_exception.raise_exception;
583: end if;
584: return;
585: end LOCK_ROW;
586:

Line 618: app_exception.raise_exception;

614: end if;
615: else
616: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
617: IGS_GE_MSG_STACK.ADD;
618: app_exception.raise_exception;
619: end if;
620:
621: Before_DML(
622: p_action => 'UPDATE',

Line 654: app_exception.raise_exception;

650: if (sql%notfound) then
651: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
652: igs_ge_msg_stack.add;
653: igs_sc_gen_001.unset_ctx('R');
654: app_exception.raise_exception;
655: end if;
656: IF (x_mode = 'S') THEN
657: igs_sc_gen_001.unset_ctx('R');
658: END IF;

Line 672: app_exception.raise_exception;

668: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
669: fnd_message.set_token ('ERR_CD', SQLCODE);
670: igs_ge_msg_stack.add;
671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: ELSE
674: igs_sc_gen_001.unset_ctx('R');
675: RAISE;
676: END IF;

Line 746: app_exception.raise_exception;

742: if (sql%notfound) then
743: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
744: igs_ge_msg_stack.add;
745: igs_sc_gen_001.unset_ctx('R');
746: app_exception.raise_exception;
747: end if;
748: IF (x_mode = 'S') THEN
749: igs_sc_gen_001.unset_ctx('R');
750: END IF;