DBA Data[Home] [Help]

APPS.IGS_RE_SPRVSR_TYPE_PKG dependencies on FND_MESSAGE

Line 37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

33: Open cur_old_ref_values;
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;

Line 81: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

77:
78: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
79: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind)
80: OR new_references.closed_ind NOT IN ('Y', 'N') then
81: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception ;
84: END IF;
85: END IF;

Line 89: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

85: END IF;
86: IF upper(column_name) = 'PRINCIPAL_SUPERVISOR_IND' OR COLUMN_NAME IS NULL THEN
87: IF new_references.PRINCIPAL_SUPERVISOR_IND <> upper(NEW_REFERENCES.PRINCIPAL_SUPERVISOR_IND) OR
88: new_references.PRINCIPAL_SUPERVISOR_IND NOT IN ('Y', 'N') then
89: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception ;
92: END IF;
93: END IF;

Line 96: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

92: END IF;
93: END IF;
94: IF upper(column_name) = 'RESEARCH_SUPERVISOR_TYPE' OR COLUMN_NAME IS NULL THEN
95: IF new_references.RESEARCH_SUPERVISOR_TYPE <> upper(NEW_REFERENCES.RESEARCH_SUPERVISOR_TYPE) then
96: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception ;
99: END IF;
100: END IF;

Line 174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

170: -- Call all the procedures related to Before Insert.
171: IF Get_PK_For_Validation (
172: new_references.research_supervisor_type
173: ) THEN
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: Check_Constraints;

Line 189: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

185: ELSIF (p_action = 'VALIDATE_INSERT') THEN
186: IF Get_PK_For_Validation (
187: new_references.research_supervisor_type
188: ) THEN
189: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193: Check_Constraints;

Line 229: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

225: if X_LAST_UPDATE_LOGIN is NULL then
226: X_LAST_UPDATE_LOGIN := -1;
227: end if;
228: else
229: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
230: IGS_GE_MSG_STACK.ADD;
231: app_exception.raise_exception;
232: end if;
233:

Line 301: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

297: open c1;
298: fetch c1 into tlinfo;
299: if (c1%notfound) then
300: close c1;
301: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
302: app_exception.raise_exception;
303: return;
304: end if;
305: close c1;

Line 313: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

309: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
310: ) then
311: null;
312: else
313: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
314: app_exception.raise_exception;
315: end if;
316: return;
317: end LOCK_ROW;

Line 345: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

341: if X_LAST_UPDATE_LOGIN is NULL then
342: X_LAST_UPDATE_LOGIN := -1;
343: end if;
344: else
345: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
346: IGS_GE_MSG_STACK.ADD;
347: app_exception.raise_exception;
348: end if;
349: