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

Line 31: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

27: l_event_key varchar2 (240);
28:
29: begin
30:
31: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
32: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
33: 'fnd.plsql.UMXVUNPB.get_suggested_username.begin',
34: 'p_person_party_id: ' || p_person_party_id);
35: end if;

Line 32: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

28:
29: begin
30:
31: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
32: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
33: 'fnd.plsql.UMXVUNPB.get_suggested_username.begin',
34: 'p_person_party_id: ' || p_person_party_id);
35: end if;
36:

Line 44: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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
45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
46: 'fnd.plsql.UMXVUNPB.run_policy',
47: 'Raising event with event key: ' || l_event_key);
48: end if;

Line 45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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
45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
46: 'fnd.plsql.UMXVUNPB.run_policy',
47: 'Raising event with event key: ' || l_event_key);
48: end if;
49:

Line 55: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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',
58: 'x_suggested_username: ' || x_suggested_username);
59: end if;

Line 56: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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',
58: 'x_suggested_username: ' || x_suggested_username);
59: end if;
60:

Line 153: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

149: and nvl (end_date_active, sysdate + 1) > sysdate;
150:
151: begin
152:
153: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
154: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
155: 'fnd.plsql.UMXVUNPB.get_username_policy_desc.begin', null);
156: end if;
157:

Line 154: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

150:
151: begin
152:
153: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
154: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
155: 'fnd.plsql.UMXVUNPB.get_username_policy_desc.begin', null);
156: end if;
157:
158: -- First, get the Policy Code

Line 193: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

189: close get_none_policy_prompt;
190: end if;
191: end if;
192:
193: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
195: 'fnd.plsql.UMXVUNPB.get_username_policy_desc.end',
196: 'x_policy_code: ' || x_policy_code ||
197: ' | x_description: ' || x_description ||

Line 194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

190: end if;
191: end if;
192:
193: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
195: 'fnd.plsql.UMXVUNPB.get_username_policy_desc.end',
196: 'x_policy_code: ' || x_policy_code ||
197: ' | x_description: ' || x_description ||
198: ' | x_prompt: ' || x_prompt ||

Line 233: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

229: begin
230:
231: l_person_party_id := p_event.getValueForParameter ('UMX_PERSON_PARTY_ID');
232:
233: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
234: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
235: 'fnd.plsql.UMXVUNPB.policy_subscription.begin',
236: 'p_subscription_guid: ' || p_subscription_guid ||
237: ' | l_person_party_id: ' || l_person_party_id);

Line 234: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

230:
231: l_person_party_id := p_event.getValueForParameter ('UMX_PERSON_PARTY_ID');
232:
233: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
234: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
235: 'fnd.plsql.UMXVUNPB.policy_subscription.begin',
236: 'p_subscription_guid: ' || p_subscription_guid ||
237: ' | l_person_party_id: ' || l_person_party_id);
238: end if;

Line 247: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

243: x_email_address => l_username);
244:
245: p_event.addParametertoList('UMX_GENERATED_USERNAME', l_username);
246:
247: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
248: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
249: 'fnd.plsql.UMXVUNPB.policy_subscription.end',
250: 'l_username: ' || l_username);
251: end if;

Line 248: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

244:
245: p_event.addParametertoList('UMX_GENERATED_USERNAME', l_username);
246:
247: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
248: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
249: 'fnd.plsql.UMXVUNPB.policy_subscription.end',
250: 'l_username: ' || l_username);
251: end if;
252:

Line 376: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

372: l_itemkey varchar2 (6) := '#SYNCH';
373:
374: begin
375:
376: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
377: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
378: 'fnd.plsql.UMXVUNPB.run_policy.begin',
379: 'p_reg_serv_code: ' || p_reg_serv_code ||
380: ' | p_person_party_id: ' || p_person_party_id);

Line 377: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

373:
374: begin
375:
376: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
377: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
378: 'fnd.plsql.UMXVUNPB.run_policy.begin',
379: 'p_reg_serv_code: ' || p_reg_serv_code ||
380: ' | p_person_party_id: ' || p_person_party_id);
381: end if;

Line 464: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

460: fetch get_person_party_id into x_exist_user_id, x_exist_per_party_id;
461: close get_person_party_id;
462: end if;
463:
464: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
465: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
466: 'fnd.plsql.UMXVUNPB.run_policy.end',
467: 'x_generated_username: ' || x_generated_username ||
468: ' | x_policy_override: ' || x_policy_override ||

Line 465: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

461: close get_person_party_id;
462: end if;
463:
464: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
465: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
466: 'fnd.plsql.UMXVUNPB.run_policy.end',
467: 'x_generated_username: ' || x_generated_username ||
468: ' | x_policy_override: ' || x_policy_override ||
469: ' | x_policy_code: ' || x_policy_code ||