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_LOG_PKG

Line 101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

97:
98: l_renderType varchar2(10);
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;

Line 102: wf_log_pkg.string(WF_LOG_PKG.level_statement,

98: l_renderType varchar2(10);
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;

Line 490: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

486: l_pos := (p_pos + l_nodesize) - length(l_end);
487: -- Free up the use of the temporary LOB
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;

Line 491: wf_log_pkg.string(WF_LOG_PKG.level_statement,

487: -- Free up the use of the temporary LOB
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:

Line 624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

620:
621: -- Free up the use of the temporary LOBs
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;

Line 625: wf_log_pkg.string(WF_LOG_PKG.level_statement,

621: -- Free up the use of the temporary LOBs
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:

Line 715: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

711: end if;
712:
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;

Line 716: wf_log_pkg.string(WF_LOG_PKG.level_statement,

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

Line 945: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

941:
942: l_pos := p_pos;
943: for l_crec in c_attr(p_nid) loop
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||'}');

Line 947: wf_log_pkg.string(WF_LOG_PKG.level_statement,

943: for l_crec in c_attr(p_nid) loop
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:

Line 971: if (wf_log_pkg.level_error >=

967: wf_notification.GetAttrDoc2(p_nid, l_crec.name, l_display_type,
968: l_tmpcontent, l_content_type);
969: exception
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);

Line 973: wf_log_pkg.string(WF_LOG_PKG.level_error,

969: exception
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),

Line 1044: if (wf_log_pkg.level_error >=

1040: wf_mail.getLOBDocContent(p_nid, l_crec.name, l_display_type,
1041: l_content_type, l_error_result);
1042: exception
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);

Line 1046: wf_log_pkg.string(WF_LOG_PKG.level_error,

1042: exception
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),

Line 1162: if (wf_log_pkg.level_error >=

1158: l_blob, l_content_type,
1159: l_aname);
1160: exception
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);

Line 1164: wf_log_pkg.string(WF_LOG_PKG.level_error,

1160: exception
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),

Line 1264: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1260:
1261: -- relase TEMP allocated LOB
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;

Line 1265: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

1261: -- relase TEMP allocated LOB
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:

Line 2627: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2623: l_language := 'AMERICAN';
2624: l_territory := 'AMERICA';
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||

Line 2628: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

2624: l_territory := 'AMERICA';
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||'}');

Line 3192: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3188: l_is_iana_cs varchar2(1);
3189:
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:

Line 3193: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

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

Line 3426: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3422: -- TODO : Get_Ntf_Language : optimization required.
3423: WF_MAIL.Get_Ntf_Language(nid, l_nlsLanguage, l_nlsTerritory, l_nlsCodeset, l_is_iana_cs);
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 || '} {'

Line 3427: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

3423: WF_MAIL.Get_Ntf_Language(nid, l_nlsLanguage, l_nlsTerritory, l_nlsCodeset, l_is_iana_cs);
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

Line 3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings
3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3530: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3531: 'wf.plsql.WF_XML.generateDoc',
3532: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3533: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'

Line 3530: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings
3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3530: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
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

Line 3800: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3796: -- pos := NewLOBTag(p_doc, pos, 'CONTENT', '', attrlist);
3797: -- attrlist.DELETE;
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:

Line 3801: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

3797: -- attrlist.DELETE;
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

Line 3806: 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,
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') ;

Line 3809: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

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;
3812: end if;
3813:

Line 3853: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3849: -- For BODYPART tag
3850: if ( (frameworkContent = true or imgFound = true) and
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;

Line 3854: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

3850: if ( (frameworkContent = true or imgFound = true) and
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:

Line 3959: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3955:
3956: -- Bug 5379861: Notification Reference section and Attachements of a pl/sql
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 || '} {'

Line 3960: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

3956: -- Bug 5379861: Notification Reference section and Attachements of a pl/sql
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

Line 4010: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4006: else
4007: pos := GetAttachment(nid, p_doc, agent, 'attachment', doctype, pos);
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 || '} {'

Line 4011: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4007: pos := GetAttachment(nid, p_doc, agent, 'attachment', doctype, pos);
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

Line 4042: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4038: p_pos := pos;
4039: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
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

Line 4043: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4039: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
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

Line 4055: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4051: -- Since within wf_mail.getLOBMessage4 we are releasing
4052: -- TEMP LOBs incase of any exception, so there is no need to
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 || '} {'

Line 4056: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4052: -- TEMP LOBs incase of any exception, so there is no need to
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

Line 4119: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4115: resetNls varchar2(10);
4116: corrId varchar2(128);
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;

Line 4120: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4116: corrId varchar2(128);
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

Line 4168: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4164: p_event_name, p_event_key, p_parameter_list);
4165: end loop;
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

Line 4169: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4165: end loop;
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

Line 4218: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4214: resetNls varchar2(10);
4215:
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:

Line 4219: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

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

Line 4326: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4322: orig_system, orig_system_id,
4323: p_event_name, p_event_key, p_parameter_list);
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

Line 4327: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4323: p_event_name, p_event_key, p_parameter_list);
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

Line 4396: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4392:
4393:
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;

Line 4397: wf_log_pkg.string(wf_log_pkg.level_event,

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

Line 4432: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

4428: l_nlsSort ,
4429: l_nlsCurrency );
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||

Line 4433: wf_log_pkg.string(wf_log_pkg.level_statement,

4429: l_nlsCurrency );
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||'}');

Line 4445: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

4441: -- XX TODO Sentinal for DISABLED case? Though there is no NID to be
4442: -- updated, can be used as documentation in the log
4443: if notification_pref not in ('SUMMARY','SUMHTML') or
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 '||

Line 4447: wf_log_pkg.string(wf_log_pkg.level_exception,

4443: if notification_pref not in ('SUMMARY','SUMHTML') or
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

Line 4452: 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,
4453: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4454: 'Not generating. Recipient has pref: '||
4455: notification_pref);
4456: end if;

Line 4715: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4711: pos := SkipLOBTag(p_doc, 'NOTIFICATION', pos, occurance);
4712:
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;

Line 4716: wf_log_pkg.string(wf_log_pkg.level_event,

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

Line 4776: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

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
4777: wf_log_pkg.string(wf_log_pkg.level_event,
4778: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4779: 'BEGIN');
4780: end if;

Line 4777: wf_log_pkg.string(wf_log_pkg.level_event,

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

Line 4791: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4787: i := i + 1;
4788: end loop;
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;

Line 4792: wf_log_pkg.string(wf_log_pkg.level_event,

4788: end loop;
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);

Line 4809: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4805: p_event_name, p_event_key, p_parameter_list);
4806: end loop;
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;

Line 4810: wf_log_pkg.string(wf_log_pkg.level_event,

4806: end loop;
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:

Line 4850: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4846: e_RoleNameNotSpecified EXCEPTION;
4847:
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;

Line 4851: wf_log_pkg.string(wf_log_pkg.level_event,

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

Line 4903: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4899: p_parameter_list);
4900:
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;

Line 4904: wf_log_pkg.string(wf_log_pkg.level_event,

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

Line 4932: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4928: l_parameters wf_parameter_list_t;
4929: l_erragt wf_agent_t;
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

Line 4933: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

4929: l_erragt wf_agent_t;
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.

Line 5004: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

5000:
5001: raise;
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;

Line 5005: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

5001: raise;
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:

Line 5420: wf_log_pkg.string(WF_LOG_PKG.LEVEL_EXCEPTION,

5416: if not notificationIsOpen(l_nid) then
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);

Line 5427: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5423: 'to provide user feedback');
5424: Wf_Notification.Respond(l_nid, NULL, 'email:'||l_fromAddr);
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);

Line 5428: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5424: Wf_Notification.Respond(l_nid, NULL, 'email:'||l_fromAddr);
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;

Line 5455: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5451: -- Check if this notification requires a Signature. Other than DEFAULT
5452: -- policies, no other policy is processed by the mailer.
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;

Line 5456: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5452: -- policies, no other policy is processed by the mailer.
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:

Line 5475: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5471: lk_type := l_responses(i).format;
5472:
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)||

Line 5476: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5472:
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||']');

Line 5498: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5494:
5495: lk_meaning := wf_mail.GetLovMeaning(lk_type,
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;

Line 5499: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5495: lk_meaning := wf_mail.GetLovMeaning(lk_type,
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:

Line 5594: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5590: else
5591: -- Do not need to preserve context
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;

Line 5595: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5591: -- Do not need to preserve context
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:

Line 5605: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5601: responder => 'email:'||l_fromAddr);
5602: end if;
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);

Line 5606: wf_log_pkg.string(WF_LOG_PKG.level_statement,

5602: end if;
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;

Line 6269: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

6265: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="y"', 1, 1);
6266: end if;
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.');

Line 6270: wf_log_pkg.string(wf_log_pkg.level_statement,

6266: end if;
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;

Line 6278: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

6274: end if;
6275: return wf_rule.default_rule(p_subscription_guid, p_event);
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.');

Line 6279: wf_log_pkg.string(wf_log_pkg.level_statement,

6275: return wf_rule.default_rule(p_subscription_guid, p_event);
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;