APPS.IGS_AS_EXM_LOC_SPVSR_PKG dependencies on APP_EXCEPTION

Line 37: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 71: APP_EXCEPTION.RAISE_EXCEPTION;

67: IF IGS_AS_VAL_ELS.assp_val_ve_lot(new_references.exam_location_cd,
68: v_message_name) = FALSE THEN
69: FND_MESSAGE.SET_NAME('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: APP_EXCEPTION.RAISE_EXCEPTION;
72: END IF;
73: -- Validate that the exam location is not closed.
74: IF IGS_AS_VAL_ELS.orgp_val_loc_closed(new_references.exam_location_cd,
75: v_message_name) = FALSE THEN

Line 78: APP_EXCEPTION.RAISE_EXCEPTION;

74: IF IGS_AS_VAL_ELS.orgp_val_loc_closed(new_references.exam_location_cd,
75: v_message_name) = FALSE THEN
76: FND_MESSAGE.SET_NAME('IGS',v_message_name);
77: IGS_GE_MSG_STACK.ADD;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79: END IF;
80:
81:
82: END BeforeRowInsert1;

Line 95: APP_EXCEPTION.RAISE_EXCEPTION;

91: new_references.person_id
92: ) THEN
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: APP_EXCEPTION.RAISE_EXCEPTION;
96:
97: END IF;
98:
99: IF (((old_references.exam_location_cd = new_references.exam_location_cd)) OR

Line 108: APP_EXCEPTION.RAISE_EXCEPTION;

104: 'N'
105: ) THEN
106: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
107: IGS_GE_MSG_STACK.ADD;
108: APP_EXCEPTION.RAISE_EXCEPTION;
109:
110: END IF;
111:
112: END Check_Parent_Existance;

Line 162: APP_EXCEPTION.RAISE_EXCEPTION;

158: IF (cur_rowid%FOUND) THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_ESU_FK');
160: IGS_GE_MSG_STACK.ADD;
161: Close cur_rowid;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:
164: Return;
165: END IF;
166: Close cur_rowid;

Line 189: APP_EXCEPTION.RAISE_EXCEPTION;

185: IF (cur_rowid%FOUND) THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_LOC_FK');
187: IGS_GE_MSG_STACK.ADD;
188: Close cur_rowid;
189: APP_EXCEPTION.RAISE_EXCEPTION;
190:
191: Return;
192: END IF;
193: Close cur_rowid;

Line 231: APP_EXCEPTION.RAISE_EXCEPTION;

227: new_references.PERSON_ID,
228: new_references.EXAM_LOCATION_CD) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: Check_Constraints;
234:
235: Check_Parent_Existance;

Line 248: APP_EXCEPTION.RAISE_EXCEPTION;

244: new_references.EXAM_LOCATION_CD
245: ) THEN
246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
247: IGS_GE_MSG_STACK.ADD;
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: END IF;
250:
251: Check_Constraints;
252: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 297: APP_EXCEPTION.RAISE_EXCEPTION;

293: end if;
294: else
295: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
296: IGS_GE_MSG_STACK.ADD;
297: APP_EXCEPTION.RAISE_EXCEPTION;
298: end if;
299:
300: Before_DML(
301: p_action=>'INSERT',

Line 356: APP_EXCEPTION.RAISE_EXCEPTION;

352: fetch c1 into tlinfo;
353: if (c1%notfound) then
354: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
355: IGS_GE_MSG_STACK.ADD;
356: APP_EXCEPTION.RAISE_EXCEPTION;
357: close c1;
358: return;
359: end if;
360: close c1;

Line 396: APP_EXCEPTION.RAISE_EXCEPTION;

392: column_name is null Then
393: IF new_references.EXAM_LOCATION_CD <> UPPER(new_references.EXAM_LOCATION_CD) Then
394: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
395: IGS_GE_MSG_STACK.ADD;
396: APP_EXCEPTION.RAISE_EXCEPTION;
397: END IF;
398: END IF;
399:
400: END Check_Constraints;