745: fnd_message.Set_token('TEXT', 'Referral Status changed: ');
746: fnd_msg_pub.Add;
747: END IF;
748: -- Once the parameters for workflow is validated, start the workflow
749: wf_engine.CreateProcess (ItemType => l_itemType,
750: ItemKey => l_itemKey,
751: process => g_wf_pcs_notify_ptnr);
752:
753: wf_engine.SetItemUserKey (ItemType => l_itemType,
749: wf_engine.CreateProcess (ItemType => l_itemType,
750: ItemKey => l_itemKey,
751: process => g_wf_pcs_notify_ptnr);
752:
753: wf_engine.SetItemUserKey (ItemType => l_itemType,
754: ItemKey => l_itemKey,
755: userKey => l_itemkey);
756:
757: --setting lead status so that it can be used in notify function
754: ItemKey => l_itemKey,
755: userKey => l_itemkey);
756:
757: --setting lead status so that it can be used in notify function
758: wf_engine.SetItemAttrText (ItemType => l_itemType,
759: ItemKey => l_itemKey,
760: aname => g_wf_attr_lead_status,
761: avalue => l_referral_status);
762:
761: avalue => l_referral_status);
762:
763:
764: --setting lead status so that it can be used in notify function
765: wf_engine.SetItemAttrText (ItemType => l_itemType,
766: ItemKey => l_itemKey,
767: aname => g_wf_attr_lead_status_mean,
768: avalue => l_referral_status_meaning);
769:
767: aname => g_wf_attr_lead_status_mean,
768: avalue => l_referral_status_meaning);
769:
770:
771: wf_engine.SetItemAttrText ( ItemType => l_itemType,
772: ItemKey => l_itemKey,
773: aname => g_wf_attr_cust_name,
774: avalue => l_customer_name);
775:
772: ItemKey => l_itemKey,
773: aname => g_wf_attr_cust_name,
774: avalue => l_customer_name);
775:
776: wf_engine.SetItemAttrText (ItemType => l_itemType,
777: ItemKey => l_itemKey,
778: aname => g_wf_attr_referral_type,
779: avalue => l_referral_type);
780:
777: ItemKey => l_itemKey,
778: aname => g_wf_attr_referral_type,
779: avalue => l_referral_type);
780:
781: wf_engine.SetItemAttrText (ItemType => l_itemType,
782: ItemKey => l_itemKey,
783: aname => g_wf_attr_referral_type_mean,
784: avalue => l_referral_type_meaning);
785:
782: ItemKey => l_itemKey,
783: aname => g_wf_attr_referral_type_mean,
784: avalue => l_referral_type_meaning);
785:
786: wf_engine.SetItemAttrText ( ItemType => l_itemType,
787: ItemKey => l_itemKey,
788: aname => g_wf_attr_ptnr_user_name,
789: avalue => l_ptnr_user_name);
790:
787: ItemKey => l_itemKey,
788: aname => g_wf_attr_ptnr_user_name,
789: avalue => l_ptnr_user_name);
790:
791: wf_engine.SetItemAttrText ( ItemType => l_itemType,
792: ItemKey => l_itemKey,
793: aname => g_wf_attr_cust_state,
794: avalue => l_customer_state);
795:
792: ItemKey => l_itemKey,
793: aname => g_wf_attr_cust_state,
794: avalue => l_customer_state);
795:
796: wf_engine.SetItemAttrText ( ItemType => l_itemType,
797: ItemKey => l_itemKey,
798: aname => g_wf_attr_cust_country,
799: avalue => l_customer_country);
800:
797: ItemKey => l_itemKey,
798: aname => g_wf_attr_cust_country,
799: avalue => l_customer_country);
800:
801: wf_engine.SetItemAttrText ( ItemType => l_itemType,
802: ItemKey => l_itemKey,
803: aname => g_wf_attr_declined_reason,
804: avalue => l_ref_decline_reason);
805:
802: ItemKey => l_itemKey,
803: aname => g_wf_attr_declined_reason,
804: avalue => l_ref_decline_reason);
805:
806: wf_engine.SetItemAttrText ( ItemType => l_itemType,
807: ItemKey => l_itemKey,
808: aname => g_wf_attr_dec_reason_mean,
809: avalue => l_ref_decline_reason_meaning);
810:
807: ItemKey => l_itemKey,
808: aname => g_wf_attr_dec_reason_mean,
809: avalue => l_ref_decline_reason_meaning);
810:
811: wf_engine.SetItemAttrText ( ItemType => l_itemType,
812: ItemKey => l_itemKey,
813: aname => g_wf_attr_ptnr_org_name,
814: avalue => l_ptnr_org_name);
815:
813: aname => g_wf_attr_ptnr_org_name,
814: avalue => l_ptnr_org_name);
815:
816:
817: wf_engine.SetItemAttrText ( ItemType => l_itemType,
818: ItemKey => l_itemKey,
819: aname => g_wf_attr_referral_commission,
820: avalue => l_ref_comm_amt);
821:
819: aname => g_wf_attr_referral_commission,
820: avalue => l_ref_comm_amt);
821:
822:
823: wf_engine.SetItemAttrText (ItemType => l_itemType,
824: ItemKey => l_itemKey,
825: aname => g_wf_attr_create_notify_role,
826: avalue => l_notify_role);
827:
824: ItemKey => l_itemKey,
825: aname => g_wf_attr_create_notify_role,
826: avalue => l_notify_role);
827:
828: wf_engine.SetItemAttrText (ItemType => l_itemType,
829: ItemKey => l_itemKey,
830: aname => g_wf_attr_create_ptnr_role,
831: avalue => l_notify_ptnr_role);
832:
830: aname => g_wf_attr_create_ptnr_role,
831: avalue => l_notify_ptnr_role);
832:
833:
834: wf_engine.SetItemAttrText (ItemType => l_itemType,
835: ItemKey => l_itemKey,
836: aname => g_wf_attr_accept_notify_role,
837: avalue => l_notify_role);
838:
835: ItemKey => l_itemKey,
836: aname => g_wf_attr_accept_notify_role,
837: avalue => l_notify_role);
838:
839: wf_engine.SetItemAttrText (ItemType => l_itemType,
840: ItemKey => l_itemKey,
841: aname => g_wf_attr_reject_notify_role,
842: avalue => l_notify_role);
843:
840: ItemKey => l_itemKey,
841: aname => g_wf_attr_reject_notify_role,
842: avalue => l_notify_role);
843:
844: wf_engine.SetItemAttrText (ItemType => l_itemType,
845: ItemKey => l_itemKey,
846: aname => g_wf_attr_referral_notify_role,
847: avalue => l_notify_role);
848:
845: ItemKey => l_itemKey,
846: aname => g_wf_attr_referral_notify_role,
847: avalue => l_notify_role);
848:
849: wf_engine.SetItemAttrText (ItemType => l_itemType,
850: ItemKey => l_itemKey,
851: aname => g_wf_attr_respond_url,
852: avalue =>l_workflow_respond_url );
853:
851: aname => g_wf_attr_respond_url,
852: avalue =>l_workflow_respond_url );
853:
854:
855: wf_engine.SetItemAttrText (ItemType => l_itemType,
856: ItemKey => l_itemKey,
857: aname => g_wf_attr_sales_lead_id,
858: avalue =>l_lead_id );
859:
856: ItemKey => l_itemKey,
857: aname => g_wf_attr_sales_lead_id,
858: avalue =>l_lead_id );
859:
860: wf_engine.SetItemAttrText (ItemType => l_itemType,
861: ItemKey => l_itemKey,
862: aname => g_wf_attr_referred_by,
863: avalue =>l_referred_by );
864:
861: ItemKey => l_itemKey,
862: aname => g_wf_attr_referred_by,
863: avalue =>l_referred_by );
864:
865: wf_engine.SetItemAttrText ( ItemType => l_itemType,
866: ItemKey => l_itemKey,
867: aname =>g_wf_attr_lead_name ,
868: avalue => l_lead_name);
869:
866: ItemKey => l_itemKey,
867: aname =>g_wf_attr_lead_name ,
868: avalue => l_lead_name);
869:
870: wf_engine.SetItemAttrText ( ItemType => l_itemType,
871: ItemKey => l_itemKey,
872: aname =>g_wf_attr_created_by ,
873: avalue => l_created_by);
874:
872: aname =>g_wf_attr_created_by ,
873: avalue => l_created_by);
874:
875:
876: wf_engine.SetItemAttrText ( ItemType => l_itemType,
877: ItemKey => l_itemKey,
878: aname =>g_wf_attr_category ,
879: avalue => l_category);
880:
877: ItemKey => l_itemKey,
878: aname =>g_wf_attr_category ,
879: avalue => l_category);
880:
881: wf_engine.SetItemAttrText ( ItemType => l_itemType,
882: ItemKey => l_itemKey,
883: aname =>g_wf_attr_ptnr_full_name ,
884: avalue => l_ptnr_full_name);
885:
882: ItemKey => l_itemKey,
883: aname =>g_wf_attr_ptnr_full_name ,
884: avalue => l_ptnr_full_name);
885:
886: /* wf_engine.SetItemAttrText ( ItemType => l_itemType,
887: ItemKey => l_itemKey,
888: aname => g_wf_attr_referral_closedate,
889: avalue => l_referral_closedate);*/
890:
896: fnd_message.Set_token('TEXT', 'Before Start Process ');
897: fnd_msg_pub.Add;
898: END IF;
899:
900: wf_engine.StartProcess (ItemType => l_itemType,
901: ItemKey => l_itemKey);
902:
903: -- dbms_output.put_line('started process');
904:
975: -- partner , only then the lead creation email will be sent to the partner contact in addition
976: -- to the lead owner from vendor side. The vendor notification is sent both times i.e when the
977: -- the lead is created by vendor or partner
978:
979: l_category := wf_engine.GetItemAttrText( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => g_wf_attr_category);
982:
983: l_ptnr_user_name := wf_engine.GetItemAttrText( itemtype => itemtype,
979: l_category := wf_engine.GetItemAttrText( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => g_wf_attr_category);
982:
983: l_ptnr_user_name := wf_engine.GetItemAttrText( itemtype => itemtype,
984: itemkey => itemkey,
985: aname => g_wf_attr_ptnr_user_name);
986:
987: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1042: fnd_msg_pub.Add;
1043: END IF;
1044:
1045: if (funcmode = 'RUN') then
1046: l_temp_status := wf_engine.GetItemAttrText( itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => g_wf_attr_lead_status);
1049:
1050: