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

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

25: l_ctxt VARCHAR2(60) := PKG_NAME||'ARE_CONFIG_CHANGES_ALLOWED';
26:
27: l_prof_value VARCHAR2(20) := NULL;
28: BEGIN
29: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
30: -- check that data scrambling is enabled first
31: FND_PROFILE.GET(B_DSCRAM_ENABLED_PROFILE_NAME,
32: l_prof_value);
33: IF l_prof_value IS NULL OR UPPER(l_prof_value) <> B_PROFILE_ENABLED_VALUE THEN

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

42: RAISE PROGRAM_ERROR;
43: END IF;
44:
45: -- success
46: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
47: RETURN TRUE;
48: EXCEPTION
49: WHEN PROGRAM_ERROR THEN
50: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

46: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
47: RETURN TRUE;
48: EXCEPTION
49: WHEN PROGRAM_ERROR THEN
50: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
51: RETURN FALSE;
52: WHEN OTHERS THEN
53: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
54: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

49: WHEN PROGRAM_ERROR THEN
50: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
51: RETURN FALSE;
52: WHEN OTHERS THEN
53: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
54: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
55: --don't push the exception
56: RETURN FALSE;
57: END;

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

50: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
51: RETURN FALSE;
52: WHEN OTHERS THEN
53: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
54: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
55: --don't push the exception
56: RETURN FALSE;
57: END;
58:

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

98: IS
99: l_ctxt VARCHAR2(60) := PKG_NAME||'ADD_DML_UPDATE_SEGMENT';
100:
101: BEGIN
102: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
103:
104: -- make sure we have the state we need
105: IF NOT FND_OAM_DSCFG_INSTANCES_PKG.IS_INITIALIZED THEN
106: RAISE NO_DATA_FOUND;

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

127: AND p2.parent_type = G_TYPE_OBJECT
128: AND p2.parent_id = o.object_id
129: AND p2.property_name = G_PROP_TABLE_NAME;
130:
131: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
132: EXCEPTION
133: WHEN NO_DATA_FOUND THEN
134: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
135: RAISE;

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

130:
131: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
132: EXCEPTION
133: WHEN NO_DATA_FOUND THEN
134: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
135: RAISE;
136: WHEN OTHERS THEN
137: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
138: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

133: WHEN NO_DATA_FOUND THEN
134: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
135: RAISE;
136: WHEN OTHERS THEN
137: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
138: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
139: RAISE;
140: END;
141:

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

134: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
135: RAISE;
136: WHEN OTHERS THEN
137: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
138: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
139: RAISE;
140: END;
141:
142: -- Public

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

156: l_prop_id NUMBER;
157:
158: k NUMBER;
159: BEGIN
160: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
161:
162: -- go ahead and create the object, if there's no config instance it'll throw an exception
163: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_DML_UPDATE_SEGMENT,
164: p_source_type => p_source_type,

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

207: p_varchar2_value => p_weight_modifier,
208: x_property_id => l_prop_id);
209: END IF;
210: x_object_id := l_object_id;
211: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN
214: --occurs when create object or prop couldn't find needed state
215: x_object_id := NULL;

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

212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN
214: --occurs when create object or prop couldn't find needed state
215: x_object_id := NULL;
216: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
217: RAISE;
218: WHEN OTHERS THEN
219: x_object_id := NULL;
220: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

216: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
217: RAISE;
218: WHEN OTHERS THEN
219: x_object_id := NULL;
220: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
221: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
222: RAISE;
223: END;
224:

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

217: RAISE;
218: WHEN OTHERS THEN
219: x_object_id := NULL;
220: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
221: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
222: RAISE;
223: END;
224:
225: -- Public

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

236: l_object_id NUMBER;
237: l_prop_id NUMBER;
238:
239: BEGIN
240: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
241:
242: -- go ahead and create the object, if there's no config instance it'll throw an exception
243: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_DML_DELETE_STMT,
244: p_source_type => p_source_type,

Line 247: fnd_oam_debug.log(1, l_ctxt, 'Object Created: '||l_object_id);

243: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_DML_DELETE_STMT,
244: p_source_type => p_source_type,
245: p_source_id => p_source_id,
246: x_object_id => l_object_id);
247: fnd_oam_debug.log(1, l_ctxt, 'Object Created: '||l_object_id);
248:
249: --now create properties for the arguments
250: --table owner
251: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

276: x_property_id => l_prop_id);
277: END IF;
278:
279: x_object_id := l_object_id;
280: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN
283: --occurs when create object or prop couldn't find needed state
284: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

280: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN
283: --occurs when create object or prop couldn't find needed state
284: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
285: RAISE;
286: WHEN OTHERS THEN
287: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
288: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

283: --occurs when create object or prop couldn't find needed state
284: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
285: RAISE;
286: WHEN OTHERS THEN
287: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
288: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
289: RAISE;
290: END;
291:

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

284: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
285: RAISE;
286: WHEN OTHERS THEN
287: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
288: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
289: RAISE;
290: END;
291:
292: -- Public

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

303: l_prop_id NUMBER;
304:
305: k NUMBER;
306: BEGIN
307: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
308:
309: -- go ahead and create the object, if there's no config instance it'll throw an exception
310: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_DML_TRUNCATE_STMT,
311: p_source_type => p_source_type,

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

334: x_property_id => l_prop_id);
335: END IF;
336:
337: x_object_id := l_object_id;
338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
339: EXCEPTION
340: WHEN NO_DATA_FOUND THEN
341: --occurs when create object or prop couldn't find needed state
342: x_object_id := NULL;

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

339: EXCEPTION
340: WHEN NO_DATA_FOUND THEN
341: --occurs when create object or prop couldn't find needed state
342: x_object_id := NULL;
343: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
344: RAISE;
345: WHEN OTHERS THEN
346: x_object_id := NULL;
347: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

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

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

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

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

365: l_prop_id NUMBER;
366:
367: k NUMBER;
368: BEGIN
369: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
370:
371: -- go ahead and create the object, if there's no config instance it'll throw an exception
372: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_PLSQL_TEXT,
373: p_source_type => p_source_type,

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

417: x_property_id => l_prop_id);
418: END IF;
419:
420: x_object_id := l_object_id;
421: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
422: EXCEPTION
423: WHEN NO_DATA_FOUND THEN
424: --occurs when create object or prop couldn't find needed state
425: x_object_id := NULL;

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

422: EXCEPTION
423: WHEN NO_DATA_FOUND THEN
424: --occurs when create object or prop couldn't find needed state
425: x_object_id := NULL;
426: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
427: RAISE;
428: WHEN OTHERS THEN
429: x_object_id := NULL;
430: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

426: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
427: RAISE;
428: WHEN OTHERS THEN
429: x_object_id := NULL;
430: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
431: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
432: RAISE;
433: END;
434:

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

427: RAISE;
428: WHEN OTHERS THEN
429: x_object_id := NULL;
430: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
431: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
432: RAISE;
433: END;
434:
435: -- Public

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

445: l_prop_id NUMBER;
446:
447: k NUMBER;
448: BEGIN
449: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
450:
451: -- go ahead and create the object, if there's no config instance it'll throw an exception
452: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_RUN,
453: x_object_id => l_object_id);

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

486: x_property_id => l_prop_id);
487: END IF;
488:
489: x_object_id := l_object_id;
490: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: --occurs when create object or prop couldn't find needed state
494: x_object_id := NULL;

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

491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: --occurs when create object or prop couldn't find needed state
494: x_object_id := NULL;
495: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
496: RAISE;
497: WHEN OTHERS THEN
498: x_object_id := NULL;
499: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

495: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
496: RAISE;
497: WHEN OTHERS THEN
498: x_object_id := NULL;
499: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
500: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
501: RAISE;
502: END;
503:

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

496: RAISE;
497: WHEN OTHERS THEN
498: x_object_id := NULL;
499: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
500: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
501: RAISE;
502: END;
503:
504: -- Public

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

515: l_prop_id NUMBER;
516:
517: k NUMBER;
518: BEGIN
519: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
520:
521: -- go ahead and create the object, if there's no config instance it'll throw an exception
522: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => G_OTYPE_BUNDLE,
523: x_object_id => l_object_id);

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

564: x_property_id => l_prop_id);
565: END IF;
566:
567: x_object_id := l_object_id;
568: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN
571: --occurs when create object or prop couldn't find needed state
572: x_object_id := NULL;

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

569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN
571: --occurs when create object or prop couldn't find needed state
572: x_object_id := NULL;
573: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
574: RAISE;
575: WHEN OTHERS THEN
576: x_object_id := NULL;
577: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

573: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
574: RAISE;
575: WHEN OTHERS THEN
576: x_object_id := NULL;
577: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
578: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
579: RAISE;
580: END;
581:

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

574: RAISE;
575: WHEN OTHERS THEN
576: x_object_id := NULL;
577: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
578: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
579: RAISE;
580: END;
581:
582: -- Public

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

592: l_prop_id NUMBER;
593:
594: k NUMBER;
595: BEGIN
596: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
597:
598: -- go ahead and create the object, if there's no config instance it'll throw an exception
599: FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type => p_object_type,
600: p_source_type => p_source_type,

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

603: p_message => p_message,
604: x_object_id => l_object_id);
605:
606: x_object_id := l_object_id;
607: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: --occurs when create object or prop couldn't find needed state
611: x_object_id := NULL;

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

608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: --occurs when create object or prop couldn't find needed state
611: x_object_id := NULL;
612: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
613: RAISE;
614: WHEN OTHERS THEN
615: x_object_id := NULL;
616: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

612: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
613: RAISE;
614: WHEN OTHERS THEN
615: x_object_id := NULL;
616: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
617: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
618: RAISE;
619: END;
620:

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

613: RAISE;
614: WHEN OTHERS THEN
615: x_object_id := NULL;
616: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
617: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
618: RAISE;
619: END;
620:
621: -- Public