APPS.IGS_RE_THS_PNL_TYPE_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 78: App_Exception.Raise_Exception;

74: IF NOT IGS_TR_VAL_TRI.TRKP_VAL_TRI_TYPE (new_references.tracking_type,
75: v_message_name) THEN
76: Fnd_Message.Set_Name('IGS', v_message_name);
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81: END BeforeRowInsertUpdate;
82:

Line 105: App_Exception.Raise_Exception;

101: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
102: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
103: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:
109: IF upper(Column_name) = 'RECOMMENDED_PANEL_SIZE' OR column_name is null then

Line 113: App_Exception.Raise_Exception;

109: IF upper(Column_name) = 'RECOMMENDED_PANEL_SIZE' OR column_name is null then
110: IF new_references.recommended_panel_size < 1 OR new_references.recommended_panel_size > 99 then
111: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116:
117:

Line 122: App_Exception.Raise_Exception;

118: IF upper(Column_name) = 'THESIS_PANEL_TYPE' OR column_name is null then
119: IF new_references.thesis_panel_type <> UPPER(new_references.thesis_panel_type ) then
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:
126: IF upper(Column_name) = 'TRACKING_TYPE' OR column_name is null then

Line 130: App_Exception.Raise_Exception;

126: IF upper(Column_name) = 'TRACKING_TYPE' OR column_name is null then
127: IF new_references.tracking_type <> UPPER(new_references.tracking_type) then
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: END IF;
133:
134: END Check_Constraints;

Line 148: App_Exception.Raise_Exception;

144: new_references.tracking_type
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: END Check_Parent_Existance;
152:

Line 229: App_Exception.Raise_Exception;

225: new_references.thesis_panel_type
226: )THEN
227: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: Check_Constraints;
232: Check_Parent_Existance;
233: ELSIF (p_action = 'UPDATE') THEN

Line 247: App_Exception.Raise_Exception;

243: new_references.thesis_panel_type
244: )THEN
245: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: Check_Constraints;
250: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
251: Check_Constraints;

Line 291: app_exception.raise_exception;

287: end if;
288: else
289: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: end if;
293:
294: Before_DML (
295: p_action => 'INSERT',

Line 372: app_exception.raise_exception;

368: fetch c1 into tlinfo;
369: if (c1%notfound) then
370: close c1;
371: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
372: app_exception.raise_exception;
373: return;
374: end if;
375: close c1;
376:

Line 392: app_exception.raise_exception;

388: ) then
389: null;
390: else
391: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
392: app_exception.raise_exception;
393: end if;
394: return;
395: end LOCK_ROW;
396:

Line 427: app_exception.raise_exception;

423: end if;
424: else
425: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
426: IGS_GE_MSG_STACK.ADD;
427: app_exception.raise_exception;
428: end if;
429:
430: Before_DML (
431: p_action => 'UPDATE',