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 FND_LOG

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

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

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

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

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

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

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

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

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

1057:
1058: l_pos := p_pos;
1059: for l_crec in c_attr(p_nid) loop
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||'}');

Line 1244: fnd_log.g_current_runtime_level) then

1240: l_aname);
1241: exception
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;

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

1331:
1332: -- relase TEMP allocated LOB
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;

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

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

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

3181: resourceList resourceList_t;
3182:
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:

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

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

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

3516: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3517: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3518:
3519: -- Reset base NLS settings
3520: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3521: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3522: 'wf.plsql.WF_XML.generateDoc',
3523: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3524: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4223: resetNls varchar2(10);
4224:
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:

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

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

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

4472: l_messageName varchar2(30);
4473:
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;

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

4508: l_nlsSort ,
4509: l_nlsCurrency );
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||

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

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

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

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

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

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
4867: wf_log_pkg.string(wf_log_pkg.level_event,
4868: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4869: 'BEGIN');
4870: end if;

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

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

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

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

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

4958: e_RoleNameNotSpecified EXCEPTION;
4959:
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;

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

5011: p_parameter_list);
5012:
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;

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

5040: l_parameters wf_parameter_list_t;
5041: l_erragt wf_agent_t;
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

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

5113:
5114: raise;
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;

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

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

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

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

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

5581: for i in 1..l_responses.COUNT loop
5582: l_step := 'Processing the responses -> '||l_responses(i).name;
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)||

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

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

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

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

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

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