DBA Data[Home] [Help]

APPS.IGS_GE_EXCEPTIONS_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:

Line 82: App_Exception.Raise_Exception;

78: IF upper(Column_name) = 'CONSTRAINT' OR column_name is null then
79: IF new_references.constraint<> UPPER(new_references.constraint) then
80: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
85: IF upper(Column_name) = 'OWNER' OR column_name is null then
86: IF new_references.owner <> UPPER(new_references.owner ) then

Line 89: App_Exception.Raise_Exception;

85: IF upper(Column_name) = 'OWNER' OR column_name is null then
86: IF new_references.owner <> UPPER(new_references.owner ) then
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: IF upper(Column_name) = 'TABLE_NAME' OR column_name is null then
93: IF new_references.table_name <> UPPER(new_references.table_name ) then

Line 96: App_Exception.Raise_Exception;

92: IF upper(Column_name) = 'TABLE_NAME' OR column_name is null then
93: IF new_references.table_name <> UPPER(new_references.table_name ) then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99:
100: END Check_Constraints;

Line 166: App_Exception.Raise_Exception;

162: new_references.excpt_id
163: )THEN
164: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF ;
168: Check_Constraints;
169: ELSIF (p_action = 'UPDATE') THEN
170: -- Call all the procedures related to Before Update.

Line 181: App_Exception.Raise_Exception;

177: new_references.excpt_id
178: )THEN
179: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF ;
183: Check_Constraints;
184: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
185: -- Call all the procedures related to Before Update.

Line 249: app_exception.raise_exception;

245: end if;
246: else
247: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
248: IGS_GE_MSG_STACK.ADD;
249: app_exception.raise_exception;
250: end if;
251: Before_DML (
252: p_action => 'INSERT',
253: x_rowid => X_ROWID,

Line 329: app_exception.raise_exception;

325: if (c1%notfound) then
326: close c1;
327: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: return;
331: end if;
332: close c1;
333:

Line 342: app_exception.raise_exception;

338: null;
339: else
340: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: end if;
344: return;
345: end LOCK_ROW;
346:

Line 376: app_exception.raise_exception;

372: end if;
373: else
374: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
375: IGS_GE_MSG_STACK.ADD;
376: app_exception.raise_exception;
377: end if;
378: Before_DML (
379: p_action => 'UPDATE',
380: x_rowid => X_ROWID,