DBA Data[Home] [Help]

APPS.IGS_RE_SEO_CLASS_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 75: Fnd_Message.Set_Name ('IGS', v_message_name);

71: (new_references.govt_seo_class_cd <> old_references.govt_seo_class_cd)) THEN
72: IF IGS_RE_VAL_SEOCC.resp_val_gscc_closed (
73: new_references.govt_seo_class_cd,
74: v_message_name) = FALSE THEN
75: Fnd_Message.Set_Name ('IGS', v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;

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

95: END IF;
96:
97: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
98: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception ;
102: END IF;
103: END IF;

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

102: END IF;
103: END IF;
104: IF upper(column_name) = 'SEO_CLASS_CD' OR COLUMN_NAME IS NULL THEN
105: IF new_references.SEO_CLASS_CD <> upper(NEW_REFERENCES.SEO_CLASS_CD) THEN
106: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception ;
109: END IF;
110: END IF;

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

119: ELSE
120: IF NOT IGS_RE_GV_SEO_CLS_CD_PKG.Get_PK_For_Validation (
121: new_references.govt_seo_class_cd
122: ) THEN
123: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;

Line 184: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SEOCC_GSCC_FK');

180: Open cur_rowid;
181: Fetch cur_rowid INTO lv_rowid;
182: IF (cur_rowid%FOUND) THEN
183: Close cur_rowid;
184: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SEOCC_GSCC_FK');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: Return;
188: END IF;

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

224: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
225: IF Get_PK_For_Validation (
226: new_references.seo_class_cd
227: ) THEN
228: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232: Check_Constraints;

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

243: IF Get_PK_For_Validation (
244: new_references.seo_class_cd
245: ) THEN
246:
247: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: Check_Constraints;

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

283: if X_LAST_UPDATE_LOGIN is NULL then
284: X_LAST_UPDATE_LOGIN := -1;
285: end if;
286: else
287: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
288: IGS_GE_MSG_STACK.ADD;
289: app_exception.raise_exception;
290: end if;
291:

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

355: open c1;
356: fetch c1 into tlinfo;
357: if (c1%notfound) then
358: close c1;
359: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
360: app_exception.raise_exception;
361: return;
362: end if;
363: close c1;

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

367: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
368: ) then
369: null;
370: else
371: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
372: app_exception.raise_exception;
373: end if;
374: return;
375: end LOCK_ROW;

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

399: if X_LAST_UPDATE_LOGIN is NULL then
400: X_LAST_UPDATE_LOGIN := -1;
401: end if;
402: else
403: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
404: IGS_GE_MSG_STACK.ADD;
405: app_exception.raise_exception;
406: end if;
407: