APPS.IGS_RE_GV_SEO_CLS_CD_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 77: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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

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

81: END IF;
82: IF upper(column_name) = 'RES_FCD_CLASS_IND' OR COLUMN_NAME IS NULL THEN
83: IF new_references.RES_FCD_CLASS_IND <> upper(NEW_REFERENCES.RES_FCD_CLASS_IND) OR
84: new_references.RES_FCD_CLASS_IND NOT IN ('Y', 'N') THEN
85: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception ;
88: END IF;
89: END IF;

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

161: IF Get_PK_For_Validation (
162: new_references.govt_seo_class_cd
163: ) THEN
164:
165: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: Check_Constraints;

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

176: ELSIF (p_action = 'VALIDATE_INSERT') THEN
177: IF Get_PK_For_Validation (
178: new_references.govt_seo_class_cd
179: ) THEN
180: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: Check_Constraints;

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

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

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

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

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

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

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

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