DBA Data[Home] [Help]

APPS.IGS_AD_APP_INTENT_PKG dependencies on FND_MESSAGE

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

65: Open cur_old_ref_values;
66: Fetch cur_old_ref_values INTO old_references;
67: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
68: Close cur_old_ref_values;
69: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
70: IGS_GE_MSG_STACK.ADD;
71: App_Exception.Raise_Exception;
72: Return;
73: END IF;

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

152: new_references.admission_appl_number
153: ,new_references.intent_type_id
154: ,new_references.person_id
155: ) THEN
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
157: IGS_GE_MSG_STACK.ADD;
158: app_exception.raise_exception;
159: END IF;
160: END Check_Uniqueness ;

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

179: new_references.intent_type_id ,
180: 'INTENT_TYPES' ,
181: 'N'
182: ) THEN
183: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTENT_TYPE'));
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;

Line 184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTENT_TYPE'));

180: 'INTENT_TYPES' ,
181: 'N'
182: ) THEN
183: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTENT_TYPE'));
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188:

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

194: ELSIF NOT Igs_Ad_Appl_Pkg.Get_PK_For_Validation (
195: new_references.person_id,
196: new_references.admission_appl_number
197: ) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;

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

195: new_references.person_id,
196: new_references.admission_appl_number
197: ) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203:

Line 308: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_ACDC_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_AAINT_ACDC_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: Return;
312: END IF;

Line 347: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_ACAI_FK');

343: Open cur_rowid;
344: Fetch cur_rowid INTO lv_rowid;
345: IF (cur_rowid%FOUND) THEN
346: Close cur_rowid;
347: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_ACAI_FK');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: Return;
351: END IF;

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

447: -- Call all the procedures related to Before Insert.
448: Null;
449: IF Get_Pk_For_Validation(
450: new_references.app_intent_id) THEN
451: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454: END IF;
455: Check_Uniqueness;

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

467: ELSIF (p_action = 'VALIDATE_INSERT') THEN
468: -- Call all the procedures related to Before Insert.
469: IF Get_PK_For_Validation (
470: new_references.app_intent_id) THEN
471: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END IF;
475: Check_Uniqueness;

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

592: else
593: X_PROGRAM_UPDATE_DATE := SYSDATE;
594: end if;
595: else
596: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600:

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

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

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

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

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

809: begin
810: open c1;
811: fetch c1 into tlinfo;
812: if (c1%notfound) then
813: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
814: IGS_GE_MSG_STACK.ADD;
815: close c1;
816: app_exception.raise_exception;
817: return;

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

885: AND (X_ATTRIBUTE20 is null)))
886: ) then
887: null;
888: else
889: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
890: IGS_GE_MSG_STACK.ADD;
891: app_exception.raise_exception;
892: end if;
893: return;

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

953: if X_LAST_UPDATE_LOGIN is NULL then
954: X_LAST_UPDATE_LOGIN := -1;
955: end if;
956: else
957: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
958: IGS_GE_MSG_STACK.ADD;
959: app_exception.raise_exception;
960: end if;
961: Before_DML(

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

1042: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
1043: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
1044: where ROWID = X_ROWID;
1045: IF (sql%notfound) THEN
1046: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1047: igs_ge_msg_stack.add;
1048: IF (x_mode = 'S') THEN
1049: igs_sc_gen_001.unset_ctx('R');
1050: END IF;

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

1069: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
1070: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1071: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
1072: -- that the ownerof policy function does not have privilege to access.
1073: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1074: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1075: IGS_GE_MSG_STACK.ADD;
1076: app_exception.raise_exception;
1077: ELSE

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

1070: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1071: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
1072: -- that the ownerof policy function does not have privilege to access.
1073: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1074: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1075: IGS_GE_MSG_STACK.ADD;
1076: app_exception.raise_exception;
1077: ELSE
1078: RAISE;

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

1211: END IF;
1212: delete from IGS_AD_APP_INTENT
1213: where ROWID = X_ROWID;
1214: if (sql%notfound) then
1215: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1216: igs_ge_msg_stack.add;
1217: IF (x_mode = 'S') THEN
1218: igs_sc_gen_001.unset_ctx('R');
1219: END IF;

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

1237: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
1238: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1239: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
1240: -- that the ownerof policy function does not have privilege to access.
1241: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1242: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1243: IGS_GE_MSG_STACK.ADD;
1244: app_exception.raise_exception;
1245: ELSE

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

1238: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1239: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
1240: -- that the ownerof policy function does not have privilege to access.
1241: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1242: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1243: IGS_GE_MSG_STACK.ADD;
1244: app_exception.raise_exception;
1245: ELSE
1246: RAISE;