DBA Data[Home] [Help]

APPS.IGS_AD_EDUGOAL_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 122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

118: ,new_references.nominated_course_cd
119: ,new_references.person_id
120: ,new_references.sequence_number
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 156: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

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

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

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

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

166: new_references.edu_goal_id ,
167: 'EDU_GOALS',
168: 'N'
169: ) THEN
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EDUCATION_GOAL'));
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;

Line 171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EDUCATION_GOAL'));

167: 'EDU_GOALS',
168: 'N'
169: ) THEN
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EDUCATION_GOAL'));
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175:

Line 291: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AEG_ACAI_FK');

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

Line 328: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AEG_ACDC_FK');

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

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

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

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

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

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

501: if X_LAST_UPDATE_LOGIN is NULL then
502: X_LAST_UPDATE_LOGIN := -1;
503: end if;
504: else
505: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
506: IGS_GE_MSG_STACK.ADD;
507: app_exception.raise_exception;
508: end if;
509:

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

574: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
575: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
576: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
577: -- that the ownerof policy function does not have privilege to access.
578: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
579: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: ELSE

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

575: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
576: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
577: -- that the ownerof policy function does not have privilege to access.
578: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
579: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: ELSE
583: RAISE;

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

615: begin
616: open c1;
617: fetch c1 into tlinfo;
618: if (c1%notfound) then
619: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
620: IGS_GE_MSG_STACK.ADD;
621: close c1;
622: app_exception.raise_exception;
623: return;

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

630: AND (tlinfo.EDU_GOAL_ID = X_EDU_GOAL_ID)
631: ) then
632: null;
633: else
634: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
635: IGS_GE_MSG_STACK.ADD;
636: app_exception.raise_exception;
637: end if;
638: return;

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

675: if X_LAST_UPDATE_LOGIN is NULL then
676: X_LAST_UPDATE_LOGIN := -1;
677: end if;
678: else
679: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
680: IGS_GE_MSG_STACK.ADD;
681: app_exception.raise_exception;
682: end if;
683: Before_DML(

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

707: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
708: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
709: where ROWID = X_ROWID;
710: if (sql%notfound) then
711: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
712: igs_ge_msg_stack.add;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');
715: END IF;

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

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

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

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

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

819: END IF;
820: DELETE FROM IGS_AD_EDUGOAL
821: WHERE ROWID = X_ROWID;
822: if (sql%notfound) then
823: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
824: igs_ge_msg_stack.add;
825: IF (x_mode = 'S') THEN
826: igs_sc_gen_001.unset_ctx('R');
827: END IF;

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

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

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

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