DBA Data[Home] [Help]

APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_DEBUG_PKG

Line 29: fa_debug_pkg.add(l_calling_fn,

25:
26: begin
27: l_debug_str := 'Updating Mass Addions';
28: if (p_log_level_rec.statement_level) then
29: fa_debug_pkg.add(l_calling_fn,
30: l_debug_str,
31: '',
32: p_log_level_rec => p_log_level_rec);
33: end if;

Line 347: fa_debug_pkg.add(l_calling_fn,

343: exception
344: WHEN dml_errors THEN
345: l_errors := SQL%BULK_EXCEPTIONS.COUNT;
346: if (p_log_level_rec.statement_level) then
347: fa_debug_pkg.add(l_calling_fn,
348: 'Number of errors is ',
349: l_errors,
350: p_log_level_rec => p_log_level_rec);
351: end if;

Line 356: fa_debug_pkg.add(l_calling_fn,

352:
353: FOR i IN 1 .. l_errors LOOP
354:
355: if (p_log_level_rec.statement_level) then
356: fa_debug_pkg.add(l_calling_fn,
357: 'Error ' || i || ' occurred during ' ||
358: 'iteration ',
359: SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
360: p_log_level_rec => p_log_level_rec);

Line 362: fa_debug_pkg.add(l_calling_fn,

358: 'iteration ',
359: SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
360: p_log_level_rec => p_log_level_rec);
361: end if;
362: fa_debug_pkg.add(l_calling_fn,
363: 'Oracle error is ',
364: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
365: p_log_level_rec => p_log_level_rec);
366: if (p_log_level_rec.statement_level) then

Line 367: fa_debug_pkg.add(l_calling_fn,

363: 'Oracle error is ',
364: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
365: p_log_level_rec => p_log_level_rec);
366: if (p_log_level_rec.statement_level) then
367: fa_debug_pkg.add(l_calling_fn,
368: 'Oracle error is ',
369: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
370: p_log_level_rec => p_log_level_rec);
371: end if;

Line 634: fa_debug_pkg.add(l_calling_fn,

630: */
631:
632: l_debug_str := 'Calling prepare_asset_key_category';
633: if (g_log_level_rec.statement_level) then
634: fa_debug_pkg.add(l_calling_fn,
635: l_debug_str,
636: '',
637: p_log_level_rec => g_log_level_rec);
638: end if;

Line 641: fa_debug_pkg.add(l_calling_fn,

637: p_log_level_rec => g_log_level_rec);
638: end if;
639:
640: if (g_log_level_rec.statement_level) then
641: fa_debug_pkg.add(l_calling_fn,
642: 'l_lookup_rule_value',
643: l_lookup_rule_value,
644: p_log_level_rec => g_log_level_rec);
645: end if;

Line 666: fa_debug_pkg.add(l_calling_fn,

662: ------------------------------------------------------------------------------
663: */
664: l_debug_str := 'Calling merge_mass_additions';
665: if (g_log_level_rec.statement_level) then
666: fa_debug_pkg.add(l_calling_fn,
667: l_debug_str,
668: '',
669: p_log_level_rec => g_log_level_rec);
670: end if;

Line 709: fa_debug_pkg.add(l_calling_fn,

705: --Loop to get process each mass addition line
706: for l_count in 1 .. l_mass_add_rec_tbl.count loop
707: l_debug_str := 'Calling prepare_attributes';
708: if (g_log_level_rec.statement_level) then
709: fa_debug_pkg.add(l_calling_fn,
710: l_debug_str,
711: '',
712: p_log_level_rec => g_log_level_rec);
713: end if;

Line 721: fa_debug_pkg.add(l_calling_fn,

717: p_log_level_rec => g_log_level_rec) then
718: l_debug_str := 'Custom prepare attributes returned failure';
719:
720: if (g_log_level_rec.statement_level) then
721: fa_debug_pkg.add(l_calling_fn,
722: l_debug_str,
723: '',
724: p_log_level_rec => g_log_level_rec);
725: end if;

Line 735: fa_debug_pkg.add(l_calling_fn,

731: p_log_level_rec => g_log_level_rec) then
732: l_debug_str := 'Custom prepare attributes returned failure';
733: if (g_log_level_rec.statement_level) then
734:
735: fa_debug_pkg.add(l_calling_fn,
736: l_debug_str,
737: '',
738: p_log_level_rec => g_log_level_rec);
739: end if;

Line 748: fa_debug_pkg.add(l_calling_fn,

744: p_log_level_rec => g_log_level_rec) then
745: l_debug_str := 'Energy prepare attributes returned failure';
746: if (g_log_level_rec.statement_level) then
747:
748: fa_debug_pkg.add(l_calling_fn,
749: l_debug_str,
750: '',
751: p_log_level_rec => g_log_level_rec);
752: end if;

Line 759: fa_debug_pkg.add(l_calling_fn,

755: end loop;
756: l_debug_str := 'Calling update_mass_additions';
757: if (g_log_level_rec.statement_level) then
758:
759: fa_debug_pkg.add(l_calling_fn,
760: l_debug_str,
761: '',
762: p_log_level_rec => g_log_level_rec);
763: end if;

Line 769: fa_debug_pkg.add(l_calling_fn,

765: p_log_level_rec => g_log_level_rec) then
766: l_debug_str := 'error in update_mass_additions';
767: if (g_log_level_rec.statement_level) then
768:
769: fa_debug_pkg.add(l_calling_fn,
770: l_debug_str,
771: '',
772: p_log_level_rec => g_log_level_rec);
773: end if;