eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BISM_CORE dependencies on BISM_ERRORCODES

Line 67: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

63: return get_last_object_id(oid,path,startpos,myid);
64: end if;
65: exception
66: when no_data_found then
67: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
68: end;
69: else
70: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
71: end if;

Line 70: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');

66: when no_data_found then
67: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
68: end;
69: else
70: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
71: end if;
72:
73: end;
74:

Line 177: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

173: begin
174: -- make sure that the object being delete is not folder
175: select object_type_id,object_id into typeid,oid from bism_objects where folder_id = fid and object_name = objname and user_visible='Y';
176: if typeid is null then
177: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
178: end if;
179:
180: if typeid = 100 then
181: raise_application_error(BISM_ERRORCODES.CANNOT_UNBIND_FOLDER,'Cannot unbind folder');

Line 181: raise_application_error(BISM_ERRORCODES.CANNOT_UNBIND_FOLDER,'Cannot unbind folder');

177: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
178: end if;
179:
180: if typeid = 100 then
181: raise_application_error(BISM_ERRORCODES.CANNOT_UNBIND_FOLDER,'Cannot unbind folder');
182: end if;
183:
184: -- modified for obj access control (ccchow)
185: -- see comments on the new check_obj_del_access routine

Line 189: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

185: -- see comments on the new check_obj_del_access routine
186: ret := check_obj_del_access(oid,fid,myid);
187: exception
188: when no_data_found then
189: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
190: end;
191:
192: -- the following check if condition to be removed
193: if ret = 'y' then

Line 199: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privilege');

195: if bism_core.v_auto_commit = TRUE then
196: commit;
197: end if;
198: else
199: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privilege');
200: end if;
201: end delete_object;
202:
203: procedure set_privilege(fid raw,grantor raw,grantee_name varchar2,priv number)

Line 214: raise_application_error(BISM_ERRORCODES.PRIVILEGE_NOT_UNDERSTOOD,'Privilege not understood');

210: begin
211: select PRIVILEGE_ID into p from bism_privileges where PRIVILEGE_ID = priv;
212: exception
213: when no_data_found then
214: raise_application_error(BISM_ERRORCODES.PRIVILEGE_NOT_UNDERSTOOD,'Privilege not understood');
215: end;
216:
217: ret := bism_access_control.check_fullcontrol_access(fid,grantor);
218: if ret = 'y' then

Line 228: raise_application_error(BISM_ERRORCODES.USER_NOT_FOUND,'Grantee not found in BISM_SUBJECTS table');

224:
225: end if;
226: exception
227: when no_data_found then
228: raise_application_error(BISM_ERRORCODES.USER_NOT_FOUND,'Grantee not found in BISM_SUBJECTS table');
229: end set_privilege;
230:
231:
232:

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

477: a_objid := oid;
478: end if;
479: exception
480: when no_data_found then
481: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
482: end;
483: else
484: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
485: end if;

Line 484: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');

480: when no_data_found then
481: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');
482: end;
483: else
484: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
485: end if;
486: end lookup_folder_wo_security;
487:
488:

Line 769: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

765: end if;
766: exception
767: when no_data_found then
768: status := BISM_CONSTANTS.DATA_NOT_FOUND;
769: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
770: end;
771: end check_modify_attrs_access;
772:
773: function get_attributes(p_fid raw, p_objname varchar2, p_myid raw)

Line 808: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

804: select object_type_id into type_id from bism_objects where folder_id = fid and object_name = objname and user_visible = 'Y';
805: exception
806: when no_data_found then
807: -- we dont care whether th eobject is not found or folder is not found
808: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
809: end;
810:
811: -- if the object is not a folder, then
812: -- check to see if the user has atleast LIST access to the parent folder

Line 941: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Illegal move : Target object is not a folder');

937: begin
938: -- make sure target folder exists
939: select object_id,object_type_id into objid,objtypeid from bism_objects where object_id = tgtfid and user_visible = 'Y';
940: if objtypeid <> 100 then
941: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Illegal move : Target object is not a folder');
942: end if;
943: exception
944: when no_data_found then
945: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

Line 945: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

941: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Illegal move : Target object is not a folder');
942: end if;
943: exception
944: when no_data_found then
945: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
946: end;
947:
948: -- now make sure that the object exists and check its type
949:

Line 962: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

958: move_object(srcfid ,tgtfid ,objname ,objid, myid );
959: end if;
960: exception
961: when no_data_found then
962: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
963: end;
964:
965: if bism_core.v_auto_commit = TRUE then
966: commit;

Line 980: raise_application_error(BISM_ERRORCODES.ILLEGAL_MOVE,'Target folder is subfolder of source folder');

976: begin
977:
978: move_not_allowed := is_src_ancestor_of_target(srcfid,tgtfid);
979: if move_not_allowed = true then
980: raise_application_error(BISM_ERRORCODES.ILLEGAL_MOVE,'Target folder is subfolder of source folder');
981: end if;
982:
983: -- NT requires that the user posses List priv on Parent folder
984: -- and Change priv on the src folder (being moved) and Add priv

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

1000: -- 2. if user does not have privilege on folder
1001: if priv is null then
1002: begin
1003: select object_name into foldername from bism_objects where object_id = srcfid;
1004: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for parent folder');
1005: exception
1006: when no_data_found then
1007: raise_application_error(BISM_ERRORCODES.PARENT_FOLDER_NOT_FOUND ,'Parent folder not found');
1008: end;

Line 1007: raise_application_error(BISM_ERRORCODES.PARENT_FOLDER_NOT_FOUND ,'Parent folder not found');

1003: select object_name into foldername from bism_objects where object_id = srcfid;
1004: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for parent folder');
1005: exception
1006: when no_data_found then
1007: raise_application_error(BISM_ERRORCODES.PARENT_FOLDER_NOT_FOUND ,'Parent folder not found');
1008: end;
1009: end if;
1010:
1011:

Line 1013: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges for parent folder');

1009: end if;
1010:
1011:
1012: if priv < 10 then
1013: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges for parent folder');
1014: end if;
1015:
1016: end;
1017:

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

1028:
1029: if priv is null then
1030: begin
1031: select object_name into foldername from bism_objects where object_id = srcfid;
1032: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder');
1033: exception
1034: when no_data_found then
1035: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');
1036: end;

Line 1035: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');

1031: select object_name into foldername from bism_objects where object_id = srcfid;
1032: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder');
1033: exception
1034: when no_data_found then
1035: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');
1036: end;
1037: end if;
1038:
1039:

Line 1041: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');

1037: end if;
1038:
1039:
1040: if priv < 40 then
1041: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');
1042: end if;
1043:
1044: end;
1045:

Line 1061: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);

1057: -- but it wont raise data not found exception
1058: if priv is null then
1059: begin
1060: select object_name into foldername from bism_objects where object_id = tgtfid;
1061: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1062: exception
1063: when no_data_found then
1064: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');
1065: end;

Line 1064: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');

1060: select object_name into foldername from bism_objects where object_id = tgtfid;
1061: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1062: exception
1063: when no_data_found then
1064: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');
1065: end;
1066: end if;
1067:
1068: if priv < 30 then

Line 1069: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');

1065: end;
1066: end if;
1067:
1068: if priv < 30 then
1069: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');
1070: end if;
1071:
1072: end;
1073:

Line 1088: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');

1084: );
1085:
1086: if priv is null then
1087: -- we know that the object exists because we got by doing a select above see for loop
1088: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');
1089: end if;
1090:
1091: if priv < 10 then
1092: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for a folder in folder hierarchy');

Line 1092: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for a folder in folder hierarchy');

1088: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');
1089: end if;
1090:
1091: if priv < 10 then
1092: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for a folder in folder hierarchy');
1093: end if;
1094:
1095: end loop;
1096: end;

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

1115:
1116: if priv is null then
1117: begin
1118: select object_name into foldername from bism_objects where object_id = objid;
1119: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for object');
1120: exception
1121: when no_data_found then
1122: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND ,'Object not found');
1123: end;

Line 1122: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND ,'Object not found');

1118: select object_name into foldername from bism_objects where object_id = objid;
1119: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for object');
1120: exception
1121: when no_data_found then
1122: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND ,'Object not found');
1123: end;
1124: end if;
1125:
1126: -- NT requires at least WRITE privilege on object

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

1124: end if;
1125:
1126: -- NT requires at least WRITE privilege on object
1127: if priv < 40 then
1128: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
1129: end if;
1130: end;
1131:
1132: -- now test the source folder

Line 1145: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);

1141: -- 2. if user does not have privilege on folder
1142: if priv is null then
1143: begin
1144: select object_name into foldername from bism_objects where object_id = srcfid;
1145: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);
1146: exception
1147: when no_data_found then
1148: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');
1149: end;

Line 1148: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');

1144: select object_name into foldername from bism_objects where object_id = srcfid;
1145: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);
1146: exception
1147: when no_data_found then
1148: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND ,'Source folder not found');
1149: end;
1150: end if;
1151:
1152: -- deprecated since NT requires only LIST privilege on source folder for move

Line 1154: --raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');

1150: end if;
1151:
1152: -- deprecated since NT requires only LIST privilege on source folder for move
1153: --if priv < 40 then
1154: --raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');
1155: --end if;
1156: end;
1157:
1158: -- now test the target folder

Line 1168: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);

1164: -- but it wont raise data not found exception
1165: if priv is null then
1166: begin
1167: select object_name into foldername from bism_objects where object_id = tgtfid;
1168: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1169: exception
1170: when no_data_found then
1171: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');
1172: end;

Line 1171: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');

1167: select object_name into foldername from bism_objects where object_id = tgtfid;
1168: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1169: exception
1170: when no_data_found then
1171: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND ,'Target folder not found');
1172: end;
1173: end if;
1174:
1175: if priv < 30 then

Line 1176: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');

1172: end;
1173: end if;
1174:
1175: if priv < 30 then
1176: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');
1177: end if;
1178: end;
1179:
1180: -- if we got this far means that the user has privileges on both the src

Line 1202: raise_application_error(BISM_ERRORCODES.ILLEGAL_COPY,'Target folder is subfolder of source folder');

1198: begin
1199: -- make sure that the destination folder is not a sub folder of src folder
1200: copy_not_allowed := bism_core.is_src_ancestor_of_target(srcfid,tgtfid);
1201: if copy_not_allowed = true then
1202: raise_application_error(BISM_ERRORCODES.ILLEGAL_COPY,'Target folder is subfolder of source folder');
1203: end if;
1204: -- make sure user has atleast READ access on all sub folders
1205: begin
1206: for i in (select object_id from bism_objects where object_type_id=100 start with object_id = srcfid connect by folder_id = prior object_id) loop

Line 1216: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');

1212: );
1213:
1214: if priv is null then
1215: -- we know that the object exists because we got by doing a select above see for loop
1216: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');
1217: end if;
1218:
1219: if priv < 20 then
1220: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for folder hierarchy');

Line 1220: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for folder hierarchy');

1216: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for a folder in the hierarchy');
1217: end if;
1218:
1219: if priv < 20 then
1220: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_HIER_FOLDER,'Insufficient privileges for folder hierarchy');
1221: end if;
1222:
1223: end loop;
1224: end;

Line 1240: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);

1236: -- but it wont raise data not found exception
1237: if priv is null then
1238: begin
1239: select object_name into foldername from bism_objects where object_id = tgtfid;
1240: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1241: exception
1242: when no_data_found then
1243: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
1244: end;

Line 1243: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

1239: select object_name into foldername from bism_objects where object_id = tgtfid;
1240: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1241: exception
1242: when no_data_found then
1243: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
1244: end;
1245: end if;
1246:
1247: if priv < 30 then

Line 1248: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');

1244: end;
1245: end if;
1246:
1247: if priv < 30 then
1248: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');
1249: end if;
1250:
1251: end;
1252:

Line 1314: raise_application_error(BISM_ERRORCODES.INVALID_COPY_OPERATION,'Invalid copy type');

1310: can_copy_folder_var boolean := false;
1311: begin
1312:
1313: if copytype not in (0,1) then
1314: raise_application_error(BISM_ERRORCODES.INVALID_COPY_OPERATION,'Invalid copy type');
1315: end if;
1316:
1317: begin
1318:

Line 1322: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Target object is not folder');

1318:
1319: -- make sure target exists
1320: select object_id,object_type_id into objid,objtypeid from bism_objects where object_id = tgtfid;
1321: if objtypeid <> 100 then
1322: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Target object is not folder');
1323: end if;
1324: exception
1325: when no_data_found then
1326: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

Line 1326: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

1322: raise_application_error(BISM_ERRORCODES.TGT_IS_NOT_FOLDER,'Target object is not folder');
1323: end if;
1324: exception
1325: when no_data_found then
1326: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
1327: end;
1328:
1329: -- now make sure that the object exists, check its type and call approp. method
1330:

Line 1349: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1345: copy_object(srcfid ,tgtfid ,srcobjname ,destobjname, myid,copytype );
1346: end if;
1347: exception
1348: when no_data_found then
1349: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1350: end;
1351:
1352: if bism_core.v_auto_commit = TRUE then
1353: commit;

Line 1393: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1389: begin
1390: select object_id into toplevelobjid from bism_objects where folder_id = srcfid and object_name = srcobjname and user_visible = 'Y';
1391: exception
1392: when no_data_found then
1393: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1394: end;
1395: -- OK, top level object is found !!
1396:
1397: -- first check the privilege on the object (ccchow)

Line 1403: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges on object');

1399: priv := 0;
1400: select max(privilege) into priv from bism_permissions where object_id = toplevelobjid and subject_id in (select group_id from bism_groups where user_id = myid);
1401:
1402: if priv is null then
1403: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges on object');
1404: end if;
1405:
1406: -- NT requires READ priv on the object
1407: if priv < 20 then

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

1404: end if;
1405:
1406: -- NT requires READ priv on the object
1407: if priv < 20 then
1408: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Insufficient privileges');
1409: end if;
1410: end;
1411:
1412: -- now check privileges on source and target folders

Line 1425: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);

1421: -- 2. if user does not have privilege on folder
1422: if priv is null then
1423: begin
1424: select object_name into foldername from bism_objects where object_id = srcfid;
1425: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);
1426: exception
1427: when no_data_found then
1428: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND,'Source folder not found');
1429: end;

Line 1428: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND,'Source folder not found');

1424: select object_name into foldername from bism_objects where object_id = srcfid;
1425: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for source folder '||foldername);
1426: exception
1427: when no_data_found then
1428: raise_application_error(BISM_ERRORCODES.SRC_FOLDER_NOT_FOUND,'Source folder not found');
1429: end;
1430: end if;
1431:
1432: -- NT requires LIST priv on source folder only (NEW)

Line 1436: -- raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');

1432: -- NT requires LIST priv on source folder only (NEW)
1433: -- (deprecated) NT only requires READ priv on source folder to be able to
1434: -- copy from source folder (OLD)
1435: -- if priv < 20 then
1436: -- raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_SRC_FOLDER,'Insufficient privileges for source folder');
1437: -- end if;
1438: end;
1439:
1440: -- now test the target folder

Line 1450: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);

1446: -- but it wont raise data not found exception
1447: if priv is null then
1448: begin
1449: select object_name into foldername from bism_objects where object_id = tgtfid;
1450: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1451: exception
1452: when no_data_found then
1453: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
1454: end;

Line 1453: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');

1449: select object_name into foldername from bism_objects where object_id = tgtfid;
1450: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for target folder '||foldername);
1451: exception
1452: when no_data_found then
1453: raise_application_error(BISM_ERRORCODES.TGT_FOLDER_NOT_FOUND,'Target folder not found');
1454: end;
1455: end if;
1456:
1457: if priv < 30 then

Line 1458: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');

1454: end;
1455: end if;
1456:
1457: if priv < 30 then
1458: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIV_TGT_FOLDER,'Insufficient privileges for target folder');
1459: end if;
1460: end;
1461:
1462: -- if we got this far means that the user has privileges on both the src

Line 1630: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1626: lookup(oid,path,lookup_output,idx,myid);
1627: end if;
1628: exception
1629: when no_data_found then
1630: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1631: end;
1632: end if; --end if path(idx) exists
1633:
1634: end;

Line 1680: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1676: end if;
1677: end if;
1678: exception
1679: when no_data_found then
1680: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1681: end;
1682: else
1683: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
1684: end if;

Line 1683: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');

1679: when no_data_found then
1680: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1681: end;
1682: else
1683: raise_application_error(BISM_ERRORCODES.INVALID_FOLDER_PATH,'Invalid atomic name');
1684: end if;
1685:
1686: end;
1687:

Line 1787: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1783: T ;
1784: return rc;
1785: exception
1786: when no_data_found then
1787: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1788: when others then
1789: raise;
1790: end;
1791:

Line 1828: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1824: 'y'=bism_core.check_lookup_access(oid,'100','y',myid);
1825: return rc;
1826: exception
1827: when no_data_found then
1828: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1829: when others then
1830: raise;
1831: end;
1832:

Line 1878: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1874:
1875: return rc;
1876: exception
1877: when no_data_found then
1878: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1879: when others then
1880: raise;
1881: end;
1882: end get_object;

Line 1931: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

1927: 'y' = bism_core.check_lookup_access(T1.object_id,T1.object_type_id,T1.user_visible,myid);
1928: return rc;
1929: exception
1930: when no_data_found then
1931: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
1932: when others then
1933: raise;
1934: end;
1935: end fetch_objectsSQL1;

Line 2006: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2002: end if;
2003: return rc;
2004: exception
2005: when no_data_found then
2006: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2007: when others then
2008: raise;
2009: end;
2010: end fetch_objectsSQL2;

Line 2047: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2043: 'y' = bism_access_control.check_list_access(p_fid,p_subid);
2044: return rc;
2045: exception
2046: when no_data_found then
2047: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2048: when others then
2049: raise;
2050: end;
2051:

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

2064: begin
2065: select object_id into oid from bism_objects where folder_id='30' and object_name= 'ROOT' and user_visible = 'Y';
2066: exception
2067: when no_data_found then
2068: raise_application_error(BISM_ERRORCODES.ROOT_NOT_FOUND,'Root folder not found');
2069: end;
2070:
2071: /* make sure user exists */
2072: begin

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

2072: begin
2073: select subject_id into subid from bism_subjects where subject_name = p_subname and subject_type= 'u';
2074: exception
2075: when no_data_found then
2076: raise_application_error (BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified');
2077: end;
2078:
2079: /* make sure user has enough prvileges */
2080: begin

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

2080: begin
2081: select nvl(max(privilege),0) into priv from bism_permissions where object_id = '31' and subject_id in (select group_id from bism_groups where user_id = subid );
2082: exception
2083: when no_data_found then
2084: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privilege for root folder');
2085: end;
2086:
2087: if priv < 10 then
2088: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User does not have enough privileges for root folder');

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

2084: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privilege for root folder');
2085: end;
2086:
2087: if priv < 10 then
2088: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User does not have enough privileges for root folder');
2089: end if;
2090:
2091: return subid;
2092: end init;

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

2584: if grantorpriv is null then
2585: begin
2586: -- see if object exists
2587: select object_name into objname from bism_objects where object_id = oid;
2588: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2589: exception
2590: when no_data_found then
2591: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2592: end;

Line 2591: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2587: select object_name into objname from bism_objects where object_id = oid;
2588: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2589: exception
2590: when no_data_found then
2591: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2592: end;
2593: end if;
2594:
2595: if grantorpriv < 50 then

Line 2596: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

2592: end;
2593: end if;
2594:
2595: if grantorpriv < 50 then
2596: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
2597: end if;
2598:
2599: if topfolder = 'y' or topfolder = 'Y' then
2600: for i in 1..acllist.count

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

2704: if grantorpriv is null then
2705: begin
2706: -- see if object exists
2707: select object_name into objname from bism_objects where object_id = oid;
2708: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2709: exception
2710: when no_data_found then
2711: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2712: end;

Line 2711: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2707: select object_name into objname from bism_objects where object_id = oid;
2708: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2709: exception
2710: when no_data_found then
2711: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2712: end;
2713: end if;
2714:
2715: if grantorpriv < 50 then

Line 2716: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

2712: end;
2713: end if;
2714:
2715: if grantorpriv < 50 then
2716: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
2717: end if;
2718:
2719: loop
2720: if startpos <> 0 then

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

2819: if grantorpriv is null then
2820: begin
2821: -- see if object exists
2822: select object_name into objname from bism_objects where object_id = oid;
2823: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2824: exception
2825: when no_data_found then
2826: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2827: end;

Line 2826: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2822: select object_name into objname from bism_objects where object_id = oid;
2823: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2824: exception
2825: when no_data_found then
2826: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2827: end;
2828: end if;
2829:
2830: if grantorpriv < 50 then

Line 2831: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

2827: end;
2828: end if;
2829:
2830: if grantorpriv < 50 then
2831: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
2832: end if;
2833:
2834: if topfolder = 'Y' or topfolder = 'y' then
2835: for i in 1..acllist.count

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

2924: if grantorpriv is null then
2925: begin
2926: -- see if object exists
2927: select object_name into objname from bism_objects where object_id = oid;
2928: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2929: exception
2930: when no_data_found then
2931: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2932: end;

Line 2931: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

2927: select object_name into objname from bism_objects where object_id = oid;
2928: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
2929: exception
2930: when no_data_found then
2931: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
2932: end;
2933: end if;
2934:
2935: if grantorpriv < 50 then

Line 2936: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

2932: end;
2933: end if;
2934:
2935: if grantorpriv < 50 then
2936: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
2937: end if;
2938:
2939: loop
2940: if startpos <> 0 then

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

3023: if grantorpriv is null then
3024: begin
3025: -- see if object exists
3026: select object_name into objname from bism_objects where object_id = oid;
3027: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
3028: exception
3029: when no_data_found then
3030: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
3031: end;

Line 3030: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

3026: select object_name into objname from bism_objects where object_id = oid;
3027: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
3028: exception
3029: when no_data_found then
3030: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
3031: end;
3032: end if;
3033:
3034: if grantorpriv < 50 then

Line 3035: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

3031: end;
3032: end if;
3033:
3034: if grantorpriv < 50 then
3035: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
3036: end if;
3037:
3038: if topfolder = 'Y' or topfolder = 'y' then
3039: for i in 1..acllist.count

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

3141: if grantorpriv is null then
3142: begin
3143: -- see if object exists
3144: select object_name into objname from bism_objects where object_id = oid;
3145: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
3146: exception
3147: when no_data_found then
3148: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
3149: end;

Line 3148: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');

3144: select object_name into objname from bism_objects where object_id = oid;
3145: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'Grantor has no privileges for folder');
3146: exception
3147: when no_data_found then
3148: raise_application_error(BISM_ERRORCODES.OBJECT_NOT_FOUND,'Object not found');
3149: end;
3150: end if;
3151:
3152: if grantorpriv < 50 then

Line 3153: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');

3149: end;
3150: end if;
3151:
3152: if grantorpriv < 50 then
3153: raise_application_error(BISM_ERRORCODES.INSUFFICIENT_PRIVILEGES,'Grantor has insufficient privileges');
3154: end if;
3155:
3156: loop
3157: if startpos <> 0 then