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

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

74:
75: l_task_id NUMBER(15);
76: l_status VARCHAR2(30);
77: BEGIN
78: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: x_return_msg := '';
81:
82: --handle closing/opening the cursor as necessary depending on p_requery

Line 100: fnd_oam_debug.log(1, l_ctxt, 'B_TASKS empty');

96: FETCH B_TASKS INTO l_task_id, l_status;
97:
98: -- no rows is an empty
99: IF B_TASKS%NOTFOUND THEN
100: fnd_oam_debug.log(1, l_ctxt, 'B_TASKS empty');
101: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
102: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_EMPTY;
103: CLOSE B_TASKS;
104: RETURN;

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

97:
98: -- no rows is an empty
99: IF B_TASKS%NOTFOUND THEN
100: fnd_oam_debug.log(1, l_ctxt, 'B_TASKS empty');
101: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
102: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_EMPTY;
103: CLOSE B_TASKS;
104: RETURN;
105: END IF;

Line 108: fnd_oam_debug.log(1, l_ctxt, 'Task ID(Status): '||l_task_id||'('||l_status||')');

104: RETURN;
105: END IF;
106:
107: --cache the last task fetched to allow a quick validation later
108: fnd_oam_debug.log(1, l_ctxt, 'Task ID(Status): '||l_task_id||'('||l_status||')');
109: x_task_id := l_task_id;
110: b_last_fetched_task_id := l_task_id;
111:
112: --success

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

109: x_task_id := l_task_id;
110: b_last_fetched_task_id := l_task_id;
111:
112: --success
113: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: EXCEPTION
116: WHEN OTHERS THEN
117: IF B_TASKS%ISOPEN THEN

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

118: CLOSE B_TASKS;
119: END IF;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
122: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
123: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
124: END;
125:
126: -- Private

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

119: END IF;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
122: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
123: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
124: END;
125:
126: -- Private
127: -- Called by execute_task before assigning the worker to sanity check

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

146: SELECT task_status
147: FROM fnd_oam_dscram_tasks
148: WHERE task_id = p_task_id;
149: BEGIN
150: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: x_return_msg := '';
153:
154: -- automatically valid if task_id same as last fetched, if status has changed

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

153:
154: -- automatically valid if task_id same as last fetched, if status has changed
155: -- then assign will catch it.
156: IF p_task_id = b_last_fetched_task_id THEN
157: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: RETURN TRUE;
160: END IF;
161:

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

163: OPEN C1;
164: FETCH C1 INTO l_status;
165: IF C1%NOTFOUND THEN
166: x_return_msg := 'Invalid task_id: ('||p_task_id||')';
167: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
168: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
169: RETURN FALSE;
170: END IF;
171: CLOSE C1;

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

164: FETCH C1 INTO l_status;
165: IF C1%NOTFOUND THEN
166: x_return_msg := 'Invalid task_id: ('||p_task_id||')';
167: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
168: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
169: RETURN FALSE;
170: END IF;
171: CLOSE C1;
172:

Line 179: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

175: -- report the true status of the task to execute to pass on to execute's caller
176: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_START_STS_TO_RET(l_status);
177: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
178: x_return_msg := 'Invalid task status('||l_status||')';
179: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
180: END IF;
181: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
182: RETURN FALSE;
183: END IF;

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

177: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
178: x_return_msg := 'Invalid task status('||l_status||')';
179: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
180: END IF;
181: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
182: RETURN FALSE;
183: END IF;
184:
185: --success

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

182: RETURN FALSE;
183: END IF;
184:
185: --success
186: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: RETURN TRUE;
189: EXCEPTION
190: WHEN OTHERS THEN

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

189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
193: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
194: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
195: RETURN FALSE;
196: END;
197:

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

190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
193: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
194: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
195: RETURN FALSE;
196: END;
197:
198: -- Public

Line 232: fnd_oam_debug.log(1, l_ctxt, '>RE-QUERYING<');

228: -- check if we should do work or if we can presume the cached status
229: IF (p_force_query OR
230: FND_OAM_DSCRAM_UTILS_PKG.VALIDATION_DUE(b_task_info.last_validated)) THEN
231:
232: fnd_oam_debug.log(1, l_ctxt, '>RE-QUERYING<');
233:
234: -- re-init the cached fields to allow easy exit
235: b_task_info.last_validation_ret_sts := x_return_status;
236: b_task_info.last_validated := SYSDATE;

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

240: FETCH C1 INTO l_status;
241: IF C1%NOTFOUND THEN
242: --shouldn't happen since we're using the cache
243: x_return_msg := 'Invalid cached task_id: '||b_task_info.task_id;
244: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
245: RETURN FALSE;
246: END IF;
247: CLOSE C1;
248:

Line 255: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

251: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_CONT_STS_TO_RET(l_status);
252: b_task_info.last_validation_ret_sts := x_return_status;
253: IF x_return_status <> FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_PROCESSED THEN
254: x_return_msg := 'Invalid task status('||l_status||')';
255: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
256: END IF;
257: RETURN FALSE;
258: END IF;
259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 273: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

269: l_return_msg) THEN
270: -- the run/bundle has an invalid status, tell the execute to stop the task
271: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_STOPPED;
272: x_return_msg := '[Continued Validation Parent(s) Failed]:(Status('||l_return_status||'), Msg('||l_return_msg||'))';
273: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
274: RETURN FALSE;
275: END IF;
276: END IF;
277:

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

281: RETURN (x_return_status = FND_API.G_RET_STS_SUCCESS);
282: EXCEPTION
283: WHEN OTHERS THEN
284: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
285: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: b_task_info.last_validation_ret_sts := x_return_status;
288: b_task_info.last_validated := SYSDATE;
289: RETURN FALSE;

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

310: l_status VARCHAR2(30) := NULL;
311: l_workers_assigned NUMBER(15);
312:
313: BEGIN
314: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: x_return_msg := '';
317:
318: -- Do a locking select without a pre-select since we always have to update the

Line 327: fnd_oam_debug.log(1, l_ctxt, 'Task Status(Workers): '||l_status||'('||l_workers_assigned||')');

323: FROM fnd_oam_dscram_tasks
324: WHERE task_id = p_task_id
325: FOR UPDATE;
326:
327: fnd_oam_debug.log(1, l_ctxt, 'Task Status(Workers): '||l_status||'('||l_workers_assigned||')');
328:
329: -- make sure the status is runnable after the lock
330: IF NOT FND_OAM_DSCRAM_UTILS_PKG.STATUS_IS_EXECUTABLE(l_status) THEN
331: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_START_STS_TO_RET(l_status);

Line 334: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

330: IF NOT FND_OAM_DSCRAM_UTILS_PKG.STATUS_IS_EXECUTABLE(l_status) THEN
331: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_VALIDATE_START_STS_TO_RET(l_status);
332: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
333: x_return_msg := 'Invalid task in assign, status('||l_status||')';
334: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
335: END IF;
336: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
337: ROLLBACK;
338: RETURN;

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

332: IF FND_OAM_DSCRAM_UTILS_PKG.RET_STS_IS_ERROR(x_return_status) THEN
333: x_return_msg := 'Invalid task in assign, status('||l_status||')';
334: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
335: END IF;
336: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
337: ROLLBACK;
338: RETURN;
339: END IF;
340:

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

353: WHERE task_id = p_task_id;
354: ELSE
355: --the bundle isn't processing but the worker count's nonzero, this shouldn't happen
356: x_return_msg := 'Task Status ('||l_status||') is not in-progress but the number of workers assigned('||l_workers_assigned||') is nonzero.';
357: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
358: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
359: ROLLBACK;
360: RETURN;
361: END IF;

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

354: ELSE
355: --the bundle isn't processing but the worker count's nonzero, this shouldn't happen
356: x_return_msg := 'Task Status ('||l_status||') is not in-progress but the number of workers assigned('||l_workers_assigned||') is nonzero.';
357: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
358: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
359: ROLLBACK;
360: RETURN;
361: END IF;
362: END IF;

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

380: -- invalidate the last_fetched vars since we've changed things
381: b_last_fetched_task_id := NULL;
382:
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
385: EXCEPTION
386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

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

385: EXCEPTION
386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
389: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
390: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
391: ROLLBACK;
392: END;
393:

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

386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
389: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
390: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
391: ROLLBACK;
392: END;
393:
394: -- Private: Autonomous Txn

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

409:
410: l_status VARCHAR2(30);
411: l_workers_assigned NUMBER(15);
412: BEGIN
413: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
414:
415: -- always lock the task since we have to decrement the worker count
416: SELECT task_status, workers_assigned
417: INTO l_status, l_workers_assigned

Line 429: fnd_oam_debug.log(1, l_ctxt, 'Translated status "'||p_proposed_status||'" into "'||l_final_status||'"');

425: p_proposed_status,
426: p_proposed_ret_sts,
427: l_final_status,
428: l_final_ret_sts);
429: fnd_oam_debug.log(1, l_ctxt, 'Translated status "'||p_proposed_status||'" into "'||l_final_status||'"');
430: fnd_oam_debug.log(1, l_ctxt, 'Translated Execute Ret Sts "'||p_proposed_ret_sts||'" into "'||l_final_ret_sts||'"');
431:
432: --if we discovered that we're full, possibly temporarily, just decrement the worker count and leave as long as we're not the last worker
433: IF l_final_ret_sts = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_FULL AND l_workers_assigned > 1 THEN

Line 430: fnd_oam_debug.log(1, l_ctxt, 'Translated Execute Ret Sts "'||p_proposed_ret_sts||'" into "'||l_final_ret_sts||'"');

426: p_proposed_ret_sts,
427: l_final_status,
428: l_final_ret_sts);
429: fnd_oam_debug.log(1, l_ctxt, 'Translated status "'||p_proposed_status||'" into "'||l_final_status||'"');
430: fnd_oam_debug.log(1, l_ctxt, 'Translated Execute Ret Sts "'||p_proposed_ret_sts||'" into "'||l_final_ret_sts||'"');
431:
432: --if we discovered that we're full, possibly temporarily, just decrement the worker count and leave as long as we're not the last worker
433: IF l_final_ret_sts = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_FULL AND l_workers_assigned > 1 THEN
434: UPDATE fnd_oam_dscram_tasks

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

466:
467: --after completing the task, kill the state
468: b_task_info.initialized := FALSE;
469:
470: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
471: EXCEPTION
472: WHEN OTHERS THEN
473: x_final_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN;
474: x_final_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;

Line 475: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

471: EXCEPTION
472: WHEN OTHERS THEN
473: x_final_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN;
474: x_final_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;
475: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
476: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
477: ROLLBACK;
478: END;
479:

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

472: WHEN OTHERS THEN
473: x_final_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN;
474: x_final_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;
475: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
476: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
477: ROLLBACK;
478: END;
479:
480: -- Public

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

490: l_return_status VARCHAR2(6);
491: l_return_msg VARCHAR2(2048);
492: l_temp VARCHAR2(30);
493: BEGIN
494: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_return_msg := '';
497:
498: -- do an initial validation of the task

Line 504: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

500: l_return_status,
501: l_return_msg) THEN
502: x_return_status := l_return_status;
503: x_return_msg := '[Task Validation Failed]:('||l_return_msg||')';
504: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
505: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
506: RETURN;
507: END IF;
508:

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

501: l_return_msg) THEN
502: x_return_status := l_return_status;
503: x_return_msg := '[Task Validation Failed]:('||l_return_msg||')';
504: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
505: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
506: RETURN;
507: END IF;
508:
509: -- attempt to assign this invocation as a worker for the bundle

Line 516: fnd_oam_debug.log(1, l_ctxt, x_return_msg);

512: l_return_msg);
513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: x_return_status := l_return_status;
515: x_return_msg := '[Task Worker Assignment Failed]:('||l_return_msg||')';
516: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
517: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
518: RETURN;
519: END IF;
520:

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

513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: x_return_status := l_return_status;
515: x_return_msg := '[Task Worker Assignment Failed]:('||l_return_msg||')';
516: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
517: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
518: RETURN;
519: END IF;
520:
521: --before proceeding after the assign, check our parent objects to make sure

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

530: FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_STOPPED,
531: l_completed_status,
532: x_return_status);
533: x_return_msg := '[Post-Assignment Parent Validation Failed]:('||l_return_msg||')';
534: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
535: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
536: RETURN;
537: END IF;
538:

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

531: l_completed_status,
532: x_return_status);
533: x_return_msg := '[Post-Assignment Parent Validation Failed]:('||l_return_msg||')';
534: fnd_oam_debug.log(1, l_ctxt, x_return_msg);
535: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
536: RETURN;
537: END IF;
538:
539: --at this point, we're assigned so we need to issue a complete before returning.

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

558: EXIT outer;
559: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
560: l_completed_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN;
561: x_return_msg := '[Fetch Next Unit Failed]:('||l_return_msg||')';
562: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
563: EXIT outer;
564: END IF;
565:
566: --execute the unit

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

584: EXIT outer;
585: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
586: l_completed_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN;
587: x_return_msg := '[Inner Fetch Next Unit Failed]:('||l_return_msg||')';
588: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
589: EXIT outer;
590: END IF;
591:
592: -- try to execute this unit

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

604: -- unexpected execution failure, since units have phases, there may be dependencies between
605: -- units which will break if we continue with the task. To handle this, we'll stop the task and
606: -- allow the user to choose whether to ignore the failed unit or retry them when restarting the task.
607: x_return_msg := '[Inner Execute Unit Failed]:(Status('||l_return_status||'), Msg('||l_return_msg||')). Stopping task.';
608: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
609: l_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_STOPPED;
610: l_completed_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_STOPPED;
611: EXIT outer;
612: END IF;

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

615: l_return_status <> FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_PROCESSED AND
616: l_return_status <> FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_SKIPPED THEN
617: -- take the same actions as when the inner execute fails
618: x_return_msg := '[Outer Execute Unit Failed]:(Status('||l_return_status||'), Msg('||l_return_msg||')). Stopping task.';
619: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
620: l_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_STOPPED;
621: l_completed_status := FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_STOPPED;
622: EXIT outer;
623: END IF;

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

632: --complete the task based on what validate found
633: l_completed_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_return_status);
634: IF FND_OAM_DSCRAM_UTILS_PKG.STATUS_IS_ERROR(l_return_status) THEN
635: x_return_msg := '[End-of-Loop Validate Failed]:('||l_return_msg||')';
636: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
637: END IF;
638: EXIT outer;
639: END IF;
640:

Line 644: fnd_oam_debug.log(1, l_ctxt, 'Finished Task with status: '||l_completed_status||'('||l_return_status||')');

640:
641: END LOOP outer;
642:
643: --finished processing the bundle
644: fnd_oam_debug.log(1, l_ctxt, 'Finished Task with status: '||l_completed_status||'('||l_return_status||')');
645: COMPLETE_TASK(l_completed_status,
646: l_return_status,
647: l_temp,
648: x_return_status);

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

646: l_return_status,
647: l_temp,
648: x_return_status);
649:
650: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
651: EXCEPTION
652: WHEN OTHERS THEN
653: COMPLETE_TASK(FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_ERROR_UNKNOWN,
654: FND_API.G_RET_STS_UNEXP_ERROR,

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

654: FND_API.G_RET_STS_UNEXP_ERROR,
655: l_completed_status,
656: x_return_status);
657: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
658: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
659: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
660: END;
661:
662: END FND_OAM_DSCRAM_TASKS_PKG;

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

655: l_completed_status,
656: x_return_status);
657: x_return_msg := 'Unhandled Exception: [Code('||SQLCODE||'), Message("'||SQLERRM||'")]';
658: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
659: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
660: END;
661:
662: END FND_OAM_DSCRAM_TASKS_PKG;