APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_DEBUG_PKG

Line 34: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

30: BEGIN
31: l_debug_str := 'Updating Mass Addions';
32:
33: IF (p_log_level_rec.statement_level) THEN
34: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
35: p_log_level_rec => p_log_level_rec);
36: END IF;
37:
38: FOR counter IN 1 .. p_mass_add_rec_tbl.COUNT LOOP

Line 205: fa_debug_pkg.add (l_calling_fn,

201: WHEN dml_errors THEN
202: l_errors := SQL%BULK_EXCEPTIONS.COUNT;
203:
204: IF (p_log_level_rec.statement_level) THEN
205: fa_debug_pkg.add (l_calling_fn,
206: 'Number of errors is ',
207: l_errors,
208: p_log_level_rec => p_log_level_rec);
209: END IF;

Line 213: fa_debug_pkg.add (l_calling_fn,

209: END IF;
210:
211: FOR i IN 1 .. l_errors LOOP
212: IF (p_log_level_rec.statement_level) THEN
213: fa_debug_pkg.add (l_calling_fn,
214: 'Error ' || i || ' occurred during ' ||
215: 'iteration ',
216: SQL%BULK_EXCEPTIONS (i).ERROR_INDEX,
217: p_log_level_rec => p_log_level_rec);

Line 219: fa_debug_pkg.add (l_calling_fn,

215: 'iteration ',
216: SQL%BULK_EXCEPTIONS (i).ERROR_INDEX,
217: p_log_level_rec => p_log_level_rec);
218:
219: fa_debug_pkg.add (l_calling_fn,
220: 'Oracle error is ',
221: SQLERRM ( -SQL%BULK_EXCEPTIONS (i).ERROR_CODE),
222: p_log_level_rec => p_log_level_rec);
223: END IF;

Line 493: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

489:
490: l_debug_str := 'Calling prepare_asset_key_category';
491:
492: IF (g_log_level_rec.statement_level) THEN
493: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
494: p_log_level_rec => g_log_level_rec);
495: END IF;
496:
497: IF (g_log_level_rec.statement_level) THEN

Line 498: fa_debug_pkg.add (l_calling_fn,

494: p_log_level_rec => g_log_level_rec);
495: END IF;
496:
497: IF (g_log_level_rec.statement_level) THEN
498: fa_debug_pkg.add (l_calling_fn,
499: 'l_lookup_rule_value',
500: l_lookup_rule_value,
501: p_log_level_rec => g_log_level_rec);
502: END IF;

Line 520: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

516: */
517: l_debug_str := 'Calling merge_mass_additions';
518:
519: IF (g_log_level_rec.statement_level) THEN
520: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
521: p_log_level_rec => g_log_level_rec);
522: END IF;
523:
524: IF NOT FA_MASSADD_PREP_ENERGY_PKG.merge_lines (p_book_type_code,

Line 563: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

559: FOR l_count IN 1 .. l_mass_add_rec_tbl.COUNT LOOP
560: l_debug_str := 'Calling prepare_attributes';
561:
562: IF (g_log_level_rec.statement_level) THEN
563: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
564: p_log_level_rec => g_log_level_rec);
565: END IF;
566:
567: IF (l_lookup_rule_value = 'DEFAULT') THEN

Line 572: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

568: IF NOT FA_MASSADD_PREP_DEFAULT_PKG.prepare_attributes ( l_mass_add_rec_tbl ( l_count), p_log_level_rec => g_log_level_rec) THEN
569: l_debug_str := 'Custom prepare attributes returned failure';
570:
571: IF (g_log_level_rec.statement_level) THEN
572: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
573: p_log_level_rec => g_log_level_rec);
574: END IF;
575: END IF;
576: ELSIF (l_lookup_rule_value = 'CUSTOM') THEN

Line 581: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

577: IF NOT FA_MASSADD_PREP_CUSTOM_PKG.prepare_attributes ( l_mass_add_rec_tbl ( l_count), p_log_level_rec => g_log_level_rec) THEN
578: l_debug_str := 'Custom prepare attributes returned failure';
579:
580: IF (g_log_level_rec.statement_level) THEN
581: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
582: p_log_level_rec => g_log_level_rec);
583: END IF;
584: END IF;
585: ELSIF (l_lookup_rule_value = 'CUSTOM ENERGY') THEN

Line 590: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

586: IF NOT FA_MASSADD_PREP_ENERGY_PKG.prepare_attributes ( l_mass_add_rec_tbl ( l_count), p_log_level_rec => g_log_level_rec) THEN
587: l_debug_str := 'Energy prepare attributes returned failure';
588:
589: IF (g_log_level_rec.statement_level) THEN
590: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
591: p_log_level_rec => g_log_level_rec);
592: END IF;
593: END IF;
594: END IF;

Line 600: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

596:
597: l_debug_str := 'Calling update_mass_additions';
598:
599: IF (g_log_level_rec.statement_level) THEN
600: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
601: p_log_level_rec => g_log_level_rec);
602: END IF;
603:
604: IF NOT update_mass_additions (l_mass_add_rec_tbl,

Line 609: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',

605: p_log_level_rec => g_log_level_rec) THEN
606: l_debug_str := 'error in update_mass_additions';
607:
608: IF (g_log_level_rec.statement_level) THEN
609: fa_debug_pkg.add ( l_calling_fn, l_debug_str, '',
610: p_log_level_rec => g_log_level_rec);
611: END IF;
612: END IF;
613: END LOOP;