42: AND ((X_row_id is NULL) OR (rowid <> X_row_id))
43: );
44: EXCEPTION
45: WHEN NO_DATA_FOUND THEN
46: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
47: app_exception.raise_exception;
48:
49: END Check_Unique;
50:
70: OR (bbom.assembly_type = 2)))
71: AND ROWNUM=1; /* Bug 6134795 To insert a value 1 into counter
72: if one or more common bills exist if substitute component
73: does not exist in Other organizations */
74: fnd_message.set_name('INV','INV_NOT_VALID');
75: fnd_message.set_token('ENTITY','Substitute item', TRUE);
76: app_exception.raise_exception;
77:
78: EXCEPTION
71: AND ROWNUM=1; /* Bug 6134795 To insert a value 1 into counter
72: if one or more common bills exist if substitute component
73: does not exist in Other organizations */
74: fnd_message.set_name('INV','INV_NOT_VALID');
75: fnd_message.set_token('ENTITY','Substitute item', TRUE);
76: app_exception.raise_exception;
77:
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
238: OPEN C;
239: FETCH C INTO Recinfo;
240: if (C%NOTFOUND) then
241: CLOSE C;
242: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
243: APP_EXCEPTION.Raise_Exception;
244: end if;
245: CLOSE C;
246: if (
306: AND (X_Attribute15 IS NULL)))
307: ) then
308: return;
309: else
310: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
311: APP_EXCEPTION.Raise_Exception;
312: end if;
313: END Lock_Row;
314: