DBA Data[Home] [Help]

APPS.IGS_FI_FEE_STR_STAT_PKG dependencies on APP_EXCEPTION

Line 33: App_Exception.Raise_Exception;

29: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
30: Close cur_old_ref_values;
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: IGS_GE_MSG_STACK.ADD;
33: App_Exception.Raise_Exception;
34: Return;
35: END IF;
36: Close cur_old_ref_values;
37: -- Populate New Values.

Line 85: App_Exception.Raise_Exception;

81: column_name is NULL THEN
82: IF new_references.closed_ind <> 'Y' AND new_references.closed_ind <> 'N' 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) = 'S_FEE_STRUCTURE_STATUS' OR

Line 96: App_Exception.Raise_Exception;

92: new_references.s_fee_structure_status <> 'INACTIVE' AND
93: new_references.s_fee_structure_status <> 'PLANNED' 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: END Check_Constraints;
100: PROCEDURE Check_Child_Existance AS

Line 164: App_Exception.Raise_Exception;

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

Line 178: App_Exception.Raise_Exception;

174: -- Call all the procedures related to Before Insert.
175: IF Get_PK_For_Validation ( new_references.fee_structure_status) THEN
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: Check_Constraints;
181: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
182: Check_Constraints;

Line 218: app_exception.raise_exception;

214: end if;
215: else
216: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
217: IGS_GE_MSG_STACK.ADD;
218: app_exception.raise_exception;
219: end if;
220: Before_DML(
221: p_action=>'INSERT',
222: x_rowid=>X_ROWID,

Line 283: app_exception.raise_exception;

279: fetch c1 into tlinfo;
280: if (c1%notfound) then
281: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
282: IGS_GE_MSG_STACK.ADD;
283: app_exception.raise_exception;
284: close c1;
285: return;
286: end if;
287: close c1;

Line 296: app_exception.raise_exception;

292: null;
293: else
294: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
295: IGS_GE_MSG_STACK.ADD;
296: app_exception.raise_exception;
297: end if;
298: return;
299: end LOCK_ROW;
300: procedure UPDATE_ROW (

Line 328: app_exception.raise_exception;

324: end if;
325: else
326: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: Before_DML(
331: p_action=>'UPDATE',
332: x_rowid=>X_ROWID,