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 1874: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided

1870: value := to_char(not_attr_row.number_value, not_attr_row.format);
1871: end if;
1872: elsif (not_attr_row.type = 'DATE') then
1873: -- now as date format we use the first non-null value of:
1874: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1875: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1876: -- and wf_core.nls_date_format.
1877: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1878: , not_attr_row.format, false);

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

1871: end if;
1872: elsif (not_attr_row.type = 'DATE') then
1873: -- now as date format we use the first non-null value of:
1874: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1875: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1876: -- and wf_core.nls_date_format.
1877: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1878: , not_attr_row.format, false);
1879:

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

1873: -- now as date format we use the first non-null value of:
1874: -- not_attr_row.format, wf_notification_util.G_NLS_DATE_FORMAT (if nid is provided
1875: -- and matches wf_notification_util.G_NID), session user's WFDS preference,
1876: -- and wf_core.nls_date_format.
1877: value := wf_notification_util.GetCalendarDate(nid, not_attr_row.date_value
1878: , not_attr_row.format, false);
1879:
1880: elsif (not_attr_row.type = 'FORM') then
1881: -- FORM is display_name (function), with parameters of function

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

2242: select DATE_VALUE into l_valDate
2243: from WF_NOTIFICATION_ATTRIBUTES WNA
2244: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2245:
2246: lvalue := wf_notification_util.GetCalendarDate(nid, l_valDate, format, false);
2247:
2248: else
2249: -- VARCHAR2, LOOKUP, FORM, or URL type.
2250: select WNA.TEXT_VALUE

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

2492: end if;
2493:
2494: -- ### Review Note 4
2495:
2496: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
2497: --Throw the Illegal exception when the check fails
2498:
2499: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2500: wf_log_pkg.string2(wf_log_pkg.level_statement,

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

3037: -- by that process.
3038: --
3039: if (callback is not null) then
3040: -- ### Review Note 3 - private function
3041: l_charcheck := WF_NOTIFICATION_UTIL.CheckIllegalChar(callback);
3042:
3043:
3044: -- BINDVAR_SCAN_IGNORE
3045: sqlbuf := 'begin '||callback||

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

3662: -- Open and parse cursor for dynamic sql for getting attr values
3663: -- Bug 2376033 added event value in call to CB
3664: if (callback is not null) then
3665: -- ### Review Note 2
3666: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
3667: --Throw the Illegal exception when the check fails
3668:
3669:
3670: -- BINDVAR_SCAN_IGNORE

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

3723: else
3724: -- Bug 2580807 call with original signature for backward
3725: -- compatibility
3726: -- ### Review Note 2 - callback is from table
3727: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
3728: --Throw the Illegal exception when the check fails
3729:
3730:
3731: -- BINDVAR_SCAN_IGNORE

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

4272: tvalue := new_role;
4273: nvalue := nid;
4274: -- ### Review Note 2 - cb is from table
4275: -- BINDVAR_SCAN_IGNORE
4276: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
4277: --Throw the Illegal exception when the check fails
4278:
4279:
4280: sqlbuf := 'begin '||cb||

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

4900: tvalue := respond.responder;
4901: nvalue := nid;
4902: -- ### Review Note 2 - callback is from table
4903: -- Check for bug#3827935
4904: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
4905: --Throw the Illegal exception when the check fails
4906:
4907:
4908: -- BINDVAR_SCAN_IGNORE

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

4994: --
4995: -- Open dynamic sql cursor for SET callback calls.
4996: --
4997: -- ### Review Note 2 - callback is from table
4998: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
4999: --Throw the Illegal exception when the check fails
5000:
5001:
5002: -- BINDVAR_SCAN_IGNORE

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

5056:
5057: -- Reparse and bind dynamic sql for the COMPLETE callback call.
5058: -- ### Review Note 2 - callback is from table
5059: -- Check for bug#3827935
5060: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
5061: --Throw the Illegal exception when the check fails
5062:
5063:
5064: -- BINDVAR_SCAN_IGNORE[3]

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

5136:
5137: -- Open dynamic sql cursor for callback call
5138: -- ### Review Note 2 - callback is from table
5139: -- Check for bug#3827935
5140: l_charcheck := wf_notification_util.CheckIllegalChar(callback);
5141: --Throw the Illegal exception when the check fails
5142:
5143:
5144: -- BINDVAR_SCAN_IGNORE

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

5914: FALSE, FALSE, 'text/plain');
5915: end if;
5916:
5917: -- ### Review Note 1
5918: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
5919: --Throw the Illegal exception when the check fails
5920:
5921: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5922: wf_log_pkg.string2(wf_log_pkg.level_statement,

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

6168: -- GetNLSLanguage.language := Wf_Notification.nls_language;
6169: -- GetNLSLanguage.territory := Wf_Notification.nls_territory;
6170: -- GetNLSLanguage.charset := Wf_Notification.nls_charset;
6171:
6172: wf_notification_util.getNLSContext( p_nlsLanguage=> GetNLSLanguage.language,
6173: p_nlsTerritory => GetNLSLanguage.territory,
6174: p_nlsCode => GetNLSLanguage.charset,
6175: p_nlsDateFormat => l_nlsDateFormat,
6176: p_nlsDateLanguage => l_nlsDateLang,

Line 6210: wf_notification_util.SetNLSContext( -- p_nid ,

6206: -- -- update cache
6207: -- Wf_Notification.nls_language := p_language;
6208: -- Wf_Notification.nls_territory := p_territory;
6209:
6210: wf_notification_util.SetNLSContext( -- p_nid ,
6211: p_nlsLanguage => l_language,
6212: p_nlsTerritory => p_territory
6213: -- ok not to pass next parameters
6214: -- as fnd_global.set_nls_context won't set

Line 6286: l_canDefer := wf_notification_util.g_allowDeferDenormalize;

6282: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6283: end if;
6284:
6285: -- 8286459. Get value, and always reset flag;
6286: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6287: wf_notification_util.g_allowDeferDenormalize := true;
6288:
6289: -- <7720908>
6290: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode

Line 6287: wf_notification_util.g_allowDeferDenormalize := true;

6283: end if;
6284:
6285: -- 8286459. Get value, and always reset flag;
6286: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6287: wf_notification_util.g_allowDeferDenormalize := true;
6288:
6289: -- <7720908>
6290: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode
6291: , l_orig_nlsDateFormat, l_orig_nlsDateLang

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

6286: l_canDefer := wf_notification_util.g_allowDeferDenormalize;
6287: wf_notification_util.g_allowDeferDenormalize := true;
6288:
6289: -- <7720908>
6290: wf_notification_util.getNLSContext( l_orig_lang, l_orig_nlsterritory, l_orig_nlsCode
6291: , l_orig_nlsDateFormat, l_orig_nlsDateLang
6292: , l_orig_nlsNumChars, l_orig_nlsSort, l_orig_nlsCalendar);
6293:
6294: if (l_orig_nlsCalendar is null) then

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

6860: tvalue := myusername;
6861: nvalue := nid;
6862: -- ### Review Note 2 - cb is from table
6863: --Check for bug#3827935
6864: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
6865: --Throw the Illegal exception when the check fails
6866:
6867:
6868: -- BINDVAR_SCAN_IGNORE

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

6995: nvalue := nid;
6996: g_context_new_role := l_question_role;
6997: -- ### Review Note 2 - cb is from table
6998: -- Check for bug#3827935
6999: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
7000: --Throw the Illegal exception when the check fails
7001:
7002: -- BINDVAR_SCAN_IGNORE
7003: sqlbuf := 'begin '||cb||

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

7373: tvalue := myusername;
7374: nvalue := nid;
7375: -- ### Review Note 2 - cb is from table
7376: -- Check for bug#3827935
7377: l_charcheck := wf_notification_util.CheckIllegalChar(cb);
7378: --Throw the Illegal exception when the check fails
7379:
7380: -- BINDVAR_SCAN_IGNORE
7381: sqlbuf := 'begin '||cb||

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

8119:
8120: j := j+1;
8121: if (p_display_type = wf_notification.doc_html) then
8122: --
8123: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8124: else
8125: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8126: end if;
8127:

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

8121: if (p_display_type = wf_notification.doc_html) then
8122: --
8123: cells(j) := 'S:' || wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8124: else
8125: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_comm_rec.h_action_date, null, true);
8126: end if;
8127:
8128: j := j+1;
8129:

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

8204: cells(j) := to_char(l_ntf_hist_rec.h_sequence);
8205:
8206: j := j+1;
8207: if (p_display_type = wf_notification.doc_html) then
8208: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8209: else
8210: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8211: end if;
8212:

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

8206: j := j+1;
8207: if (p_display_type = wf_notification.doc_html) then
8208: cells(j) := 'S:'|| wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8209: else
8210: cells(j) := wf_notification_util.GetCalendarDate(p_nid, l_ntf_hist_rec.h_action_date, null, true);
8211: end if;
8212:
8213: j := j+1;
8214:

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

8475: end if;
8476:
8477: -- ### Review Note 1
8478: -- Check for bug#3827935
8479: l_charcheck := wf_notification_util.CheckIllegalChar(procname);
8480: --Throw the Illegal exception when the check fails
8481:
8482: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8483: wf_log_pkg.string2(wf_log_pkg.level_statement,