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

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

216:
217: l_config_instance_id NUMBER;
218: l_found BOOLEAN := FALSE;
219: BEGIN
220: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
221:
222: --perform different lookup depending on the config_instance_type
223: CASE p_config_instance_type
224: WHEN FND_OAM_DSCFG_API_PKG.G_CONFTYPE_CLONING THEN

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

233: x_config_instance_id := l_config_instance_id;
234: l_found := TRUE;
235: END CASE;
236:
237: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
238: RETURN l_found;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

237: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
238: RETURN l_found;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
242: RETURN FALSE;
243: WHEN TOO_MANY_ROWS THEN
244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: RETURN FALSE;

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

240: WHEN NO_DATA_FOUND THEN
241: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
242: RETURN FALSE;
243: WHEN TOO_MANY_ROWS THEN
244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: RETURN FALSE;
246: WHEN OTHERS THEN
247: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
248: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

243: WHEN TOO_MANY_ROWS THEN
244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: RETURN FALSE;
246: WHEN OTHERS THEN
247: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
248: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
249: RETURN FALSE;
250: END;
251:

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

244: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
245: RETURN FALSE;
246: WHEN OTHERS THEN
247: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
248: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
249: RETURN FALSE;
250: END;
251:
252: -- Private

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

290: l_ctxt VARCHAR2(60) := PKG_NAME||'ADD_CONFIG_INSTANCE';
291:
292: l_config_instance_id NUMBER;
293: BEGIN
294: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
295:
296: --first check if we're allowed to make config changes
297: IF NOT FND_OAM_DSCFG_API_PKG.ARE_CONFIG_CHANGES_ALLOWED THEN
298: --raise a program error

Line 299: fnd_oam_debug.log(6, l_ctxt, 'Scrambling Configuration changes currently not allowed.');

295:
296: --first check if we're allowed to make config changes
297: IF NOT FND_OAM_DSCFG_API_PKG.ARE_CONFIG_CHANGES_ALLOWED THEN
298: --raise a program error
299: fnd_oam_debug.log(6, l_ctxt, 'Scrambling Configuration changes currently not allowed.');
300: RAISE PROGRAM_ERROR;
301: END IF;
302:
303: --do the insert

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

339: p_clone_key => p_clone_key,
340: p_policyset_id => p_policyset_id);
341: x_config_instance_id := l_config_instance_id;
342:
343: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
344: EXCEPTION
345: WHEN PROGRAM_ERROR THEN
346: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
347: RAISE;

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

342:
343: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
344: EXCEPTION
345: WHEN PROGRAM_ERROR THEN
346: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
347: RAISE;
348: WHEN OTHERS THEN
349: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
350: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

345: WHEN PROGRAM_ERROR THEN
346: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
347: RAISE;
348: WHEN OTHERS THEN
349: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
350: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
351: RAISE;
352: END;
353:

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

346: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
347: RAISE;
348: WHEN OTHERS THEN
349: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
350: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
351: RAISE;
352: END;
353:
354: -- Public

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

365: l_source_dbname VARCHAR2(30);
366: l_clone_key VARCHAR2(1040);
367: l_policyset_id NUMBER;
368: BEGIN
369: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
370:
371: --first check if we're allowed to make config changes
372: IF NOT FND_OAM_DSCFG_API_PKG.ARE_CONFIG_CHANGES_ALLOWED THEN
373: --raise a program error

Line 374: fnd_oam_debug.log(6, l_ctxt, 'Scrambling Configuration changes currently not allowed.');

370:
371: --first check if we're allowed to make config changes
372: IF NOT FND_OAM_DSCFG_API_PKG.ARE_CONFIG_CHANGES_ALLOWED THEN
373: --raise a program error
374: fnd_oam_debug.log(6, l_ctxt, 'Scrambling Configuration changes currently not allowed.');
375: RAISE PROGRAM_ERROR;
376: END IF;
377:
378: --query out the instance attributes

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

392: p_source_dbname => l_source_dbname,
393: p_clone_key => l_clone_key,
394: p_policyset_id => l_policyset_id);
395:
396: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
397: EXCEPTION
398: WHEN PROGRAM_ERROR THEN
399: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
400: RAISE;

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

395:
396: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
397: EXCEPTION
398: WHEN PROGRAM_ERROR THEN
399: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
400: RAISE;
401: WHEN NO_DATA_FOUND THEN
402: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
403: RAISE;

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

398: WHEN PROGRAM_ERROR THEN
399: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
400: RAISE;
401: WHEN NO_DATA_FOUND THEN
402: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
403: RAISE;
404: WHEN OTHERS THEN
405: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
406: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

401: WHEN NO_DATA_FOUND THEN
402: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
403: RAISE;
404: WHEN OTHERS THEN
405: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
406: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
407: RAISE;
408: END;
409:

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

402: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
403: RAISE;
404: WHEN OTHERS THEN
405: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
406: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
407: RAISE;
408: END;
409:
410: -- Public

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

420:
421: k NUMBER;
422: l_failed BOOLEAN := FALSE;
423: BEGIN
424: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
425:
426: --first nuke the dscram runs
427: IF p_recurse_engine IS NOT NULL AND p_recurse_engine = FND_API.G_TRUE THEN
428: SELECT run_id

Line 433: fnd_oam_debug.log(1, l_ctxt, 'Deleting '||l_run_ids.COUNT||' engine runs...');

429: BULK COLLECT INTO l_run_ids
430: FROM fnd_oam_dscram_runs_b
431: WHERE config_instance_id = p_config_instance_id;
432:
433: fnd_oam_debug.log(1, l_ctxt, 'Deleting '||l_run_ids.COUNT||' engine runs...');
434: k := l_run_ids.FIRST;
435: WHILE k IS NOT NULL LOOP
436: IF NOT FND_OAM_DSCRAM_UTILS_PKG.DELETE_RUN(l_run_ids(k)) THEN
437: l_failed := TRUE;

Line 456: fnd_oam_debug.log(1, l_ctxt, 'Deleting '||l_object_ids.COUNT||' configuration objects...');

452: BULK COLLECT INTO l_object_ids
453: FROM fnd_oam_dscfg_objects
454: WHERE config_instance_id = p_config_instance_id;
455:
456: fnd_oam_debug.log(1, l_ctxt, 'Deleting '||l_object_ids.COUNT||' configuration objects...');
457: k := l_object_ids.FIRST;
458: WHILE k IS NOT NULL LOOP
459: IF NOT FND_OAM_DSCFG_OBJECTS_PKG.DELETE_OBJECT(l_object_ids(k),
460: p_recurse_config) THEN

Line 474: fnd_oam_debug.log(1, l_ctxt, 'Deleting the instance row');

470: END IF;
471: END IF;
472:
473: --now delete the config instance
474: fnd_oam_debug.log(1, l_ctxt, 'Deleting the instance row');
475: DELETE FROM fnd_oam_dscfg_instances
476: WHERE config_instance_id = p_config_instance_id;
477:
478: --success

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

475: DELETE FROM fnd_oam_dscfg_instances
476: WHERE config_instance_id = p_config_instance_id;
477:
478: --success
479: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
480: RETURN TRUE;
481: EXCEPTION
482: WHEN OTHERS THEN
483: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

479: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
480: RETURN TRUE;
481: EXCEPTION
482: WHEN OTHERS THEN
483: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
484: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
485: RETURN FALSE;
486: END;
487:

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

480: RETURN TRUE;
481: EXCEPTION
482: WHEN OTHERS THEN
483: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
484: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
485: RETURN FALSE;
486: END;
487:
488: END FND_OAM_DSCFG_INSTANCES_PKG;