DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_CAT_PKG dependencies on FND_MESSAGE

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

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

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

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

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

80: END IF;
81:
82: IF Upper(Column_Name)='UNIT_CAT' OR Column_Name IS NULL Then
83: IF new_references.Unit_Cat <> UPPER(New_References.Unit_Cat ) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;

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

155:
156: IF (p_action = 'INSERT') THEN
157: -- Call all the procedures related to Before Insert.
158: IF Get_PK_For_Validation (New_References.unit_cat) THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;

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

168: -- Call all the procedures related to Before Delete.
169: Check_Child_Existance;
170: ELSIF (p_action = 'VALIDATE_INSERT') THEN
171: IF Get_PK_For_Validation (New_References.unit_cat) 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 224: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

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

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

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

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

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

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

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