APPS.IGS_AD_AUSE_ED_OT_SC_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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

Line 191: IGS_GE_MSG_STACK.ADD;

187:
188:
189:
190: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
191: IGS_GE_MSG_STACK.ADD;
192:
193:
194:
195:

Line 233: IGS_GE_MSG_STACK.ADD;

229:
230:
231:
232: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
233: IGS_GE_MSG_STACK.ADD;
234:
235:
236:
237:

Line 276: IGS_GE_MSG_STACK.ADD;

272:
273:
274:
275: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
276: IGS_GE_MSG_STACK.ADD;
277:
278:
279:
280:

Line 333: IGS_GE_MSG_STACK.ADD;

329: new_references.person_id,
330: new_references.ase_sequence_number
331: ) THEN
332: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END IF;
336: END IF;
337:

Line 433: IGS_GE_MSG_STACK.ADD;

429: Fetch cur_rowid INTO lv_rowid;
430: IF (cur_rowid%FOUND) THEN
431: Close cur_rowid;
432: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASEOS_ASE_FK');
433: IGS_GE_MSG_STACK.ADD;
434: App_Exception.Raise_Exception;
435: Return;
436: END IF;
437: Close cur_rowid;

Line 479: IGS_GE_MSG_STACK.ADD;

475: new_references.result_obtained_yr,
476: new_references.score_type
477: ) THEN
478: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
479: IGS_GE_MSG_STACK.ADD;
480: App_Exception.Raise_Exception;
481: END IF;
482: Check_Constraints;
483: Check_Parent_Existance;

Line 495: IGS_GE_MSG_STACK.ADD;

491: new_references.result_obtained_yr,
492: new_references.score_type
493: ) THEN
494: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
495: IGS_GE_MSG_STACK.ADD;
496: App_Exception.Raise_Exception;
497: END IF;
498: Check_Constraints;
499: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 547: IGS_GE_MSG_STACK.ADD;

543: X_LAST_UPDATE_LOGIN := -1;
544: end if;
545: else
546: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
547: IGS_GE_MSG_STACK.ADD;
548: app_exception.raise_exception;
549: end if;
550: Before_DML(
551: p_action=>'INSERT',

Line 623: IGS_GE_MSG_STACK.ADD;

619: open c1;
620: fetch c1 into tlinfo;
621: if (c1%notfound) then
622: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
623: IGS_GE_MSG_STACK.ADD;
624: app_exception.raise_exception;
625: close c1;
626: return;
627: end if;

Line 635: IGS_GE_MSG_STACK.ADD;

631: ) then
632: null;
633: else
634: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
635: IGS_GE_MSG_STACK.ADD;
636: app_exception.raise_exception;
637: end if;
638: return;
639: end LOCK_ROW;

Line 669: IGS_GE_MSG_STACK.ADD;

665: X_LAST_UPDATE_LOGIN := -1;
666: end if;
667: else
668: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
669: IGS_GE_MSG_STACK.ADD;
670: app_exception.raise_exception;
671: end if;
672:
673: Before_DML(