119: OPEN C_CUST_REF;
120: FETCH C_CUST_REF INTO l_recinfo;
121: IF (C_CUST_REF%NOTFOUND) THEN
122: CLOSE C_CUST_REF;
123: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
124: APP_EXCEPTION.RAISE_EXCEPTION;
125: END IF;
126: CLOSE C_CUST_REF;
127:
138: OR ((l_recinfo.END_DATE IS NULL) AND (P_END_DATE IS NULL)))
139: THEN
140: NULL;
141: ELSE
142: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
143: APP_EXCEPTION.RAISE_EXCEPTION;
144: END IF;
145: END LOCK_ROW;
146: