APPS.FND_LOG_REPOSITORY dependencies on FND_PROFILE

Line 144: l_sys_al_level varchar2(80); /*fnd_profile_options.PROFILE_OPTION_NAME%TYPE*/

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;

Line 153: l_sys_al_level := fnd_profile.value('OAM_ENABLE_SYSTEM_ALERT');

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

Line 173: l_pr_al_count := fnd_profile.value('OAM_MAX_SYSTEM_ALERT');

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);

Line 323: CONTEXT_OUT(2).a_val := fnd_profile.value('USER_ID');

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;

Line 685: l_max_occ_count := fnd_profile.value('OAM_MAX_OCCURRENCES_PER_ALERT');

681: where encoded_message = l_enc_msg
682: and status in ('N', 'O');
683:
684: /** Check if limit for occrrences has been reached **/
685: l_max_occ_count := fnd_profile.value('OAM_MAX_OCCURRENCES_PER_ALERT');
686: if(l_occ_count >= l_max_occ_count) then
687: rollback;
688: DEBUG('Not Logging occ l_occ_count = l_max_occ_count'|| l_max_occ_count);
689: return FALSE;

Line 928: l_buffer_size := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_SIZE'));

924: begin
925:
926: if ( AFLOG_ENABLED_X = TRUE) then
927:
928: l_buffer_size := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_SIZE'));
929: l_buffer_mode := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_MODE'));
930:
931: if ( l_buffer_size > -1 ) then
932: AFLOG_BUFFER_SIZE_X := l_buffer_size;

Line 929: l_buffer_mode := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_MODE'));

925:
926: if ( AFLOG_ENABLED_X = TRUE) then
927:
928: l_buffer_size := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_SIZE'));
929: l_buffer_mode := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_BUFFER_MODE'));
930:
931: if ( l_buffer_size > -1 ) then
932: AFLOG_BUFFER_SIZE_X := l_buffer_size;
933: end if;

Line 1971: USER_ID_X := to_number(FND_PROFILE.VALUE('USER_ID'));

1967: SESSION_ID_X := SESSION_ID;
1968: end if;
1969:
1970: if(USER_ID is NULL) then
1971: USER_ID_X := to_number(FND_PROFILE.VALUE('USER_ID'));
1972: else
1973: USER_ID_X := USER_ID;
1974: end if;
1975:

Line 1981: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then

1977: USER_ID_X := -1;
1978: end if;
1979:
1980:
1981: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1982: AFLOG_ENABLED_X := TRUE;
1983: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1984: 255);
1985: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));

Line 1983: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,

1979:
1980:
1981: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1982: AFLOG_ENABLED_X := TRUE;
1983: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1984: 255);
1985: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1986: AFLOG_MODULE_X := UPPER(SUBSTR(
1987: FND_PROFILE.VALUE('AFLOG_MODULE'),

Line 1985: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));

1981: if (SUBSTR(FND_PROFILE.VALUE('AFLOG_ENABLED'), 1, 1) = 'Y') then
1982: AFLOG_ENABLED_X := TRUE;
1983: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1984: 255);
1985: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1986: AFLOG_MODULE_X := UPPER(SUBSTR(
1987: FND_PROFILE.VALUE('AFLOG_MODULE'),
1988: 1, 2000));
1989: else

Line 1987: FND_PROFILE.VALUE('AFLOG_MODULE'),

1983: AFLOG_FILENAME_X := SUBSTR(FND_PROFILE.VALUE('AFLOG_FILENAME'), 1,
1984: 255);
1985: AFLOG_LEVEL_X := TO_NUMBER(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1986: AFLOG_MODULE_X := UPPER(SUBSTR(
1987: FND_PROFILE.VALUE('AFLOG_MODULE'),
1988: 1, 2000));
1989: else
1990: AFLOG_ENABLED_X := FALSE;
1991: AFLOG_FILENAME_X := NULL;