eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_XML dependencies on WF_CORE

Line 50: -- calls to wf_core.

46: and WMA.ATTACH = 'N'
47: and WMA.NAME = WNA.NAME;
48:
49: -- Set these constants as session level varaibles to minumise the
50: -- calls to wf_core.
51: g_newLine varchar2(1) := wf_core.newLine;
52: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
53: g_htmlmessage varchar2(200);
54: g_urlNotification varchar2(200);

Line 51: g_newLine varchar2(1) := wf_core.newLine;

47: and WMA.NAME = WNA.NAME;
48:
49: -- Set these constants as session level varaibles to minumise the
50: -- calls to wf_core.
51: g_newLine varchar2(1) := wf_core.newLine;
52: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
53: g_htmlmessage varchar2(200);
54: g_urlNotification varchar2(200);
55: g_urlListAttachment varchar2(200);

Line 52: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');

48:
49: -- Set these constants as session level varaibles to minumise the
50: -- calls to wf_core.
51: g_newLine varchar2(1) := wf_core.newLine;
52: g_install varchar2(100) := wf_core.Translate('WF_INSTALL');
53: g_htmlmessage varchar2(200);
54: g_urlNotification varchar2(200);
55: g_urlListAttachment varchar2(200);
56: -- These are only used in legacy procedures.

Line 57: g_webAgent varchar2(200) := wf_core.translate('WF_WEB_AGENT');

53: g_htmlmessage varchar2(200);
54: g_urlNotification varchar2(200);
55: g_urlListAttachment varchar2(200);
56: -- These are only used in legacy procedures.
57: g_webAgent varchar2(200) := wf_core.translate('WF_WEB_AGENT');
58: g_wfSchema varchar2(200) := wf_core.translate('WF_SCHEMA');
59: g_fndapi_misschr varchar2(1) := FND_API.G_MISS_CHAR;
60:
61: g_ntfDocText varchar2(30) := wf_notification.doc_text;

Line 58: g_wfSchema varchar2(200) := wf_core.translate('WF_SCHEMA');

54: g_urlNotification varchar2(200);
55: g_urlListAttachment varchar2(200);
56: -- These are only used in legacy procedures.
57: g_webAgent varchar2(200) := wf_core.translate('WF_WEB_AGENT');
58: g_wfSchema varchar2(200) := wf_core.translate('WF_SCHEMA');
59: g_fndapi_misschr varchar2(1) := FND_API.G_MISS_CHAR;
60:
61: g_ntfDocText varchar2(30) := wf_notification.doc_text;
62: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;

Line 70: -- variables from wf_core.nls_date_format,

66: g_base_territory v$nls_parameters.value%TYPE ;
67: g_base_codeset v$nls_parameters.value%TYPE ;
68:
69: -- << sstomar>> : Initialization can be done by using
70: -- variables from wf_core.nls_date_format,
71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;

Line 71: -- wf_core.nls_date_language etc. but since

67: g_base_codeset v$nls_parameters.value%TYPE ;
68:
69: -- << sstomar>> : Initialization can be done by using
70: -- variables from wf_core.nls_date_format,
71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;

Line 74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;

70: -- variables from wf_core.nls_date_format,
71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;

Line 75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;

71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:

Line 76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;

72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);

Line 77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;

73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:

Line 78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;

74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table

Line 240: wf_core.context('Wf_XML','GetRecipients',p_role);

236: end if;
237: end if;
238: exception
239: when others then
240: wf_core.context('Wf_XML','GetRecipients',p_role);
241: raise;
242: end GetRecipients;
243:
244: -- EncodeEntityReference

Line 293: wf_core.context('Wf_Notification', 'DecodeEntityReference');

289: buf := replace(buf, l_amp||'amp;', l_amp);
290: return buf;
291: exception
292: when others then
293: wf_core.context('Wf_Notification', 'DecodeEntityReference');
294: raise;
295: end DecodeEntityReference;
296:
297: -- EnqueueLOBMessage

Line 333: wf_core.context('WF_XML','EnqueueLOBMessage',p_queue,

329: null;
330:
331: exception
332: when others then
333: wf_core.context('WF_XML','EnqueueLOBMessage',p_queue,
334: to_char(p_priority),
335: p_correlation);
336: raise;
337: end EnqueueLOBMessage;

Line 379: wf_core.context('WF_XML','EnqueueMessage',p_queue, to_char(p_priority),

375: exception
376: when others then
377: -- just in case, check and free it any way.
378: wf_temp_lob.ReleaseLob(g_LOBTable, l_msgLobIdx);
379: wf_core.context('WF_XML','EnqueueMessage',p_queue, to_char(p_priority),
380: p_correlation);
381: raise;
382: end EnqueueMessage;
383:

Line 501: wf_core.context('WF_XML','NewLOBTag', p_tag);

497:
498: exception
499: when others then
500: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);
501: wf_core.context('WF_XML','NewLOBTag', p_tag);
502: raise;
503: end NewLOBTag;
504:
505: -- NewLOBTag - Create a new TAG node and insert it into the

Line 636: wf_core.context('WF_XML','NewLOBTag', p_tag);

632: exception
633: when others then
634: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
635: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
636: wf_core.context('WF_XML','NewLOBTag', p_tag);
637: raise;
638: end NewLOBTag;
639:
640: -- NewTag - Create a new TAG node and insert it into the

Line 724: wf_core.context('WF_XML','NewTag', p_tag);

720: return l_pos;
721:
722: exception
723: when others then
724: wf_core.context('WF_XML','NewTag', p_tag);
725: raise;
726: end NewTag;
727:
728:

Line 756: wf_core.context('WF_XML','SkipLOBTag', p_tag, to_char(p_offset),

752: return l_pos + length(l_tag);
753:
754: exception
755: when others then
756: wf_core.context('WF_XML','SkipLOBTag', p_tag, to_char(p_offset),
757: to_char(p_occurance));
758: raise;
759: end SkipLOBTag;
760:

Line 787: wf_core.context('WF_XML','SkipTag', p_tag, to_char(p_offset),

783: return l_pos + length(l_tag);
784:
785: exception
786: when others then
787: wf_core.context('WF_XML','SkipTag', p_tag, to_char(p_offset),
788: to_char(p_occurance));
789: raise;
790: end SkipTag;
791:

Line 844: wf_core.context('WF_XML','GetTagValue',p_tag, to_char(p_pos));

840: p_pos := l_endPos + length(l_endTag) + 1;
841: p_value := l_value;
842: exception
843: when others then
844: wf_core.context('WF_XML','GetTagValue',p_tag, to_char(p_pos));
845: raise;
846: end GetTagValue;
847:
848:

Line 866: wf_core.context('WF_XML','AddElementAttribute',p_attribute_name,

862: p_attribute_list(l_index).attribute := p_attribute_name;
863: p_attribute_list(l_index).value := p_attribute_value;
864: exception
865: when others then
866: wf_core.context('WF_XML','AddElementAttribute',p_attribute_name,
867: p_attribute_value);
868: raise;
869: end;
870:

Line 977: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),

973: wf_log_pkg.string(WF_LOG_PKG.level_error,
974: 'wf.plsql.WF_XML.GetAttachment',
975: 'Error when getting PLSQL Document attachment -> '||sqlerrm);
976: end if;
977: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
978: l_display_type);
979: raise;
980: end;
981:

Line 1000: -- l_filename := Wf_Core.SubstituteSpecialChars(l_filename);

996: -- <> : File name may have '&' character etc., due to it SAX parser at
997: -- (Mailer) java layer will fail if it finds '&' only, so replace it with '&'
998: l_filename := WF_NOTIFICATION.SubstituteSpecialChars(l_filename);
999:
1000: -- l_filename := Wf_Core.SubstituteSpecialChars(l_filename);
1001:
1002: AddElementAttribute('content-type',l_mimeType, l_attrlist);
1003: l_pos := NewLOBTag(p_doc, l_pos, 'BODYPART', '', l_attrlist);
1004: l_attrlist.DELETE;

Line 1050: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),

1046: wf_log_pkg.string(WF_LOG_PKG.level_error,
1047: 'wf.plsql.WF_XML.GetAttachment',
1048: 'Error when getting PLSQL CLOB Document attachment -> '||sqlerrm);
1049: end if;
1050: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1051: l_display_type);
1052: raise;
1053: end;
1054:

Line 1069: -- l_filename := Wf_Core.SubstituteSpecialChars(l_filename);

1065:
1066: -- Bug 8801597
1067: -- <> : File name may have '&' character etc., due to it SAX parser at
1068: -- (Mailer) java layer will fail if it finds '&' only, so replace it with '&'
1069: -- l_filename := Wf_Core.SubstituteSpecialChars(l_filename);
1070: l_filename := WF_NOTIFICATION.SubstituteSpecialChars(l_filename);
1071:
1072: if lower(l_mimeType) not like 'text/%' and
1073: (l_encoding is null or lower(l_encoding) <> 'base64') then

Line 1168: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),

1164: wf_log_pkg.string(WF_LOG_PKG.level_error,
1165: 'wf.plsql.WF_XML.GetAttachment',
1166: 'Error when getting BLOB attachment -> '||sqlerrm);
1167: end if;
1168: wf_core.context('WF_XML', 'GetAttachment', to_char(p_nid),
1169: l_display_type);
1170:
1171: raise;
1172: end;

Line 1234: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),

1230: length(l_end), l_end);
1231:
1232:
1233: if l_error_result is not null or l_error_result <> '' then
1234: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1235: p_agent, to_char(p_pos));
1236: wf_core.token('SQLERR', l_error_result);
1237: wf_core.raise('WF_URLLIST_ERROR');
1238: end if;

Line 1236: wf_core.token('SQLERR', l_error_result);

1232:
1233: if l_error_result is not null or l_error_result <> '' then
1234: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1235: p_agent, to_char(p_pos));
1236: wf_core.token('SQLERR', l_error_result);
1237: wf_core.raise('WF_URLLIST_ERROR');
1238: end if;
1239:
1240: -- No need to handle "&" char in filename here as these names are seeded ones

Line 1237: wf_core.raise('WF_URLLIST_ERROR');

1233: if l_error_result is not null or l_error_result <> '' then
1234: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid),
1235: p_agent, to_char(p_pos));
1236: wf_core.token('SQLERR', l_error_result);
1237: wf_core.raise('WF_URLLIST_ERROR');
1238: end if;
1239:
1240: -- No need to handle "&" char in filename here as these names are seeded ones
1241: l_fileName := g_urlListAttachment||'.html';

Line 1275: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,

1271: exception
1272: when others then
1273: WF_MAIL.CloseLob(l_display_type);
1274: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1275: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,
1276: to_char(p_pos));
1277: l_err_message := sqlerrm;
1278: raise;
1279: end GetAttachment;

Line 1355: wf_core.context('WF_XML', 'GetAttributes', to_char(p_nid));

1351: end loop;
1352: return l_pos;
1353: exception
1354: when others then
1355: wf_core.context('WF_XML', 'GetAttributes', to_char(p_nid));
1356: raise;
1357: end GetAttributes;
1358:
1359: -- GetXMLMessage - Return a CLOB Document containing an XML encoded version of the

Line 1442: wf_core.token('LANG', l_language);

1438: l_subject, l_text_body, l_html_body, l_body_atth,
1439: l_error_result);
1440: -- Check for any problems
1441: if l_error_result is not NULL then
1442: wf_core.token('LANG', l_language);
1443: wf_core.token('TERR', l_territory);
1444: wf_core.token('ERRMSG', l_error_result);
1445: wf_core.raise('WFXMLERR');
1446: end if;

Line 1443: wf_core.token('TERR', l_territory);

1439: l_error_result);
1440: -- Check for any problems
1441: if l_error_result is not NULL then
1442: wf_core.token('LANG', l_language);
1443: wf_core.token('TERR', l_territory);
1444: wf_core.token('ERRMSG', l_error_result);
1445: wf_core.raise('WFXMLERR');
1446: end if;
1447:

Line 1444: wf_core.token('ERRMSG', l_error_result);

1440: -- Check for any problems
1441: if l_error_result is not NULL then
1442: wf_core.token('LANG', l_language);
1443: wf_core.token('TERR', l_territory);
1444: wf_core.token('ERRMSG', l_error_result);
1445: wf_core.raise('WFXMLERR');
1446: end if;
1447:
1448:

Line 1445: wf_core.raise('WFXMLERR');

1441: if l_error_result is not NULL then
1442: wf_core.token('LANG', l_language);
1443: wf_core.token('TERR', l_territory);
1444: wf_core.token('ERRMSG', l_error_result);
1445: wf_core.raise('WFXMLERR');
1446: end if;
1447:
1448:
1449: -- Instantiate a handle to the new document.

Line 1484: wf_core.raise('WFNTFGM_FAILED');

1480: from wf_notifications_view
1481: where notification_id = p_nid;
1482: exception
1483: when NO_DATA_FOUND then
1484: wf_core.raise('WFNTFGM_FAILED');
1485: end;
1486:
1487: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos, 'PRIORITY',
1488: to_char(l_priority), l_attrlist);

Line 1582: wf_core.context('WF_XML', 'GetXMLMessage', to_char(p_nid), p_protocol,

1578:
1579: exception
1580: when others then
1581: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1582: wf_core.context('WF_XML', 'GetXMLMessage', to_char(p_nid), p_protocol,
1583: p_node, p_nlang, p_nterr);
1584: raise;
1585: end getXMLMessage;
1586:

Line 1663: wf_core.raise('WFNTFGM_FAILED');

1659: from wf_notifications
1660: where notification_id = p_nid;
1661: exception
1662: when NO_DATA_FOUND then
1663: wf_core.raise('WFNTFGM_FAILED');
1664: end;
1665:
1666: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos,
1667: 'PRIORITY', to_char(l_priority), l_attrlist);

Line 1693: wf_core.context('WF_XML', 'GetShortLOBXMLMessage', to_char(p_nid));

1689:
1690: exception
1691: when others then
1692: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1693: wf_core.context('WF_XML', 'GetShortLOBXMLMessage', to_char(p_nid));
1694: raise;
1695: end getShortLOBXMLMessage;
1696:
1697: -- GetShortXMLMessage -

Line 1766: wf_core.raise('WFNTFGM_FAILED');

1762: from wf_notifications
1763: where notification_id = p_nid;
1764: exception
1765: when NO_DATA_FOUND then
1766: wf_core.raise('WFNTFGM_FAILED');
1767: end;
1768:
1769: l_pos := NewTag(p_message, l_pos, 'PRIORITY', to_char(l_priority),
1770: l_attrlist);

Line 1786: wf_core.context('WF_XML', 'GetShortXMLMessage', to_char(p_nid));

1782: p_priority := l_priority;
1783:
1784: exception
1785: when others then
1786: wf_core.context('WF_XML', 'GetShortXMLMessage', to_char(p_nid));
1787: raise;
1788: end getShortXMLMessage;
1789:
1790:

Line 1919: wf_core.context('WF_XML', 'EnqueueFullNotification', to_char(p_nid));

1915:
1916: exception
1917: when others then
1918: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1919: wf_core.context('WF_XML', 'EnqueueFullNotification', to_char(p_nid));
1920: raise;
1921: end EnqueueFullNotification;
1922:
1923:

Line 1985: wf_core.context('WF_XML', 'EnqueueLOBNotification', to_char(p_nid));

1981:
1982: exception
1983: when others then
1984: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1985: wf_core.context('WF_XML', 'EnqueueLOBNotification', to_char(p_nid));
1986: raise;
1987: end EnqueueLOBNotification;
1988:
1989: -- EnqueueNotification - To push a notification ID to the outbound

Line 2046: wf_core.context('WF_XML', 'EnqueueNotification', to_char(p_nid));

2042: end if;
2043:
2044: exception
2045: when others then
2046: wf_core.context('WF_XML', 'EnqueueNotification', to_char(p_nid));
2047: raise;
2048: end EnqueueNotification;
2049:
2050:

Line 2078: Wf_Core.Context('WF_XML', 'DequeueMessage', p_queue_name,

2074: exception
2075: when dequeue_timeout then
2076: p_timeout := TRUE;
2077: when others then
2078: Wf_Core.Context('WF_XML', 'DequeueMessage', p_queue_name,
2079: p_correlation);
2080: p_timeout := FALSE;
2081: raise;
2082: end DequeueMessage;

Line 2162: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));

2158: end if;
2159:
2160: exception
2161: when no_program_unit then
2162: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2163: raise;
2164:
2165: when others then
2166: -- First look for a wf_core error.

Line 2166: -- First look for a wf_core error.

2162: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2163: raise;
2164:
2165: when others then
2166: -- First look for a wf_core error.
2167: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2168:
2169: -- If no wf_core error look for a sql error.
2170: if (l_err_name is null) then

Line 2167: wf_core.get_error(l_err_name, l_err_message, l_err_stack);

2163: raise;
2164:
2165: when others then
2166: -- First look for a wf_core error.
2167: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2168:
2169: -- If no wf_core error look for a sql error.
2170: if (l_err_name is null) then
2171: l_err_message := sqlerrm;

Line 2169: -- If no wf_core error look for a sql error.

2165: when others then
2166: -- First look for a wf_core error.
2167: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2168:
2169: -- If no wf_core error look for a sql error.
2170: if (l_err_name is null) then
2171: l_err_message := sqlerrm;
2172: end if;
2173:

Line 2175: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));

2171: l_err_message := sqlerrm;
2172: end if;
2173:
2174: p_error_result := l_err_message;
2175: wf_core.context('WF_XML', 'GetMessage', to_char(p_queue));
2176: raise;
2177:
2178: end GetMessage;
2179:

Line 2215: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));

2211: GetQueueMessage(l_queue_name, p_nid, p_recipient, p_status,
2212: p_timeout, p_error_result);
2213: exception
2214: when no_program_unit then
2215: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2216: raise;
2217:
2218: when others then
2219: -- First look for a wf_core error.

Line 2219: -- First look for a wf_core error.

2215: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2216: raise;
2217:
2218: when others then
2219: -- First look for a wf_core error.
2220: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2221:
2222: -- If no wf_core error look for a sql error.
2223: if (l_err_name is null) then

Line 2220: wf_core.get_error(l_err_name, l_err_message, l_err_stack);

2216: raise;
2217:
2218: when others then
2219: -- First look for a wf_core error.
2220: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2221:
2222: -- If no wf_core error look for a sql error.
2223: if (l_err_name is null) then
2224: l_err_message := sqlerrm;

Line 2222: -- If no wf_core error look for a sql error.

2218: when others then
2219: -- First look for a wf_core error.
2220: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2221:
2222: -- If no wf_core error look for a sql error.
2223: if (l_err_name is null) then
2224: l_err_message := sqlerrm;
2225: end if;
2226:

Line 2228: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));

2224: l_err_message := sqlerrm;
2225: end if;
2226:
2227: p_error_result := l_err_message;
2228: wf_core.context('WF_XML', 'GetShortMessage', to_char(p_queue));
2229: raise;
2230:
2231: end GetShortMessage;
2232:

Line 2280: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));

2276: end if;
2277:
2278: exception
2279: when no_program_unit then
2280: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2281: raise;
2282:
2283: when others then
2284: -- First look for a wf_core error.

Line 2284: -- First look for a wf_core error.

2280: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2281: raise;
2282:
2283: when others then
2284: -- First look for a wf_core error.
2285: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2286:
2287: -- If no wf_core error look for a sql error.
2288: if (l_err_name is null) then

Line 2285: wf_core.get_error(l_err_name, l_err_message, l_err_stack);

2281: raise;
2282:
2283: when others then
2284: -- First look for a wf_core error.
2285: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2286:
2287: -- If no wf_core error look for a sql error.
2288: if (l_err_name is null) then
2289: l_err_message := sqlerrm;

Line 2287: -- If no wf_core error look for a sql error.

2283: when others then
2284: -- First look for a wf_core error.
2285: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2286:
2287: -- If no wf_core error look for a sql error.
2288: if (l_err_name is null) then
2289: l_err_message := sqlerrm;
2290: end if;
2291:

Line 2293: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));

2289: l_err_message := sqlerrm;
2290: end if;
2291:
2292: p_error_result := l_err_message;
2293: wf_core.context('WF_XML', 'GetExceptionMessage', to_char(p_queue));
2294: raise;
2295:
2296: end GetExceptionMessage;
2297:

Line 2391: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);

2387: end if;
2388:
2389: exception
2390: when no_program_unit then
2391: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2392: raise;
2393:
2394: when others then
2395: -- First look for a wf_core error.

Line 2395: -- First look for a wf_core error.

2391: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2392: raise;
2393:
2394: when others then
2395: -- First look for a wf_core error.
2396: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2397:
2398: -- If no wf_core error look for a sql error.
2399: if (l_err_name is null) then

Line 2396: wf_core.get_error(l_err_name, l_err_message, l_err_stack);

2392: raise;
2393:
2394: when others then
2395: -- First look for a wf_core error.
2396: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2397:
2398: -- If no wf_core error look for a sql error.
2399: if (l_err_name is null) then
2400: l_err_message := sqlerrm;

Line 2398: -- If no wf_core error look for a sql error.

2394: when others then
2395: -- First look for a wf_core error.
2396: wf_core.get_error(l_err_name, l_err_message, l_err_stack);
2397:
2398: -- If no wf_core error look for a sql error.
2399: if (l_err_name is null) then
2400: l_err_message := sqlerrm;
2401: end if;
2402:

Line 2404: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);

2400: l_err_message := sqlerrm;
2401: end if;
2402:
2403: p_error_result := l_err_message;
2404: wf_core.context('WF_XML', 'GetQueueMessage', p_queuename);
2405: raise;
2406:
2407: end GetQueueMessage;
2408:

Line 2436: Wf_Core.Context('WF_XML', 'RemoveMessage', p_queue_name, p_correlation);

2432: null;
2433:
2434: exception
2435: when others then
2436: Wf_Core.Context('WF_XML', 'RemoveMessage', p_queue_name, p_correlation);
2437: p_timeout := FALSE;
2438: raise;
2439: end RemoveMessage;
2440:

Line 2498: wf_core.context('WF_XML','RemoveNotification',to_char(p_nid));

2494: end loop;
2495:
2496: exception
2497: when others then
2498: wf_core.context('WF_XML','RemoveNotification',to_char(p_nid));
2499: raise;
2500: end RemoveNotification;
2501:
2502:

Line 2560: wf_core.context('WF_XML','getBodyPart',to_char(p_nid),p_doctype);

2556: WF_MAIL.CloseLob(p_doctype);
2557:
2558: exception
2559: when others then
2560: wf_core.context('WF_XML','getBodyPart',to_char(p_nid),p_doctype);
2561: raise;
2562: end getBodyPart;
2563:
2564:

Line 2588: wf_core.context('WF_XML','GetNLS');

2584:
2585:
2586: exception
2587: when others then
2588: wf_core.context('WF_XML','GetNLS');
2589: raise;
2590: end getNLS;
2591:
2592:

Line 2639: wf_core.context('WF_XML','SetNLS', language, territory);

2635: dbms_session.set_nls('NLS_LANGUAGE' , l_language);
2636: dbms_session.set_nls('NLS_TERRITORY' , l_territory);
2637: exception
2638: when others then
2639: wf_core.context('WF_XML','SetNLS', language, territory);
2640: raise;
2641: end setNLS;
2642:
2643: -- Parse the p_doc for the URL attributes and edit

Line 2752: wf_core.context('WF_XML','ParseForInlineImages',to_char(nid));

2748: when others then
2749: -- Release temp LOB if any error , bug 6511028
2750: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2751:
2752: wf_core.context('WF_XML','ParseForInlineImages',to_char(nid));
2753: raise;
2754: end ParseForInlineImages;
2755:
2756: -- Adds the RESOURCE tags for the inline images.

Line 2795: wf_core.context('WF_XML','addInlineImages', to_char(nid));

2791: end loop;
2792:
2793: exception
2794: when others then
2795: wf_core.context('WF_XML','addInlineImages', to_char(nid));
2796: raise;
2797: end addInlineImages;
2798:
2799:

Line 2967: wf_core.context('WF_XML','addCopyRecipients', p_list, p_type,

2963: end loop;
2964: end if;
2965: exception
2966: when others then
2967: wf_core.context('WF_XML','addCopyRecipients', p_list, p_type,
2968: step);
2969: end addCopyRecipients;
2970:
2971:

Line 3065: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);

3061: AddElementAttribute('codeset', 'UTF8', l_attrlist);
3062: -- Though it will not reach to Java layer, but adding.
3063: AddElementAttribute('is-iana-cs', 'N', l_attrlist);
3064: -- Added below default base parameters.
3065: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
3066: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
3067: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
3068: AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
3069:

Line 3066: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);

3062: -- Though it will not reach to Java layer, but adding.
3063: AddElementAttribute('is-iana-cs', 'N', l_attrlist);
3064: -- Added below default base parameters.
3065: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
3066: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
3067: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
3068: AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
3069:
3070: AddElementAttribute('full-document', 'N', l_attrlist);

Line 3067: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);

3063: AddElementAttribute('is-iana-cs', 'N', l_attrlist);
3064: -- Added below default base parameters.
3065: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
3066: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
3067: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
3068: AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
3069:
3070: AddElementAttribute('full-document', 'N', l_attrlist);
3071: AddElementAttribute('reason', p_reason, l_attrlist);

Line 3068: AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);

3064: -- Added below default base parameters.
3065: AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
3066: AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
3067: AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
3068: AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
3069:
3070: AddElementAttribute('full-document', 'N', l_attrlist);
3071: AddElementAttribute('reason', p_reason, l_attrlist);
3072: l_pos := NewLOBTag(p_doc, l_pos, 'NOTIFICATION', '', l_attrlist);

Line 3217: wf_core.context('WF_XML','GenerateDoc',to_char(nid));

3213: when no_data_found then
3214: GenerateEmptyDoc(nid, p_pos, p_doc, 'no_data_found', FALSE);
3215: return;
3216: when others then
3217: wf_core.context('WF_XML','GenerateDoc',to_char(nid));
3218: raise;
3219: end;
3220:
3221: recipient_role := p_recipient_role;

Line 3308: if (wf_core.error_name = 'WFNTF_ATTR') then

3304: begin
3305: cc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_CC'));
3306: exception
3307: when others then
3308: if (wf_core.error_name = 'WFNTF_ATTR') then
3309: wf_core.clear();
3310: cc_list := null;
3311: else
3312: raise;

Line 3309: wf_core.clear();

3305: cc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_CC'));
3306: exception
3307: when others then
3308: if (wf_core.error_name = 'WFNTF_ATTR') then
3309: wf_core.clear();
3310: cc_list := null;
3311: else
3312: raise;
3313: end if;

Line 3320: if (wf_core.error_name = 'WFNTF_ATTR') then

3316: begin
3317: bcc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_BCC'));
3318: exception
3319: when others then
3320: if (wf_core.error_name = 'WFNTF_ATTR') then
3321: wf_core.clear();
3322: bcc_list := null;
3323: else
3324: raise;

Line 3321: wf_core.clear();

3317: bcc_list := upper(Wf_Notification.GetAttrText(nid, '#WFM_BCC'));
3318: exception
3319: when others then
3320: if (wf_core.error_name = 'WFNTF_ATTR') then
3321: wf_core.clear();
3322: bcc_list := null;
3323: else
3324: raise;
3325: end if;

Line 3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or

3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or

Line 3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or

3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then

Line 3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or

3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.

Line 3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then

3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.
3454: -- at other places pass value as null.
3455: WF_NOTIFICATION_UTIL.SetNLSContext(nid,

Line 3478: g_WebMail_PostScript_Msg := wf_core.translate('WF_WEBMAIL_POSTSCRIPT_MSG');

3474: -- bug 8515763
3475: if(l_ntfPref_Overridden) then
3476: -- Assign value, so it can be checked in getBodyPart( ) API and
3477: -- Nullify in same API so subsequeuent call of getBodyPart( ) will not add.
3478: g_WebMail_PostScript_Msg := wf_core.translate('WF_WEBMAIL_POSTSCRIPT_MSG');
3479: end if;
3480:
3481:
3482: -- Initialise the XML Document and then progressively walk

Line 3520: wf_core.token('ERROR',error_result);

3516:
3517: end if;
3518:
3519: if error_result is not null or error_result <> '' then
3520: wf_core.token('ERROR',error_result);
3521: wf_core.raise('WFMLR_GENERATE_FAILED');
3522: end if;
3523:
3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');

Line 3521: wf_core.raise('WFMLR_GENERATE_FAILED');

3517: end if;
3518:
3519: if error_result is not null or error_result <> '' then
3520: wf_core.token('ERROR',error_result);
3521: wf_core.raise('WFMLR_GENERATE_FAILED');
3522: end if;
3523:
3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');

Line 3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');

3520: wf_core.token('ERROR',error_result);
3521: wf_core.raise('WFMLR_GENERATE_FAILED');
3522: end if;
3523:
3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings

Line 3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');

3521: wf_core.raise('WFMLR_GENERATE_FAILED');
3522: end if;
3523:
3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings
3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');

3522: end if;
3523:
3524: g_htmlmessage := wf_core.translate('WF_HTML_MESSAGE');
3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings
3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3530: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

Line 4079: wf_core.context('WF_XML', 'GenerateDoc', p_event_name, p_event_key);

4075: g_base_nlsCalendar );
4076:
4077:
4078:
4079: wf_core.context('WF_XML', 'GenerateDoc', p_event_name, p_event_key);
4080: raise;
4081: end GenerateDoc;
4082:
4083:

Line 4174: wf_core.context('WF_XML','GenerateGroupDoc',p_event_name, p_event_key);

4170: 'wf.plsql.WF_XML.generateGroupDoc', 'END');
4171: end if;
4172: exception
4173: when others then
4174: wf_core.context('WF_XML','GenerateGroupDoc',p_event_name, p_event_key);
4175: raise;
4176: end GenerateGroupDoc;
4177:
4178: -- GenerateMessage

Line 4237: wf_core.context('WF_XML','GenerateMessage',to_char(nid));

4233: when no_data_found then
4234: GenerateEmptyDoc(nid, 0, p_doc, 'no_data_found', TRUE);
4235: return;
4236: when others then
4237: wf_core.context('WF_XML','GenerateMessage',to_char(nid));
4238: raise;
4239: end;
4240:
4241: -- Bug 10243065. Check if this is a reassigned notification that does

Line 4332: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);

4328: 'wf.plsql.WF_XML.generateMessage', 'END');
4329: end if;
4330: exception
4331: when others then
4332: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
4333: raise;
4334: end GenerateMessage;
4335:
4336: -- GenerateSummaryDoc

Line 4503: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or

4499: -- setNLS(language, territory);
4500: -- Set user / role's context
4501: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4502: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4503: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4504: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4507:

Line 4504: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or

4500: -- Set user / role's context
4501: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4502: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4503: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4504: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4507:
4508:

Line 4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or

4501: if( nvl(l_nlsLanguage, 'AMERICA') <> g_base_language or
4502: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4503: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4504: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4507:
4508:
4509: WF_NOTIFICATION_UTIL.SetNLSContext(0,

Line 4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then

4502: nvl(l_nlsTerritory, 'AMERICAN') <> g_base_territory or
4503: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> g_base_nlsDateFormat or
4504: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> g_base_nlsDateLanguage or
4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4507:
4508:
4509: WF_NOTIFICATION_UTIL.SetNLSContext(0,
4510: l_nlsLanguage ,

Line 4739: wf_core.context('WF_XML', 'GenerateSummaryDoc', p_event_name,

4735: g_base_nlsSort ,
4736: g_base_nlsCalendar );
4737:
4738:
4739: wf_core.context('WF_XML', 'GenerateSummaryDoc', p_event_name,
4740: p_event_key);
4741: raise;
4742: end GenerateSummaryDoc;
4743:

Line 4817: wf_core.context('WF_XML','GenerateGroupSummaryDoc ',p_event_name,

4813: end if;
4814:
4815: exception
4816: when others then
4817: wf_core.context('WF_XML','GenerateGroupSummaryDoc ',p_event_name,
4818: p_event_key);
4819: raise;
4820: end GenerateGroupSummaryDoc ;
4821:

Line 4911: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);

4907: end if;
4908: exception
4909:
4910: when e_RoleNameNotSpecified then
4911: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
4912: raise;
4913:
4914: when others then
4915: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);

Line 4915: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);

4911: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
4912: raise;
4913:
4914: when others then
4915: wf_core.context('WF_XML','GenerateSummary',p_event_name, p_event_key);
4916: raise;
4917: end GenerateSummary;
4918:
4919: -- Generate

Line 4988: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);

4984:
4985: end if;
4986: exception
4987: when others then
4988: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
4989:
4990: -- RESET BASSE LANGUAGE
4991: WF_NOTIFICATION_UTIL.SetNLSContext(null,
4992: g_base_language ,

Line 5285: wf_core.context('WF_XML','getResponseDetails', step);

5281:
5282: exception
5283:
5284: when xmldom.INDEX_SIZE_ERR then
5285: wf_core.context('WF_XML','getResponseDetails', step);
5286: raise;
5287:
5288: when xmldom.DOMSTRING_SIZE_ERR then
5289: wf_core.context('WF_XML','getResponseDetails', step);

Line 5289: wf_core.context('WF_XML','getResponseDetails', step);

5285: wf_core.context('WF_XML','getResponseDetails', step);
5286: raise;
5287:
5288: when xmldom.DOMSTRING_SIZE_ERR then
5289: wf_core.context('WF_XML','getResponseDetails', step);
5290: raise;
5291:
5292: when xmldom.HIERARCHY_REQUEST_ERR then
5293: wf_core.context('WF_XML','getResponseDetails', step);

Line 5293: wf_core.context('WF_XML','getResponseDetails', step);

5289: wf_core.context('WF_XML','getResponseDetails', step);
5290: raise;
5291:
5292: when xmldom.HIERARCHY_REQUEST_ERR then
5293: wf_core.context('WF_XML','getResponseDetails', step);
5294: raise;
5295:
5296: when xmldom.WRONG_DOCUMENT_ERR then
5297: wf_core.context('WF_XML','getResponseDetails', step);

Line 5297: wf_core.context('WF_XML','getResponseDetails', step);

5293: wf_core.context('WF_XML','getResponseDetails', step);
5294: raise;
5295:
5296: when xmldom.WRONG_DOCUMENT_ERR then
5297: wf_core.context('WF_XML','getResponseDetails', step);
5298: raise;
5299:
5300: when xmldom.INVALID_CHARACTER_ERR then
5301: wf_core.context('WF_XML','getResponseDetails', step);

Line 5301: wf_core.context('WF_XML','getResponseDetails', step);

5297: wf_core.context('WF_XML','getResponseDetails', step);
5298: raise;
5299:
5300: when xmldom.INVALID_CHARACTER_ERR then
5301: wf_core.context('WF_XML','getResponseDetails', step);
5302: raise;
5303:
5304: when xmldom.NO_DATA_ALLOWED_ERR then
5305: wf_core.context('WF_XML','getResponseDetails', step);

Line 5305: wf_core.context('WF_XML','getResponseDetails', step);

5301: wf_core.context('WF_XML','getResponseDetails', step);
5302: raise;
5303:
5304: when xmldom.NO_DATA_ALLOWED_ERR then
5305: wf_core.context('WF_XML','getResponseDetails', step);
5306: raise;
5307:
5308: when xmldom.NO_MODIFICATION_ALLOWED_ERR then
5309: wf_core.context('WF_XML','getResponseDetails', step);

Line 5309: wf_core.context('WF_XML','getResponseDetails', step);

5305: wf_core.context('WF_XML','getResponseDetails', step);
5306: raise;
5307:
5308: when xmldom.NO_MODIFICATION_ALLOWED_ERR then
5309: wf_core.context('WF_XML','getResponseDetails', step);
5310: raise;
5311:
5312: when xmldom.NOT_FOUND_ERR then
5313: wf_core.context('WF_XML','getResponseDetails', step);

Line 5313: wf_core.context('WF_XML','getResponseDetails', step);

5309: wf_core.context('WF_XML','getResponseDetails', step);
5310: raise;
5311:
5312: when xmldom.NOT_FOUND_ERR then
5313: wf_core.context('WF_XML','getResponseDetails', step);
5314: raise;
5315:
5316: when xmldom.NOT_SUPPORTED_ERR then
5317: wf_core.context('WF_XML','getResponseDetails', step);

Line 5317: wf_core.context('WF_XML','getResponseDetails', step);

5313: wf_core.context('WF_XML','getResponseDetails', step);
5314: raise;
5315:
5316: when xmldom.NOT_SUPPORTED_ERR then
5317: wf_core.context('WF_XML','getResponseDetails', step);
5318: raise;
5319:
5320: when xmldom.INUSE_ATTRIBUTE_ERR then
5321: wf_core.context('WF_XML','getResponseDetails', step);

Line 5321: wf_core.context('WF_XML','getResponseDetails', step);

5317: wf_core.context('WF_XML','getResponseDetails', step);
5318: raise;
5319:
5320: when xmldom.INUSE_ATTRIBUTE_ERR then
5321: wf_core.context('WF_XML','getResponseDetails', step);
5322: raise;
5323:
5324: when others then
5325: wf_core.context('WF_XML','getResponseDetails', step);

Line 5325: wf_core.context('WF_XML','getResponseDetails', step);

5321: wf_core.context('WF_XML','getResponseDetails', step);
5322: raise;
5323:
5324: when others then
5325: wf_core.context('WF_XML','getResponseDetails', step);
5326: raise;
5327:
5328: end getResponseDetails;
5329:

Line 5362: wf_core.Context('WF_XML','SendNotification',p_event.getEventName(),

5358: end if;
5359: return 'SUCCESS';
5360: exception
5361: when others then
5362: wf_core.Context('WF_XML','SendNotification',p_event.getEventName(),
5363: p_subscription_guid);
5364: -- Save error message and set status to INVALID so mailer will
5365: -- bounce an "invalid reply" message to sender.
5366: wf_event.SetErrorInfo(p_event, 'ERROR');

Line 5434: wf_core.Context('WF_XML','handleReceiveEvent',

5430: 'Exception on call to Wf_Notification.Respond NID['||l_nid||'] '||
5431: 'Error Msg '||sqlerrm);
5432: end if;
5433:
5434: wf_core.Context('WF_XML','handleReceiveEvent',
5435: p_event.getEventName(), p_subscription_guid);
5436: -- Save error message and set status to INVALID so mailer will
5437: -- bounce an "invalid reply" message to sender.
5438: WF_MAIL.HandleResponseError(l_nid, lk_type, lk_code,

Line 5462: wf_core.context('WF_XML', 'HandleReceiveEvent',

5458: 'Signature policy is not DEFAULT');
5459: end if;
5460:
5461: -- If a new policy is added, only wfmail.msg needs to be updated
5462: wf_core.context('WF_XML', 'HandleReceiveEvent',
5463: to_char(l_nid), l_node, l_fromAddr);
5464: wf_core.token('NID', to_char(l_nid));
5465: wf_core.raise('WFRSPR_' || l_sig_policy);
5466: end if;

Line 5464: wf_core.token('NID', to_char(l_nid));

5460:
5461: -- If a new policy is added, only wfmail.msg needs to be updated
5462: wf_core.context('WF_XML', 'HandleReceiveEvent',
5463: to_char(l_nid), l_node, l_fromAddr);
5464: wf_core.token('NID', to_char(l_nid));
5465: wf_core.raise('WFRSPR_' || l_sig_policy);
5466: end if;
5467:
5468: for i in 1..l_responses.COUNT loop

Line 5465: wf_core.raise('WFRSPR_' || l_sig_policy);

5461: -- If a new policy is added, only wfmail.msg needs to be updated
5462: wf_core.context('WF_XML', 'HandleReceiveEvent',
5463: to_char(l_nid), l_node, l_fromAddr);
5464: wf_core.token('NID', to_char(l_nid));
5465: wf_core.raise('WFRSPR_' || l_sig_policy);
5466: end if;
5467:
5468: for i in 1..l_responses.COUNT loop
5469: l_step := 'Processing the responses -> '||l_responses(i).name;

Line 5504: wf_core.token('TYPE', lk_type);

5500: 'wf.plsql.WF_XML.handleReceiveEvent',
5501: 'LOV Meaning is null');
5502: end if;
5503:
5504: wf_core.token('TYPE', lk_type);
5505: wf_core.token('CODE', lk_code);
5506: wf_core.raise('WFSQL_LOOKUP_CODE');
5507: end if;
5508: end if;

Line 5505: wf_core.token('CODE', lk_code);

5501: 'LOV Meaning is null');
5502: end if;
5503:
5504: wf_core.token('TYPE', lk_type);
5505: wf_core.token('CODE', lk_code);
5506: wf_core.raise('WFSQL_LOOKUP_CODE');
5507: end if;
5508: end if;
5509: if (l_responses(i).type = 'MOREINFO') then

Line 5506: wf_core.raise('WFSQL_LOOKUP_CODE');

5502: end if;
5503:
5504: wf_core.token('TYPE', lk_type);
5505: wf_core.token('CODE', lk_code);
5506: wf_core.raise('WFSQL_LOOKUP_CODE');
5507: end if;
5508: end if;
5509: if (l_responses(i).type = 'MOREINFO') then
5510: null; -- discard these responses

Line 5540: wf_core.context('WF_XML', 'HandleReceiveEvent',

5536: if l_responses(i).name = 'WFNTF_MOREINFO_FROM' then
5537: l_user := DecodeEntityReference(lk_code);
5538: elsif l_responses(i).name = 'WFNTF_MOREINFO_QPROMPT' then
5539: if length(l_responses(i).value) > 4000 then
5540: wf_core.context('WF_XML', 'HandleReceiveEvent',
5541: l_responses(i).type,
5542: l_responses(i).name, l_step);
5543: lk_code := substrb(l_responses(i).value, 1,
5544: 1000);

Line 5545: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');

5541: l_responses(i).type,
5542: l_responses(i).name, l_step);
5543: lk_code := substrb(l_responses(i).value, 1,
5544: 1000);
5545: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');
5546: end if;
5547: l_comment := lk_code;
5548: end if;
5549: elsif l_version = 4 then

Line 5552: wf_core.context('WF_XML', 'HandleReceiveEvent',

5548: end if;
5549: elsif l_version = 4 then
5550: if l_responses(i).name = 'WFNTF_MOREINFO_APROMPT' then
5551: if length(l_responses(i).value) > 4000 then
5552: wf_core.context('WF_XML', 'HandleReceiveEvent',
5553: l_responses(i).type,
5554: l_responses(i).name, l_step);
5555: lk_code := substrb(l_responses(i).value, 1,
5556: 1000);

Line 5557: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');

5553: l_responses(i).type,
5554: l_responses(i).name, l_step);
5555: lk_code := substrb(l_responses(i).value, 1,
5556: 1000);
5557: wf_core.raise('WFNTF_QUESTION_TOO_LARGE');
5558: end if;
5559: l_comment := lk_code;
5560: end if;
5561: end if;

Line 5574: wf_core.raise('WFNTF_NO_ROLE');

5570: if l_version = 3 then
5571: -- Question mode
5572: -- Send a email back to the sender that the More Info User is invalid
5573: if (l_user is null or length(trim(l_user)) = 0) then
5574: wf_core.raise('WFNTF_NO_ROLE');
5575: elsif(l_comment is null or length(trim(l_comment)) = 0) then
5576: wf_core.raise('WFNTF_NO_QUESTION');
5577: else
5578: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,

Line 5576: wf_core.raise('WFNTF_NO_QUESTION');

5572: -- Send a email back to the sender that the More Info User is invalid
5573: if (l_user is null or length(trim(l_user)) = 0) then
5574: wf_core.raise('WFNTF_NO_ROLE');
5575: elsif(l_comment is null or length(trim(l_comment)) = 0) then
5576: wf_core.raise('WFNTF_NO_QUESTION');
5577: else
5578: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,
5579: l_comment);
5580: end if;

Line 5585: wf_core.raise('WFNTF_NO_ANSWER');

5581: elsif l_version = 4 then
5582: -- Answer mode
5583: l_user := null;
5584: if(l_comment is null or length(trim(l_comment)) = 0) then
5585: wf_core.raise('WFNTF_NO_ANSWER');
5586: else
5587: wf_notification.UpdateInfo2(l_nid, l_user, l_fromAddr,
5588: l_comment);
5589: end if;

Line 5612: wf_core.Context('WF_XML','handleReceiveEvent',

5608: 'Exception in processing the Response. Step '||l_step||
5609: ' Error Msg '||sqlerrm);
5610: end if;
5611:
5612: wf_core.Context('WF_XML','handleReceiveEvent',
5613: to_char(l_nid), 'Step '||l_step);
5614: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5615: -- Save error message and set status to INVALID so mailer will
5616: -- bounce an "invalid reply" message to sender.

Line 5614: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));

5610: end if;
5611:
5612: wf_core.Context('WF_XML','handleReceiveEvent',
5613: to_char(l_nid), 'Step '||l_step);
5614: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5615: -- Save error message and set status to INVALID so mailer will
5616: -- bounce an "invalid reply" message to sender.
5617: WF_MAIL.HandleResponseError(l_nid, lk_type,
5618: substrb(lk_code, 1, 1000),

Line 5627: wf_core.Context('WF_XML','handleReceiveEvent',p_event.getEventName(),

5623:
5624: exception
5625:
5626: when others then
5627: wf_core.Context('WF_XML','handleReceiveEvent',p_event.getEventName(),
5628: p_subscription_guid);
5629: -- Save error message and set status to INVALID so mailer will
5630: -- bounce an "invalid reply" message to sender.
5631: wf_event.SetErrorInfo(p_event, 'ERROR');

Line 5695: wf_core.Context('WF_XML','Receive',p_event.getEventName(),

5691:
5692: exception
5693:
5694: when others then
5695: wf_core.Context('WF_XML','Receive',p_event.getEventName(),
5696: p_subscription_guid);
5697: -- Save error message and set status to INVALID so mailer will
5698: -- bounce an "invalid reply" message to sender.
5699: wf_event.SetErrorInfo(p_event, 'ERROR');

Line 5819: wf_core.Context('WF_XML','SummaryRule',p_event.getEventName(),

5815:
5816: exception
5817:
5818: when others then
5819: wf_core.Context('WF_XML','SummaryRule',p_event.getEventName(),
5820: p_subscription_guid);
5821: wf_event.SetErrorInfo(p_event, 'ERROR');
5822: return 'ERROR';
5823: end SummaryRule;

Line 6089: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',

6085: when no_data_found then
6086: return 'SUCCESS';
6087: when others then
6088: error_msg := sqlerrm;
6089: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',
6090: 'CTX['||ctx||']');
6091: raise;
6092: end;
6093: else

Line 6100: wf_core.token('ERROR_MESSAGE', error_msg);

6096:
6097: if cb is not null then
6098: -- Put the error onto the stack.
6099: begin
6100: wf_core.token('ERROR_MESSAGE', error_msg);
6101: wf_core.token('ERROR_STACK', error_stack);
6102: wf_core.raise('WF_ERROR');
6103: exception
6104: when others then null;

Line 6101: wf_core.token('ERROR_STACK', error_stack);

6097: if cb is not null then
6098: -- Put the error onto the stack.
6099: begin
6100: wf_core.token('ERROR_MESSAGE', error_msg);
6101: wf_core.token('ERROR_STACK', error_stack);
6102: wf_core.raise('WF_ERROR');
6103: exception
6104: when others then null;
6105: end;

Line 6102: wf_core.raise('WF_ERROR');

6098: -- Put the error onto the stack.
6099: begin
6100: wf_core.token('ERROR_MESSAGE', error_msg);
6101: wf_core.token('ERROR_STACK', error_stack);
6102: wf_core.raise('WF_ERROR');
6103: exception
6104: when others then null;
6105: end;
6106: l_dummy := '';

Line 6123: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',

6119: in out dvalue;
6120: exception
6121: when others then
6122: error_msg := sqlerrm;
6123: wf_core.context('WF_XML','ERROR_RULE','NID['||to_char(nid)||']',
6124: 'CTX['||ctx||']');
6125: raise;
6126: end;
6127: end if;