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 943: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

939: -- user_name := substr(l_email, 1, instr(l_email, '@') - 1);
940:
941: -- Bug 13060615. Check if the expected user is the one who responded via e-mail
942: if (preferred_name is not null) then
943: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
944: wf_log_pkg.string(wf_log_pkg.level_statement,
945: 'wf.plsql.WF_NOTIFICATION.GetUserfromEmail',
946: 'Obtaining user name using preferred name '||preferred_name);
947: end if;

Line 944: wf_log_pkg.string(wf_log_pkg.level_statement,

940:
941: -- Bug 13060615. Check if the expected user is the one who responded via e-mail
942: if (preferred_name is not null) then
943: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
944: wf_log_pkg.string(wf_log_pkg.level_statement,
945: 'wf.plsql.WF_NOTIFICATION.GetUserfromEmail',
946: 'Obtaining user name using preferred name '||preferred_name);
947: end if;
948: if WF_DIRECTORY.UserActive(preferred_name) then

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

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

Line 2566: wf_log_pkg.string2(wf_log_pkg.level_statement,

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

Line 2582: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

2578: in out document,
2579: in out doctype;
2580: exception
2581: when others then
2582: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
2583: wf_log_pkg.string(wf_log_pkg.level_error,
2584: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_api',
2585: 'Error executing PLSQL Doc API - '||procname||' -> '||sqlerrm);
2586: end if;

Line 2583: wf_log_pkg.string(wf_log_pkg.level_error,

2579: in out doctype;
2580: exception
2581: when others then
2582: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
2583: wf_log_pkg.string(wf_log_pkg.level_error,
2584: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_api',
2585: 'Error executing PLSQL Doc API - '||procname||' -> '||sqlerrm);
2586: end if;
2587:

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

2593: WF_CORE.Token('SQLERRM', DBMS_UTILITY.FORMAT_ERROR_STACK());
2594: WF_CORE.Raise('WFNTF_GEN_DOC');
2595: end;
2596:
2597: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2598: wf_log_pkg.string2(wf_log_pkg.level_statement,
2599: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2600: 'End executing PLSQL Doc procedure - '||procname, false);
2601: end if;

Line 2598: wf_log_pkg.string2(wf_log_pkg.level_statement,

2594: WF_CORE.Raise('WFNTF_GEN_DOC');
2595: end;
2596:
2597: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2598: wf_log_pkg.string2(wf_log_pkg.level_statement,
2599: 'wf.plsql.wf_notification.GetAttrDoc2.plsqldoc_callout',
2600: 'End executing PLSQL Doc procedure - '||procname, false);
2601: end if;
2602:

Line 4143: if (WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4139: AND action_type = 'RESPOND';
4140: end if;
4141: exception
4142: when OTHERS then
4143: if (WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4144: WF_LOG_PKG.string2(WF_LOG_PKG.LEVEL_STATEMENT, l_proc_name,
4145: 'Unable to retrieve notification Id :'||sqlerrm);
4146: end if;
4147: end;

Line 4144: WF_LOG_PKG.string2(WF_LOG_PKG.LEVEL_STATEMENT, l_proc_name,

4140: end if;
4141: exception
4142: when OTHERS then
4143: if (WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4144: WF_LOG_PKG.string2(WF_LOG_PKG.LEVEL_STATEMENT, l_proc_name,
4145: 'Unable to retrieve notification Id :'||sqlerrm);
4146: end if;
4147: end;
4148:

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

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

Line 5773: wf_log_pkg.string2(wf_log_pkg.level_statement,

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

Line 5789: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

5785: in out document,
5786: in out doctype;
5787: exception
5788: when others then
5789: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
5790: wf_log_pkg.string(wf_log_pkg.level_error,
5791: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_api',
5792: 'Error executing PLSQLCLOB Doc API - '||procname|| ' -> '||sqlerrm);
5793: end if;

Line 5790: wf_log_pkg.string(wf_log_pkg.level_error,

5786: in out doctype;
5787: exception
5788: when others then
5789: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
5790: wf_log_pkg.string(wf_log_pkg.level_error,
5791: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_api',
5792: 'Error executing PLSQLCLOB Doc API - '||procname|| ' -> '||sqlerrm);
5793: end if;
5794:

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

5800: WF_CORE.Token('SQLERRM', DBMS_UTILITY.FORMAT_ERROR_STACK());
5801: WF_CORE.Raise('WFNTF_GEN_DOC');
5802: end;
5803:
5804: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5805: wf_log_pkg.string2(wf_log_pkg.level_statement,
5806: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5807: 'End executing PLSQLCLOB Doc procedure - '||procname, false);
5808: end if;

Line 5805: wf_log_pkg.string2(wf_log_pkg.level_statement,

5801: WF_CORE.Raise('WFNTF_GEN_DOC');
5802: end;
5803:
5804: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5805: wf_log_pkg.string2(wf_log_pkg.level_statement,
5806: 'wf.plsql.wf_notification.GetAttrClob.plsqlclob_callout',
5807: 'End executing PLSQLCLOB Doc procedure - '||procname, false);
5808: end if;
5809:

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

6104: l_canDefer boolean;
6105: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6106:
6107: begin
6108: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6109: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6110: if ( l_logPRCD ) then
6111: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6112: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);

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

6105: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6106:
6107: begin
6108: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6109: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6110: if ( l_logPRCD ) then
6111: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6112: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6113: end if;

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

6107: begin
6108: l_logPRCD := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
6109: l_logSTMT := WF_LOG_PKG.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level;
6110: if ( l_logPRCD ) then
6111: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6112: , 'BEGIN, nid='||nid||', username='||username||', langcode='||langcode);
6113: end if;
6114:
6115: -- 8286459. Get value, and always reset flag;

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

6124: if (l_orig_nlsCalendar is null) then
6125: -- when null (typically, online session), get calendar from user prefs
6126: l_sessionUser := Wfa_Sec.GetUser();
6127: if ( l_logSTMT ) then
6128: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6129: , 'l_sessionUser=>'||l_sessionUser||'<');
6130: end if;
6131:
6132: if (l_sessionUser is not null) then

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

6132: if (l_sessionUser is not null) then
6133: Wf_Directory.GetRoleInfo2(l_sessionUser, l_sessionUserInfo);
6134: l_orig_nlsCalendar := l_sessionUserInfo(1).nls_calendar;
6135: if ( l_logSTMT ) then
6136: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6137: , 'l_sessionUser calendar=>'||l_orig_nlsCalendar||'<');
6138: end if;
6139: end if;
6140: end if;

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

6160:
6161: role_info_tbl.DELETE;
6162:
6163: if ( l_logSTMT ) then
6164: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6165: , 'Got '||username||'''s preferences (passed by caller), lang='||l_language);
6166: end if;
6167:
6168: -- check if user language match

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

6173: elsif (langcode is not null) then
6174: -- check if langcode match
6175: if (langcode <> userenv('LANG')) then
6176: if ( l_logPRCD ) then
6177: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module
6178: , 'END - did nothing, langcode <> session lang');
6179: end if;
6180: return;
6181: end if;

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

6202: wf_core.raise('WFNTF_NID');
6203: end;
6204:
6205: if ( l_logSTMT ) then
6206: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6207: , 'Getting '||l_user||'''s (recipient) preferences');
6208: end if;
6209:
6210: Wf_Directory.GetRoleInfo2(l_user, role_info_tbl);

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

6231: -- do not do anything if the NLS settings do not match
6232: l_defer_denormalize := TRUE;
6233:
6234: if ( l_logSTMT ) then
6235: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6236: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6237: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6238: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6239: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

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

6233:
6234: if ( l_logSTMT ) then
6235: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6236: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6237: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6238: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6239: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6240: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6241: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

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

6235: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6236: , 'l_orig_lang:>'|| l_orig_lang ||'<, l_language:>'||l_language);
6237: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6238: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6239: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6240: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6241: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6242: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6243: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

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

6237: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6238: , 'l_orig_nlsDateFormat:>'||l_orig_nlsDateFormat ||'<, l_nls_date_format:>'||l_nls_date_format);
6239: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6240: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6241: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6242: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6243: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6244: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6245: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module

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

6239: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6240: , 'l_orig_nlsDateLang:>'||l_orig_nlsDateLang ||'<, l_nls_date_language:>'||l_nls_date_language);
6241: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6242: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6243: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6244: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6245: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6246: , 'l_orig_nlsSort:>'|| l_orig_nlsSort||'<, l_nls_sort:>'||l_nls_sort);
6247: end if;

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

6241: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6242: , 'l_orig_nlsCalendar:>'|| l_orig_nlsCalendar ||'<, l_nls_calendar:>'||l_nls_calendar);
6243: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6244: , 'l_orig_nlsterritory:>'|| l_orig_nlsterritory ||'<, l_territory:>'||l_territory);
6245: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6246: , 'l_orig_nlsSort:>'|| l_orig_nlsSort||'<, l_nls_sort:>'||l_nls_sort);
6247: end if;
6248: end if;
6249: end if;

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

6265: wf_event.AddParameterToList('NLS_CURRENCY', l_nls_currency,l_parameterlist);
6266: --
6267:
6268: if ( l_logSTMT ) then
6269: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||
6270: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6271: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6272: '), date_format('||l_nls_date_format||'), date_language('||
6273: l_nls_date_language||')');

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

6267:
6268: if ( l_logSTMT ) then
6269: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'defer parameters: '||
6270: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6271: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6272: '), date_format('||l_nls_date_format||'), date_language('||
6273: l_nls_date_language||')');
6274: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'calendar('||l_nls_calendar||
6275: '), numeric_characters('||l_nls_numeric_characters||'), sort('||

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

6270: 'nid('||nid||'), role('||l_user||'), language('||l_language||')');
6271: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'territory('||l_territory||
6272: '), date_format('||l_nls_date_format||'), date_language('||
6273: l_nls_date_language||')');
6274: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'calendar('||l_nls_calendar||
6275: '), numeric_characters('||l_nls_numeric_characters||'), sort('||
6276: l_nls_sort||'), currency('||l_nls_currency||')');
6277: end if;
6278: if ( l_logPRCD ) then

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

6275: '), numeric_characters('||l_nls_numeric_characters||'), sort('||
6276: l_nls_sort||'), currency('||l_nls_currency||')');
6277: end if;
6278: if ( l_logPRCD ) then
6279: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END - deferring denormalization');
6280: end if;
6281:
6282: -- Raise the event
6283: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.denormalize',

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

6287: return;
6288: end if;
6289:
6290: if ( l_logSTMT ) then
6291: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module,
6292: 'Not deferring denormalization, so using session''s settings');
6293: end if;
6294:
6295: -- To User

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

6322: -- skilaru 08-MAY-03 bug fix 2883247
6323: l_subject := Wf_Notification.GetSubject(nid, 'text/plain');
6324:
6325: if ( l_logSTMT ) then
6326: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module, 'subject('||l_subject||')');
6327: end if;
6328: -- Populate the notification values
6329: --
6330: begin

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

6341: wf_core.raise('WFNTF_DENORM_FAILED');
6342: end;
6343:
6344: if ( l_logPRCD ) then
6345: wf_log_pkg.String(wf_log_pkg.LEVEL_PROCEDURE, l_module, 'END');
6346: end if;
6347: exception
6348: when OTHERS then
6349: wf_core.context('Wf_Notification', 'Denormalize_Notification',

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

7440: -- bug 7130745
7441: l_event_name varchar2(240);
7442:
7443: begin
7444: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7445: wf_log_pkg.string(wf_log_pkg.level_procedure,
7446: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.Begin',
7447: 'NID: '||to_char(nid) ||', Username: '||username||
7448: ' From: '||from_email);

Line 7445: wf_log_pkg.string(wf_log_pkg.level_procedure,

7441: l_event_name varchar2(240);
7442:
7443: begin
7444: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7445: wf_log_pkg.string(wf_log_pkg.level_procedure,
7446: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.Begin',
7447: 'NID: '||to_char(nid) ||', Username: '||username||
7448: ' From: '||from_email);
7449: end if;

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

7457: WHERE notification_id = nid;
7458:
7459: -- Donot process the request if the notification is not open.
7460: if (l_stat <> 'OPEN') then
7461: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7462: wf_log_pkg.string(wf_log_pkg.level_statement,
7463: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.not_open',
7464: 'Notification '||to_char(nid)||' is not OPEN. Returning.');
7465: end if;

Line 7462: wf_log_pkg.string(wf_log_pkg.level_statement,

7458:
7459: -- Donot process the request if the notification is not open.
7460: if (l_stat <> 'OPEN') then
7461: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7462: wf_log_pkg.string(wf_log_pkg.level_statement,
7463: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.not_open',
7464: 'Notification '||to_char(nid)||' is not OPEN. Returning.');
7465: end if;
7466: return;

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

7478: else
7479: g_context_user := 'email:' || myusername;
7480: end if;
7481:
7482: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7483: wf_log_pkg.string(wf_log_pkg.level_statement,
7484: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.got_user',
7485: 'Email: '||from_email||' User: '||myusername||' DispName: '||mydispname);
7486: end if;

Line 7483: wf_log_pkg.string(wf_log_pkg.level_statement,

7479: g_context_user := 'email:' || myusername;
7480: end if;
7481:
7482: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7483: wf_log_pkg.string(wf_log_pkg.level_statement,
7484: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.got_user',
7485: 'Email: '||from_email||' User: '||myusername||' DispName: '||mydispname);
7486: end if;
7487:

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

7585: when resource_busy then
7586: wf_core.raise('WFNTF_BEING_UPDATED');
7587: end;
7588:
7589: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7590: wf_log_pkg.string(wf_log_pkg.level_statement,
7591: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.question',
7592: 'Updating QUESTION');
7593: end if;

Line 7590: wf_log_pkg.string(wf_log_pkg.level_statement,

7586: wf_core.raise('WFNTF_BEING_UPDATED');
7587: end;
7588:
7589: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7590: wf_log_pkg.string(wf_log_pkg.level_statement,
7591: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.question',
7592: 'Updating QUESTION');
7593: end if;
7594:

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

7716: in out dvalue;
7717:
7718: end if;
7719:
7720: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7721: wf_log_pkg.string(wf_log_pkg.level_statement,
7722: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.answer',
7723: 'Updating ANSWER');
7724: end if;

Line 7721: wf_log_pkg.string(wf_log_pkg.level_statement,

7717:
7718: end if;
7719:
7720: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7721: wf_log_pkg.string(wf_log_pkg.level_statement,
7722: 'wf.plsql.WF_NOTIFICATION.UpdateInfo2.answer',
7723: 'Updating ANSWER');
7724: end if;
7725:

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

7847: l_language varchar2(30);
7848: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7849:
7850: begin
7851: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7852: 'NID: '||to_char(nid));
7853:
7854: -- Do not allow reply when a question has not been asked, or it has
7855: -- already been answered. In both cases, MORE_INFO_ROLE is set to null.

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

7905:
7906: end if;
7907:
7908:
7909: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7910: 'Updating ANSWER');
7911:
7912: update WF_NOTIFICATIONS
7913: set MAIL_STATUS = 'MAIL',

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

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

Line 8719: wf_log_pkg.string2(wf_log_pkg.level_statement,

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

Line 8735: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

8731: in out document,
8732: in out doctype;
8733: exception
8734: when others then
8735: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
8736: wf_log_pkg.string(wf_log_pkg.level_error,
8737: 'wf.plsql.wf_notification.GetAttrBLOB.plsqlblob_api',
8738: 'Error executing PLSQLBLOB Doc API - '||procname||' -> '||sqlerrm);
8739: end if;

Line 8736: wf_log_pkg.string(wf_log_pkg.level_error,

8732: in out doctype;
8733: exception
8734: when others then
8735: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
8736: wf_log_pkg.string(wf_log_pkg.level_error,
8737: 'wf.plsql.wf_notification.GetAttrBLOB.plsqlblob_api',
8738: 'Error executing PLSQLBLOB Doc API - '||procname||' -> '||sqlerrm);
8739: end if;
8740:

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

8746: WF_CORE.Token('SQLERRM', DBMS_UTILITY.FORMAT_ERROR_STACK());
8747: WF_CORE.Raise('WFNTF_GEN_DOC');
8748: end;
8749:
8750: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8751: wf_log_pkg.string2(wf_log_pkg.level_statement,
8752: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8753: 'End executing PLSQLBLOB Doc procedure - '||procname, false);
8754: end if;

Line 8751: wf_log_pkg.string2(wf_log_pkg.level_statement,

8747: WF_CORE.Raise('WFNTF_GEN_DOC');
8748: end;
8749:
8750: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
8751: wf_log_pkg.string2(wf_log_pkg.level_statement,
8752: 'wf.plsql.wf_notification.GetAttrBlob.plsqlblob_callout',
8753: 'End executing PLSQLBLOB Doc procedure - '||procname, false);
8754: end if;
8755:

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

9113: lang_code varchar2(4);
9114: l_api varchar2(250) := g_plsqlName ||'getFwkBodyURL2';
9115: l_nls_calendar varchar2(64);
9116: begin
9117: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9118: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9119: end if;
9120:
9121: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

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

9114: l_api varchar2(250) := g_plsqlName ||'getFwkBodyURL2';
9115: l_nls_calendar varchar2(64);
9116: begin
9117: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9118: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9119: end if;
9120:
9121: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9122:

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

9144: url_value := url_value || '&language_code='|| lang_code;
9145:
9146: exception
9147: when others then
9148: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.getFwkBodyURLLang',
9149: 'nid: '||to_char(p_nid)||'; language: '|| p_language);
9150: end;
9151: end if;
9152:

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

9154: if (l_nls_calendar <> 'GREGORIAN') then
9155: url_value := url_value || '&nlsCalendar='||l_nls_calendar;
9156: end if;
9157:
9158: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9159: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9160: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9161: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9162: end if;

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

9155: url_value := url_value || '&nlsCalendar='||l_nls_calendar;
9156: end if;
9157:
9158: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9159: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9160: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9161: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9162: end if;
9163:

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

9156: end if;
9157:
9158: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9159: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9160: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9161: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9162: end if;
9163:
9164: return url_value;

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

9157:
9158: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9159: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9160: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9161: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9162: end if;
9163:
9164: return url_value;
9165:

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

9235: url_value varchar2(2000);
9236: l_api varchar2(250) := g_plsqlName ||'getSummaryURL2';
9237: l_nls_calendar varchar2(64);
9238: begin
9239: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9240: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9241: end if;
9242:
9243: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

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

9236: l_api varchar2(250) := g_plsqlName ||'getSummaryURL2';
9237: l_nls_calendar varchar2(64);
9238: begin
9239: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9240: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9241: end if;
9242:
9243: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9244: if url_value is null then

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

9260: if (l_nls_calendar <> 'GREGORIAN') then
9261: url_value := url_value || '&nlsCalendar='||l_nls_calendar;
9262: end if;
9263:
9264: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9265: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9266: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9267: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9268: end if;

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

9261: url_value := url_value || '&nlsCalendar='||l_nls_calendar;
9262: end if;
9263:
9264: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9265: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9266: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9267: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9268: end if;
9269:

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

9262: end if;
9263:
9264: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9265: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9266: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9267: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9268: end if;
9269:
9270: return url_value;

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

9263:
9264: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9265: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'p_nlsCalendar: '||p_nlsCalendar);
9266: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'url: '||url_value);
9267: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
9268: end if;
9269:
9270: return url_value;
9271: