DBA Data[Home] [Help]

APPS.IGS_PR_STDNT_PR_UNIT_PKG dependencies on FND_MESSAGE

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

33: -- Populate Old Values.
34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: Close cur_old_ref_values;
40: App_Exception.Raise_Exception;
41:

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

76: new_references.person_id,
77: new_references.course_cd,
78: new_references.spo_sequence_number
79: )THEN
80: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;

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

91: ELSE
92: IF NOT IGS_PS_UNIT_PKG.Get_PK_For_Validation (
93: new_references.unit_cd
94: )THEN
95: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98:
99: END IF;

Line 157: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_SPO_FK');

153:
154: Open cur_rowid;
155: Fetch cur_rowid INTO lv_rowid;
156: IF (cur_rowid%FOUND) THEN
157: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_SPO_FK');
158: IGS_GE_MSG_STACK.ADD;
159: Close cur_rowid;
160: App_Exception.Raise_Exception;
161:

Line 184: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_UN_FK');

180:
181: Open cur_rowid;
182: Fetch cur_rowid INTO lv_rowid;
183: IF (cur_rowid%FOUND) THEN
184: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_UN_FK');
185: IGS_GE_MSG_STACK.ADD;
186: Close cur_rowid;
187: App_Exception.Raise_Exception;
188:

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

230: new_references.person_id,
231: new_references.course_cd,
232: new_references.spo_sequence_number,
233: new_references.unit_cd) THEN
234: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: CHECK_CONSTRAINTS;

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

248: new_references.person_id,
249: new_references.course_cd,
250: new_references.spo_sequence_number,
251: new_references.unit_cd) THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: CHECK_CONSTRAINTS;

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

293: if X_LAST_UPDATE_LOGIN is NULL then
294: X_LAST_UPDATE_LOGIN := -1;
295: end if;
296: else
297: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
298: IGS_GE_MSG_STACK.ADD;
299: app_exception.raise_exception;
300: end if;
301: Before_DML (

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

353: close c;
354: EXCEPTION
355: WHEN OTHERS THEN
356: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
357: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
358: fnd_message.set_token ('ERR_CD', SQLCODE);
359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;

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

354: EXCEPTION
355: WHEN OTHERS THEN
356: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
357: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
358: fnd_message.set_token ('ERR_CD', SQLCODE);
359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;
362: ELSE

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

388: begin
389: open c1;
390: fetch c1 into tlinfo;
391: if (c1%notfound) then
392: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: close c1;
395: app_exception.raise_exception;
396:

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

406: (tlinfo.S_UNIT_TYPE = X_S_UNIT_TYPE)
407: ) then
408: null;
409: else
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414: return;

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

440: if X_LAST_UPDATE_LOGIN is NULL then
441: X_LAST_UPDATE_LOGIN := -1;
442: end if;
443: else
444: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
445: IGS_GE_MSG_STACK.ADD;
446: app_exception.raise_exception;
447: end if;
448: Before_DML (

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

468: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
469: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
470: where ROWID = X_ROWID;
471: if (sql%notfound) then
472: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
473: igs_ge_msg_stack.add;
474: igs_sc_gen_001.unset_ctx('R');
475: app_exception.raise_exception;
476: end if;

Line 484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF (SQLCODE = (-28115)) THEN
484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
485: fnd_message.set_token ('ERR_CD', SQLCODE);
486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;

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

481: EXCEPTION
482: WHEN OTHERS THEN
483: IF (SQLCODE = (-28115)) THEN
484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
485: fnd_message.set_token ('ERR_CD', SQLCODE);
486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;
489: ELSE

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

549: END IF;
550: delete from IGS_PR_STDNT_PR_UNIT
551: where ROWID = X_ROWID;
552: if (sql%notfound) then
553: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
554: igs_ge_msg_stack.add;
555: igs_sc_gen_001.unset_ctx('R');
556: app_exception.raise_exception;
557: end if;

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

581: END IF ;
582:
583: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
584: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
585: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception ;
588: END IF;
589:

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

590: END IF ;
591:
592: IF upper(Column_name) = 'S_UNIT_TYPE' OR COLUMN_NAME IS NULL THEN
593: IF new_references.S_UNIT_TYPE<> upper(new_references.S_UNIT_TYPE) then
594: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
595: IGS_GE_MSG_STACK.ADD;
596: App_Exception.Raise_Exception ;
597: END IF;
598:

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

596: App_Exception.Raise_Exception ;
597: END IF;
598:
599: IF new_references.S_UNIT_TYPE not in ('EXCLUDED','REQUIRED') then
600: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception ;
603: END IF;
604:

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

605: END IF ;
606:
607: IF upper(Column_name) = 'UNIT_CD' OR COLUMN_NAME IS NULL THEN
608: IF new_references.UNIT_CD<> upper(new_references.UNIT_CD) then
609: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
610: IGS_GE_MSG_STACK.ADD;
611: App_Exception.Raise_Exception ;
612: END IF;
613: