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_REGISTRATION_UTIL dependencies on FND_LOG

Line 27: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

23: /*
24: **logging enter of method
25: */
26:
27: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
28: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
29: 'fnd.plsql.UMXUTILB.checkApprovalStatus.begin','');
30: end if;
31:

Line 28: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

24: **logging enter of method
25: */
26:
27: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
28: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
29: 'fnd.plsql.UMXUTILB.checkApprovalStatus.begin','');
30: end if;
31:
32: if (command = 'RUN') then

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

40: else
41: resultout := 'COMPLETE:REJECTED';
42: end if;
43: end if;
44: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
46: 'fnd.plsql.UMXUTILB.checkApprovalStatus.end','');
47: end if;
48: END Check_Approval_Status;

Line 45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

41: resultout := 'COMPLETE:REJECTED';
42: end if;
43: end if;
44: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
46: 'fnd.plsql.UMXUTILB.checkApprovalStatus.end','');
47: end if;
48: END Check_Approval_Status;
49:

Line 59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

55:
56: begin
57:
58:
59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
60: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
61: 'fnd.plsql.UMXUTILB.checkadminpriv.begin',
62: 'RequestedByUserid: '||l_requested_by_user_id);
63: end if;

Line 60: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

56: begin
57:
58:
59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
60: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
61: 'fnd.plsql.UMXUTILB.checkadminpriv.begin',
62: 'RequestedByUserid: '||l_requested_by_user_id);
63: end if;
64:

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

61: 'fnd.plsql.UMXUTILB.checkadminpriv.begin',
62: 'RequestedByUserid: '||l_requested_by_user_id);
63: end if;
64:
65: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
67: 'fnd.plsql.UMXUTILB.checkadminpriv.end','Return false');
68: end if;
69:

Line 66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

62: 'RequestedByUserid: '||l_requested_by_user_id);
63: end if;
64:
65: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
67: 'fnd.plsql.UMXUTILB.checkadminpriv.end','Return false');
68: end if;
69:
70: return false;

Line 95: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

91:
92: begin
93:
94:
95: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
96: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
97: 'fnd.plsql.UMXUTILB.checkadmingrants.begin',
98: 'RequestedByUserid: '||l_requested_by_user_id);
99: end if;

Line 96: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

92: begin
93:
94:
95: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
96: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
97: 'fnd.plsql.UMXUTILB.checkadmingrants.begin',
98: 'RequestedByUserid: '||l_requested_by_user_id);
99: end if;
100:

Line 113: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

109:
110: priv := fnd_function.test_instance (function_name => 'UMX_SYSTEM_ACCT_ADMINSTRATION',
111: user_name => l_username);
112:
113: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
114: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
115: 'fnd.plsql.UMXUTILB.checkadmingrants.end',
116: 'return : ');
117: end if;

Line 114: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

110: priv := fnd_function.test_instance (function_name => 'UMX_SYSTEM_ACCT_ADMINSTRATION',
111: user_name => l_username);
112:
113: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
114: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
115: 'fnd.plsql.UMXUTILB.checkadmingrants.end',
116: 'return : ');
117: end if;
118:

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

130: l_parameter_list wf_parameter_list_t;
131: i number ;
132: BEGIN
133:
134: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
135: l_parameter_list := p_event.getparameterlist ();
136: for i in 1..l_parameter_list.count loop
137: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
138: 'fnd.plsql.UMXUTILB.print','name:'||l_parameter_list (i).getName ()||

Line 137: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

133:
134: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
135: l_parameter_list := p_event.getparameterlist ();
136: for i in 1..l_parameter_list.count loop
137: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
138: 'fnd.plsql.UMXUTILB.print','name:'||l_parameter_list (i).getName ()||
139: ' value:'||l_parameter_list (i).getValue ());
140: end loop;
141: end if;

Line 157: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

153: p_attr_name in varchar2,
154: p_attr_value in varchar2) is
155: l_event wf_event_t;
156: BEGIN
157: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
159: 'fnd.plsql.UMXUTILB.addparamtoevent.begin','');
160: end if;
161:

Line 158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

154: p_attr_value in varchar2) is
155: l_event wf_event_t;
156: BEGIN
157: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
159: 'fnd.plsql.UMXUTILB.addparamtoevent.begin','');
160: end if;
161:
162: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,

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

167: itemkey => p_item_key,
168: name => 'REGISTRATION_DATA',
169: event => l_event);
170:
171: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
172: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
173: 'fnd.plsql.UMXUTILB.addparamtoevent','name: '||p_attr_name
174: ||' value: '||p_attr_value);
175: end if;

Line 172: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

168: name => 'REGISTRATION_DATA',
169: event => l_event);
170:
171: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
172: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
173: 'fnd.plsql.UMXUTILB.addparamtoevent','name: '||p_attr_name
174: ||' value: '||p_attr_value);
175: end if;
176: EXCEPTION

Line 179: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

175: end if;
176: EXCEPTION
177: WHEN others THEN
178: raise;
179: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXUTILB.addparamtoevent.end','');
182: end if;
183: END add_param_to_event;

Line 180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

176: EXCEPTION
177: WHEN others THEN
178: raise;
179: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXUTILB.addparamtoevent.end','');
182: end if;
183: END add_param_to_event;
184:

Line 219: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

215: where user_id = p_user_id;
216:
217: BEGIN
218:
219: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
221: 'fnd.plsql.UMXUTILB.assignwfRole.begin','itemkey: '||item_key);
222: end if;
223:

Line 220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

216:
217: BEGIN
218:
219: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
221: 'fnd.plsql.UMXUTILB.assignwfRole.begin','itemkey: '||item_key);
222: end if;
223:
224: if (command = 'RUN') then

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

257: end if;
258:
259: if (l_user_name is not null and l_wf_role_name is not null) then
260:
261: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
262: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
263: 'fnd.plsql.UMXUTILB','invoking propagateuserrole '||
264: 'rolename:'||l_wf_role_name||' username:'||l_user_name);
265: end if;

Line 262: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

258:
259: if (l_user_name is not null and l_wf_role_name is not null) then
260:
261: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
262: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
263: 'fnd.plsql.UMXUTILB','invoking propagateuserrole '||
264: 'rolename:'||l_wf_role_name||' username:'||l_user_name);
265: end if;
266:

Line 300: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

296: end if;
297: resultout := 'COMPLETE';
298: end if;
299:
300: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
301: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
302: 'fnd.plsql.UMXUTILB.assignwfRole.end','itemkey: '||item_key);
303: end if;
304:

Line 301: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

297: resultout := 'COMPLETE';
298: end if;
299:
300: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
301: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
302: 'fnd.plsql.UMXUTILB.assignwfRole.end','itemkey: '||item_key);
303: end if;
304:
305: EXCEPTION

Line 340: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
337: l_launch_workflow boolean := false;
338:
339: BEGIN
340: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
341: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
342: 'fnd.plsql.UMXUTILB.checkapprovaldefined.begin','itemkey: '||item_key);
343: end if;
344:

Line 341: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

337: l_launch_workflow boolean := false;
338:
339: BEGIN
340: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
341: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
342: 'fnd.plsql.UMXUTILB.checkapprovaldefined.begin','itemkey: '||item_key);
343: end if;
344:
345: if (command = 'RUN') then

Line 416: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

412: resultout := 'COMPLETE:N';
413: end if;
414: end if;
415:
416: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
417: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
418: 'fnd.plsql.UMXUTILB.checkapprovaldefined.end','itemkey: '||item_key);
419: end if;
420:

Line 417: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

413: end if;
414: end if;
415:
416: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
417: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
418: 'fnd.plsql.UMXUTILB.checkapprovaldefined.end','itemkey: '||item_key);
419: end if;
420:
421: EXCEPTION

Line 448: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

444:
445: l_identity_vrfy_reqd UMX_REG_SERVICES_B.EMAIL_VERIFICATION_FLAG%TYPE;
446: BEGIN
447:
448: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
449: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
450: 'fnd.plsql.UMXUTILB.checkidntyvrfyreqd.begin',
451: 'itemkey: '||item_key);
452: end if;

Line 449: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

445: l_identity_vrfy_reqd UMX_REG_SERVICES_B.EMAIL_VERIFICATION_FLAG%TYPE;
446: BEGIN
447:
448: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
449: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
450: 'fnd.plsql.UMXUTILB.checkidntyvrfyreqd.begin',
451: 'itemkey: '||item_key);
452: end if;
453:

Line 475: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

471: resultout := 'COMPLETE:NOTREQUIRED';
472: end if;
473: end if;
474:
475: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
476: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
477: 'fnd.plsql.UMXUTILB.checkidntyvrfyreqd.end',
478: 'itemkey: '||item_key);
479: end if;

Line 476: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

472: end if;
473: end if;
474:
475: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
476: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
477: 'fnd.plsql.UMXUTILB.checkidntyvrfyreqd.end',
478: 'itemkey: '||item_key);
479: end if;
480:

Line 511: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

507: l_username fnd_user.user_name%type;
508:
509: BEGIN
510:
511: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
513: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.begin',
514: 'item_type: '|| item_type || ' | itemkey: '||item_key);
515: end if;

Line 512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

508:
509: BEGIN
510:
511: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
513: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.begin',
514: 'item_type: '|| item_type || ' | itemkey: '||item_key);
515: end if;
516:

Line 532: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

528: end if;
529:
530: if (l_missing_attribute) then
531:
532: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
533: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
534: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.end',
535: 'Exception occurs because mandatory attribute (s) is/are missing: ' || l_message_tokens);
536: end if;

Line 533: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

529:
530: if (l_missing_attribute) then
531:
532: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
533: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
534: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.end',
535: 'Exception occurs because mandatory attribute (s) is/are missing: ' || l_message_tokens);
536: end if;
537:

Line 547: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

543: raise_application_error ('-20000', fnd_message.get);
544: end if;
545: end if;
546:
547: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
549: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.end',
550: 'item_type: '|| item_type || ' | itemkey: '|| item_key);
551: end if;

Line 548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

544: end if;
545: end if;
546:
547: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
549: 'fnd.plsql.UMXUTILB.check_mandatory_attributes.end',
550: 'item_type: '|| item_type || ' | itemkey: '|| item_key);
551: end if;
552:

Line 595: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

591: l_event wf_event_t;
592:
593: BEGIN
594:
595: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
596: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
597: 'fnd.plsql.UMXUTILB.createregrequest.begin',
598: 'itemkey: '||p_item_key);
599: end if;

Line 596: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

592:
593: BEGIN
594:
595: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
596: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
597: 'fnd.plsql.UMXUTILB.createregrequest.begin',
598: 'itemkey: '||p_item_key);
599: end if;
600:

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

606: ** this is the first method in the workflow so log all the
607: ** parameters passed to it (all params in event object).
608: **/
609:
610: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
611:
612: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
613: itemkey => p_item_key,
614: name => 'REGISTRATION_DATA');

Line 705: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

701: x_ame_transaction_type_id => l_ame_transaction_type_id,
702: x_justification => l_justification);
703: end if;
704:
705: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
706: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
707: 'fnd.plsql.UMXUTILB.createregrequest.end',
708: 'itemkey: '||p_item_key);
709: end if;

Line 706: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

702: x_justification => l_justification);
703: end if;
704:
705: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
706: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
707: 'fnd.plsql.UMXUTILB.createregrequest.end',
708: 'itemkey: '||p_item_key);
709: end if;
710:

Line 750: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

746: l_return_status pls_integer;
747:
748: BEGIN
749:
750: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
751: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
752: 'fnd.plsql.UMXUTILB.reserveusername.begin',
753: 'itemkey: '||p_item_key);
754: end if;

Line 751: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

747:
748: BEGIN
749:
750: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
751: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
752: 'fnd.plsql.UMXUTILB.reserveusername.begin',
753: 'itemkey: '||p_item_key);
754: end if;
755:

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

802:
803: add_param_to_event (p_item_type, p_item_key, 'DISPLAY_PASSWORD', l_password_message);
804:
805: -- Check if the username is available
806: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
807: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
808: 'fnd.plsql.UMXUTILB.reserveusername',
809: 'Before invoking fnd_user_pkg.TestUserName API with username is ' || l_username);
810: end if;

Line 807: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

803: add_param_to_event (p_item_type, p_item_key, 'DISPLAY_PASSWORD', l_password_message);
804:
805: -- Check if the username is available
806: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
807: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
808: 'fnd.plsql.UMXUTILB.reserveusername',
809: 'Before invoking fnd_user_pkg.TestUserName API with username is ' || l_username);
810: end if;
811:

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

810: end if;
811:
812: l_return_status := fnd_user_pkg.TestUserName (x_user_name => l_username);
813:
814: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
816: 'fnd.plsql.UMXUTILB.reserveusername',
817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);
818: end if;

Line 815: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

811:
812: l_return_status := fnd_user_pkg.TestUserName (x_user_name => l_username);
813:
814: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
816: 'fnd.plsql.UMXUTILB.reserveusername',
817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);
818: end if;
819:

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

836: avalue => l_password);
837: add_param_to_event (p_item_type, p_item_key, 'DISPLAY_PASSWORD', l_password);
838: end if;
839:
840: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
841: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
842: 'fnd.plsql.UMXUTILB.reserveusername',
843: 'Before invoking UMX_REG_REQUESTS_PVT.reserve_username API.');
844: end if;

Line 841: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

837: add_param_to_event (p_item_type, p_item_key, 'DISPLAY_PASSWORD', l_password);
838: end if;
839:
840: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
841: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
842: 'fnd.plsql.UMXUTILB.reserveusername',
843: 'Before invoking UMX_REG_REQUESTS_PVT.reserve_username API.');
844: end if;
845:

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

852: p_email_address => l_email_address,
853: p_fax => l_fax,
854: p_person_party_id => l_person_party_id);
855:
856: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
857: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
858: 'fnd.plsql.UMXUTILB.reserveusername',
859: 'userid: '||l_user_id);
860: end if;

Line 857: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

853: p_fax => l_fax,
854: p_person_party_id => l_person_party_id);
855:
856: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
857: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
858: 'fnd.plsql.UMXUTILB.reserveusername',
859: 'userid: '||l_user_id);
860: end if;
861:

Line 877: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

873: p_resultout := 'COMPLETE:N';
874: end if;
875: end if;
876:
877: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
878: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
879: 'fnd.plsql.UMXUTILB.reserveusername.end',
880: 'itemkey: '||p_item_key);
881: end if;

Line 878: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

874: end if;
875: end if;
876:
877: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
878: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
879: 'fnd.plsql.UMXUTILB.reserveusername.end',
880: 'itemkey: '||p_item_key);
881: end if;
882:

Line 911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

907: l_start_date DATE;
908: l_end_date DATE;
909: BEGIN
910:
911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
913: 'fnd.plsql.UMXUTILB.activateusername.begin',
914: 'itemkey: '||p_item_key);
915: end if;

Line 912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

908: l_end_date DATE;
909: BEGIN
910:
911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
913: 'fnd.plsql.UMXUTILB.activateusername.begin',
914: 'itemkey: '||p_item_key);
915: end if;
916:

Line 954: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

950: -- raise an error cannot activate user account with a person_party_id
951: -- there was an error somewhere not traped as party_id should not be
952: -- null here
953:
954: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
955: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
956: 'fnd.plsql.UMXUTILB.launchusernamepolicy',
957: 'person_party_id is null in activate username');
958: end if;

Line 955: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

951: -- there was an error somewhere not traped as party_id should not be
952: -- null here
953:
954: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
955: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
956: 'fnd.plsql.UMXUTILB.launchusernamepolicy',
957: 'person_party_id is null in activate username');
958: end if;
959:

Line 965: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

961: end if;
962: p_resultout := 'COMPLETE';
963: end if;
964:
965: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
966: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
967: 'fnd.plsql.UMXUTILB.activateusername.end',
968: 'itemkey: '||p_item_key);
969: end if;

Line 966: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

962: p_resultout := 'COMPLETE';
963: end if;
964:
965: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
966: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
967: 'fnd.plsql.UMXUTILB.activateusername.end',
968: 'itemkey: '||p_item_key);
969: end if;
970:

Line 995: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

991: l_userid FND_USER.user_id%type;
992:
993: BEGIN
994:
995: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
996: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
997: 'fnd.plsql.UMXUTILB.releaseusername.begin',
998: 'itemkey: '||p_item_key);
999: end if;

Line 996: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

992:
993: BEGIN
994:
995: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
996: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
997: 'fnd.plsql.UMXUTILB.releaseusername.begin',
998: 'itemkey: '||p_item_key);
999: end if;
1000:

Line 1020: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1016: p_username => l_username);
1017:
1018: end if;
1019:
1020: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1021: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1022: 'fnd.plsql.UMXUTILB.releaseusername.end',
1023: 'itemkey: '||p_item_key);
1024: end if;

Line 1021: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1017:
1018: end if;
1019:
1020: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1021: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1022: 'fnd.plsql.UMXUTILB.releaseusername.end',
1023: 'itemkey: '||p_item_key);
1024: end if;
1025:

Line 1051: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1047: l_event_type varchar2 (25);
1048:
1049: BEGIN
1050:
1051: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1052: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1053: 'fnd.plsql.UMXUTILB.incrementsequence.begin',
1054: 'itemkey: '||p_item_key);
1055: end if;

Line 1052: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1048:
1049: BEGIN
1050:
1051: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1052: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1053: 'fnd.plsql.UMXUTILB.incrementsequence.begin',
1054: 'itemkey: '||p_item_key);
1055: end if;
1056:

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

1061: actid => p_activity_id,
1062: aname => 'EVENT_TYPE',
1063: ignore_notfound => true);
1064:
1065: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1066: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1067: 'fnd.plsql.UMXUTILB.incrementsequence',
1068: 'eventtype: '||l_event_type);
1069: end if;

Line 1066: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1062: aname => 'EVENT_TYPE',
1063: ignore_notfound => true);
1064:
1065: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1066: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1067: 'fnd.plsql.UMXUTILB.incrementsequence',
1068: 'eventtype: '||l_event_type);
1069: end if;
1070:

Line 1086: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1082: p_resultout := 'COMPLETE';
1083:
1084: end if;
1085:
1086: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1087: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1088: 'fnd.plsql.UMXUTILB.incrementsequence.end',
1089: 'itemkey: '||p_item_key);
1090: end if;

Line 1087: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1083:
1084: end if;
1085:
1086: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1087: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1088: 'fnd.plsql.UMXUTILB.incrementsequence.end',
1089: 'itemkey: '||p_item_key);
1090: end if;
1091:

Line 1122: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1118: l_password varchar2 (100);
1119:
1120: BEGIN
1121:
1122: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1124: 'fnd.plsql.UMXUTILB.checkpasswordnull.begin',
1125: 'itemkey: '||item_key);
1126: end if;

Line 1123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1119:
1120: BEGIN
1121:
1122: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1124: 'fnd.plsql.UMXUTILB.checkpasswordnull.begin',
1125: 'itemkey: '||item_key);
1126: end if;
1127:

Line 1145: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1141: resultout := 'COMPLETE:N';
1142: end if;
1143: end if;
1144:
1145: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1146: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1147: 'fnd.plsql.UMXUTILB.checkpasswordnull.end',
1148: 'itemkey: '||item_key);
1149: end if;

Line 1146: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1142: end if;
1143: end if;
1144:
1145: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1146: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1147: 'fnd.plsql.UMXUTILB.checkpasswordnull.end',
1148: 'itemkey: '||item_key);
1149: end if;
1150:

Line 1182: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1178: l_parent_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
1179: l_parent_itemkey WF_ITEMS.ITEM_KEY%TYPE;
1180: begin
1181:
1182: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1183: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1184: 'fnd.plsql.UMXUTILB.seteventobject.begin',
1185: 'attrname: '||p_attr_name ||
1186: ' attrvalue: '|| p_attr_value);

Line 1183: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1179: l_parent_itemkey WF_ITEMS.ITEM_KEY%TYPE;
1180: begin
1181:
1182: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1183: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1184: 'fnd.plsql.UMXUTILB.seteventobject.begin',
1185: 'attrname: '||p_attr_name ||
1186: ' attrvalue: '|| p_attr_value);
1187: end if;

Line 1224: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1220: event => p_event);
1221:
1222: return 'success';
1223:
1224: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1225: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1226: 'fnd.plsql.UMXUTILB.seteventobject.end',
1227: '');
1228: end if;

Line 1225: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1221:
1222: return 'success';
1223:
1224: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1225: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1226: 'fnd.plsql.UMXUTILB.seteventobject.end',
1227: '');
1228: end if;
1229:

Line 1234: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1230: /**
1231: ** log all the params in event obj
1232: **/
1233:
1234: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1235: then
1236: print_Event_params (p_event => p_event);
1237: end if;
1238:

Line 1274: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1270: l_event wf_event_t;
1271:
1272: BEGIN
1273:
1274: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1276: 'fnd.plsql.UMXUTILB.updateregrequest.begin',
1277: 'itemkey: '||p_item_key);
1278: end if;

Line 1275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1271:
1272: BEGIN
1273:
1274: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1276: 'fnd.plsql.UMXUTILB.updateregrequest.begin',
1277: 'itemkey: '||p_item_key);
1278: end if;
1279:

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

1282: **/
1283:
1284: if (p_command = 'RUN') then
1285:
1286: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1287:
1288: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
1289: itemkey => p_item_key,
1290: name => 'REGISTRATION_DATA');

Line 1292: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1288: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
1289: itemkey => p_item_key,
1290: name => 'REGISTRATION_DATA');
1291: print_Event_params (p_event => l_event);
1292: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1293: 'fnd.plsql.UMXUTILB',
1294: 'regrequestid: '||p_item_key);
1295: end if;
1296:

Line 1389: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1385:
1386: p_resultout := 'COMPLETE';
1387: end if;
1388:
1389: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1390: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1391: 'fnd.plsql.UMXUTILB.updateregrequests.end',
1392: 'itemkey: '||p_item_key);
1393: end if;

Line 1390: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1386: p_resultout := 'COMPLETE';
1387: end if;
1388:
1389: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1390: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1391: 'fnd.plsql.UMXUTILB.updateregrequests.end',
1392: 'itemkey: '||p_item_key);
1393: end if;
1394:

Line 1414: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1410: l_event_key number;
1411: l_person_party_id fnd_user.person_party_id%type;
1412: BEGIN
1413:
1414: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1416: 'fnd.plsql.UMXUTILB.launchevent.begin',
1417: 'itemkey: '||item_key);
1418: end if;

Line 1415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1411: l_person_party_id fnd_user.person_party_id%type;
1412: BEGIN
1413:
1414: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1416: 'fnd.plsql.UMXUTILB.launchevent.begin',
1417: 'itemkey: '||item_key);
1418: end if;
1419:

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

1432:
1433: select UMX_EVENTS_S.nextval into l_event_key from dual;
1434: wf_event.raise ('oracle.apps.fnd.umx.createpersonparty',l_event_key,null,l_parameter_list,sysdate);
1435:
1436: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1437: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1438: 'fnd.plsql.UMXUTILB.launchevent',
1439: 'event_key: '||l_event_key);
1440: end if;

Line 1437: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1433: select UMX_EVENTS_S.nextval into l_event_key from dual;
1434: wf_event.raise ('oracle.apps.fnd.umx.createpersonparty',l_event_key,null,l_parameter_list,sysdate);
1435:
1436: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1437: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1438: 'fnd.plsql.UMXUTILB.launchevent',
1439: 'event_key: '||l_event_key);
1440: end if;
1441:

Line 1446: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1442:
1443: end if;
1444: end if;
1445:
1446: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1447: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1448: 'fnd.plsql.UMXUTILB.launchevent.end',
1449: 'itemkey: '||item_key);
1450: end if;

Line 1447: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1443: end if;
1444: end if;
1445:
1446: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1447: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1448: 'fnd.plsql.UMXUTILB.launchevent.end',
1449: 'itemkey: '||item_key);
1450: end if;
1451:

Line 1543: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1539: BEGIN
1540:
1541: if (command = 'RUN') then
1542:
1543: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1544: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1545: 'fnd.plsql.UMXUTILB.createadhocrole.begin',
1546: 'item_type: ' || item_type ||
1547: ' item_key: ' || item_key);

Line 1544: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1540:
1541: if (command = 'RUN') then
1542:
1543: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1544: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1545: 'fnd.plsql.UMXUTILB.createadhocrole.begin',
1546: 'item_type: ' || item_type ||
1547: ' item_key: ' || item_key);
1548: end if;

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

1589: itemtype => item_type,
1590: itemkey => item_key,
1591: aname => 'PERSON_SUFFIX');
1592:
1593: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1594: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1595: 'fnd.plsql.UMXUTILB.createadhocrole',
1596: 'calling hz_format_pub.format_name with ' ||
1597: 'p_person_first_name=>' || l_person_first_name ||

Line 1594: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1590: itemkey => item_key,
1591: aname => 'PERSON_SUFFIX');
1592:
1593: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1594: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1595: 'fnd.plsql.UMXUTILB.createadhocrole',
1596: 'calling hz_format_pub.format_name with ' ||
1597: 'p_person_first_name=>' || l_person_first_name ||
1598: ', p_person_middle_name=>' || l_person_middle_name ||

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

1613: x_formatted_name => l_formatted_name,
1614: x_formatted_lines_cnt => l_formatted_lines_cnt,
1615: x_formatted_name_tbl => l_formatted_name_tbl);
1616:
1617: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1618: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1619: 'fnd.plsql.UMXUTILB.createadhocrole',
1620: 'Done calling hz_format_pub.format_name with ' ||
1621: 'x_return_status=>' || l_return_status ||

Line 1618: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1614: x_formatted_lines_cnt => l_formatted_lines_cnt,
1615: x_formatted_name_tbl => l_formatted_name_tbl);
1616:
1617: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1618: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1619: 'fnd.plsql.UMXUTILB.createadhocrole',
1620: 'Done calling hz_format_pub.format_name with ' ||
1621: 'x_return_status=>' || l_return_status ||
1622: ', x_msg_count=>' || l_msg_data ||

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

1647: itemtype => item_type,
1648: itemkey => item_key,
1649: aname => 'EMAIL_ADDRESS');
1650:
1651: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1652: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1653: 'fnd.plsql.UMXUTILB.createadhocrole',
1654: 'before calling wf_directory.CreateAdHocRole:' ||
1655: ' l_ad_hoc_role: ' || l_ad_hoc_role ||

Line 1652: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1648: itemkey => item_key,
1649: aname => 'EMAIL_ADDRESS');
1650:
1651: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1652: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1653: 'fnd.plsql.UMXUTILB.createadhocrole',
1654: 'before calling wf_directory.CreateAdHocRole:' ||
1655: ' l_ad_hoc_role: ' || l_ad_hoc_role ||
1656: ' l_formatted_name: ' || l_formatted_name ||

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

1662: role_display_name => l_formatted_name,
1663: email_address => l_email_address,
1664: owner_tag => 'FND');
1665:
1666: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1667: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1668: 'fnd.plsql.UMXUTILB.createadhocrole',
1669: 'After calling wf_directory.CreateAdHocRole.');
1670: end if;

Line 1667: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1663: email_address => l_email_address,
1664: owner_tag => 'FND');
1665:
1666: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1667: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1668: 'fnd.plsql.UMXUTILB.createadhocrole',
1669: 'After calling wf_directory.CreateAdHocRole.');
1670: end if;
1671: end if;

Line 1707: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1703: p_item_key => item_key,
1704: p_attr_name => 'USER_ROLE_NAME',
1705: p_attr_value => l_ad_hoc_role);
1706:
1707: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1709: 'fnd.plsql.UMXUTILB.createadhocrole.end', '');
1710: end if;
1711: end if;

Line 1708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1704: p_attr_name => 'USER_ROLE_NAME',
1705: p_attr_value => l_ad_hoc_role);
1706:
1707: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1709: 'fnd.plsql.UMXUTILB.createadhocrole.end', '');
1710: end if;
1711: end if;
1712:

Line 1746: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1742: begin
1743:
1744: if (command = 'RUN') then
1745:
1746: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1747: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1748: 'fnd.plsql.UMXUTILB.releaseadhocrole.end',
1749: 'item_type: ' || item_type ||
1750: ' item_key: ' || item_key);

Line 1747: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1743:
1744: if (command = 'RUN') then
1745:
1746: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1747: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1748: 'fnd.plsql.UMXUTILB.releaseadhocrole.end',
1749: 'item_type: ' || item_type ||
1750: ' item_key: ' || item_key);
1751: end if;

Line 1779: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1775: end if;
1776:
1777: end if;
1778:
1779: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1781: 'fnd.plsql.UMXUTILB.releaseadhocrole.end', '');
1782: end if;
1783: end if;

Line 1780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1776:
1777: end if;
1778:
1779: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1781: 'fnd.plsql.UMXUTILB.releaseadhocrole.end', '');
1782: end if;
1783: end if;
1784:

Line 1800: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1796: p_command in varchar2,
1797: p_resultout out NOCOPY varchar2) is
1798: Begin
1799: --null;
1800: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1801: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1802: 'fnd.plsql.UMXUTILB.rejectrequest.begin',
1803: 'itemkey: '||p_item_key);
1804: end if;

Line 1801: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1797: p_resultout out NOCOPY varchar2) is
1798: Begin
1799: --null;
1800: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1801: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1802: 'fnd.plsql.UMXUTILB.rejectrequest.begin',
1803: 'itemkey: '||p_item_key);
1804: end if;
1805:

Line 1809: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1805:
1806: umx_reg_requests_pvt.reject_reg_request
1807: (p_reg_request_id => to_number (p_item_key));
1808:
1809: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1811: 'fnd.plsql.UMXUTILB.cancelusername.begin',
1812: 'itemkey: '||p_item_key);
1813: end if;

Line 1810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1806: umx_reg_requests_pvt.reject_reg_request
1807: (p_reg_request_id => to_number (p_item_key));
1808:
1809: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1811: 'fnd.plsql.UMXUTILB.cancelusername.begin',
1812: 'itemkey: '||p_item_key);
1813: end if;
1814: End reject_request;

Line 1838: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1834: l_username FND_USER.user_name%type;
1835: l_userid FND_USER.user_id%type;
1836: Begin
1837:
1838: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1839: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1840: 'fnd.plsql.UMXUTILB.cancelusername.begin',
1841: 'itemkey: '||p_item_key);
1842: end if;

Line 1839: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1835: l_userid FND_USER.user_id%type;
1836: Begin
1837:
1838: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1839: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1840: 'fnd.plsql.UMXUTILB.cancelusername.begin',
1841: 'itemkey: '||p_item_key);
1842: end if;
1843:

Line 1863: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1859: p_username => l_username);
1860:
1861: end if;
1862:
1863: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1864: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1865: 'fnd.plsql.UMXUTILB.cancelusername.end',
1866: 'itemkey: '||p_item_key);
1867: end if;

Line 1864: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1860:
1861: end if;
1862:
1863: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1864: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1865: 'fnd.plsql.UMXUTILB.cancelusername.end',
1866: 'itemkey: '||p_item_key);
1867: end if;
1868:

Line 1892: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1888: p_resultout out NOCOPY varchar2) is
1889: l_userid FND_USER.user_id%type;
1890: Begin
1891:
1892: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1893: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1894: 'fnd.plsql.UMXUTILB.updateuserstatus.begin',
1895: 'itemkey: '||p_item_key);
1896: end if;

Line 1893: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1889: l_userid FND_USER.user_id%type;
1890: Begin
1891:
1892: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1893: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1894: 'fnd.plsql.UMXUTILB.updateuserstatus.begin',
1895: 'itemkey: '||p_item_key);
1896: end if;
1897:

Line 1911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1907: X_STATUS_CODE => 'PENDING');
1908:
1909: end if;
1910:
1911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1913: 'fnd.plsql.UMXUTILB.updateuserstatus.end',
1914: 'itemkey: '||p_item_key);
1915: end if;

Line 1912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1908:
1909: end if;
1910:
1911: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1912: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1913: 'fnd.plsql.UMXUTILB.updateuserstatus.end',
1914: 'itemkey: '||p_item_key);
1915: end if;
1916:

Line 2023: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2019: l_icm_region varchar2 (4000);
2020:
2021: BEGIN
2022:
2023: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2024: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2025: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK.begin',
2026: 'item_type=' || item_type ||
2027: ', item_key=' || item_key);

Line 2024: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2020:
2021: BEGIN
2022:
2023: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2024: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2025: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK.begin',
2026: 'item_type=' || item_type ||
2027: ', item_key=' || item_key);
2028: end if;

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

2030: -- First check the UMX_ENABLE_ICM_VALIDATION profile option value
2031: fnd_profile.get (name => 'UMX_ENABLE_ICM_VALIDATION',
2032: val => l_icm_enabled);
2033:
2034: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2035: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2036: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2037: 'Is ICM enabled? ' || l_icm_enabled);
2038: end if;

Line 2035: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2031: fnd_profile.get (name => 'UMX_ENABLE_ICM_VALIDATION',
2032: val => l_icm_enabled);
2033:
2034: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2035: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2036: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2037: 'Is ICM enabled? ' || l_icm_enabled);
2038: end if;
2039:

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

2040: if (l_icm_enabled = 'Y') then
2041: -- Call the ICM API Here
2042: if (AMW_VIOLATION_PVT.Is_ICM_Installed = 'Y') then
2043:
2044: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2045: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2046: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2047: 'ICM is installed.');
2048: end if;

Line 2045: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2041: -- Call the ICM API Here
2042: if (AMW_VIOLATION_PVT.Is_ICM_Installed = 'Y') then
2043:
2044: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2045: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2046: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2047: 'ICM is installed.');
2048: end if;
2049:

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

2063: l_wf_role_names := jtf_varchar2_table_400 ();
2064: l_wf_role_names.EXTEND;
2065: l_wf_role_names (1) := l_wf_role_name;
2066:
2067: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2068: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2069: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2070: 'Before calling AMW_VIOLATION_PVT.Has_Violations_For_Mode with p_user_id=' || l_requested_for_user_id ||
2071: ', p_role_names=' || l_wf_role_name || ', and p_mode=APPROVE');

Line 2068: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2064: l_wf_role_names.EXTEND;
2065: l_wf_role_names (1) := l_wf_role_name;
2066:
2067: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2068: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2069: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2070: 'Before calling AMW_VIOLATION_PVT.Has_Violations_For_Mode with p_user_id=' || l_requested_for_user_id ||
2071: ', p_role_names=' || l_wf_role_name || ', and p_mode=APPROVE');
2072: end if;

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

2076: p_role_names => l_wf_role_names,
2077: p_mode => 'APPROVE',
2078: x_violat_hashtable => l_amw_results_table);
2079:
2080: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2081: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2082: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2083: 'After calling AMW_VIOLATION_PVT.Has_Violations_For_Mode');
2084: end if;

Line 2081: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2077: p_mode => 'APPROVE',
2078: x_violat_hashtable => l_amw_results_table);
2079:
2080: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2081: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2082: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2083: 'After calling AMW_VIOLATION_PVT.Has_Violations_For_Mode');
2084: end if;
2085:

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

2084: end if;
2085:
2086: l_has_violations := l_amw_results_table ('HasViolations');
2087:
2088: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2089: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2090: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2091: 'l_has_violations is ' || l_has_violations);
2092: end if;

Line 2089: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2085:
2086: l_has_violations := l_amw_results_table ('HasViolations');
2087:
2088: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2089: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2090: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2091: 'l_has_violations is ' || l_has_violations);
2092: end if;
2093:

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

2094: if (l_has_violations = 'Y') then
2095: -- add parameters to the main workflow
2096: l_icm_region := l_amw_results_table ('ViolationDetail');
2097:
2098: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2100: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2101: 'l_icm_region is ' || l_icm_region);
2102: end if;

Line 2099: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2095: -- add parameters to the main workflow
2096: l_icm_region := l_amw_results_table ('ViolationDetail');
2097:
2098: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2100: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2101: 'l_icm_region is ' || l_icm_region);
2102: end if;
2103:

Line 2130: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2126: end if;
2127: end if;
2128: end if;
2129:
2130: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2131: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2132: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK.end',
2133: 'l_has_violations=' || l_has_violations ||
2134: ', l_icm_region=' || l_icm_region);

Line 2131: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2127: end if;
2128: end if;
2129:
2130: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2131: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2132: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK.end',
2133: 'l_has_violations=' || l_has_violations ||
2134: ', l_icm_region=' || l_icm_region);
2135: end if;

Line 2169: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2165: l_suggested_username FND_USER.USER_NAME%TYPE;
2166:
2167: BEGIN
2168:
2169: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2170: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2171: 'fnd.plsql.UMXUTILB.launchusernamepolicy.begin',
2172: 'itemkey: '||item_key);
2173: end if;

Line 2170: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2166:
2167: BEGIN
2168:
2169: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2170: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2171: 'fnd.plsql.UMXUTILB.launchusernamepolicy.begin',
2172: 'itemkey: '||item_key);
2173: end if;
2174:

Line 2200: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2196: resultout :='COMPLETE:T';
2197: end if;
2198: end if;
2199:
2200: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2201: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2202: 'fnd.plsql.UMXUTILB.launchusernamepolicy.end',
2203: 'itemkey: '||item_key);
2204: end if;

Line 2201: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2197: end if;
2198: end if;
2199:
2200: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2201: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2202: 'fnd.plsql.UMXUTILB.launchusernamepolicy.end',
2203: 'itemkey: '||item_key);
2204: end if;
2205:

Line 2234: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2230:
2231: l_username FND_USER.USER_NAME%TYPE;
2232: BEGIN
2233:
2234: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2235: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2236: 'fnd.plsql.UMXUTILB.checkusernamenull.begin',
2237: 'itemkey: '||item_key);
2238: end if;

Line 2235: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2231: l_username FND_USER.USER_NAME%TYPE;
2232: BEGIN
2233:
2234: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2235: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2236: 'fnd.plsql.UMXUTILB.checkusernamenull.begin',
2237: 'itemkey: '||item_key);
2238: end if;
2239:

Line 2253: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2249: resultout := 'COMPLETE:N';
2250: end if;
2251: end if;
2252:
2253: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2255: 'fnd.plsql.UMXUTILB.checkusernamenull.end',
2256: 'itemkey: '||item_key);
2257: end if;

Line 2254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2250: end if;
2251: end if;
2252:
2253: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2255: 'fnd.plsql.UMXUTILB.checkusernamenull.end',
2256: 'itemkey: '||item_key);
2257: end if;
2258: