DBA Data[Home] [Help]

APPS.IGS_PE_RES_DTLS_PKG dependencies on FND_MESSAGE

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

83: Open cur_old_ref_values;
84: Fetch cur_old_ref_values INTO old_references;
85: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
86: Close cur_old_ref_values;
87: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: Return;
91: END IF;

Line 190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

186: new_references.person_id,
187: new_references.cal_type,
188: new_references.sequence_number
189: ) THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: END IF;
194: END Check_Uniqueness ;

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

218: NULL;
219: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
220: new_references.person_id
221: ) THEN
222: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226:

Line 347: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PRD_PP_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_PE_PRD_PP_FK');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: Return;
351: END IF;

Line 460: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

456: -- Call all the PROCEDUREs related to Before Insert.
457: Null;
458: IF Get_Pk_For_Validation(
459: new_references.resident_details_id) THEN
460: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464: Check_Constraints;

Line 480: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

476: ELSIF (p_action = 'VALIDATE_INSERT') THEN
477: -- Call all the PROCEDUREs related to Before Insert.
478: IF Get_PK_For_Validation (
479: new_references.resident_details_id) THEN
480: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
481: IGS_GE_MSG_STACK.ADD;
482: App_Exception.Raise_Exception;
483: END IF;
484: Check_Constraints;

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

740: if X_LAST_UPDATE_LOGIN is NULL then
741: X_LAST_UPDATE_LOGIN := -1;
742: END if;
743: else
744: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
745: IGS_GE_MSG_STACK.ADD;
746: app_exception.raise_exception;
747: END if;
748: SELECT IGS_PE_RES_DTLS_S.NEXTVAL INTO X_RESIDENT_DETAILS_ID

Line 888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
889: fnd_message.set_token ('ERR_CD', SQLCODE);
890: igs_ge_msg_stack.add;
891: igs_sc_gen_001.unset_ctx('R');
892: app_exception.raise_exception;

Line 889: fnd_message.set_token ('ERR_CD', SQLCODE);

885: EXCEPTION
886: WHEN OTHERS THEN
887: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
889: fnd_message.set_token ('ERR_CD', SQLCODE);
890: igs_ge_msg_stack.add;
891: igs_sc_gen_001.unset_ctx('R');
892: app_exception.raise_exception;
893: ELSE

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

981: begin
982: open c1;
983: fetch c1 into tlinfo;
984: if (c1%notfound) then
985: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
986: IGS_GE_MSG_STACK.ADD;
987: close c1;
988: app_exception.raise_exception;
989: return;

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

1064: AND (X_ATTRIBUTE20 is null)))
1065: ) then
1066: null;
1067: else
1068: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1069: IGS_GE_MSG_STACK.ADD;
1070: app_exception.raise_exception;
1071: END if;
1072: return;

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

1138: if X_LAST_UPDATE_LOGIN is NULL then
1139: X_LAST_UPDATE_LOGIN := -1;
1140: END if;
1141: else
1142: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1143: IGS_GE_MSG_STACK.ADD;
1144: app_exception.raise_exception;
1145: END if;
1146: Before_DML(

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

1218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1219: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1220: where ROWID = X_ROWID;
1221: if (sql%notfound) then
1222: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1223: igs_ge_msg_stack.add;
1224: igs_sc_gen_001.unset_ctx('R');
1225: app_exception.raise_exception;
1226: END if;

Line 1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1234: );
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: IF (SQLCODE = (-28115)) THEN
1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;

Line 1239: fnd_message.set_token ('ERR_CD', SQLCODE);

1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: IF (SQLCODE = (-28115)) THEN
1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE

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

1407: END IF;
1408: delete from igs_pe_res_dtls_all
1409: where ROWID = X_ROWID;
1410: if (sql%notfound) then
1411: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1412: igs_ge_msg_stack.add;
1413: igs_sc_gen_001.unset_ctx('R');
1414: app_exception.raise_exception;
1415: END if;