[Home] [Help]
2535: where notification_id = nid;
2536:
2537: -- Now that the template name has been derrived, see
2538: -- if the default value has been overridden.
2539: altTempl := WF_MAILER_PARAMETER.getValueForCorr(nid, mType || ':'|| mName, t_name, inAttr);
2540: colPos := instrb(altTempl, ':', 1);
2541: if colPos > 0 then
2542: t_type := substrb(altTempl, 1, colPos -1);
2543: t_name := substrb(altTempl, colPos + 1, length(altTempl)-colPos);
5970: end if;
5971:
5972: -- We have the basic template name. Now check to see if has been
5973: -- redirected using a mailer configuration parameter of the same name.
5974: altTempl := WF_MAILER_PARAMETER.GetValueForCorr('WFMAIL', templateName);
5975: colon := instrb(altTempl, ':', 1);
5976: if colon > 0 then
5977: templateType := substrb(altTempl, 1, colon -1);
5978: templateName := substrb(altTempl, colon + 1, length(altTempl)-colon);
7959: wf_xml.AddElementAttribute('maxcount', '1', l_attrlist);
7960: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATIONGROUP', '', l_attrlist);
7961: l_attrlist.DELETE;
7962:
7963: l_nodename := WF_MAILER_PARAMETER.GetValueForCorr(p_module, 'NODENAME');
7964:
7965: -- Id string required for response required alerts.
7966: -- We assume that a null id string constitutes a FYI message
7967: if (p_idstring is not null and l_fyi_flag = false) then
8390: when NO_DATA_FOUND then
8391: wf_core.raise('WFCORE_NO_MESSAGE');
8392: end;
8393:
8394: l_nodename := wf_mailer_parameter.getvalueforcorr(
8395: l_msg_type||':'||l_msg_name,'NODENAME');
8396:
8397: l_idstr := '';
8398: