APPS.RG_DSS_VARIABLES_PKG dependencies on APP_EXCEPTION

Line 70: APP_EXCEPTION.raise_exception;

66: WHERE vdm.variable_id = X_Variable_Id
67: AND vdm.dimension_id = dim.dimension_id
68: AND dim.dimension_type = 'T' );
69: FND_MESSAGE.set_name('RG', 'RG_DSS_DIMENSION_REQUIRED');
70: APP_EXCEPTION.raise_exception;
71: EXCEPTION
72: WHEN NO_DATA_FOUND THEN
73: NULL;
74: END;

Line 89: APP_EXCEPTION.raise_exception;

85: AND vdm.dimension_id = dim.dimension_id
86: AND dim.level_code = 'S' );
87:
88: FND_MESSAGE.set_name('RG', 'RG_DSS_SUM_DIM_REQUIRED');
89: APP_EXCEPTION.raise_exception;
90: END IF;
91:
92: EXCEPTION
93: WHEN NO_DATA_FOUND THEN

Line 110: APP_EXCEPTION.raise_exception;

106:
107: -- name already exists for a different variable: ERROR
108: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS');
109: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
110: APP_EXCEPTION.raise_exception;
111:
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: -- name doesn't exist, so do nothing

Line 131: APP_EXCEPTION.raise_exception;

127:
128: -- name already exists for a different variable: ERROR
129: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS');
130: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_OBJECT_NAME', TRUE);
131: APP_EXCEPTION.raise_exception;
132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: -- name doesn't exist, so do nothing

Line 155: APP_EXCEPTION.raise_exception;

151:
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: FND_MESSAGE.set_name('RG','RG_DSS_REF_VARIABLE');
155: APP_EXCEPTION.raise_exception;
156: END check_references;
157:
158: PROCEDURE generate_matching_struc(
159: X_Variable_Id NUMBER,

Line 226: APP_EXCEPTION.RAISE_EXCEPTION;

222: WHEN NO_DATA_FOUND THEN
223: null;
224: WHEN TOO_MANY_ROWS THEN
225: FND_MESSAGE.set_name('RG', 'RG_DSS_DIM_DUP_SEG');
226: APP_EXCEPTION.RAISE_EXCEPTION;
227: WHEN OTHERS THEN
228: RAISE;
229: END;
230:

Line 314: WHEN app_exceptions.application_exception THEN

310:
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN
313: null;
314: WHEN app_exceptions.application_exception THEN
315: RAISE;
316: WHEN OTHERS THEN
317: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
318: fnd_message.set_token('PROCEDURE',

Line 667: APP_EXCEPTION.RAISE_EXCEPTION;

663: FETCH C INTO Recinfo;
664: IF (C%NOTFOUND) THEN
665: CLOSE C;
666: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
667: APP_EXCEPTION.RAISE_EXCEPTION;
668: END IF;
669: CLOSE C;
670:
671: IF (

Line 855: APP_EXCEPTION.RAISE_EXCEPTION;

851: ) THEN
852: RETURN;
853: ELSE
854: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
855: APP_EXCEPTION.RAISE_EXCEPTION;
856: END IF;
857: END Lock_Row;
858:
859:

Line 932: APP_EXCEPTION.raise_exception;

928: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
929: -- can't modify a variable that is used in a frozen system
930: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
931: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
932: APP_EXCEPTION.raise_exception;
933: END IF;
934:
935: -- primarily check for summary dimension
936: check_for_details(X_Variable_Id,X_Level_Code);

Line 1053: APP_EXCEPTION.raise_exception;

1049: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
1050: -- can't modify a variable that is used in a frozen system
1051: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
1052: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
1053: APP_EXCEPTION.raise_exception;
1054: END IF;
1055:
1056: DELETE FROM rg_dss_var_dimensions
1057: WHERE variable_id = X_Variable_Id;