[Home] [Help]
48: and WMA.ATTACH = 'N'
49: and WMA.NAME = WNA.NAME;
50:
51: -- Set these constants as session level varaibles to minumise the
52: -- calls to wf_core.
53: g_newLine varchar2(1) := wf_core.newLine;
54: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
55: g_htmlmessage varchar2(200);
56: g_urlNotification varchar2(200);
49: and WMA.NAME = WNA.NAME;
50:
51: -- Set these constants as session level varaibles to minumise the
52: -- calls to wf_core.
53: g_newLine varchar2(1) := wf_core.newLine;
54: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
55: g_htmlmessage varchar2(200);
56: g_urlNotification varchar2(200);
57: g_urlListAttachment varchar2(200);
50:
51: -- Set these constants as session level varaibles to minumise the
52: -- calls to wf_core.
53: g_newLine varchar2(1) := wf_core.newLine;
54: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
55: g_htmlmessage varchar2(200);
56: g_urlNotification varchar2(200);
57: g_urlListAttachment varchar2(200);
58: -- These are only used in legacy procedures.
55: g_htmlmessage varchar2(200);
56: g_urlNotification varchar2(200);
57: g_urlListAttachment varchar2(200);
58: -- These are only used in legacy procedures.
59: g_webAgent varchar2(200) := wf_core.translate('WF_WEB_AGENT');
60: g_wfSchema varchar2(200) := wf_core.translate('WF_SCHEMA');
61: g_fndapi_misschr varchar2(1) := FND_API.G_MISS_CHAR;
62:
63: g_ntfDocText varchar2(30) := wf_notification.doc_text;
56: g_urlNotification varchar2(200);
57: g_urlListAttachment varchar2(200);
58: -- These are only used in legacy procedures.
59: g_webAgent varchar2(200) := wf_core.translate('WF_WEB_AGENT');
60: g_wfSchema varchar2(200) := wf_core.translate('WF_SCHEMA');
61: g_fndapi_misschr varchar2(1) := FND_API.G_MISS_CHAR;
62:
63: g_ntfDocText varchar2(30) := wf_notification.doc_text;
64: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
68: g_base_territory v$nls_parameters.value%TYPE ;
69: g_base_codeset v$nls_parameters.value%TYPE ;
70:
71: -- << sstomar>> : Initialization can be done by using
72: -- variables from wf_core.nls_date_format,
73: -- wf_core.nls_date_language etc. but since
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
69: g_base_codeset v$nls_parameters.value%TYPE ;
70:
71: -- << sstomar>> : Initialization can be done by using
72: -- variables from wf_core.nls_date_format,
73: -- wf_core.nls_date_language etc. but since
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
72: -- variables from wf_core.nls_date_format,
73: -- wf_core.nls_date_language etc. but since
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
79: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
80: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
73: -- wf_core.nls_date_language etc. but since
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
79: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
80: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
81:
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
79: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
80: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
81:
82:
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
79: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
80: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
81:
82:
83: -- Return TRUE if the URL points to a image file.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
79: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
80: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
81:
82:
83: -- Return TRUE if the URL points to a image file.
84: -- The URL is pretested to ensure that it does NOT contain
231: end if;
232: end if;
233: exception
234: when others then
235: wf_core.context('Wf_XML','GetRecipients',p_role);
236: raise;
237: end GetRecipients;
238:
239: -- EncodeEntityReference
284: buf := replace(buf, l_amp||'amp;', l_amp);
285: return buf;
286: exception
287: when others then
288: wf_core.context('Wf_Notification', 'DecodeEntityReference');
289: raise;
290: end DecodeEntityReference;
291:
292: -- EnqueueLOBMessage
324: null;
325:
326: exception
327: when others then
328: wf_core.context('WF_XML','EnqueueLOBMessage',p_queue,
329: to_char(p_priority),
330: p_correlation);
331: raise;
332: end EnqueueLOBMessage;
370: exception
371: when others then
372: -- just in case, check and free it any way.
373: wf_temp_lob.ReleaseLob(g_LOBTable, l_msgLobIdx);
374: wf_core.context('WF_XML','EnqueueMessage',p_queue, to_char(p_priority),
375: p_correlation);
376: raise;
377: end EnqueueMessage;
378:
492:
493: exception
494: when others then
495: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);
496: wf_core.context('WF_XML','NewLOBTag', p_tag);
497: raise;
498: end NewLOBTag;
499:
500: -- NewLOBTag - Create a new TAG node and insert it into the
627: exception
628: when others then
629: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
630: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
631: wf_core.context('WF_XML','NewLOBTag', p_tag);
632: raise;
633: end NewLOBTag;
634:
635: -- NewTag - Create a new TAG node and insert it into the
715: return l_pos;
716:
717: exception
718: when others then
719: wf_core.context('WF_XML','NewTag', p_tag);
720: raise;
721: end NewTag;
722:
723:
747: return l_pos + length(l_tag);
748:
749: exception
750: when others then
751: wf_core.context('WF_XML','SkipLOBTag', p_tag, to_char(p_offset),
752: to_char(p_occurance));
753: raise;
754: end SkipLOBTag;
755:
778: return l_pos + length(l_tag);
779:
780: exception
781: when others then
782: wf_core.context('WF_XML','SkipTag', p_tag, to_char(p_offset),
783: to_char(p_occurance));
784: raise;
785: end SkipTag;
786:
835: p_pos := l_endPos + length(l_endTag) + 1;
836: p_value := l_value;
837: exception
838: when others then
839: wf_core.context('WF_XML','GetTagValue',p_tag, to_char(p_pos));
840: raise;
841: end GetTagValue;
842:
843:
857: p_attribute_list(l_index).attribute := p_attribute_name;
858: p_attribute_list(l_index).value := p_attribute_value;
859: exception
860: when others then
861: wf_core.context('WF_XML','AddElementAttribute',p_attribute_name,
862: p_attribute_value);
863: raise;
864: end;
865:
1133: l_content_type, l_error_result);
1134:
1135: if l_error_result is not null or l_error_result <> '' then
1136: -- Error in getting content
1137: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1138: l_display_type);
1139: wf_core.raise('WFMLR_DOCUMENT_ERROR');
1140: end if;
1141:
1135: if l_error_result is not null or l_error_result <> '' then
1136: -- Error in getting content
1137: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1138: l_display_type);
1139: wf_core.raise('WFMLR_DOCUMENT_ERROR');
1140: end if;
1141:
1142: -- default to display type is no document type is specified
1143: if (l_content_type is null) then
1245: wf_log_pkg.string(WF_LOG_PKG.level_error,
1246: 'wf.plsql.WF_XML.GetAttachment',
1247: 'Error when getting BLOB attachment -> '||sqlerrm);
1248: end if;
1249: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1250: l_display_type);
1251: wf_core.raise('WFMLR_DOCUMENT_ERROR');
1252: end;
1253:
1247: 'Error when getting BLOB attachment -> '||sqlerrm);
1248: end if;
1249: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1250: l_display_type);
1251: wf_core.raise('WFMLR_DOCUMENT_ERROR');
1252: end;
1253:
1254: -- default to display type is no document type is specified
1255: if (l_content_type is null) then
1302: length(l_end), l_end);
1303:
1304:
1305: if l_error_result is not null or l_error_result <> '' then
1306: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1307: p_agent, to_char(p_pos));
1308: wf_core.token('SQLERR', l_error_result);
1309: wf_core.raise('WF_URLLIST_ERROR');
1310: end if;
1304:
1305: if l_error_result is not null or l_error_result <> '' then
1306: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1307: p_agent, to_char(p_pos));
1308: wf_core.token('SQLERR', l_error_result);
1309: wf_core.raise('WF_URLLIST_ERROR');
1310: end if;
1311:
1312: l_fileName := g_urlListAttachment||'.html';
1305: if l_error_result is not null or l_error_result <> '' then
1306: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1307: p_agent, to_char(p_pos));
1308: wf_core.token('SQLERR', l_error_result);
1309: wf_core.raise('WF_URLLIST_ERROR');
1310: end if;
1311:
1312: l_fileName := g_urlListAttachment||'.html';
1313:
1342: exception
1343: when others then
1344: WF_MAIL.CloseLob(l_display_type);
1345: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1346: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,
1347: to_char(p_pos));
1348: l_err_message := sqlerrm;
1349: raise;
1350: end GetAttachment;
1422: end loop;
1423: return l_pos;
1424: exception
1425: when others then
1426: wf_core.context('WF_XML', 'GetAttributes', to_char(p_nid));
1427: raise;
1428: end GetAttributes;
1429:
1430: -- GetXMLMessage - Return a CLOB Document containing an XML encoded version of the
1509: l_subject, l_text_body, l_html_body, l_body_atth,
1510: l_error_result);
1511: -- Check for any problems
1512: if l_error_result is not NULL then
1513: wf_core.token('LANG', l_language);
1514: wf_core.token('TERR', l_territory);
1515: wf_core.token('ERRMSG', l_error_result);
1516: wf_core.raise('WFXMLERR');
1517: end if;
1510: l_error_result);
1511: -- Check for any problems
1512: if l_error_result is not NULL then
1513: wf_core.token('LANG', l_language);
1514: wf_core.token('TERR', l_territory);
1515: wf_core.token('ERRMSG', l_error_result);
1516: wf_core.raise('WFXMLERR');
1517: end if;
1518:
1511: -- Check for any problems
1512: if l_error_result is not NULL then
1513: wf_core.token('LANG', l_language);
1514: wf_core.token('TERR', l_territory);
1515: wf_core.token('ERRMSG', l_error_result);
1516: wf_core.raise('WFXMLERR');
1517: end if;
1518:
1519:
1512: if l_error_result is not NULL then
1513: wf_core.token('LANG', l_language);
1514: wf_core.token('TERR', l_territory);
1515: wf_core.token('ERRMSG', l_error_result);
1516: wf_core.raise('WFXMLERR');
1517: end if;
1518:
1519:
1520: -- Instantiate a handle to the new document.
1551: from wf_notifications_view
1552: where notification_id = p_nid;
1553: exception
1554: when NO_DATA_FOUND then
1555: wf_core.raise('WFNTFGM_FAILED');
1556: end;
1557:
1558: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos, 'PRIORITY',
1559: to_char(l_priority), l_attrlist);
1649:
1650: exception
1651: when others then
1652: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1653: wf_core.context('WF_XML', 'GetXMLMessage', to_char(p_nid), p_protocol,
1654: p_node, p_nlang, p_nterr);
1655: raise;
1656: end getXMLMessage;
1657:
1730: from wf_notifications
1731: where notification_id = p_nid;
1732: exception
1733: when NO_DATA_FOUND then
1734: wf_core.raise('WFNTFGM_FAILED');
1735: end;
1736:
1737: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos,
1738: 'PRIORITY', to_char(l_priority), l_attrlist);
1760:
1761: exception
1762: when others then
1763: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1764: wf_core.context('WF_XML', 'GetShortLOBXMLMessage', to_char(p_nid));
1765: raise;
1766: end getShortLOBXMLMessage;
1767:
1768: -- GetShortXMLMessage -
1833: from wf_notifications
1834: where notification_id = p_nid;
1835: exception
1836: when NO_DATA_FOUND then
1837: wf_core.raise('WFNTFGM_FAILED');
1838: end;
1839:
1840: l_pos := NewTag(p_message, l_pos, 'PRIORITY', to_char(l_priority),
1841: l_attrlist);
1853: p_priority := l_priority;
1854:
1855: exception
1856: when others then
1857: wf_core.context('WF_XML', 'GetShortXMLMessage', to_char(p_nid));
1858: raise;
1859: end getShortXMLMessage;
1860:
1861:
1986:
1987: exception
1988: when others then
1989: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1990: wf_core.context('WF_XML', 'EnqueueFullNotification', to_char(p_nid));
1991: raise;
1992: end EnqueueFullNotification;
1993:
1994:
2052:
2053: exception
2054: when others then
2055: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
2056: wf_core.context('WF_XML', 'EnqueueLOBNotification', to_char(p_nid));
2057: raise;
2058: end EnqueueLOBNotification;
2059:
2060: -- EnqueueNotification - To push a notification ID to the outbound
2113: end if;
2114:
2115: exception
2116: when others then
2117: wf_core.context('WF_XML', 'EnqueueNotification', to_char(p_nid));
2118: raise;
2119: end EnqueueNotification;
2120:
2121:
2145: exception
2146: when dequeue_timeout then
2147: p_timeout := TRUE;
2148: when others then
2149: Wf_Core.Context('WF_XML', 'DequeueMessage', p_queue_name,
2150: p_correlation);
2151: p_timeout := FALSE;
2152: raise;
2153: end DequeueMessage;
2229: end if;
2230:
2231: exception
2232: when no_program_unit then
2233: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2234: raise;
2235:
2236: when others then
2237: -- First look for a wf_core error.
2233: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2234: raise;
2235:
2236: when others then
2237: -- First look for a wf_core error.
2238: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2239:
2240: -- If no wf_core error look for a sql error.
2241: if (l_err_name is null) then
2234: raise;
2235:
2236: when others then
2237: -- First look for a wf_core error.
2238: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2239:
2240: -- If no wf_core error look for a sql error.
2241: if (l_err_name is null) then
2242: l_err_message := sqlerrm;
2236: when others then
2237: -- First look for a wf_core error.
2238: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2239:
2240: -- If no wf_core error look for a sql error.
2241: if (l_err_name is null) then
2242: l_err_message := sqlerrm;
2243: end if;
2244:
2242: l_err_message := sqlerrm;
2243: end if;
2244:
2245: p_error_result := l_err_message;
2246: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2247: raise;
2248:
2249: end GetMessage;
2250:
2282: GetQueueMessage(l_queue_name, p_nid, p_recipient, p_status,
2283: p_timeout, p_error_result);
2284: exception
2285: when no_program_unit then
2286: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2287: raise;
2288:
2289: when others then
2290: -- First look for a wf_core error.
2286: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2287: raise;
2288:
2289: when others then
2290: -- First look for a wf_core error.
2291: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2292:
2293: -- If no wf_core error look for a sql error.
2294: if (l_err_name is null) then
2287: raise;
2288:
2289: when others then
2290: -- First look for a wf_core error.
2291: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2292:
2293: -- If no wf_core error look for a sql error.
2294: if (l_err_name is null) then
2295: l_err_message := sqlerrm;
2289: when others then
2290: -- First look for a wf_core error.
2291: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2292:
2293: -- If no wf_core error look for a sql error.
2294: if (l_err_name is null) then
2295: l_err_message := sqlerrm;
2296: end if;
2297:
2295: l_err_message := sqlerrm;
2296: end if;
2297:
2298: p_error_result := l_err_message;
2299: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2300: raise;
2301:
2302: end GetShortMessage;
2303:
2347: end if;
2348:
2349: exception
2350: when no_program_unit then
2351: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2352: raise;
2353:
2354: when others then
2355: -- First look for a wf_core error.
2351: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2352: raise;
2353:
2354: when others then
2355: -- First look for a wf_core error.
2356: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2357:
2358: -- If no wf_core error look for a sql error.
2359: if (l_err_name is null) then
2352: raise;
2353:
2354: when others then
2355: -- First look for a wf_core error.
2356: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2357:
2358: -- If no wf_core error look for a sql error.
2359: if (l_err_name is null) then
2360: l_err_message := sqlerrm;
2354: when others then
2355: -- First look for a wf_core error.
2356: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2357:
2358: -- If no wf_core error look for a sql error.
2359: if (l_err_name is null) then
2360: l_err_message := sqlerrm;
2361: end if;
2362:
2360: l_err_message := sqlerrm;
2361: end if;
2362:
2363: p_error_result := l_err_message;
2364: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2365: raise;
2366:
2367: end GetExceptionMessage;
2368:
2458: end if;
2459:
2460: exception
2461: when no_program_unit then
2462: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2463: raise;
2464:
2465: when others then
2466: -- First look for a wf_core error.
2462: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2463: raise;
2464:
2465: when others then
2466: -- First look for a wf_core error.
2467: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2468:
2469: -- If no wf_core error look for a sql error.
2470: if (l_err_name is null) then
2463: raise;
2464:
2465: when others then
2466: -- First look for a wf_core error.
2467: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2468:
2469: -- If no wf_core error look for a sql error.
2470: if (l_err_name is null) then
2471: l_err_message := sqlerrm;
2465: when others then
2466: -- First look for a wf_core error.
2467: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2468:
2469: -- If no wf_core error look for a sql error.
2470: if (l_err_name is null) then
2471: l_err_message := sqlerrm;
2472: end if;
2473:
2471: l_err_message := sqlerrm;
2472: end if;
2473:
2474: p_error_result := l_err_message;
2475: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2476: raise;
2477:
2478: end GetQueueMessage;
2479:
2503: null;
2504:
2505: exception
2506: when others then
2507: Wf_Core.Context('WF_XML', 'RemoveMessage', p_queue_name, p_correlation);
2508: p_timeout := FALSE;
2509: raise;
2510: end RemoveMessage;
2511:
2565: end loop;
2566:
2567: exception
2568: when others then
2569: wf_core.context('WF_XML','RemoveNotification',to_char(p_nid));
2570: raise;
2571: end RemoveNotification;
2572:
2573:
2612: WF_MAIL.CloseLob(p_doctype);
2613:
2614: exception
2615: when others then
2616: wf_core.context('WF_XML','getBodyPart',to_char(p_nid),p_doctype);
2617: raise;
2618: end getBodyPart;
2619:
2620:
2640:
2641:
2642: exception
2643: when others then
2644: wf_core.context('WF_XML','GetNLS');
2645: raise;
2646: end getNLS;
2647:
2648:
2691: dbms_session.set_nls('NLS_LANGUAGE' , l_language);
2692: dbms_session.set_nls('NLS_TERRITORY' , l_territory);
2693: exception
2694: when others then
2695: wf_core.context('WF_XML','SetNLS', language, territory);
2696: raise;
2697: end setNLS;
2698:
2699: -- Parse the p_doc for the URL attributes and edit
2804: when others then
2805: -- Release temp LOB if any error , bug 6511028
2806: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2807:
2808: wf_core.context('WF_XML','ParseForInlineImages',to_char(nid));
2809: raise;
2810: end ParseForInlineImages;
2811:
2812: -- Adds the RESOURCE tags for the inline images.
2847: end loop;
2848:
2849: exception
2850: when others then
2851: wf_core.context('WF_XML','addInlineImages', to_char(nid));
2852: raise;
2853: end addInlineImages;
2854:
2855:
3019: end loop;
3020: end if;
3021: exception
3022: when others then
3023: wf_core.context('WF_XML','addCopyRecipients', p_list, p_type,
3024: step);
3025: end addCopyRecipients;
3026:
3027:
3214: AddElementAttribute('territory', 'AMERICA', attrlist);
3215: AddElementAttribute('codeset', 'UTF8', attrlist);
3216:
3217: -- Added below default base parameters.
3218: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
3219: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3220: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3221: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3222:
3215: AddElementAttribute('codeset', 'UTF8', attrlist);
3216:
3217: -- Added below default base parameters.
3218: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
3219: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3220: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3221: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3222:
3223: AddElementAttribute('full-document', 'N', attrlist);
3216:
3217: -- Added below default base parameters.
3218: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
3219: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3220: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3221: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3222:
3223: AddElementAttribute('full-document', 'N', attrlist);
3224: AddElementAttribute('reason', 'no_data_found', attrlist);
3217: -- Added below default base parameters.
3218: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
3219: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3220: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3221: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3222:
3223: AddElementAttribute('full-document', 'N', attrlist);
3224: AddElementAttribute('reason', 'no_data_found', attrlist);
3225: p_pos := NewLOBTag(p_doc, p_pos, 'NOTIFICATION', '', attrlist);
3227: p_pos := SkipLOBTag(p_doc, 'NOTIFICATION', p_pos, occurance);
3228:
3229: return;
3230: when others then
3231: wf_core.context('WF_XML','GenerateDoc',to_char(nid));
3232: raise;
3233: end;
3234:
3235: if (wf_mail.test_flag = TRUE) then
3266: AddElementAttribute('territory', 'AMERICA', attrlist);
3267: AddElementAttribute('codeset', 'UTF8', attrlist);
3268:
3269: -- Added below default base parameters.
3270: AddElementAttribute('nlsDateFormat', wf_core.nls_date_format, attrlist);
3271: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3272: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3273: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3274:
3267: AddElementAttribute('codeset', 'UTF8', attrlist);
3268:
3269: -- Added below default base parameters.
3270: AddElementAttribute('nlsDateFormat', wf_core.nls_date_format, attrlist);
3271: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3272: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3273: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3274:
3275: AddElementAttribute('full-document', 'N', attrlist);
3268:
3269: -- Added below default base parameters.
3270: AddElementAttribute('nlsDateFormat', wf_core.nls_date_format, attrlist);
3271: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3272: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3273: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3274:
3275: AddElementAttribute('full-document', 'N', attrlist);
3276: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
3269: -- Added below default base parameters.
3270: AddElementAttribute('nlsDateFormat', wf_core.nls_date_format, attrlist);
3271: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
3272: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
3273: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
3274:
3275: AddElementAttribute('full-document', 'N', attrlist);
3276: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
3277: notification_pref, attrlist);
3341: begin
3342: cc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_CC'));
3343: exception
3344: when others then
3345: if (wf_core.error_name = 'WFNTF_ATTR') then
3346: wf_core.clear();
3347: cc_list := null;
3348: else
3349: raise;
3342: cc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_CC'));
3343: exception
3344: when others then
3345: if (wf_core.error_name = 'WFNTF_ATTR') then
3346: wf_core.clear();
3347: cc_list := null;
3348: else
3349: raise;
3350: end if;
3353: begin
3354: bcc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_BCC'));
3355: exception
3356: when others then
3357: if (wf_core.error_name = 'WFNTF_ATTR') then
3358: wf_core.clear();
3359: bcc_list := null;
3360: else
3361: raise;
3354: bcc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_BCC'));
3355: exception
3356: when others then
3357: if (wf_core.error_name = 'WFNTF_ATTR') then
3358: wf_core.clear();
3359: bcc_list := null;
3360: else
3361: raise;
3362: end if;
3448:
3449:
3450: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
3451: NVL( l_nlsTerritory, 'AMERICAN') <> g_base_territory or
3452: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
3453: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
3454: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
3455: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
3456:
3449:
3450: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
3451: NVL( l_nlsTerritory, 'AMERICAN') <> g_base_territory or
3452: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
3453: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
3454: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
3455: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
3456:
3457: -- nid, l_nlsCalendar, just set here only.
3450: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
3451: NVL( l_nlsTerritory, 'AMERICAN') <> g_base_territory or
3452: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
3453: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
3454: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
3455: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
3456:
3457: -- nid, l_nlsCalendar, just set here only.
3458: -- at other places pass value as null.
3451: NVL( l_nlsTerritory, 'AMERICAN') <> g_base_territory or
3452: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
3453: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
3454: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
3455: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
3456:
3457: -- nid, l_nlsCalendar, just set here only.
3458: -- at other places pass value as null.
3459: WF_NOTIFICATION_UTIL.SetNLSContext(nid,
3507:
3508: end if;
3509:
3510: if error_result is not null or error_result <> '' then
3511: wf_core.token('ERROR',error_result);
3512: wf_core.raise('WFMLR_GENERATE_FAILED');
3513: end if;
3514:
3515: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3508: end if;
3509:
3510: if error_result is not null or error_result <> '' then
3511: wf_core.token('ERROR',error_result);
3512: wf_core.raise('WFMLR_GENERATE_FAILED');
3513: end if;
3514:
3515: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3516: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3511: wf_core.token('ERROR',error_result);
3512: wf_core.raise('WFMLR_GENERATE_FAILED');
3513: end if;
3514:
3515: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3516: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3517: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3518:
3519: -- Reset base NLS settings
3512: wf_core.raise('WFMLR_GENERATE_FAILED');
3513: end if;
3514:
3515: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3516: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3517: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3518:
3519: -- Reset base NLS settings
3520: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3513: end if;
3514:
3515: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3516: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3517: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3518:
3519: -- Reset base NLS settings
3520: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3521: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4059: g_base_nlsCalendar );
4060:
4061:
4062:
4063: wf_core.context('WF_XML', 'GenerateDoc', p_event_name, p_event_key);
4064: raise;
4065: end GenerateDoc;
4066:
4067:
4122: if members_t.count = 0 then
4123: -- No role members. Only log it for now and change the
4124: -- notification preference to QUERY.
4125: -- ---------------------------------------------------
4126: -- wf_core.context('WF_XML','GenerateGroup', p_event_name,
4127: -- p_event_key);
4128: -- wf_core.token('NID', p_event_key);
4129: -- wf_core.token('ROLE', p_recipient_role);
4130: -- wf_core.raise('WFMLR_NOROLEMEMBERS');
4124: -- notification preference to QUERY.
4125: -- ---------------------------------------------------
4126: -- wf_core.context('WF_XML','GenerateGroup', p_event_name,
4127: -- p_event_key);
4128: -- wf_core.token('NID', p_event_key);
4129: -- wf_core.token('ROLE', p_recipient_role);
4130: -- wf_core.raise('WFMLR_NOROLEMEMBERS');
4131: -- ---------------------------------------------------
4132: AddElementAttribute('maxcount', '1', attrlist);
4125: -- ---------------------------------------------------
4126: -- wf_core.context('WF_XML','GenerateGroup', p_event_name,
4127: -- p_event_key);
4128: -- wf_core.token('NID', p_event_key);
4129: -- wf_core.token('ROLE', p_recipient_role);
4130: -- wf_core.raise('WFMLR_NOROLEMEMBERS');
4131: -- ---------------------------------------------------
4132: AddElementAttribute('maxcount', '1', attrlist);
4133: p_pos := NewLOBTag(p_doc, p_pos, 'NOTIFICATIONGROUP', '', attrlist);
4126: -- wf_core.context('WF_XML','GenerateGroup', p_event_name,
4127: -- p_event_key);
4128: -- wf_core.token('NID', p_event_key);
4129: -- wf_core.token('ROLE', p_recipient_role);
4130: -- wf_core.raise('WFMLR_NOROLEMEMBERS');
4131: -- ---------------------------------------------------
4132: AddElementAttribute('maxcount', '1', attrlist);
4133: p_pos := NewLOBTag(p_doc, p_pos, 'NOTIFICATIONGROUP', '', attrlist);
4134: attrlist.DELETE;
4139: AddElementAttribute('language', 'AMERICAN', attrlist);
4140: AddElementAttribute('territory', 'AMERICA', attrlist);
4141: AddElementAttribute('codeset', 'UTF8', attrlist);
4142: -- Added below default base parameters.
4143: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4144: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4145: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4146: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4147:
4140: AddElementAttribute('territory', 'AMERICA', attrlist);
4141: AddElementAttribute('codeset', 'UTF8', attrlist);
4142: -- Added below default base parameters.
4143: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4144: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4145: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4146: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4147:
4148: AddElementAttribute('full-document', 'N', attrlist);
4141: AddElementAttribute('codeset', 'UTF8', attrlist);
4142: -- Added below default base parameters.
4143: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4144: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4145: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4146: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4147:
4148: AddElementAttribute('full-document', 'N', attrlist);
4149: AddElementAttribute('reason', 'no_members', attrlist);
4142: -- Added below default base parameters.
4143: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4144: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4145: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4146: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4147:
4148: AddElementAttribute('full-document', 'N', attrlist);
4149: AddElementAttribute('reason', 'no_members', attrlist);
4150: p_pos := NewLOBTag(p_doc, p_pos, 'NOTIFICATION', '', attrlist);
4179: 'wf.plsql.WF_XML.generateGroupDoc', 'END');
4180: end if;
4181: exception
4182: when others then
4183: wf_core.context('WF_XML','GenerateGroupDoc',p_event_name, p_event_key);
4184: raise;
4185: end GenerateGroupDoc;
4186:
4187: -- GenerateMessage
4259: AddElementAttribute('territory', 'AMERICA', attrlist);
4260: AddElementAttribute('codeset', 'UTF8', attrlist);
4261:
4262: -- Added below default base parameters.
4263: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4264: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4265: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4266: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4267:
4260: AddElementAttribute('codeset', 'UTF8', attrlist);
4261:
4262: -- Added below default base parameters.
4263: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4264: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4265: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4266: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4267:
4268: AddElementAttribute('full-document', 'N', attrlist);
4261:
4262: -- Added below default base parameters.
4263: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4264: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4265: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4266: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4267:
4268: AddElementAttribute('full-document', 'N', attrlist);
4269: AddElementAttribute('reason', 'no_data_found', attrlist);
4262: -- Added below default base parameters.
4263: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4264: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4265: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4266: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4267:
4268: AddElementAttribute('full-document', 'N', attrlist);
4269: AddElementAttribute('reason', 'no_data_found', attrlist);
4270: pos := NewLOBTag(p_doc, pos, 'NOTIFICATION', '', attrlist);
4271: attrlist.DELETE;
4272:
4273: return;
4274: when others then
4275: wf_core.context('WF_XML','GenerateMessage',to_char(nid));
4276: raise;
4277: end;
4278:
4279: if (wf_mail.test_flag = TRUE) then
4304: AddElementAttribute('territory', 'AMERICA', attrlist);
4305: AddElementAttribute('codeset', 'UTF8', attrlist);
4306:
4307: -- Added below default base parameters.
4308: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4309: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4310: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4311: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4312:
4305: AddElementAttribute('codeset', 'UTF8', attrlist);
4306:
4307: -- Added below default base parameters.
4308: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4309: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4310: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4311: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4312:
4313: AddElementAttribute('full-document', 'N', attrlist);
4306:
4307: -- Added below default base parameters.
4308: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4309: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4310: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4311: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4312:
4313: AddElementAttribute('full-document', 'N', attrlist);
4314: AddElementAttribute('reason', 'MAIL_STATUS:'||
4307: -- Added below default base parameters.
4308: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4309: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4310: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4311: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4312:
4313: AddElementAttribute('full-document', 'N', attrlist);
4314: AddElementAttribute('reason', 'MAIL_STATUS:'||
4315: MAIL_STATUS, attrlist);
4379: AddElementAttribute('territory', 'AMERICA', attrlist);
4380: AddElementAttribute('codeset', 'UTF8', attrlist);
4381:
4382: -- Added below default base parameters.
4383: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4384: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4385: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4386: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4387:
4380: AddElementAttribute('codeset', 'UTF8', attrlist);
4381:
4382: -- Added below default base parameters.
4383: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4384: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4385: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4386: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4387:
4388: AddElementAttribute('full-document', 'N', attrlist);
4381:
4382: -- Added below default base parameters.
4383: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4384: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4385: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4386: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4387:
4388: AddElementAttribute('full-document', 'N', attrlist);
4389: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
4382: -- Added below default base parameters.
4383: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4384: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4385: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4386: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4387:
4388: AddElementAttribute('full-document', 'N', attrlist);
4389: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
4390: notification_pref, attrlist);
4410: 'wf.plsql.WF_XML.generateMessage', 'END');
4411: end if;
4412: exception
4413: when others then
4414: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
4415: raise;
4416: end GenerateMessage;
4417:
4418: -- GenerateSummaryDoc
4542: AddElementAttribute('codeset', 'UTF8', attrlist);
4543:
4544: -- set values of attributes as notification is NOT to be sent
4545: -- Added below default base parameters.
4546: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4547: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4548:
4549: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4550: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4543:
4544: -- set values of attributes as notification is NOT to be sent
4545: -- Added below default base parameters.
4546: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4547: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4548:
4549: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4550: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4551: AddElementAttribute('full-document', 'N', attrlist);
4545: -- Added below default base parameters.
4546: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4547: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4548:
4549: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4550: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4551: AddElementAttribute('full-document', 'N', attrlist);
4552:
4553: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
4546: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4547: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4548:
4549: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4550: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4551: AddElementAttribute('full-document', 'N', attrlist);
4552:
4553: AddElementAttribute('reason', 'NOTIFICATION_PREFERENCE:'||
4554: notification_pref, attrlist);
4600: -- setNLS(language, territory);
4601: -- Set user / role's context
4602: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4603: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4604: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4605: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4606: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4607: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4608:
4601: -- Set user / role's context
4602: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4603: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4604: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4605: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4606: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4607: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4608:
4609:
4602: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4603: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4604: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4605: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4606: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4607: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4608:
4609:
4610: WF_NOTIFICATION_UTIL.SetNLSContext(0,
4603: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4604: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4605: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4606: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4607: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4608:
4609:
4610: WF_NOTIFICATION_UTIL.SetNLSContext(0,
4611: l_nlsLanguage ,
4825: g_base_nlsSort ,
4826: g_base_nlsCalendar );
4827:
4828:
4829: wf_core.context('WF_XML', 'GenerateSummaryDoc', p_event_name,
4830: p_event_key);
4831: raise;
4832: end GenerateSummaryDoc;
4833:
4895: AddElementAttribute('territory', 'AMERICA', attrlist);
4896: AddElementAttribute('codeset', 'UTF8', attrlist);
4897:
4898: -- Added below default base parameters.
4899: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4900: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4901:
4902: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4903: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4896: AddElementAttribute('codeset', 'UTF8', attrlist);
4897:
4898: -- Added below default base parameters.
4899: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4900: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4901:
4902: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4903: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4904:
4898: -- Added below default base parameters.
4899: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4900: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4901:
4902: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4903: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4904:
4905: AddElementAttribute('full-document', 'N', attrlist);
4906: AddElementAttribute('reason', 'no_members', attrlist);
4899: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, attrlist);
4900: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, attrlist);
4901:
4902: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, attrlist);
4903: AddElementAttribute('nlsSort', wf_core.nls_sort, attrlist);
4904:
4905: AddElementAttribute('full-document', 'N', attrlist);
4906: AddElementAttribute('reason', 'no_members', attrlist);
4907: p_pos := NewLOBTag(p_doc, p_pos, 'NOTIFICATION', '', attrlist);
4925: end if;
4926:
4927: exception
4928: when others then
4929: wf_core.context('WF_XML','GenerateGroupSummaryDoc ',p_event_name,
4930: p_event_key);
4931: raise;
4932: end GenerateGroupSummaryDoc ;
4933:
5019: end if;
5020: exception
5021:
5022: when e_RoleNameNotSpecified then
5023: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
5024: raise;
5025:
5026: when others then
5027: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
5023: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
5024: raise;
5025:
5026: when others then
5027: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
5028: raise;
5029: end GenerateSummary;
5030:
5031: -- Generate
5097:
5098: end if;
5099: exception
5100: when others then
5101: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
5102:
5103: -- RESET BASSE LANGUAGE
5104: WF_NOTIFICATION_UTIL.SetNLSContext(null,
5105: g_base_language ,
5394:
5395: exception
5396:
5397: when xmldom.INDEX_SIZE_ERR then
5398: wf_core.context('WF_XML','getResponseDetails', step);
5399: raise;
5400:
5401: when xmldom.DOMSTRING_SIZE_ERR then
5402: wf_core.context('WF_XML','getResponseDetails', step);
5398: wf_core.context('WF_XML','getResponseDetails', step);
5399: raise;
5400:
5401: when xmldom.DOMSTRING_SIZE_ERR then
5402: wf_core.context('WF_XML','getResponseDetails', step);
5403: raise;
5404:
5405: when xmldom.HIERARCHY_REQUEST_ERR then
5406: wf_core.context('WF_XML','getResponseDetails', step);
5402: wf_core.context('WF_XML','getResponseDetails', step);
5403: raise;
5404:
5405: when xmldom.HIERARCHY_REQUEST_ERR then
5406: wf_core.context('WF_XML','getResponseDetails', step);
5407: raise;
5408:
5409: when xmldom.WRONG_DOCUMENT_ERR then
5410: wf_core.context('WF_XML','getResponseDetails', step);
5406: wf_core.context('WF_XML','getResponseDetails', step);
5407: raise;
5408:
5409: when xmldom.WRONG_DOCUMENT_ERR then
5410: wf_core.context('WF_XML','getResponseDetails', step);
5411: raise;
5412:
5413: when xmldom.INVALID_CHARACTER_ERR then
5414: wf_core.context('WF_XML','getResponseDetails', step);
5410: wf_core.context('WF_XML','getResponseDetails', step);
5411: raise;
5412:
5413: when xmldom.INVALID_CHARACTER_ERR then
5414: wf_core.context('WF_XML','getResponseDetails', step);
5415: raise;
5416:
5417: when xmldom.NO_DATA_ALLOWED_ERR then
5418: wf_core.context('WF_XML','getResponseDetails', step);
5414: wf_core.context('WF_XML','getResponseDetails', step);
5415: raise;
5416:
5417: when xmldom.NO_DATA_ALLOWED_ERR then
5418: wf_core.context('WF_XML','getResponseDetails', step);
5419: raise;
5420:
5421: when xmldom.NO_MODIFICATION_ALLOWED_ERR then
5422: wf_core.context('WF_XML','getResponseDetails', step);
5418: wf_core.context('WF_XML','getResponseDetails', step);
5419: raise;
5420:
5421: when xmldom.NO_MODIFICATION_ALLOWED_ERR then
5422: wf_core.context('WF_XML','getResponseDetails', step);
5423: raise;
5424:
5425: when xmldom.NOT_FOUND_ERR then
5426: wf_core.context('WF_XML','getResponseDetails', step);
5422: wf_core.context('WF_XML','getResponseDetails', step);
5423: raise;
5424:
5425: when xmldom.NOT_FOUND_ERR then
5426: wf_core.context('WF_XML','getResponseDetails', step);
5427: raise;
5428:
5429: when xmldom.NOT_SUPPORTED_ERR then
5430: wf_core.context('WF_XML','getResponseDetails', step);
5426: wf_core.context('WF_XML','getResponseDetails', step);
5427: raise;
5428:
5429: when xmldom.NOT_SUPPORTED_ERR then
5430: wf_core.context('WF_XML','getResponseDetails', step);
5431: raise;
5432:
5433: when xmldom.INUSE_ATTRIBUTE_ERR then
5434: wf_core.context('WF_XML','getResponseDetails', step);
5430: wf_core.context('WF_XML','getResponseDetails', step);
5431: raise;
5432:
5433: when xmldom.INUSE_ATTRIBUTE_ERR then
5434: wf_core.context('WF_XML','getResponseDetails', step);
5435: raise;
5436:
5437: when others then
5438: wf_core.context('WF_XML','getResponseDetails', step);
5434: wf_core.context('WF_XML','getResponseDetails', step);
5435: raise;
5436:
5437: when others then
5438: wf_core.context('WF_XML','getResponseDetails', step);
5439: raise;
5440:
5441: end getResponseDetails;
5442:
5471: end if;
5472: return 'SUCCESS';
5473: exception
5474: when others then
5475: wf_core.Context('WF_XML','SendNotification',p_event.getEventName(),
5476: p_subscription_guid);
5477: -- Save error message and set status to INVALID so mailer will
5478: -- bounce an "invalid reply" message to sender.
5479: wf_event.SetErrorInfo(p_event, 'ERROR');
5543: 'Exception on call to Wf_Notification.Respond NID['||l_nid||'] '||
5544: 'Error Msg '||sqlerrm);
5545: end if;
5546:
5547: wf_core.Context('WF_XML','handleReceiveEvent',
5548: p_event.getEventName(), p_subscription_guid);
5549: -- Save error message and set status to INVALID so mailer will
5550: -- bounce an "invalid reply" message to sender.
5551: WF_MAIL.HandleResponseError(l_nid, lk_type, lk_code,
5571: 'Signature policy is not DEFAULT');
5572: end if;
5573:
5574: -- If a new policy is added, only wfmail.msg needs to be updated
5575: wf_core.context('WF_XML', 'HandleReceiveEvent',
5576: to_char(l_nid), l_node, l_fromAddr);
5577: wf_core.token('NID', to_char(l_nid));
5578: wf_core.raise('WFRSPR_' || l_sig_policy);
5579: end if;
5573:
5574: -- If a new policy is added, only wfmail.msg needs to be updated
5575: wf_core.context('WF_XML', 'HandleReceiveEvent',
5576: to_char(l_nid), l_node, l_fromAddr);
5577: wf_core.token('NID', to_char(l_nid));
5578: wf_core.raise('WFRSPR_' || l_sig_policy);
5579: end if;
5580:
5581: for i in 1..l_responses.COUNT loop
5574: -- If a new policy is added, only wfmail.msg needs to be updated
5575: wf_core.context('WF_XML', 'HandleReceiveEvent',
5576: to_char(l_nid), l_node, l_fromAddr);
5577: wf_core.token('NID', to_char(l_nid));
5578: wf_core.raise('WFRSPR_' || l_sig_policy);
5579: end if;
5580:
5581: for i in 1..l_responses.COUNT loop
5582: l_step := 'Processing the responses -> '||l_responses(i).name;
5610: 'wf.plsql.WF_XML.handleReceiveEvent',
5611: 'LOV Meaning is null');
5612: end if;
5613:
5614: wf_core.token('TYPE', lk_type);
5615: wf_core.token('CODE', lk_code);
5616: wf_core.raise('WFSQL_LOOKUP_CODE');
5617: end if;
5618: end if;
5611: 'LOV Meaning is null');
5612: end if;
5613:
5614: wf_core.token('TYPE', lk_type);
5615: wf_core.token('CODE', lk_code);
5616: wf_core.raise('WFSQL_LOOKUP_CODE');
5617: end if;
5618: end if;
5619: if l_responses(i).type = 'MOREINFO' then
5612: end if;
5613:
5614: wf_core.token('TYPE', lk_type);
5615: wf_core.token('CODE', lk_code);
5616: wf_core.raise('WFSQL_LOOKUP_CODE');
5617: end if;
5618: end if;
5619: if l_responses(i).type = 'MOREINFO' then
5620: null; -- discard these responses
5634: if l_responses(i).name = 'WFNTF_MOREINFO_FROM' then
5635: l_user := DecodeEntityReference(lk_code);
5636: elsif l_responses(i).name = 'WFNTF_MOREINFO_QPROMPT' then
5637: if length(l_responses(i).value) > 4000 then
5638: wf_core.context('WF_XML', 'HandleReceiveEvent',
5639: l_responses(i).type,
5640: l_responses(i).name, l_step);
5641: lk_code := substrb(l_responses(i).value, 1,
5642: 1000);
5639: l_responses(i).type,
5640: l_responses(i).name, l_step);
5641: lk_code := substrb(l_responses(i).value, 1,
5642: 1000);
5643: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');
5644: end if;
5645: l_comment := lk_code;
5646: end if;
5647: elsif l_version = 4 then
5646: end if;
5647: elsif l_version = 4 then
5648: if l_responses(i).name = 'WFNTF_MOREINFO_APROMPT' then
5649: if length(l_responses(i).value) > 4000 then
5650: wf_core.context('WF_XML', 'HandleReceiveEvent',
5651: l_responses(i).type,
5652: l_responses(i).name, l_step);
5653: lk_code := substrb(l_responses(i).value, 1,
5654: 1000);
5651: l_responses(i).type,
5652: l_responses(i).name, l_step);
5653: lk_code := substrb(l_responses(i).value, 1,
5654: 1000);
5655: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');
5656: end if;
5657: l_comment := lk_code;
5658: end if;
5659: end if;
5668: if l_version = 3 then
5669: -- Question mode
5670: -- Send a email back to the sender that the More Info User is invalid
5671: if (l_user is null or length(trim(l_user)) = 0) then
5672: wf_core.raise('WFNTF_NO_ROLE');
5673: elsif(l_comment is null or length(trim(l_comment)) = 0) then
5674: wf_core.raise('WFNTF_NO_QUESTION');
5675: else
5676: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,
5670: -- Send a email back to the sender that the More Info User is invalid
5671: if (l_user is null or length(trim(l_user)) = 0) then
5672: wf_core.raise('WFNTF_NO_ROLE');
5673: elsif(l_comment is null or length(trim(l_comment)) = 0) then
5674: wf_core.raise('WFNTF_NO_QUESTION');
5675: else
5676: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,
5677: l_comment);
5678: end if;
5679: elsif l_version = 4 then
5680: -- Answer mode
5681: l_user := null;
5682: if(l_comment is null or length(trim(l_comment)) = 0) then
5683: wf_core.raise('WFNTF_NO_ANSWER');
5684: else
5685: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,
5686: l_comment);
5687: end if;
5706: 'Exception in processing the Response. Step '||l_step||
5707: ' Error Msg '||sqlerrm);
5708: end if;
5709:
5710: wf_core.Context('WF_XML','handleReceiveEvent',
5711: to_char(l_nid), 'Step '||l_step);
5712: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5713: -- Save error message and set status to INVALID so mailer will
5714: -- bounce an "invalid reply" message to sender.
5708: end if;
5709:
5710: wf_core.Context('WF_XML','handleReceiveEvent',
5711: to_char(l_nid), 'Step '||l_step);
5712: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5713: -- Save error message and set status to INVALID so mailer will
5714: -- bounce an "invalid reply" message to sender.
5715: WF_MAIL.HandleResponseError(l_nid, lk_type,
5716: substrb(lk_code, 1, 1000),
5721:
5722: exception
5723:
5724: when others then
5725: wf_core.Context('WF_XML','handleReceiveEvent',p_event.getEventName(),
5726: p_subscription_guid);
5727: -- Save error message and set status to INVALID so mailer will
5728: -- bounce an "invalid reply" message to sender.
5729: wf_event.SetErrorInfo(p_event, 'ERROR');
5789:
5790: exception
5791:
5792: when others then
5793: wf_core.Context('WF_XML','Receive',p_event.getEventName(),
5794: p_subscription_guid);
5795: -- Save error message and set status to INVALID so mailer will
5796: -- bounce an "invalid reply" message to sender.
5797: wf_event.SetErrorInfo(p_event, 'ERROR');
5854:
5855: exception
5856:
5857: when others then
5858: wf_core.Context('WF_XML','SummaryRule',p_event.getEventName(),
5859: p_subscription_guid);
5860: wf_event.SetErrorInfo(p_event, 'ERROR');
5861: return 'ERROR';
5862: end SummaryRule;
6124: when no_data_found then
6125: return 'SUCCESS';
6126: when others then
6127: error_msg := sqlerrm;
6128: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',
6129: 'CTX['||ctx||']');
6130: raise;
6131: end;
6132: else
6135:
6136: if cb is not null then
6137: -- Put the error onto the stack.
6138: begin
6139: wf_core.token('ERROR_MESSAGE', error_msg);
6140: wf_core.token('ERROR_STACK', error_stack);
6141: wf_core.raise('WF_ERROR');
6142: exception
6143: when others then null;
6136: if cb is not null then
6137: -- Put the error onto the stack.
6138: begin
6139: wf_core.token('ERROR_MESSAGE', error_msg);
6140: wf_core.token('ERROR_STACK', error_stack);
6141: wf_core.raise('WF_ERROR');
6142: exception
6143: when others then null;
6144: end;
6137: -- Put the error onto the stack.
6138: begin
6139: wf_core.token('ERROR_MESSAGE', error_msg);
6140: wf_core.token('ERROR_STACK', error_stack);
6141: wf_core.raise('WF_ERROR');
6142: exception
6143: when others then null;
6144: end;
6145: l_dummy := '';
6158: in out dvalue;
6159: exception
6160: when others then
6161: error_msg := sqlerrm;
6162: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',
6163: 'CTX['||ctx||']');
6164: raise;
6165: end;
6166: end if;