APPS.RG_DSS_DIM_SEGMENTS_PKG dependencies on APP_EXCEPTION

Line 45: APP_EXCEPTION.raise_exception;

41: WHEN NO_DATA_FOUND THEN
42: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
43: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);
44: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_DIMENSION', TRUE);
45: APP_EXCEPTION.raise_exception;
46: END check_unique_sequence;
47:
48:
49: PROCEDURE check_unique_segment(X_rowid VARCHAR2,

Line 70: APP_EXCEPTION.raise_exception;

66: WHEN NO_DATA_FOUND THEN
67: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
68: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEGMENT', TRUE);
69: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_DIMENSION', TRUE);
70: APP_EXCEPTION.raise_exception;
71: END check_unique_segment;
72:
73:
74: FUNCTION number_of_dim_segments(X_dimension_id NUMBER) RETURN NUMBER IS

Line 133: APP_EXCEPTION.raise_exception;

129: IF (RG_DSS_DIMENSIONS_PKG.used_in_frozen_system(X_Dimension_Id) = 1) THEN
130: -- can't modify a dimension that is used in a frozen system
131: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
132: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_DIMENSION', TRUE);
133: APP_EXCEPTION.raise_exception;
134: END IF;
135:
136: check_unique_sequence(X_rowid, X_dimension_id, X_sequence);
137: check_unique_segment(X_rowid, X_dimension_id, X_application_column_name);

Line 244: APP_EXCEPTION.raise_exception;

240: IF (RG_DSS_DIMENSIONS_PKG.used_in_frozen_system(X_Dimension_Id) = 1) THEN
241: -- can't modify a dimension that is used in a frozen system
242: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
243: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_DIMENSION', TRUE);
244: APP_EXCEPTION.raise_exception;
245: END IF;
246:
247: UPDATE rg_dss_dim_segments
248: SET dimension_id = X_dimension_id ,

Line 321: APP_EXCEPTION.RAISE_EXCEPTION;

317: FETCH C INTO Recinfo;
318: IF (C%NOTFOUND) THEN
319: CLOSE C;
320: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
321: APP_EXCEPTION.RAISE_EXCEPTION;
322: END IF;
323: CLOSE C;
324:
325: IF (

Line 402: APP_EXCEPTION.RAISE_EXCEPTION;

398: ) THEN
399: RETURN;
400: ELSE
401: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
402: APP_EXCEPTION.RAISE_EXCEPTION;
403: END IF;
404: END lock_row;
405:
406: PROCEDURE delete_row(

Line 414: APP_EXCEPTION.raise_exception;

410: IF (RG_DSS_DIMENSIONS_PKG.used_in_frozen_system(X_Dimension_Id) = 1) THEN
411: -- can't modify a dimension that is used in a frozen system
412: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
413: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_DIMENSION', TRUE);
414: APP_EXCEPTION.raise_exception;
415: END IF;
416:
417: DELETE FROM rg_dss_dim_segments
418: WHERE rowid = X_rowid;