[Home] [Help]
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS ;
270:
271: -- check the profile value and return if the value is not Y
272: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), 'Y');
273:
274: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
276: fnd_message.Set_Token('TEXT', 'Email Notication is Enabled '||l_email_enabled);
460: ItemKey => l_itemKey,
461: aname => g_wf_attr_vendor_org_name,
462: avalue => p_vendor_org_name);
463:
464: l_send_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
465:
466: wf_engine.SetItemAttrText ( ItemType => l_itemType,
467: ItemKey => l_itemKey,
468: aname => g_wf_attr_send_url,
622: -- Initialize API return status to success
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624:
625: -- check the profile value and return if the value is not Y
626: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), 'Y');
627:
628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
629: debug('Email Enabled Flag '||l_email_enabled);
630: END IF;
715: itemkey => p_itemKey,
716: aname => g_wf_attr_partner_name,
717: avalue => p_partner_name);
718:
719: l_send_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
720:
721: wf_engine.SetItemAttrText ( itemtype => p_itemType,
722: itemkey => p_itemKey,
723: aname => g_wf_attr_send_url,
843: 0,
844: null,
845: 1,
846: TO_CHAR(MAX(grp.group_id)),
847: FND_PROFILE.VALUE_SPECIFIC('ASF_DEFAULT_GROUP_ROLE',
848: MAX(RES.user_id))) salesgroup_id
849: FROM JTF_RS_GROUP_MEMBERS mem,
850: JTF_RS_ROLE_RELATIONS rrel,
851: JTF_RS_ROLES_B role,