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_LOG_PKG

Line 2499: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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,
2501: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2502: 'Start executing PLSQL Doc procedure - '||procname, true);
2503: end if;

Line 2500: wf_log_pkg.string2(wf_log_pkg.level_statement,

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,
2501: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2502: 'Start executing PLSQL Doc procedure - '||procname, true);
2503: end if;
2504:

Line 2512: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2508: in disptype,
2509: in out document,
2510: in out doctype;
2511:
2512: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2513: wf_log_pkg.string2(wf_log_pkg.level_statement,
2514: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2515: 'End executing PLSQL Doc procedure - '||procname, false);
2516: end if;

Line 2513: wf_log_pkg.string2(wf_log_pkg.level_statement,

2509: in out document,
2510: in out doctype;
2511:
2512: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2513: wf_log_pkg.string2(wf_log_pkg.level_statement,
2514: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2515: 'End executing PLSQL Doc procedure - '||procname, false);
2516: end if;
2517:

Line 5921: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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,
5923: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5924: 'Start executing PLSQLCLOB Doc procedure - '||procname, true);
5925: end if;

Line 5922: wf_log_pkg.string2(wf_log_pkg.level_statement,

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,
5923: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5924: 'Start executing PLSQLCLOB Doc procedure - '||procname, true);
5925: end if;
5926:

Line 5934: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5930: in disptype,
5931: in out document,
5932: in out doctype;
5933:
5934: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5935: wf_log_pkg.string2(wf_log_pkg.level_statement,
5936: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5937: 'End executing PLSQLCLOB Doc procedure - '||procname, false);
5938: end if;

Line 5935: wf_log_pkg.string2(wf_log_pkg.level_statement,

5931: in out document,
5932: in out doctype;
5933:
5934: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5935: wf_log_pkg.string2(wf_log_pkg.level_statement,
5936: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5937: 'End executing PLSQLCLOB Doc procedure - '||procname, false);
5938: end if;
5939:

Line 6278: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;

6274: l_canDefer boolean;
6275: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6276:
6277: begin
6278: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6279: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6280: if ( l_logPRCD ) then
6281: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6282: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);

Line 6279: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;

6275: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6276:
6277: begin
6278: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6279: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6280: if ( l_logPRCD ) then
6281: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6282: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6283: end if;

Line 6281: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module

6277: begin
6278: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6279: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6280: if ( l_logPRCD ) then
6281: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6282: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6283: end if;
6284:
6285: -- 8286459. Get value, and always reset flag;

Line 6298: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6294: if (l_orig_nlsCalendar is null) then
6295: -- when null (typically, online session), get calendar from user prefs
6296: l_sessionUser := Wfa_Sec.GetUser();
6297: if ( l_logSTMT ) then
6298: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6299: , 'l_sessionUser=>'||l_sessionUser||'<');
6300: end if;
6301:
6302: if (l_sessionUser is not null) then

Line 6306: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6302: if (l_sessionUser is not null) then
6303: Wf_Directory.GetRoleInfo2(l_sessionUser, l_sessionUserInfo);
6304: l_orig_nlsCalendar := l_sessionUserInfo(1).nls_calendar;
6305: if ( l_logSTMT ) then
6306: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6307: , 'l_sessionUser calendar=>'||l_orig_nlsCalendar||'<');
6308: end if;
6309: end if;
6310: end if;

Line 6334: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6330:
6331: role_info_tbl.DELETE;
6332:
6333: if ( l_logSTMT ) then
6334: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6335: , 'Got '||username||'''s preferences (passed by caller), lang='||l_language);
6336: end if;
6337:
6338: -- check if user language match

Line 6347: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module

6343: elsif (langcode is not null) then
6344: -- check if langcode match
6345: if (langcode <> userenv('LANG')) then
6346: if ( l_logPRCD ) then
6347: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6348: , 'END - did nothing, langcode <> session lang');
6349: end if;
6350: return;
6351: end if;

Line 6376: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6372: wf_core.raise('WFNTF_NID');
6373: end;
6374:
6375: if ( l_logSTMT ) then
6376: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6377: , 'Getting '||l_user||'''s (recipient) preferences');
6378: end if;
6379:
6380: Wf_Directory.GetRoleInfo2(l_user, role_info_tbl);

Line 6405: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6401: -- do not do anything if the NLS settings do not match
6402: l_defer_denormalize := TRUE;
6403:
6404: if ( l_logSTMT ) then
6405: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6406: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6407: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6408: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

Line 6407: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6403:
6404: if ( l_logSTMT ) then
6405: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6406: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6407: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6408: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6410: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

Line 6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6405: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6406: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6407: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6408: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6410: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6412: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6413: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

Line 6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6407: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6408: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6410: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6412: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6413: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6414: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6415: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

Line 6413: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6409: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6410: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6412: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6413: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6414: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6415: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6416: , 'l_orig_nlsSort:>'|| l_orig_nlsSort||'<, l_nls_sort:>'||l_nls_sort);
6417: end if;

Line 6415: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

6411: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6412: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6413: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6414: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6415: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6416: , 'l_orig_nlsSort:>'|| l_orig_nlsSort||'<, l_nls_sort:>'||l_nls_sort);
6417: end if;
6418: end if;
6419: end if;

Line 6439: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||

6435: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6436: --
6437:
6438: if ( l_logSTMT ) then
6439: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||
6440: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6441: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6442: '), date_format('||l_nls_date_format||'), date_language('||
6443: l_nls_date_language||')');

Line 6441: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||

6437:
6438: if ( l_logSTMT ) then
6439: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||
6440: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6441: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6442: '), date_format('||l_nls_date_format||'), date_language('||
6443: l_nls_date_language||')');
6444: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'calendar('||l_nls_calendar||
6445: '), numeric_characters('||l_nls_numeric_characters||'), sort('||

Line 6444: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'calendar('||l_nls_calendar||

6440: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6441: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6442: '), date_format('||l_nls_date_format||'), date_language('||
6443: l_nls_date_language||')');
6444: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'calendar('||l_nls_calendar||
6445: '), numeric_characters('||l_nls_numeric_characters||'), sort('||
6446: l_nls_sort||'), currency('||l_nls_currency||')');
6447: end if;
6448: if ( l_logPRCD ) then

Line 6449: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END - deferring denormalization');

6445: '), numeric_characters('||l_nls_numeric_characters||'), sort('||
6446: l_nls_sort||'), currency('||l_nls_currency||')');
6447: end if;
6448: if ( l_logPRCD ) then
6449: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END - deferring denormalization');
6450: end if;
6451:
6452: -- Raise the event
6453: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.denormalize',

Line 6461: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module,

6457: return;
6458: end if;
6459:
6460: if ( l_logSTMT ) then
6461: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module,
6462: 'Not deferring denormalization, so using session''s settings');
6463: end if;
6464:
6465: -- To User

Line 6496: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'subject('||l_subject||')');

6492: -- skilaru 08-MAY-03 bug fix 2883247
6493: l_subject := Wf_Notification.GetSubject(nid, 'text/plain');
6494:
6495: if ( l_logSTMT ) then
6496: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'subject('||l_subject||')');
6497: end if;
6498: -- Populate the notification values
6499: --
6500: begin

Line 6515: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END');

6511: wf_core.raise('WFNTF_DENORM_FAILED');
6512: end;
6513:
6514: if ( l_logPRCD ) then
6515: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END');
6516: end if;
6517: exception
6518: when OTHERS then
6519: wf_core.context('Wf_Notification', 'Denormalize_Notification',

Line 7269: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

7265: -- bug 7130745
7266: l_event_name varchar2(240);
7267:
7268: begin
7269: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7270: wf_log_pkg.string(wf_log_pkg.level_procedure,
7271: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.Begin',
7272: 'NID: '||to_char(nid) ||', Username: '||username||
7273: ' From: '||from_email);

Line 7270: wf_log_pkg.string(wf_log_pkg.level_procedure,

7266: l_event_name varchar2(240);
7267:
7268: begin
7269: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7270: wf_log_pkg.string(wf_log_pkg.level_procedure,
7271: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.Begin',
7272: 'NID: '||to_char(nid) ||', Username: '||username||
7273: ' From: '||from_email);
7274: end if;

Line 7286: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

7282: WHERE notification_id = nid;
7283:
7284: -- Donot process the request if the notification is not open.
7285: if (l_stat <> 'OPEN') then
7286: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7287: wf_log_pkg.string(wf_log_pkg.level_statement,
7288: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.not_open',
7289: 'Notification '||to_char(nid)||' is not OPEN. Returning.');
7290: end if;

Line 7287: wf_log_pkg.string(wf_log_pkg.level_statement,

7283:
7284: -- Donot process the request if the notification is not open.
7285: if (l_stat <> 'OPEN') then
7286: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7287: wf_log_pkg.string(wf_log_pkg.level_statement,
7288: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.not_open',
7289: 'Notification '||to_char(nid)||' is not OPEN. Returning.');
7290: end if;
7291: return;

Line 7303: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

7299: else
7300: g_context_user := 'email:' || myusername;
7301: end if;
7302:
7303: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7304: wf_log_pkg.string(wf_log_pkg.level_statement,
7305: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.got_user',
7306: 'Email: '||from_email||' User: '||myusername||' DispName: '||mydispname);
7307: end if;

Line 7304: wf_log_pkg.string(wf_log_pkg.level_statement,

7300: g_context_user := 'email:' || myusername;
7301: end if;
7302:
7303: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7304: wf_log_pkg.string(wf_log_pkg.level_statement,
7305: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.got_user',
7306: 'Email: '||from_email||' User: '||myusername||' DispName: '||mydispname);
7307: end if;
7308:

Line 7366: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

7362: when resource_busy then
7363: wf_core.raise('WFNTF_BEING_UPDATED');
7364: end;
7365:
7366: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7367: wf_log_pkg.string(wf_log_pkg.level_statement,
7368: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.question',
7369: 'Updating QUESTION');
7370: end if;

Line 7367: wf_log_pkg.string(wf_log_pkg.level_statement,

7363: wf_core.raise('WFNTF_BEING_UPDATED');
7364: end;
7365:
7366: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7367: wf_log_pkg.string(wf_log_pkg.level_statement,
7368: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.question',
7369: 'Updating QUESTION');
7370: end if;
7371:

Line 7495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

7491: in out dvalue;
7492:
7493: end if;
7494:
7495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7496: wf_log_pkg.string(wf_log_pkg.level_statement,
7497: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.answer',
7498: 'Updating ANSWER');
7499: end if;

Line 7496: wf_log_pkg.string(wf_log_pkg.level_statement,

7492:
7493: end if;
7494:
7495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7496: wf_log_pkg.string(wf_log_pkg.level_statement,
7497: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.answer',
7498: 'Updating ANSWER');
7499: end if;
7500:

Line 7625: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',

7621: l_language varchar2(30);
7622: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7623:
7624: begin
7625: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7626: 'NID: '||to_char(nid));
7627:
7628: -- Do not allow reply when a question has not been asked, or it has
7629: -- already been answered. In both cases, MORE_INFO_ROLE is set to null.

Line 7683: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',

7679:
7680: end if;
7681:
7682:
7683: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7684: 'Updating ANSWER');
7685:
7686: update WF_NOTIFICATIONS
7687: set MAIL_STATUS = 'MAIL',

Line 8482: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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,
8484: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8485: 'Start executing PLSQLBLOB Doc procedure - '||procname, true);
8486: end if;

Line 8483: wf_log_pkg.string2(wf_log_pkg.level_statement,

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,
8484: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8485: 'Start executing PLSQLBLOB Doc procedure - '||procname, true);
8486: end if;
8487:

Line 8495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

8491: in disptype,
8492: in out document,
8493: in out doctype;
8494:
8495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8496: wf_log_pkg.string2(wf_log_pkg.level_statement,
8497: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8498: 'End executing PLSQLBLOB Doc procedure - '||procname, false);
8499: end if;

Line 8496: wf_log_pkg.string2(wf_log_pkg.level_statement,

8492: in out document,
8493: in out doctype;
8494:
8495: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8496: wf_log_pkg.string2(wf_log_pkg.level_statement,
8497: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8498: 'End executing PLSQLBLOB Doc procedure - '||procname, false);
8499: end if;
8500:

Line 8866: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

8862: url_value varchar2(2000);
8863: lang_code varchar2(4);
8864: l_api varchar2(250) := g_plsqlName ||'getFwkBodyURL2';
8865: begin
8866: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8867: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8868: end if;
8869:
8870: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

Line 8867: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

8863: lang_code varchar2(4);
8864: l_api varchar2(250) := g_plsqlName ||'getFwkBodyURL2';
8865: begin
8866: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8867: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8868: end if;
8869:
8870: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8871:

Line 8897: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.getFwkBodyURLLang',

8893: url_value := url_value || '&language_code='|| lang_code;
8894:
8895: exception
8896: when others then
8897: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.getFwkBodyURLLang',
8898: 'nid: '||to_char(p_nid)||'; language: '|| p_language);
8899: end;
8900: end if;
8901:

Line 8908: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

8904: and fnd_release.point_version>=1) or (fnd_release.major_version > 12) then
8905: url_value := url_value || '&nlsCalendar='|| nvl(p_nlsCalendar, wf_core.nls_calendar);
8906: end if;
8907:
8908: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8909: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
8910: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
8911: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
8912: end if;

Line 8909: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);

8905: url_value := url_value || '&nlsCalendar='|| nvl(p_nlsCalendar, wf_core.nls_calendar);
8906: end if;
8907:
8908: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8909: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
8910: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
8911: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
8912: end if;
8913:

Line 8910: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);

8906: end if;
8907:
8908: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8909: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
8910: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
8911: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
8912: end if;
8913:
8914: return url_value;

Line 8911: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

8907:
8908: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8909: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
8910: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
8911: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
8912: end if;
8913:
8914: return url_value;
8915:

Line 8988: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

8984: is
8985: url_value varchar2(2000);
8986: l_api varchar2(250) := g_plsqlName ||'getSummaryURL2';
8987: begin
8988: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8989: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8990: end if;
8991:
8992: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

Line 8989: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

8985: url_value varchar2(2000);
8986: l_api varchar2(250) := g_plsqlName ||'getSummaryURL2';
8987: begin
8988: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8989: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8990: end if;
8991:
8992: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8993: if url_value is null then

Line 9016: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

9012: url_value := url_value || '&nlsCalendar='|| nvl(p_nlsCalendar,
9013: wf_core.nls_calendar);
9014: end if;
9015:
9016: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9017: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9018: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9019: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9020: end if;

Line 9017: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);

9013: wf_core.nls_calendar);
9014: end if;
9015:
9016: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9017: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9018: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9019: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9020: end if;
9021:

Line 9018: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);

9014: end if;
9015:
9016: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9017: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9018: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9019: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9020: end if;
9021:
9022: return url_value;

Line 9019: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

9015:
9016: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9017: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9018: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9019: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9020: end if;
9021:
9022: return url_value;
9023: