APPS.IGS_CA_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: 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 84: App_Exception.Raise_Exception;

80: new_references.s_cal_status <> 'ACTIVE' AND
81: new_references.s_cal_status <> 'PLANNED' THEN
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87: --IF upper(Column_Name) = 'CAL_STATUS' OR
88: --column_name is NULL THEN

Line 92: --App_Exception.Raise_Exception;

88: --column_name is NULL THEN
89: --IF new_references.cal_status <> UPPER(new_references.cal_status) THEN
90: --Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: --IGS_GE_MSG_STACK.ADD;
92: --App_Exception.Raise_Exception;
93: --END IF;
94: --END IF;
95: IF upper(Column_Name) = 'CLOSED_IND' OR
96: column_name is NULL THEN

Line 101: App_Exception.Raise_Exception;

97: IF new_references.closed_ind <> 'Y' AND
98: new_references.closed_ind <> '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: END Check_Constraints;
105:

Line 118: App_Exception.Raise_Exception;

114: new_references.cal_status
115: ) THEN
116: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END Check_Parent_Existance;
121:
122:

Line 179: App_Exception.Raise_Exception;

175: IF (cur_rowid%FOUND) THEN
176: fnd_message.set_name('IGS','IGS_CA_STAT_LKUPV_FK');
177: IGS_GE_MSG_STACK.ADD;
178: Close cur_rowid;
179: App_Exception.Raise_Exception;
180: Return;
181: END IF;
182: Close cur_rowid;
183: END GET_FK_IGS_LOOKUPS_VIEW;

Line 223: App_Exception.Raise_Exception;

219: IF Get_PK_For_Validation ( new_references.cal_status)
220: THEN
221: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;
224: END IF;
225: Check_Constraints;
226: ELSIF (p_action = 'UPDATE') THEN
227: -- Call all the procedures related to Before Update.

Line 238: App_Exception.Raise_Exception;

234: IF Get_PK_For_Validation ( new_references.cal_status)
235: THEN
236: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: END IF;
240: Check_Constraints;
241: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
242: Check_Constraints;

Line 279: app_exception.raise_exception;

275: end if;
276: else
277: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
278: IGS_GE_MSG_STACK.ADD;
279: app_exception.raise_exception;
280: end if;
281: Before_DML (
282: p_action =>'INSERT',
283: x_rowid =>X_ROWID,

Line 348: app_exception.raise_exception;

344: if (c1%notfound) then
345: close c1;
346: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
347: IGS_GE_MSG_STACK.ADD;
348: app_exception.raise_exception;
349: return;
350: end if;
351: close c1;
352:

Line 361: app_exception.raise_exception;

357: null;
358: else
359: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
360: IGS_GE_MSG_STACK.ADD;
361: app_exception.raise_exception;
362: end if;
363: return;
364: end LOCK_ROW;
365:

Line 394: app_exception.raise_exception;

390: end if;
391: else
392: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
393: IGS_GE_MSG_STACK.ADD;
394: app_exception.raise_exception;
395: end if;
396: Before_DML (
397: p_action =>'UPDATE',
398: x_rowid =>X_ROWID,