DBA Data[Home] [Help]

APPS.IGS_EN_ENROLMENT_CAT_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: new_references.closed_ind,
79: v_message_name) = FALSE THEN
80: fnd_message.set_name('IGS',v_message_name);
81: IGS_GE_MSG_STACK.ADD;
82: app_exception.raise_exception;
83: END IF;
84: END IF;
85:
86:

Line 108: App_Exception.Raise_Exception;

104: if new_references.closed_ind NOT IN ('Y','N') OR
105: new_references.closed_ind <> upper(new_references.closed_ind) then
106: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: end if;
110: end if;
111:
112: IF upper(column_name) = 'ENROLMENT_CAT' OR

Line 117: App_Exception.Raise_Exception;

113: column_name is null then
114: if new_references.enrolment_cat <> upper(new_references.enrolment_cat) then
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: end if;
119: end if;
120:
121: END check_constraints;

Line 209: App_Exception.Raise_Exception;

205: new_references.enrolment_cat
206: ) then
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: end if;
211: Check_constraints;
212: ELSIF (p_action = 'UPDATE') THEN
213: -- Call all the procedures related to Before Update.

Line 226: App_Exception.Raise_Exception;

222: new_references.enrolment_cat
223: ) then
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: end if;
228: Check_constraints;
229: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
230: Check_constraints;

Line 286: app_exception.raise_exception;

282: end if;
283: else
284: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
285: IGS_GE_MSG_STACK.ADD;
286: app_exception.raise_exception;
287: end if;
288: Before_DML (
289: p_action => 'INSERT',
290: x_rowid => X_ROWID,

Line 354: app_exception.raise_exception;

350: if (c1%notfound) then
351: close c1;
352: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
353: IGS_GE_MSG_STACK.ADD;
354: app_exception.raise_exception;
355: return;
356: end if;
357: close c1;
358:

Line 366: app_exception.raise_exception;

362: null;
363: else
364: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
365: IGS_GE_MSG_STACK.ADD;
366: app_exception.raise_exception;
367: end if;
368: return;
369: end LOCK_ROW;
370:

Line 398: app_exception.raise_exception;

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

Line 503: APP_EXCEPTION.RAISE_EXCEPTION;

499: -- indicator.
500:
501: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
502: igs_ge_msg_stack.add;
503: APP_EXCEPTION.RAISE_EXCEPTION;
504:
505: END beforerowdelete;
506:
507: