DBA Data[Home] [Help]

APPS.RG_DSS_VAR_DIMENSIONS_PKG dependencies on FND_MESSAGE

Line 21: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');

17: AND sequence = X_Sequence
18: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
19:
20: -- name already exists for a different variable: ERROR
21: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
22: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);
23: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
24: APP_EXCEPTION.raise_exception;
25:

Line 22: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);

18: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
19:
20: -- name already exists for a different variable: ERROR
21: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
22: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);
23: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
24: APP_EXCEPTION.raise_exception;
25:
26: EXCEPTION

Line 23: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);

19:
20: -- name already exists for a different variable: ERROR
21: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
22: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);
23: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
24: APP_EXCEPTION.raise_exception;
25:
26: EXCEPTION
27: WHEN NO_DATA_FOUND THEN

Line 46: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');

42: AND dimension_id = X_Dimension_Id
43: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
44:
45: -- name already exists for a different variable: ERROR
46: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
47: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_DIMENSION', TRUE);
48: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
49: APP_EXCEPTION.raise_exception;
50:

Line 47: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_DIMENSION', TRUE);

43: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
44:
45: -- name already exists for a different variable: ERROR
46: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
47: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_DIMENSION', TRUE);
48: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
49: APP_EXCEPTION.raise_exception;
50:
51: EXCEPTION

Line 48: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);

44:
45: -- name already exists for a different variable: ERROR
46: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
47: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_DIMENSION', TRUE);
48: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_VARIABLE', TRUE);
49: APP_EXCEPTION.raise_exception;
50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN

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

97: X_Variable_Id := X_Master_Variable_Id;
98:
99: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
100: -- can't modify a variable that is used in a frozen system
101: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
102: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
103: APP_EXCEPTION.raise_exception;
104: END IF;
105:

Line 102: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);

98:
99: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
100: -- can't modify a variable that is used in a frozen system
101: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
102: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
103: APP_EXCEPTION.raise_exception;
104: END IF;
105:
106: SELECT count(*)

Line 113: FND_MESSAGE.set_name('RG', 'RG_DSS_MAX_DIMENSION_REACHED');

109: WHERE variable_id = X_Variable_Id;
110:
111: IF (NumRecs >= 10) THEN
112: -- Maximum number of dimensions is 10
113: FND_MESSAGE.set_name('RG', 'RG_DSS_MAX_DIMENSION_REACHED');
114: FND_MESSAGE.set_token('NUM_DIM','10');
115: APP_EXCEPTION.raise_exception;
116: END IF;
117:

Line 114: FND_MESSAGE.set_token('NUM_DIM','10');

110:
111: IF (NumRecs >= 10) THEN
112: -- Maximum number of dimensions is 10
113: FND_MESSAGE.set_name('RG', 'RG_DSS_MAX_DIMENSION_REACHED');
114: FND_MESSAGE.set_token('NUM_DIM','10');
115: APP_EXCEPTION.raise_exception;
116: END IF;
117:
118: check_unique_sequence(X_Rowid, X_Variable_Id, X_Sequence);

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

215: OPEN C;
216: FETCH C INTO Recinfo;
217: IF (C%NOTFOUND) THEN
218: CLOSE C;
219: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
220: APP_EXCEPTION.RAISE_EXCEPTION;
221: END IF;
222: CLOSE C;
223:

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

281: AND (X_Attribute15 IS NULL)))
282: ) THEN
283: RETURN;
284: ELSE
285: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
286: APP_EXCEPTION.RAISE_EXCEPTION;
287: END IF;
288: END Lock_Row;
289:

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

314: BEGIN
315:
316: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
317: -- can't modify a variable that is used in a frozen system
318: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
319: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
320: APP_EXCEPTION.raise_exception;
321: END IF;
322:

Line 319: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);

315:
316: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
317: -- can't modify a variable that is used in a frozen system
318: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
319: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
320: APP_EXCEPTION.raise_exception;
321: END IF;
322:
323: UPDATE rg_dss_var_dimensions

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

357: BEGIN
358:
359: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
360: -- can't modify a variable that is used in a frozen system
361: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
362: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
363: APP_EXCEPTION.raise_exception;
364: END IF;
365:

Line 362: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);

358:
359: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
360: -- can't modify a variable that is used in a frozen system
361: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
362: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
363: APP_EXCEPTION.raise_exception;
364: END IF;
365:
366: DELETE FROM rg_dss_var_dimensions