DBA Data[Home] [Help]

APPS.BISM_UTILS dependencies on BISM_ERRORCODES

Line 40: raise_application_error(BISM_ERRORCODES.ROOT_NOT_FOUND,'Root folder not found');

36: begin
37: select object_id into oid from bism_objects where folder_id = '30' and object_name = 'ROOT' and user_visible = 'Y';
38: exception
39: when no_data_found then
40: raise_application_error(BISM_ERRORCODES.ROOT_NOT_FOUND,'Root folder not found');
41: end;
42:
43: -- make sure that the user is internally identified (we need SUBJECT_ID)
44: begin

Line 51: raise_application_error(BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified',true);

47: -- select sys_context('bism_session','current_user_id') into sub_id from dual;
48: exception
49: when no_data_found then
50: -- renumber the error messages later..
51: raise_application_error(BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified',true);
52: when too_many_rows then
53: raise_application_error(BISM_ERRORCODES.USER_EXISTS_MULTIPLE_TIMES,'User exists more than once',true);
54:
55: end;

Line 53: raise_application_error(BISM_ERRORCODES.USER_EXISTS_MULTIPLE_TIMES,'User exists more than once',true);

49: when no_data_found then
50: -- renumber the error messages later..
51: raise_application_error(BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified',true);
52: when too_many_rows then
53: raise_application_error(BISM_ERRORCODES.USER_EXISTS_MULTIPLE_TIMES,'User exists more than once',true);
54:
55: end;
56:
57: --lastly make sure that the user has atleat list privilege on the root

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

58: begin
59: select privilege into priv from bism_permissions where subject_id=sub_id and object_id='31';
60: exception
61: when no_data_found then
62: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for root folder');
63: end;
64:
65: if priv < 10 then
66: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'User does not have enough privileges for root folder');

Line 66: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'User does not have enough privileges for root folder');

62: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for root folder');
63: end;
64:
65: if priv < 10 then
66: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'User does not have enough privileges for root folder');
67: else
68: return sub_id;
69: end if;
70: