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.57.12020000.2 2012/07/16 11:28:28 skandepu ship $ */
3: --
4: -- Exceptions
5: --

Line 2: /* $Header: wfmxmlb.pls 120.57.12020000.2 2012/07/16 11:28:28 skandepu ship $ */

1: package body WF_XML as
2: /* $Header: wfmxmlb.pls 120.57.12020000.2 2012/07/16 11:28:28 skandepu ship $ */
3: --
4: -- Exceptions
5: --
6: dequeue_timeout exception;

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

99:
100: begin
101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
102: wf_log_pkg.string(WF_LOG_PKG.level_statement,
103: 'wf.plsql.WF_XML.isImageReference',
104: 'BEGIN {'||url||'} {'||renderType||'}');
105: end if;
106: l_renderType := renderType;
107:

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 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 399: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

395: function NewLOBTag (p_doc in out NOCOPY CLOB,
396: p_pos in integer,
397: p_tag in varchar2,
398: p_data in varchar2,
399: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
400: return integer
401: is
402:
403: -- l_temp CLOB;

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

488: -- dbms_lob.FreeTemporary(l_temp);
489:
490: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
491: wf_log_pkg.string(WF_LOG_PKG.level_statement,
492: 'wf.plsql.WF_XML.newLOBTag',
493: 'TAG: '||l_start||' POS: '||to_char(l_pos));
494: end if;
495:
496: return l_pos;

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 519: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

515: function NewLOBTag (p_doc in out NOCOPY CLOB,
516: p_pos in integer,
517: p_tag in varchar2,
518: p_data in CLOB,
519: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
520: return integer
521: is
522:
523: l_tempIdx pls_integer;

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

622: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
623:
624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
625: wf_log_pkg.string(WF_LOG_PKG.level_statement,
626: 'wf.plsql.WF_XML.newLOBTag',
627: 'TAG: '||l_start||' POS: '||to_char(l_pos));
628: end if;
629:
630: return l_pos;

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 654: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

650: function NewTag (p_doc in out NOCOPY VARCHAR2,
651: p_pos in integer ,
652: p_tag in varchar2,
653: p_data in varchar2,
654: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)
655: return integer
656: is
657:
658: l_temp VARCHAR2(32000);

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

713: l_pos := (p_pos + l_nodesize) - length(l_end);
714:
715: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
716: wf_log_pkg.string(WF_LOG_PKG.level_statement,
717: 'wf.plsql.WF_XML.newTag',
718: 'TAG: '||l_start||' POS: '||to_char(l_pos));
719: end if;
720: return l_pos;
721:

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 807: p_attrlist in out NOCOPY wf_xml_attr_table_type)

803: procedure GetTagValue(p_doc in out NOCOPY CLOB,
804: p_tag in varchar2,
805: p_value out NOCOPY varchar2,
806: p_pos in out NOCOPY integer,
807: p_attrlist in out NOCOPY wf_xml_attr_table_type)
808: as
809:
810: l_value varchar2(32000);
811: l_length integer;

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 857: p_attribute_list IN OUT NOCOPY wf_xml_attr_table_type)

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

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 899: l_attrlist wf_xml_attr_table_type;

895: l_atthname varchar2(255);
896: l_display_type varchar2(256) := p_doc_type;
897: l_content_type varchar2(256); -- as in fnd_lobs
898:
899: l_attrlist wf_xml_attr_table_type;
900: l_cbuf varchar2(32000);
901: l_doc_end integer;
902: l_doc_length number;
903: l_start VARCHAR2(10) := '

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

944: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);
945: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
946:
947: wf_log_pkg.string(WF_LOG_PKG.level_statement,
948: 'wf.plsql.WF_XML.GetAttachment',
949: 'Document URL {'||l_crec.url||'}');
950: end if;
951:
952: if l_crec.type = 'URL' then

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

970: when others then
971: if (wf_log_pkg.level_error >=
972: fnd_log.g_current_runtime_level) then
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);

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 1047: 'wf.plsql.WF_XML.GetAttachment',

1043: when others then
1044: if (wf_log_pkg.level_error >=
1045: fnd_log.g_current_runtime_level) then
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);

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 1165: 'wf.plsql.WF_XML.GetAttachment',

1161: when others then
1162: if (wf_log_pkg.level_error >=
1163: fnd_log.g_current_runtime_level) then
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);

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 1266: 'wf.plsql.WF_XML.GetAttachment',

1262: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1263:
1264: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1265: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1266: 'wf.plsql.WF_XML.GetAttachment',
1267: 'END');
1268: end if;
1269:
1270: return l_pos;

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 1298: l_attrlist wf_xml_attr_table_type;

1294: p_pos in out NOCOPY integer) return integer
1295: is
1296:
1297: l_pos integer;
1298: l_attrlist wf_xml_attr_table_type;
1299: l_occurance integer := 1;
1300: l_error_result varchar2 (2000);
1301: l_err_name varchar2(30);
1302: l_err_message varchar2(2000);

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 1398: l_attrlist wf_xml_attr_table_type;

1394: l_access_key wf_notifications.access_key%TYPE;
1395:
1396: l_response integer;
1397:
1398: l_attrlist wf_xml_attr_table_type;
1399: l_receiverlist varchar2 (4000);
1400: l_status varchar2 (8);
1401: l_language varchar2 (30);
1402: l_territory varchar2 (30);

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 1616: l_attrlist wf_xml_attr_table_type;

1612: l_priority wf_notifications.priority%TYPE;
1613: l_status wf_notifications.status%TYPE;
1614: l_recipient wf_notifications.recipient_role%TYPE;
1615:
1616: l_attrlist wf_xml_attr_table_type;
1617: l_str varchar2 (250);
1618:
1619: l_error_result varchar2 (2000);
1620: l_err_name varchar2 (30);

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 1724: l_attrlist wf_xml_attr_table_type;

1720: l_priority wf_notifications.priority%TYPE;
1721: l_status wf_notifications.status%TYPE;
1722: l_recipient wf_notifications.recipient_role%TYPE;
1723:
1724: l_attrlist wf_xml_attr_table_type;
1725: l_str varchar2 (250);
1726:
1727: l_error_result varchar2 (2000);
1728: l_err_name varchar2 (30);

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 2112: l_attrlist wf_xml_attr_table_type;

2108:
2109: l_message CLOB;
2110: l_timeout BOOLEAN;
2111: l_pos integer;
2112: l_attrlist wf_xml_attr_table_type;
2113:
2114: l_err_name varchar2(30);
2115: l_err_message varchar2(2000);
2116: l_err_stack varchar2(4000);

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 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 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 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 2322: l_attrlist wf_xml_attr_table_type;

2318: l_queue_name varchar2(255);
2319: l_status varchar2(8) := NULL;
2320: l_currstatus varchar2(8);
2321: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE := NULL;
2322: l_attrlist wf_xml_attr_table_type;
2323: l_timeout BOOLEAN;
2324: l_pos integer;
2325: l_statusOK boolean;
2326:

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 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 2629: 'wf.plsql.WF_XML.SetNLS',

2625: end;
2626:
2627: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2628: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
2629: 'wf.plsql.WF_XML.SetNLS',
2630: 'Setting Language {'||l_language||'} {'||
2631: l_territory||'} - Passed in {'||language||
2632: '} {'||territory||'}');
2633: end if;

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 2759: attrlist IN OUT NOCOPY wf_xml_attr_table_type,

2755:
2756: -- Adds the RESOURCE tags for the inline images.
2757: procedure addInlineImages(doc IN OUT NOCOPY CLOB,
2758: pos IN OUT NOCOPY number,
2759: attrlist IN OUT NOCOPY wf_xml_attr_table_type,
2760: nid IN number,
2761: disposition in varchar2,
2762: resourceList in resourceList_t)
2763: is

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 2819: attrlist wf_xml_attr_table_type;

2815: is
2816: display_name varchar2(360);
2817: email varchar2(320);
2818:
2819: attrlist wf_xml_attr_table_type;
2820: occurance integer := 1;
2821:
2822: begin
2823: AddElementAttribute('name', p_role, attrlist);

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 3035: l_attrlist wf_xml_attr_table_type;

3031: -- p_reason: the reason why the document is empty, e-mail is not being sent
3032:
3033: procedure GenerateEmptyDoc(p_nid number, p_pos number, p_doc IN OUT NOCOPY CLOB,
3034: p_reason IN VARCHAR2, p_group BOOLEAN) is
3035: l_attrlist wf_xml_attr_table_type;
3036: l_occurance integer;
3037: str varchar2 (2000);
3038: l_pos number;
3039:

Line 3140: attrlist wf_xml_attr_table_type;

3136: email wf_roles.email_address%TYPE;
3137: notification_pref wf_roles.notification_preference%TYPE;
3138:
3139: occurance integer := 1;
3140: attrlist wf_xml_attr_table_type;
3141: str varchar2 (250);
3142: nodeName varchar2(100) := '#NODE';
3143: agent varchar2(100) := '#AGENT';
3144: replyto varchar2(100) := '#REPLYTO';

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

3190: begin
3191:
3192: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3193: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3194: 'wf.plsql.WF_XML.generateDoc', 'BEGIN');
3195: end if;
3196:
3197: nid := to_number(p_event_key);
3198:

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 3428: 'wf.plsql.WF_XML.generateDoc',

3424:
3425: -- Set NLS language and territory for this notification
3426: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3427: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3428: 'wf.plsql.WF_XML.generateDoc',
3429: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3430: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'
3431: || '} {' || l_nlsCalendar || '} {' || l_nlsNumericCharacters
3432: || '} {' || l_nlsSort || '}');

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

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,
3531: 'wf.plsql.WF_XML.generateDoc',
3532: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3533: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
3534: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
3535: || '} {' || g_base_nlsSort || '}');

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

3798: -- end if;
3799:
3800: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3801: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3802: 'wf.plsql.WF_XML.generateDoc',
3803: ' Template Name returned by Wf_Mail.ProcessSecurityPolicy: [' || t_name || ']' );
3804:
3805: if (frameworkContent ) then
3806: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

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

3803: ' Template Name returned by Wf_Mail.ProcessSecurityPolicy: [' || t_name || ']' );
3804:
3805: if (frameworkContent ) then
3806: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3807: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;
3808: else
3809: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3810: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: NO') ;
3811: end if;

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

3806: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3807: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;
3808: else
3809: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3810: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: NO') ;
3811: end if;
3812: end if;
3813:
3814: -- << sstomar bug 6993909>> :

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

3851: ( t_name is null or t_name <>'OPEN_MAIL_SECURE') ) then
3852:
3853: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3854: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3855: 'wf.plsql.WF_XML.generateDoc',
3856: 'Setting BODYPART content-type multipart/related');
3857: end if;
3858:
3859: -- Set Content-Type = multipart/related because this BODY MAY have

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

3957: -- notificaton appears as Non-Translated.
3958: -- Set NLS language and territory for this notification
3959: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3960: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3961: 'wf.plsql.WF_XML.generateDoc',
3962: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3963: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'
3964: || '} {' || l_nlsCalendar || '} {' || l_nlsNumericCharacters
3965: || '} {' || l_nlsSort || '}');

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

4008: end if;
4009:
4010: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4011: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4012: 'wf.plsql.WF_XML.generateDoc',
4013: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
4014: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
4015: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
4016: || '} {' || g_base_nlsSort || '}');

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

4040:
4041:
4042: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4043: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4044: 'wf.plsql.WF_XML.generateDoc', 'END');
4045: end if;
4046: exception
4047: when others then
4048:

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

4053: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)
4054:
4055: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4056: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4057: 'wf.plsql.WF_XML.generateDoc',
4058: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
4059: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'
4060: || '} {' || g_base_nlsCalendar || '} {' || g_base_nlsNumericCharacters
4061: || '} {' || g_base_nlsSort || '}');

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 4113: attrlist wf_xml_attr_table_type;

4109: INDEX BY BINARY_INTEGER;
4110: i pls_integer := 1;
4111:
4112: members_t members_table_type;
4113: attrlist wf_xml_attr_table_type;
4114: inAttr varchar2(1);
4115: resetNls varchar2(10);
4116: corrId varchar2(128);
4117:

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

4117:
4118: begin
4119: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4120: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4121: 'wf.plsql.WF_XML.generateGroupDoc', 'BEGIN');
4122: end if;
4123: i := 1;
4124: for r in members(p_recipient_role, p_orig_system, p_orig_system_id) loop
4125: members_t(i).user_name := r.user_name;

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

4166: end if;
4167:
4168: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4169: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
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);

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 4207: attrlist wf_xml_attr_table_type;

4203: display_name wf_roles.display_name%TYPE;
4204: email wf_roles.email_address%TYPE;
4205: notification_pref wf_roles.notification_preference%TYPE;
4206:
4207: attrlist wf_xml_attr_table_type;
4208:
4209: nodename varchar2(100);
4210: messageType varchar2(8);
4211: messageName varchar2(30);

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

4216: begin
4217:
4218: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4219: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4220: 'wf.plsql.WF_XML.generateMessage', 'BEGIN');
4221: end if;
4222:
4223: nid := to_number(p_event_key);
4224:

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 4328: 'wf.plsql.WF_XML.generateMessage', 'END');

4324: end if;
4325:
4326: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4327: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
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);

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 4347: attrlist wf_xml_attr_table_type;

4343: p_event_key in varchar2,
4344: p_parameter_list in wf_parameter_list_t)
4345: is
4346: pos integer;
4347: attrlist wf_xml_attr_table_type;
4348: occurance integer;
4349:
4350: docType VARCHAR2(100);
4351:

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

4394: begin
4395:
4396: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4397: wf_log_pkg.string(wf_log_pkg.level_event,
4398: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4399: 'BEGIN');
4400: end if;
4401:
4402: recipient_role := p_recipient_role;

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

4430:
4431:
4432: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4433: wf_log_pkg.string(wf_log_pkg.level_statement,
4434: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4435: 'ROLE {'||recipient_role||'} LANG {'||l_nlsLanguage||
4436: '} TERR {'||l_nlsTerritory||' NTF {'||notification_pref||
4437: '} EMAIL {'||email||'}');
4438:

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

4444: email is null then
4445: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4446: if email is null then
4447: wf_log_pkg.string(wf_log_pkg.level_exception,
4448: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4449: 'Not generating. Recipient has a null '||
4450: 'email address');
4451: else
4452: wf_log_pkg.string(wf_log_pkg.level_exception,

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

4449: 'Not generating. Recipient has a null '||
4450: 'email address');
4451: else
4452: wf_log_pkg.string(wf_log_pkg.level_exception,
4453: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4454: 'Not generating. Recipient has pref: '||
4455: notification_pref);
4456: end if;
4457: end if;

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

4713: p_pos := pos;
4714:
4715: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4716: wf_log_pkg.string(wf_log_pkg.level_event,
4717: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4718: 'END');
4719: end if;
4720:
4721: exception

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 4772: attrlist wf_xml_attr_table_type;

4768:
4769: i pls_integer := 1;
4770:
4771: members_t members_table_type;
4772: attrlist wf_xml_attr_table_type;
4773:
4774: begin
4775:
4776: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

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

4774: begin
4775:
4776: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4777: wf_log_pkg.string(wf_log_pkg.level_event,
4778: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4779: 'BEGIN');
4780: end if;
4781:
4782: i := 1;

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

4789:
4790: if members_t.count = 0 then
4791: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4792: wf_log_pkg.string(wf_log_pkg.level_event,
4793: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4794: 'No role members.');
4795: end if;
4796: GenerateEmptyDoc(0, p_pos, p_doc, 'no_members', TRUE);
4797: else

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

4807: end if;
4808:
4809: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4810: wf_log_pkg.string(wf_log_pkg.level_event,
4811: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4812: 'END');
4813: end if;
4814:
4815: exception

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 4832: attrlist wf_xml_attr_table_type;

4828: p_parameter_list in wf_parameter_list_t)
4829: is
4830: pos integer;
4831:
4832: attrlist wf_xml_attr_table_type;
4833: str varchar2 (2000);
4834:
4835: recipient_role VARCHAR2(100);
4836:

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

4848: begin
4849:
4850: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4851: wf_log_pkg.string(wf_log_pkg.level_event,
4852: 'wf.plsql.WF_XML.GenerateSummary',
4853: 'BEGIN');
4854: end if;
4855:
4856: if p_parameter_list is not null then

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

4901: end if;
4902:
4903: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4904: wf_log_pkg.string(wf_log_pkg.level_event,
4905: 'wf.plsql.WF_XML.GenerateSummary',
4906: 'END');
4907: end if;
4908: exception
4909:

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 4934: 'wf.plsql.WF_XML.generate', 'BEGIN');

4930:
4931: begin
4932: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4933: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4934: 'wf.plsql.WF_XML.generate', 'BEGIN');
4935: end if;
4936: -- We do not use the LOB pooling for the generate as the LOB
4937: -- is to be returned and not reused.
4938: dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.call);

Line 4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,

4966:
4967: end if;
4968:
4969: -- bug 7130745 : added Question / Answere events
4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
4971: wf_xml.WF_NTF_CANCEL,
4972: wf_xml.WF_NTF_REASIGN,
4973: wf_xml.WF_NTF_SEND_QUESTION,
4974: wf_xml.WF_NTF_SEND_ANSWER ) then

Line 4971: wf_xml.WF_NTF_CANCEL,

4967: end if;
4968:
4969: -- bug 7130745 : added Question / Answere events
4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
4971: wf_xml.WF_NTF_CANCEL,
4972: wf_xml.WF_NTF_REASIGN,
4973: wf_xml.WF_NTF_SEND_QUESTION,
4974: wf_xml.WF_NTF_SEND_ANSWER ) then
4975:

Line 4972: wf_xml.WF_NTF_REASIGN,

4968:
4969: -- bug 7130745 : added Question / Answere events
4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
4971: wf_xml.WF_NTF_CANCEL,
4972: wf_xml.WF_NTF_REASIGN,
4973: wf_xml.WF_NTF_SEND_QUESTION,
4974: wf_xml.WF_NTF_SEND_ANSWER ) then
4975:
4976: GenerateMessage(l_doc, p_event_name, p_event_key,

Line 4973: wf_xml.WF_NTF_SEND_QUESTION,

4969: -- bug 7130745 : added Question / Answere events
4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
4971: wf_xml.WF_NTF_CANCEL,
4972: wf_xml.WF_NTF_REASIGN,
4973: wf_xml.WF_NTF_SEND_QUESTION,
4974: wf_xml.WF_NTF_SEND_ANSWER ) then
4975:
4976: GenerateMessage(l_doc, p_event_name, p_event_key,
4977: p_parameter_list);

Line 4974: wf_xml.WF_NTF_SEND_ANSWER ) then

4970: if p_event_name in (wf_xml.WF_NTF_SEND_MESSAGE,
4971: wf_xml.WF_NTF_CANCEL,
4972: wf_xml.WF_NTF_REASIGN,
4973: wf_xml.WF_NTF_SEND_QUESTION,
4974: wf_xml.WF_NTF_SEND_ANSWER ) then
4975:
4976: GenerateMessage(l_doc, p_event_name, p_event_key,
4977: p_parameter_list);
4978:

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 5006: 'wf.plsql.WF_XML.generate', 'END');

5002: end;
5003:
5004: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5005: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5006: 'wf.plsql.WF_XML.generate', 'END');
5007: end if;
5008: return l_doc;
5009:
5010: end Generate;

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 5332: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided

5328: end getResponseDetails;
5329:
5330:
5331: -- sendNotification
5332: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided
5333: -- as forward compatabilty for the original mailer since the call to
5334: -- wf_xml.enqueueNotification has been removed from
5335: -- wf_notification.sendSingle.
5336: -- To use the original mailer, one must enable the subscription that will

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

5330:
5331: -- sendNotification
5332: -- This API is a wrapper to the wf_xml.enqueueNotification. It is provided
5333: -- as forward compatabilty for the original mailer since the call to
5334: -- wf_xml.enqueueNotification has been removed from
5335: -- wf_notification.sendSingle.
5336: -- To use the original mailer, one must enable the subscription that will
5337: -- call this rule function.
5338: -- IN

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

5349: begin
5350: l_eventkey := p_event.GetEventKey();
5351: l_nid := to_number(l_eventKey);
5352: l_eventName := p_event.GetEventName();
5353: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5354: wf_xml.WF_NTF_REASIGN) then
5355: wf_xml.enqueueNotification(l_nid);
5356: else
5357: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 5354: wf_xml.WF_NTF_REASIGN) then

5350: l_eventkey := p_event.GetEventKey();
5351: l_nid := to_number(l_eventKey);
5352: l_eventName := p_event.GetEventName();
5353: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5354: wf_xml.WF_NTF_REASIGN) then
5355: wf_xml.enqueueNotification(l_nid);
5356: else
5357: return wf_rule.default_rule(p_subscription_guid, p_event);
5358: end if;

Line 5355: wf_xml.enqueueNotification(l_nid);

5351: l_nid := to_number(l_eventKey);
5352: l_eventName := p_event.GetEventName();
5353: if l_eventName in (wf_xml.WF_NTF_SEND_MESSAGE, wf_xml.WF_NTF_CANCEL,
5354: wf_xml.WF_NTF_REASIGN) then
5355: wf_xml.enqueueNotification(l_nid);
5356: else
5357: return wf_rule.default_rule(p_subscription_guid, p_event);
5358: end if;
5359: return 'SUCCESS';

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 5421: 'WF_XML.handleReceiveEvent',

5417: begin
5418: lk_type := '';
5419: lk_code := '';
5420: wf_log_pkg.string(WF_LOG_PKG.LEVEL_EXCEPTION,
5421: 'WF_XML.handleReceiveEvent',
5422: 'Notification is not OPEN. Submitting response '||
5423: 'to provide user feedback');
5424: Wf_Notification.Respond(l_nid, NULL, 'email:'||l_fromAddr);
5425: exception

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

5425: exception
5426: when others then
5427: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5428: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5429: 'wf.plsql.WF_XML.handleReceiveEvent',
5430: 'Exception on call to Wf_Notification.Respond NID['||l_nid||'] '||
5431: 'Error Msg '||sqlerrm);
5432: end if;
5433:

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 5457: 'wf.plsql.WF_XML.handleReceiveEvent',

5453: Wf_Mail.GetSignaturePolicy(l_nid, l_sig_policy);
5454: if (l_sig_policy is not NULL and upper(l_sig_policy) <> 'DEFAULT') then
5455: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5456: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5457: 'wf.plsql.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

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 5477: 'wf.plsql.WF_XML.handleReceiveEvent',

5473: lk_code := substrb(l_responses(i).value, 1, 4000);
5474:
5475: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5476: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5477: 'wf.plsql.WF_XML.handleReceiveEvent',
5478: 'Response VALUE ['||
5479: substrb(lk_code, 1, 100)||
5480: '] TYPE ['||lk_type||']');
5481: end if;

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

5496: lk_code);
5497: if lk_meaning is null then
5498: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5499: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5500: 'wf.plsql.WF_XML.handleReceiveEvent',
5501: 'LOV Meaning is null');
5502: end if;
5503:
5504: wf_core.token('TYPE', lk_type);

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 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 5596: 'wf.plsql.WF_XML.handleReceiveEvent',

5592: wf_engine.preserved_context := FALSE;
5593:
5594: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5595: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5596: 'wf.plsql.WF_XML.handleReceiveEvent',
5597: 'Calling Wf_Notification.Respond');
5598: end if;
5599:
5600: Wf_Notification.Respond(nid => l_nid,

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

5603: exception
5604: when others then
5605: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5606: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5607: 'wf.plsql.WF_XML.handleReceiveEvent',
5608: 'Exception in processing the Response. Step '||l_step||
5609: ' Error Msg '||sqlerrm);
5610: end if;
5611:

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

Line 6271: 'wf.plsql.WF_XML.Send_Rule',

6267:
6268: if (l_fulldocloc > 0) then
6269: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
6270: wf_log_pkg.string(wf_log_pkg.level_statement,
6271: 'wf.plsql.WF_XML.Send_Rule',
6272: 'Full Message for the event key '||l_eventKey||'.'
6273: ||'Running the default rule function.');
6274: end if;
6275: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 6280: 'wf.plsql.WF_XML.Send_Rule',

6276: else
6277:
6278: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
6279: wf_log_pkg.string(wf_log_pkg.level_statement,
6280: 'wf.plsql.WF_XML.Send_Rule',
6281: 'No Full Message for the event key '||l_eventKey||'.'
6282: ||'NOT enquing the message into WF_NOTIFICATION_OUT queue.');
6283: end if;
6284: return 'SUCCESS';

Line 6290: end WF_XML;

6286:
6287: end Send_Rule;
6288:
6289:
6290: end WF_XML;