217: FETCH C INTO tlinfo;
218:
219: IF (C%NOTFOUND) then
220: CLOSE C;
221: fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');
222: app_exception.raise_exception;
223: END IF;
224: CLOSE C;
225:
276: )
277: THEN
278: RETURN;
279: ELSE
280: fnd_message.Set_Name('FND', 'FORM_RECORD_CHANGED');
281: app_exception.raise_exception;
282: END IF;
283:
284: END Lock_row;
364: FETCH C INTO oldrow;
365:
366: IF (C%NOTFOUND) then
367: CLOSE C;
368: fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');
369: app_exception.raise_exception;
370: END IF;
371: CLOSE C;
372:
373: -- Update only allowed for start date/end date change
374: -- IF oldrow.salesrep_id <> x_salesrep_id OR
375: -- oldrow.pmt_plan_id <> x_pmt_plan_id OR
376: -- oldrow.credit_type_id <> x_credit_type_id THEN
377: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_UPD_NA');
378: -- app_exception.raise_exception;
379: -- END IF;
380:
381: SELECT