APPS.RG_DSS_VAR_DIMENSIONS_PKG dependencies on APP_EXCEPTION

Line 24: APP_EXCEPTION.raise_exception;

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
28: -- name doesn't exist, so do nothing

Line 49: APP_EXCEPTION.raise_exception;

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
53: -- name doesn't exist, so do nothing

Line 103: APP_EXCEPTION.raise_exception;

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(*)
107: INTO NumRecs

Line 115: APP_EXCEPTION.raise_exception;

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);
119: check_unique_dimension(X_Rowid, X_Variable_Id, X_Dimension_Id);

Line 220: APP_EXCEPTION.RAISE_EXCEPTION;

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:
224: IF (

Line 286: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 320: APP_EXCEPTION.raise_exception;

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
324: SET

Line 363: APP_EXCEPTION.raise_exception;

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
367: WHERE rowid = X_Rowid;