DBA Data[Home] [Help]

APPS.CSM_EMAIL_QUERY_PKG dependencies on WF_NOTIFICATION

Line 2120: l_nid := wf_notification.Send

2116: CSM_UTIL_PKG.LOG('Created Role : ' || l_role_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2117:
2118: END IF;
2119:
2120: l_nid := wf_notification.Send
2121: ( role => l_role_name
2122: , msg_type => 'CSM_MSGS'
2123: , msg_name => 'FYI_MESSAGE'
2124: );

Line 2125: wf_notification.SetAttrText

2121: ( role => l_role_name
2122: , msg_type => 'CSM_MSGS'
2123: , msg_name => 'FYI_MESSAGE'
2124: );
2125: wf_notification.SetAttrText
2126: ( l_nid
2127: , 'MESSAGE_BODY'
2128: , p_message
2129: );

Line 2131: wf_notification.SetAttrText

2127: , 'MESSAGE_BODY'
2128: , p_message
2129: );
2130:
2131: wf_notification.SetAttrText
2132: ( l_nid
2133: , 'SUBJECT'
2134: , p_subject
2135: );

Line 2137: wf_notification.denormalize_notification(l_nid);

2133: , 'SUBJECT'
2134: , p_subject
2135: );
2136:
2137: wf_notification.denormalize_notification(l_nid);
2138: x_return_status := fnd_api.g_ret_sts_success;
2139: x_error_message := 'Successfully send notification id: ' || l_nid || ' to role: ' || l_role_name;
2140:
2141: CSM_UTIL_PKG.LOG('Leaving NOTIFY_EMAIL_EXECPTION for EMAIL_ID: ' || p_email_id || ' NID: ' || l_nid, g_object_name, FND_LOG.LEVEL_PROCEDURE);