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.FND_OAM_DS_ALGOS_PKG dependencies on FND_OAM_DEBUG

Line 136: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

132: l_raw_algo_text VARCHAR2(4000);
133: l_weight_modifier NUMBER;
134:
135: BEGIN
136: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
137:
138: --see if the algo misses the cache, if so find it's base definition and add it
139: IF NOT b_algo_cache.EXISTS(p_algo_id) THEN
140: fnd_oam_debug.log(1, l_ctxt, 'Uncached... finding root algo_id.');

Line 140: fnd_oam_debug.log(1, l_ctxt, 'Uncached... finding root algo_id.');

136: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
137:
138: --see if the algo misses the cache, if so find it's base definition and add it
139: IF NOT b_algo_cache.EXISTS(p_algo_id) THEN
140: fnd_oam_debug.log(1, l_ctxt, 'Uncached... finding root algo_id.');
141: --loop the fetch to resolve the chain of use_algo_id references
142: l_current_algo_id := p_algo_id;
143: WHILE TRUE LOOP
144: fnd_oam_debug.log(1, l_ctxt, 'Querying details for algo_id: '||l_current_algo_id);

Line 144: fnd_oam_debug.log(1, l_ctxt, 'Querying details for algo_id: '||l_current_algo_id);

140: fnd_oam_debug.log(1, l_ctxt, 'Uncached... finding root algo_id.');
141: --loop the fetch to resolve the chain of use_algo_id references
142: l_current_algo_id := p_algo_id;
143: WHILE TRUE LOOP
144: fnd_oam_debug.log(1, l_ctxt, 'Querying details for algo_id: '||l_current_algo_id);
145: --fetch attributes corresponding to the current algo id
146: BEGIN
147: SELECT use_algo_id, datatype, algo_text, weight_modifier
148: INTO l_use_algo_id, l_datatype, l_raw_algo_text, l_weight_modifier

Line 155: fnd_oam_debug.log(3, l_ctxt, 'Failed to query algo_id from ds_algos_b - no data found.');

151: AND SYSDATE BETWEEN NVL(START_DATE, SYSDATE) AND NVL(END_DATE, SYSDATE);
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: --if the lookup fails, store that failure in the cache
155: fnd_oam_debug.log(3, l_ctxt, 'Failed to query algo_id from ds_algos_b - no data found.');
156: ADD_BAD_ALGO_CACHE_ENTRY(p_algo_id => p_algo_id);
157: RAISE;
158: END;
159:

Line 162: fnd_oam_debug.log(1, l_ctxt, 'Caching base algo_id: '||l_current_algo_id);

158: END;
159:
160: --if there's no queried use_algo_id, we have our definition
161: IF l_use_algo_id IS NULL THEN
162: fnd_oam_debug.log(1, l_ctxt, 'Caching base algo_id: '||l_current_algo_id);
163: ADD_ALGO_CACHE_ENTRY(p_algo_id => p_algo_id,
164: p_used_algo_id => l_current_algo_id,
165: p_datatype => l_datatype,
166: p_raw_algo_text => l_raw_algo_text,

Line 189: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

185: x_new_column_value);
186: x_weight_modifier := b_algo_cache(p_algo_id).weight_modifier;
187:
188: -- Success
189: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
193: RAISE;

Line 192: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

188: -- Success
189: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
193: RAISE;
194: WHEN VALUE_ERROR THEN
195: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
196: RAISE;

Line 195: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

191: WHEN NO_DATA_FOUND THEN
192: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
193: RAISE;
194: WHEN VALUE_ERROR THEN
195: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
196: RAISE;
197: WHEN OTHERS THEN
198: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
199: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 198: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

194: WHEN VALUE_ERROR THEN
195: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
196: RAISE;
197: WHEN OTHERS THEN
198: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
199: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
200: RAISE;
201: END;
202:

Line 199: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

195: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
196: RAISE;
197: WHEN OTHERS THEN
198: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
199: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
200: RAISE;
201: END;
202:
203: -- Public

Line 211: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

207: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_DEFAULT_ALGO_FOR_DATATYPE';
208:
209: l_id NUMBER;
210: BEGIN
211: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
212:
213: --see if we've already queried this datatype
214: IF b_default_algo_cache.EXISTS(p_datatype) THEN
215: --if we cached the algo_id NULL, we cached failure

Line 221: fnd_oam_debug.log(1, l_ctxt, 'Querying default for datatype "'||p_datatype||'"...');

217: IF l_id IS NULL THEN
218: RAISE NO_DATA_FOUND;
219: END IF;
220: ELSE
221: fnd_oam_debug.log(1, l_ctxt, 'Querying default for datatype "'||p_datatype||'"...');
222:
223: --do the query, automatically throws NO_DATA_FOUND/TOO_MANY_ROWS if less than or greater than one row
224: BEGIN
225: SELECT algo_id

Line 232: fnd_oam_debug.log(1, l_ctxt, 'Found id: '||l_id);

228: WHERE datatype = p_datatype
229: AND default_for_datatype_flag = FND_API.G_TRUE;
230:
231: --cache the result
232: fnd_oam_debug.log(1, l_ctxt, 'Found id: '||l_id);
233: b_default_algo_cache(p_datatype) := l_id;
234: EXCEPTION
235: WHEN OTHERS THEN
236: --cache failure

Line 237: fnd_oam_debug.log(3, l_ctxt, 'Failed to find a default: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

233: b_default_algo_cache(p_datatype) := l_id;
234: EXCEPTION
235: WHEN OTHERS THEN
236: --cache failure
237: fnd_oam_debug.log(3, l_ctxt, 'Failed to find a default: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
238: b_default_algo_cache(p_datatype) := NULL;
239: RAISE;
240: END;
241: END IF;

Line 244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

240: END;
241: END IF;
242:
243: x_algo_id := l_id;
244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
248: RAISE;

Line 247: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

243: x_algo_id := l_id;
244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
248: RAISE;
249: WHEN TOO_MANY_ROWS THEN
250: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
251: RAISE;

Line 250: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

246: WHEN NO_DATA_FOUND THEN
247: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
248: RAISE;
249: WHEN TOO_MANY_ROWS THEN
250: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
251: RAISE;
252: WHEN OTHERS THEN
253: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
254: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 253: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

249: WHEN TOO_MANY_ROWS THEN
250: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
251: RAISE;
252: WHEN OTHERS THEN
253: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
254: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
255: RAISE;
256: END;
257:

Line 254: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

250: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
251: RAISE;
252: WHEN OTHERS THEN
253: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
254: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
255: RAISE;
256: END;
257:
258: