[Home] [Help]
36:
37: -- Raising the Business Event
38: -- p_person_party_id could be null. In this case, we expect the subscription to handle
39: -- the null party id.
40: wf_event.addParametertoList('UMX_PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
41: select UMX_USERNAME_POLICY_S.nextval into l_event_key from dual;
42:
43: -- Log the event key
44: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
48: end if;
49:
50: -- Raise the generate user name event.
51: -- Calling raise3 because l_parameter_list is an in/out parameter.
52: wf_event.raise3('oracle.apps.fnd.umx.username.generate', l_event_key, null, l_parameter_list, sysdate);
53: x_suggested_username := wf_event.getValueForParameter ('UMX_GENERATED_USERNAME', l_parameter_list);
54:
55: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
56: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
49:
50: -- Raise the generate user name event.
51: -- Calling raise3 because l_parameter_list is an in/out parameter.
52: wf_event.raise3('oracle.apps.fnd.umx.username.generate', l_event_key, null, l_parameter_list, sysdate);
53: x_suggested_username := wf_event.getValueForParameter ('UMX_GENERATED_USERNAME', l_parameter_list);
54:
55: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
56: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
57: 'fnd.plsql.UMXVUNPB.get_suggested_username.end',
220: -- Required : Y
221: -- Output Parameters :
222: --
223: function policy_subscription (p_subscription_guid in raw,
224: p_event in out nocopy WF_EVENT_T) return varchar2 is
225:
226: l_person_party_id HZ_PARTIES.PARTY_ID%type;
227: l_username fnd_user.user_name%type;
228: