APPS.GL_DEFAS_ACCESS_SETS_PKG dependencies on FND_MESSAGE

Line 22: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

18: CLOSE get_new_id;
19: RETURN (new_id);
20: ELSE
21: CLOSE get_new_id;
22: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
23: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_ACCESS_SETS_S');
24: app_exception.raise_exception;
25: END IF;
26:

Line 23: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_ACCESS_SETS_S');

19: RETURN (new_id);
20: ELSE
21: CLOSE get_new_id;
22: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
23: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_ACCESS_SETS_S');
24: app_exception.raise_exception;
25: END IF;
26:
27: EXCEPTION

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

27: EXCEPTION
28: WHEN app_exceptions.application_exception THEN
29: RAISE;
30: WHEN OTHERS THEN
31: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
32: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_unique_id');
33: RAISE;
34: END get_unique_id;
35:

Line 32: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_unique_id');

28: WHEN app_exceptions.application_exception THEN
29: RAISE;
30: WHEN OTHERS THEN
31: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
32: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_unique_id');
33: RAISE;
34: END get_unique_id;
35:
36:

Line 51: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

47: CLOSE get_new_id;
48: RETURN (new_id);
49: ELSE
50: CLOSE get_new_id;
51: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
52: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_DBNAME_S');
53: app_exception.raise_exception;
54: END IF;
55:

Line 52: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_DBNAME_S');

48: RETURN (new_id);
49: ELSE
50: CLOSE get_new_id;
51: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
52: fnd_message.set_token('SEQUENCE', 'GL_DEFAS_DBNAME_S');
53: app_exception.raise_exception;
54: END IF;
55:
56: EXCEPTION

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

56: EXCEPTION
57: WHEN app_exceptions.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEN
60: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
61: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_dbname_id');
62: RAISE;
63: END get_dbname_id;
64:

Line 61: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_dbname_id');

57: WHEN app_exceptions.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEN
60: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
61: fnd_message.set_token('PROCEDURE', 'gl_defas_access_sets_pkg.get_dbname_id');
62: RAISE;
63: END get_dbname_id;
64:
65: --

Line 83: fnd_message.set_name( 'SQLGL', 'GL_DEFAS_DUPLICATE' );

79: FETCH c_dup INTO dummy;
80:
81: IF c_dup%FOUND THEN
82: CLOSE c_dup;
83: fnd_message.set_name( 'SQLGL', 'GL_DEFAS_DUPLICATE' );
84: app_exception.raise_exception;
85: END IF;
86:
87: CLOSE c_dup;

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

89: EXCEPTION
90: WHEN app_exceptions.application_exception THEN
91: RAISE;
92: WHEN OTHERS THEN
93: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
94: fnd_message.set_token('PROCEDURE',
95: 'GL_DEFAS_ACCESS_SETS_PKG.check_unique_name');
96: RAISE;
97: END check_unique_name;

Line 94: fnd_message.set_token('PROCEDURE',

90: WHEN app_exceptions.application_exception THEN
91: RAISE;
92: WHEN OTHERS THEN
93: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
94: fnd_message.set_token('PROCEDURE',
95: 'GL_DEFAS_ACCESS_SETS_PKG.check_unique_name');
96: RAISE;
97: END check_unique_name;
98:

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

114: EXCEPTION
115: WHEN app_exceptions.application_exception THEN
116: RAISE;
117: WHEN OTHERS THEN
118: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
119: fnd_message.set_token('PROCEDURE',
120: 'GL_DEFAS_ACCESS_SETS_PKG.check_assign');
121: RAISE;
122:

Line 119: fnd_message.set_token('PROCEDURE',

115: WHEN app_exceptions.application_exception THEN
116: RAISE;
117: WHEN OTHERS THEN
118: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
119: fnd_message.set_token('PROCEDURE',
120: 'GL_DEFAS_ACCESS_SETS_PKG.check_assign');
121: RAISE;
122:
123: END check_assign;

Line 186: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');

182: BEGIN
183:
184: -- validate input parameters
185: if ( X_User_Definition_Access_Set IS NULL) then
186: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
187: app_exception.raise_exception;
188: end if;
189:
190: if (X_OWNER = 'SEED') then