DBA Data[Home] [Help]

APPS.RG_DSS_VARIABLES_PKG dependencies on FND_MESSAGE

Line 69: FND_MESSAGE.set_name('RG', 'RG_DSS_DIMENSION_REQUIRED');

65: rg_dss_dimensions dim
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;

Line 88: FND_MESSAGE.set_name('RG', 'RG_DSS_SUM_DIM_REQUIRED');

84: WHERE vdm.variable_id = X_Variable_Id
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

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

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

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

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

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

125: WHERE object_name = X_Object_Name
126: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
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

Line 130: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_OBJECT_NAME', TRUE);

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

Line 154: FND_MESSAGE.set_name('RG','RG_DSS_REF_VARIABLE');

150: );
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(

Line 225: FND_MESSAGE.set_name('RG', 'RG_DSS_DIM_DUP_SEG');

221: 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;

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

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',
319: 'RG_DSS_VARIABLES_PKG.generate_matching_struc');
320: RAISE;
321: END generate_matching_struc;

Line 318: fnd_message.set_token('PROCEDURE',

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',
319: 'RG_DSS_VARIABLES_PKG.generate_matching_struc');
320: RAISE;
321: END generate_matching_struc;
322:

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

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

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

850: AND (X_Segment30_Type IS NULL)))
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:

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

926: BEGIN
927:
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:

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

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

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

1047: PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Variable_Id NUMBER) IS
1048: BEGIN
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:

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

1048: BEGIN
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