DBA Data[Home] [Help]

APPS.BISM_ACCESS_CONTROL dependencies on BISM_ERRORCODES

Line 24: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

20:
21: if priv is null then
22: begin
23: select object_name into name from bism_objects where object_id = fid;
24: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
25: exception
26: when no_data_found then
27: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
28: end;

Line 27: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

23: select object_name into name from bism_objects where object_id = fid;
24: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
25: exception
26: when no_data_found then
27: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
28: end;
29: end if;
30:
31: if priv >= 10 then

Line 34: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

30:
31: if priv >= 10 then
32: return 'y';
33: else
34: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
35: end if;
36: exception
37: when no_data_found then
38: return 'n';

Line 60: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

56:
57: if priv is null then
58: begin
59: select object_name into name from bism_objects where object_id = fid;
60: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
61: exception
62: when no_data_found then
63: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
64: end;

Line 63: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

59: select object_name into name from bism_objects where object_id = fid;
60: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
61: exception
62: when no_data_found then
63: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
64: end;
65: end if;
66:
67: if priv >= 30 then

Line 70: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

66:
67: if priv >= 30 then
68: return 'y';
69: else
70: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
71: end if;
72: exception
73: when no_data_found then
74: return 'n';

Line 102: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

98:
99: if priv is null then
100: begin
101: select object_name into name from bism_objects where object_id = thisid;
102: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
103: exception
104: when no_data_found then
105: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
106: end;

Line 105: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

101: select object_name into name from bism_objects where object_id = thisid;
102: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
103: exception
104: when no_data_found then
105: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
106: end;
107: end if;
108:
109: if priv >= 40 then

Line 112: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

108:
109: if priv >= 40 then
110: return 'y';
111: else
112: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
113: end if;
114:
115: exception
116: when no_data_found then

Line 146: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

142:
143: if priv is null then
144: begin
145: select object_name into name from bism_objects where object_id = tempid;
146: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
147: exception
148: when no_data_found then
149: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
150: end;

Line 149: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

145: select object_name into name from bism_objects where object_id = tempid;
146: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
147: exception
148: when no_data_found then
149: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
150: end;
151: end if;
152:
153: if priv >= 20 then

Line 156: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

152:
153: if priv >= 20 then
154: return 'y';
155: else
156: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
157: end if;
158: exception
159: when no_data_found then
160: return 'n';

Line 195: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

191:
192: if priv is null then
193: begin
194: select object_name into fname from bism_objects where object_id = tempid;
195: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
196: exception
197: when no_data_found then
198: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
199: end;

Line 198: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

194: select object_name into fname from bism_objects where object_id = tempid;
195: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
196: exception
197: when no_data_found then
198: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
199: end;
200: end if;
201:
202: if priv >=40 then

Line 205: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

201:
202: if priv >=40 then
203: return 'y';
204: else
205: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
206: end if;
207: exception
208: when no_data_found then
209: dbms_output.put_line('Exception occurred - No Data Found');

Line 231: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

227:
228: if priv is null then
229: begin
230: select object_name into name from bism_objects where object_id = oid;
231: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
232: exception
233: when no_data_found then
234: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
235: end;

Line 234: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

230: select object_name into name from bism_objects where object_id = oid;
231: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
232: exception
233: when no_data_found then
234: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
235: end;
236: end if;
237:
238: if priv >= 50 then

Line 241: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');

237:
238: if priv >= 50 then
239: return 'y';
240: else
241: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
242: end if;
243: exception
244: when no_data_found then
245: dbms_output.put_line('Exception occurred - No Data Found');

Line 270: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

266:
267: if priv is null then
268: begin
269: select object_name into name from bism_objects where object_id = oid;
270: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
271: exception
272: when no_data_found then
273: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
274: end;

Line 273: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

269: select object_name into name from bism_objects where object_id = oid;
270: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
271: exception
272: when no_data_found then
273: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
274: end;
275: end if;
276:
277: -- to list the entries on a folder, the caller should have atleast the

Line 286: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES, 'Insufficient privileges to show entries');

282: -- now I only check for priv of 10
283: if priv >= 10 then
284: return 'y';
285: else
286: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES, 'Insufficient privileges to show entries');
287: end if;
288: exception
289: when no_data_found then
290: begin

Line 292: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');

288: exception
289: when no_data_found then
290: begin
291: select object_name into oname from bism_objects where object_id = oid;
292: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
293: exception
294: when no_data_found then
295: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
296: end;

Line 295: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

291: select object_name into oname from bism_objects where object_id = oid;
292: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
293: exception
294: when no_data_found then
295: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
296: end;
297:
298: return 'n';
299: