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.FA_GENACCTS_PKG dependencies on FA_DEBUG_PKG

Line 213: FA_DEBUG_PKG.Initialize;

209: end if;
210: end if;
211:
212: -- Initialize server message stack and debug
213: FA_DEBUG_PKG.Initialize;
214:
215: -- get book information
216: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code
217: ,p_log_level_rec => g_log_level_rec) then

Line 293: fa_debug_pkg.add(l_calling_fn, 'looping through: ', 'job list'

289: -- Loop thru job list
290: -- -----------------------------------------
291:
292: if g_log_level_rec.statement_level then
293: fa_debug_pkg.add(l_calling_fn, 'looping through: ', 'job list'
294: ,p_log_level_rec => g_log_level_rec);
295: end if;
296:
297:

Line 313: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt

309: FROM FA_WORKER_JOBS
310: WHERE request_id = p_parent_request_id;
311:
312: if g_log_level_rec.statement_level then
313: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt
314: ,p_log_level_rec => g_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt
316: ,p_log_level_rec => g_log_level_rec);
317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt

Line 315: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt

311:
312: if g_log_level_rec.statement_level then
313: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt
314: ,p_log_level_rec => g_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt
316: ,p_log_level_rec => g_log_level_rec);
317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt
318: ,p_log_level_rec => g_log_level_rec);
319: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt

Line 317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt

313: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt
314: ,p_log_level_rec => g_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt
316: ,p_log_level_rec => g_log_level_rec);
317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt
318: ,p_log_level_rec => g_log_level_rec);
319: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt
320: ,p_log_level_rec => g_log_level_rec);
321: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt

Line 319: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt

315: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt
316: ,p_log_level_rec => g_log_level_rec);
317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt
318: ,p_log_level_rec => g_log_level_rec);
319: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt
320: ,p_log_level_rec => g_log_level_rec);
321: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt
322: ,p_log_level_rec => g_log_level_rec);
323: end if;

Line 321: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt

317: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt
318: ,p_log_level_rec => g_log_level_rec);
319: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt
320: ,p_log_level_rec => g_log_level_rec);
321: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt
322: ,p_log_level_rec => g_log_level_rec);
323: end if;
324:
325: IF (l_failed_cnt > 0) THEN

Line 327: fa_debug_pkg.add(l_calling_fn, 'Another worker has errored out: ', 'Stop processing'

323: end if;
324:
325: IF (l_failed_cnt > 0) THEN
326: if g_log_level_rec.statement_level then
327: fa_debug_pkg.add(l_calling_fn, 'Another worker has errored out: ', 'Stop processing'
328: ,p_log_level_rec => g_log_level_rec);
329: end if;
330: raise error_found; -- probably not
331: ELSIF (l_unassigned_cnt = 0) THEN

Line 333: fa_debug_pkg.add(l_calling_fn, 'No more jobs left', 'Terminating.'

329: end if;
330: raise error_found; -- probably not
331: ELSIF (l_unassigned_cnt = 0) THEN
332: if g_log_level_rec.statement_level then
333: fa_debug_pkg.add(l_calling_fn, 'No more jobs left', 'Terminating.'
334: ,p_log_level_rec => g_log_level_rec);
335: end if;
336: raise done_exc;
337: ELSIF (l_completed_cnt = l_total_cnt) THEN

Line 339: fa_debug_pkg.add(l_calling_fn, 'All jobs completed, no more jobs. ', 'Terminating'

335: end if;
336: raise done_exc;
337: ELSIF (l_completed_cnt = l_total_cnt) THEN
338: if g_log_level_rec.statement_level then
339: fa_debug_pkg.add(l_calling_fn, 'All jobs completed, no more jobs. ', 'Terminating'
340: ,p_log_level_rec => g_log_level_rec);
341: end if;
342: raise done_exc;
343: ELSIF (l_unassigned_cnt > 0) THEN

Line 354: fa_debug_pkg.add(l_calling_fn, 'Taking job from job queue', sql%rowcount

350:
351: l_count := sql%rowcount;
352:
353: if g_log_level_rec.statement_level then
354: fa_debug_pkg.add(l_calling_fn, 'Taking job from job queue', sql%rowcount
355: ,p_log_level_rec => g_log_level_rec);
356: end if;
357:
358: if g_log_level_rec.statement_level then

Line 359: fa_debug_pkg.add(l_calling_fn, 'l_count', l_count

355: ,p_log_level_rec => g_log_level_rec);
356: end if;
357:
358: if g_log_level_rec.statement_level then
359: fa_debug_pkg.add(l_calling_fn, 'l_count', l_count
360: ,p_log_level_rec => g_log_level_rec);
361: end if;
362:
363:

Line 367: fa_debug_pkg.add(l_calling_fn, 'x_worker_jobs', x_worker_jobs

363:
364: x_worker_jobs := l_count;
365:
366: if g_log_level_rec.statement_level then
367: fa_debug_pkg.add(l_calling_fn, 'x_worker_jobs', x_worker_jobs
368: ,p_log_level_rec => g_log_level_rec);
369: end if;
370:
371: COMMIT;

Line 382: fa_debug_pkg.add(l_calling_fn, 'before entering', 'main logic'

378: -- another worker. So, if unassigned
379: -- job no longer exist. Do nothing.
380: -- -----------------------------------
381: if g_log_level_rec.statement_level then
382: fa_debug_pkg.add(l_calling_fn, 'before entering', 'main logic'
383: ,p_log_level_rec => g_log_level_rec);
384:
385: end if;
386: IF (l_count > 0) THEN

Line 389: fa_debug_pkg.add(l_calling_fn, 'entering', 'main logic'

385: end if;
386: IF (l_count > 0) THEN
387:
388: if g_log_level_rec.statement_level then
389: fa_debug_pkg.add(l_calling_fn, 'entering', 'main logic'
390: ,p_log_level_rec => g_log_level_rec);
391: end if;
392:
393: DECLARE

Line 397: fa_debug_pkg.add(l_calling_fn, 'selecting', 'ranges'

393: DECLARE
394: BEGIN
395:
396: if g_log_level_rec.statement_level then
397: fa_debug_pkg.add(l_calling_fn, 'selecting', 'ranges'
398: ,p_log_level_rec => g_log_level_rec);
399: end if;
400:
401: SELECT start_range,

Line 411: fa_debug_pkg.add(l_calling_fn, 'opening cursor', 'dist'

407: AND worker_num = p_request_number
408: AND status = 'IN PROCESS';
409:
410: if g_log_level_rec.statement_level then
411: fa_debug_pkg.add(l_calling_fn, 'opening cursor', 'dist'
412: ,p_log_level_rec => g_log_level_rec);
413: end if;
414:
415: OPEN dist

Line 430: fa_debug_pkg.add(l_calling_fn, 'fecthing cursor', 'dist'

426: p_start_range => l_start_range,
427: p_end_range => l_end_range);
428:
429: if g_log_level_rec.statement_level then
430: fa_debug_pkg.add(l_calling_fn, 'fecthing cursor', 'dist'
431: ,p_log_level_rec => g_log_level_rec);
432: end if;
433:
434: FETCH dist bulk collect

Line 446: fa_debug_pkg.add(l_calling_fn, 'closing cursor', 'dist'

442: l_group_asset_id,
443: l_tracking_method;
444:
445: if g_log_level_rec.statement_level then
446: fa_debug_pkg.add(l_calling_fn, 'closing cursor', 'dist'
447: ,p_log_level_rec => g_log_level_rec);
448: end if;
449:
450: close dist;

Line 462: fa_debug_pkg.add(l_calling_fn, 'processing ', 'cat and asset'

458: if (g_pregen_cat_acct = 'Y' or
459: g_pregen_asset_acct = 'Y') then
460:
461: if g_log_level_rec.statement_level then
462: fa_debug_pkg.add(l_calling_fn, 'processing ', 'cat and asset'
463: ,p_log_level_rec => g_log_level_rec);
464: end if;
465:
466: for i in 1..l_dist_id.count loop

Line 497: fa_debug_pkg.add(l_calling_fn, 'skipping ', 'cat and asset'

493:
494: else
495:
496: if g_log_level_rec.statement_level then
497: fa_debug_pkg.add(l_calling_fn, 'skipping ', 'cat and asset'
498: ,p_log_level_rec => g_log_level_rec);
499: end if;
500:
501: -- BUG# 3280298

Line 530: fa_debug_pkg.add(l_calling_fn, 'looping and calling', 'GEN_CCID'

526: end loop;
527: end if;
528:
529: if g_log_level_rec.statement_level then
530: fa_debug_pkg.add(l_calling_fn, 'looping and calling', 'GEN_CCID'
531: ,p_log_level_rec => g_log_level_rec);
532: end if;
533:
534: for i in 1..l_dist_id.count loop

Line 537: -- FA_DEBUG_PKG.Initialize;

533:
534: for i in 1..l_dist_id.count loop
535:
536: -- clear the debug stack for each line
537: -- FA_DEBUG_PKG.Initialize;
538: -- reset the message level to prevent bogus errors
539: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
540:
541: GEN_CCID(

Line 595: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs'

591:
592: END LOOP; -- bulk update loop
593:
594: if g_log_level_rec.statement_level then
595: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs'
596: ,p_log_level_rec => g_log_level_rec);
597: end if;
598:
599: UPDATE FA_WORKER_JOBS

Line 637: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

633: x_failure_count := G_failure_count;
634:
635: -- Commented for bugfix 4672237
636: -- if (g_log_level_rec.statement_level) then
637: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
638: -- end if;
639:
640: x_return_status := 0;
641:

Line 649: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

645: x_failure_count := G_failure_count;
646:
647: -- Commented for bugfix 4672237
648: -- if (g_log_level_rec.statement_level) then
649: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
650: -- end if;
651:
652: x_return_status := 0;
653:

Line 662: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

658: ,p_log_level_rec => g_log_level_rec);
659:
660: -- Commented for bugfix 4672237
661: -- if (g_log_level_rec.statement_level) then
662: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
663: -- end if;
664: x_return_status := 2;
665:
666: WHEN OTHERS THEN

Line 675: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

671: ,p_log_level_rec => g_log_level_rec);
672:
673: -- Commented for bugfix 4672237
674: -- if (g_log_level_rec.statement_level) then
675: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
676: -- end if;
677: x_return_status := 2;
678:
679: END GEN_ACCTS;

Line 1904: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT

1900: WHERE DH.BOOK_TYPE_CODE = l_dist_source_book )
1901: GROUP BY UNIT_ID;
1902:
1903: if g_log_level_rec.statement_level then
1904: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT
1905: ,p_log_level_rec => g_log_level_rec);
1906: end if;
1907:
1908: commit;

Line 1918: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1914: rollback;
1915:
1916: -- Commented for bugfix 4672237
1917: -- if (g_log_level_rec.statement_level) then
1918: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1919: -- end if;
1920: fa_srvr_msg.add_message(calling_fn => l_calling_fn
1921: ,p_log_level_rec => g_log_level_rec);
1922: x_return_status := 2;

Line 1932: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1928: rollback;
1929:
1930: -- Commented for bugfix 4672237
1931: -- if (g_log_level_rec.statement_level) then
1932: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1933: -- end if;
1934: x_return_status := 2;
1935:
1936: END Load_Workers;