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 490: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;

486: pragma exception_init(e_numOrValueError, -06502);
487:
488:
489: begin
490: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
491: l_logPROC := l_logSTMT or (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level);
492:
493: if ( l_logPROC ) then
494: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'BEGIN');

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

487:
488:
489: begin
490: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
491: l_logPROC := l_logSTMT or (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level);
492:
493: if ( l_logPROC ) then
494: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'BEGIN');
495: end if;

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

608: return l_ret_value;
609:
610: exception
611: when e_wrongNLSparam then
612: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
613: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-12702!!');
614: end if;
615: return to_char(p_date, l_date_format);
616:

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

614: end if;
615: return to_char(p_date, l_date_format);
616:
617: when e_unrecognizedFormat then
618: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
619: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-1821!!');
620: end if;
621: return to_char(p_date, null, 'NLS_CALENDAR = '''||l_nls_calendar||'''');
622:

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

620: end if;
621: return to_char(p_date, null, 'NLS_CALENDAR = '''||l_nls_calendar||'''');
622:
623: when e_numOrValueError then
624: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
625: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-06502!!');
626: end if;
627: return to_char(p_date);
628:

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

628:
629: when others then
630: l_errCode := SQLCODE;
631: l_err := substr(sqlerrm,1,3500);
632: if (wf_log_pkg.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
633: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION '||l_errCode ||' - '|| l_err );
634: end if;
635: return to_char(p_date);
636: end GetCalendarDate;