242: EXCEPTION
243: WHEN NO_DATA_FOUND THEN
244: X_New_Template_Id := -1;
245: WHEN OTHERS THEN
246: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
247: fnd_message.set_token('PROCEDURE',
248: 'RG_DSS_VAR_TEMPLATES.Get_New_Template_Id');
249: RAISE;
250: END Get_New_Template_Id;
243: WHEN NO_DATA_FOUND THEN
244: X_New_Template_Id := -1;
245: WHEN OTHERS THEN
246: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
247: fnd_message.set_token('PROCEDURE',
248: 'RG_DSS_VAR_TEMPLATES.Get_New_Template_Id');
249: RAISE;
250: END Get_New_Template_Id;
251:
261: AND template_id = X_Template_Id
262: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
263:
264: -- name already exists for a different variable: ERROR
265: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
266: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_TEMPLATE', TRUE);
267: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
268: APP_EXCEPTION.raise_exception;
269:
262: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
263:
264: -- name already exists for a different variable: ERROR
265: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
266: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_TEMPLATE', TRUE);
267: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
268: APP_EXCEPTION.raise_exception;
269:
270: EXCEPTION
263:
264: -- name already exists for a different variable: ERROR
265: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
266: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_TEMPLATE', TRUE);
267: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
268: APP_EXCEPTION.raise_exception;
269:
270: EXCEPTION
271: WHEN NO_DATA_FOUND THEN
516: OPEN C;
517: FETCH C INTO Recinfo;
518: if (C%NOTFOUND) then
519: CLOSE C;
520: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
521: APP_EXCEPTION.Raise_Exception;
522: end if;
523: CLOSE C;
524: if (
664: AND (X_Attribute15 IS NULL)))
665: ) then
666: return;
667: else
668: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
669: APP_EXCEPTION.Raise_Exception;
670: end if;
671: END Lock_Row;
672: