DBA Data[Home] [Help]

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

73: END IF;
74:
75: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then
76: IF New_References.Crs_Note_Type <> UPPER(New_References.Crs_Note_Type) 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 86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

82:
83:
84: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
85: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;

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

99: NULL;
100: ELSE
101: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
102: new_references.crs_note_type) THEN
103: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107:

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

112: NULL;
113: ELSE
114: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
115: new_references.reference_number) THEN
116: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120:

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

129: ELSE
130: IF NOT IGS_PS_UNIT_VER_PKG.Get_PK_For_Validation (
131: new_references.unit_cd,
132: new_references.version_number) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137:

Line 190: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_CNT_FK');

186: Open cur_rowid;
187: Fetch cur_rowid INTO lv_rowid;
188: IF (cur_rowid%FOUND) THEN
189: Close cur_rowid;
190: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_CNT_FK');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: Return;
194: END IF;

Line 216: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_NOTE_FK');

212: Open cur_rowid;
213: Fetch cur_rowid INTO lv_rowid;
214: IF (cur_rowid%FOUND) THEN
215: Close cur_rowid;
216: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_NOTE_FK');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;

Line 244: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_UV_FK');

240: Open cur_rowid;
241: Fetch cur_rowid INTO lv_rowid;
242: IF (cur_rowid%FOUND) THEN
243: Close cur_rowid;
244: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_UV_FK');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: Return;
248: END IF;

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

283: -- Call all the procedures related to Before Insert.
284: IF Get_PK_For_Validation (New_References.unit_cd,
285: New_References.version_number,
286: New_References.reference_number) THEN
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: Check_Constraints;

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

298: ELSIF (p_action = 'VALIDATE_INSERT') THEN
299: IF Get_PK_For_Validation (New_References.unit_cd,
300: New_References.version_number,
301: New_References.reference_number) THEN
302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: Check_Constraints;

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

351: if X_LAST_UPDATE_LOGIN is NULL then
352: X_LAST_UPDATE_LOGIN := -1;
353: end if;
354: else
355: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
356: IGS_GE_MSG_STACK.ADD;
357: app_exception.raise_exception;
358: end if;
359:

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

424: open c1;
425: fetch c1 into tlinfo;
426: if (c1%notfound) then
427: close c1;
428: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: return;
432: end if;

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

435: if ( (tlinfo.CRS_NOTE_TYPE = X_CRS_NOTE_TYPE)
436: ) then
437: null;
438: else
439: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: end if;
443: return;

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

468: if X_LAST_UPDATE_LOGIN is NULL then
469: X_LAST_UPDATE_LOGIN := -1;
470: end if;
471: else
472: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
473: IGS_GE_MSG_STACK.ADD;
474: app_exception.raise_exception;
475: end if;
476: Before_DML(