APPS.FA_MASS_REVAL_PKG dependencies on FA_DEBUG_PKG

Line 311: fa_debug_pkg.add(l_calling_fn, 'opening c_assets cursor at', sysdate,

307:
308: if p_loop_count = 1 then -- asset level first
309:
310: if (g_log_level_rec.statement_level) then
311: fa_debug_pkg.add(l_calling_fn, 'opening c_assets cursor at', sysdate,
312: p_log_level_rec => g_log_level_rec);
313: end if;
314:
315: OPEN c_assets;

Line 355: fa_debug_pkg.add(l_calling_fn, 'opening c_assets_cat cursor at', sysdate,

351:
352: else -- category level
353:
354: if (g_log_level_rec.statement_level) then
355: fa_debug_pkg.add(l_calling_fn, 'opening c_assets_cat cursor at', sysdate,
356: p_log_level_rec => g_log_level_rec);
357: end if;
358:
359: OPEN c_assets_cat;

Line 399: fa_debug_pkg.add('test',

395:
396: end if;
397:
398: if (g_log_level_rec.statement_level) then
399: fa_debug_pkg.add('test',
400: 'after fetch asset count is',
401: l_rowid.count,
402: p_log_level_rec => g_log_level_rec);
403: end if;

Line 414: FA_DEBUG_PKG.Initialize;

410:
411: for l_loop_count in 1..l_asset_id.count loop
412:
413: -- clear the debug stack for each asset
414: FA_DEBUG_PKG.Initialize;
415: -- reset the message level to prevent bogus errors
416: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
417:
418: l_mesg_name := null;

Line 534: fa_debug_pkg.add('do_mass_reval',

530: END;
531:
532: -- commit each record
533: FND_CONCURRENT.AF_COMMIT;
534: fa_debug_pkg.add('do_mass_reval',
535: 'asset_id : ', l_asset_id(l_asset_id.count));
536: fa_debug_pkg.add('do_mass_reval',
537: 'count : ',(l_asset_id.count));
538:

Line 536: fa_debug_pkg.add('do_mass_reval',

532: -- commit each record
533: FND_CONCURRENT.AF_COMMIT;
534: fa_debug_pkg.add('do_mass_reval',
535: 'asset_id : ', l_asset_id(l_asset_id.count));
536: fa_debug_pkg.add('do_mass_reval',
537: 'count : ',(l_asset_id.count));
538:
539: end loop; -- main bulk fetch loop
540:

Line 548: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count,

544: set process_status = l_process_status(i)
545: where rowid = l_rowid(i);
546:
547: if (g_log_level_rec.statement_level) then
548: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count,
549: p_log_level_rec => g_log_level_rec);
550: end if;
551:
552:

Line 878: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation',

874: end if;
875: end if;
876:
877: if (g_log_level_rec.statement_level) then
878: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation',
879: p_log_level_rec => g_log_level_rec);
880: end if;
881:
882: x_return_status := 0;

Line 891: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate,

887: end if;
888:
889:
890: if (g_log_level_rec.statement_level) then
891: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate,
892: p_log_level_rec => g_log_level_rec);
893: end if;
894:
895:

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

896: -- NOTE: on first cursor, we do not want to insert category
897: -- as it's used to indicate asset/category later on
898:
899: if (g_log_level_rec.statement_level) then
900: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount,
901: p_log_level_rec => g_log_level_rec);
902: end if;
903:
904: -- asset based

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

954: AND th_rev.mass_transaction_id = p_mass_reval_id);
955:
956:
957: if (g_log_level_rec.statement_level) then
958: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount,
959: p_log_level_rec => g_log_level_rec);
960: end if;
961:
962: