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_PR_S_CRV_PRG_CAL_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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: Close cur_old_ref_values;
41: App_Exception.Raise_Exception;
42:
43: Return;
44: END IF;
45: Close cur_old_ref_values;

Line 87: App_Exception.Raise_Exception;

83: new_references.prg_cal_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: -- Validate the show cause length
91: IF p_inserting OR (p_updating AND

Line 100: App_Exception.Raise_Exception;

96: new_references.show_cause_length,
97: v_message_name) = FALSE THEN
98: Fnd_Message.Set_Name('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103: -- Validate the appeal length
104: IF p_inserting OR (p_updating AND

Line 113: App_Exception.Raise_Exception;

109: new_references.appeal_length,
110: v_message_name) = FALSE THEN
111: Fnd_Message.Set_Name('IGS',v_message_name);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116:
117:

Line 132: App_Exception.Raise_Exception;

128: new_references.prg_cal_type
129: ) THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135:
136: IF (((old_references.course_cd = new_references.course_cd) AND

Line 148: App_Exception.Raise_Exception;

144: new_references.version_number
145: ) THEN
146: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: END Check_Parent_Existance;

Line 203: App_Exception.Raise_Exception;

199: IF (cur_rowid%FOUND) THEN
200: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SCPCA_CAT_FK');
201: IGS_GE_MSG_STACK.ADD;
202: Close cur_rowid;
203: App_Exception.Raise_Exception;
204:
205: Return;
206: END IF;
207: Close cur_rowid;

Line 232: App_Exception.Raise_Exception;

228: IF (cur_rowid%FOUND) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SCPCA_SCPC_FK');
230: IGS_GE_MSG_STACK.ADD;
231: Close cur_rowid;
232: App_Exception.Raise_Exception;
233:
234: Return;
235: END IF;
236: Close cur_rowid;

Line 283: App_Exception.Raise_Exception;

279: new_references.prg_cal_type
280: ) THEN
281: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: Check_Constraints;
286: Check_Parent_Existance;
287: ELSIF (p_action = 'UPDATE') THEN

Line 301: App_Exception.Raise_Exception;

297: new_references.prg_cal_type
298: ) THEN
299: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: Check_Constraints;
304: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
305: -- Call all the procedures related to Before Update.

Line 345: app_exception.raise_exception;

341: end if;
342: else
343: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: end if;
347:
348: Before_DML(
349: p_action => 'INSERT',

Line 425: app_exception.raise_exception;

421: if (c1%notfound) then
422: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
423: IGS_GE_MSG_STACK.ADD;
424: close c1;
425: app_exception.raise_exception;
426:
427: return;
428: end if;
429: close c1;

Line 443: app_exception.raise_exception;

439: null;
440: else
441: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445: return;
446: end LOCK_ROW;
447:

Line 478: app_exception.raise_exception;

474: end if;
475: else
476: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: end if;
480:
481: Before_DML(
482: p_action => 'UPDATE',

Line 603: App_Exception.Raise_Exception ;

599: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
600: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
601: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
602: IGS_GE_MSG_STACK.ADD;
603: App_Exception.Raise_Exception ;
604: END IF;
605:
606: END IF ;
607:

Line 612: App_Exception.Raise_Exception ;

608: IF upper(Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
609: IF new_references.PRG_CAL_TYPE<> upper(new_references.PRG_CAL_TYPE) then
610: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
611: IGS_GE_MSG_STACK.ADD;
612: App_Exception.Raise_Exception ;
613: END IF;
614:
615: END IF ;
616:

Line 621: App_Exception.Raise_Exception ;

617: IF upper(Column_name) = 'STREAM_NUM' OR COLUMN_NAME IS NULL THEN
618: IF new_references.STREAM_NUM < 0 or new_references.STREAM_NUM > 99 then
619: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
620: IGS_GE_MSG_STACK.ADD;
621: App_Exception.Raise_Exception ;
622: END IF;
623:
624: END IF ;
625:

Line 630: App_Exception.Raise_Exception ;

626: IF upper(Column_name) = 'SHOW_CAUSE_LENGTH' OR COLUMN_NAME IS NULL THEN
627: IF new_references.SHOW_CAUSE_LENGTH < 0 or new_references.SHOW_CAUSE_LENGTH > 999 then
628: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
629: IGS_GE_MSG_STACK.ADD;
630: App_Exception.Raise_Exception ;
631: END IF;
632:
633: END IF ;
634:

Line 639: App_Exception.Raise_Exception ;

635: IF upper(Column_name) = 'APPEAL_LENGTH' OR COLUMN_NAME IS NULL THEN
636: IF new_references.APPEAL_LENGTH < 0 or new_references.APPEAL_LENGTH > 999 then
637: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
638: IGS_GE_MSG_STACK.ADD;
639: App_Exception.Raise_Exception ;
640: END IF;
641:
642: END IF ;
643: