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_BES_CACHE dependencies on FND_LOG

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

124: l_lastMetaUpload date;
125: begin
126: l_lastMetaUpload := GetMetaDataUploaded();
127:
128: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
129: wf_log_pkg.string(wf_log_pkg.level_statement,
130: 'wf.plsql.WF_BES_CACHE.CacheValid.Check',
131: 'Last upload time {'||to_char(l_lastMetaUpload, g_date_mask)||
132: '} Last cache time {'||to_char(g_LastCacheUpdate, g_date_mask)||'}');

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

156: is
157: begin
158: -- if cache is invalid, clear it so that it can be rebuilt from database
159: if (not CacheValid()) then
160: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
161: wf_log_pkg.string(wf_log_pkg.level_statement,
162: 'wf.plsql.WF_BES_CACHE.ValidateCache.Cache_Invalid',
163: 'Cache is invalid. Clearing the cache');
164: end if;

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

224: fetch c_get_event into p_event_obj.guid, p_event_obj.name, p_event_obj.type,
225: p_event_obj.status, p_event_obj.generate_function,
226: p_event_obj.java_generate_func, p_event_obj.licensed_flag;
227: if (c_get_event%NOTFOUND) then
228: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
229: wf_log_pkg.string(wf_log_pkg.level_statement,
230: 'wf.plsql.WF_BES_CACHE.Load_Event.Not_Found',
231: 'Event {'||p_event_name||'} not found in the database');
232: end if;

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

330: begin
331:
332: -- Check if subscriptions are already loaded for this source type
333: if (upper(p_event_obj.GetSubsLoaded(p_source_type)) = g_status_yes) then
334: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
335: wf_log_pkg.string(wf_log_pkg.level_statement,
336: 'wf.plsql.WF_BES_CACHE.Load_Subscriptions.Check',
337: p_source_type||' subscriptions for event {'||
338: p_event_name||'} are already loaded.');

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

345:
346: -- Load all LOCAL subscriptions from the Database
347: if (lower(p_event_name) in (g_event_unexpected, g_event_any)) then
348: open active_event_subs(p_event_name, p_source_type, p_source_agent);
349: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
350: wf_log_pkg.string(wf_log_pkg.level_procedure,
351: 'wf.plsql.WF_BES_CACHE.Load_Subscriptions.active_event_subs',
352: 'Using cursor active_event_subs for event {'||p_event_name||'}');
353: end if;

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

388: end loop;
389: close active_event_subs;
390: else
391: open active_subs(p_event_name, p_source_type, p_source_agent);
392: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
393: wf_log_pkg.string(wf_log_pkg.level_procedure,
394: 'wf.plsql.WF_BES_CACHE.Load_Subscriptions.active_subs',
395: 'Using cursor active_subs for event {'||p_event_name||'}');
396: end if;

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

431: end loop;
432: close active_subs;
433: end if;
434:
435: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
436: wf_log_pkg.string(wf_log_pkg.level_procedure,
437: 'wf.plsql.WF_BES_CACHE.Load_Subscriptions.End',
438: 'Loaded {'||l_count||'} '||p_source_type||' subscriptions '||
439: 'for event {'||p_event_name||'}');

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

456: l_event_obj wf_event_obj;
457: l_any_data anyData;
458: l_dummy pls_integer;
459: begin
460: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
461: wf_log_pkg.string(wf_log_pkg.level_procedure,
462: 'wf.plsql.WF_BES_CACHE.GetEventByName.Begin',
463: 'Getting event details for {'||p_event_name||'}');
464: end if;

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

473:
474: -- Each object type being cached is identified by a number within
475: -- the session
476: if (not wf_object_cache.IsCacheCreated(g_Event_Idx)) then
477: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
478: wf_log_pkg.string(wf_log_pkg.level_statement,
479: 'wf.plsql.WF_BES_CACHE.GetEventByName.Create_Cache',
480: 'Cache is not created for EVENTS index {'||g_Event_Idx||'}');
481: end if;

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

481: end if;
482: wf_object_cache.CreateCache(g_Event_Idx);
483: SetMetaDataCached(sysdate);
484: else
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_BES_CACHE.GetEventByName.Cache_Get',
488: 'Getting the event from Cache');
489: end if;

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

492:
493: -- If the event is not in the object cache, initialize the object and
494: -- retrieve the details from the database
495: if (l_event_obj is null) then
496: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
497: wf_log_pkg.string(wf_log_pkg.level_statement,
498: 'wf.plsql.WF_BES_CACHE.GetEventByName.Load_Event',
499: 'Event not found in cache. Loading from Database');
500: end if;

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

501: -- Load event from the database to the object
502: Load_Event(p_event_name, l_event_obj);
503:
504: if (l_event_obj is not null) then
505: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
506: wf_log_pkg.string(wf_log_pkg.level_statement,
507: 'wf.plsql.WF_BES_CACHE.GetEventByName.Set_Cache',
508: 'Setting event {'||p_event_name||'} to cache');
509: end if;

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

538: l_any_data anyData;
539: l_dummy pls_integer;
540: l_subs_count number;
541: begin
542: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
543: wf_log_pkg.string(wf_log_pkg.level_procedure,
544: 'wf.plsql.WF_BES_CACHE.GetSubscriptions.Begin',
545: 'Getting subscriptions for event {'||p_event_name||'}'||
546: ' Source Type {'||p_source_type||'} Source Agt {'||p_source_agent||'}');

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

556:
557: -- Load subscriptions for a given source type if not already loaded
558: if (upper(l_event_obj.GetSubsLoaded(p_source_type)) = g_status_no) then
559:
560: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
561: wf_log_pkg.string(wf_log_pkg.level_statement,
562: 'wf.plsql.WF_BES_CACHE.GetSubscriptions.Load_Subs',
563: 'Subscriptions for {'||p_event_name||'} is not already loaded.'||
564: ' Loading from DB for Source Type {'||p_source_type||

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

573: -- load subscriptions for all source_agents if not already loaded
574: Load_Subscriptions(p_event_name, p_source_type, null, l_subs_count, l_event_obj);
575: Set_Event_Object(p_event_name, l_event_obj);
576: else
577: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
578: wf_log_pkg.string(wf_log_pkg.level_statement,
579: 'wf.plsql.WF_BES_CACHE.GetSubscriptions.Subs_Loaded',
580: 'Subscriptions for {'||p_event_name||'} is already loaded to cache');
581: end if;

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

716: wf_agent_obj.Initialize(p_agent_obj);
717: end if;
718:
719: if (p_agent_name is not null and p_system_name is not null) then
720: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
721: wf_log_pkg.string(wf_log_pkg.level_statement,
722: 'wf.plsql.WF_BES_CACHE.Load_Agent.Cursor',
723: 'Loading agent by name '||p_agent_name||'+'||p_system_name);
724: end if;

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

737: p_agent_obj.TYPE,
738: p_agent_obj.JAVA_QUEUE_HANDLER;
739:
740: if (c_get_agent_n%NOTFOUND) then
741: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
742: wf_log_pkg.string(wf_log_pkg.level_statement,
743: 'wf.plsql.WF_BES_CACHE.Load_Agent.Not_Found',
744: 'Agent not found in the database.');
745: end if;

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

747: p_agent_obj := null;
748: end if;
749: close c_get_agent_n;
750: elsif (p_agent_guid is not null) then
751: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
752: wf_log_pkg.string(wf_log_pkg.level_statement,
753: 'wf.plsql.WF_BES_CACHE.Load_Agent.Not_Found',
754: 'Loading agent by GUID '||p_agent_guid);
755: end if;

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

768: p_agent_obj.TYPE,
769: p_agent_obj.JAVA_QUEUE_HANDLER;
770:
771: if (c_get_agent_g%NOTFOUND) then
772: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
773: wf_log_pkg.string(wf_log_pkg.level_statement,
774: 'wf.plsql.WF_BES_CACHE.Load_Agent.Not_Found',
775: 'Agent not found in the database');
776: end if;

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

811: if (p_agent_qh is null) then
812: return;
813: end if;
814:
815: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
816: wf_log_pkg.string(wf_log_pkg.level_statement,
817: 'wf.plsql.WF_BES_CACHE.Load_Agent_QH.Cursor',
818: 'Loading from DB for Queue Handler '||p_agent_qh);
819: end if;

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

833: p_agent_obj.TYPE,
834: p_agent_obj.JAVA_QUEUE_HANDLER;
835:
836: if (c_get_agent%NOTFOUND) then
837: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
838: wf_log_pkg.string(wf_log_pkg.level_statement,
839: 'wf.plsql.WF_BES_CACHE.Load_Agent.Not_Found',
840: 'No Agent exists for the given queue handler');
841: end if;

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

859: l_dummy pls_integer;
860: l_agent_key varchar2(60);
861: l_system_name varchar2(30);
862: begin
863: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
864: wf_log_pkg.string(wf_log_pkg.level_procedure,
865: 'wf.plsql.WF_BES_CACHE.GetAgentByName.Begin',
866: 'Getting agent details for {'||p_agent_name||
867: '+'||p_system_name||'}');

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

890:
891: -- Each object type being cached is identified by a number within
892: -- the session
893: if (not wf_object_cache.IsCacheCreated(g_Agent_Idx)) then
894: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
895: wf_log_pkg.string(wf_log_pkg.level_statement,
896: 'wf.plsql.WF_BES_CACHE.GetAgentByName.Create_Cache',
897: 'Cache is not created for AGENTS index {'||g_Agent_Idx||'}');
898: end if;

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

898: end if;
899: wf_object_cache.CreateCache(g_Agent_Idx);
900: SetMetaDataCached(sysdate);
901: else
902: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
903: wf_log_pkg.string(wf_log_pkg.level_statement,
904: 'wf.plsql.WF_BES_CACHE.GetAgentByName.Cache_Get',
905: 'Getting the Agent from Cache');
906: end if;

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

909:
910: -- If the Agent is not in the object cache, initialize the object and
911: -- retrieve the details from the database
912: if (l_agent_obj is null) then
913: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
914: wf_log_pkg.string(wf_log_pkg.level_statement,
915: 'wf.plsql.WF_BES_CACHE.GetAgentByName.Load_Agent',
916: 'Agent not found in cache. Loading from Database');
917: end if;

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

919:
920: Load_Agent(null, p_agent_name, l_system_name, l_agent_obj);
921:
922: if (l_agent_obj is not null) then
923: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
924: wf_log_pkg.string(wf_log_pkg.level_statement,
925: 'wf.plsql.WF_BES_CACHE.GetAgentByName.Set_Cache',
926: 'Setting Agent {'||l_agent_key||'} to cache');
927: end if;

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

963: ValidateCache();
964:
965: -- check if the Agent cache is created. if created get all agent objects
966: if (not wf_object_cache.IsCacheCreated(g_Agent_Idx)) then
967: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
968: wf_log_pkg.string(wf_log_pkg.level_statement,
969: 'wf.plsql.WF_BES_CACHE.GetAgentByGUID.Create_Cache',
970: 'Cache is not created for AGENTS index {'||g_Agent_Idx||'}');
971: end if;

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

971: end if;
972: wf_object_cache.CreateCache(g_Agent_Idx);
973: SetMetaDataCached(sysdate);
974: else
975: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
976: wf_log_pkg.string(wf_log_pkg.level_statement,
977: 'wf.plsql.WF_BES_CACHE.GetAgentByGUID.Get_All',
978: 'Getting all cached agent objects');
979: end if;

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

995: l_loc := l_all_agents.NEXT(l_loc);
996: end loop;
997:
998: if (l_found) then
999: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1000: wf_log_pkg.string(wf_log_pkg.level_statement,
1001: 'wf.plsql.WF_BES_CACHE.GetAgentByGUID.Cache_Hit',
1002: 'Agent found in cache for GUID '||p_agent_guid);
1003: end if;

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

1012: if (l_agent_obj is not null) then
1013: l_agent_name := l_agent_obj.NAME;
1014: l_system_name := l_agent_obj.SYSTEM_NAME;
1015: l_agent_key := l_agent_name||l_system_name;
1016: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1017: wf_log_pkg.string(wf_log_pkg.level_statement,
1018: 'wf.plsql.WF_BES_CACHE.GetAgentByGUID.Set_Object',
1019: 'Agent loaded from Database for GUID '||p_agent_guid||
1020: '. Setting to cache for '||l_agent_key);

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

1060: ValidateCache();
1061:
1062: -- check if the Agent cache is created. if created get all agent objects
1063: if (not wf_object_cache.IsCacheCreated(g_Agent_Idx)) then
1064: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1065: wf_log_pkg.string(wf_log_pkg.level_statement,
1066: 'wf.plsql.WF_BES_CACHE.GetAgentByQH.Create_Cache',
1067: 'Cache is not created for AGENTS index {'||g_Agent_Idx||'}');
1068: end if;

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

1068: end if;
1069: wf_object_cache.CreateCache(g_Agent_Idx);
1070: SetMetaDataCached(sysdate);
1071: else
1072: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1073: wf_log_pkg.string(wf_log_pkg.level_statement,
1074: 'wf.plsql.WF_BES_CACHE.GetAgentByQH.Get_All',
1075: 'Getting all cached agent objects');
1076: end if;

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

1093: l_loc := l_all_agents.NEXT(l_loc);
1094: end loop;
1095:
1096: if (l_found) then
1097: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1098: wf_log_pkg.string(wf_log_pkg.level_statement,
1099: 'wf.plsql.WF_BES_CACHE.GetAgentByQH.Cache_Hit',
1100: 'Agent found in cache for Queue Handler '||p_agent_qh);
1101: end if;

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

1110: if (l_agent_obj is not null) then
1111: l_agent_name := l_agent_obj.NAME;
1112: l_system_name := l_agent_obj.SYSTEM_NAME;
1113: l_agent_key := l_agent_name||l_system_name;
1114: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1115: wf_log_pkg.string(wf_log_pkg.level_statement,
1116: 'wf.plsql.WF_BES_CACHE.GetAgentByQH.Set_Object',
1117: 'Agent loaded from Database for Queue Hander '||p_agent_qh||
1118: '. Setting to cache for '||l_agent_key);