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