APPS.IGS_AD_TAC_LVL_OF_QF_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_QUAL' OR Column_Name IS NULL THEN
82: IF new_references.tac_level_of_qual <> UPPER(new_references.tac_level_of_qual) THEN

Line 85: App_Exception.Raise_Exception;

81: IF upper(Column_Name) = 'TAC_LEVEL_OF_QUAL' OR Column_Name IS NULL THEN
82: IF new_references.tac_level_of_qual <> UPPER(new_references.tac_level_of_qual) 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 160: App_Exception.Raise_Exception;

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

Line 174: App_Exception.Raise_Exception;

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

Line 224: app_exception.raise_exception;

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

Line 294: app_exception.raise_exception;

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

Line 306: app_exception.raise_exception;

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

Line 338: app_exception.raise_exception;

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