[Home] [Help]
104:
105: IF l_dup_found = 'Y' THEN
106: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PLCMNT_SUP_DUP');
107: FND_MESSAGE.SET_TOKEN('PERSON_NAME',P_LAST_NAME || ', ' || P_FIRST_NAME);
108: IGS_GE_MSG_STACK.ADD;
109: APP_EXCEPTION.RAISE_EXCEPTION;
110: END IF;
111: END IF;
112:
229: IF v_phone_update_rec.OBJECT_VERSION_NUMBER <> P_PHONE_OVN THEN
230: -- the record was updated by some other user hence the object version number is not matching.
231: CLOSE cur_c2;
232: FND_MESSAGE.SET_NAME ('FND',' FORM_RECORD_DELETED');
233: IGS_GE_MSG_STACK.ADD;
234: APP_EXCEPTION.RAISE_EXCEPTION;
235: END IF;
236: END IF;
237:
333: IF V_EMAIL_UPDATE_REC.OBJECT_VERSION_NUMBER <> l_EMAIL_OVN THEN
334: -- the record was updated by some other user hence the object version number is not matching.
335: CLOSE cur_c3;
336: FND_MESSAGE.SET_NAME('FND',' FORM_RECORD_DELETED');
337: IGS_GE_MSG_STACK.ADD;
338: APP_EXCEPTION.RAISE_EXCEPTION;
339: END IF;
340: END IF;
341: