eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_NOTIFICATION_UTIL dependencies on WF_LOG_PKG

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 118: wf_log_pkg.string(wf_log_pkg.level_procedure,l_api,'BEGIN, p_subscription_guid='||p_subscription_guid);

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');
122: l_territory := p_event.GetValueForParameter('TERRITORY');

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 133: wf_log_pkg.string(wf_log_pkg.level_statement,l_api,'Nid: '||l_nid);

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);
137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,

Line 134: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Lang: '||l_language||' Territory: '||l_territory);

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);
137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
138: 'nls_calendar: '||l_nls_calendar||', nls_numeric_characters: '||l_nls_numeric_characters);

Line 135: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,

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);
137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
138: 'nls_calendar: '||l_nls_calendar||', nls_numeric_characters: '||l_nls_numeric_characters);
139: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,

Line 137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,

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);
137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
138: 'nls_calendar: '||l_nls_calendar||', nls_numeric_characters: '||l_nls_numeric_characters);
139: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
140: 'nls_sort: '||l_nls_sort||', nls_currency: '||l_nls_currency);
141: end if;

Line 139: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,

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);
137: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
138: 'nls_calendar: '||l_nls_calendar||', nls_numeric_characters: '||l_nls_numeric_characters);
139: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,
140: 'nls_sort: '||l_nls_sort||', nls_currency: '||l_nls_currency);
141: end if;
142: -- <7514495>
143: -- Wf_Notification.GetNLSLanguage(l_orig_lang,l_orig_terr,l_orig_chrs); commenting out

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 167: wf_log_pkg.string(wf_log_pkg.level_procedure,l_api,'END');

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';
171: exception

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 262: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Returning following values');

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);
266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);

Line 263: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsLanguage: '||p_nlsLanguage||', p_nlsTerritory: '||p_nlsTerritory);

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);
266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
267: end if;

Line 264: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsCode: '||p_nlsCode||', p_nlsDateFormat: '||p_nlsDateFormat);

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);
266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
267: end if;
268: exception

Line 265: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsDateLanguage: '||p_nlsDateLanguage||', p_nlsSort: '||p_nlsSort);

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);
266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
267: end if;
268: exception
269: WHEN OTHERS THEN

Line 266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);

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);
266: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
267: end if;
268: exception
269: WHEN OTHERS THEN
270: raise;

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 305: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'Parameters passed');

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);
309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);

Line 306: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsLanguage: '||p_nlsLanguage||', p_nlsTerritory: '||p_nlsTerritory);

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);
309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
310: end if;

Line 307: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nid: '||p_nid||', p_nlsDateFormat: '||p_nlsDateFormat);

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);
309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
310: end if;
311: -- As nls_date_language may come as lang. code e.g. US, KO

Line 308: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsDateLanguage: '||p_nlsDateLanguage||', p_nlsSort: '||p_nlsSort);

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);
309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
310: end if;
311: -- As nls_date_language may come as lang. code e.g. US, KO
312: if( (p_nlsDateLanguage IS NOT NULL) ) then

Line 309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);

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);
309: wf_log_pkg.string(wf_log_pkg.level_statement, l_api,'p_nlsNumericCharacters: '||p_nlsNumericCharacters||', p_nlsCalendar: '||p_nlsCalendar);
310: end if;
311: -- As nls_date_language may come as lang. code e.g. US, KO
312: if( (p_nlsDateLanguage IS NOT NULL) ) then
313: if(isLanguageInstalled(p_nlsDateLanguage) = FALSE ) then

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 494: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, '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;
496:
497: -- if the call is from mailer, use the preferences from global variables
498: if (wf_notification_util.G_NID > 0 and wf_notification_util.G_NID = p_nid) then

Line 529: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'before conversion, p_date_format: '||p_date_format);

525:
526: end if;
527:
528: if ( l_logSTMT ) then
529: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'before conversion, p_date_format: '||p_date_format);
530: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_date_format (before adding tstamp): '||l_date_format);
531: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_nls_calendar: '||l_nls_calendar);
532: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'p_date: '||to_char(p_date,'DD-MON-RR HH24:MI:SS'));
533: end if;

Line 530: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_date_format (before adding tstamp): '||l_date_format);

526: end if;
527:
528: if ( l_logSTMT ) then
529: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'before conversion, p_date_format: '||p_date_format);
530: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_date_format (before adding tstamp): '||l_date_format);
531: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_nls_calendar: '||l_nls_calendar);
532: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'p_date: '||to_char(p_date,'DD-MON-RR HH24:MI:SS'));
533: end if;
534:

Line 531: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_nls_calendar: '||l_nls_calendar);

527:
528: if ( l_logSTMT ) then
529: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'before conversion, p_date_format: '||p_date_format);
530: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_date_format (before adding tstamp): '||l_date_format);
531: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_nls_calendar: '||l_nls_calendar);
532: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'p_date: '||to_char(p_date,'DD-MON-RR HH24:MI:SS'));
533: end if;
534:
535: l_date_format := nvl(p_date_format, l_date_format);

Line 532: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'p_date: '||to_char(p_date,'DD-MON-RR HH24:MI:SS'));

528: if ( l_logSTMT ) then
529: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'before conversion, p_date_format: '||p_date_format);
530: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_date_format (before adding tstamp): '||l_date_format);
531: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'l_nls_calendar: '||l_nls_calendar);
532: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod, 'p_date: '||to_char(p_date,'DD-MON-RR HH24:MI:SS'));
533: end if;
534:
535: l_date_format := nvl(p_date_format, l_date_format);
536: if (p_addTime) and (instr(upper(l_date_format), 'HH') = 0) then

Line 540: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod

536: if (p_addTime) and (instr(upper(l_date_format), 'HH') = 0) then
537: l_date_format := l_date_format|| g_time_format;
538:
539: if ( l_logSTMT ) then
540: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod
541: , 'l_date_format (after adding tstamp): '||l_date_format);
542: end if;
543: end if;
544:

Line 570: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod

566:
567: l_date_format := replace(l_date_format,'MON','FMMONFM');
568:
569: if ( l_logSTMT ) then
570: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod
571: , 'returning to_char(to_date('''||to_char(p_date,'DD-MON-RRRR HH24:MI:SS')||
572: ''',''DD-MON-RRRR HH24:MI:SS''), '''||l_date_format||''', ''NLS_CALENDAR = '''''||
573: l_nls_calendar||'''''''); ');
574: end if;

Line 584: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod

580: elsif (sys_context('USERENV','LANG') = 'AR' and
581: l_nls_territory not in ('JORDAN', 'LEBANON', 'SYRIA', 'IRAQ')) then
582:
583: if ( l_logSTMT ) then
584: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod
585: , 'returning to_char(to_date('''||to_char(p_date,'DD-MON-RRRR HH24:MI:SS')||
586: ''',''DD-MON-RRRR HH24:MI:SS''), '''||l_date_format||''', ''NLS_DATE_LANGUAGE='''''||
587: 'EGYPTIAN''''''); ');
588: end if;

Line 595: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod

591:
592: -- All Other CASES
593: else
594: if ( l_logSTMT ) then
595: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, p_mod
596: , 'returning to_char(to_date('''||to_char(p_date,'DD-MON-RRRR HH24:MI:SS')||
597: ''',''DD-MON-RRRR HH24:MI:SS''), '''||l_date_format||''' );');
598: end if;
599:

Line 604: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'Returning value '|| l_ret_value );

600: l_ret_value := to_char(p_date, l_date_format);
601: end if;
602:
603: if ( l_logSTMT OR l_logPROC) then
604: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'Returning value '|| l_ret_value );
605: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'END');
606: end if;
607:
608: return l_ret_value;

Line 605: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'END');

601: end if;
602:
603: if ( l_logSTMT OR l_logPROC) then
604: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'Returning value '|| l_ret_value );
605: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'END');
606: end if;
607:
608: return l_ret_value;
609:

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 613: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-12702!!');

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:
617: when e_unrecognizedFormat then

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 619: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-1821!!');

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:
623: when e_numOrValueError then

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 625: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION ora-06502!!');

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:
629: when others then

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;

Line 633: wf_log_pkg.String(wf_log_pkg.LEVEL_EXCEPTION, p_mod, 'EXCEPTION '||l_errCode ||' - '|| l_err );

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;
637: