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.AP_WEB_PROXY_ASSIGN_PKG dependencies on FND_LOG

Line 65: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

61: and c.employee_id = ppf.person_id
62: and pa.responsibility_app_id = b.application_id
63: for update of pa.effective_end_date;
64: BEGIN
65: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
66: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Enter');
67: end if;
68: if (p_end_date is not null) then
69: l_end_date := trunc(p_end_date);

Line 66: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Enter');

62: and pa.responsibility_app_id = b.application_id
63: for update of pa.effective_end_date;
64: BEGIN
65: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
66: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Enter');
67: end if;
68: if (p_end_date is not null) then
69: l_end_date := trunc(p_end_date);
70: end if;

Line 112: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

108: where current of c2;
109: end loop;
110: close c2;
111: end if;
112: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
113: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Exit');
114: end if;
115: exception when OTHERS then
116: app_exception.raise_exception;

Line 113: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Exit');

109: end loop;
110: close c2;
111: end if;
112: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
113: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.all_assignee_update','Exit');
114: end if;
115: exception when OTHERS then
116: app_exception.raise_exception;
117: END all_assignee_update;

Line 159: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

155: l_app_short_name varchar2(30);
156: l_sec_group_id number;
157:
158: BEGIN
159: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
160: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','Start');
161: end if;
162: l_event_name := p_event.getEventName();
163: l_event_key := p_event.GetEventKey;

Line 160: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','Start');

156: l_sec_group_id number;
157:
158: BEGIN
159: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
160: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','Start');
161: end if;
162: l_event_name := p_event.getEventName();
163: l_event_key := p_event.GetEventKey;
164:

Line 196: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

192: -- this event to capture when an employee is terminated
193: -- all assigned responsibilities get updated.
194: all_assignee_update(l_user_id, null, null, null, 'SQLAP', l_end_date, 'N');
195: end if;
196: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
197: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','End');
198: end if;
199: return 'SUCCESS';
200: exception when others then

Line 197: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','End');

193: -- all assigned responsibilities get updated.
194: all_assignee_update(l_user_id, null, null, null, 'SQLAP', l_end_date, 'N');
195: end if;
196: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
197: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments','End');
198: end if;
199: return 'SUCCESS';
200: exception when others then
201: if p_subscription_guid IS NOT NULL THEN

Line 248: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

244: l_full_name varchar2(255);
245:
246: BEGIN
247:
248: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
249: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Enter');
250: end if;
251:
252: select p_user_name || to_char(sysdate, 'DDMONYYYYHH24MISS') into l_request_id from dual;

Line 249: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Enter');

245:
246: BEGIN
247:
248: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
249: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Enter');
250: end if;
251:
252: select p_user_name || to_char(sysdate, 'DDMONYYYYHH24MISS') into l_request_id from dual;
253:

Line 293: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

289: WF_ENGINE.SetItemAttrTextArray('APWPROXY', l_request_id, l_textNameArr, l_textValArr);
290: -- Start the notification process
291: WF_ENGINE.STARTPROCESS('APWPROXY', l_request_id);
292:
293: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Exit');
295: end if;
296:
297: exception when others then

Line 294: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Exit');

290: -- Start the notification process
291: WF_ENGINE.STARTPROCESS('APWPROXY', l_request_id);
292:
293: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT,'AP_WEB_PROXY_ASSIGN_PKG.send_notification','Exit');
295: end if;
296:
297: exception when others then
298: Wf_Core.Context('AP_WEB_PROXY_ASSIGN_PKG', 'send_notification',