DBA Data[Home] [Help]

APPS.IGS_CA_INST_REL_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 134: APP_EXCEPTION.RAISE_EXCEPTION;

130: new_references.sub_cal_type,
131: new_references.sub_ci_sequence_number) LOOP
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_FCI_LCI_ONE_REL');
133: IGS_GE_MSG_STACK.ADD;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135: END LOOP;
136: END IF;
137: END LOOP;
138: END IF;

Line 182: APP_EXCEPTION.RAISE_EXCEPTION;

178: v_message_name) = FALSE
179: THEN
180: Fnd_Message.Set_Name('IGS',v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: APP_EXCEPTION.RAISE_EXCEPTION;
183: END IF;
184: END IF;
185: END AfterStmtInsert2;
186:

Line 243: App_Exception.Raise_Exception;

239: column_name is NULL THEN
240: IF new_references.load_research_percentage < 000.01 OR new_references.load_research_percentage > 100.00 THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246: IF upper(Column_Name) = 'SUB_CAL_TYPE' OR
247: column_name is NULL THEN

Line 251: App_Exception.Raise_Exception;

247: column_name is NULL THEN
248: IF new_references.sub_cal_type <> UPPER(new_references.sub_cal_type) THEN
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254: IF upper(Column_Name) = 'SUP_CAL_TYPE' OR
255: column_name is NULL THEN

Line 259: App_Exception.Raise_Exception;

255: column_name is NULL THEN
256: IF new_references.sup_cal_type <> UPPER(new_references.sup_cal_type) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
262: END Check_Constraints;
263:

Line 278: App_Exception.Raise_Exception;

274: new_references.sub_ci_sequence_number
275: ) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280:
281: IF (((old_references.sup_cal_type = new_references.sup_cal_type) AND
282: (old_references.sup_ci_sequence_number = new_references.sup_ci_sequence_number)) OR

Line 292: App_Exception.Raise_Exception;

288: new_references.sup_ci_sequence_number
289: ) THEN
290: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294:
295: END Check_Parent_Existance;
296:

Line 370: App_Exception.Raise_Exception;

366: IF (cur_rowid%FOUND) THEN
367: Close cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_CA_CIR_CI_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: Return;
372: END IF;
373: Close cur_rowid;
374:

Line 427: App_Exception.Raise_Exception;

423: new_references.sup_cal_type,
424: new_references.sup_ci_sequence_number ) THEN
425: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: BeforeRowInsertUpdateDelete(p_inserting => TRUE);
430: Check_Constraints;
431: Check_Parent_Existance;

Line 451: App_Exception.Raise_Exception;

447: new_references.sup_cal_type,
448: new_references.sup_ci_sequence_number ) THEN
449: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453: Check_Constraints;
454: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
455: Check_Constraints;

Line 461: App_Exception.Raise_Exception;

457: -- Stop delete if SUP-CAL = Academic and SUB-CAL = Admission and both calendars have active status.
458: IF Check_acad_adm_cal_rel (p_rowid => x_rowid) THEN
459: Fnd_Message.Set_Name ('IGS', 'IGS_CA_REL_DEL_NOT');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception;
462: END IF;
463: BeforeRowInsertUpdateDelete(p_deleting => TRUE);
464: Check_Child_Existance;
465: END IF;

Line 523: app_exception.raise_exception;

519: end if;
520: else
521: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
522: IGS_GE_MSG_STACK.ADD;
523: app_exception.raise_exception;
524: end if;
525: Before_DML (
526: p_action =>'INSERT',
527: x_rowid =>X_ROWID,

Line 598: app_exception.raise_exception;

594: if (c1%notfound) then
595: close c1;
596: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: return;
600: end if;
601: close c1;
602:

Line 611: app_exception.raise_exception;

607: null;
608: else
609: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
610: IGS_GE_MSG_STACK.ADD;
611: app_exception.raise_exception;
612: end if;
613: return;
614: end LOCK_ROW;
615:

Line 645: app_exception.raise_exception;

641: end if;
642: else
643: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
644: IGS_GE_MSG_STACK.ADD;
645: app_exception.raise_exception;
646: end if;
647: Before_DML (
648: p_action =>'UPDATE',
649: x_rowid =>X_ROWID,