DBA Data[Home] [Help]

APPS.IGS_AD_OTHER_INST_PKG dependencies on FND_MESSAGE

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

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

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

118: ,new_references.institution_code
119: ,new_references.person_id
120: ,new_references.new_institution
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;

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

157: -- Igs_Ad_Ps_Appl_Inst_Pkg.Get_PK_For_Validation (
158: new_references.person_id,
159: new_references.admission_appl_number
160: ) THEN
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;

Line 162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));

158: new_references.person_id,
159: new_references.admission_appl_number
160: ) THEN
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166:

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

169: NULL;
170: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
171: new_references.institution_code
172: ) THEN
173: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_GE_INSTITUTION'));
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;

Line 174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_GE_INSTITUTION'));

170: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
171: new_references.institution_code
172: ) THEN
173: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_GE_INSTITUTION'));
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178:

Line 292: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOI_ACAI_FK');

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

Line 329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOI_INST_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_AOI_INST_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;

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

392: -- Call all the procedures related to Before Insert.
393: Null;
394: IF Get_Pk_For_Validation(
395: new_references.other_inst_id) THEN
396: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: IGS_GE_MSG_STACK.ADD;
398: App_Exception.Raise_Exception;
399: END IF;
400: Check_Uniqueness;

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

412: ELSIF (p_action = 'VALIDATE_INSERT') THEN
413: -- Call all the procedures related to Before Insert.
414: IF Get_PK_For_Validation (
415: new_references.other_inst_id) THEN
416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Uniqueness;

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

521: else
522: X_PROGRAM_UPDATE_DATE := SYSDATE;
523: end if;
524: else
525: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
526: IGS_GE_MSG_STACK.ADD;
527: app_exception.raise_exception;
528: end if;
529:

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

600: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
601: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
602: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
603: -- that the ownerof policy function does not have privilege to access.
604: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
605: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: ELSE

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

601: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
602: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
603: -- that the ownerof policy function does not have privilege to access.
604: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
605: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: ELSE
609: RAISE;

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

642: begin
643: open c1;
644: fetch c1 into tlinfo;
645: if (c1%notfound) then
646: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
647: IGS_GE_MSG_STACK.ADD;
648: close c1;
649: app_exception.raise_exception;
650: return;

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

655: AND (tlinfo.INSTITUTION_CODE = X_INSTITUTION_CODE)
656: ) then
657: null;
658: else
659: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
660: IGS_GE_MSG_STACK.ADD;
661: app_exception.raise_exception;
662: end if;
663: return;

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

707: if X_LAST_UPDATE_LOGIN is NULL then
708: X_LAST_UPDATE_LOGIN := -1;
709: end if;
710: else
711: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
712: IGS_GE_MSG_STACK.ADD;
713: app_exception.raise_exception;
714: end if;
715: Before_DML(

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

756: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
757: NEW_INSTITUTION = X_NEW_INSTITUTION
758: where ROWID = X_ROWID;
759: IF (sql%notfound) THEN
760: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
761: igs_ge_msg_stack.add;
762: igs_sc_gen_001.unset_ctx('R');
763: app_exception.raise_exception;
764: END IF;

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

781: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
782: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
783: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
784: -- that the ownerof policy function does not have privilege to access.
785: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
786: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
787: IGS_GE_MSG_STACK.ADD;
788: app_exception.raise_exception;
789: ELSE

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

782: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
783: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
784: -- that the ownerof policy function does not have privilege to access.
785: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
786: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
787: IGS_GE_MSG_STACK.ADD;
788: app_exception.raise_exception;
789: ELSE
790: RAISE;

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

865: END IF;
866: delete from IGS_AD_OTHER_INST
867: where ROWID = X_ROWID;
868: if (sql%notfound) then
869: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
870: igs_ge_msg_stack.add;
871: igs_sc_gen_001.unset_ctx('R');
872: app_exception.raise_exception;
873: end if;

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

889: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
890: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
891: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
892: -- that the ownerof policy function does not have privilege to access.
893: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
894: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
895: IGS_GE_MSG_STACK.ADD;
896: app_exception.raise_exception;
897: ELSE

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

890: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
891: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
892: -- that the ownerof policy function does not have privilege to access.
893: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
894: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
895: IGS_GE_MSG_STACK.ADD;
896: app_exception.raise_exception;
897: ELSE
898: RAISE;