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_NOTIFICATION

Line 1: package body WF_NOTIFICATION_UTIL as

1: package body WF_NOTIFICATION_UTIL as
2: /* $Header: wfntfb.pls 120.43.12010000.27 2009/02/26 01:39:33 alepe ship $ */
3:
4: -- flag to initialize default NLS values
5: g_wfcore_nls_set boolean := false;

Line 8: g_plsqlName varchar2(35) := 'wf.plsql.WF_NOTIFICATION_UTIL.';

4: -- flag to initialize default NLS values
5: g_wfcore_nls_set boolean := false;
6:
7: -- logging variable
8: g_plsqlName varchar2(35) := 'wf.plsql.WF_NOTIFICATION_UTIL.';
9:
10: -- <7578908> to handle timestamp in getCalendarDate()
11: g_time_format varchar2(64) := ' HH24:MI:SS';
12:

Line 33: update WF_NOTIFICATION_ATTRIBUTES

29: wf_core.raise('WFSQL_ARGS');
30: end if;
31:
32: -- Update attribute value
33: update WF_NOTIFICATION_ATTRIBUTES
34: set EVENT_VALUE = avalue
35: where NOTIFICATION_ID = nid and NAME = aname;
36:
37: if (SQL%NOTFOUND) then

Line 45: wf_core.context('Wf_Notification_Util', 'SetAttrEvent', to_char(nid), aname);

41: end if;
42:
43: exception
44: when others then
45: wf_core.context('Wf_Notification_Util', 'SetAttrEvent', to_char(nid), aname);
46: raise;
47: end SetAttrEvent;
48:
49: -- GetAttrEvent Bug# 2376197

Line 72: from WF_NOTIFICATION_ATTRIBUTES WNA

68:
69: begin
70: select WNA.EVENT_VALUE
71: into lvalue
72: from WF_NOTIFICATION_ATTRIBUTES WNA
73: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
74: exception
75: when no_data_found then
76: wf_core.token('NID', to_char(nid));

Line 83: wf_core.context('Wf_Notification_Util', 'GetAttrEvent', to_char(nid), aname);

79: end;
80: return(lvalue);
81: exception
82: when others then
83: wf_core.context('Wf_Notification_Util', 'GetAttrEvent', to_char(nid), aname);
84: raise;
85: end GetAttrEvent;
86:
87:

Line 114: l_api varchar2(50):='wf.plsql.wf_notification_util.denormalize_rf';

110: l_orig_calendar varchar2(64);
111: l_orig_numeric_characters varchar2(64);
112: l_orig_sort varchar2(64);
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);

Line 143: -- Wf_Notification.GetNLSLanguage(l_orig_lang,l_orig_terr,l_orig_chrs); commenting out

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
144: wf_notification_util.getNLSContext(p_nlsLanguage=>l_orig_lang, p_nlsTerritory =>l_orig_terr, p_nlsCode => l_orig_chrs,
145: p_nlsDateFormat =>l_orig_date_format, p_nlsDateLanguage =>l_orig_date_language,
146: p_nlsNumericCharacters =>l_orig_numeric_characters, p_nlsSort =>l_orig_sort,
147: p_nlsCalendar =>l_orig_calendar);

Line 144: wf_notification_util.getNLSContext(p_nlsLanguage=>l_orig_lang, p_nlsTerritory =>l_orig_terr, p_nlsCode => l_orig_chrs,

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
144: wf_notification_util.getNLSContext(p_nlsLanguage=>l_orig_lang, p_nlsTerritory =>l_orig_terr, p_nlsCode => l_orig_chrs,
145: p_nlsDateFormat =>l_orig_date_format, p_nlsDateLanguage =>l_orig_date_language,
146: p_nlsNumericCharacters =>l_orig_numeric_characters, p_nlsSort =>l_orig_sort,
147: p_nlsCalendar =>l_orig_calendar);
148:

Line 150: -- Wf_Notification.SetNLSLanguage(l_language,l_territory); commenting out

146: p_nlsNumericCharacters =>l_orig_numeric_characters, p_nlsSort =>l_orig_sort,
147: p_nlsCalendar =>l_orig_calendar);
148:
149: -- <7514495>
150: -- Wf_Notification.SetNLSLanguage(l_language,l_territory); commenting out
151: wf_notification_util.SetNLSContext(p_nid=> l_nid, p_nlsLanguage =>l_language, p_nlsTerritory =>l_territory,
152: p_nlsDateFormat =>l_nls_date_format, p_nlsDateLanguage => l_nls_date_language,
153: p_nlsNumericCharacters => l_nls_numeric_characters, p_nlsSort =>l_nls_sort,
154: p_nlsCalendar => l_nls_calendar);

Line 151: wf_notification_util.SetNLSContext(p_nid=> l_nid, p_nlsLanguage =>l_language, p_nlsTerritory =>l_territory,

147: p_nlsCalendar =>l_orig_calendar);
148:
149: -- <7514495>
150: -- Wf_Notification.SetNLSLanguage(l_language,l_territory); commenting out
151: wf_notification_util.SetNLSContext(p_nid=> l_nid, p_nlsLanguage =>l_language, p_nlsTerritory =>l_territory,
152: p_nlsDateFormat =>l_nls_date_format, p_nlsDateLanguage => l_nls_date_language,
153: p_nlsNumericCharacters => l_nls_numeric_characters, p_nlsSort =>l_nls_sort,
154: p_nlsCalendar => l_nls_calendar);
155:

Line 157: Wf_Notification.Denormalize_Notification(l_nid);

153: p_nlsNumericCharacters => l_nls_numeric_characters, p_nlsSort =>l_nls_sort,
154: p_nlsCalendar => l_nls_calendar);
155:
156: g_allowDeferDenormalize:=false;
157: Wf_Notification.Denormalize_Notification(l_nid);
158:
159: -- reset the existing session language
160: -- WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr); <7514495> commenting out
161: wf_notification_util.SetNLSContext(p_nlsLanguage =>l_orig_lang, p_nlsTerritory =>l_orig_terr,

Line 160: -- WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr); <7514495> commenting out

156: g_allowDeferDenormalize:=false;
157: Wf_Notification.Denormalize_Notification(l_nid);
158:
159: -- reset the existing session language
160: -- WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr); <7514495> commenting out
161: wf_notification_util.SetNLSContext(p_nlsLanguage =>l_orig_lang, p_nlsTerritory =>l_orig_terr,
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);

Line 161: wf_notification_util.SetNLSContext(p_nlsLanguage =>l_orig_lang, p_nlsTerritory =>l_orig_terr,

157: Wf_Notification.Denormalize_Notification(l_nid);
158:
159: -- reset the existing session language
160: -- WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr); <7514495> commenting out
161: wf_notification_util.SetNLSContext(p_nlsLanguage =>l_orig_lang, p_nlsTerritory =>l_orig_terr,
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:

Line 173: wf_core.context('Wf_Notification_util', 'Denormalize_Rf', to_char(l_nid));

169:
170: return 'SUCCESS';
171: exception
172: when others then
173: wf_core.context('Wf_Notification_util', 'Denormalize_Rf', to_char(l_nid));
174: wf_event.setErrorInfo(p_event, 'ERROR');
175: return 'ERROR';
176: end denormalize_rf;
177:

Line 229: l_api varchar2(50):='wf.plsql.wf_notification_util.getNLSContext';

225: is
226: l_envLangTerritory varchar2(240);
227: l_uPos number; -- position for '_'
228: l_dotPos number; -- position for '.'
229: l_api varchar2(50):='wf.plsql.wf_notification_util.getNLSContext';
230:
231: begin
232: -- ensure that wf_core NLS defaults are in fact set
233: if (g_wfcore_nls_set = false) then

Line 301: l_api varchar2(50):='wf.plsql.wf_notification_util.SetNLSContext';

297: is
298:
299: -- dependes on NLS_LANGUAGE
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');

Line 351: wf_core.context('Wf_Notification_Util', 'SetNLSContext',

347: SetCurrentNID(p_nid);
348:
349: exception
350: when others then
351: wf_core.context('Wf_Notification_Util', 'SetNLSContext',
352: p_nid,
353: p_nlsLanguage ,
354: p_nlsTerritory ,
355: p_nlsDateFormat ,

Line 493: if (wf_notification_util.G_NID > 0 and wf_notification_util.G_NID = p_nid) then

489: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, p_mod, 'BEGIN');
490: end if;
491:
492: -- if the call is from mailer, use the preferences from global variables
493: if (wf_notification_util.G_NID > 0 and wf_notification_util.G_NID = p_nid) then
494: l_date_format := wf_notification_util.G_NLS_DATE_FORMAT;
495: l_nls_calendar := wf_notification_util.G_NLS_CALENDAR;
496: else
497: l_user := wfa_sec.GetUser();

Line 494: l_date_format := wf_notification_util.G_NLS_DATE_FORMAT;

490: end if;
491:
492: -- if the call is from mailer, use the preferences from global variables
493: if (wf_notification_util.G_NID > 0 and wf_notification_util.G_NID = p_nid) then
494: l_date_format := wf_notification_util.G_NLS_DATE_FORMAT;
495: l_nls_calendar := wf_notification_util.G_NLS_CALENDAR;
496: else
497: l_user := wfa_sec.GetUser();
498: if (l_user is null) then

Line 495: l_nls_calendar := wf_notification_util.G_NLS_CALENDAR;

491:
492: -- if the call is from mailer, use the preferences from global variables
493: if (wf_notification_util.G_NID > 0 and wf_notification_util.G_NID = p_nid) then
494: l_date_format := wf_notification_util.G_NLS_DATE_FORMAT;
495: l_nls_calendar := wf_notification_util.G_NLS_CALENDAR;
496: else
497: l_user := wfa_sec.GetUser();
498: if (l_user is null) then
499: -- use default values

Line 576: end WF_NOTIFICATION_UTIL;

572: return to_char(p_date);
573: end GetCalendarDate;
574:
575: -- package body end.
576: end WF_NOTIFICATION_UTIL;
577:
578:
579: