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

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

61:
62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();
63: k NUMBER;
64: BEGIN
65: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: x_return_msg := '';
68:
69: -- bulk select all valid plsqls with work to do

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

88: END LOOP;
89:
90: --success
91: x_work_queue := l_work_queue;
92: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: EXCEPTION
95: WHEN OTHERS THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

94: EXCEPTION
95: WHEN OTHERS THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: x_return_msg := 'Unit ID ('||p_unit_id||') failed to fetch plsql_ids: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
98: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
99: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
100: END;
101:
102: -- Public

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

95: WHEN OTHERS THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: x_return_msg := 'Unit ID ('||p_unit_id||') failed to fetch plsql_ids: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
98: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
99: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
100: END;
101:
102: -- Public
103: PROCEDURE UPDATE_COMP_PLS_WRITABLE_ARGS(p_plsql_id IN NUMBER,

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

114:
115: l_return_status VARCHAR2(6);
116: l_return_msg VARCHAR2(2048);
117: BEGIN
118: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: x_return_msg := '';
121:
122: --make sure the plsql's in the cache, if not we need to fetch its arg list now to update the writable args

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

131: l_return_msg);
132: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
133: x_return_status := l_return_status;
134: x_return_msg := l_return_msg;
135: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
136: RETURN;
137: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_has_writable_args THEN
138: --to allow these args to be pushed into the context, we also need to make a plsql cache entry so that
139: --destroy_plsql_cache_entries can get the computed value

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

159:
160: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
161: x_return_status := l_return_status;
162: x_return_msg := l_return_msg;
163: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
164: RETURN;
165: END IF;
166: END IF;
167:

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

165: END IF;
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
170: EXCEPTION
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

170: EXCEPTION
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
176: END;
177:
178: -- Private helper to the destroy procedures to do the actual work of destroying a

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

171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
176: END;
177:
178: -- Private helper to the destroy procedures to do the actual work of destroying a
179: -- cache entry, assumes p_plsql_id is in the cache.

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

220: EXCEPTION
221: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
224: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
225: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
226: END;
227:
228: -- Public

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

221: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
224: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
225: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
226: END;
227:
228: -- Public
229: PROCEDURE DESTROY_PLSQL_CACHE_ENTRY(p_plsql_id IN NUMBER,

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

236:
237: l_return_status VARCHAR2(6);
238: l_return_msg VARCHAR2(2048);
239: BEGIN
240: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: x_return_msg := '';
243:
244: --make sure the plsql's in the cache and get it's entry

Line 248: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID ('||p_plsql_id||') not found in cache.');

244: --make sure the plsql's in the cache and get it's entry
245: IF NOT b_plsql_cache.EXISTS(p_plsql_id) THEN
246: --not existing is fine here
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID ('||p_plsql_id||') not found in cache.');
249: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
250: RETURN;
251: END IF;
252:

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

245: IF NOT b_plsql_cache.EXISTS(p_plsql_id) THEN
246: --not existing is fine here
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID ('||p_plsql_id||') not found in cache.');
249: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
250: RETURN;
251: END IF;
252:
253: --call the internal procedure to do the work and return the status of the operation

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

256: p_update_context,
257: x_return_status,
258: x_return_msg);
259:
260: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
261: EXCEPTION
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

261: EXCEPTION
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
265: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
266: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
267: END;
268:
269: -- Public

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

262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
265: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
266: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
267: END;
268:
269: -- Public
270: PROCEDURE DESTROY_PLSQL_CACHE(px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

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

278:
279: l_return_status VARCHAR2(6);
280: l_return_msg VARCHAR2(2048);
281: BEGIN
282: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: x_return_msg := '';
285:
286: --loop through what's left in the cache, destroying each, ignore rolling the args into the context

Line 289: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID: '||k);

285:
286: --loop through what's left in the cache, destroying each, ignore rolling the args into the context
287: k := b_plsql_cache.FIRST;
288: WHILE k IS NOT NULL LOOP
289: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID: '||k);
290: INTERNAL_DESTROY_CACHE_ENTRY(k,
291: px_arg_context,
292: FALSE,
293: l_return_status,

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

307:
308: IF NOT l_found_failure THEN
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310: END IF;
311: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
312: EXCEPTION
313: WHEN OTHERS THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

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

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

313: WHEN OTHERS THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
316: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
317: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
318: END;
319:
320: -- Public
321: PROCEDURE COMPLETE_PLSQL(p_plsql_id IN NUMBER,

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

334:
335: l_return_status VARCHAR2(6);
336: l_return_msg VARCHAR2(2048);
337: BEGIN
338: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_return_msg := '';
341:
342: --make sure the plsql's in the cache

Line 350: fnd_oam_debug.log(1, l_ctxt, 'PLSQL id ('||p_plsql_id||') not in plsql cache. This happens.');

346: -- its possible for a split plsql to execute but not have any ad units. In this case,
347: -- the plsql will not make it into the cache since there's no point in parsing it. Instead
348: -- we just need to complete the record if workers_assigned = 1.
349: l_plsql_in_cache := FALSE;
350: fnd_oam_debug.log(1, l_ctxt, 'PLSQL id ('||p_plsql_id||') not in plsql cache. This happens.');
351: END IF;
352:
353: --perform a blocking select for update on the PLSQL, shouldn't be contention since complete_plsql is called once
354: --and shouldn't already be finished.

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

360:
361: --make sure it's not already finished.
362: IF l_finished_ret_sts IS NOT NULL THEN
363: x_return_msg := 'PLSQL id ('||p_plsql_id||') has finished already set. This should not happen.';
364: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
365: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
366: --don't rollback, parent can do it
367: RETURN;
368: END IF;

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

361: --make sure it's not already finished.
362: IF l_finished_ret_sts IS NOT NULL THEN
363: x_return_msg := 'PLSQL id ('||p_plsql_id||') has finished already set. This should not happen.';
364: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
365: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
366: --don't rollback, parent can do it
367: RETURN;
368: END IF;
369:

Line 382: fnd_oam_debug.log(1, l_ctxt, 'Finished PLSQL with Status: '||l_finished_status||'('||l_finished_ret_sts||')');

378: l_message := p_message;
379: END IF;
380: l_finished_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_finished_ret_sts);
381:
382: fnd_oam_debug.log(1, l_ctxt, 'Finished PLSQL with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
383:
384: --update the plsql
385: UPDATE fnd_oam_dscram_plsqls
386: SET finished_ret_sts = l_finished_ret_sts,

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

398:
399: --exit without committing, leave that to the parent
400:
401: --success
402: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404: EXCEPTION
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

404: EXCEPTION
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
408: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
409: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
410: END;
411:
412: -- Private wrapper on COMPLETE_PLSQL to do it in an autonomous transaction. This is often used when

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

405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
408: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
409: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
410: END;
411:
412: -- Private wrapper on COMPLETE_PLSQL to do it in an autonomous transaction. This is often used when
413: -- a piece of work has failed and we want to update the metadata even though the data will be

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

452:
453: l_return_status VARCHAR2(6);
454: l_return_msg VARCHAR2(2048);
455: BEGIN
456: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: x_return_msg := '';
459:
460: --assume that the check already occured in add_plsql_to_cache so proceed right to the lock

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

468: IF l_final_plsql_text IS NOT NULL THEN
469: x_final_plsql_text := l_final_plsql_text;
470: ROLLBACK;
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
473: RETURN;
474: END IF;
475:
476: --create the SQL statement by wrapping the plsql procedure text in an anonymous block

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

477: l_length := LENGTH(l_plsql_text) + LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX) +
478: LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX) + 1;
479: IF l_length > l_maxlen THEN
480: x_return_msg := 'PLSQL Final text length would be '||l_length||', greater than max: '||l_maxlen;
481: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
482: ROLLBACK;
483: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
484: RETURN;
485: END IF;

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

479: IF l_length > l_maxlen THEN
480: x_return_msg := 'PLSQL Final text length would be '||l_length||', greater than max: '||l_maxlen;
481: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
482: ROLLBACK;
483: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
484: RETURN;
485: END IF;
486: l_final_plsql_text := FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX||l_plsql_text||';'||FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX;
487:

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

497: --commit the autonomous txn to release the lock
498: COMMIT;
499:
500: --success
501: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: x_final_plsql_text := l_final_plsql_text;
504: EXCEPTION
505: WHEN OTHERS THEN

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

504: EXCEPTION
505: WHEN OTHERS THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: x_return_msg := 'PLSQL ID ('||p_plsql_id||'), failed to generate final plsql text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
508: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
509: ROLLBACK;
510: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
511: END;
512:

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

506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: x_return_msg := 'PLSQL ID ('||p_plsql_id||'), failed to generate final plsql text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
508: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
509: ROLLBACK;
510: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
511: END;
512:
513: -- Private helper to EXECUTE_PLSQL* to take a foreign plsql_id and prepare it by parsing it into
514: -- a cursor and fetching the arg list

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

530:
531: l_return_status VARCHAR2(6);
532: l_return_msg VARCHAR2(4000);
533: BEGIN
534: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_return_msg := '';
537:
538: --if the plsql isn't cached, there's a chance that its stats row hasn't been created yet, query and

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

564: l_return_msg);
565: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
566: x_return_status := l_return_status;
567: x_return_msg := l_return_msg;
568: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
569: RETURN;
570: END IF;
571: END IF;
572:

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

579: EXCEPTION
580: WHEN OTHERS THEN
581: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
582: x_return_msg := 'PLSQL_ID ('||p_plsql_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
583: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
584: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
585: RETURN;
586: END;
587:

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

580: WHEN OTHERS THEN
581: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
582: x_return_msg := 'PLSQL_ID ('||p_plsql_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
583: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
584: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
585: RETURN;
586: END;
587:
588: --now lets get the arg list for the plsql

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

595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
597: x_return_status := l_return_status;
598: x_return_msg := l_return_msg;
599: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
600: RETURN;
601: END IF;
602:
603: --SUCCESS, update internal structures

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

614: --store the entry in the cache
615: b_plsql_cache(p_plsql_id) := l_cache_entry;
616:
617: --success
618: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620: EXCEPTION
621: WHEN OTHERS THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

620: EXCEPTION
621: WHEN OTHERS THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_return_msg := 'PLSQL ID ('||p_plsql_id||'), unexpected error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
624: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
625: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
626: END;
627:
628: -- Private, helper to EXECUTE_PLSQL* procedures to do the grunt work. the call to complete the PLSQL

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

621: WHEN OTHERS THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_return_msg := 'PLSQL ID ('||p_plsql_id||'), unexpected error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
624: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
625: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
626: END;
627:
628: -- Private, helper to EXECUTE_PLSQL* procedures to do the grunt work. the call to complete the PLSQL
629: -- will be done by the caller. No commits or rollbacks are done here.

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

641:
642: l_return_status VARCHAR2(6);
643: l_return_msg VARCHAR2(2048);
644: BEGIN
645: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: x_return_msg := '';
648:
649: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID: '||p_plsql_id);

Line 649: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID: '||p_plsql_id);

645: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: x_return_msg := '';
648:
649: fnd_oam_debug.log(1, l_ctxt, 'PLSQL ID: '||p_plsql_id);
650:
651: --set the current plsql id before binding args to allow for access of the plsql_id from a state argument
652: b_current_plsql_id := p_plsql_id;
653:

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

655: IF b_plsql_cache.EXISTS(p_plsql_id) THEN
656: --make sure the cursor isn't configured for splitting
657: IF b_plsql_cache(p_plsql_id).use_splitting <> p_use_splitting THEN
658: x_return_msg := 'PLSQL ID ('||p_plsql_id||'), cached splitting enabled not equal to provided splitting enabled. This should not happen.';
659: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
660: RAISE EXECUTE_FAILED;
661: END IF;
662: ELSE
663: --no cache entry, create one

Line 698: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');

694: --independent of the context in which it's called
695:
696: --skip the execute if we're in test-no-exec mode
697: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN
698: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
699: ELSE
700: --do the execute
701: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
702: BEGIN

Line 701: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');

697: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN
698: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
699: ELSE
700: --do the execute
701: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
702: BEGIN
703: l_rows_processed := DBMS_SQL.EXECUTE(b_plsql_cache(p_plsql_id).cursor_id);
704: EXCEPTION
705: WHEN OTHERS THEN

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

703: l_rows_processed := DBMS_SQL.EXECUTE(b_plsql_cache(p_plsql_id).cursor_id);
704: EXCEPTION
705: WHEN OTHERS THEN
706: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
707: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
708: RAISE EXECUTE_FAILED;
709: END;
710: fnd_oam_debug.log(1, l_ctxt, '...Done.('||l_rows_processed||' rows)');
711: END IF;

Line 710: fnd_oam_debug.log(1, l_ctxt, '...Done.('||l_rows_processed||' rows)');

706: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
707: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
708: RAISE EXECUTE_FAILED;
709: END;
710: fnd_oam_debug.log(1, l_ctxt, '...Done.('||l_rows_processed||' rows)');
711: END IF;
712:
713: -- If the plsql has any output variables, we should get values for them
714: IF b_plsql_cache(p_plsql_id).has_writable_args THEN

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

730:
731: -- Success
732: b_current_plsql_id := NULL;
733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
735: EXCEPTION
736: WHEN EXECUTE_FAILED THEN
737: b_current_plsql_id := NULL;
738: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

734: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
735: EXCEPTION
736: WHEN EXECUTE_FAILED THEN
737: b_current_plsql_id := NULL;
738: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
739: RETURN;
740: WHEN OTHERS THEN
741: b_current_plsql_id := NULL;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

740: WHEN OTHERS THEN
741: b_current_plsql_id := NULL;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
744: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
745: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
746: RETURN;
747: END;
748:

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

741: b_current_plsql_id := NULL;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
744: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
745: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
746: RETURN;
747: END;
748:
749: -- Public

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

758: l_return_msg VARCHAR2(2048);
759: l_return_status2 VARCHAR2(6);
760: l_return_msg2 VARCHAR2(2048);
761: BEGIN
762: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
763:
764: --do the single-threaded execute
765: INTERNAL_EXECUTE_PLSQL(p_plsql_id,
766: px_arg_context,

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

811: x_return_status := l_return_status;
812: x_return_msg := l_return_msg;
813: END IF;
814:
815: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
816: EXCEPTION
817: WHEN OTHERS THEN
818: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

816: EXCEPTION
817: WHEN OTHERS THEN
818: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
821: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
822: END;
823:
824: -- Public

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

817: WHEN OTHERS THEN
818: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
821: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
822: END;
823:
824: -- Public
825: PROCEDURE EXECUTE_PLSQL_ON_RANGE(p_plsql_id IN NUMBER,

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

840: BEGIN
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: x_return_msg := '';
843:
844: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
845: INTERNAL_EXECUTE_PLSQL(p_plsql_id,
846: px_arg_context,
847: TRUE,
848: p_rowid_lbound,

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

862:
863: --return status/msg of execute failure
864: x_return_status := l_return_status;
865: x_return_msg := l_return_msg;
866: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
867: RETURN;
868: END IF;
869:
870: --success

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

868: END IF;
869:
870: --success
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
873: EXCEPTION
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';

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

873: EXCEPTION
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
877: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
878: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
879: END;
880:
881: END FND_OAM_DSCRAM_PLSQLS_PKG;

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

874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
877: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
878: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
879: END;
880:
881: END FND_OAM_DSCRAM_PLSQLS_PKG;