DBA Data[Home] [Help]

APPS.UMX_NOTIFICATION_UTIL dependencies on FND_LOG

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

35: BEGIN
36:
37: if (command = 'RUN') then
38:
39: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
40: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
41: 'fnd.plsql.UMXNTFSB.CheckContext.begin', 'Begin');
42: end if;
43:

Line 40: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

36:
37: if (command = 'RUN') then
38:
39: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
40: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
41: 'fnd.plsql.UMXNTFSB.CheckContext.begin', 'Begin');
42: end if;
43:
44: /**

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

44: /**
45: ** this is the first method print all the variables in the event obj
46: **/
47:
48: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
49:
50: l_event := wf_engine.getitemattrevent (itemtype => item_type,
51: itemkey => item_key,
52: name => 'REGISTRATION_DATA');

Line 57: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

53:
54: l_parameter_list := l_event.getparameterlist ();
55:
56: for i in 1..l_parameter_list.count loop
57: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
58: 'fnd.plsql.UMXNTFSB.check_context',
59: ' parameter name:'||l_parameter_list (i).getName ()||
60: ' value:'||l_parameter_list (i).getValue ());
61: end loop;

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

102: end if;
103:
104: end if;
105:
106: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
108: 'fnd.plsql.UMXNTFSB.CheckContext.end', 'End');
109: end if;
110:

Line 107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

103:
104: end if;
105:
106: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
108: 'fnd.plsql.UMXNTFSB.CheckContext.end', 'End');
109: end if;
110:
111: end if;

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

142:
143: BEGIN
144:
145: if (command = 'RUN') then
146: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
148: 'fnd.plsql.UMXNTFSB.notificationprocessdone.begin', 'Begin');
149: end if;
150:

Line 147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

143: BEGIN
144:
145: if (command = 'RUN') then
146: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
148: 'fnd.plsql.UMXNTFSB.notificationprocessdone.begin', 'Begin');
149: end if;
150:
151: l_registration_data :=

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

183: wf_event.raise ('oracle.apps.fnd.umx.notificationdone', l_parent_itemkey,
184: null,l_parameter_list,sysdate);
185: resultout := 'COMPLETE';
186:
187: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
189: 'fnd.plsql.UMXNTFSB.notificationprocessdone.end', 'End');
190: end if;
191: end if;

Line 188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

184: null,l_parameter_list,sysdate);
185: resultout := 'COMPLETE';
186:
187: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
189: 'fnd.plsql.UMXNTFSB.notificationprocessdone.end', 'End');
190: end if;
191: end if;
192:

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

249: BEGIN
250:
251: if (command = 'RUN') then
252:
253: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
255: 'fnd.plsql.UMXNTFSB.getnextapprover.begin', 'Begin');
256: end if;
257:

Line 254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

250:
251: if (command = 'RUN') then
252:
253: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
255: 'fnd.plsql.UMXNTFSB.getnextapprover.begin', 'Begin');
256: end if;
257:
258: l_ame_application_id := wf_engine.getitemattrtext (

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

277: p_ame_transaction_type_id => l_ame_transaction_type_id,
278: p_reg_request_id => l_reg_request_id);
279: l_approver_name := l_next_approver.name;
280:
281: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
282: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
283: 'fnd.plsql.UMXNTFSB.getnextapprover',
284: 'approver name:'|| l_approver_name);
285: end if;

Line 282: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

278: p_reg_request_id => l_reg_request_id);
279: l_approver_name := l_next_approver.name;
280:
281: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
282: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
283: 'fnd.plsql.UMXNTFSB.getnextapprover',
284: 'approver name:'|| l_approver_name);
285: end if;
286:

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

355: itemtype => item_type,
356: itemkey => item_key,
357: aname => 'PRE_NAME_ADJUNCT');
358:
359: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
360: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
361: 'fnd.plsql.UMXNTFSB.getnextapprover',
362: 'Before calling hz_format_pub.format_name (' ||
363: l_person_first_name || ',' || l_person_middle_name ||

Line 360: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

356: itemkey => item_key,
357: aname => 'PRE_NAME_ADJUNCT');
358:
359: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
360: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
361: 'fnd.plsql.UMXNTFSB.getnextapprover',
362: 'Before calling hz_format_pub.format_name (' ||
363: l_person_first_name || ',' || l_person_middle_name ||
364: l_person_last_name || ',' || l_prefix ||

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

377: x_formatted_name => l_role_display_name,
378: x_formatted_lines_cnt => l_formatted_lines_cnt,
379: x_formatted_name_tbl => l_formatted_name_tbl);
380:
381: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
382: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
383: 'fnd.plsql.UMXNTFSB.getnextapprover',
384: 'After calling hz_format_pub.format_name (' ||
385: l_return_status || ',' || l_msg_count ||

Line 382: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

378: x_formatted_lines_cnt => l_formatted_lines_cnt,
379: x_formatted_name_tbl => l_formatted_name_tbl);
380:
381: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
382: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
383: 'fnd.plsql.UMXNTFSB.getnextapprover',
384: 'After calling hz_format_pub.format_name (' ||
385: l_return_status || ',' || l_msg_count ||
386: l_role_display_name || ',' || l_formatted_lines_cnt || ')');

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

437: else
438: resultout := 'COMPLETE:F';
439: end if;
440:
441: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
442: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
443: 'fnd.plsql.UMXNTFSB.getnextapprover.end', 'End');
444: end if;
445: end if;

Line 442: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

438: resultout := 'COMPLETE:F';
439: end if;
440:
441: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
442: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
443: 'fnd.plsql.UMXNTFSB.getnextapprover.end', 'End');
444: end if;
445: end if;
446:

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

509: begin
510:
511: if (command = 'RUN') then
512:
513: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
514: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
515: 'fnd.plsql.UMXNTFSB.getreceipientusername.begin', 'Begin');
516: end if;
517:

Line 514: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

510:
511: if (command = 'RUN') then
512:
513: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
514: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
515: 'fnd.plsql.UMXNTFSB.getreceipientusername.begin', 'Begin');
516: end if;
517:
518: l_first_name := wf_engine.getitemattrtext (

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

706: end if;
707:
708: resultout := 'COMPLETE:';
709:
710: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
711: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
712: 'fnd.plsql.UMXNTFSB.getrecipientusername.end', 'End');
713: end if;
714:

Line 711: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

707:
708: resultout := 'COMPLETE:';
709:
710: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
711: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
712: 'fnd.plsql.UMXNTFSB.getrecipientusername.end', 'End');
713: end if;
714:
715: end if; --command = run

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

745: BEGIN
746:
747: if (command = 'RUN') then
748:
749: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
751: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.begin', 'Begin');
752: end if;
753:

Line 750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

746:
747: if (command = 'RUN') then
748:
749: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
751: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.begin', 'Begin');
752: end if;
753:
754: -- get the next approver record again, this will not increment

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

775: l_current_approver := umx_reg_requests_pvt.getNextApproverPvt (p_ame_application_id => l_ame_application_id,
776: p_ame_transaction_type_id => l_ame_transaction_type_id,
777: p_reg_request_id => l_reg_request_id);
778:
779: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
780: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
781: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
782: 'approver username:'|| l_current_approver.name);
783: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

Line 780: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

776: p_ame_transaction_type_id => l_ame_transaction_type_id,
777: p_reg_request_id => l_reg_request_id);
778:
779: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
780: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
781: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
782: 'approver username:'|| l_current_approver.name);
783: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
784: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',

Line 783: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

779: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
780: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
781: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
782: 'approver username:'|| l_current_approver.name);
783: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
784: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
785: 'Before calling ame_api2.updateapprovalstatus (' ||
786: l_ame_application_id || ',' || l_ame_transaction_type_id || ',' ||
787: l_reg_request_id || ',' || l_current_approver.name || ')');

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

792: transactionTypeIn => l_ame_transaction_type_id,
793: transactionIdIn => l_reg_request_id,
794: approverIn => l_current_approver);
795:
796: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
798: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
799: 'After calling ame_api2.updateapprovalstatus.');
800: end if;

Line 797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

793: transactionIdIn => l_reg_request_id,
794: approverIn => l_current_approver);
795:
796: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
798: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
799: 'After calling ame_api2.updateapprovalstatus.');
800: end if;
801:

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

798: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
799: 'After calling ame_api2.updateapprovalstatus.');
800: end if;
801:
802: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
803: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
804: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.end', 'End');
805: end if;
806:

Line 803: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

799: 'After calling ame_api2.updateapprovalstatus.');
800: end if;
801:
802: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
803: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
804: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.end', 'End');
805: end if;
806:
807: end if;

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

830: BEGIN
831:
832: if (command = 'RUN') then
833:
834: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
835: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
836: 'fnd.plsql.UMXNTFSB.updateRejectedStatus.begin', 'Begin');
837: end if;
838:

Line 835: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

831:
832: if (command = 'RUN') then
833:
834: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
835: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
836: 'fnd.plsql.UMXNTFSB.updateRejectedStatus.begin', 'Begin');
837: end if;
838:
839: -- get the next approver record again, this will not increment

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

859: l_current_approver := umx_reg_requests_pvt.getNextApproverPvt (p_ame_application_id => l_ame_application_id,
860: p_ame_transaction_type_id => l_ame_transaction_type_id,
861: p_reg_request_id => l_reg_request_id);
862:
863: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
864: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
865: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
866: 'approver username:'|| l_current_approver.name);
867: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

Line 864: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

860: p_ame_transaction_type_id => l_ame_transaction_type_id,
861: p_reg_request_id => l_reg_request_id);
862:
863: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
864: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
865: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
866: 'approver username:'|| l_current_approver.name);
867: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
868: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',

Line 867: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

863: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
864: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
865: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
866: 'approver username:'|| l_current_approver.name);
867: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
868: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
869: 'Before calling ame_api2.updateapprovalstatus (' ||
870: l_ame_application_id || ',' || l_ame_transaction_type_id || ',' ||
871: l_reg_request_id || ',' || l_current_approver.name || ')');

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

876: transactionTypeIn => l_ame_transaction_type_id,
877: transactionIdIn => l_reg_request_id,
878: approverIn => l_current_approver);
879:
880: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
881: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
882: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
883: 'After calling ame_api2.updateapprovalstatus.');
884: end if;

Line 881: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

877: transactionIdIn => l_reg_request_id,
878: approverIn => l_current_approver);
879:
880: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
881: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
882: 'fnd.plsql.UMXNTFSB.updateRejectedStatus',
883: 'After calling ame_api2.updateapprovalstatus.');
884: end if;
885:

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

898: itemkey => item_key,
899: name => 'REGISTRATION_DATA',
900: event => l_event);
901:
902: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
903: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
904: 'fnd.plsql.UMXNTFSB.updaterejectedstatus.end', 'End');
905: end if;
906:

Line 903: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

899: name => 'REGISTRATION_DATA',
900: event => l_event);
901:
902: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
903: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
904: 'fnd.plsql.UMXNTFSB.updaterejectedstatus.end', 'End');
905: end if;
906:
907: end if;

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

937: BEGIN
938:
939: if (command = 'RUN') then
940:
941: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
942: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
943: 'fnd.plsql.UMXNTFSB.queryroledisplayname.begin', 'Begin');
944: end if;
945:

Line 942: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

938:
939: if (command = 'RUN') then
940:
941: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
942: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
943: 'fnd.plsql.UMXNTFSB.queryroledisplayname.begin', 'Begin');
944: end if;
945:
946: l_role_name := wf_engine.getitemattrtext (itemtype => item_type,

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

969: end if;
970:
971: resultout := 'COMPLETE';
972:
973: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
975: 'fnd.plsql.UMXNTFSB.queryRoleDisplayName.end',
976: 'roleDisplayName:'|| l_role_display_name);
977: end if;

Line 974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

970:
971: resultout := 'COMPLETE';
972:
973: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
975: 'fnd.plsql.UMXNTFSB.queryRoleDisplayName.end',
976: 'roleDisplayName:'|| l_role_display_name);
977: end if;
978: end if;