APPS.IGS_RU_RET_TYPE_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 79: App_Exception.Raise_Exception ;

75: IF upper(Column_name) = 'S_RETURN_TYPE' OR COLUMN_NAME IS NULL THEN
76: IF new_references.S_RETURN_TYPE<> upper(new_references.S_RETURN_TYPE) then
77: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception ;
80: END IF;
81:
82: END IF ;
83:

Line 88: App_Exception.Raise_Exception ;

84: IF upper(Column_name) = 'FUNCTION_RETURN_IND' OR COLUMN_NAME IS NULL THEN
85: IF new_references.FUNCTION_RETURN_IND NOT IN ('Y','N') then
86: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception ;
89: END IF;
90: END IF ;
91: END Check_Constraints;
92:

Line 162: App_Exception.Raise_Exception;

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

Line 177: App_Exception.Raise_Exception;

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

Line 226: app_exception.raise_exception;

222: end if;
223: else
224: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
225: IGS_GE_MSG_STACK.ADD;
226: app_exception.raise_exception;
227: end if;
228:
229: Before_DML(
230: p_action=>'INSERT',

Line 291: app_exception.raise_exception;

287: if (c1%notfound) then
288: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
289: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW : IGSUI10B.PLS');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: close c1;
293: return;
294: end if;
295: close c1;

Line 306: app_exception.raise_exception;

302: else
303: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
304: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW FORM_RECORD_CHANGED : IGSUI10B.PLS');
305: IGS_GE_MSG_STACK.ADD;
306: app_exception.raise_exception;
307: end if;
308: return;
309: end LOCK_ROW;
310:

Line 337: app_exception.raise_exception;

333: end if;
334: else
335: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
336: IGS_GE_MSG_STACK.ADD;
337: app_exception.raise_exception;
338: end if;
339:
340: Before_DML(
341: p_action=>'UPDATE',