APPS.IGS_OR_ORG_NOTE_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

45: Fetch cur_old_ref_values INTO old_references;
46: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
47: Close cur_old_ref_values;
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;
53: Close cur_old_ref_values;

Line 108: IGS_GE_MSG_STACK.ADD;

104: IF Upper(Column_Name) = 'UNIT_FLAG' OR
105: Column_Name IS NULL THEN
106: IF NOT (new_references.unit_flag IN ('Y', 'N')) THEN
107: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:

Line 118: IGS_GE_MSG_STACK.ADD;

114: IF Upper(Column_Name) = 'LOCATION_FLAG' OR
115: Column_Name IS NULL THEN
116: IF NOT (new_references.location_flag IN ('Y', 'N')) THEN
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122:

Line 128: IGS_GE_MSG_STACK.ADD;

124: IF Upper(Column_Name) = 'INST_FLAG' OR
125: Column_Name IS NULL THEN
126: IF NOT (new_references.inst_flag IN ('Y', 'N')) THEN
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:

Line 241: IGS_GE_MSG_STACK.ADD;

237: Null;
238: IF Get_Pk_For_Validation(
239: new_references.org_notes_type) THEN
240: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244: Check_Constraints;
245: ELSIF (p_action = 'UPDATE') THEN

Line 258: IGS_GE_MSG_STACK.ADD;

254: -- Call all the procedures related to Before Insert.
255: IF Get_PK_For_Validation (
256: new_references.org_notes_type) THEN
257: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
262: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 344: IGS_GE_MSG_STACK.ADD;

340: X_LAST_UPDATE_LOGIN := -1;
341: end if;
342: else
343: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: end if;
347: Before_DML(
348: p_action=>'INSERT',

Line 426: IGS_GE_MSG_STACK.ADD;

422: open c1;
423: fetch c1 into tlinfo;
424: if (c1%notfound) then
425: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
426: IGS_GE_MSG_STACK.ADD;
427: close c1;
428: app_exception.raise_exception;
429: return;
430: end if;

Line 448: IGS_GE_MSG_STACK.ADD;

444: ) then
445: null;
446: else
447: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
448: IGS_GE_MSG_STACK.ADD;
449: app_exception.raise_exception;
450: end if;
451: return;
452: end LOCK_ROW;

Line 492: IGS_GE_MSG_STACK.ADD;

488: X_LAST_UPDATE_LOGIN := -1;
489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: Before_DML(
496: p_action=>'UPDATE',