173: -- Log error message into edw_error_log table
174:
175: x_message := 'Context length exceeds maximum allowable limit.
176: Please try by reducing the number of dimensions or levels on which security is defined.';
177: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
178:
179:
180: -- Set the error_context to make security function aware of the error occured in initialization function
181:
196:
197: x_message := 'Oracle error occured.
198: Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText ;
199:
200: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
201:
202: commit;
203:
204:
319: -- Log error message into edw_error_log table
320:
321: x_message := 'Default Context length exceeds maximum allowable limit.';
322:
323: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
324:
325:
326: -- Set the error_context to make security function aware of the error occured in initialization function
327:
342:
343: x_message := 'Oracle error occured.
344: Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText ;
345:
346: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
347:
348: commit;
349:
350: END set_default_context;
591: -- Log error message into edw_error_log table
592:
593: x_message := 'Application user '|| x_user_name || ' does not exist on master source instance.';
594:
595: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
596:
597: -- Set the error_context to make security function aware of the error occured in initialization function
598:
599: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
605: -- Log error message into edw_error_log table
606:
607: x_message := 'Application user '|| x_user_name || ' is not linked with any employee.';
608:
609: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
610:
611: -- Set the error_context to make security function aware of the error occured in initialization function
612:
613: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
628:
629: x_message := 'Oracle error occured.
630: Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText ;
631:
632: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
633:
634:
635: commit;
636:
958: -- Log error message into edw_error_log table
959:
960: x_message := 'Error in initialization function.';
961:
962: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
963:
964:
965: -- Make security function fail
966: RAISE;
970: -- Log error message into edw_error_log table
971:
972: x_message := 'Def_dim_id is null.';
973:
974: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
975:
976: -- Make security function fail
977: RAISE;
978:
982:
983: x_message := 'Predicate length exceeds maximum allowable limit.
984: Please try by reducing the number of dimensions or levels on which security is defined.';
985:
986: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
987:
988:
989: -- Make security function fail
990: RAISE;
997:
998: x_message := 'Oracle error occured.
999: Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText ;
1000:
1001: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
1002:
1003:
1004: -- Make security function fail
1005: RAISE;
1157: -- Log error message into edw_error_log table
1158:
1159: x_message := 'Error in initialization function';
1160:
1161: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
1162:
1163: -- Make security function fail
1164: RAISE;
1165:
1168: -- Log error message into edw_error_log table
1169:
1170: x_message := 'Predicate length exceeds maximum allowable limit.';
1171:
1172: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
1173:
1174: -- Make security function fail
1175: RAISE;
1176:
1182:
1183: x_message := 'Oracle error occured.
1184: Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText ;
1185:
1186: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
1187:
1188: -- Make security function fail
1189: RAISE;
1190: