48: OPEN chk_duplicates;
49: FETCH chk_duplicates INTO dummy;
50:
51: IF chk_duplicates%FOUND THEN
52: FND_MESSAGE.Set_Name('CE', 'CE_DUPLICATE_FORECAST_HDR');
53: APP_EXCEPTION.Raise_exception;
54: END IF;
55: CLOSE chk_duplicates;
56: EXCEPTION
56: EXCEPTION
57: WHEN APP_EXCEPTIONS.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEn
60: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
61: FND_MESSAGE.Set_Token('PROCEDURE', 'ce_cf_headers_pkg.check_unique');
62: RAISE;
63: END check_unique;
64:
57: WHEN APP_EXCEPTIONS.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEn
60: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
61: FND_MESSAGE.Set_Token('PROCEDURE', 'ce_cf_headers_pkg.check_unique');
62: RAISE;
63: END check_unique;
64:
65: --
280: OPEN C;
281: FETCH C INTO recinfo;
282: if (C%NOTFOUND) then
283: CLOSE C;
284: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
285: APP_EXCEPTION.Raise_Exception;
286: end if;
287: CLOSE C;
288: if (
357: AND (X_attribute15 IS NULL)))
358: ) then
359: return;
360: else
361: FND_MESSAGE.Set_name('FND', 'FORM_RECORD_CHANGED');
362: APP_EXCEPTION.Raise_Exception;
363: end if;
364: END Lock_Row;
365: