APPS.IGS_EN_UNITSETPSTYPE_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 91: App_Exception.Raise_Exception;

87: v_version_number,
88: v_message_name) = FALSE THEN
89: Fnd_Message.Set_Name('IGS', v_message_name);
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: IF p_inserting OR p_updating THEN
94: --
95: -- Can not alter details when COURSE type is closed

Line 101: App_Exception.Raise_Exception;

97: new_references.course_type,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS', v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105:

Line 130: App_Exception.Raise_Exception;

126: IF ((UPPER (column_name) = 'COURSE_TYPE') OR (column_name IS NULL)) THEN
127: IF (new_references.course_type <> UPPER (new_references.course_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: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN

Line 138: App_Exception.Raise_Exception;

134: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
135: IF (new_references.unit_set_cd <> UPPER (new_references.unit_set_cd)) THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:
142:

Line 158: App_Exception.Raise_Exception;

154: new_references.course_type
155: ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159:
160: END IF;
161:
162: END IF;

Line 177: App_Exception.Raise_Exception;

173: ) THEN
174:
175: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178:
179: END IF;
180:
181: END IF;

Line 239: App_Exception.Raise_Exception;

235: IF (cur_rowid%FOUND) THEN
236: Fnd_Message.Set_Name ('IGS', 'IGS_EN_USCT_US_FK');
237: IGS_GE_MSG_STACK.ADD;
238: Close cur_rowid;
239: App_Exception.Raise_Exception;
240: Return;
241: END IF;
242: Close cur_rowid;
243:

Line 285: App_Exception.Raise_Exception;

281: ) THEN
282:
283: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286:
287: END IF;
288:
289: Check_Constraints;

Line 307: App_Exception.Raise_Exception;

303: new_references.course_type
304: ) THEN
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: Check_Constraints;
310: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
311: Check_Constraints;

Line 372: app_exception.raise_exception;

368: end if;
369: else
370: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
371: IGS_GE_MSG_STACK.ADD;
372: app_exception.raise_exception;
373: end if;
374:
375: Before_DML(
376: p_action => 'INSERT' ,

Line 443: app_exception.raise_exception;

439: if (c1%notfound) then
440: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
441: IGS_GE_MSG_STACK.ADD;
442: close c1;
443: app_exception.raise_exception;
444: return;
445: end if;
446: close c1;
447: return;