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

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

135: SELECT run_status, target_dbname
136: FROM fnd_oam_dscram_runs_b
137: WHERE run_id = p_run_id;
138: BEGIN
139: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: x_return_msg := '';
142:
143: -- check that data scrambling is enabled first

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

170: IF NOT FND_OAM_DSCRAM_UTILS_PKG.STATUS_IS_PROCESSING(l_status) THEN
171: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_START_STS_TO_RET(l_status);
172: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
173: x_return_msg := 'Invalid run status('||l_status||')';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: END IF;
176: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
177: RETURN FALSE;
178: END IF;

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

172: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
173: x_return_msg := 'Invalid run status('||l_status||')';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: END IF;
176: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
177: RETURN FALSE;
178: END IF;
179:
180: --validate that the run's dbname matches this DB

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

187: RAISE PROGRAM_ERROR;
188: END IF;
189:
190: --success
191: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: RETURN TRUE;
194: EXCEPTION
195: WHEN PROGRAM_ERROR THEN

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

192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: RETURN TRUE;
194: EXCEPTION
195: WHEN PROGRAM_ERROR THEN
196: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
197: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
198: RETURN FALSE;
199: WHEN OTHERS THEN
200: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

193: RETURN TRUE;
194: EXCEPTION
195: WHEN PROGRAM_ERROR THEN
196: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
197: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
198: RETURN FALSE;
199: WHEN OTHERS THEN
200: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
201: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

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

197: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
198: RETURN FALSE;
199: WHEN OTHERS THEN
200: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
201: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
204: RETURN FALSE;
205: END;

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

199: WHEN OTHERS THEN
200: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
201: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
204: RETURN FALSE;
205: END;
206:
207: -- Public

Line 242: fnd_oam_debug.log(1, l_ctxt, '>RE-QUERYING<');

238: x_return_status := b_run_info.last_validation_ret_sts;
239: RETURN (x_return_status = FND_API.G_RET_STS_SUCCESS);
240: END IF;
241:
242: fnd_oam_debug.log(1, l_ctxt, '>RE-QUERYING<');
243:
244: -- re-init the cached fields to allow easy exit
245: b_run_info.last_validation_ret_sts := x_return_status;
246: b_run_info.last_validated := SYSDATE;

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

250: FETCH C1 INTO l_status;
251: IF C1%NOTFOUND THEN
252: --shouldn't happen since we're using the cached run_id
253: x_return_msg := 'Invalid cached run_id: '||b_run_info.run_id;
254: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
255: RETURN FALSE;
256: END IF;
257: CLOSE C1;
258:

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

261: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_CONT_STS_TO_RET(l_status);
262: b_run_info.last_validation_ret_sts := x_return_status;
263: IF x_return_status <> FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_PROCESSED THEN
264: x_return_msg := 'Invalid run status('||l_status||')';
265: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
266: END IF;
267: RETURN FALSE;
268: END IF;
269:

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

276: RETURN TRUE;
277: EXCEPTION
278: WHEN OTHERS THEN
279: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
280: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: b_run_info.last_validation_ret_sts := x_return_status;
283: b_run_info.last_validated := SYSDATE;
284: RETURN FALSE;

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

312: WHERE EXISTS (SELECT 1
313: FROM fnd_oam_dscram_stats
314: WHERE stat_id = c_stat_id);
315: BEGIN
316: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: x_return_msg := '';
319:
320: --fetch necessary run attributes

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

321: OPEN C1;
322: FETCH C1 INTO l_run_stat_id, l_valid_check_interval, l_run_mode;
323: IF C1%NOTFOUND THEN
324: x_return_msg := 'Invalid run_id: ('||p_run_id||')';
325: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
326: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
327: RETURN;
328: END IF;
329: CLOSE C1;

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

322: FETCH C1 INTO l_run_stat_id, l_valid_check_interval, l_run_mode;
323: IF C1%NOTFOUND THEN
324: x_return_msg := 'Invalid run_id: ('||p_run_id||')';
325: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
326: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
327: RETURN;
328: END IF;
329: CLOSE C1;
330:

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

332: OPEN C2(l_run_stat_id);
333: FETCH C2 into l_null;
334: IF C2%NOTFOUND THEN
335: x_return_msg := 'Invalid run_stat_id: ('||l_run_stat_id||')';
336: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
337: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
338: RETURN;
339: END IF;
340: CLOSE C2;

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

333: FETCH C2 into l_null;
334: IF C2%NOTFOUND THEN
335: x_return_msg := 'Invalid run_stat_id: ('||l_run_stat_id||')';
336: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
337: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
338: RETURN;
339: END IF;
340: CLOSE C2;
341:

Line 342: fnd_oam_debug.log(1, l_ctxt, 'Run Stat ID: '||l_run_stat_id);

338: RETURN;
339: END IF;
340: CLOSE C2;
341:
342: fnd_oam_debug.log(1, l_ctxt, 'Run Stat ID: '||l_run_stat_id);
343:
344: b_run_info.run_id := p_run_id;
345: b_run_info.run_stat_id := l_run_stat_id;
346: IF l_valid_check_interval IS NULL OR l_valid_check_interval < 0 THEN

Line 348: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling DISABLED');

344: b_run_info.run_id := p_run_id;
345: b_run_info.run_stat_id := l_run_stat_id;
346: IF l_valid_check_interval IS NULL OR l_valid_check_interval < 0 THEN
347: l_valid_check_interval := 0;
348: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling DISABLED');
349: ELSE
350: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling Interval: '||l_valid_check_interval||' seconds');
351: END IF;
352: b_run_info.valid_check_interval := l_valid_check_interval;

Line 350: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling Interval: '||l_valid_check_interval||' seconds');

346: IF l_valid_check_interval IS NULL OR l_valid_check_interval < 0 THEN
347: l_valid_check_interval := 0;
348: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling DISABLED');
349: ELSE
350: fnd_oam_debug.log(1, l_ctxt, 'Entity Validation Polling Interval: '||l_valid_check_interval||' seconds');
351: END IF;
352: b_run_info.valid_check_interval := l_valid_check_interval;
353: b_run_info.run_mode := l_run_mode;
354: b_run_info.last_validated := NULL;

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

354: b_run_info.last_validated := NULL;
355: b_run_info.initialized := TRUE;
356:
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
363: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
365: END;
366:
367: -- Public

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

360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
363: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
365: END;
366:
367: -- Public
368: -- Copied from FND_OAM_DS_PSETS_PKG, seems to mimic standard syntax of calls