APPS.IGS_RE_GV_TOA_CLS_CD_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: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 77: App_Exception.Raise_Exception ;

73: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
74: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
75: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception ;
78: END IF;
79: END IF;
80: IF upper(column_name) = 'GOVT_TOA_CLASS_CD' OR COLUMN_NAME IS NULL THEN
81: IF new_references.GOVT_TOA_CLASS_CD <> upper(NEW_REFERENCES.GOVT_TOA_CLASS_CD) THEN

Line 84: App_Exception.Raise_Exception ;

80: IF upper(column_name) = 'GOVT_TOA_CLASS_CD' OR COLUMN_NAME IS NULL THEN
81: IF new_references.GOVT_TOA_CLASS_CD <> upper(NEW_REFERENCES.GOVT_TOA_CLASS_CD) THEN
82: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception ;
85: END IF;
86: END IF;
87: END Check_Constraints ;
88:

Line 159: App_Exception.Raise_Exception;

155: ) THEN
156:
157: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: Check_Constraints;
162: ELSIF (p_action = 'UPDATE') THEN
163: -- Call all the procedures related to Before Update.

Line 175: App_Exception.Raise_Exception;

171: ) THEN
172:
173: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: Check_Constraints;
178: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
179: Check_Constraints;

Line 214: app_exception.raise_exception;

210: end if;
211: else
212: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
213: IGS_GE_MSG_STACK.ADD;
214: app_exception.raise_exception;
215: end if;
216:
217: Before_DML (
218: p_action => 'INSERT',

Line 280: app_exception.raise_exception;

276: fetch c1 into tlinfo;
277: if (c1%notfound) then
278: close c1;
279: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
280: app_exception.raise_exception;
281: return;
282: end if;
283: close c1;
284:

Line 291: app_exception.raise_exception;

287: ) then
288: null;
289: else
290: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
291: app_exception.raise_exception;
292: end if;
293: return;
294: end LOCK_ROW;
295:

Line 323: app_exception.raise_exception;

319: end if;
320: else
321: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
322: IGS_GE_MSG_STACK.ADD;
323: app_exception.raise_exception;
324: end if;
325:
326: Before_DML (
327: p_action => 'UPDATE',