APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_OAM_DEBUG

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

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

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

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

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

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

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

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

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

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

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

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

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

159: l_return_msg);
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 170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

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

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

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

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

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

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

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

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

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

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

Line 249: fnd_oam_debug.log(1, l_ctxt, 'DML ID ('||p_dml_id||') not found in cache.');

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

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

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

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

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

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

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

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

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

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

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

Line 290: fnd_oam_debug.log(1, l_ctxt, 'DML ID: '||k);

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

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

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

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

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

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

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

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

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

Line 353: fnd_oam_debug.log(1, l_ctxt, 'DML id ('||p_dml_id||') not in dml cache. This happens.');

349: -- its possible for a split dml to execute but not have any ad units. In this case,
350: -- the dml will not make it into the cache since there's no point in parsing it. Instead
351: -- we just need to complete the record if workers_assigned = 1.
352: l_dml_in_cache := FALSE;
353: fnd_oam_debug.log(1, l_ctxt, 'DML id ('||p_dml_id||') not in dml cache. This happens.');
354: END IF;
355:
356: --perform a blocking select for update on the DML, allows sequencing of rows_processed updates
357: SELECT finished_ret_sts

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

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

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

363: --make sure it's not already finished, only the last complete_dml should do this
364: IF l_finished_ret_sts IS NOT NULL THEN
365: x_return_msg := 'DML id ('||p_dml_id||') has finished already set. This should not happen.';
366: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
367: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
368: --don't rollback, parent can do it
369: RETURN;
370: END IF;
371:

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

381: l_message := p_message;
382: END IF;
383: l_finished_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_finished_ret_sts);
384:
385: fnd_oam_debug.log(1, l_ctxt, 'Finished DML with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
386:
387: --update the dml
388: UPDATE fnd_oam_dscram_dmls
389: SET finished_ret_sts = l_finished_ret_sts

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

409:
410: --exit without committing, leave that to the parent
411:
412: --success
413: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: EXCEPTION
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

415: EXCEPTION
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
419: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
420: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
421: END;
422:
423: -- Private wrapper on COMPLETE_DML to do it in an autonomous transaction. This is often used when

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

416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
419: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
420: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
421: END;
422:
423: -- Private wrapper on COMPLETE_DML to do it in an autonomous transaction. This is often used when
424: -- a piece of work has failed and we want to update the metadata even though the data will be

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

433: PRAGMA AUTONOMOUS_TRANSACTION;
434:
435: l_ctxt VARCHAR2(60) := PKG_NAME||'COMPLETE_DML_AUTONOMOUSLY';
436: BEGIN
437: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
438: COMPLETE_DML(p_dml_id,
439: p_finished_ret_sts,
440: p_message,
441: p_workers_assigned,

Line 446: fnd_oam_debug.log(1, l_ctxt, 'Committed completion of DML ('||p_dml_id||')');

442: x_return_status,
443: x_return_msg);
444: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
445: COMMIT;
446: fnd_oam_debug.log(1, l_ctxt, 'Committed completion of DML ('||p_dml_id||')');
447: ELSE
448: fnd_oam_debug.log(3, l_ctxt, 'Failed to complete DML ('||p_dml_id||') autonomously: status('||x_return_status||'), message('||x_return_msg||')');
449: ROLLBACK;
450: END IF;

Line 448: fnd_oam_debug.log(3, l_ctxt, 'Failed to complete DML ('||p_dml_id||') autonomously: status('||x_return_status||'), message('||x_return_msg||')');

444: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
445: COMMIT;
446: fnd_oam_debug.log(1, l_ctxt, 'Committed completion of DML ('||p_dml_id||')');
447: ELSE
448: fnd_oam_debug.log(3, l_ctxt, 'Failed to complete DML ('||p_dml_id||') autonomously: status('||x_return_status||'), message('||x_return_msg||')');
449: ROLLBACK;
450: END IF;
451: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
452: END;

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

447: ELSE
448: fnd_oam_debug.log(3, l_ctxt, 'Failed to complete DML ('||p_dml_id||') autonomously: status('||x_return_status||'), message('||x_return_msg||')');
449: ROLLBACK;
450: END IF;
451: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
452: END;
453:
454: -- Private: helper to ADD_DML_TO_CACHE to prepare the final statement for a DML. This is
455: -- autonomous to keep from commiting data on the transaction.

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

473:
474: l_return_status VARCHAR2(6);
475: l_return_msg VARCHAR2(2048);
476: BEGIN
477: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: x_return_msg := '';
480:
481: --assume that the check already occured in add_dml_to_cache so proceed right to the lock

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

489: IF l_final_dml_stmt IS NOT NULL THEN
490: x_final_dml_stmt := l_final_dml_stmt;
491: ROLLBACK;
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
494: RETURN;
495: END IF;
496:
497: --prepare the final stmt from the stmt, where clause and possible the rowid restrict where clause

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

506: x_return_status := l_return_status;
507: x_return_msg := l_return_msg;
508: --commit the stats entry, make_final just does string manipulation
509: COMMIT;
510: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
511: RETURN;
512: END IF;
513:
514: --store this string as the final stmt

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

523: --commit the autonomous txn to release the lock
524: COMMIT;
525:
526: --success
527: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
528: x_return_status := FND_API.G_RET_STS_SUCCESS;
529: x_final_dml_stmt := l_final_dml_stmt;
530: EXCEPTION
531: WHEN OTHERS THEN

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

530: EXCEPTION
531: WHEN OTHERS THEN
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_return_msg := 'DML ID ('||p_dml_id||'), failed to generate final dml stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
534: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
535: ROLLBACK;
536: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
537: END;
538:

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

532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_return_msg := 'DML ID ('||p_dml_id||'), failed to generate final dml stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
534: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
535: ROLLBACK;
536: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
537: END;
538:
539: -- Private helper to EXECUTE_DML* to take a foreign dml_id and prepare it by generating the
540: -- final dml statement if necessary, parsing it into a cursor and fetching the arg list

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

556: l_return_status VARCHAR2(6);
557: l_return_msg VARCHAR2(2048);
558: l_temp VARCHAR2(30);
559: BEGIN
560: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: x_return_msg := '';
563:
564: --if the dml isn't cached, there's a chance that its stats row hasn't been created yet, query and

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

591: l_return_msg);
592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
593: x_return_status := l_return_status;
594: x_return_msg := l_return_msg;
595: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
596: RETURN;
597: END IF;
598: END IF;
599:

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

606: EXCEPTION
607: WHEN OTHERS THEN
608: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
609: x_return_msg := 'DML_ID ('||p_dml_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
610: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
611: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
612: RETURN;
613: END;
614:

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

607: WHEN OTHERS THEN
608: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
609: x_return_msg := 'DML_ID ('||p_dml_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
610: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
611: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
612: RETURN;
613: END;
614:
615: --now lets get the arg list for the dml

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

622: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
624: x_return_status := l_return_status;
625: x_return_msg := l_return_msg;
626: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
627: RETURN;
628: END IF;
629:
630: --SUCCESS, update internal structures

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

642: --store the entry in the cache
643: b_dml_cache(p_dml_id) := l_cache_entry;
644:
645: --success
646: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION
649: WHEN OTHERS THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

648: EXCEPTION
649: WHEN OTHERS THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_return_msg := 'DML ID ('||p_dml_id||'), failed to add to cache: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
652: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
653: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
654: END;
655:
656: -- Private, helper to EXECUTE_DML* procedures to do the grunt work. the call to complete the DML

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

649: WHEN OTHERS THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_return_msg := 'DML ID ('||p_dml_id||'), failed to add to cache: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
652: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
653: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
654: END;
655:
656: -- Private, helper to EXECUTE_DML* procedures to do the grunt work. the call to complete the DML
657: -- will be done by the caller. No commits or rollbacks are done here.

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

670:
671: l_return_status VARCHAR2(6);
672: l_return_msg VARCHAR2(2048);
673: BEGIN
674: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: x_return_msg := '';
677:
678: fnd_oam_debug.log(1, l_ctxt, 'DML ID: '||p_dml_id);

Line 678: fnd_oam_debug.log(1, l_ctxt, 'DML ID: '||p_dml_id);

674: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: x_return_msg := '';
677:
678: fnd_oam_debug.log(1, l_ctxt, 'DML ID: '||p_dml_id);
679:
680: --set the current dml id before binding args to allow for access of the dml_id from a state argument
681: b_current_dml_id := p_dml_id;
682:

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

684: IF b_dml_cache.EXISTS(p_dml_id) THEN
685: --make sure the cursor isn't configured for splitting
686: IF b_dml_cache(p_dml_id).use_splitting <> p_use_splitting THEN
687: x_return_msg := 'DML ID ('||p_dml_id||'), cached splitting enabled not equal to provided splitting enabled. This should not happen.';
688: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
689: RAISE EXECUTE_FAILED;
690: END IF;
691: ELSE
692: --no cache entry, create one

Line 724: fnd_oam_debug.log(1, l_ctxt, 'Binding lower('||p_rowid_lbound||') and upper('||p_rowid_ubound||') rowids');

720: END IF;
721:
722: --cache entry should be valid now, do additional bindings if needed
723: IF p_use_splitting THEN
724: fnd_oam_debug.log(1, l_ctxt, 'Binding lower('||p_rowid_lbound||') and upper('||p_rowid_ubound||') rowids');
725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
727: p_rowid_lbound);
728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,

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

731: END IF;
732:
733: --skip the execute if we're in test-no-exec mode
734: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN
735: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
736: l_rows_processed := 0;
737: ELSE
738: --do the execute
739: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');

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

735: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
736: l_rows_processed := 0;
737: ELSE
738: --do the execute
739: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
740: BEGIN
741: l_rows_processed := DBMS_SQL.EXECUTE(b_dml_cache(p_dml_id).cursor_id);
742: EXCEPTION
743: WHEN OTHERS THEN

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

741: l_rows_processed := DBMS_SQL.EXECUTE(b_dml_cache(p_dml_id).cursor_id);
742: EXCEPTION
743: WHEN OTHERS THEN
744: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
745: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
746: RAISE EXECUTE_FAILED;
747: END;
748: fnd_oam_debug.log(1, l_ctxt, '...Done.('||l_rows_processed||' rows)');
749: END IF;

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

744: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
745: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
746: RAISE EXECUTE_FAILED;
747: END;
748: fnd_oam_debug.log(1, l_ctxt, '...Done.('||l_rows_processed||' rows)');
749: END IF;
750:
751: -- If the dml has any output variables, we should get values for them now if we can
752: IF b_dml_cache(p_dml_id).has_writable_args THEN

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

769: -- Success
770: b_current_dml_id := NULL;
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: x_rows_processed := l_rows_processed;
773: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
774: EXCEPTION
775: WHEN EXECUTE_FAILED THEN
776: b_current_dml_id := NULL;
777: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

773: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
774: EXCEPTION
775: WHEN EXECUTE_FAILED THEN
776: b_current_dml_id := NULL;
777: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
778: RETURN;
779: WHEN OTHERS THEN
780: b_current_dml_id := NULL;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

779: WHEN OTHERS THEN
780: b_current_dml_id := NULL;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
783: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
784: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
785: RETURN;
786: END;
787:

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

780: b_current_dml_id := NULL;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
783: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
784: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
785: RETURN;
786: END;
787:
788: -- Public

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

798: l_return_msg VARCHAR2(2048);
799: l_return_status2 VARCHAR2(6);
800: l_return_msg2 VARCHAR2(2048);
801: BEGIN
802: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
803:
804: --do the single-threaded execute
805: INTERNAL_EXECUTE_DML(p_dml_id,
806: px_arg_context,

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

857: x_return_status := l_return_status;
858: x_return_msg := l_return_msg;
859: END IF;
860:
861: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
862: EXCEPTION
863: WHEN OTHERS THEN
864: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

862: EXCEPTION
863: WHEN OTHERS THEN
864: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
867: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
868: END;
869:
870: -- Public

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

863: WHEN OTHERS THEN
864: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
867: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
868: END;
869:
870: -- Public
871: PROCEDURE EXECUTE_DML_ON_RANGE(p_dml_id IN NUMBER,

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

885: BEGIN
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: x_return_msg := '';
888:
889: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
890: INTERNAL_EXECUTE_DML(p_dml_id,
891: px_arg_context,
892: TRUE,
893: p_rowid_lbound,

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

910: --return status/msg of execute failure
911: x_rows_processed := 0;
912: x_return_status := l_return_status;
913: x_return_msg := l_return_msg;
914: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
915: RETURN;
916: END IF;
917:
918: --success

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

917:
918: --success
919: x_rows_processed := l_rows_processed;
920: x_return_status := FND_API.G_RET_STS_SUCCESS;
921: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
922: EXCEPTION
923: WHEN OTHERS THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';

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

922: EXCEPTION
923: WHEN OTHERS THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
926: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
927: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
928: END;
929:
930: END FND_OAM_DSCRAM_DMLS_PKG;

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

923: WHEN OTHERS THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
926: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
927: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
928: END;
929:
930: END FND_OAM_DSCRAM_DMLS_PKG;