APPS.IGS_AD_TEST_TYPE_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 75: App_Exception.Raise_Exception;

71: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_code,
72: v_message_name) THEN
73: Fnd_Message.Set_Name('IGS', v_message_name);
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: END IF;
77: END IF;
78: END BeforeRowInsertUpdate;
79:

Line 101: App_Exception.Raise_Exception;

97: IF upper(Column_Name) = 'ADMISSION_TEST_TYPE' OR Column_Name IS NULL THEN
98: IF new_references.admission_test_type <> UPPER(new_references.admission_test_type) 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 110: App_Exception.Raise_Exception;

106: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
107: IF new_references.closed_ind NOT IN ('Y','N') THEN
108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:
114: IF upper(Column_Name) = 'SCORE_TYPE' OR Column_Name IS NULL THEN

Line 118: App_Exception.Raise_Exception;

114: IF upper(Column_Name) = 'SCORE_TYPE' OR Column_Name IS NULL THEN
115: IF new_references.score_type NOT IN ('OFFICIAL','OTHER','SELF_REPORT','UNOFFICIAL') THEN
116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:
122:

Line 202: App_Exception.Raise_Exception;

198: BeforeRowInsertUpdate(p_inserting => TRUE);
199: IF Get_PK_For_Validation (new_references.admission_test_type) THEN
200: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: Check_Constraints;
205: ELSIF (p_action = 'UPDATE') THEN
206: -- Call all the procedures related to Before Update.

Line 216: App_Exception.Raise_Exception;

212: ELSIF (p_action = 'VALIDATE_INSERT') THEN
213: IF Get_PK_For_Validation (new_references.admission_test_type) THEN
214: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: Check_Constraints;
219: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
220: Check_Constraints;

Line 268: app_exception.raise_exception;

264: end if;
265: else
266: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
267: IGS_GE_MSG_STACK.ADD;
268: app_exception.raise_exception;
269: end if;
270:
271: Before_DML (
272: p_action => 'INSERT',

Line 349: app_exception.raise_exception;

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

Line 365: app_exception.raise_exception;

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

Line 399: app_exception.raise_exception;

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