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_XML

Line 1: package body WF_XML as

1: package body WF_XML as
2: /* $Header: wfmxmlb.pls 120.31.12010000.10 2009/02/12 02:15:33 alepe ship $ */
3: --
4: -- Exceptions
5: --

Line 2: /* $Header: wfmxmlb.pls 120.31.12010000.10 2009/02/12 02:15:33 alepe ship $ */

1: package body WF_XML as
2: /* $Header: wfmxmlb.pls 120.31.12010000.10 2009/02/12 02:15:33 alepe ship $ */
3: --
4: -- Exceptions
5: --
6: dequeue_timeout exception;

Line 98: 'wf.plsql.WF_XML.isImageReference',

94:
95: begin
96: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
97: wf_log_pkg.string(WF_LOG_PKG.level_statement,
98: 'wf.plsql.WF_XML.isImageReference',
99: 'BEGIN {'||url||'} {'||renderType||'}');
100: end if;
101: l_renderType := renderType;
102:

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

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

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

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;

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

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:

Line 394: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

390: function NewLOBTag (p_doc in out NOCOPY CLOB,
391: p_pos in integer,
392: p_tag in varchar2,
393: p_data in varchar2,
394: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
395: return integer
396: is
397:
398: -- l_temp CLOB;

Line 487: 'wf.plsql.WF_XML.newLOBTag',

483: -- dbms_lob.FreeTemporary(l_temp);
484:
485: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
486: wf_log_pkg.string(WF_LOG_PKG.level_statement,
487: 'wf.plsql.WF_XML.newLOBTag',
488: 'TAG: '||l_start||' POS: '||to_char(l_pos));
489: end if;
490:
491: return l_pos;

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

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

Line 514: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

510: function NewLOBTag (p_doc in out NOCOPY CLOB,
511: p_pos in integer,
512: p_tag in varchar2,
513: p_data in CLOB,
514: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
515: return integer
516: is
517:
518: l_tempIdx pls_integer;

Line 621: 'wf.plsql.WF_XML.newLOBTag',

617: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
618:
619: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
620: wf_log_pkg.string(WF_LOG_PKG.level_statement,
621: 'wf.plsql.WF_XML.newLOBTag',
622: 'TAG: '||l_start||' POS: '||to_char(l_pos));
623: end if;
624:
625: return l_pos;

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

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

Line 649: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

645: function NewTag (p_doc in out NOCOPY VARCHAR2,
646: p_pos in integer ,
647: p_tag in varchar2,
648: p_data in varchar2,
649: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
650: return integer
651: is
652:
653: l_temp VARCHAR2(32000);

Line 712: 'wf.plsql.WF_XML.newTag',

708: l_pos := (p_pos + l_nodesize) - length(l_end);
709:
710: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
711: wf_log_pkg.string(WF_LOG_PKG.level_statement,
712: 'wf.plsql.WF_XML.newTag',
713: 'TAG: '||l_start||' POS: '||to_char(l_pos));
714: end if;
715: return l_pos;
716:

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

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:

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

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:

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

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:

Line 802: p_attrlist in out NOCOPY wf_xml_attr_table_type)

798: procedure GetTagValue(p_doc in out NOCOPY CLOB,
799: p_tag in varchar2,
800: p_value out NOCOPY varchar2,
801: p_pos in out NOCOPY integer,
802: p_attrlist in out NOCOPY wf_xml_attr_table_type)
803: as
804:
805: l_value varchar2(32000);
806: l_length integer;

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

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:

Line 852: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

848: -- Value for the attribute
849: -- The attribute list to add the name/value pair to.
850: procedure AddElementAttribute(p_attribute_name IN VARCHAR2,
851: p_attribute_value IN VARCHAR2,
852: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
853: is
854: l_index integer;
855: begin
856: l_index := p_attribute_list.COUNT + 1;

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

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:

Line 930: -- on WF_XML for WFA_HTML. This copy remains in tact.

926: -- pEncoding The content-encoding part of the Content-Type
927: --
928: -- NOTE: For bug 3735752, a copy of parseContentType was taken and
929: -- placed into WF_MAIL_UTIL in order to prevent a dependancy
930: -- on WF_XML for WFA_HTML. This copy remains in tact.
931: procedure parseContentType(pContentType in varchar2,
932: pMimeType out nocopy varchar2,
933: pFileName out nocopy varchar2,
934: pExtn out nocopy varchar2,

Line 1015: l_attrlist wf_xml_attr_table_type;

1011: l_blob BLOB;
1012: l_atthname varchar2(255);
1013: l_display_type varchar2(255) := p_doc_type;
1014: l_content_type varchar2(255);
1015: l_attrlist wf_xml_attr_table_type;
1016: l_cbuf varchar2(32000);
1017: l_doc_end integer;
1018: l_doc_length number;
1019: l_start VARCHAR2(10) := '

Line 1064: 'wf.plsql.WF_XML.GetAttachment',

1060: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);
1061: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1062:
1063: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1064: 'wf.plsql.WF_XML.GetAttachment',
1065: 'Document URL {'||l_crec.url||'}');
1066: end if;
1067:
1068: if l_crec.type = 'URL' then

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

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:

Line 1246: 'wf.plsql.WF_XML.GetAttachment',

1242: when others then
1243: if (wf_log_pkg.level_error >=
1244: fnd_log.g_current_runtime_level) 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);

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

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:

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

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;

Line 1337: 'wf.plsql.WF_XML.GetAttachment',

1333: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1334:
1335: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1336: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1337: 'wf.plsql.WF_XML.GetAttachment',
1338: 'END');
1339: end if;
1340:
1341: return l_pos;

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

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;

Line 1369: l_attrlist wf_xml_attr_table_type;

1365: p_pos in out NOCOPY integer) return integer
1366: is
1367:
1368: l_pos integer;
1369: l_attrlist wf_xml_attr_table_type;
1370: l_occurance integer := 1;
1371: l_error_result varchar2 (2000);
1372: l_err_name varchar2(30);
1373: l_err_message varchar2(2000);

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

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

Line 1469: l_attrlist wf_xml_attr_table_type;

1465: l_access_key wf_notifications.access_key%TYPE;
1466:
1467: l_response integer;
1468:
1469: l_attrlist wf_xml_attr_table_type;
1470: l_receiverlist varchar2 (4000);
1471: l_status varchar2 (8);
1472: l_language varchar2 (30);
1473: l_territory varchar2 (30);

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

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:

Line 1687: l_attrlist wf_xml_attr_table_type;

1683: l_priority wf_notifications.priority%TYPE;
1684: l_status wf_notifications.status%TYPE;
1685: l_recipient wf_notifications.recipient_role%TYPE;
1686:
1687: l_attrlist wf_xml_attr_table_type;
1688: l_str varchar2 (250);
1689:
1690: l_error_result varchar2 (2000);
1691: l_err_name varchar2 (30);

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

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 -

Line 1795: l_attrlist wf_xml_attr_table_type;

1791: l_priority wf_notifications.priority%TYPE;
1792: l_status wf_notifications.status%TYPE;
1793: l_recipient wf_notifications.recipient_role%TYPE;
1794:
1795: l_attrlist wf_xml_attr_table_type;
1796: l_str varchar2 (250);
1797:
1798: l_error_result varchar2 (2000);
1799: l_err_name varchar2 (30);

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

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:

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

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:

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

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

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

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:

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

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;

Line 2183: l_attrlist wf_xml_attr_table_type;

2179:
2180: l_message CLOB;
2181: l_timeout BOOLEAN;
2182: l_pos integer;
2183: l_attrlist wf_xml_attr_table_type;
2184:
2185: l_err_name varchar2(30);
2186: l_err_message varchar2(2000);
2187: l_err_stack varchar2(4000);

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

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.

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

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:

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

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.

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

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:

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

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.

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

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:

Line 2393: l_attrlist wf_xml_attr_table_type;

2389: l_queue_name varchar2(255);
2390: l_status varchar2(8) := NULL;
2391: l_currstatus varchar2(8);
2392: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE := NULL;
2393: l_attrlist wf_xml_attr_table_type;
2394: l_timeout BOOLEAN;
2395: l_pos integer;
2396: l_statusOK boolean;
2397:

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

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.

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

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:

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

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:

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

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:

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

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:

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

2640:
2641:
2642: exception
2643: when others then
2644: wf_core.context('WF_XML','GetNLS');
2645: raise;
2646: end getNLS;
2647:
2648:

Line 2685: 'wf.plsql.WF_XML.SetNLS',

2681: end;
2682:
2683: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2684: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
2685: 'wf.plsql.WF_XML.SetNLS',
2686: 'Setting Language {'||l_language||'} {'||
2687: l_territory||'} - Passed in {'||language||
2688: '} {'||territory||'}');
2689: end if;

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

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

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

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.

Line 2815: attrlist IN OUT NOCOPY wf_xml_attr_table_type,

2811:
2812: -- Adds the RESOURCE tags for the inline images.
2813: procedure addInlineImages(doc IN OUT NOCOPY CLOB,
2814: pos IN OUT NOCOPY number,
2815: attrlist IN OUT NOCOPY wf_xml_attr_table_type,
2816: nid IN number,
2817: disposition in varchar2,
2818: resourceList in resourceList_t)
2819: is

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

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:

Line 2875: attrlist wf_xml_attr_table_type;

2871: is
2872: display_name varchar2(360);
2873: email varchar2(320);
2874:
2875: attrlist wf_xml_attr_table_type;
2876: occurance integer := 1;
2877:
2878: begin
2879: AddElementAttribute('name', p_role, attrlist);

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

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:

Line 3139: attrlist wf_xml_attr_table_type;

3135: email VARCHAR2(1000);
3136: notification_pref VARCHAR2(100);
3137:
3138: occurance integer := 1;
3139: attrlist wf_xml_attr_table_type;
3140: str varchar2 (250);
3141: nodeName varchar2(100) := '#NODE';
3142: agent varchar2(100) := '#AGENT';
3143: replyto varchar2(100) := '#REPLYTO';

Line 3187: 'wf.plsql.WF_XML.generateDoc', 'BEGIN');

3183: begin
3184:
3185: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3186: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3187: 'wf.plsql.WF_XML.generateDoc', 'BEGIN');
3188: end if;
3189:
3190: nid := to_number(p_event_key);
3191:

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

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

Line 3438: 'wf.plsql.WF_XML.generateDoc',

3434:
3435: -- Set NLS language and territory for this notification
3436: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3437: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3438: 'wf.plsql.WF_XML.generateDoc',
3439: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3440: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'
3441: || '} {' || l_nlsCalendar || '} {' || l_nlsNumericCharacters
3442: || '} {' || l_nlsSort || '}');

Line 3522: 'wf.plsql.WF_XML.generateDoc',

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,
3522: 'wf.plsql.WF_XML.generateDoc',
3523: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3524: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
3525: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
3526: || '} {' || g_base_nlsSort || '}');

Line 3786: 'wf.plsql.WF_XML.generateDoc',

3782: -- end if;
3783:
3784: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3785: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3786: 'wf.plsql.WF_XML.generateDoc',
3787: ' Template Name returned by Wf_Mail.ProcessSecurityPolicy: [' || t_name || ']' );
3788:
3789: if (frameworkContent ) then
3790: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

Line 3791: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;

3787: ' Template Name returned by Wf_Mail.ProcessSecurityPolicy: [' || t_name || ']' );
3788:
3789: if (frameworkContent ) then
3790: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3791: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;
3792: else
3793: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3794: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: NO') ;
3795: end if;

Line 3794: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: NO') ;

3790: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3791: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;
3792: else
3793: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3794: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: NO') ;
3795: end if;
3796: end if;
3797:
3798: -- << sstomar bug 6993909>> :

Line 3839: 'wf.plsql.WF_XML.generateDoc',

3835: ( t_name is null or t_name <>'OPEN_MAIL_SECURE') ) then
3836:
3837: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3838: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3839: 'wf.plsql.WF_XML.generateDoc',
3840: 'Setting BODYPART content-type multipart/related');
3841: end if;
3842:
3843: -- Set Content-Type = multipart/related because this BODY MAY have

Line 3945: 'wf.plsql.WF_XML.generateDoc',

3941: -- notificaton appears as Non-Translated.
3942: -- Set NLS language and territory for this notification
3943: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3944: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3945: 'wf.plsql.WF_XML.generateDoc',
3946: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3947: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'
3948: || '} {' || l_nlsCalendar || '} {' || l_nlsNumericCharacters
3949: || '} {' || l_nlsSort || '}');

Line 3996: 'wf.plsql.WF_XML.generateDoc',

3992: end if;
3993:
3994: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3995: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3996: 'wf.plsql.WF_XML.generateDoc',
3997: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3998: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
3999: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
4000: || '} {' || g_base_nlsSort || '}');

Line 4028: 'wf.plsql.WF_XML.generateDoc', 'END');

4024:
4025:
4026: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4027: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4028: 'wf.plsql.WF_XML.generateDoc', 'END');
4029: end if;
4030: exception
4031: when others then
4032:

Line 4041: 'wf.plsql.WF_XML.generateDoc',

4037: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)
4038:
4039: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4040: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4041: 'wf.plsql.WF_XML.generateDoc',
4042: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
4043: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
4044: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
4045: || '} {' || g_base_nlsSort || '}');

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

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:

Line 4097: attrlist wf_xml_attr_table_type;

4093: INDEX BY BINARY_INTEGER;
4094: i pls_integer := 1;
4095:
4096: members_t members_table_type;
4097: attrlist wf_xml_attr_table_type;
4098: inAttr varchar2(1);
4099: resetNls varchar2(10);
4100: corrId varchar2(128);
4101:

Line 4105: 'wf.plsql.WF_XML.generateGroupDoc', 'BEGIN');

4101:
4102: begin
4103: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4104: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4105: 'wf.plsql.WF_XML.generateGroupDoc', 'BEGIN');
4106: end if;
4107: i := 1;
4108: for r in members(p_recipient_role, p_orig_system, p_orig_system_id) loop
4109: members_t(i).user_name := r.user_name;

Line 4126: -- wf_core.context('WF_XML','GenerateGroup', p_event_name,

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');

Line 4179: 'wf.plsql.WF_XML.generateGroupDoc', 'END');

4175: end if;
4176:
4177: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4178: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
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);

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

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

Line 4216: attrlist wf_xml_attr_table_type;

4212: display_name VARCHAR2(200);
4213: email VARCHAR2(1000);
4214: notification_pref VARCHAR2(100);
4215:
4216: attrlist wf_xml_attr_table_type;
4217:
4218: nodename varchar2(100);
4219: messageType varchar2(8);
4220: messageName varchar2(30);

Line 4229: 'wf.plsql.WF_XML.generateMessage', 'BEGIN');

4225: begin
4226:
4227: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4228: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4229: 'wf.plsql.WF_XML.generateMessage', 'BEGIN');
4230: end if;
4231:
4232: nid := to_number(p_event_key);
4233:

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

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

Line 4410: 'wf.plsql.WF_XML.generateMessage', 'END');

4406: end if;
4407:
4408: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4409: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
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);

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

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

Line 4429: attrlist wf_xml_attr_table_type;

4425: p_event_key in varchar2,
4426: p_parameter_list in wf_parameter_list_t)
4427: is
4428: pos integer;
4429: attrlist wf_xml_attr_table_type;
4430: occurance integer;
4431:
4432: docType VARCHAR2(100);
4433:

Line 4478: 'wf.plsql.WF_XML.GenerateSummaryDoc',

4474: begin
4475:
4476: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4477: wf_log_pkg.string(wf_log_pkg.level_event,
4478: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4479: 'BEGIN');
4480: end if;
4481:
4482: recipient_role := p_recipient_role;

Line 4514: 'wf.plsql.WF_XML.GenerateSummaryDoc',

4510:
4511:
4512: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4513: wf_log_pkg.string(wf_log_pkg.level_statement,
4514: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4515: 'ROLE {'||recipient_role||'} LANG {'||l_nlsLanguage||
4516: '} TERR {'||l_nlsTerritory||' NTF {'||notification_pref||
4517: '} EMAIL {'||email||'}');
4518:

Line 4528: 'wf.plsql.WF_XML.GenerateSummaryDoc',

4524: email is null then
4525: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4526: if email is null then
4527: wf_log_pkg.string(wf_log_pkg.level_exception,
4528: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4529: 'Not generating. Recipient has a null '||
4530: 'email address');
4531: else
4532: wf_log_pkg.string(wf_log_pkg.level_exception,

Line 4533: 'wf.plsql.WF_XML.GenerateSummaryDoc',

4529: 'Not generating. Recipient has a null '||
4530: 'email address');
4531: else
4532: wf_log_pkg.string(wf_log_pkg.level_exception,
4533: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4534: 'Not generating. Recipient has pref: '||
4535: notification_pref);
4536: end if;
4537: end if;

Line 4807: 'wf.plsql.WF_XML.GenerateSummaryDoc',

4803: p_pos := pos;
4804:
4805: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4806: wf_log_pkg.string(wf_log_pkg.level_event,
4807: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4808: 'END');
4809: end if;
4810:
4811: exception

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

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:

Line 4862: attrlist wf_xml_attr_table_type;

4858:
4859: i pls_integer := 1;
4860:
4861: members_t members_table_type;
4862: attrlist wf_xml_attr_table_type;
4863:
4864: begin
4865:
4866: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

Line 4868: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',

4864: begin
4865:
4866: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4867: wf_log_pkg.string(wf_log_pkg.level_event,
4868: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4869: 'BEGIN');
4870: end if;
4871:
4872: i := 1;

Line 4883: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',

4879:
4880: if members_t.count = 0 then
4881: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4882: wf_log_pkg.string(wf_log_pkg.level_event,
4883: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4884: 'No role members.');
4885: end if;
4886:
4887: AddElementAttribute('maxcount', '1', attrlist);

Line 4923: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',

4919: end if;
4920:
4921: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4922: wf_log_pkg.string(wf_log_pkg.level_event,
4923: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4924: 'END');
4925: end if;
4926:
4927: exception

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

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:

Line 4944: attrlist wf_xml_attr_table_type;

4940: p_parameter_list in wf_parameter_list_t)
4941: is
4942: pos integer;
4943:
4944: attrlist wf_xml_attr_table_type;
4945: str varchar2 (2000);
4946:
4947: recipient_role VARCHAR2(100);
4948:

Line 4964: 'wf.plsql.WF_XML.GenerateSummary',

4960: begin
4961:
4962: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4963: wf_log_pkg.string(wf_log_pkg.level_event,
4964: 'wf.plsql.WF_XML.GenerateSummary',
4965: 'BEGIN');
4966: end if;
4967:
4968: if p_parameter_list is not null then

Line 5017: 'wf.plsql.WF_XML.GenerateSummary',

5013: end if;
5014:
5015: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
5016: wf_log_pkg.string(wf_log_pkg.level_event,
5017: 'wf.plsql.WF_XML.GenerateSummary',
5018: 'END');
5019: end if;
5020: exception
5021:

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

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);

Line 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

Line 5046: 'wf.plsql.WF_XML.generate', 'BEGIN');

5042:
5043: begin
5044: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5045: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5046: 'wf.plsql.WF_XML.generate', 'BEGIN');
5047: end if;
5048: -- We do not use the LOB pooling for the generate as the LOB
5049: -- is to be returned and not reused.
5050: dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.call);

Line 5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,

5079:
5080: end if;
5081:
5082: -- bug 7130745 : added Question / Answere events
5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
5084: wf_xml.WF_NTF_CANCEL,
5085: wf_xml.WF_NTF_REASIGN,
5086: wf_xml.WF_NTF_SEND_QUESTION,
5087: wf_xml.WF_NTF_SEND_ANSWER ) then

Line 5084: wf_xml.WF_NTF_CANCEL,

5080: end if;
5081:
5082: -- bug 7130745 : added Question / Answere events
5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
5084: wf_xml.WF_NTF_CANCEL,
5085: wf_xml.WF_NTF_REASIGN,
5086: wf_xml.WF_NTF_SEND_QUESTION,
5087: wf_xml.WF_NTF_SEND_ANSWER ) then
5088:

Line 5085: wf_xml.WF_NTF_REASIGN,

5081:
5082: -- bug 7130745 : added Question / Answere events
5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
5084: wf_xml.WF_NTF_CANCEL,
5085: wf_xml.WF_NTF_REASIGN,
5086: wf_xml.WF_NTF_SEND_QUESTION,
5087: wf_xml.WF_NTF_SEND_ANSWER ) then
5088:
5089: GenerateMessage(l_doc, p_event_name, p_event_key,

Line 5086: wf_xml.WF_NTF_SEND_QUESTION,

5082: -- bug 7130745 : added Question / Answere events
5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
5084: wf_xml.WF_NTF_CANCEL,
5085: wf_xml.WF_NTF_REASIGN,
5086: wf_xml.WF_NTF_SEND_QUESTION,
5087: wf_xml.WF_NTF_SEND_ANSWER ) then
5088:
5089: GenerateMessage(l_doc, p_event_name, p_event_key,
5090: p_parameter_list);

Line 5087: wf_xml.WF_NTF_SEND_ANSWER ) then

5083: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
5084: wf_xml.WF_NTF_CANCEL,
5085: wf_xml.WF_NTF_REASIGN,
5086: wf_xml.WF_NTF_SEND_QUESTION,
5087: wf_xml.WF_NTF_SEND_ANSWER ) then
5088:
5089: GenerateMessage(l_doc, p_event_name, p_event_key,
5090: p_parameter_list);
5091:

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

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 ,

Line 5119: 'wf.plsql.WF_XML.generate', 'END');

5115: end;
5116:
5117: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5118: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5119: 'wf.plsql.WF_XML.generate', 'END');
5120: end if;
5121: return l_doc;
5122:
5123: end Generate;

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

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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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:

Line 5445: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided

5441: end getResponseDetails;
5442:
5443:
5444: -- sendNotification
5445: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided
5446: -- as forward compatabilty for the original mailer since the call to
5447: -- wf_xml.enqueueNotification has been removed from
5448: -- wf_notification.sendSingle.
5449: -- To use the original mailer, one must enable the subscription that will

Line 5447: -- wf_xml.enqueueNotification has been removed from

5443:
5444: -- sendNotification
5445: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided
5446: -- as forward compatabilty for the original mailer since the call to
5447: -- wf_xml.enqueueNotification has been removed from
5448: -- wf_notification.sendSingle.
5449: -- To use the original mailer, one must enable the subscription that will
5450: -- call this rule function.
5451: -- IN

Line 5466: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,

5462: begin
5463: l_eventkey := p_event.GetEventKey();
5464: l_nid := to_number(l_eventKey);
5465: l_eventName := p_event.GetEventName();
5466: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5467: wf_xml.WF_NTF_REASIGN) then
5468: wf_xml.enqueueNotification(l_nid);
5469: else
5470: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 5467: wf_xml.WF_NTF_REASIGN) then

5463: l_eventkey := p_event.GetEventKey();
5464: l_nid := to_number(l_eventKey);
5465: l_eventName := p_event.GetEventName();
5466: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5467: wf_xml.WF_NTF_REASIGN) then
5468: wf_xml.enqueueNotification(l_nid);
5469: else
5470: return wf_rule.default_rule(p_subscription_guid, p_event);
5471: end if;

Line 5468: wf_xml.enqueueNotification(l_nid);

5464: l_nid := to_number(l_eventKey);
5465: l_eventName := p_event.GetEventName();
5466: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5467: wf_xml.WF_NTF_REASIGN) then
5468: wf_xml.enqueueNotification(l_nid);
5469: else
5470: return wf_rule.default_rule(p_subscription_guid, p_event);
5471: end if;
5472: return 'SUCCESS';

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

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');

Line 5534: 'WF_XML.handleReceiveEvent',

5530: begin
5531: lk_type := '';
5532: lk_code := '';
5533: wf_log_pkg.string(WF_LOG_PKG.LEVEL_EXCEPTION,
5534: 'WF_XML.handleReceiveEvent',
5535: 'Notification is not OPEN. Submitting response '||
5536: 'to provide user feedback');
5537: Wf_Notification.Respond(l_nid, NULL, 'email:'||l_fromAddr);
5538: exception

Line 5542: 'wf.plsql.WF_XML.handleReceiveEvent',

5538: exception
5539: when others then
5540: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5541: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5542: 'wf.plsql.WF_XML.handleReceiveEvent',
5543: 'Exception on call to Wf_Notification.Respond NID['||l_nid||'] '||
5544: 'Error Msg '||sqlerrm);
5545: end if;
5546:

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

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,

Line 5570: 'wf.plsql.WF_XML.handleReceiveEvent',

5566: Wf_Mail.GetSignaturePolicy(l_nid, l_sig_policy);
5567: if (l_sig_policy is not NULL and upper(l_sig_policy) <> 'DEFAULT') then
5568: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5569: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5570: 'wf.plsql.WF_XML.handleReceiveEvent',
5571: 'Signature policy is not DEFAULT');
5572: end if;
5573:
5574: -- If a new policy is added, only wfmail.msg needs to be updated

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

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;

Line 5587: 'wf.plsql.WF_XML.handleReceiveEvent',

5583: lk_type := l_responses(i).format;
5584: lk_code := substrb(l_responses(i).value, 1, 4000);
5585: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5586: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5587: 'wf.plsql.WF_XML.handleReceiveEvent',
5588: 'Response VALUE ['||
5589: substrb(lk_code, 1, 100)||
5590: '] TYPE ['||lk_type||']');
5591: end if;

Line 5610: 'wf.plsql.WF_XML.handleReceiveEvent',

5606: lk_code);
5607: if lk_meaning is null then
5608: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5609: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5610: 'wf.plsql.WF_XML.handleReceiveEvent',
5611: 'LOV Meaning is null');
5612: end if;
5613:
5614: wf_core.token('TYPE', lk_type);

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

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);

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

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);

Line 5694: 'wf.plsql.WF_XML.handleReceiveEvent',

5690: wf_engine.preserved_context := FALSE;
5691:
5692: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5693: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5694: 'wf.plsql.WF_XML.handleReceiveEvent',
5695: 'Calling Wf_Notification.Respond');
5696: end if;
5697:
5698: Wf_Notification.Respond(nid => l_nid,

Line 5705: 'wf.plsql.WF_XML.handleReceiveEvent',

5701: exception
5702: when others then
5703: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5704: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5705: 'wf.plsql.WF_XML.handleReceiveEvent',
5706: 'Exception in processing the Response. Step '||l_step||
5707: ' Error Msg '||sqlerrm);
5708: end if;
5709:

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

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.

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

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');

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

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');

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

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;

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

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

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

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;

Line 6274: end WF_XML;

6270: begin
6271: return g_LOBTable.COUNT;
6272: end;
6273:
6274: end WF_XML;