APPS.RG_DSS_HIERARCHIES_PKG dependencies on APP_EXCEPTION

Line 49: APP_EXCEPTION.raise_exception;

45:
46: -- name already exists for a different hierarchy: ERROR
47: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS');
48: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
49: APP_EXCEPTION.raise_exception;
50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: -- name doesn't exist, so do nothing

Line 88: WHEN app_exceptions.application_exception THEN

84:
85: RETURN(NumRecords);
86:
87: EXCEPTION
88: WHEN app_exceptions.application_exception THEN
89: RAISE;
90: WHEN OTHERS THEN
91: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
92: RAISE;

Line 120: APP_EXCEPTION.raise_exception;

116: dummy NUMBER;
117: BEGIN
118: IF (used_in_frozen_system(X_Hierarchy_Id)) THEN
119: FND_MESSAGE.set_name('RG','RG_DSS_REF_HIERARCHY');
120: APP_EXCEPTION.raise_exception;
121: END IF;
122: END check_references;
123:
124:

Line 177: APP_EXCEPTION.raise_exception;

173:
174: IF (num_detail_rows <> num_segments) THEN
175: /* Every segment must have a detail hierarchy row */
176: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');
177: APP_EXCEPTION.raise_exception;
178: END IF;
179:
180: INSERT INTO rg_dss_hierarchies(
181: hierarchy_id,

Line 288: APP_EXCEPTION.RAISE_EXCEPTION;

284: FETCH C INTO Recinfo;
285: IF (C%NOTFOUND) THEN
286: CLOSE C;
287: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
288: APP_EXCEPTION.RAISE_EXCEPTION;
289: END IF;
290: CLOSE C;
291:
292: IF (

Line 363: APP_EXCEPTION.RAISE_EXCEPTION;

359: ) THEN
360: RETURN;
361: ELSE
362: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END IF;
365: END Lock_Row;
366:
367:

Line 402: APP_EXCEPTION.raise_exception;

398: IF (used_in_frozen_system(X_Hierarchy_Id)) THEN
399: -- Can't update the record if the hierarchy is used in a frozen system
400: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
401: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
402: APP_EXCEPTION.raise_exception;
403: END IF;
404:
405: /* Ensure that there are as many detail records
406: as there are segments for the dimension */

Line 414: APP_EXCEPTION.raise_exception;

410:
411: IF (num_detail_rows <> num_segments) THEN
412: /* Every segment must have a detail hierarchy row */
413: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');
414: APP_EXCEPTION.raise_exception;
415: END IF;
416:
417: UPDATE rg_dss_hierarchies
418: SET

Line 459: APP_EXCEPTION.raise_exception;

455: IF (used_in_frozen_system(X_Hierarchy_Id)) THEN
456: -- Can't delete the record if the hierarchy is used in a frozen system
457: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
458: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
459: APP_EXCEPTION.raise_exception;
460: END IF;
461:
462: DELETE FROM rg_dss_hierarchies
463: WHERE rowid = X_Rowid;