DBA Data[Home] [Help]

APPS.IGS_CA_INST_REL_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

34: Fetch cur_old_ref_values INTO old_references;
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;

Line 133: IGS_GE_MSG_STACK.ADD;

129: new_references.sup_ci_sequence_number,
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;

Line 181: IGS_GE_MSG_STACK.ADD;

177: new_references.sup_ci_sequence_number,
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;

Line 242: IGS_GE_MSG_STACK.ADD;

238: IF upper(Column_Name) = 'LOAD_RESEARCH_PERCENTAGE' OR
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

Line 250: IGS_GE_MSG_STACK.ADD;

246: IF upper(Column_Name) = 'SUB_CAL_TYPE' OR
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

Line 258: IGS_GE_MSG_STACK.ADD;

254: IF upper(Column_Name) = 'SUP_CAL_TYPE' OR
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;

Line 277: IGS_GE_MSG_STACK.ADD;

273: new_references.sub_cal_type,
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

Line 291: IGS_GE_MSG_STACK.ADD;

287: new_references.sup_cal_type,
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;

Line 369: IGS_GE_MSG_STACK.ADD;

365: Fetch cur_rowid INTO lv_rowid;
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;

Line 426: IGS_GE_MSG_STACK.ADD;

422: new_references.sub_ci_sequence_number,
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;

Line 450: IGS_GE_MSG_STACK.ADD;

446: new_references.sub_ci_sequence_number,
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

Line 460: IGS_GE_MSG_STACK.ADD;

456: ELSIF (p_action = 'VALIDATE_DELETE') THEN
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;

Line 522: IGS_GE_MSG_STACK.ADD;

518: X_LAST_UPDATE_LOGIN := -1;
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',

Line 597: IGS_GE_MSG_STACK.ADD;

593: fetch c1 into tlinfo;
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;

Line 610: IGS_GE_MSG_STACK.ADD;

606: ) then
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;

Line 644: IGS_GE_MSG_STACK.ADD;

640: X_LAST_UPDATE_LOGIN := -1;
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',