DBA Data[Home] [Help]

APPS.IGS_AD_SPL_ADM_CAT_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.person_id
119: ,new_references.sequence_number
120: ,new_references.spl_adm_cat
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 ('FND','FORM_RECORD_DELETED');

152: new_references.admission_appl_number,
153: new_references.nominated_course_cd,
154: new_references.sequence_number
155: ) THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:

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

165: new_references.spl_adm_cat ,
166: 'SPECIAL_ADM_CAT',
167: 'N'
168: ) THEN
169: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173:

Line 289: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACAI_FK');

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

Line 326: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACDC_FK');

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

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

387: -- Call all the procedures related to Before Insert.
388: Null;
389: IF Get_Pk_For_Validation(
390: new_references.spl_adm_cat_id) THEN
391: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;
395: Check_Uniqueness;

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

407: ELSIF (p_action = 'VALIDATE_INSERT') THEN
408: -- Call all the procedures related to Before Insert.
409: IF Get_PK_For_Validation (
410: new_references.spl_adm_cat_id) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Uniqueness;

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

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

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

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

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

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

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

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

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

626: AND (tlinfo.SPL_ADM_CAT = X_SPL_ADM_CAT)
627: ) then
628: null;
629: else
630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
631: IGS_GE_MSG_STACK.ADD;
632: app_exception.raise_exception;
633: end if;
634: return;

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

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

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

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

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

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

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

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

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

816: END IF;
817: delete from IGS_AD_SPL_ADM_CAT
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: IF (x_mode = 'S') THEN
823: igs_sc_gen_001.unset_ctx('R');
824: END IF;

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

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

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

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