DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_DEBUG_PKG

Line 181: fa_debug_pkg.add(l_calling_fn, 'opening c_trx_parent cursor at', sysdate,

177:
178: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
179:
180: if (g_log_level_rec.statement_level) then
181: fa_debug_pkg.add(l_calling_fn, 'opening c_trx_parent cursor at', sysdate,
182: p_log_level_rec => g_log_level_rec);
183: end if;
184:
185: open c_trx(p_parent_request_id => p_parent_request_id,

Line 203: fa_debug_pkg.add('test',

199:
200: close c_trx;
201:
202: if (g_log_level_rec.statement_level) then
203: fa_debug_pkg.add('test',
204: 'after fetch thid count is',
205: l_corp_thid.count,
206: p_log_level_rec => g_log_level_rec);
207: end if;

Line 217: FA_DEBUG_PKG.Initialize;

213:
214: for l_loop_count in 1..l_corp_thid.count loop
215:
216: -- clear the debug stack for each asset
217: FA_DEBUG_PKG.Initialize;
218: -- reset the message level to prevent bogus errors
219: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
220:
221: BEGIN

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

374: set process_status = l_process_status(i)
375: where rowid = l_rowid(i);
376:
377: if (g_log_level_rec.statement_level) then
378: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count,
379: p_log_level_rec => g_log_level_rec);
380: end if;
381:
382:

Line 407: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count,

403: select asset_id
404: from fa_asset_failures_gt;
405:
406: if (g_log_level_rec.statement_level) then
407: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count,
408: p_log_level_rec => g_log_level_rec);
409: end if;
410:
411: FND_CONCURRENT.AF_COMMIT;

Line 1142: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type

1138: end if;
1139:
1140:
1141: if (p_log_level_rec.statement_level) then
1142: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type
1143: ,p_log_level_rec => p_log_level_rec);
1144: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value
1145: ,p_log_level_rec => p_log_level_rec);
1146: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent

Line 1144: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value

1140:
1141: if (p_log_level_rec.statement_level) then
1142: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type
1143: ,p_log_level_rec => p_log_level_rec);
1144: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value
1145: ,p_log_level_rec => p_log_level_rec);
1146: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent
1147: ,p_log_level_rec => p_log_level_rec);
1148: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change

Line 1146: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent

1142: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type
1143: ,p_log_level_rec => p_log_level_rec);
1144: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value
1145: ,p_log_level_rec => p_log_level_rec);
1146: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent
1147: ,p_log_level_rec => p_log_level_rec);
1148: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change
1149: ,p_log_level_rec => p_log_level_rec);
1150: end if;

Line 1148: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change

1144: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value
1145: ,p_log_level_rec => p_log_level_rec);
1146: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent
1147: ,p_log_level_rec => p_log_level_rec);
1148: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change
1149: ,p_log_level_rec => p_log_level_rec);
1150: end if;
1151:
1152:

Line 1489: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type

1485:
1486: l_asset_fin_rec_adj.production_capacity := l_delta_capacity;
1487:
1488: if (p_log_level_rec.statement_level) then
1489: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type
1490: ,p_log_level_rec => p_log_level_rec);
1491: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value
1492: ,p_log_level_rec => p_log_level_rec);
1493: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value

Line 1491: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value

1487:
1488: if (p_log_level_rec.statement_level) then
1489: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type
1490: ,p_log_level_rec => p_log_level_rec);
1491: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value
1492: ,p_log_level_rec => p_log_level_rec);
1493: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value
1494: ,p_log_level_rec => p_log_level_rec);
1495: end if;

Line 1493: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value

1489: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type
1490: ,p_log_level_rec => p_log_level_rec);
1491: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value
1492: ,p_log_level_rec => p_log_level_rec);
1493: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value
1494: ,p_log_level_rec => p_log_level_rec);
1495: end if;
1496:
1497: FA_ADJUSTMENT_PUB.do_adjustment

Line 1721: fa_debug_pkg.add('test',

1717: end if;
1718:
1719: -- verify the asset exists in the book
1720: if (p_log_level_rec.statement_level) then
1721: fa_debug_pkg.add('test',
1722: 'getting',
1723: 'c_retirement cursor',
1724: p_log_level_rec => p_log_level_rec);
1725: end if;

Line 1785: fa_debug_pkg.add('test',

1781: raise ret_err1;
1782: end if;
1783:
1784: if (p_log_level_rec.statement_level) then
1785: fa_debug_pkg.add('test',
1786: 'getting',
1787: 'category cache',
1788: p_log_level_rec => p_log_level_rec);
1789: end if;

Line 1803: fa_debug_pkg.add('test',

1799: raise ret_err2;
1800: end if;
1801:
1802: if (p_log_level_rec.statement_level) then
1803: fa_debug_pkg.add('test',
1804: 'doing',
1805: 'validation',
1806: p_log_level_rec => p_log_level_rec);
1807: end if;

Line 1905: fa_debug_pkg.add('test',

1901:
1902: end if;
1903:
1904: if (p_log_level_rec.statement_level) then
1905: fa_debug_pkg.add('test',
1906: 'doing',
1907: 'validation part 2',
1908: p_log_level_rec => p_log_level_rec);
1909: end if;

Line 1926: fa_debug_pkg.add('test',

1922: end if;
1923:
1924:
1925: if (p_log_level_rec.statement_level) then
1926: fa_debug_pkg.add('test',
1927: 'doing',
1928: 'validation for period of addition',
1929: p_log_level_rec => p_log_level_rec);
1930: end if;

Line 1952: fa_debug_pkg.add('test',

1948:
1949: if (l_valid) then
1950:
1951: if (p_log_level_rec.statement_level) then
1952: fa_debug_pkg.add('test',
1953: 'trx',
1954: 'is valid'
1955: ,p_log_level_rec => p_log_level_rec);
1956: end if;

Line 2010: fa_debug_pkg.add('test',

2006:
2007: -- insure we run gainloss
2008: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2009: if (p_log_level_rec.statement_level) then
2010: fa_debug_pkg.add('test',
2011: 'calling',
2012: 'do reinstatement',
2013: p_log_level_rec => p_log_level_rec);
2014: end if;

Line 2017: fa_debug_pkg.add('test',

2013: p_log_level_rec => p_log_level_rec);
2014: end if;
2015:
2016: if (p_log_level_rec.statement_level) then
2017: fa_debug_pkg.add('test',
2018: 'calling',
2019: 'do retirement',
2020: p_log_level_rec => p_log_level_rec);
2021: fa_debug_pkg.add('test',

Line 2021: fa_debug_pkg.add('test',

2017: fa_debug_pkg.add('test',
2018: 'calling',
2019: 'do retirement',
2020: p_log_level_rec => p_log_level_rec);
2021: fa_debug_pkg.add('test',
2022: 'souce thid before call',
2023: l_trans_rec.source_transaction_header_id,
2024: p_log_level_rec => p_log_level_rec);
2025: end if;

Line 2076: fa_debug_pkg.add('test',

2072: -- pop the retirement struct with corp vales
2073: -- uses the retirement id for lookup
2074:
2075: if (p_log_level_rec.statement_level) then
2076: fa_debug_pkg.add('test',
2077: 'l_asset_retire_rec.retirement_id',
2078: l_asset_retire_rec.retirement_id,
2079: p_log_level_rec => p_log_level_rec);
2080: end if;

Line 2156: fa_debug_pkg.add('test',

2152: -- call the appropriate api
2153: -- passing calc_gain_loss flag as true
2154:
2155: if (p_log_level_rec.statement_level) then
2156: fa_debug_pkg.add('test',
2157: 'calling',
2158: 'do retirement',
2159: p_log_level_rec => p_log_level_rec);
2160: fa_debug_pkg.add('test',

Line 2160: fa_debug_pkg.add('test',

2156: fa_debug_pkg.add('test',
2157: 'calling',
2158: 'do retirement',
2159: p_log_level_rec => p_log_level_rec);
2160: fa_debug_pkg.add('test',
2161: 'souce thid before call',
2162: l_trans_rec.source_transaction_header_id,
2163: p_log_level_rec => p_log_level_rec);
2164: end if;

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

2439: end if;
2440: end if;
2441:
2442: if (g_log_level_rec.statement_level) then
2443: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation',
2444: p_log_level_rec => g_log_level_rec);
2445: end if;
2446:
2447:

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

2539: return;
2540: end if;
2541:
2542: if (g_log_level_rec.statement_level) then
2543: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate,
2544: p_log_level_rec => g_log_level_rec);
2545:
2546: end if;
2547:

Line 2646: fa_debug_pkg.add(l_calling_fn, 'opening c_per_trx_child cursor at', sysdate,

2642:
2643: else
2644:
2645: if (g_log_level_rec.statement_level) then
2646: fa_debug_pkg.add(l_calling_fn, 'opening c_per_trx_child cursor at', sysdate,
2647: p_log_level_rec => g_log_level_rec);
2648: end if;
2649:
2650: insert into fa_parallel_workers

Line 2758: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers', sql%rowcount,

2754:
2755: end if;
2756:
2757: if (g_log_level_rec.statement_level) then
2758: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers', sql%rowcount,
2759: p_log_level_rec => g_log_level_rec);
2760: end if;
2761:
2762: FND_CONCURRENT.AF_COMMIT;

Line 2783: fa_debug_pkg.add(l_calling_fn, 'rows fetched for parents, non-children and orphaned children', l_asset_id.count,

2779: l_worker_number
2780: limit l_batch_size;
2781:
2782: if (g_log_level_rec.statement_level) then
2783: fa_debug_pkg.add(l_calling_fn, 'rows fetched for parents, non-children and orphaned children', l_asset_id.count,
2784: p_log_level_rec => g_log_level_rec);
2785: end if;
2786:
2787: if (l_asset_id.count = 0) then

Line 2807: fa_debug_pkg.add(l_calling_fn, 'rows fetched for child assets', l_child_asset_id.count,

2803: into l_child_asset_id,
2804: l_child_process_order;
2805:
2806: if (g_log_level_rec.statement_level) then
2807: fa_debug_pkg.add(l_calling_fn, 'rows fetched for child assets', l_child_asset_id.count,
2808: p_log_level_rec => g_log_level_rec);
2809: end if;
2810:
2811: if (l_child_asset_id.count = 0) then

Line 2839: fa_debug_pkg.add(l_calling_fn, 'done process parent and child cursors', '',

2835:
2836: close c_parent_assets;
2837:
2838: if (g_log_level_rec.statement_level) then
2839: fa_debug_pkg.add(l_calling_fn, 'done process parent and child cursors', '',
2840: p_log_level_rec => g_log_level_rec);
2841: end if;
2842:
2843: