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

Line 35: fnd_oam_debug.log(3, p_ctxt, p_message);

31: p_message IN VARCHAR2)
32: IS
33: l_msg VARCHAR2(4000);
34: BEGIN
35: fnd_oam_debug.log(3, p_ctxt, p_message);
36: l_msg := '['||p_ctxt||']'||p_message;
37: UPDATE fnd_oam_dscfg_objects
38: SET errors_found_flag = FND_API.G_TRUE,
39: message = l_msg

Line 65: fnd_oam_debug.log(1, p_ctxt, l_msg);

61: IS
62: l_msg VARCHAR2(4000);
63: BEGIN
64: l_msg := 'WARNING: '||p_message;
65: fnd_oam_debug.log(1, p_ctxt, l_msg);
66: UPDATE fnd_oam_dscfg_objects
67: SET errors_found_flag = NULL,
68: message = l_msg
69: WHERE object_id = p_object_id;

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

104: WHERE table_owner = p_table_owner
105: AND table_name = p_table_name
106: AND status = 'ENABLED';
107: BEGIN
108: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
109:
110: --get the owners/tables in scope of the engine
111: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
112: x_table_names => l_table_names);

Line 113: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');

109:
110: --get the owners/tables in scope of the engine
111: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
112: x_table_names => l_table_names);
113: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');
114:
115: -- iterate across the tables found
116: k := l_table_owners.FIRST;
117: WHILE k IS NOT NULL LOOP

Line 122: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trig.trigger_owner||'.'||l_trig.trigger_name);

118: -- only process if a corresponding names entry is present
119: IF l_table_names.EXISTS(k) THEN
120: FOR l_trig IN c_table_triggers(l_table_owners(k), l_table_names(k)) LOOP
121: l_seen := l_seen + 1;
122: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trig.trigger_owner||'.'||l_trig.trigger_name);
123:
124: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');
125: --create the disabled trigger object first since the alter trigger call is immediate
126: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_TRIGGER,

Line 124: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');

120: FOR l_trig IN c_table_triggers(l_table_owners(k), l_table_names(k)) LOOP
121: l_seen := l_seen + 1;
122: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trig.trigger_owner||'.'||l_trig.trigger_name);
123:
124: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');
125: --create the disabled trigger object first since the alter trigger call is immediate
126: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_TRIGGER,
127: x_object_id => l_object_id);
128:

Line 144: fnd_oam_debug.log(1, l_ctxt, 'Disabling the actual trigger...');

140: p_property_name => B_PROP_TRIGGER_DISABLED_DATE,
141: p_date_value => SYSDATE,
142: x_property_id => l_property_id);
143:
144: fnd_oam_debug.log(1, l_ctxt, 'Disabling the actual trigger...');
145:
146: -- disable the trigger
147: BEGIN
148: EXECUTE IMMEDIATE 'ALTER TRIGGER '||l_trig.trigger_owner||'.'||l_trig.trigger_name||' DISABLE';

Line 149: fnd_oam_debug.log(1, l_ctxt, 'Trigger disabled.');

145:
146: -- disable the trigger
147: BEGIN
148: EXECUTE IMMEDIATE 'ALTER TRIGGER '||l_trig.trigger_owner||'.'||l_trig.trigger_name||' DISABLE';
149: fnd_oam_debug.log(1, l_ctxt, 'Trigger disabled.');
150: l_disabled := l_disabled + 1;
151: EXCEPTION
152: WHEN OTHERS THEN
153: --don't rollback so we can commit the error along with the object

Line 163: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');

159:
160: -- commit the object/props since the execute succeeded
161: COMMIT;
162:
163: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');
164: END LOOP;
165: END IF;
166: k := l_table_owners.NEXT(k);
167: END LOOP;

Line 168: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' triggers.');

164: END LOOP;
165: END IF;
166: k := l_table_owners.NEXT(k);
167: END LOOP;
168: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' triggers.');
169:
170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN

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

166: k := l_table_owners.NEXT(k);
167: END LOOP;
168: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' triggers.');
169:
170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN
173: ROLLBACK;
174: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN
173: ROLLBACK;
174: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
175: RAISE;
176: WHEN OTHERS THEN
177: ROLLBACK;
178: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

174: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
175: RAISE;
176: WHEN OTHERS THEN
177: ROLLBACK;
178: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
179: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
180: RAISE;
181: END;
182:

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

175: RAISE;
176: WHEN OTHERS THEN
177: ROLLBACK;
178: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
179: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
180: RAISE;
181: END;
182:
183: -- Public

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

195: l_seen NUMBER := 0;
196:
197: k NUMBER;
198: BEGIN
199: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
200:
201: --get all objects representing disabled triggers which don't have errors(flag=T) or have already been
202: --processed(flag=F).
203: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_TRIGGER,

Line 206: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled trigger objects.');

202: --processed(flag=F).
203: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_TRIGGER,
204: p_errors_found_flag => NULL,
205: x_object_ids => l_object_ids);
206: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled trigger objects.');
207:
208: -- iterate across the objects found
209: k := l_object_ids.FIRST;
210: WHILE k IS NOT NULL LOOP

Line 219: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trigger_owner||'.'||l_trigger_name);

215: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
216: p_property_name => B_PROP_TRIGGER_NAME,
217: x_varchar2_value => l_trigger_name);
218: l_seen := l_seen + 1;
219: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trigger_owner||'.'||l_trigger_name);
220:
221:
222: -- re-enable the trigger
223: fnd_oam_debug.log(1, l_ctxt, 'Performing the trigger enable...');

Line 223: fnd_oam_debug.log(1, l_ctxt, 'Performing the trigger enable...');

219: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trigger_owner||'.'||l_trigger_name);
220:
221:
222: -- re-enable the trigger
223: fnd_oam_debug.log(1, l_ctxt, 'Performing the trigger enable...');
224: BEGIN
225: EXECUTE IMMEDIATE 'ALTER TRIGGER '||l_trigger_owner||'.'||l_trigger_name||' ENABLE';
226: fnd_oam_debug.log(1, l_ctxt, 'Trigger re-enabled.');
227: --add property for when the trigger was re-enabled

Line 226: fnd_oam_debug.log(1, l_ctxt, 'Trigger re-enabled.');

222: -- re-enable the trigger
223: fnd_oam_debug.log(1, l_ctxt, 'Performing the trigger enable...');
224: BEGIN
225: EXECUTE IMMEDIATE 'ALTER TRIGGER '||l_trigger_owner||'.'||l_trigger_name||' ENABLE';
226: fnd_oam_debug.log(1, l_ctxt, 'Trigger re-enabled.');
227: --add property for when the trigger was re-enabled
228: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),
229: p_property_name => B_PROP_TRIGGER_RE_ENABLED_DATE,
230: p_date_value => SYSDATE,

Line 243: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');

239: l_object_ids(k),
240: SQLCODE,
241: SQLERRM);
242: END;
243: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');
244:
245: -- save the success or error flag/message
246: COMMIT;
247:

Line 251: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' triggers.');

247:
248: k := l_object_ids.NEXT(k);
249: END LOOP;
250:
251: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' triggers.');
252:
253: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN

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

249: END LOOP;
250:
251: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' triggers.');
252:
253: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN
256: ROLLBACK;
257: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

253: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN
256: ROLLBACK;
257: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
258: RAISE;
259: WHEN TOO_MANY_ROWS THEN
260: ROLLBACK;
261: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

257: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
258: RAISE;
259: WHEN TOO_MANY_ROWS THEN
260: ROLLBACK;
261: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
262: RAISE;
263: WHEN OTHERS THEN
264: ROLLBACK;
265: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

261: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
262: RAISE;
263: WHEN OTHERS THEN
264: ROLLBACK;
265: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
266: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
267: RAISE;
268: END;
269:

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

262: RAISE;
263: WHEN OTHERS THEN
264: ROLLBACK;
265: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
266: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
267: RAISE;
268: END;
269:
270: -- Public

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

287: l_commit BOOLEAN;
288:
289: k NUMBER;
290: BEGIN
291: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
292:
293: --get the owners/tables in scope of the engine
294: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
295: x_table_names => l_table_names);

Line 296: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');

292:
293: --get the owners/tables in scope of the engine
294: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
295: x_table_names => l_table_names);
296: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');
297:
298: -- iterate across the tables found
299: k := l_table_owners.FIRST;
300: WHILE k IS NOT NULL LOOP

Line 304: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owners(k)||'.'||l_table_names(k));

300: WHILE k IS NOT NULL LOOP
301: -- only process if a corresponding names entry is present
302: IF l_table_names.EXISTS(k) THEN
303: l_seen := l_seen + 1;
304: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owners(k)||'.'||l_table_names(k));
305:
306: fnd_oam_debug.log(1, l_ctxt, 'Disabling any primary key constraint(s)...');
307:
308: -- disable the primary key

Line 306: fnd_oam_debug.log(1, l_ctxt, 'Disabling any primary key constraint(s)...');

302: IF l_table_names.EXISTS(k) THEN
303: l_seen := l_seen + 1;
304: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owners(k)||'.'||l_table_names(k));
305:
306: fnd_oam_debug.log(1, l_ctxt, 'Disabling any primary key constraint(s)...');
307:
308: -- disable the primary key
309: l_commit := TRUE;
310: l_object_id := NULL;

Line 313: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) disabled.');

309: l_commit := TRUE;
310: l_object_id := NULL;
311: BEGIN
312: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owners(k)||'.'||l_table_names(k)||' DISABLE PRIMARY KEY CASCADE';
313: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) disabled.');
314:
315: l_disabled := l_disabled + 1;
316: EXCEPTION
317: WHEN NO_PRIMARY_KEY_DEFINED THEN

Line 319: fnd_oam_debug.log(1, l_ctxt, 'No primary keys defined - skipping.');

315: l_disabled := l_disabled + 1;
316: EXCEPTION
317: WHEN NO_PRIMARY_KEY_DEFINED THEN
318: --don't need an entry
319: fnd_oam_debug.log(1, l_ctxt, 'No primary keys defined - skipping.');
320: l_commit := FALSE;
321: WHEN TABLE_DOES_NOT_EXIST THEN
322: --also don't need an entry
323: fnd_oam_debug.log(1, l_ctxt, 'Table does not exist - skipping.');

Line 323: fnd_oam_debug.log(1, l_ctxt, 'Table does not exist - skipping.');

319: fnd_oam_debug.log(1, l_ctxt, 'No primary keys defined - skipping.');
320: l_commit := FALSE;
321: WHEN TABLE_DOES_NOT_EXIST THEN
322: --also don't need an entry
323: fnd_oam_debug.log(1, l_ctxt, 'Table does not exist - skipping.');
324: l_commit := FALSE;
325: WHEN OTHERS THEN
326: --create the object and store the error message
327: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,

Line 339: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');

335: -- if we have things to commit, add the other properties and commit it all
336: IF l_commit THEN
337: --create the object if we haven't already created an errored object
338: IF l_object_id IS NULL THEN
339: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');
340: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
341: x_object_id => l_object_id);
342: END IF;
343:

Line 357: fnd_oam_debug.log(1, l_ctxt, 'Comitting.');

353: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
354: p_property_name => B_PROP_PRIM_KEY_DISABLED_DATE,
355: p_date_value => SYSDATE,
356: x_property_id => l_property_id);
357: fnd_oam_debug.log(1, l_ctxt, 'Comitting.');
358: COMMIT;
359: END IF;
360:
361: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');

Line 361: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');

357: fnd_oam_debug.log(1, l_ctxt, 'Comitting.');
358: COMMIT;
359: END IF;
360:
361: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');
362: END IF;
363: k := l_table_owners.NEXT(k);
364: END LOOP;
365:

Line 366: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' table primary keys.');

362: END IF;
363: k := l_table_owners.NEXT(k);
364: END LOOP;
365:
366: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' table primary keys.');
367:
368: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN

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

364: END LOOP;
365:
366: fnd_oam_debug.log(1, l_ctxt, 'Disabled '||l_disabled||' of '||l_seen||' table primary keys.');
367:
368: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: ROLLBACK;
372: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

368: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: ROLLBACK;
372: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
373: RAISE;
374: WHEN OTHERS THEN
375: ROLLBACK;
376: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

372: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
373: RAISE;
374: WHEN OTHERS THEN
375: ROLLBACK;
376: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
377: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
378: RAISE;
379: END;
380:

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

373: RAISE;
374: WHEN OTHERS THEN
375: ROLLBACK;
376: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
377: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
378: RAISE;
379: END;
380:
381: -- Public

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

392:
393: l_property_id NUMBER;
394: k NUMBER;
395: BEGIN
396: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
397:
398: --get all objects representing disabled primary keys
399: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
400: p_errors_found_flag => NULL,

Line 402: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled primary key objects.');

398: --get all objects representing disabled primary keys
399: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
400: p_errors_found_flag => NULL,
401: x_object_ids => l_object_ids);
402: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled primary key objects.');
403:
404: -- iterate across the objects found
405: k := l_object_ids.FIRST;
406: WHILE k IS NOT NULL LOOP

Line 416: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owner||'.'||l_table_name);

412: p_property_name => B_PROP_PRIM_KEY_TABLE_NAME,
413: x_varchar2_value => l_table_name);
414:
415: l_seen := l_seen + 1;
416: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owner||'.'||l_table_name);
417:
418: -- re-enable the primary key(s)
419: fnd_oam_debug.log(1, l_ctxt, 'Performing the primary key enable...');
420: BEGIN

Line 419: fnd_oam_debug.log(1, l_ctxt, 'Performing the primary key enable...');

415: l_seen := l_seen + 1;
416: fnd_oam_debug.log(1, l_ctxt, 'Processing Table('||l_seen||'): '||l_table_owner||'.'||l_table_name);
417:
418: -- re-enable the primary key(s)
419: fnd_oam_debug.log(1, l_ctxt, 'Performing the primary key enable...');
420: BEGIN
421: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.'||l_table_name||' ENABLE PRIMARY KEY';
422: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) re-enabled.');
423: --add property for when the primary key was re-enabled

Line 422: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) re-enabled.');

418: -- re-enable the primary key(s)
419: fnd_oam_debug.log(1, l_ctxt, 'Performing the primary key enable...');
420: BEGIN
421: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.'||l_table_name||' ENABLE PRIMARY KEY';
422: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) re-enabled.');
423: --add property for when the primary key was re-enabled
424: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),
425: p_property_name => B_PROP_PRIM_KEY_ENABLED_DATE,
426: p_date_value => SYSDATE,

Line 439: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');

435: l_object_ids(k),
436: SQLCODE,
437: SQLERRM);
438: END;
439: fnd_oam_debug.log(1, l_ctxt, 'Processing finished.');
440:
441: COMMIT;
442:
443: k := l_object_ids.NEXT(k);

Line 446: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' table primary keys.');

442:
443: k := l_object_ids.NEXT(k);
444: END LOOP;
445:
446: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' table primary keys.');
447:
448: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN

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

444: END LOOP;
445:
446: fnd_oam_debug.log(1, l_ctxt, 'Re-enabled '||l_enabled||' of '||l_seen||' table primary keys.');
447:
448: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: ROLLBACK;
452: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

448: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: ROLLBACK;
452: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
453: RAISE;
454: WHEN TOO_MANY_ROWS THEN
455: ROLLBACK;
456: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

452: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
453: RAISE;
454: WHEN TOO_MANY_ROWS THEN
455: ROLLBACK;
456: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
457: RAISE;
458: WHEN OTHERS THEN
459: ROLLBACK;
460: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

456: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
457: RAISE;
458: WHEN OTHERS THEN
459: ROLLBACK;
460: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
461: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
462: RAISE;
463: END;
464:

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

457: RAISE;
458: WHEN OTHERS THEN
459: ROLLBACK;
460: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
461: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
462: RAISE;
463: END;
464:
465: