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

Line 705: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,

701:
702: if (g_times_called = 1) then
703:
704: if (g_log_level_rec.statement_level) then
705: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,
706: p_log_level_rec => g_log_level_rec);
707: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode,
708: p_log_level_rec => g_log_level_rec);
709: end if;

Line 707: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode,

703:
704: if (g_log_level_rec.statement_level) then
705: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,
706: p_log_level_rec => g_log_level_rec);
707: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode,
708: p_log_level_rec => g_log_level_rec);
709: end if;
710:
711: end if;

Line 922: FA_DEBUG_PKG.Initialize;

918:
919: savepoint famapt;
920:
921: -- clear the debug stack for each asset
922: FA_DEBUG_PKG.Initialize;
923: -- reset the message level to prevent bogus errors
924: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
925:
926: BEGIN -- start asset level block

Line 1275: fa_debug_pkg.add(l_calling_fn,

1271:
1272: if (l_add_to_asset_id_tbl(i) is null) then
1273:
1274: if (g_log_level_rec.statement_level) then
1275: fa_debug_pkg.add(l_calling_fn,
1276: 'Regular addition',
1277: l_asset_id_tbl(i),
1278: p_log_level_rec => g_log_level_rec);
1279: end if;

Line 1462: fa_debug_pkg.add(l_calling_fn,

1458:
1459: else -- add_to_asset_id populated for adj
1460:
1461: if (g_log_level_rec.statement_level) then
1462: fa_debug_pkg.add(l_calling_fn,
1463: 'Add to asset_id',
1464: l_add_to_asset_id_tbl(i));
1465: end if;
1466:

Line 1561: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);

1557: end if;
1558:
1559: if l_mass_property_flag_tbl(i) = 'Y' then
1560: if (g_log_level_rec.statement_level) then
1561: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1562: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1563: end if;
1564:
1565: open c_distributions(p_massadd_id => l_mass_addition_id_tbl(i));

Line 1562: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);

1558:
1559: if l_mass_property_flag_tbl(i) = 'Y' then
1560: if (g_log_level_rec.statement_level) then
1561: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1562: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1563: end if;
1564:
1565: open c_distributions(p_massadd_id => l_mass_addition_id_tbl(i));
1566: fetch c_distributions bulk collect

Line 1575: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist bulkfetch', '', p_log_level_rec => g_log_level_rec);

1571:
1572: close c_distributions;
1573:
1574: if (g_log_level_rec.statement_level) then
1575: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist bulkfetch', '', p_log_level_rec => g_log_level_rec);
1576: end if;
1577:
1578: for l_md in 1..l_mad_units_tbl.count loop
1579: if (g_log_level_rec.statement_level) then

Line 1580: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist loop', l_md, p_log_level_rec => g_log_level_rec);

1576: end if;
1577:
1578: for l_md in 1..l_mad_units_tbl.count loop
1579: if (g_log_level_rec.statement_level) then
1580: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist loop', l_md, p_log_level_rec => g_log_level_rec);
1581: end if;
1582:
1583: if l_mad_deprn_expense_ccid_tbl(l_md) is not null then
1584:

Line 1586: fa_debug_pkg.add(l_calling_fn, 'mad ccid is not null', l_mad_deprn_expense_ccid_tbl(l_md));

1582:
1583: if l_mad_deprn_expense_ccid_tbl(l_md) is not null then
1584:
1585: if (g_log_level_rec.statement_level) then
1586: fa_debug_pkg.add(l_calling_fn, 'mad ccid is not null', l_mad_deprn_expense_ccid_tbl(l_md));
1587: end if;
1588:
1589: open c_dh (l_add_to_asset_id_tbl(i), l_mad_deprn_expense_ccid_tbl(l_md),l_mad_location_id_tbl(l_md),l_mad_employee_id_tbl(l_md));
1590: fetch c_dh

Line 1605: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);

1601: l_asset_dist_rec.transaction_units := l_mad_units_tbl(l_md);
1602: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1603:
1604: if (g_log_level_rec.statement_level) then
1605: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1606: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1607: end if;
1608:
1609: else -- dist doesn't exist

Line 1606: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);

1602: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1603:
1604: if (g_log_level_rec.statement_level) then
1605: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1606: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1607: end if;
1608:
1609: else -- dist doesn't exist
1610: -- create new distribution row.

Line 1619: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);

1615: l_asset_dist_rec.location_ccid := l_mad_location_id_tbl(l_md);
1616: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1617:
1618: if (g_log_level_rec.statement_level) then
1619: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1620: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid, p_log_level_rec => g_log_level_rec);
1621: end if;
1622: end if; -- c_dh
1623: close c_dh;

Line 1620: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid, p_log_level_rec => g_log_level_rec);

1616: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1617:
1618: if (g_log_level_rec.statement_level) then
1619: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1620: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid, p_log_level_rec => g_log_level_rec);
1621: end if;
1622: end if; -- c_dh
1623: close c_dh;
1624: else -- ccid is null

Line 1628: fa_debug_pkg.add(l_calling_fn, 'ccid is null', '', p_log_level_rec => g_log_level_rec);

1624: else -- ccid is null
1625: -- do same as old solution, i.e. same as in else --l_mass_property_flag below.
1626: -- start duplicate cod. strive for one new procedure to be called.
1627: if (g_log_level_rec.statement_level) then
1628: fa_debug_pkg.add(l_calling_fn, 'ccid is null', '', p_log_level_rec => g_log_level_rec);
1629: end if;
1630:
1631: -- get the current distributions
1632: open c_dist_history(l_add_to_asset_id_tbl(i));

Line 1664: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);

1660: l_asset_dist_rec.distribution_id := l_dist_id_tbl(l_dist);
1661: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1662:
1663: if (g_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1666: end if;
1667:
1668: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;

Line 1665: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);

1661: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1662:
1663: if (g_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1666: end if;
1667:
1668: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;
1669:

Line 1714: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);

1710: l_asset_dist_rec.distribution_id := l_dist_id_tbl(l_dist);
1711: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1712:
1713: if (g_log_level_rec.statement_level) then
1714: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1715: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1716: end if;
1717:
1718: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;

Line 1715: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);

1711: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1712:
1713: if (g_log_level_rec.statement_level) then
1714: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units, p_log_level_rec => g_log_level_rec);
1715: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id, p_log_level_rec => g_log_level_rec);
1716: end if;
1717:
1718: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;
1719:

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

1780: where merge_parent_mass_additions_id = l_mass_addition_id_tbl(i);
1781:
1782:
1783: if (g_log_level_rec.statement_level) then
1784: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1785: end if;
1786:
1787: fa_srvr_msg.add_message(
1788: calling_fn => NULL,

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

1803: queue_name = 'ON HOLD'
1804: where mass_addition_id = l_mass_addition_id_tbl(i);
1805:
1806: if (g_log_level_rec.statement_level) then
1807: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1808: end if;
1809:
1810: fa_srvr_msg.add_message(
1811: calling_fn => l_calling_fn,

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

1824: queue_name = 'ON HOLD'
1825: where mass_addition_id = l_mass_addition_id_tbl(i);
1826:
1827: if (g_log_level_rec.statement_level) then
1828: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1829: end if;
1830:
1831: fa_srvr_msg.add_message(
1832: calling_fn => l_calling_fn,

Line 2027: fa_debug_pkg.add(l_calling_fn,

2023:
2024: BEGIN
2025:
2026: if (g_log_level_rec.statement_level) then
2027: fa_debug_pkg.add(l_calling_fn,
2028: 'In do_mass_property',
2029: '', p_log_level_rec => g_log_level_rec);
2030: end if;
2031:

Line 2048: fa_debug_pkg.add(l_calling_fn,

2044: G_last_mp_category_id := p_asset_category_id_tbl(i);
2045: end if;
2046:
2047: if (g_log_level_rec.statement_level) then
2048: fa_debug_pkg.add(l_calling_fn,
2049: 'do_mass_property, entering new mp table loop',
2050: '', p_log_level_rec => g_log_level_rec);
2051: fa_debug_pkg.add(l_calling_fn,
2052: 'do_mass_property, p_asset_category_id_tbl count',

Line 2051: fa_debug_pkg.add(l_calling_fn,

2047: if (g_log_level_rec.statement_level) then
2048: fa_debug_pkg.add(l_calling_fn,
2049: 'do_mass_property, entering new mp table loop',
2050: '', p_log_level_rec => g_log_level_rec);
2051: fa_debug_pkg.add(l_calling_fn,
2052: 'do_mass_property, p_asset_category_id_tbl count',
2053: p_asset_category_id_tbl.count, p_log_level_rec => g_log_level_rec);
2054: fa_debug_pkg.add(l_calling_fn,
2055: 'do_mass_property, G_new_mp_asset_tbl count',

Line 2054: fa_debug_pkg.add(l_calling_fn,

2050: '', p_log_level_rec => g_log_level_rec);
2051: fa_debug_pkg.add(l_calling_fn,
2052: 'do_mass_property, p_asset_category_id_tbl count',
2053: p_asset_category_id_tbl.count, p_log_level_rec => g_log_level_rec);
2054: fa_debug_pkg.add(l_calling_fn,
2055: 'do_mass_property, G_new_mp_asset_tbl count',
2056: G_new_mp_asset_tbl.count, p_log_level_rec => g_log_level_rec);
2057: fa_debug_pkg.add(l_calling_fn,
2058: 'do_mass_property, px_date_placed_in_service_tbl count',

Line 2057: fa_debug_pkg.add(l_calling_fn,

2053: p_asset_category_id_tbl.count, p_log_level_rec => g_log_level_rec);
2054: fa_debug_pkg.add(l_calling_fn,
2055: 'do_mass_property, G_new_mp_asset_tbl count',
2056: G_new_mp_asset_tbl.count, p_log_level_rec => g_log_level_rec);
2057: fa_debug_pkg.add(l_calling_fn,
2058: 'do_mass_property, px_date_placed_in_service_tbl count',
2059: px_date_placed_in_service_tbl.count, p_log_level_rec => g_log_level_rec);
2060:
2061: end if;

Line 2066: fa_debug_pkg.add(l_calling_fn,

2062:
2063: for x in 1..G_new_mp_asset_tbl.count loop
2064:
2065: if (g_log_level_rec.statement_level) then
2066: fa_debug_pkg.add(l_calling_fn,
2067: 'do_mass_property, in global table loop - x value is',
2068: x, p_log_level_rec => g_log_level_rec);
2069: fa_debug_pkg.add(l_calling_fn,
2070: 'do_mass_property, p_asset_category_id_tbl(i)',

Line 2069: fa_debug_pkg.add(l_calling_fn,

2065: if (g_log_level_rec.statement_level) then
2066: fa_debug_pkg.add(l_calling_fn,
2067: 'do_mass_property, in global table loop - x value is',
2068: x, p_log_level_rec => g_log_level_rec);
2069: fa_debug_pkg.add(l_calling_fn,
2070: 'do_mass_property, p_asset_category_id_tbl(i)',
2071: p_asset_category_id_tbl(i));
2072: fa_debug_pkg.add(l_calling_fn,
2073: 'do_mass_property, G_new_mp_asset_tbl(x).category_id',

Line 2072: fa_debug_pkg.add(l_calling_fn,

2068: x, p_log_level_rec => g_log_level_rec);
2069: fa_debug_pkg.add(l_calling_fn,
2070: 'do_mass_property, p_asset_category_id_tbl(i)',
2071: p_asset_category_id_tbl(i));
2072: fa_debug_pkg.add(l_calling_fn,
2073: 'do_mass_property, G_new_mp_asset_tbl(x).category_id',
2074: G_new_mp_asset_tbl(x).category_id);
2075: end if;
2076:

Line 2082: fa_debug_pkg.add(l_calling_fn,

2078: px_date_placed_in_service_tbl(i) between G_new_mp_asset_tbl(x).start_date
2079: and G_new_mp_asset_tbl(x).end_date) then
2080:
2081: if (g_log_level_rec.statement_level) then
2082: fa_debug_pkg.add(l_calling_fn,
2083: 'do_mass_property, match found in global table',
2084: '', p_log_level_rec => g_log_level_rec);
2085: end if;
2086:

Line 2098: fa_debug_pkg.add(l_calling_fn,

2094: -- if not found in array, search posted assets
2095: if (l_mp_asset_indicator = 0) then
2096:
2097: if (g_log_level_rec.statement_level) then
2098: fa_debug_pkg.add(l_calling_fn,
2099: 'do_mass_property, not found in array',
2100: '', p_log_level_rec => g_log_level_rec);
2101: end if;
2102:

Line 2117: fa_debug_pkg.add(l_calling_fn,

2113: -- load the returned value into the global MP asset arrays
2114: l_mp_asset_indicator := G_new_mp_asset_tbl.count + 1;
2115:
2116: if (g_log_level_rec.statement_level) then
2117: fa_debug_pkg.add(l_calling_fn,
2118: 'After mass_property, l_mp_asset_indicator to load global tabe',
2119: l_mp_asset_indicator, p_log_level_rec => g_log_level_rec);
2120: end if;
2121:

Line 2133: fa_debug_pkg.add(l_calling_fn,

2129: G_new_mp_asset_tbl(l_mp_asset_indicator).end_date := mprec.end_date;
2130:
2131:
2132: if (g_log_level_rec.statement_level) then
2133: fa_debug_pkg.add(l_calling_fn,
2134: 'found existing assetid',
2135: mprec.asset_id, p_log_level_rec => g_log_level_rec);
2136: end if;
2137:

Line 2150: fa_debug_pkg.add(l_calling_fn,

2146: l_mp_found := FALSE;
2147: l_mp_asset_indicator := G_new_mp_asset_tbl.count + 1;
2148:
2149: if (g_log_level_rec.statement_level) then
2150: fa_debug_pkg.add(l_calling_fn,
2151: 'do_mass_property, not found in array nor tables',
2152: '', p_log_level_rec => g_log_level_rec);
2153: end if;
2154:

Line 2198: fa_debug_pkg.add(l_calling_fn,

2194: -- derivation code (move in from main block for bulk and allocation)
2195: -- GROUP will always create a new mp-asset, because no adjustments allowed.
2196:
2197: if (g_log_level_rec.statement_level) then
2198: fa_debug_pkg.add(l_calling_fn,
2199: 'do_mass_property, entering main derivation code',
2200: '', p_log_level_rec => g_log_level_rec);
2201: end if;
2202:

Line 2207: fa_debug_pkg.add(l_calling_fn,

2203: if (l_mp_found = TRUE and
2204: p_asset_type_tbl(i) <> 'GROUP') then
2205:
2206: if (g_log_level_rec.statement_level) then
2207: fa_debug_pkg.add(l_calling_fn,
2208: 'do_mass_property, mp found and capitalized',
2209: '', p_log_level_rec => g_log_level_rec);
2210: end if;
2211:

Line 2230: fa_debug_pkg.add(l_calling_fn,

2226: else -- mp asset not found is null or group asset
2227:
2228: -- fix for bug 2723293
2229: if (g_log_level_rec.statement_level) then
2230: fa_debug_pkg.add(l_calling_fn,
2231: 'After do_mass_property, dpis',
2232: px_date_placed_in_service_tbl(i));
2233: fa_debug_pkg.add(l_calling_fn,
2234: 'After do_mass_property, asset_type',

Line 2233: fa_debug_pkg.add(l_calling_fn,

2229: if (g_log_level_rec.statement_level) then
2230: fa_debug_pkg.add(l_calling_fn,
2231: 'After do_mass_property, dpis',
2232: px_date_placed_in_service_tbl(i));
2233: fa_debug_pkg.add(l_calling_fn,
2234: 'After do_mass_property, asset_type',
2235: p_asset_type_tbl(i));
2236: end if;
2237:

Line 2252: fa_debug_pkg.add(l_calling_fn,

2248: px_description_tbl(i) := G_new_mp_asset_tbl(l_mp_asset_indicator).description;
2249: px_date_placed_in_service_tbl(i) := G_new_mp_asset_tbl(l_mp_asset_indicator).date_placed_in_service;
2250:
2251: if (g_log_level_rec.statement_level) then
2252: fa_debug_pkg.add(l_calling_fn,
2253: 'After mass_property, amort_start_date',
2254: px_amortization_start_date_tbl(i));
2255: fa_debug_pkg.add(l_calling_fn,
2256: 'After mass_property, dpis',

Line 2255: fa_debug_pkg.add(l_calling_fn,

2251: if (g_log_level_rec.statement_level) then
2252: fa_debug_pkg.add(l_calling_fn,
2253: 'After mass_property, amort_start_date',
2254: px_amortization_start_date_tbl(i));
2255: fa_debug_pkg.add(l_calling_fn,
2256: 'After mass_property, dpis',
2257: px_date_placed_in_service_tbl(i));
2258: end if;
2259:

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

2407: end if;
2408: end if;
2409:
2410: if(g_log_level_rec.statement_level) then
2411: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation', p_log_level_rec => g_log_level_rec);
2412: end if;
2413:
2414: x_return_status := 0;
2415:

Line 2446: fa_debug_pkg.add(l_calling_fn,

2442:
2443:
2444:
2445: if (g_log_level_rec.statement_level) then
2446: fa_debug_pkg.add(l_calling_fn,
2447: 'Calling do_mass_property',
2448: '', p_log_level_rec => g_log_level_rec);
2449: end if;
2450:

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

2650:
2651: end if;
2652:
2653: if (g_log_level_rec.statement_level) then
2654: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_mass_addition_trxs', sql%rowcount);
2655: end if;
2656:
2657: commit;
2658: