APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on AP_WEB_PROXY_ASSIGN_PKG

Line 1: PACKAGE BODY AP_WEB_PROXY_ASSIGN_PKG AS

1: PACKAGE BODY AP_WEB_PROXY_ASSIGN_PKG AS
2: /* $Header: apwprasb.pls 120.1.12000000.2 2007/02/15 23:01:42 skoukunt ship $ */
3:
4: -- api has two conditions, if responsibility id is null then effectively all the
5: -- responsbilities for the user gets updated else only the specified

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 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 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 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 202: WF_CORE.context('AP_WEB_PROXY_ASSIGN_PKG', 'proxy_assignments', p_event.getEventName(), p_subscription_guid);

198: end if;
199: return 'SUCCESS';
200: exception when others then
201: if p_subscription_guid IS NOT NULL THEN
202: WF_CORE.context('AP_WEB_PROXY_ASSIGN_PKG', 'proxy_assignments', p_event.getEventName(), p_subscription_guid);
203: WF_EVENT.setErrorInfo(p_event, 'ERROR');
204: end if;
205: raise;
206: return 'ERROR';

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 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',

Line 298: Wf_Core.Context('AP_WEB_PROXY_ASSIGN_PKG', 'send_notification',

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',
299: p_user_name, p_resp_name, to_char(sysdate));
300: raise;
301: END send_notification;
302:

Line 303: END AP_WEB_PROXY_ASSIGN_PKG;

299: p_user_name, p_resp_name, to_char(sysdate));
300: raise;
301: END send_notification;
302:
303: END AP_WEB_PROXY_ASSIGN_PKG;