[Home] [Help]
140: * p_msg_sev Raised Alert severity.
141: */
142: FUNCTION IS_ALERTING_ENABLED(p_msg_sev IN VARCHAR2) return boolean is
143: l_retu boolean;
144: l_sys_al_level varchar2(80); /*fnd_profile_options.PROFILE_OPTION_NAME%TYPE*/
145: l_alertCount number;
146: l_pr_al_count number;
147: begin
148: l_retu := FALSE;
149: if (p_msg_sev IS NULL)THEN
150: return l_retu;
151: end if;
152:
153: l_sys_al_level := fnd_profile.value('OAM_ENABLE_SYSTEM_ALERT');
154: DEBUG('IS_ALERTING_ENABLED::l_sys_al_level' || l_sys_al_level || ' p_msg_sev' || p_msg_sev );
155: --Check Valid profile value
156: if ((l_sys_al_level <> '00_NONE') AND (l_sys_al_level <> '10_CRITICAL')
157: AND(l_sys_al_level <> '20_ERROR') AND (l_sys_al_level <> '30_WARNING'))THEN
169: DEBUG('IS_ALERTING_ENABLED::p_msg_sev' || p_msg_sev);
170:
171:
172: if (l_sys_al_level >= p_msg_sev)THEN
173: l_pr_al_count := fnd_profile.value('OAM_MAX_SYSTEM_ALERT');
174: select count(*) into l_alertCount from FND_LOG_UNIQUE_EXCEPTIONS
175: where STATUS = 'N';
176: DEBUG('IS_ALERTING_ENABLED: can log msg Sevrity lower Next chek:l_pr_al_count' || l_pr_al_count);
177: DEBUG('IS_ALERTING_ENABLED::l_alertCount' || l_alertCount);
319: if (USER_ID IS NULL) then
320: if SELF_INITED_X then
321: CONTEXT_OUT(2).a_val := USER_ID_X;
322: else
323: CONTEXT_OUT(2).a_val := fnd_profile.value('USER_ID');
324: end if;
325: else
326: CONTEXT_OUT(2).a_val := USER_ID;
327: end if;
659: where encoded_message = l_enc_msg
660: and status in ('N', 'O');
661:
662: /** Check if limit for occrrences has been reached **/
663: l_max_occ_count := fnd_profile.value('OAM_MAX_OCCURRENCES_PER_ALERT');
664: if(l_occ_count >= l_max_occ_count) then
665: rollback;
666: DEBUG('Not Logging occ l_occ_count = l_max_occ_count'|| l_max_occ_count);
667: return FALSE;
902: begin
903:
904: if ( AFLOG_ENABLED_X = TRUE) then
905:
906: l_buffer_size := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_SIZE'));
907: l_buffer_mode := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_MODE'));
908:
909: if ( l_buffer_size > -1 ) then
910: AFLOG_BUFFER_SIZE_X := l_buffer_size;
903:
904: if ( AFLOG_ENABLED_X = TRUE) then
905:
906: l_buffer_size := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_SIZE'));
907: l_buffer_mode := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_MODE'));
908:
909: if ( l_buffer_size > -1 ) then
910: AFLOG_BUFFER_SIZE_X := l_buffer_size;
911: end if;
1918: SESSION_ID_X := SESSION_ID;
1919: end if;
1920:
1921: if(USER_ID is NULL) then
1922: USER_ID_X := to_number(FND_PROFILE.VALUE('USER_ID'));
1923: else
1924: USER_ID_X := USER_ID;
1925: end if;
1926:
1928: USER_ID_X := -1;
1929: end if;
1930:
1931:
1932: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1933: AFLOG_ENABLED_X := TRUE;
1934: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1935: 255);
1936: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1930:
1931:
1932: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1933: AFLOG_ENABLED_X := TRUE;
1934: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1935: 255);
1936: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1937: AFLOG_MODULE_X := UPPER(SUBSTR(
1938: FND_PROFILE.VALUE('AFLOG_MODULE'),
1932: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1933: AFLOG_ENABLED_X := TRUE;
1934: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1935: 255);
1936: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1937: AFLOG_MODULE_X := UPPER(SUBSTR(
1938: FND_PROFILE.VALUE('AFLOG_MODULE'),
1939: 1, 2000));
1940: else
1934: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1935: 255);
1936: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1937: AFLOG_MODULE_X := UPPER(SUBSTR(
1938: FND_PROFILE.VALUE('AFLOG_MODULE'),
1939: 1, 2000));
1940: else
1941: AFLOG_ENABLED_X := FALSE;
1942: AFLOG_FILENAME_X := NULL;