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 dependencies on WF_NOTIFICATION_UTIL

Line 363: -- l_format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided and matches

359: end;
360:
361: if (l_type = 'DATE') then
362: -- now as date format we use the first non-null value of:
363: -- l_format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided and matches
364: -- wf_notification_util.G_NID), session user's WFDS preference, wf_core.nls_date_format.
365: l_text := wf_notification_util.GetCalendarDate(nid, l_datev, l_format, false);
366: elsif (l_type = 'NUMBER') then
367: if (l_format is null) then

Line 364: -- wf_notification_util.G_NID), session user's WFDS preference, wf_core.nls_date_format.

360:
361: if (l_type = 'DATE') then
362: -- now as date format we use the first non-null value of:
363: -- l_format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided and matches
364: -- wf_notification_util.G_NID), session user's WFDS preference, wf_core.nls_date_format.
365: l_text := wf_notification_util.GetCalendarDate(nid, l_datev, l_format, false);
366: elsif (l_type = 'NUMBER') then
367: if (l_format is null) then
368: l_text := to_char(l_numberv);

Line 365: l_text := wf_notification_util.GetCalendarDate(nid, l_datev, l_format, false);

361: if (l_type = 'DATE') then
362: -- now as date format we use the first non-null value of:
363: -- l_format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided and matches
364: -- wf_notification_util.G_NID), session user's WFDS preference, wf_core.nls_date_format.
365: l_text := wf_notification_util.GetCalendarDate(nid, l_datev, l_format, false);
366: elsif (l_type = 'NUMBER') then
367: if (l_format is null) then
368: l_text := to_char(l_numberv);
369: else

Line 1601: value := wf_notification_util.getCalendarDate(nid,

1597: -- end if;
1598:
1599: -- <>: bug8430385: Also Removed restrict_references(WNDS) pragma
1600: -- from GETURLTEXT, GETSHORTTEXT and getShortBody etc..
1601: value := wf_notification_util.getCalendarDate(nid,
1602: not_attr_row.date_value,
1603: not_attr_row.format, false);
1604:
1605: elsif (not_attr_row.type = 'FORM') then

Line 1933: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided

1929: value := to_char(not_attr_row.number_value, not_attr_row.format);
1930: end if;
1931: elsif (not_attr_row.type = 'DATE') then
1932: -- now as date format we use the first non-null value of:
1933: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1934: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1935: -- and wf_core.nls_date_format.
1936: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1937: , not_attr_row.format, false);

Line 1934: -- and matches wf_notification_util.G_NID), session user's WFDS preference,

1930: end if;
1931: elsif (not_attr_row.type = 'DATE') then
1932: -- now as date format we use the first non-null value of:
1933: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1934: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1935: -- and wf_core.nls_date_format.
1936: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1937: , not_attr_row.format, false);
1938:

Line 1936: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value

1932: -- now as date format we use the first non-null value of:
1933: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1934: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1935: -- and wf_core.nls_date_format.
1936: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1937: , not_attr_row.format, false);
1938:
1939: elsif (not_attr_row.type = 'FORM') then
1940: -- FORM is display_name (function), with parameters of function

Line 2313: lvalue := wf_notification_util.GetCalendarDate(nid, l_valDate, format, false);

2309: select DATE_VALUE into l_valDate
2310: from WF_NOTIFICATION_ATTRIBUTES WNA
2311: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2312:
2313: lvalue := wf_notification_util.GetCalendarDate(nid, l_valDate, format, false);
2314:
2315: else
2316: -- VARCHAR2, LOOKUP, FORM, or URL type.
2317: select WNA.TEXT_VALUE

Line 2562: l_charcheck := wf_notification_util.CheckIllegalChar(procname);

2558: end if;
2559:
2560: -- ### Review Note 4
2561:
2562: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
2563: --Throw the Illegal exception when the check fails
2564:
2565: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2566: wf_log_pkg.string2(wf_log_pkg.level_statement,

Line 3127: l_charcheck := WF_NOTIFICATION_UTIL.CheckIllegalChar(callback);

3123: -- by that process.
3124: --
3125: if (callback is not null) then
3126: -- ### Review Note 3 - private function
3127: l_charcheck := WF_NOTIFICATION_UTIL.CheckIllegalChar(callback);
3128:
3129:
3130: -- BINDVAR_SCAN_IGNORE
3131: sqlbuf := 'begin '||callback||

Line 3783: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

3779: -- Open and parse cursor for dynamic sql for getting attr values
3780: -- Bug 2376033 added event value in call to CB
3781: if (callback is not null) then
3782: -- ### Review Note 2
3783: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
3784: --Throw the Illegal exception when the check fails
3785:
3786:
3787: -- BINDVAR_SCAN_IGNORE

Line 3847: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

3843: else
3844: -- Bug 2580807 call with original signature for backward
3845: -- compatibility
3846: -- ### Review Note 2 - callback is from table
3847: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
3848: --Throw the Illegal exception when the check fails
3849:
3850:
3851: -- BINDVAR_SCAN_IGNORE

Line 4418: l_charcheck := wf_notification_util.CheckIllegalChar(cb);

4414: tvalue := new_role;
4415: nvalue := nid;
4416: -- ### Review Note 2 - cb is from table
4417: -- BINDVAR_SCAN_IGNORE
4418: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
4419: --Throw the Illegal exception when the check fails
4420:
4421:
4422: sqlbuf := 'begin '||cb||

Line 4981: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

4977:
4978: -- Open dynamic sql cursor for callback call
4979: -- ### Review Note 2 - callback is from table
4980: -- Check for bug#3827935
4981: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
4982: --Throw the Illegal exception when the check fails
4983:
4984:
4985: -- BINDVAR_SCAN_IGNORE

Line 5769: l_charcheck := wf_notification_util.CheckIllegalChar(procname);

5765: FALSE, FALSE, 'text/plain');
5766: end if;
5767:
5768: -- ### Review Note 1
5769: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
5770: --Throw the Illegal exception when the check fails
5771:
5772: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5773: wf_log_pkg.string2(wf_log_pkg.level_statement,

Line 6002: wf_notification_util.getNLSContext( p_nlsLanguage=> GetNLSLanguage.language,

5998: -- GetNLSLanguage.language := Wf_Notification.nls_language;
5999: -- GetNLSLanguage.territory := Wf_Notification.nls_territory;
6000: -- GetNLSLanguage.charset := Wf_Notification.nls_charset;
6001:
6002: wf_notification_util.getNLSContext( p_nlsLanguage=> GetNLSLanguage.language,
6003: p_nlsTerritory => GetNLSLanguage.territory,
6004: p_nlsCode => GetNLSLanguage.charset,
6005: p_nlsDateFormat => l_nlsDateFormat,
6006: p_nlsDateLanguage => l_nlsDateLang,

Line 6040: wf_notification_util.SetNLSContext( -- p_nid ,

6036: -- -- update cache
6037: -- Wf_Notification.nls_language := p_language;
6038: -- Wf_Notification.nls_territory := p_territory;
6039:
6040: wf_notification_util.SetNLSContext( -- p_nid ,
6041: p_nlsLanguage => l_language,
6042: p_nlsTerritory => p_territory
6043: -- ok not to pass next parameters
6044: -- as fnd_global.set_nls_context won't set

Line 6116: l_canDefer := wf_notification_util.g_allowDeferDenormalize;

6112: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6113: end if;
6114:
6115: -- 8286459. Get value, and always reset flag;
6116: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6117: wf_notification_util.g_allowDeferDenormalize := true;
6118:
6119: -- <7720908>
6120: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode

Line 6117: wf_notification_util.g_allowDeferDenormalize := true;

6113: end if;
6114:
6115: -- 8286459. Get value, and always reset flag;
6116: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6117: wf_notification_util.g_allowDeferDenormalize := true;
6118:
6119: -- <7720908>
6120: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode
6121: , l_orig_nlsDateFormat, l_orig_nlsDateLang

Line 6120: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode

6116: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6117: wf_notification_util.g_allowDeferDenormalize := true;
6118:
6119: -- <7720908>
6120: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode
6121: , l_orig_nlsDateFormat, l_orig_nlsDateLang
6122: , l_orig_nlsNumChars, l_orig_nlsSort, l_orig_nlsCalendar);
6123:
6124: if (l_orig_nlsCalendar is null) then

Line 6643: l_charcheck := wf_notification_util.CheckIllegalChar(cb);

6639: tvalue := myusername;
6640: nvalue := nid;
6641: -- ### Review Note 2 - cb is from table
6642: --Check for bug#3827935
6643: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
6644: --Throw the Illegal exception when the check fails
6645:
6646:
6647: -- BINDVAR_SCAN_IGNORE

Line 6795: l_charcheck := wf_notification_util.CheckIllegalChar(cb);

6791: nvalue := nid;
6792: g_context_new_role := l_question_role;
6793: -- ### Review Note 2 - cb is from table
6794: -- Check for bug#3827935
6795: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
6796: --Throw the Illegal exception when the check fails
6797:
6798: -- BINDVAR_SCAN_IGNORE
6799: sqlbuf := 'begin '||cb||

Line 7036: l_charcheck := wf_notification_util.CheckIllegalChar(l_callback_function);

7032:
7033: if (l_callback_function is not null) then
7034: tvalue := l_session_user;
7035: nvalue := p_nid;
7036: l_charcheck := wf_notification_util.CheckIllegalChar(l_callback_function);
7037: l_anon_block := 'begin '||l_callback_function||
7038: '(:p1, :p2, :p3, :p4, :p5, :p6, :p7); end;';
7039:
7040: execute immediate l_anon_block using

Line 7600: l_charcheck := wf_notification_util.CheckIllegalChar(cb);

7596: tvalue := myusername;
7597: nvalue := nid;
7598: -- ### Review Note 2 - cb is from table
7599: -- Check for bug#3827935
7600: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
7601: --Throw the Illegal exception when the check fails
7602:
7603: -- BINDVAR_SCAN_IGNORE
7604: sqlbuf := 'begin '||cb||

Line 8350: l_comm_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_comm_rec.h_action_date);

8346: j := j+1;
8347:
8348: -- Bug 9173224, Added by David on March 02,2010
8349: -- Convert server datetime to local datetime according to the client timezone.
8350: l_comm_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_comm_rec.h_action_date);
8351:
8352: if (p_display_type = wf_notification.doc_html) then
8353: --
8354: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);

Line 8354: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);

8350: l_comm_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_comm_rec.h_action_date);
8351:
8352: if (p_display_type = wf_notification.doc_html) then
8353: --
8354: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8355: else
8356: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8357: end if;
8358:

Line 8356: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);

8352: if (p_display_type = wf_notification.doc_html) then
8353: --
8354: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8355: else
8356: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8357: end if;
8358:
8359: j := j+1;
8360:

Line 8441: l_ntf_hist_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_ntf_hist_rec.h_action_date);

8437: j := j+1;
8438:
8439: -- Bug 9173224, Added by David on March 02,2010
8440: -- Convert server datetime to local datetime according to the client timezone.
8441: l_ntf_hist_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_ntf_hist_rec.h_action_date);
8442:
8443: if (p_display_type = wf_notification.doc_html) then
8444: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8445: else

Line 8444: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);

8440: -- Convert server datetime to local datetime according to the client timezone.
8441: l_ntf_hist_rec.h_action_date := wf_notification_util.GetLocalDateTime(l_ntf_hist_rec.h_action_date);
8442:
8443: if (p_display_type = wf_notification.doc_html) then
8444: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8445: else
8446: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8447: end if;
8448:

Line 8446: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);

8442:
8443: if (p_display_type = wf_notification.doc_html) then
8444: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8445: else
8446: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8447: end if;
8448:
8449: j := j+1;
8450:

Line 8715: l_charcheck := wf_notification_util.CheckIllegalChar(procname);

8711: end if;
8712:
8713: -- ### Review Note 1
8714: -- Check for bug#3827935
8715: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
8716: --Throw the Illegal exception when the check fails
8717:
8718: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8719: wf_log_pkg.string2(wf_log_pkg.level_statement,

Line 10017: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

10013: tvalue := respond2.responder;
10014: nvalue := nid;
10015: -- ### Review Note 2 - callback is from table
10016: -- Check for bug#3827935
10017: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
10018: --Throw the Illegal exception when the check fails
10019:
10020:
10021: -- BINDVAR_SCAN_IGNORE

Line 10111: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

10107: --
10108: -- Open dynamic sql cursor for SET callback calls.
10109: --
10110: -- ### Review Note 2 - callback is from table
10111: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
10112: --Throw the Illegal exception when the check fails
10113:
10114:
10115: -- BINDVAR_SCAN_IGNORE

Line 10311: l_charcheck := wf_notification_util.CheckIllegalChar(callback);

10307: wf_core.token('NID', to_char(p_nid));
10308: wf_core.raise('WFNTF_NID');
10309: end;
10310:
10311: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
10312:
10313: sqlbuf := 'begin '||callback||
10314: '(:p1, :p2, :p3, :p4, :p5, :p6, :p7); end;';
10315: execute immediate sqlbuf using