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 132: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

485: end if;
486: wf_object_cache.CreateCache(g_Event_Idx);
487: SetMetaDataCached(sysdate);
488: else
489: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
490: wf_log_pkg.string(wf_log_pkg.level_statement,
491: 'wf.plsql.WF_BES_CACHE.GetEventByName.Cache_Get',
492: 'Getting the event from Cache');
493: end if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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