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_OBJECT_CACHE dependencies on WF_LOG_PKG

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

85: l_currIdx number;
86: begin
87: l_currIdx := g_Object_List(p_cache_key).Curr_Idx;
88:
89: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
90: wf_log_pkg.string(wf_log_pkg.level_statement,
91: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
92: 'Checking size of Cache. CurrIdx {'||l_currIdx||'}');
93: end if;

Line 90: wf_log_pkg.string(wf_log_pkg.level_statement,

86: begin
87: l_currIdx := g_Object_List(p_cache_key).Curr_Idx;
88:
89: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
90: wf_log_pkg.string(wf_log_pkg.level_statement,
91: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
92: 'Checking size of Cache. CurrIdx {'||l_currIdx||'}');
93: end if;
94:

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

98: l_currIdx := mod(l_currIdx, g_cacheMaxSize);
99: g_Object_List(p_cache_key).Curr_Idx := l_currIdx;
100:
101: g_Object_List(p_cache_key).Overflow := true;
102: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
103: wf_log_pkg.string(wf_log_pkg.level_statement,
104: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
105: 'Curr Idx exceeded Max Cache size, reseting CurrIdx. '||
106: ' Max Cache Size {'||g_cacheMaxSize||'}');

Line 103: wf_log_pkg.string(wf_log_pkg.level_statement,

99: g_Object_List(p_cache_key).Curr_Idx := l_currIdx;
100:
101: g_Object_List(p_cache_key).Overflow := true;
102: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
103: wf_log_pkg.string(wf_log_pkg.level_statement,
104: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
105: 'Curr Idx exceeded Max Cache size, reseting CurrIdx. '||
106: ' Max Cache Size {'||g_cacheMaxSize||'}');
107: end if;

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

109:
110: -- If the cache has reached it's max size, remove the oldest record
111: if (g_Object_List(p_cache_key).Overflow) then
112: l_oldest := g_Object_List(p_cache_key).Hash_Val(l_currIdx);
113: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
114: wf_log_pkg.string(wf_log_pkg.level_statement,
115: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
116: 'Removing oldest record {'||l_oldest||'} from cache');
117: end if;

Line 114: wf_log_pkg.string(wf_log_pkg.level_statement,

110: -- If the cache has reached it's max size, remove the oldest record
111: if (g_Object_List(p_cache_key).Overflow) then
112: l_oldest := g_Object_List(p_cache_key).Hash_Val(l_currIdx);
113: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
114: wf_log_pkg.string(wf_log_pkg.level_statement,
115: 'wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin',
116: 'Removing oldest record {'||l_oldest||'} from cache');
117: end if;
118: g_Object_List(p_cache_key).Cache_Objs.DELETE(l_oldest);

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

140: l_anyData sys.anyData;
141: begin
142: -- Set object would be called only if the required object was not already
143: -- in the cache.
144: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
145: wf_log_pkg.string(wf_log_pkg.level_procedure,
146: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin',
147: 'Assigning object at {'||p_object_key||'} in cache {'||p_cache_key||'}');
148: end if;

Line 145: wf_log_pkg.string(wf_log_pkg.level_procedure,

141: begin
142: -- Set object would be called only if the required object was not already
143: -- in the cache.
144: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
145: wf_log_pkg.string(wf_log_pkg.level_procedure,
146: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin',
147: 'Assigning object at {'||p_object_key||'} in cache {'||p_cache_key||'}');
148: end if;
149:

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

150: g_Object_List(p_cache_key).Cache_Objs(p_object_key) := p_object;
151:
152: l_currIdx := g_Object_List(p_cache_key).Curr_Idx;
153: g_Object_List(p_cache_key).Hash_Val(l_currIdx) := p_object_key;
154: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
155: wf_log_pkg.string(wf_log_pkg.level_statement,
156: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin',
157: 'Current Idx for age table is {'||l_currIdx||'}');
158: end if;

Line 155: wf_log_pkg.string(wf_log_pkg.level_statement,

151:
152: l_currIdx := g_Object_List(p_cache_key).Curr_Idx;
153: g_Object_List(p_cache_key).Hash_Val(l_currIdx) := p_object_key;
154: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
155: wf_log_pkg.string(wf_log_pkg.level_statement,
156: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin',
157: 'Current Idx for age table is {'||l_currIdx||'}');
158: end if;
159:

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

159:
160: l_currIdx := l_currIdx + 1;
161: g_Object_List(p_cache_key).Curr_Idx := l_currIdx;
162:
163: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
164: wf_log_pkg.string(wf_log_pkg.level_procedure,
165: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.End',
166: 'Assigned object to cache. Next Idx {'||l_currIdx||'}');
167: end if;

Line 164: wf_log_pkg.string(wf_log_pkg.level_procedure,

160: l_currIdx := l_currIdx + 1;
161: g_Object_List(p_cache_key).Curr_Idx := l_currIdx;
162:
163: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
164: wf_log_pkg.string(wf_log_pkg.level_procedure,
165: 'wf.plsql.WF_OBJECT_CACHE.Assign_Object.End',
166: 'Assigned object to cache. Next Idx {'||l_currIdx||'}');
167: end if;
168: end Assign_Object;

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

184: l_objHashVal number;
185:
186: begin
187:
188: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
189: wf_log_pkg.string(wf_log_pkg.level_procedure,
190: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Begin',
191: 'Setting object {'||p_object_key||'} in cache {'||p_cache_index||'}');
192: end if;

Line 189: wf_log_pkg.string(wf_log_pkg.level_procedure,

185:
186: begin
187:
188: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
189: wf_log_pkg.string(wf_log_pkg.level_procedure,
190: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Begin',
191: 'Setting object {'||p_object_key||'} in cache {'||p_cache_index||'}');
192: end if;
193:

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

194: l_cacheLoc := p_cache_index;
195: l_objHashVal := getHashValue(p_object_key);
196:
197: if (isDuplicate(l_cacheLoc, l_objHashVal)) then
198: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
199: wf_log_pkg.string(wf_log_pkg.level_statement,
200: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Overwrite',
201: 'Object already in cache. Overwriting.');
202: end if;

Line 199: wf_log_pkg.string(wf_log_pkg.level_statement,

195: l_objHashVal := getHashValue(p_object_key);
196:
197: if (isDuplicate(l_cacheLoc, l_objHashVal)) then
198: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
199: wf_log_pkg.string(wf_log_pkg.level_statement,
200: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Overwrite',
201: 'Object already in cache. Overwriting.');
202: end if;
203: -- If the object is already in cache, overwrite it. The new one might be an

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

203: -- If the object is already in cache, overwrite it. The new one might be an
204: -- updated one with more information
205: g_Object_List(l_cacheLoc).Cache_Objs(l_objHashVal) := p_object;
206: else
207: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
208: wf_log_pkg.string(wf_log_pkg.level_statement,
209: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Assign',
210: 'Checking cache size and storing object in cache');
211: end if;

Line 208: wf_log_pkg.string(wf_log_pkg.level_statement,

204: -- updated one with more information
205: g_Object_List(l_cacheLoc).Cache_Objs(l_objHashVal) := p_object;
206: else
207: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
208: wf_log_pkg.string(wf_log_pkg.level_statement,
209: 'wf.plsql.WF_OBJECT_CACHE.SetObject.Assign',
210: 'Checking cache size and storing object in cache');
211: end if;
212: -- Checks if cache reached max size. If size reached, the oldest

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

237: dummy pls_integer;
238: l_event wf_event_obj;
239: begin
240:
241: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
242: wf_log_pkg.string(wf_log_pkg.level_procedure,
243: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Begin',
244: 'Getting {'||p_object_key||'} from cache {'||p_cache_index||'}');
245: end if;

Line 242: wf_log_pkg.string(wf_log_pkg.level_procedure,

238: l_event wf_event_obj;
239: begin
240:
241: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
242: wf_log_pkg.string(wf_log_pkg.level_procedure,
243: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Begin',
244: 'Getting {'||p_object_key||'} from cache {'||p_cache_index||'}');
245: end if;
246:

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

248: l_objHashVal := getHashValue(p_object_key);
249:
250: if (g_Object_List.EXISTS(l_cacheLoc) and
251: g_Object_List(l_cacheLoc).Cache_Objs.EXISTS(l_objHashVal)) then
252: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
253: wf_log_pkg.string(wf_log_pkg.level_statement,
254: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit',
255: 'Object found in cache for {'||p_object_key||'}');
256: end if;

Line 253: wf_log_pkg.string(wf_log_pkg.level_statement,

249:
250: if (g_Object_List.EXISTS(l_cacheLoc) and
251: g_Object_List(l_cacheLoc).Cache_Objs.EXISTS(l_objHashVal)) then
252: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
253: wf_log_pkg.string(wf_log_pkg.level_statement,
254: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit',
255: 'Object found in cache for {'||p_object_key||'}');
256: end if;
257: return g_Object_List(l_cacheLoc).Cache_Objs(l_objHashVal);

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

255: 'Object found in cache for {'||p_object_key||'}');
256: end if;
257: return g_Object_List(l_cacheLoc).Cache_Objs(l_objHashVal);
258: else
259: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
260: wf_log_pkg.string(wf_log_pkg.level_statement,
261: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit',
262: 'Object not found in cache for {'||p_object_key||'}');
263: end if;

Line 260: wf_log_pkg.string(wf_log_pkg.level_statement,

256: end if;
257: return g_Object_List(l_cacheLoc).Cache_Objs(l_objHashVal);
258: else
259: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
260: wf_log_pkg.string(wf_log_pkg.level_statement,
261: 'wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit',
262: 'Object not found in cache for {'||p_object_key||'}');
263: end if;
264: return null;

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

276: return wf_objects_t
277: is
278: l_objs wf_objects_t;
279: begin
280: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
281: wf_log_pkg.string(wf_log_pkg.level_statement,
282: 'wf.plsql.WF_OBJECT_CACHE.GetAllObjects.Begin',
283: 'Returning all cached objects for {'||p_cache_index||'}');
284: end if;

Line 281: wf_log_pkg.string(wf_log_pkg.level_statement,

277: is
278: l_objs wf_objects_t;
279: begin
280: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
281: wf_log_pkg.string(wf_log_pkg.level_statement,
282: 'wf.plsql.WF_OBJECT_CACHE.GetAllObjects.Begin',
283: 'Returning all cached objects for {'||p_cache_index||'}');
284: end if;
285: return g_Object_List(p_cache_index).Cache_Objs;

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

292: is
293: l_cacheLoc number;
294: begin
295:
296: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
297: wf_log_pkg.string(wf_log_pkg.level_procedure,
298: 'wf.plsql.WF_OBJECT_CACHE.Clear.Begin',
299: 'Clearing object at cache index {'||p_cache_index||'}');
300: end if;

Line 297: wf_log_pkg.string(wf_log_pkg.level_procedure,

293: l_cacheLoc number;
294: begin
295:
296: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
297: wf_log_pkg.string(wf_log_pkg.level_procedure,
298: 'wf.plsql.WF_OBJECT_CACHE.Clear.Begin',
299: 'Clearing object at cache index {'||p_cache_index||'}');
300: end if;
301: -- If cache index is specified, delete only that specified cache