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 232: FA_DEBUG_PKG.Initialize;

228: raise error_found;
229: end if;
230: end if;
231: -- Initialize server message stack and debug
232: FA_DEBUG_PKG.Initialize;
233:
234: -- get book information
235: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
236: raise error_found;

Line 288: fa_debug_pkg.add(l_calling_fn,'Sorp Enabled Flag',h_allow_sorp_flag, p_log_level_rec => g_log_level_rec);

284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666
286:
287: if g_log_level_rec.statement_level then
288: fa_debug_pkg.add(l_calling_fn,'Sorp Enabled Flag',h_allow_sorp_flag, p_log_level_rec => g_log_level_rec);
289: end if;
290:
291: select dp.period_counter
292: into G_FY_first_pc

Line 316: fa_debug_pkg.add(l_calling_fn, 'looping through: ', 'job list', p_log_level_rec => g_log_level_rec);

312: -- Loop thru job list
313: -- -----------------------------------------
314:
315: if g_log_level_rec.statement_level then
316: fa_debug_pkg.add(l_calling_fn, 'looping through: ', 'job list', p_log_level_rec => g_log_level_rec);
317: end if;
318:
319:
320:

Line 335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);

331: FROM FA_WORKER_JOBS
332: WHERE request_id = p_parent_request_id;
333:
334: if g_log_level_rec.statement_level then
335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);
336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);
337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);
338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);
339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);

Line 336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);

332: WHERE request_id = p_parent_request_id;
333:
334: if g_log_level_rec.statement_level then
335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);
336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);
337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);
338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);
339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);
340: end if;

Line 337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);

333:
334: if g_log_level_rec.statement_level then
335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);
336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);
337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);
338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);
339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);
340: end if;
341:

Line 338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);

334: if g_log_level_rec.statement_level then
335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);
336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);
337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);
338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);
339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);
340: end if;
341:
342: IF (l_failed_cnt > 0) THEN

Line 339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);

335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);
336: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);
337: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);
338: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);
339: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);
340: end if;
341:
342: IF (l_failed_cnt > 0) THEN
343: if g_log_level_rec.statement_level then

Line 344: fa_debug_pkg.add(l_calling_fn, 'Another worker has errored out: ', 'Stop processing', p_log_level_rec => g_log_level_rec);

340: end if;
341:
342: IF (l_failed_cnt > 0) THEN
343: if g_log_level_rec.statement_level then
344: fa_debug_pkg.add(l_calling_fn, 'Another worker has errored out: ', 'Stop processing', p_log_level_rec => g_log_level_rec);
345: end if;
346: raise error_found; -- probably not
347: ELSIF (l_unassigned_cnt = 0) THEN
348: if g_log_level_rec.statement_level then

Line 349: fa_debug_pkg.add(l_calling_fn, 'No more jobs left', 'Terminating.', p_log_level_rec => g_log_level_rec);

345: end if;
346: raise error_found; -- probably not
347: ELSIF (l_unassigned_cnt = 0) THEN
348: if g_log_level_rec.statement_level then
349: fa_debug_pkg.add(l_calling_fn, 'No more jobs left', 'Terminating.', p_log_level_rec => g_log_level_rec);
350: end if;
351: raise done_exc;
352: ELSIF (l_completed_cnt = l_total_cnt) THEN
353: if g_log_level_rec.statement_level then

Line 354: fa_debug_pkg.add(l_calling_fn, 'All jobs completed, no more jobs. ', 'Terminating', p_log_level_rec => g_log_level_rec);

350: end if;
351: raise done_exc;
352: ELSIF (l_completed_cnt = l_total_cnt) THEN
353: if g_log_level_rec.statement_level then
354: fa_debug_pkg.add(l_calling_fn, 'All jobs completed, no more jobs. ', 'Terminating', p_log_level_rec => g_log_level_rec);
355: end if;
356: raise done_exc;
357: ELSIF (l_unassigned_cnt > 0) THEN
358: UPDATE FA_WORKER_JOBS

Line 368: fa_debug_pkg.add(l_calling_fn, 'Taking job from job queue', l_count, p_log_level_rec => g_log_level_rec);

364:
365: l_count := sql%rowcount;
366:
367: if g_log_level_rec.statement_level then
368: fa_debug_pkg.add(l_calling_fn, 'Taking job from job queue', l_count, p_log_level_rec => g_log_level_rec);
369: end if;
370: x_worker_jobs := l_count;
371: COMMIT;
372: END IF;

Line 384: fa_debug_pkg.add(l_calling_fn, 'entering', 'main logic', p_log_level_rec => g_log_level_rec);

380: -- -----------------------------------
381: IF (l_count > 0) THEN
382:
383: if g_log_level_rec.statement_level then
384: fa_debug_pkg.add(l_calling_fn, 'entering', 'main logic', p_log_level_rec => g_log_level_rec);
385: end if;
386:
387: DECLARE
388: BEGIN

Line 391: fa_debug_pkg.add(l_calling_fn, 'selecting', 'ranges', p_log_level_rec => g_log_level_rec);

387: DECLARE
388: BEGIN
389:
390: if g_log_level_rec.statement_level then
391: fa_debug_pkg.add(l_calling_fn, 'selecting', 'ranges', p_log_level_rec => g_log_level_rec);
392: end if;
393:
394: SELECT start_range,
395: end_range

Line 404: fa_debug_pkg.add(l_calling_fn, 'opening cursor', 'dist', p_log_level_rec => g_log_level_rec);

400: AND worker_num = p_request_number
401: AND status = 'IN PROCESS';
402:
403: if g_log_level_rec.statement_level then
404: fa_debug_pkg.add(l_calling_fn, 'opening cursor', 'dist', p_log_level_rec => g_log_level_rec);
405: end if;
406:
407: OPEN dist
408: (p_book_type_code => p_book_type_code,

Line 424: fa_debug_pkg.add(l_calling_fn, 'fecthing cursor', 'dist', p_log_level_rec => g_log_level_rec);

420: p_start_range => l_start_range,
421: p_end_range => l_end_range);
422:
423: if g_log_level_rec.statement_level then
424: fa_debug_pkg.add(l_calling_fn, 'fecthing cursor', 'dist', p_log_level_rec => g_log_level_rec);
425: end if;
426:
427: FETCH dist bulk collect
428: into l_dist_id,

Line 439: fa_debug_pkg.add(l_calling_fn, 'closing cursor', 'dist', p_log_level_rec => g_log_level_rec);

435: l_group_asset_id,
436: l_tracking_method;
437:
438: if g_log_level_rec.statement_level then
439: fa_debug_pkg.add(l_calling_fn, 'closing cursor', 'dist', p_log_level_rec => g_log_level_rec);
440: end if;
441:
442: close dist;
443: /*

Line 454: fa_debug_pkg.add(l_calling_fn, 'processing ', 'cat and asset', p_log_level_rec => g_log_level_rec);

450: if (g_pregen_cat_acct = 'Y' or
451: g_pregen_asset_acct = 'Y') then
452:
453: if g_log_level_rec.statement_level then
454: fa_debug_pkg.add(l_calling_fn, 'processing ', 'cat and asset', p_log_level_rec => g_log_level_rec);
455: end if;
456:
457: for i in 1..l_dist_id.count loop
458:

Line 500: fa_debug_pkg.add(l_calling_fn, 'skipping ', 'cat and asset', p_log_level_rec => g_log_level_rec);

496:
497: else
498:
499: if g_log_level_rec.statement_level then
500: fa_debug_pkg.add(l_calling_fn, 'skipping ', 'cat and asset', p_log_level_rec => g_log_level_rec);
501: end if;
502:
503: -- BUG# 3280298
504: -- need to load the table values here with null if we're not

Line 544: fa_debug_pkg.add(l_calling_fn, 'looping and calling', 'GEN_CCID', p_log_level_rec => g_log_level_rec);

540: end loop;
541: end if;
542:
543: if g_log_level_rec.statement_level then
544: fa_debug_pkg.add(l_calling_fn, 'looping and calling', 'GEN_CCID', p_log_level_rec => g_log_level_rec);
545: end if;
546:
547: for i in 1..l_dist_id.count loop
548:

Line 550: -- FA_DEBUG_PKG.Initialize;

546:
547: for i in 1..l_dist_id.count loop
548:
549: -- clear the debug stack for each line
550: -- FA_DEBUG_PKG.Initialize;
551: -- reset the message level to prevent bogus errors
552: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
553:
554: GEN_CCID(

Line 617: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);

613:
614: END LOOP; -- bulk update loop
615:
616: if g_log_level_rec.statement_level then
617: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
618: end if;
619:
620: UPDATE FA_WORKER_JOBS
621: SET status = 'COMPLETED'

Line 656: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

652: x_success_count := G_success_count;
653: x_failure_count := G_failure_count;
654:
655: if (g_log_level_rec.statement_level) then
656: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
657: end if;
658:
659: x_return_status := 0;
660:

Line 667: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

663: x_success_count := G_success_count;
664: x_failure_count := G_failure_count;
665:
666: if (g_log_level_rec.statement_level) then
667: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
668: end if;
669:
670: x_return_status := 0;
671:

Line 677: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

673: x_success_count := G_success_count;
674: x_failure_count := G_failure_count;
675: fa_srvr_msg.add_message(calling_fn => 'fa_genaccts_pkg.gen_accts', p_log_level_rec => g_log_level_rec);
676: if (g_log_level_rec.statement_level) then
677: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
678: end if;
679: x_return_status := 2;
680:
681: WHEN OTHERS THEN

Line 687: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

683: x_failure_count := G_failure_count;
684: FA_SRVR_MSG.ADD_SQL_ERROR(
685: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
686: if (g_log_level_rec.statement_level) then
687: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
688: end if;
689: x_return_status := 2;
690:
691: END GEN_ACCTS;

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

2095: WHERE DH.BOOK_TYPE_CODE = l_dist_source_book )
2096: GROUP BY UNIT_ID;
2097:
2098: if g_log_level_rec.statement_level then
2099: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);
2100: end if;
2101:
2102: commit;
2103:

Line 2110: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

2106: EXCEPTION
2107: WHEN error_found then
2108: rollback;
2109: if (g_log_level_rec.statement_level) then
2110: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
2111: end if;
2112: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2113: x_return_status := 2;
2114:

Line 2120: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

2116: FA_SRVR_MSG.ADD_SQL_ERROR(
2117: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
2118: rollback;
2119: if (g_log_level_rec.statement_level) then
2120: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
2121: end if;
2122: x_return_status := 2;
2123:
2124: END Load_Workers;