300:
301:
302: FUNCTION Check_Error_Message(p_Error_Message IN VARCHAR2)
303: RETURN BOOLEAN IS
304: l_error_message bsc_message_logs.message%TYPE;
305: l_Is_Error BOOLEAN;
306:
307: CURSOR C_ERROR(l_source VARCHAR2) IS
308: SELECT message
306:
307: CURSOR C_ERROR(l_source VARCHAR2) IS
308: SELECT message
309: INTO l_error_message
310: FROM bsc_message_logs
311: WHERE type = 0
312: AND UPPER(SOURCE) = UPPER(l_source)
313: AND LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID;
314: