DBA Data[Home] [Help]

APPS.IGS_GR_APRV_STAT_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 129: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

125:
126: IF (p_action = 'INSERT') THEN
127: -- Call all the procedures related to Before Insert.
128: IF Get_PK_For_Validation(new_references.graduand_appr_status ) THEN
129: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
130: IGS_GE_MSG_STACK.ADD;
131: App_Exception.Raise_Exception;
132: END IF;
133: Check_Constraints;

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

141: Check_CHILD_EXISTANCE;
142:
143: ELSIF (p_action = 'VALIDATE_INSERT') THEN
144: IF Get_PK_For_Validation(new_references.graduand_appr_status ) THEN
145: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: Check_Constraints;

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

190: if X_LAST_UPDATE_LOGIN is NULL then
191: X_LAST_UPDATE_LOGIN := -1;
192: end if;
193: else
194: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
195: IGS_GE_MSG_STACK.ADD;
196: app_exception.raise_exception;
197: end if;
198:

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

261: open c1;
262: fetch c1 into tlinfo;
263: if (c1%notfound) then
264: close c1;
265: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
266: app_exception.raise_exception;
267: return;
268: end if;
269: close c1;

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

273: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
274: ) then
275: null;
276: else
277: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
278: app_exception.raise_exception;
279: end if;
280: return;
281: end LOCK_ROW;

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

305: if X_LAST_UPDATE_LOGIN is NULL then
306: X_LAST_UPDATE_LOGIN := -1;
307: end if;
308: else
309: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
310: IGS_GE_MSG_STACK.ADD;
311: app_exception.raise_exception;
312: end if;
313:

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

394: END IF;
395:
396: IF upper(Column_name) = 'S_GRADUAND_APPR_STATUS' or column_name IS NULL Then
397: IF new_references.s_graduand_appr_status NOT IN ('WAITING', 'APPROVED', 'REJECTED') THEN
398: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: END IF;
402: END IF;

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

402: END IF;
403:
404: IF upper(Column_name) = 'CLOSED_IND' or column_name IS NULL THEN
405: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
406: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409: END IF;
410: END IF;

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

410: END IF;
411:
412: IF upper(Column_name) = 'GRADUAND_APPR_STATUS' or column_name IS NULL THEN
413: IF new_references.graduand_appr_status<> upper(new_references.graduand_appr_status) then
414: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: END IF;
418: END IF;