DBA Data[Home] [Help]

APPS.IGS_PR_STDNT_PR_PS_PKG dependencies on FND_MESSAGE

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

32: -- Populate Old Values.
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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: Close cur_old_ref_values;
39: App_Exception.Raise_Exception;
40:

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

68: ELSE
69: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
70: new_references.course_cd
71: )THEN
72: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75:
76: END IF;

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

89: new_references.person_id,
90: new_references.spo_course_cd,
91: new_references.spo_sequence_number
92: )THEN
93: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96:
97: END IF;

Line 150: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_CRS_FK');

146: BEGIN
147: Open cur_rowid;
148: Fetch cur_rowid INTO lv_rowid;
149: IF (cur_rowid%FOUND) THEN
150: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_CRS_FK');
151: IGS_GE_MSG_STACK.ADD;
152: Close cur_rowid;
153: App_Exception.Raise_Exception;
154:

Line 180: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_SPO_FK');

176:
177: Open cur_rowid;
178: Fetch cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_SPO_FK');
181: IGS_GE_MSG_STACK.ADD;
182: Close cur_rowid;
183: App_Exception.Raise_Exception;
184:

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

224: new_references.person_id,
225: new_references.spo_course_cd,
226: new_references.spo_sequence_number,
227: new_references.course_cd)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 244: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

240: new_references.person_id,
241: new_references.spo_course_cd,
242: new_references.spo_sequence_number,
243: new_references.course_cd)THEN
244: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END IF;
248: CHECK_CONSTRAINTS;

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

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

Line 344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

340: close c;
341: EXCEPTION
342: WHEN OTHERS THEN
343: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
345: fnd_message.set_token ('ERR_CD', SQLCODE);
346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;

Line 345: fnd_message.set_token ('ERR_CD', SQLCODE);

341: EXCEPTION
342: WHEN OTHERS THEN
343: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
345: fnd_message.set_token ('ERR_CD', SQLCODE);
346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;
349: ELSE

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

373: begin
374: open c1;
375: fetch c1 into tlinfo;
376: if (c1%notfound) then
377: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
378: IGS_GE_MSG_STACK.ADD;
379: close c1;
380: app_exception.raise_exception;
381:

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

392: )
393: then
394: null;
395: else
396: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
397: IGS_GE_MSG_STACK.ADD;
398: app_exception.raise_exception;
399: end if;
400: return;

Line 422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

418: END IF;
419: delete from IGS_PR_STDNT_PR_PS
420: where ROWID = X_ROWID;
421: if (sql%notfound) then
422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: end if;

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

447: END IF ;
448:
449: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
450: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
451: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception ;
454: END IF;
455: END IF ;

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

455: END IF ;
456:
457: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
458: IF new_references.SPO_COURSE_CD<> upper(new_references.SPO_COURSE_CD) then
459: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception ;
462: END IF;
463: END IF;

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

462: END IF;
463: END IF;
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
466: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception ;
469: END IF;
470: