APPS.WF_NOTIFICATION_UTIL dependencies on FND_LOG

Line 117: if (wf_log_pkg.level_procedure>= fnd_log.g_current_runtime_level) then

113: l_orig_currency varchar2(64);
114: l_api varchar2(50):='wf.plsql.wf_notification_util.denormalize_rf';
115:
116: begin
117: if (wf_log_pkg.level_procedure>= fnd_log.g_current_runtime_level) then
118: wf_log_pkg.string(wf_log_pkg.level_procedure,l_api,'BEGIN, p_subscription_guid='||p_subscription_guid);
119: end if;
120: l_nid := p_event.GetValueForParameter('NOTIFICATION_ID');
121: l_language := p_event.GetValueForParameter('LANGUAGE');

Line 132: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

128: l_nls_numeric_characters:= p_event.GetValueForParameter('NLS_NUMERIC_CHARACTERS');
129: l_nls_sort := p_event.GetValueForParameter('NLS_SORT');
130: l_nls_currency:= p_event.GetValueForParameter('NLS_CURRENCY'); --
131:
132: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
133: wf_log_pkg.string(wf_log_pkg.level_statement,l_api,'Nid: '||l_nid);
134: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Lang: '||l_language||' Territory: '||l_territory);
135: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
136: 'nls_date_format: '||l_nls_date_format||', nls_date_language: '||l_nls_date_language);

Line 166: if (wf_log_pkg.level_procedure>= fnd_log.g_current_runtime_level) then

162: p_nlsDateFormat =>l_orig_date_format, p_nlsDateLanguage => l_orig_date_language,
163: p_nlsNumericCharacters => l_orig_numeric_characters, p_nlsSort =>l_orig_sort,
164: p_nlsCalendar => l_orig_calendar);
165:
166: if (wf_log_pkg.level_procedure>= fnd_log.g_current_runtime_level) then
167: wf_log_pkg.string(wf_log_pkg.level_procedure,l_api,'END');
168: end if;
169:
170: return 'SUCCESS';

Line 261: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

257: where parameter = 'NLS_NUMERIC_CHARACTERS';
258:
259: p_nlsCalendar := GetCurrentCalendar;
260:
261: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
262: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Returning following values');
263: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsLanguage: '||p_nlsLanguage||', p_nlsTerritory: '||p_nlsTerritory);
264: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsCode: '||p_nlsCode||', p_nlsDateFormat: '||p_nlsDateFormat);
265: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsDateLanguage: '||p_nlsDateLanguage||', p_nlsSort: '||p_nlsSort);

Line 304: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

300: l_nlsDateLanguage v$nls_parameters.value%TYPE := upper(p_nlsDateLanguage);
301: l_api varchar2(50):='wf.plsql.wf_notification_util.SetNLSContext';
302:
303: begin
304: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
305: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Parameters passed');
306: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsLanguage: '||p_nlsLanguage||', p_nlsTerritory: '||p_nlsTerritory);
307: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nid: '||p_nid||', p_nlsDateFormat: '||p_nlsDateFormat);
308: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsDateLanguage: '||p_nlsDateLanguage||', p_nlsSort: '||p_nlsSort);

Line 485: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;

481: pragma exception_init(e_numOrValueError, -06502);
482:
483:
484: begin
485: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
486: l_logPROC := l_logSTMT or (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level);
487:
488: if ( l_logPROC ) then
489: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'BEGIN');

Line 486: l_logPROC := l_logSTMT or (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level);

482:
483:
484: begin
485: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
486: l_logPROC := l_logSTMT or (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level);
487:
488: if ( l_logPROC ) then
489: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'BEGIN');
490: end if;

Line 552: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

548: end if;
549:
550: exception
551: when e_wrongNLSparam then
552: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
553: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-12702!!');
554: end if;
555: return to_char(p_date, l_date_format);
556: when e_unrecognizedFormat then

Line 557: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

553: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-12702!!');
554: end if;
555: return to_char(p_date, l_date_format);
556: when e_unrecognizedFormat then
557: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
558: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-1821!!');
559: end if;
560: return to_char(p_date, null, 'NLS_CALENDAR = '''||l_nls_calendar||'''');
561: when e_numOrValueError then

Line 562: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

558: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-1821!!');
559: end if;
560: return to_char(p_date, null, 'NLS_CALENDAR = '''||l_nls_calendar||'''');
561: when e_numOrValueError then
562: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
563: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-06502!!');
564: end if;
565: return to_char(p_date);
566: when others then

Line 569: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

565: return to_char(p_date);
566: when others then
567: l_errCode := SQLCODE;
568: l_err := substr(sqlerrm,1,3500);
569: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
570: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION '||l_errCode ||' - '|| l_err );
571: end if;
572: return to_char(p_date);
573: end GetCalendarDate;