DBA Data[Home] [Help]

APPS.IGS_AD_APPL_NOTES_PKG dependencies on FND_MESSAGE

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

46: Open cur_old_ref_values;
47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;

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

120: ,new_references.note_type_id
121: ,new_references.person_id
122: ,new_references.sequence_number
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;

Line 158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

154: new_references.admission_appl_number,
155: new_references.nominated_course_cd,
156: new_references.sequence_number
157: ) THEN
158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;

Line 159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));

155: new_references.nominated_course_cd,
156: new_references.sequence_number
157: ) THEN
158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163:

Line 172: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

168: new_references.note_type_id ,
169: NULL,
170: 'N'
171: ) THEN
172: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;

Line 173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));

169: NULL,
170: 'N'
171: ) THEN
172: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177:

Line 293: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAN_ACAI_FK');

289: Open cur_rowid;
290: Fetch cur_rowid INTO lv_rowid;
291: IF (cur_rowid%FOUND) THEN
292: Close cur_rowid;
293: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAN_ACAI_FK');
294: App_Exception.Raise_Exception;
295: Return;
296: END IF;
297: Close cur_rowid;

Line 329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAN_ANT_FK');

325: Open cur_rowid;
326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAN_ANT_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;

Line 425: Fnd_Message.Set_name('IGS','IGS_AD_APPL_INST_WITHD');

421:
422:
423: -- applicaiton would have got withdrawn.
424: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(lv_appl_inst_status),'-1') = 'WITHDRAWN' THEN
425: Fnd_Message.Set_name('IGS','IGS_AD_APPL_INST_WITHD');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: -- end apadegal adtd001 igs.m

Line 436: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

432: -- Call all the procedures related to Before Insert.
433: Null;
434: IF Get_Pk_For_Validation(
435: new_references.appl_notes_id) THEN
436: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
437: IGS_GE_MSG_STACK.ADD;
438: App_Exception.Raise_Exception;
439: END IF;
440: Check_Uniqueness;

Line 456: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

452: ELSIF (p_action = 'VALIDATE_INSERT') THEN
453: -- Call all the procedures related to Before Insert.
454: IF Get_PK_For_Validation (
455: new_references.appl_notes_id) THEN
456: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: IGS_GE_MSG_STACK.ADD;
458: App_Exception.Raise_Exception;
459: END IF;
460: Check_Uniqueness;

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

571: else
572: X_PROGRAM_UPDATE_DATE := SYSDATE;
573: end if;
574: else
575: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: end if;
579:

Line 660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

656: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
657: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
658: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
659: -- that the ownerof policy function does not have privilege to access.
660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
661: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
662: IGS_GE_MSG_STACK.ADD;
663: app_exception.raise_exception;
664: ELSE

Line 661: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

657: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
658: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
659: -- that the ownerof policy function does not have privilege to access.
660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
661: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
662: IGS_GE_MSG_STACK.ADD;
663: app_exception.raise_exception;
664: ELSE
665: RAISE;

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

699: begin
700: open c1;
701: fetch c1 into tlinfo;
702: if (c1%notfound) then
703: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
704: IGS_GE_MSG_STACK.ADD;
705: close c1;
706: app_exception.raise_exception;
707: return;

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

715: AND (tlinfo.REF_NOTES_ID = X_REF_NOTES_ID)
716: ) then
717: null;
718: else
719: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
720: IGS_GE_MSG_STACK.ADD;
721: app_exception.raise_exception;
722: end if;
723: return;

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

768: if X_LAST_UPDATE_LOGIN is NULL then
769: X_LAST_UPDATE_LOGIN := -1;
770: end if;
771: else
772: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
773: IGS_GE_MSG_STACK.ADD;
774: app_exception.raise_exception;
775: end if;
776: Before_DML(

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

821: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
822: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
823: where ROWID = X_ROWID;
824: IF (sql%notfound) THEN
825: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
826: igs_ge_msg_stack.add;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.set_ctx('R');
829: END IF;

Line 852: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

848: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
849: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
850: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
851: -- that the ownerof policy function does not have privilege to access.
852: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
853: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
854: IGS_GE_MSG_STACK.ADD;
855: app_exception.raise_exception;
856: ELSE

Line 853: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

849: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
850: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
851: -- that the ownerof policy function does not have privilege to access.
852: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
853: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
854: IGS_GE_MSG_STACK.ADD;
855: app_exception.raise_exception;
856: ELSE
857: RAISE;

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

939: END IF;
940: DELETE FROM IGS_AD_APPL_NOTES
941: WHERE ROWID = X_ROWID;
942: IF (sql%notfound) THEN
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;
945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: END IF;

Line 967: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

963: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
964: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
965: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
966: -- that the ownerof policy function does not have privilege to access.
967: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
968: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
969: IGS_GE_MSG_STACK.ADD;
970: app_exception.raise_exception;
971: ELSE

Line 968: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

964: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
965: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
966: -- that the ownerof policy function does not have privilege to access.
967: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
968: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
969: IGS_GE_MSG_STACK.ADD;
970: app_exception.raise_exception;
971: ELSE
972: RAISE;