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

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

210:
211: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
212:
213: if(g_log_level_rec.statement_level) then
214: fa_debug_pkg.add(l_calling_fn, 'opening c_trx_parent cursor at', sysdate, p_log_level_rec => g_log_level_rec);
215: end if;
216:
217: open c_trx(p_parent_request_id => p_parent_request_id,
218: p_request_number => p_request_number,

Line 235: fa_debug_pkg.add('test',

231:
232: close c_trx;
233:
234: if (g_log_level_rec.statement_level) then
235: fa_debug_pkg.add('test',
236: 'after fetch thid count is',
237: l_corp_thid.count, p_log_level_rec => g_log_level_rec);
238: end if;
239:

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

244: end if;
245:
246: -- dump any debug messages from above
247: if (g_log_level_rec.statement_level) then
248: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
249: end if;
250:
251: for l_loop_count in 1..l_corp_thid.count loop
252:

Line 254: FA_DEBUG_PKG.Initialize;

250:
251: for l_loop_count in 1..l_corp_thid.count loop
252:
253: -- clear the debug stack for each asset
254: FA_DEBUG_PKG.Initialize;
255: -- reset the message level to prevent bogus errors
256: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
257:
258: BEGIN

Line 301: fa_debug_pkg.add(l_calling_fn,

297: l_tax_thid(l_loop_count) is not null and
298: G_release = 11) then
299:
300: if (g_log_level_rec.statement_level) then
301: fa_debug_pkg.add(l_calling_fn,
302: 'entering',
303: 'logic for ADDITION and tax exists', p_log_level_rec => g_log_level_rec);
304: end if;
305:

Line 326: fa_debug_pkg.add(l_calling_fn,

322: -- corp book error out.
323: if (c_last_copied_trx%notfound) then
324: close c_last_copied_trx;
325: if (g_log_level_rec.statement_level) then
326: fa_debug_pkg.add(l_calling_fn,
327: 'Tax Book contains',
328: 'no transaction copied from corp book', p_log_level_rec => g_log_level_rec);
329: end if;
330: raise error_found_trx;

Line 338: fa_debug_pkg.add(l_calling_fn,

334: end if;
335: -- Bug 5864939 end
336:
337: if (g_log_level_rec.statement_level) then
338: fa_debug_pkg.add(l_calling_fn,
339: 'Last copied corp book txn',
340: l_orig_src_trx_header_id, p_log_level_rec => g_log_level_rec);
341: end if;
342:

Line 346: fa_debug_pkg.add(l_calling_fn,

342:
343:
344: if (l_orig_src_trx_header_id < l_corp_thid(l_loop_count)) then
345: if (g_log_level_rec.statement_level) then
346: fa_debug_pkg.add(l_calling_fn,
347: 'processing ADDITION as ADJUSTMENT using source thid of ',
348: l_orig_src_trx_header_id, p_log_level_rec => g_log_level_rec);
349: end if;
350:

Line 369: fa_debug_pkg.add(l_calling_fn,

365: raise error_found_fatal_trx;
366: end if;
367:
368: if (g_log_level_rec.statement_level) then
369: fa_debug_pkg.add(l_calling_fn,
370: 'finding in between trxs ',
371: '', p_log_level_rec => g_log_level_rec);
372: fa_debug_pkg.add(l_calling_fn,
373: 'asset id ',

Line 372: fa_debug_pkg.add(l_calling_fn,

368: if (g_log_level_rec.statement_level) then
369: fa_debug_pkg.add(l_calling_fn,
370: 'finding in between trxs ',
371: '', p_log_level_rec => g_log_level_rec);
372: fa_debug_pkg.add(l_calling_fn,
373: 'asset id ',
374: l_asset_id(l_loop_count));
375: fa_debug_pkg.add(l_calling_fn,
376: 'corp book',

Line 375: fa_debug_pkg.add(l_calling_fn,

371: '', p_log_level_rec => g_log_level_rec);
372: fa_debug_pkg.add(l_calling_fn,
373: 'asset id ',
374: l_asset_id(l_loop_count));
375: fa_debug_pkg.add(l_calling_fn,
376: 'corp book',
377: fa_cache_pkg.fazcbc_record.distribution_source_book, p_log_level_rec => g_log_level_rec);
378: fa_debug_pkg.add(l_calling_fn,
379: 'start thid',

Line 378: fa_debug_pkg.add(l_calling_fn,

374: l_asset_id(l_loop_count));
375: fa_debug_pkg.add(l_calling_fn,
376: 'corp book',
377: fa_cache_pkg.fazcbc_record.distribution_source_book, p_log_level_rec => g_log_level_rec);
378: fa_debug_pkg.add(l_calling_fn,
379: 'start thid',
380: l_orig_src_trx_header_id, p_log_level_rec => g_log_level_rec);
381: fa_debug_pkg.add(l_calling_fn,
382: 'end thid ',

Line 381: fa_debug_pkg.add(l_calling_fn,

377: fa_cache_pkg.fazcbc_record.distribution_source_book, p_log_level_rec => g_log_level_rec);
378: fa_debug_pkg.add(l_calling_fn,
379: 'start thid',
380: l_orig_src_trx_header_id, p_log_level_rec => g_log_level_rec);
381: fa_debug_pkg.add(l_calling_fn,
382: 'end thid ',
383: l_corp_thid(l_loop_count));
384:
385: end if;

Line 399: fa_debug_pkg.add(l_calling_fn,

395: close c_prior_adjs;
396:
397: if (l_prior_thid.count = 0) then
398: if (g_log_level_rec.statement_level) then
399: fa_debug_pkg.add(l_calling_fn,
400: 'no ADDITION/VOIDs found',
401: '', p_log_level_rec => g_log_level_rec);
402: end if;
403: end if;

Line 412: fa_debug_pkg.add(l_calling_fn,

408: -- Consider each call to mcp_adjustment as a separate
409: -- Transaction (record) and handle the exceptions here itself
410: BEGIN
411: if (g_log_level_rec.statement_level) then
412: fa_debug_pkg.add(l_calling_fn,
413: 'in loop',
414: '', p_log_level_rec => g_log_level_rec);
415: fa_debug_pkg.add(l_calling_fn,
416: 'calling mcp_adjustment with thid of ',

Line 415: fa_debug_pkg.add(l_calling_fn,

411: if (g_log_level_rec.statement_level) then
412: fa_debug_pkg.add(l_calling_fn,
413: 'in loop',
414: '', p_log_level_rec => g_log_level_rec);
415: fa_debug_pkg.add(l_calling_fn,
416: 'calling mcp_adjustment with thid of ',
417: l_prior_thid(x));
418: end if;
419:

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

464:
465: END;
466:
467: if (g_log_level_rec.statement_level) then
468: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
469: end if;
470:
471: -- FND_CONCURRENT.AF_COMMIT each record
472: FND_CONCURRENT.AF_COMMIT;

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

556: l_process_status(l_loop_count) := 'SUCCESS';
557: end if;
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: -- do not set the fatal error flag here!

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

567:
568: l_process_status(l_loop_count) := 'WARNING';
569: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
570: if (g_log_level_rec.statement_level) then
571: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
572: end if;
573:
574: WHEN error_found_fatal_trx THEN
575: FND_CONCURRENT.AF_ROLLBACK;

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

579: g_asset_error2_tbl(l_asset_id(l_loop_count)) := l_asset_id(l_loop_count);
580:
581: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
582: if (g_log_level_rec.statement_level) then
583: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
584: end if;
585:
586: WHEN OTHERS THEN
587: FND_CONCURRENT.AF_ROLLBACK;

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

592:
593: g_fatal_error := TRUE;
594: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
595: if (g_log_level_rec.statement_level) then
596: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
597: end if;
598:
599: END; -- asset level block
600:

Line 613: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workersfor status', sql%rowcount);

609: set process_status = l_process_status(i)
610: where rowid = l_rowid(i);
611:
612: if (g_log_level_rec.statement_level) then
613: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workersfor status', sql%rowcount);
614: end if;
615:
616: FND_CONCURRENT.AF_COMMIT;
617:

Line 642: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count, p_log_level_rec => g_log_level_rec);

638: select asset_id
639: from fa_asset_failures_gt;
640:
641: if (g_log_level_rec.statement_level) then
642: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count, p_log_level_rec => g_log_level_rec);
643: end if;
644:
645:
646: x_success_count := G_success_count;

Line 1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);

1421: end if;
1422:
1423:
1424: if (g_log_level_rec.statement_level) then
1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);
1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);

Line 1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);

1422:
1423:
1424: if (g_log_level_rec.statement_level) then
1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);
1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);
1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);

Line 1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);

1423:
1424: if (g_log_level_rec.statement_level) then
1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);
1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);
1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);
1431: end if;

Line 1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);

1424: if (g_log_level_rec.statement_level) then
1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);
1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);
1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);
1431: end if;
1432:

Line 1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);

1425: fa_debug_pkg.add(l_calling_fn, 'l_tax_new_salvage_type', l_tax_new_salvage_type, p_log_level_rec => g_log_level_rec);
1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);
1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);
1431: end if;
1432:
1433:

Line 1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);

1426: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_value', l_delta_salvage_value, p_log_level_rec => g_log_level_rec);
1427: fa_debug_pkg.add(l_calling_fn, 'l_delta_salvage_percent', l_delta_salvage_percent, p_log_level_rec => g_log_level_rec);
1428: fa_debug_pkg.add(l_calling_fn, 'l_valid_salvage_change', l_valid_salvage_change, p_log_level_rec => g_log_level_rec);
1429: fa_debug_pkg.add(l_calling_fn, 'l_salvage_change', l_salvage_change, p_log_level_rec => g_log_level_rec);
1430: fa_debug_pkg.add(l_calling_fn, 'l_group_change', l_group_change, p_log_level_rec => g_log_level_rec);
1431: end if;
1432:
1433:
1434:

Line 1793: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type, p_log_level_rec => g_log_level_rec);

1789:
1790: l_asset_fin_rec_adj.production_capacity := l_delta_capacity;
1791:
1792: if (g_log_level_rec.statement_level) then
1793: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type, p_log_level_rec => g_log_level_rec);
1794: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value, p_log_level_rec => g_log_level_rec);
1795: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value, p_log_level_rec => g_log_level_rec);
1796: end if;
1797:

Line 1794: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value, p_log_level_rec => g_log_level_rec);

1790: l_asset_fin_rec_adj.production_capacity := l_delta_capacity;
1791:
1792: if (g_log_level_rec.statement_level) then
1793: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type, p_log_level_rec => g_log_level_rec);
1794: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value, p_log_level_rec => g_log_level_rec);
1795: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value, p_log_level_rec => g_log_level_rec);
1796: end if;
1797:
1798: FA_ADJUSTMENT_PUB.do_adjustment

Line 1795: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value, p_log_level_rec => g_log_level_rec);

1791:
1792: if (g_log_level_rec.statement_level) then
1793: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_type', l_asset_fin_rec_adj.salvage_type, p_log_level_rec => g_log_level_rec);
1794: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.salvage_value', l_asset_fin_rec_adj.salvage_value, p_log_level_rec => g_log_level_rec);
1795: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_adj.percent_salvage_value', l_asset_fin_rec_adj.percent_salvage_value, p_log_level_rec => g_log_level_rec);
1796: end if;
1797:
1798: FA_ADJUSTMENT_PUB.do_adjustment
1799: (p_api_version => 1.0,

Line 2019: fa_debug_pkg.add('test',

2015: end if;
2016:
2017: -- verify the asset exists in the book
2018: if (g_log_level_rec.statement_level) then
2019: fa_debug_pkg.add('test',
2020: 'getting',
2021: 'c_retirement cursor', p_log_level_rec => g_log_level_rec);
2022: end if;
2023:

Line 2082: fa_debug_pkg.add('test',

2078: raise ret_err1;
2079: end if;
2080:
2081: if (g_log_level_rec.statement_level) then
2082: fa_debug_pkg.add('test',
2083: 'getting',
2084: 'category cache', p_log_level_rec => g_log_level_rec);
2085: end if;
2086:

Line 2098: fa_debug_pkg.add('test',

2094: raise ret_err2;
2095: end if;
2096:
2097: if (g_log_level_rec.statement_level) then
2098: fa_debug_pkg.add('test',
2099: 'doing',
2100: 'validation', p_log_level_rec => g_log_level_rec);
2101: end if;
2102:

Line 2200: fa_debug_pkg.add('test',

2196: end if;
2197: end if;
2198:
2199: if (g_log_level_rec.statement_level) then
2200: fa_debug_pkg.add('test',
2201: 'doing',
2202: 'validation part 2', p_log_level_rec => g_log_level_rec);
2203: end if;
2204:

Line 2220: fa_debug_pkg.add('test',

2216: end if;
2217:
2218:
2219: if (g_log_level_rec.statement_level) then
2220: fa_debug_pkg.add('test',
2221: 'doing',
2222: 'validation for period of addition', p_log_level_rec => g_log_level_rec);
2223: end if;
2224:

Line 2245: fa_debug_pkg.add('test',

2241: end if;
2242:
2243: -- BUG# 6905121 no longer validate period of capitalization
2244: if (g_log_level_rec.statement_level) then
2245: fa_debug_pkg.add('test',
2246: 'doing',
2247: 'after validating period of addition', p_log_level_rec => g_log_level_rec);
2248: end if;
2249:

Line 2267: fa_debug_pkg.add('test',

2263:
2264: if (l_valid) then
2265:
2266: if (g_log_level_rec.statement_level) then
2267: fa_debug_pkg.add('test',
2268: 'trx',
2269: 'is valid', p_log_level_rec => g_log_level_rec);
2270: end if;
2271:

Line 2298: fa_debug_pkg.add('Checking reinst.','l_tax_reinst_thid',l_tax_reinst_thid);

2294: l_count :=0;
2295: END;
2296:
2297: if (g_log_level_rec.statement_level) then
2298: fa_debug_pkg.add('Checking reinst.','l_tax_reinst_thid',l_tax_reinst_thid);
2299: fa_debug_pkg.add('Checking reinst.','l_count',l_count);
2300: end if;
2301:
2302: -- verify asset has been retired

Line 2299: fa_debug_pkg.add('Checking reinst.','l_count',l_count);

2295: END;
2296:
2297: if (g_log_level_rec.statement_level) then
2298: fa_debug_pkg.add('Checking reinst.','l_tax_reinst_thid',l_tax_reinst_thid);
2299: fa_debug_pkg.add('Checking reinst.','l_count',l_count);
2300: end if;
2301:
2302: -- verify asset has been retired
2303: if (l_count = 0) then

Line 2345: fa_debug_pkg.add('test',

2341:
2342: -- insure we run gainloss
2343: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2344: if (g_log_level_rec.statement_level) then
2345: fa_debug_pkg.add('test',
2346: 'calling',
2347: 'do reinstatement', p_log_level_rec => g_log_level_rec);
2348: end if;
2349:

Line 2351: fa_debug_pkg.add('test',

2347: 'do reinstatement', p_log_level_rec => g_log_level_rec);
2348: end if;
2349:
2350: if (g_log_level_rec.statement_level) then
2351: fa_debug_pkg.add('test',
2352: 'calling',
2353: 'do retirement', p_log_level_rec => g_log_level_rec);
2354: fa_debug_pkg.add('test',
2355: 'souce thid before call',

Line 2354: fa_debug_pkg.add('test',

2350: if (g_log_level_rec.statement_level) then
2351: fa_debug_pkg.add('test',
2352: 'calling',
2353: 'do retirement', p_log_level_rec => g_log_level_rec);
2354: fa_debug_pkg.add('test',
2355: 'souce thid before call',
2356: l_trans_rec.source_transaction_header_id, p_log_level_rec => g_log_level_rec);
2357: end if;
2358:

Line 2407: fa_debug_pkg.add('test',

2403: -- pop the retirement struct with corp vales
2404: -- uses the retirement id for lookup
2405:
2406: if (g_log_level_rec.statement_level) then
2407: fa_debug_pkg.add('test',
2408: 'l_asset_retire_rec.retirement_id',
2409: l_asset_retire_rec.retirement_id, p_log_level_rec => g_log_level_rec);
2410: end if;
2411:

Line 2488: fa_debug_pkg.add('test',

2484: -- call the appropriate api
2485: -- passing calc_gain_loss flag as true
2486:
2487: if (g_log_level_rec.statement_level) then
2488: fa_debug_pkg.add('test',
2489: 'calling',
2490: 'do retirement', p_log_level_rec => g_log_level_rec);
2491: fa_debug_pkg.add('test',
2492: 'souce thid before call',

Line 2491: fa_debug_pkg.add('test',

2487: if (g_log_level_rec.statement_level) then
2488: fa_debug_pkg.add('test',
2489: 'calling',
2490: 'do retirement', p_log_level_rec => g_log_level_rec);
2491: fa_debug_pkg.add('test',
2492: 'souce thid before call',
2493: l_trans_rec.source_transaction_header_id, p_log_level_rec => g_log_level_rec);
2494: end if;
2495:

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

2769: end if;
2770: end if;
2771:
2772: if(g_log_level_rec.statement_level) then
2773: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation', p_log_level_rec => g_log_level_rec);
2774: end if;
2775:
2776: x_return_status := 0;
2777:

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

2867: return;
2868: end if;
2869:
2870: if(g_log_level_rec.statement_level) then
2871: fa_debug_pkg.add(l_calling_fn, 'inserting initial transactions at', sysdate, p_log_level_rec => g_log_level_rec);
2872: end if;
2873:
2874: -- bug fix 5900321 (Initial Mass Copy copies capitalized assets to wrong fiscal year and period in TAX book)
2875: l_date_effective := nvl(l_corp_period_rec.period_close_date, sysdate);

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

2969:
2970: else
2971:
2972: if (g_log_level_rec.statement_level) then
2973: fa_debug_pkg.add(l_calling_fn, 'opening c_per_trx_child cursor at', sysdate, p_log_level_rec => g_log_level_rec);
2974: end if;
2975:
2976: insert into fa_parallel_workers
2977: (request_id ,

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

3080:
3081: end if;
3082:
3083: if (g_log_level_rec.statement_level) then
3084: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers', sql%rowcount);
3085: end if;
3086:
3087: FND_CONCURRENT.AF_COMMIT;
3088: /* Bug 9020567 */

Line 3093: fa_debug_pkg.add(l_calling_fn, 'Getting schema name', 'OFA', p_log_level_rec => g_log_level_rec);

3089: /* When Data volumes are hign in fa_parallel_workers table we need to */
3090: /* analze this table to compute statistics for performance reason*/
3091:
3092: if (g_log_level_rec.statement_level) then
3093: fa_debug_pkg.add(l_calling_fn, 'Getting schema name', 'OFA', p_log_level_rec => g_log_level_rec);
3094: end if;
3095:
3096: -- Bug 14661641: Get FA schema
3097: if not (fnd_installation.get_app_info (

Line 3106: fa_debug_pkg.add(l_calling_fn, 'Schema name', l_schema, p_log_level_rec => g_log_level_rec);

3102: raise masscp_err;
3103: end if;
3104:
3105: if (g_log_level_rec.statement_level) then
3106: fa_debug_pkg.add(l_calling_fn, 'Schema name', l_schema, p_log_level_rec => g_log_level_rec);
3107: end if;
3108:
3109: EXECUTE IMMEDIATE 'begin sys.dbms_stats.gather_table_stats(
3110: :1, '

Line 3115: fa_debug_pkg.add(l_calling_fn, 'After gather statistics', l_schema, p_log_level_rec => g_log_level_rec);

3111: ||'''fa_parallel_workers'''
3112: ||',estimate_percent=>100, cascade=>TRUE); end;' using l_schema;
3113:
3114: if (g_log_level_rec.statement_level) then
3115: fa_debug_pkg.add(l_calling_fn, 'After gather statistics', l_schema, p_log_level_rec => g_log_level_rec);
3116: end if;
3117:
3118: -- increase the process order for group if applicable
3119: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then

Line 3138: fa_debug_pkg.add(l_calling_fn, 'rows fetched for parents, non-children and orphaned children', l_asset_id.count, p_log_level_rec => g_log_level_rec);

3134: l_worker_number
3135: limit l_batch_size;
3136:
3137: if (g_log_level_rec.statement_level) then
3138: fa_debug_pkg.add(l_calling_fn, 'rows fetched for parents, non-children and orphaned children', l_asset_id.count, p_log_level_rec => g_log_level_rec);
3139: end if;
3140:
3141: if (l_asset_id.count = 0) then
3142: exit;

Line 3161: fa_debug_pkg.add(l_calling_fn, 'rows fetched for child assets', l_child_asset_id.count, p_log_level_rec => g_log_level_rec);

3157: into l_child_asset_id,
3158: l_child_process_order;
3159:
3160: if (g_log_level_rec.statement_level) then
3161: fa_debug_pkg.add(l_calling_fn, 'rows fetched for child assets', l_child_asset_id.count, p_log_level_rec => g_log_level_rec);
3162: end if;
3163:
3164: if (l_child_asset_id.count = 0) then
3165: exit;

Line 3192: fa_debug_pkg.add(l_calling_fn, 'done process parent and child cursors', '', p_log_level_rec => g_log_level_rec);

3188:
3189: close c_parent_assets;
3190:
3191: if (g_log_level_rec.statement_level) then
3192: fa_debug_pkg.add(l_calling_fn, 'done process parent and child cursors', '', p_log_level_rec => g_log_level_rec);
3193: end if;
3194:
3195: FND_CONCURRENT.AF_COMMIT;
3196:

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

3195: FND_CONCURRENT.AF_COMMIT;
3196:
3197: -- dump any debug messages from above
3198: if (g_log_level_rec.statement_level) then
3199: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
3200: end if;
3201:
3202:
3203: x_return_status := 0;

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

3208: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
3209:
3210: -- dump any debug messages from above
3211: if (g_log_level_rec.statement_level) then
3212: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
3213: end if;
3214:
3215:
3216: X_return_status := 2;

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

3220: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
3221:
3222: -- dump any debug messages from above
3223: if (g_log_level_rec.statement_level) then
3224: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
3225: end if;
3226:
3227: x_return_status := 2;
3228: