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 706: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

702: end if;
703:
704: resultout := 'COMPLETE:';
705:
706: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
708: 'fnd.plsql.UMXNTFSB.getrecipientusername.end', 'End');
709: end if;
710:

Line 707: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

703:
704: resultout := 'COMPLETE:';
705:
706: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
708: 'fnd.plsql.UMXNTFSB.getrecipientusername.end', 'End');
709: end if;
710:
711: end if; --command = run

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

741: BEGIN
742:
743: if (command = 'RUN') then
744:
745: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
746: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
747: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.begin', 'Begin');
748: end if;
749:

Line 746: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 776: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

Line 779: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 793: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

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

794: 'fnd.plsql.UMXNTFSB.updateapprovalstatus',
795: 'After calling ame_api2.updateapprovalstatus.');
796: end if;
797:
798: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
799: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
800: 'fnd.plsql.UMXNTFSB.updateapprovalstatus.end', 'End');
801: end if;
802:

Line 799: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

826: BEGIN
827:
828: if (command = 'RUN') then
829:
830: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
831: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
832: 'fnd.plsql.UMXNTFSB.updateRejectedStatus.begin', 'Begin');
833: end if;
834:

Line 831: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 860: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

Line 863: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 877: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 899: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

895: name => 'REGISTRATION_DATA',
896: event => l_event);
897:
898: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
899: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
900: 'fnd.plsql.UMXNTFSB.updaterejectedstatus.end', 'End');
901: end if;
902:
903: end if;

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

933: BEGIN
934:
935: if (command = 'RUN') then
936:
937: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
938: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
939: 'fnd.plsql.UMXNTFSB.queryroledisplayname.begin', 'Begin');
940: end if;
941:

Line 938: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

965: end if;
966:
967: resultout := 'COMPLETE';
968:
969: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
970: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
971: 'fnd.plsql.UMXNTFSB.queryRoleDisplayName.end',
972: 'roleDisplayName:'|| l_role_display_name);
973: end if;

Line 970: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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