DBA Data[Home] [Help]

APPS.IGS_AD_SPL_TALENTS_PKG dependencies on FND_MESSAGE

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

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

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

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

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

139: new_references.special_talent_type_id ,
140: 'SPECIAL_TALENTS',
141: 'N'
142: ) THEN
143: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_TALENT_TYPE'));
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;

Line 144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_TALENT_TYPE'));

140: 'SPECIAL_TALENTS',
141: 'N'
142: ) THEN
143: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_TALENT_TYPE'));
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148:

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

154: ELSIF NOT Igs_Ad_Appl_Pkg.Get_PK_For_Validation (
155: new_references.person_id,
156: new_references.admission_appl_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_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_APPL'));

155: new_references.person_id,
156: new_references.admission_appl_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_APPL'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163:

Line 269: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASPLT_ACDC_FK');

265: Open cur_rowid;
266: Fetch cur_rowid INTO lv_rowid;
267: IF (cur_rowid%FOUND) THEN
268: Close cur_rowid;
269: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASPLT_ACDC_FK');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: Return;
273: END IF;

Line 308: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASPLT_ACAI_FK');

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

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

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

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

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

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

491: else
492: X_PROGRAM_UPDATE_DATE := SYSDATE;
493: end if;
494: else
495: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
496: IGS_GE_MSG_STACK.ADD;
497: app_exception.raise_exception;
498: end if;
499:

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

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

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

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

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

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

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

616: AND (tlinfo.SPECIAL_TALENT_TYPE_ID = X_SPECIAL_TALENT_TYPE_ID)
617: ) then
618: null;
619: else
620: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
621: IGS_GE_MSG_STACK.ADD;
622: app_exception.raise_exception;
623: end if;
624: return;

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

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

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

711: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
712: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
713: where ROWID = X_ROWID;
714: if (sql%notfound) then
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: end if;

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

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

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

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

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

816: END IF;
817: delete from IGS_AD_SPL_TALENTS
818: where ROWID = X_ROWID;
819: IF (sql%notfound) THEN
820: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
821: igs_ge_msg_stack.add;
822: igs_sc_gen_001.unset_ctx('R');
823: app_exception.raise_exception;
824: END IF;

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

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

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

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