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_MASS_REVAL_PKG dependencies on FA_DEBUG_PKG

Line 285: fa_debug_pkg.add(l_calling_fn, 'at begin', '', p_log_level_rec => g_log_level_rec);

281:
282: g_release := fa_cache_pkg.fazarel_release;
283:
284: if (g_log_level_rec.statement_level) then
285: fa_debug_pkg.add(l_calling_fn, 'at begin', '', p_log_level_rec => g_log_level_rec);
286: end if;
287:
288: G_times_called := G_times_called + 1;
289:

Line 294: fa_debug_pkg.add(l_calling_fn, 'before init', '', p_log_level_rec => g_log_level_rec);

290: x_success_count := 0;
291: x_failure_count := 0;
292:
293: if (g_log_level_rec.statement_level) then
294: fa_debug_pkg.add(l_calling_fn, 'before init', '', p_log_level_rec => g_log_level_rec);
295: end if;
296:
297: if (G_times_called = 1) then
298:

Line 338: fa_debug_pkg.add(l_calling_fn, 'after init', '', p_log_level_rec => g_log_level_rec);

334:
335: end if;
336:
337: if (g_log_level_rec.statement_level) then
338: fa_debug_pkg.add(l_calling_fn, 'after init', '', p_log_level_rec => g_log_level_rec);
339: end if;
340:
341: if p_loop_count = 1 then -- asset level first
342:

Line 344: fa_debug_pkg.add(l_calling_fn, 'opening c_assets cursor at', sysdate, p_log_level_rec => g_log_level_rec);

340:
341: if p_loop_count = 1 then -- asset level first
342:
343: if (g_log_level_rec.statement_level) then
344: fa_debug_pkg.add(l_calling_fn, 'opening c_assets cursor at', sysdate, p_log_level_rec => g_log_level_rec);
345: end if;
346:
347: OPEN c_assets;
348: FETCH c_assets BULK COLLECT INTO

Line 391: fa_debug_pkg.add(l_calling_fn, 'opening c_assets_cat cursor at', sysdate, p_log_level_rec => g_log_level_rec);

387:
388: else -- category level
389:
390: if (g_log_level_rec.statement_level) then
391: fa_debug_pkg.add(l_calling_fn, 'opening c_assets_cat cursor at', sysdate, p_log_level_rec => g_log_level_rec);
392: end if;
393:
394: OPEN c_assets_cat;
395: FETCH c_assets_cat BULK COLLECT INTO

Line 438: fa_debug_pkg.add('test',

434:
435: end if;
436:
437: if (g_log_level_rec.statement_level) then
438: fa_debug_pkg.add('test',
439: 'after fetch asset count is',
440: l_rowid.count, p_log_level_rec => g_log_level_rec);
441: end if;
442:

Line 451: FA_DEBUG_PKG.Initialize;

447:
448: for l_loop_count in 1..l_asset_id.count loop
449:
450: -- clear the debug stack for each asset
451: FA_DEBUG_PKG.Initialize;
452: -- reset the message level to prevent bogus errors
453: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
454:
455: l_mesg_name := null;

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

556: 'FA_MCP_SHARED_SUCCEED',
557: p_mode);
558:
559: if (g_log_level_rec.statement_level) then
560: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
561: end if;
562:
563: EXCEPTION
564: when reval_err then

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

570: write_message(l_asset_number(l_loop_count),
571: l_mesg_name,
572: p_mode);
573: if (g_log_level_rec.statement_level) then
574: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
575: end if;
576:
577: when others then
578: FND_CONCURRENT.AF_ROLLBACK;

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

586:
587: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
588:
589: if (g_log_level_rec.statement_level) then
590: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
591: end if;
592:
593: END;
594:

Line 598: fa_debug_pkg.add(l_calling_fn,

594:
595: -- FND_CONCURRENT.AF_COMMIT each record
596: FND_CONCURRENT.AF_COMMIT;
597:
598: fa_debug_pkg.add(l_calling_fn,
599: 'asset_id : ', l_asset_id(l_asset_id.count));
600: fa_debug_pkg.add(l_calling_fn,
601: 'count : ',(l_asset_id.count));
602:

Line 600: fa_debug_pkg.add(l_calling_fn,

596: FND_CONCURRENT.AF_COMMIT;
597:
598: fa_debug_pkg.add(l_calling_fn,
599: 'asset_id : ', l_asset_id(l_asset_id.count));
600: fa_debug_pkg.add(l_calling_fn,
601: 'count : ',(l_asset_id.count));
602:
603: end loop; -- main bulk fetch loop
604:

Line 606: fa_debug_pkg.add(l_calling_fn, 'updating fa_parallel_workers for status', '', p_log_level_rec => g_log_level_rec);

602:
603: end loop; -- main bulk fetch loop
604:
605: if (g_log_level_rec.statement_level) then
606: fa_debug_pkg.add(l_calling_fn, 'updating fa_parallel_workers for status', '', p_log_level_rec => g_log_level_rec);
607: end if;
608:
609: -- now flags the rows process status accordingly
610: forall i in 1..l_rowid.count

Line 616: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count, p_log_level_rec => g_log_level_rec);

612: set process_status = l_process_status(i)
613: where rowid = l_rowid(i);
614:
615: if (g_log_level_rec.statement_level) then
616: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count, p_log_level_rec => g_log_level_rec);
617: end if;
618:
619: x_return_status := 0;
620:

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

622: write_preview_messages;
623: end if;
624:
625: if (g_log_level_rec.statement_level) then
626: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
627: end if;
628:
629:
630: EXCEPTION

Line 637: fa_debug_pkg.add(l_calling_fn, 'in massrvl_err main', '', p_log_level_rec => g_log_level_rec);

633:
634: when massrvl_err then
635: FND_CONCURRENT.AF_ROLLBACK;
636: if (g_log_level_rec.statement_level) then
637: fa_debug_pkg.add(l_calling_fn, 'in massrvl_err main', '', p_log_level_rec => g_log_level_rec);
638: end if;
639:
640: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
641: if (g_log_level_rec.statement_level) then

Line 642: FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

638: end if;
639:
640: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
641: if (g_log_level_rec.statement_level) then
642: FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
643: end if;
644: x_return_status := 2;
645:
646: if (p_mode = 'PREVIEW') then

Line 654: fa_debug_pkg.add(l_calling_fn, 'in massrvl_err when otherx', '', p_log_level_rec => g_log_level_rec);

650: when others then
651: FND_CONCURRENT.AF_ROLLBACK;
652:
653: if (g_log_level_rec.statement_level) then
654: fa_debug_pkg.add(l_calling_fn, 'in massrvl_err when otherx', '', p_log_level_rec => g_log_level_rec);
655: end if;
656:
657: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
658: if (g_log_level_rec.statement_level) then

Line 659: FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

655: end if;
656:
657: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
658: if (g_log_level_rec.statement_level) then
659: FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
660: end if;
661: x_return_status := 2;
662:
663: if (p_mode = 'PREVIEW') then

Line 959: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation', p_log_level_rec => g_log_level_rec);

955:
956: g_release := fa_cache_pkg.fazarel_release;
957:
958: if (g_log_level_rec.statement_level) then
959: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation', p_log_level_rec => g_log_level_rec);
960: end if;
961:
962: x_return_status := 0;
963:

Line 970: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate, p_log_level_rec => g_log_level_rec);

966: raise massrvl_err;
967: end if;
968:
969: if (g_log_level_rec.statement_level) then
970: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate, p_log_level_rec => g_log_level_rec);
971: end if;
972:
973: -- NOTE: on first cursor, we do not want to insert category
974: -- as it's used to indicate asset/category later on

Line 977: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount);

973: -- NOTE: on first cursor, we do not want to insert category
974: -- as it's used to indicate asset/category later on
975:
976: if (g_log_level_rec.statement_level) then
977: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount);
978: end if;
979:
980: -- R12 conditional handling
981: if (G_release = 11) then

Line 1045: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount);

1041: AND th_rev.transaction_type_code = 'REVALUATION'
1042: AND th_rev.mass_transaction_id = p_mass_reval_id);
1043:
1044: if (g_log_level_rec.statement_level) then
1045: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount);
1046: end if;
1047:
1048:
1049: -- category based