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_OID dependencies on WF_OID

Line 1: package body WF_OID as

1: package body WF_OID as
2: /* $Header: WFOIDB.pls 120.3 2006/08/09 14:18:40 rsantis noship $ */
3: --
4: -- Start of Package Globals
5: --

Line 6: G_MODULE_SOURCE constant varchar2(80) := 'fnd.plsql.oid.wf_oid.';

2: /* $Header: WFOIDB.pls 120.3 2006/08/09 14:18:40 rsantis noship $ */
3: --
4: -- Start of Package Globals
5: --
6: G_MODULE_SOURCE constant varchar2(80) := 'fnd.plsql.oid.wf_oid.';
7: pending_sub_add_event LDAP_EVENT := NULL;
8: key_guid varchar2(8):= NULL;
9: --
10: -- End of Package Globals

Line 39: wf_core.context('WF_OID', 'get_oid_session',

35: return my_session;
36:
37: exception
38: when others then
39: wf_core.context('WF_OID', 'get_oid_session',
40: 'Error code: '||to_char(sqlcode),
41: 'Error Message: '||substr(sqlerrm, 1, 238));
42: wf_core.raise('ICX_PREF_DESC');
43: end;

Line 81: if (event.event_type = wf_oid.IDENTITY_ADD)

77: then
78: raise l_null_event_exp;
79: end if;
80:
81: if (event.event_type = wf_oid.IDENTITY_ADD)
82: then
83: fnd_oid_util.process_identity_add(event);
84:
85: elsif (event.event_type = wf_oid.IDENTITY_MODIFY)

Line 85: elsif (event.event_type = wf_oid.IDENTITY_MODIFY)

81: if (event.event_type = wf_oid.IDENTITY_ADD)
82: then
83: fnd_oid_util.process_identity_add(event);
84:
85: elsif (event.event_type = wf_oid.IDENTITY_MODIFY)
86: then
87: fnd_oid_util.process_identity_modify(event);
88:
89: elsif (event.event_type = wf_oid.IDENTITY_DELETE)

Line 89: elsif (event.event_type = wf_oid.IDENTITY_DELETE)

85: elsif (event.event_type = wf_oid.IDENTITY_MODIFY)
86: then
87: fnd_oid_util.process_identity_modify(event);
88:
89: elsif (event.event_type = wf_oid.IDENTITY_DELETE)
90: then
91: fnd_oid_util.process_identity_delete(event);
92:
93: elsif (event.event_type = wf_oid.SUBSCRIPTION_ADD)

Line 93: elsif (event.event_type = wf_oid.SUBSCRIPTION_ADD)

89: elsif (event.event_type = wf_oid.IDENTITY_DELETE)
90: then
91: fnd_oid_util.process_identity_delete(event);
92:
93: elsif (event.event_type = wf_oid.SUBSCRIPTION_ADD)
94: then
95: fnd_oid_util.process_subscription_add(event);
96:
97: elsif (event.event_type = wf_oid.SUBSCRIPTION_DELETE)

Line 97: elsif (event.event_type = wf_oid.SUBSCRIPTION_DELETE)

93: elsif (event.event_type = wf_oid.SUBSCRIPTION_ADD)
94: then
95: fnd_oid_util.process_subscription_add(event);
96:
97: elsif (event.event_type = wf_oid.SUBSCRIPTION_DELETE)
98: then
99: fnd_oid_util.process_subscription_delete(event);
100:
101: else

Line 117: 0, null, wf_oid.EVENT_SUCCESS);

113:
114: end if;
115:
116: event_status := ldap_event_status(event.event_id, null,
117: 0, null, wf_oid.EVENT_SUCCESS);
118:
119: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
120: then
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

Line 127: 'Received Null Event', wf_oid.EVENT_RESEND);

123:
124: exception
125: when l_null_event_exp then
126: event_status := LDAP_EVENT_STATUS(null, null, 0,
127: 'Received Null Event', wf_oid.EVENT_RESEND);
128: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
131: 'Receiced Null Event. Sending wf_oid.EVENT_RESEND');

Line 131: 'Receiced Null Event. Sending wf_oid.EVENT_RESEND');

127: 'Received Null Event', wf_oid.EVENT_RESEND);
128: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
131: 'Receiced Null Event. Sending wf_oid.EVENT_RESEND');
132: end if;
133:
134: when others then
135: event_status := LDAP_EVENT_STATUS(event.event_id, null, to_char(sqlcode),

Line 136: sqlerrm, wf_oid.EVENT_ERROR);

132: end if;
133:
134: when others then
135: event_status := LDAP_EVENT_STATUS(event.event_id, null, to_char(sqlcode),
136: sqlerrm, wf_oid.EVENT_ERROR);
137: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
138: then
139: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
140: end if;

Line 204: if (event.event_type = wf_oid.IDENTITY_MODIFY) then

200:
201: fnd_ldap_mapper.map_oid_event(l_ldap_key, l_entity_changes_rec
202: , l_ldap_attr_list, event);
203:
204: if (event.event_type = wf_oid.IDENTITY_MODIFY) then
205: --APPS_SSO_LDAP_SYNC profile is considered for MODIFY events only
206: fnd_profile.get_specific(
207: name_z => 'APPS_SSO_LDAP_SYNC',
208: user_id_z => l_apps_username_key.user_id,

Line 238: return wf_oid.EVENT_FOUND;

234: then
235: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
236: end if;
237:
238: return wf_oid.EVENT_FOUND;
239:
240: exception
241: when fnd_oid_util.event_not_found_exp then
242: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 245: , 'No more events to send.Sending wf_oid.EVENT_NOT_FOUND');

241: when fnd_oid_util.event_not_found_exp then
242: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
245: , 'No more events to send.Sending wf_oid.EVENT_NOT_FOUND');
246: end if;
247:
248: return wf_oid.EVENT_NOT_FOUND;
249:

Line 248: return wf_oid.EVENT_NOT_FOUND;

244: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
245: , 'No more events to send.Sending wf_oid.EVENT_NOT_FOUND');
246: end if;
247:
248: return wf_oid.EVENT_NOT_FOUND;
249:
250: when others then
251: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
252: then

Line 256: return wf_oid.EVENT_NOT_FOUND;

252: then
253: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
254: end if;
255:
256: return wf_oid.EVENT_NOT_FOUND;
257: end GetAppEvent;
258: --
259: -------------------------------------------------------------------------------
260: procedure PutAppEventStatus(event_status in ldap_event_status) is

Line 296: if (event_status.error_disposition = wf_oid.EVENT_SUCCESS)

292: 'l_entity_key_value = ' || l_entity_key_value);
293: end if;
294:
295:
296: if (event_status.error_disposition = wf_oid.EVENT_SUCCESS)
297: then
298: -- OID sometimes sends dummy event with user_name=guid
299: if l_entity_key_value <> '' || event_status.orclguid then
300: update fnd_user

Line 417: end WF_OID;

413: end;
414:
415: ------------------------------------------------------------------------------
416: ------------------------------------------------------------------------------
417: end WF_OID;