APPS.IGS_EN_UNIT_SET_STAT_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 85: App_Exception.Raise_Exception;

81: IF ((UPPER (column_name) = 'S_UNIT_SET_STATUS') OR (column_name IS NULL)) THEN
82: IF new_references.s_unit_set_status NOT IN ( 'ACTIVE' , 'INACTIVE' , 'PLANNED' ) 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:
89: IF ((UPPER (column_name) = 'UNIT_SET_STATUS') OR (column_name IS NULL)) THEN

Line 93: App_Exception.Raise_Exception;

89: IF ((UPPER (column_name) = 'UNIT_SET_STATUS') OR (column_name IS NULL)) THEN
90: IF (new_references.unit_set_status <> UPPER (new_references.unit_set_status)) THEN
91: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
96:
97: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN

Line 101: App_Exception.Raise_Exception;

97: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
98: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) THEN
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105:

Line 180: App_Exception.Raise_Exception;

176: new_references.unit_set_status
177: ) THEN
178: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181:
182: END IF;
183: Check_Constraints;
184:

Line 198: App_Exception.Raise_Exception;

194: new_references.unit_set_status
195: ) THEN
196: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: Check_Constraints;
201: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
202: Check_Constraints;

Line 261: app_exception.raise_exception;

257: end if;
258: else
259: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
260: IGS_GE_MSG_STACK.ADD;
261: app_exception.raise_exception;
262: end if;
263:
264: Before_DML(
265: p_action => 'INSERT' ,

Line 338: app_exception.raise_exception;

334: if (c1%notfound) then
335: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
336: IGS_GE_MSG_STACK.ADD;
337: close c1;
338: app_exception.raise_exception;
339: return;
340: end if;
341: close c1;
342:

Line 351: app_exception.raise_exception;

347: null;
348: else
349: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
350: IGS_GE_MSG_STACK.ADD;
351: app_exception.raise_exception;
352: end if;
353: return;
354: end LOCK_ROW;
355:

Line 384: app_exception.raise_exception;

380: end if;
381: else
382: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
383: IGS_GE_MSG_STACK.ADD;
384: app_exception.raise_exception;
385: end if;
386:
387: Before_DML(
388: p_action => 'UPDATE' ,