DBA Data[Home] [Help]

APPS.IGS_AD_TAC_LVL_OF_QF_PKG dependencies on FND_MESSAGE

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

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

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

72: END IF;
73:
74: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
75: IF new_references.closed_ind NOT IN ('Y','N') THEN
76: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;

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

79: END IF;
80: END IF;
81: IF upper(Column_Name) = 'TAC_LEVEL_OF_QUAL' OR Column_Name IS NULL THEN
82: IF new_references.tac_level_of_qual <> UPPER(new_references.tac_level_of_qual) THEN
83: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;

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

154: IF (p_action = 'INSERT') THEN
155: IF Get_PK_For_Validation (
156: new_references.tac_level_of_qual
157: ) THEN
158: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: Check_Constraints;

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

168: ELSIF (p_action = 'VALIDATE_INSERT') THEN
169: IF Get_PK_For_Validation (
170: new_references.tac_level_of_qual
171: ) THEN
172: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: Check_Constraints;

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

218: if X_LAST_UPDATE_LOGIN is NULL then
219: X_LAST_UPDATE_LOGIN := -1;
220: end if;
221: else
222: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
223: IGS_GE_MSG_STACK.ADD;
224: app_exception.raise_exception;
225: end if;
226:

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

288: open c1;
289: fetch c1 into tlinfo;
290: if (c1%notfound) then
291: close c1;
292: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
293: IGS_GE_MSG_STACK.ADD;
294: app_exception.raise_exception;
295: return;
296: end if;

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

300: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
301: ) then
302: null;
303: else
304: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
305: IGS_GE_MSG_STACK.ADD;
306: app_exception.raise_exception;
307: end if;
308: return;

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

332: if X_LAST_UPDATE_LOGIN is NULL then
333: X_LAST_UPDATE_LOGIN := -1;
334: end if;
335: else
336: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: end if;
340: