DBA Data[Home] [Help]

APPS.IGS_AD_ACAD_INTEREST_PKG dependencies on FND_MESSAGE

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

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

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

110: new_references.admission_appl_number
111: ,new_references.field_of_study
112: ,new_references.person_id
113: ) THEN
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
115: IGS_GE_MSG_STACK.ADD;
116: app_exception.raise_exception;
117: END IF;
118: END Check_Uniqueness ;

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

135: NULL;
136: ELSIF NOT Igs_Ps_Fld_Of_Study_Pkg.Get_PK_For_Validation (
137: new_references.field_of_study
138: ) THEN
139: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIELD_OF_STUDY'));
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;

Line 140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIELD_OF_STUDY'));

136: ELSIF NOT Igs_Ps_Fld_Of_Study_Pkg.Get_PK_For_Validation (
137: new_references.field_of_study
138: ) THEN
139: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIELD_OF_STUDY'));
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144:

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

150: ELSIF NOT Igs_Ad_Appl_Pkg.Get_PK_For_Validation (
151: new_references.person_id,
152: new_references.admission_appl_number
153: ) THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;

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

151: new_references.person_id,
152: new_references.admission_appl_number
153: ) THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159:

Line 265: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_FOS_FK');

261: Open cur_rowid;
262: Fetch cur_rowid INTO lv_rowid;
263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_FOS_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;

Line 305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAIT_ACAI_FK');

301: Open cur_rowid;
302: Fetch cur_rowid INTO lv_rowid;
303: IF (cur_rowid%FOUND) THEN
304: Close cur_rowid;
305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAIT_ACAI_FK');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: Return;
309: END IF;

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

363: -- Call all the procedures related to Before Insert.
364: Null;
365: IF Get_Pk_For_Validation(
366: new_references.acad_interest_id) THEN
367: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: IGS_GE_MSG_STACK.ADD;
369: App_Exception.Raise_Exception;
370: END IF;
371: Check_Uniqueness;

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

383: ELSIF (p_action = 'VALIDATE_INSERT') THEN
384: -- Call all the procedures related to Before Insert.
385: IF Get_PK_For_Validation (
386: new_references.acad_interest_id) THEN
387: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception;
390: END IF;
391: Check_Uniqueness;

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

487: else
488: X_PROGRAM_UPDATE_DATE := SYSDATE;
489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495:

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

562: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
563: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
564: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
565: -- that the ownerof policy function does not have privilege to access.
566: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
567: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
568: IGS_GE_MSG_STACK.ADD;
569: app_exception.raise_exception;
570: ELSE

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

563: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
564: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
565: -- that the ownerof policy function does not have privilege to access.
566: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
567: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
568: IGS_GE_MSG_STACK.ADD;
569: app_exception.raise_exception;
570: ELSE
571: RAISE;

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

600: begin
601: open c1;
602: fetch c1 into tlinfo;
603: if (c1%notfound) then
604: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
605: IGS_GE_MSG_STACK.ADD;
606: close c1;
607: app_exception.raise_exception;
608: return;

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

613: AND (tlinfo.FIELD_OF_STUDY = X_FIELD_OF_STUDY)
614: ) then
615: null;
616: else
617: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621: return;

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

661: if X_LAST_UPDATE_LOGIN is NULL then
662: X_LAST_UPDATE_LOGIN := -1;
663: end if;
664: else
665: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
666: IGS_GE_MSG_STACK.ADD;
667: app_exception.raise_exception;
668: end if;
669: Before_DML(

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

708: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
709: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
710: where ROWID = X_ROWID;
711: IF (sql%notfound) THEN
712: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
713: igs_ge_msg_stack.add;
714: IF (x_mode = 'S') THEN
715: igs_sc_gen_001.set_ctx('R');
716: END IF;

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

735: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
736: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
737: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
738: -- that the ownerof policy function does not have privilege to access.
739: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
740: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
741: IGS_GE_MSG_STACK.ADD;
742: app_exception.raise_exception;
743: ELSE

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

736: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
737: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
738: -- that the ownerof policy function does not have privilege to access.
739: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
740: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
741: IGS_GE_MSG_STACK.ADD;
742: app_exception.raise_exception;
743: ELSE
744: RAISE;

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

815: END IF;
816: DELETE from IGS_AD_ACAD_INTEREST
817: WHERE ROWID = X_ROWID;
818: IF (sql%notfound) THEN
819: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
820: igs_ge_msg_stack.add;
821: IF (x_mode = 'S') THEN
822: igs_sc_gen_001.set_ctx('R');
823: END IF;

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

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

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

842: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
843: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
844: -- that the ownerof policy function does not have privilege to access.
845: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
846: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
847: IGS_GE_MSG_STACK.ADD;
848: app_exception.raise_exception;
849: ELSE
850: RAISE;