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:
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: /**
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');
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;
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:
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;
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:
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 :=
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;
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:
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:
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 (
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;
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:
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 ||
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 ||
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 ||
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 || ')');
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;
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:
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:
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 (
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:
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
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:
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
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,
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',
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 || ')');
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;
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:
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:
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;
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:
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
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,
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',
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 || ')');
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;
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:
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:
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;
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:
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,
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;
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;