APPS.RG_DSS_HIERARCHIES_PKG dependencies on FND_MESSAGE

Line 47: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS');

43: WHERE name = X_Name
44: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
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

Line 48: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);

44: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
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

Line 91: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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;
93:
94: END num_details;
95:

Line 109: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

105: RETURN(NumSegments);
106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
110: RAISE;
111:
112: END num_segments_for_dim;
113:

Line 119: FND_MESSAGE.set_name('RG','RG_DSS_REF_HIERARCHY');

115: PROCEDURE check_references(X_Hierarchy_Id NUMBER) IS
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:

Line 176: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');

172: num_detail_rows := num_details(X_Hierarchy_Id);
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(

Line 287: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

283: OPEN C;
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:

Line 362: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

358: AND (X_Attribute15 IS NULL)))
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:

Line 400: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');

396: BEGIN
397:
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:

Line 401: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);

397:
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

Line 413: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');

409: num_detail_rows := num_details(X_Hierarchy_Id);
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

Line 457: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');

453: BEGIN
454:
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:

Line 458: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);

454:
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