APPS.IGS_PE_RES_DTLS_PKG dependencies on IGS_GE_MSG_STACK

Line 88: IGS_GE_MSG_STACK.ADD;

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;
92: Close cur_old_ref_values;

Line 191: IGS_GE_MSG_STACK.ADD;

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 ;
195:

Line 223: IGS_GE_MSG_STACK.ADD;

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:
227: END Check_Parent_Existance;

Line 348: IGS_GE_MSG_STACK.ADD;

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;
352: Close cur_rowid;

Line 461: IGS_GE_MSG_STACK.ADD;

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;
465: Check_Uniqueness;

Line 481: IGS_GE_MSG_STACK.ADD;

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;
485: Check_Uniqueness;

Line 745: IGS_GE_MSG_STACK.ADD;

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
749: FROM DUAL;

Line 890: igs_ge_msg_stack.add;

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
894: igs_sc_gen_001.unset_ctx('R');

Line 986: IGS_GE_MSG_STACK.ADD;

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;
990: END if;

Line 1069: IGS_GE_MSG_STACK.ADD;

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;
1073: END LOCK_ROW;

Line 1143: IGS_GE_MSG_STACK.ADD;

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(
1147: p_action=>'UPDATE',

Line 1223: igs_ge_msg_stack.add;

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;
1227: IF (x_mode = 'S') THEN

Line 1240: igs_ge_msg_stack.add;

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
1244: igs_sc_gen_001.unset_ctx('R');

Line 1412: igs_ge_msg_stack.add;

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;
1416: IF (x_mode = 'S') THEN