DBA Data[Home] [Help]

APPS.IGS_PS_STAGE_TYPE_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: IF upper(column_name)= 'COURSE_STAGE_TYPE' OR
74: column_name is null THEN
75: IF new_references.course_stage_type <> UPPER(new_references.course_stage_type)
76: 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 87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

83: IF upper(column_name)= 'CLOSED_IND' OR
84: column_name is null THEN
85: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
86: THEN
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;

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

166:
167: IF Get_PK_For_Validation(
168: new_references.course_stage_type
169: ) THEN
170: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;
174: Check_Constraints;

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

181: ELSIF (p_action = 'VALIDATE_INSERT') THEN
182: IF Get_PK_For_Validation(
183: new_references.course_stage_type
184: ) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: Check_Constraints;

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

232: if X_LAST_UPDATE_LOGIN is NULL then
233: X_LAST_UPDATE_LOGIN := -1;
234: end if;
235: else
236: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
237: IGS_GE_MSG_STACK.ADD;
238: app_exception.raise_exception;
239: end if;
240:

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

300: open c1;
301: fetch c1 into tlinfo;
302: if (c1%notfound) then
303: close c1;
304: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
305: IGS_GE_MSG_STACK.ADD;
306: app_exception.raise_exception;
307: return;
308: end if;

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

312: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
313: ) then
314: null;
315: else
316: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: end if;
320: return;

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

344: if X_LAST_UPDATE_LOGIN is NULL then
345: X_LAST_UPDATE_LOGIN := -1;
346: end if;
347: else
348: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
349: IGS_GE_MSG_STACK.ADD;
350: app_exception.raise_exception;
351: end if;
352: