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_DSCRAM_STATS_PKG dependencies on FND_OAM_DEBUG

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

80: l_ctxt VARCHAR2(60) := PKG_NAME||'INTERNAL_COMPLETE_ENTRY';
81:
82: l_stat_id NUMBER(15);
83: BEGIN
84: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: x_return_msg := '';
87:
88: --do the update

Line 103: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

99:
100: --make sure we completed a row
101: IF SQL%ROWCOUNT <> 1 THEN
102: x_return_msg := 'Stat Complete for Run Stat ID('||p_run_stat_id||'), source type ('||p_source_object_type||'), source id ('||p_source_object_id||') updated '||SQL%ROWCOUNT||' stat rows. Should be 1.';
103: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
105: RETURN;
106: END IF;
107:

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

100: --make sure we completed a row
101: IF SQL%ROWCOUNT <> 1 THEN
102: x_return_msg := 'Stat Complete for Run Stat ID('||p_run_stat_id||'), source type ('||p_source_object_type||'), source id ('||p_source_object_id||') updated '||SQL%ROWCOUNT||' stat rows. Should be 1.';
103: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
105: RETURN;
106: END IF;
107:
108: --success

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

106: END IF;
107:
108: --success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 115: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
115: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
116: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
117: END;
118:
119: -- Public

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

112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
115: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
116: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
117: END;
118:
119: -- Public
120: PROCEDURE CREATE_ENTRY_FOR_RUN(p_run_id IN NUMBER,

Line 174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171: EXCEPTION
172: WHEN OTHERS THEN
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: END;
177:
178: -- Public

Line 203: fnd_oam_debug.log(6, l_ctxt, l_return_msg);

199: x_return_status => l_return_status,
200: x_return_msg => l_return_msg);
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: --just log the message
203: fnd_oam_debug.log(6, l_ctxt, l_return_msg);
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 207: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

203: fnd_oam_debug.log(6, l_ctxt, l_return_msg);
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
208: END;
209:
210: -- Public
211: PROCEDURE CREATE_ENTRY(p_source_object_type IN VARCHAR2,

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

217: IS
218: l_ctxt VARCHAR2(60) := PKG_NAME||'CREATE_ENTRY(no_run_id)';
219:
220: BEGIN
221: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
222:
223: CREATE_ENTRY(p_run_stat_id => FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_STAT_ID,
224: p_source_object_type => p_source_object_type,
225: p_source_object_id => p_source_object_id,

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

227: p_prestart_status => p_prestart_status,
228: p_start_message => p_start_message,
229: x_stat_id => x_stat_id);
230:
231: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
232: EXCEPTION
233: WHEN OTHERS THEN
234: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
235: END;

Line 234: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

230:
231: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
232: EXCEPTION
233: WHEN OTHERS THEN
234: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
235: END;
236:
237: -- Public
238: PROCEDURE CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type IN VARCHAR2,

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

248: l_ctxt VARCHAR2(60) := PKG_NAME||'CREATE_ENTRY_AUTONOMOUSLY';
249: l_return_status VARCHAR2(6);
250: l_return_msg VARCHAR2(4000);
251: BEGIN
252: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
253:
254: INTERNAL_CREATE_ENTRY(p_run_stat_id => FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_STAT_ID,
255: p_source_object_type => p_source_object_type,
256: p_source_object_id => p_source_object_id,

Line 265: fnd_oam_debug.log(6, l_ctxt, l_return_msg);

261: x_return_status => l_return_status,
262: x_return_msg => l_return_msg);
263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: IF NOT FND_OAM_DSCRAM_UTILS_PKG.FLAG_TO_BOOLEAN(p_dismiss_failure) THEN
265: fnd_oam_debug.log(6, l_ctxt, l_return_msg);
266: END IF;
267: ROLLBACK;
268: ELSE
269: COMMIT;

Line 270: fnd_oam_debug.log(1, l_ctxt, 'Created stats row.');

266: END IF;
267: ROLLBACK;
268: ELSE
269: COMMIT;
270: fnd_oam_debug.log(1, l_ctxt, 'Created stats row.');
271: END IF;
272:
273: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
274: EXCEPTION

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

269: COMMIT;
270: fnd_oam_debug.log(1, l_ctxt, 'Created stats row.');
271: END IF;
272:
273: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
274: EXCEPTION
275: WHEN OTHERS THEN
276: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
277: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 276: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

272:
273: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
274: EXCEPTION
275: WHEN OTHERS THEN
276: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
277: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
278: ROLLBACK;
279: END;
280:

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

273: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
274: EXCEPTION
275: WHEN OTHERS THEN
276: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
277: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
278: ROLLBACK;
279: END;
280:
281: -- Public

Line 315: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

311: EXCEPTION
312: WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
315: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
316: END;
317:
318: -- Public
319: PROCEDURE COMPLETE_ENTRY(p_run_stat_id IN NUMBER,

Line 333: fnd_oam_debug.log(6, l_ctxt, 'Skipping update because of non-final status '||p_postend_status||'. This should not happen.');

329: l_return_msg VARCHAR2(2048);
330: BEGIN
331: --make sure it's a valid finishing state
332: IF NOT FND_OAM_DSCRAM_UTILS_PKG.STATUS_IS_FINAL(p_postend_status) THEN
333: fnd_oam_debug.log(6, l_ctxt, 'Skipping update because of non-final status '||p_postend_status||'. This should not happen.');
334: RETURN;
335: END IF;
336:
337: INTERNAL_COMPLETE_ENTRY(p_run_stat_id => p_run_stat_id,

Line 348: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

344: x_return_msg => l_return_msg);
345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
349: END;
350:
351: -- Public
352: PROCEDURE COMPLETE_ENTRY(p_source_object_type IN VARCHAR2,

Line 370: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

366: p_end_message => p_end_message);
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
371: END;
372:
373: -- Public
374: FUNCTION HAS_ENTRY(p_run_stat_id IN NUMBER,

Line 395: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: RETURN FALSE;
394: WHEN OTHERS THEN
395: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
396: RETURN FALSE;
397: END;
398:
399: -- Public

Line 411: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

407: p_source_object_type => p_source_object_type,
408: p_source_object_id => p_source_object_id);
409: EXCEPTION
410: WHEN OTHERS THEN
411: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
412: RETURN FALSE;
413: END;
414:
415: END FND_OAM_DSCRAM_STATS_PKG;