223: OPEN c_get_item_catalog;
224: FETCH c_get_item_catalog INTO recinfo;
225: IF (c_get_item_catalog%NOTFOUND) THEN
226: CLOSE c_get_item_catalog;
227: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
228: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
229: END IF;
230: CLOSE c_get_item_catalog;
231:
311: OR ((recinfo.ATTRIBUTE15 is null) AND (P_Catalog_Group_Rec.ATTRIBUTE15 is null))))
312: THEN
313: NULL;
314: ELSE
315: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
316: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319: FOR tlinfo IN c_get_description_rec LOOP
321: IF (((tlinfo.DESCRIPTION = P_Catalog_Group_Rec.DESCRIPTION)
322: OR ((tlinfo.DESCRIPTION is null) AND (P_Catalog_Group_Rec.DESCRIPTION is null)))) THEN
323: NULL;
324: ELSE
325: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
326: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
327: END IF;
328: END IF;
329: END LOOP;