DBA Data[Home] [Help]

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

78: IF upper(column_name)= 'COURSE_STATUS' OR
79: column_name is null THEN
80: IF new_references.course_status <> UPPER(new_references.course_status)
81: THEN
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;

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

88: IF upper(column_name)= 'CLOSED_IND' OR
89: column_name is null THEN
90: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
91: THEN
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;

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

98: IF upper(column_name)= 'S_COURSE_STATUS' OR
99: column_name is null THEN
100: IF new_references.s_course_status NOT IN ( 'ACTIVE' , 'INACTIVE','PLANNED' )
101: THEN
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;

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

174: -- Call all the procedures related to Before Insert.
175: IF Get_PK_For_Validation(
176: new_references.course_status
177: ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: Check_Constraints;

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

190: ELSIF (p_action = 'VALIDATE_INSERT') THEN
191: IF Get_PK_For_Validation(
192: new_references.course_status
193: ) THEN
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: Check_Constraints;

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

241: if X_LAST_UPDATE_LOGIN is NULL then
242: X_LAST_UPDATE_LOGIN := -1;
243: end if;
244: else
245: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
246: IGS_GE_MSG_STACK.ADD;
247: app_exception.raise_exception;
248: end if;
249: Before_DML( p_action => 'INSERT',

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

312: open c1;
313: fetch c1 into tlinfo;
314: if (c1%notfound) then
315: close c1;
316: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: return;
320: end if;

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

325: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
326: ) then
327: null;
328: else
329: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
330: IGS_GE_MSG_STACK.ADD;
331: app_exception.raise_exception;
332: end if;
333: return;

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

358: if X_LAST_UPDATE_LOGIN is NULL then
359: X_LAST_UPDATE_LOGIN := -1;
360: end if;
361: else
362: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: end if;
366: Before_DML( p_action => 'UPDATE',