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 FND_LOG

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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;