APPS.IGS_RE_THS_PNL_MR_TP_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 77: App_Exception.Raise_Exception;

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

Line 103: App_Exception.Raise_Exception;

99: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then
100: IF new_references.panel_member_type <> UPPER(new_references.panel_member_type ) 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: IF upper(Column_name) = 'TRACKING_TYPE' OR column_name is null then

Line 111: App_Exception.Raise_Exception;

107: IF upper(Column_name) = 'TRACKING_TYPE' OR column_name is null then
108: IF new_references.tracking_type <> UPPER(new_references.tracking_type ) then
109: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:
115: IF upper(Column_name) = 'PANEL_CHAIR_IND' OR column_name is null then

Line 120: App_Exception.Raise_Exception;

116: IF new_references.panel_chair_ind <> UPPER(new_references.panel_chair_ind) OR
117: new_references.panel_chair_ind NOT IN ( 'Y' , 'N' ) then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
124: IF upper(Column_name) = 'CLOSED_IND' OR column_name is null THEN

Line 129: App_Exception.Raise_Exception;

125: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
126: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
133: END Check_Constraints;

Line 147: App_Exception.Raise_Exception;

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

Line 227: App_Exception.Raise_Exception;

223: new_references.panel_member_type
224: )THEN
225: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END IF;
229: Check_Constraints;
230: Check_Parent_Existance;
231: ELSIF (p_action = 'UPDATE') THEN

Line 245: App_Exception.Raise_Exception;

241: new_references.panel_member_type
242: )THEN
243: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: Check_Constraints;
248: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
249: Check_Constraints;

Line 288: app_exception.raise_exception;

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

Line 367: app_exception.raise_exception;

363: fetch c1 into tlinfo;
364: if (c1%notfound) then
365: close c1;
366: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
367: app_exception.raise_exception;
368: return;
369: end if;
370: close c1;
371:

Line 382: app_exception.raise_exception;

378: ) then
379: null;
380: else
381: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
382: app_exception.raise_exception;
383: end if;
384: return;
385: end LOCK_ROW;
386:

Line 416: app_exception.raise_exception;

412: end if;
413: else
414: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
415: IGS_GE_MSG_STACK.ADD;
416: app_exception.raise_exception;
417: end if;
418:
419: Before_DML (
420: p_action => 'UPDATE',