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

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

Line 85: App_Exception.Raise_Exception;

81: IF upper(Column_Name) = 'TAC_LEVEL_OF_COMP' OR Column_Name IS NULL THEN
82: IF new_references.tac_level_of_comp <> UPPER(new_references.tac_level_of_comp) THEN
83: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: END Check_Constraints;
89:

Line 161: App_Exception.Raise_Exception;

157: new_references.tac_level_of_comp
158: ) THEN
159: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;
164: ELSIF (p_action = 'UPDATE') THEN
165: Check_Constraints;

Line 175: App_Exception.Raise_Exception;

171: new_references.tac_level_of_comp
172: ) THEN
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 223: app_exception.raise_exception;

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

Line 292: app_exception.raise_exception;

288: if (c1%notfound) then
289: close c1;
290: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
291: IGS_GE_MSG_STACK.ADD;
292: app_exception.raise_exception;
293: return;
294: end if;
295: close c1;
296:

Line 305: app_exception.raise_exception;

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

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: Before_DML (
340: p_action => 'UPDATE',
341: x_rowid => X_ROWID,