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 663: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,

659:
660: if (g_times_called = 1) then
661:
662: if (g_log_level_rec.statement_level) then
663: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,
664: p_log_level_rec => g_log_level_rec);
665: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode,
666: p_log_level_rec => g_log_level_rec);
667: end if;

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

661:
662: if (g_log_level_rec.statement_level) then
663: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code,
664: p_log_level_rec => g_log_level_rec);
665: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode,
666: p_log_level_rec => g_log_level_rec);
667: end if;
668:
669: end if;

Line 869: FA_DEBUG_PKG.Initialize;

865:
866: savepoint famapt;
867:
868: -- clear the debug stack for each asset
869: FA_DEBUG_PKG.Initialize;
870: -- reset the message level to prevent bogus errors
871: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
872:
873: BEGIN -- start asset level block

Line 1220: fa_debug_pkg.add(l_calling_fn,

1216:
1217: if (l_add_to_asset_id_tbl(i) is null) then
1218:
1219: if (g_log_level_rec.statement_level) then
1220: fa_debug_pkg.add(l_calling_fn,
1221: 'Regular addition',
1222: l_asset_id_tbl(i),
1223: p_log_level_rec => g_log_level_rec);
1224: end if;

Line 1384: fa_debug_pkg.add(l_calling_fn,

1380:
1381: else -- add_to_asset_id populated for adj
1382:
1383: if (g_log_level_rec.statement_level) then
1384: fa_debug_pkg.add(l_calling_fn,
1385: 'Add to asset_id',
1386: l_add_to_asset_id_tbl(i),
1387: p_log_level_rec => g_log_level_rec);
1388: end if;

Line 1484: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,

1480: end if;
1481:
1482: if l_mass_property_flag_tbl(i) = 'Y' then
1483: if (g_log_level_rec.statement_level) then
1484: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1485: p_log_level_rec => g_log_level_rec);
1486: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1487: p_log_level_rec => g_log_level_rec);
1488: end if;

Line 1486: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,

1482: if l_mass_property_flag_tbl(i) = 'Y' then
1483: if (g_log_level_rec.statement_level) then
1484: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1485: p_log_level_rec => g_log_level_rec);
1486: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1487: p_log_level_rec => g_log_level_rec);
1488: end if;
1489:
1490: open c_distributions(p_massadd_id => l_mass_addition_id_tbl(i));

Line 1500: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist bulkfetch', '',

1496:
1497: close c_distributions;
1498:
1499: if (g_log_level_rec.statement_level) then
1500: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist bulkfetch', '',
1501: p_log_level_rec => g_log_level_rec);
1502: end if;
1503:
1504: for l_md in 1..l_mad_units_tbl.count loop

Line 1506: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist loop', l_md,

1502: end if;
1503:
1504: for l_md in 1..l_mad_units_tbl.count loop
1505: if (g_log_level_rec.statement_level) then
1506: fa_debug_pkg.add(l_calling_fn, 'After massadd_dist loop', l_md,
1507: p_log_level_rec => g_log_level_rec);
1508: end if;
1509:
1510: if l_mad_deprn_expense_ccid_tbl(l_md) is not null then

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

1509:
1510: if l_mad_deprn_expense_ccid_tbl(l_md) is not null then
1511:
1512: if (g_log_level_rec.statement_level) then
1513: fa_debug_pkg.add(l_calling_fn, 'mad ccid is not null', l_mad_deprn_expense_ccid_tbl(l_md),
1514: p_log_level_rec => g_log_level_rec);
1515: end if;
1516:
1517: 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));

Line 1533: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units,

1529: l_asset_dist_rec.transaction_units := l_mad_units_tbl(l_md);
1530: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1531:
1532: if (g_log_level_rec.statement_level) then
1533: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units,
1534: p_log_level_rec => g_log_level_rec);
1535: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id,
1536: p_log_level_rec => g_log_level_rec);
1537: end if;

Line 1535: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id,

1531:
1532: if (g_log_level_rec.statement_level) then
1533: fa_debug_pkg.add(l_calling_fn, 'c_dh found trans_units', l_asset_dist_rec.transaction_units,
1534: p_log_level_rec => g_log_level_rec);
1535: fa_debug_pkg.add(l_calling_fn, 'c_dh found distid', l_asset_dist_rec.distribution_id,
1536: p_log_level_rec => g_log_level_rec);
1537: end if;
1538:
1539: else -- dist doesn't exist

Line 1549: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units,

1545: l_asset_dist_rec.location_ccid := l_mad_location_id_tbl(l_md);
1546: l_asset_dist_tbl(l_md) := l_asset_dist_rec;
1547:
1548: if (g_log_level_rec.statement_level) then
1549: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units,
1550: p_log_level_rec => g_log_level_rec);
1551: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid,
1552: p_log_level_rec => g_log_level_rec);
1553: end if;

Line 1551: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid,

1547:
1548: if (g_log_level_rec.statement_level) then
1549: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound trans_units', l_asset_dist_rec.transaction_units,
1550: p_log_level_rec => g_log_level_rec);
1551: fa_debug_pkg.add(l_calling_fn, 'c_dh notfound ccid', l_asset_dist_rec.expense_ccid,
1552: p_log_level_rec => g_log_level_rec);
1553: end if;
1554: end if; -- c_dh
1555: close c_dh;

Line 1560: fa_debug_pkg.add(l_calling_fn, 'ccid is null', '',

1556: else -- ccid is null
1557: -- do same as old solution, i.e. same as in else --l_mass_property_flag below.
1558: -- start duplicate cod. strive for one new procedure to be called.
1559: if (g_log_level_rec.statement_level) then
1560: fa_debug_pkg.add(l_calling_fn, 'ccid is null', '',
1561: p_log_level_rec => g_log_level_rec);
1562: end if;
1563:
1564: -- get the current distributions

Line 1597: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,

1593: l_asset_dist_rec.distribution_id := l_dist_id_tbl(l_dist);
1594: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1595:
1596: if (g_log_level_rec.statement_level) then
1597: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1598: p_log_level_rec => g_log_level_rec);
1599: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1600: p_log_level_rec => g_log_level_rec);
1601: end if;

Line 1599: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,

1595:
1596: if (g_log_level_rec.statement_level) then
1597: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1598: p_log_level_rec => g_log_level_rec);
1599: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1600: p_log_level_rec => g_log_level_rec);
1601: end if;
1602:
1603: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;

Line 1649: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,

1645: l_asset_dist_rec.distribution_id := l_dist_id_tbl(l_dist);
1646: l_asset_dist_rec.transaction_units := l_dist_units_tbl(l_dist);
1647:
1648: if (g_log_level_rec.statement_level) then
1649: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1650: p_log_level_rec => g_log_level_rec);
1651: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1652: p_log_level_rec => g_log_level_rec);
1653: end if;

Line 1651: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,

1647:
1648: if (g_log_level_rec.statement_level) then
1649: fa_debug_pkg.add(l_calling_fn, 'trans_units', l_asset_dist_rec.transaction_units,
1650: p_log_level_rec => g_log_level_rec);
1651: fa_debug_pkg.add(l_calling_fn, 'distid', l_asset_dist_rec.distribution_id,
1652: p_log_level_rec => g_log_level_rec);
1653: end if;
1654:
1655: l_asset_dist_tbl(l_dist) := l_asset_dist_rec;

Line 1839: FA_DEBUG_PKG.Initialize;

1835:
1836:
1837: commit;
1838:
1839: FA_DEBUG_PKG.Initialize;
1840:
1841: x_return_status := 0;
1842:
1843:

Line 1934: fa_debug_pkg.add(l_calling_fn,

1930:
1931: BEGIN
1932:
1933: if (p_log_level_rec.statement_level) then
1934: fa_debug_pkg.add(l_calling_fn,
1935: 'In do_mass_property',
1936: '',
1937: p_log_level_rec => p_log_level_rec);
1938: end if;

Line 1951: fa_debug_pkg.add(l_calling_fn,

1947: -- thus we can clear global arrays when category or FY changes
1948: -- fy is unlikely as most assets would be current period / year
1949:
1950: if (p_log_level_rec.statement_level) then
1951: fa_debug_pkg.add(l_calling_fn,
1952: 'do_mass_property, checking category match',
1953: '',
1954: p_log_level_rec => p_log_level_rec);
1955: end if;

Line 1963: fa_debug_pkg.add(l_calling_fn,

1959: G_last_mp_category_id := p_asset_category_id_tbl(i);
1960: end if;
1961:
1962: if (p_log_level_rec.statement_level) then
1963: fa_debug_pkg.add(l_calling_fn,
1964: 'do_mass_property, entering new mp table loop',
1965: '',
1966: p_log_level_rec => p_log_level_rec);
1967: fa_debug_pkg.add(l_calling_fn,

Line 1967: fa_debug_pkg.add(l_calling_fn,

1963: fa_debug_pkg.add(l_calling_fn,
1964: 'do_mass_property, entering new mp table loop',
1965: '',
1966: p_log_level_rec => p_log_level_rec);
1967: fa_debug_pkg.add(l_calling_fn,
1968: 'do_mass_property, p_asset_category_id_tbl count',
1969: p_asset_category_id_tbl.count,
1970: p_log_level_rec => p_log_level_rec);
1971: fa_debug_pkg.add(l_calling_fn,

Line 1971: fa_debug_pkg.add(l_calling_fn,

1967: fa_debug_pkg.add(l_calling_fn,
1968: 'do_mass_property, p_asset_category_id_tbl count',
1969: p_asset_category_id_tbl.count,
1970: p_log_level_rec => p_log_level_rec);
1971: fa_debug_pkg.add(l_calling_fn,
1972: 'do_mass_property, G_new_mp_asset_tbl count',
1973: G_new_mp_asset_tbl.count,
1974: p_log_level_rec => p_log_level_rec);
1975: fa_debug_pkg.add(l_calling_fn,

Line 1975: fa_debug_pkg.add(l_calling_fn,

1971: fa_debug_pkg.add(l_calling_fn,
1972: 'do_mass_property, G_new_mp_asset_tbl count',
1973: G_new_mp_asset_tbl.count,
1974: p_log_level_rec => p_log_level_rec);
1975: fa_debug_pkg.add(l_calling_fn,
1976: 'do_mass_property, px_date_placed_in_service_tbl count',
1977: px_date_placed_in_service_tbl.count,
1978: p_log_level_rec => p_log_level_rec);
1979:

Line 1985: fa_debug_pkg.add(l_calling_fn,

1981:
1982: for x in 1..G_new_mp_asset_tbl.count loop
1983:
1984: if (p_log_level_rec.statement_level) then
1985: fa_debug_pkg.add(l_calling_fn,
1986: 'do_mass_property, in global table loop - x value is',
1987: x,
1988: p_log_level_rec => p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn,

Line 1989: fa_debug_pkg.add(l_calling_fn,

1985: fa_debug_pkg.add(l_calling_fn,
1986: 'do_mass_property, in global table loop - x value is',
1987: x,
1988: p_log_level_rec => p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn,
1990: 'do_mass_property, p_asset_category_id_tbl(i)',
1991: p_asset_category_id_tbl(i),
1992: p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add(l_calling_fn,

Line 1993: fa_debug_pkg.add(l_calling_fn,

1989: fa_debug_pkg.add(l_calling_fn,
1990: 'do_mass_property, p_asset_category_id_tbl(i)',
1991: p_asset_category_id_tbl(i),
1992: p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add(l_calling_fn,
1994: 'do_mass_property, G_new_mp_asset_tbl(x).category_id',
1995: G_new_mp_asset_tbl(x).category_id,
1996: p_log_level_rec => p_log_level_rec);
1997: end if;

Line 2004: fa_debug_pkg.add(l_calling_fn,

2000: px_date_placed_in_service_tbl(i) between G_new_mp_asset_tbl(x).start_date
2001: and G_new_mp_asset_tbl(x).end_date) then
2002:
2003: if (p_log_level_rec.statement_level) then
2004: fa_debug_pkg.add(l_calling_fn,
2005: 'do_mass_property, match found in global table',
2006: '',
2007: p_log_level_rec => p_log_level_rec);
2008: end if;

Line 2021: fa_debug_pkg.add(l_calling_fn,

2017: -- if not found in array, search posted assets
2018: if (l_mp_asset_indicator = 0) then
2019:
2020: if (p_log_level_rec.statement_level) then
2021: fa_debug_pkg.add(l_calling_fn,
2022: 'do_mass_property, not found in array',
2023: '',
2024: p_log_level_rec => p_log_level_rec);
2025: end if;

Line 2042: fa_debug_pkg.add(l_calling_fn,

2038: -- load the returned value into the global MP asset arrays
2039: l_mp_asset_indicator := G_new_mp_asset_tbl.count + 1;
2040:
2041: if (p_log_level_rec.statement_level) then
2042: fa_debug_pkg.add(l_calling_fn,
2043: 'After mass_property, l_mp_asset_indicator to load global tabe',
2044: l_mp_asset_indicator,
2045: p_log_level_rec => p_log_level_rec);
2046: end if;

Line 2058: fa_debug_pkg.add(l_calling_fn,

2054: G_new_mp_asset_tbl(l_mp_asset_indicator).start_date := mprec.start_date;
2055: G_new_mp_asset_tbl(l_mp_asset_indicator).end_date := mprec.end_date;
2056:
2057: if (p_log_level_rec.statement_level) then
2058: fa_debug_pkg.add(l_calling_fn,
2059: 'found existing assetid',
2060: mprec.asset_id,
2061: p_log_level_rec => p_log_level_rec);
2062: end if;

Line 2076: fa_debug_pkg.add(l_calling_fn,

2072: l_mp_found := FALSE;
2073: l_mp_asset_indicator := G_new_mp_asset_tbl.count + 1;
2074:
2075: if (p_log_level_rec.statement_level) then
2076: fa_debug_pkg.add(l_calling_fn,
2077: 'do_mass_property, not found in array nor tables',
2078: '',
2079: p_log_level_rec => p_log_level_rec);
2080: end if;

Line 2125: fa_debug_pkg.add(l_calling_fn,

2121:
2122: -- derivation code (move in from main block for bulk and allocation)
2123: -- GROUP will always create a new mp-asset, because no adjustments allowed.
2124: if (p_log_level_rec.statement_level) then
2125: fa_debug_pkg.add(l_calling_fn,
2126: 'do_mass_property, entering main derivation code',
2127: '',
2128: p_log_level_rec => p_log_level_rec);
2129: end if;

Line 2135: fa_debug_pkg.add(l_calling_fn,

2131: if (l_mp_found = TRUE and
2132: p_asset_type_tbl(i) <> 'GROUP') then
2133:
2134: if (p_log_level_rec.statement_level) then
2135: fa_debug_pkg.add(l_calling_fn,
2136: 'do_mass_property, mp found and capitalized',
2137: '',
2138: p_log_level_rec => p_log_level_rec);
2139: end if;

Line 2160: fa_debug_pkg.add(l_calling_fn,

2156: else -- mp asset not found is null or group asset
2157:
2158: -- fix for bug 2723293
2159: if (p_log_level_rec.statement_level) then
2160: fa_debug_pkg.add(l_calling_fn,
2161: 'After do_mass_property, dpis',
2162: px_date_placed_in_service_tbl(i),
2163: p_log_level_rec => p_log_level_rec);
2164: fa_debug_pkg.add(l_calling_fn,

Line 2164: fa_debug_pkg.add(l_calling_fn,

2160: fa_debug_pkg.add(l_calling_fn,
2161: 'After do_mass_property, dpis',
2162: px_date_placed_in_service_tbl(i),
2163: p_log_level_rec => p_log_level_rec);
2164: fa_debug_pkg.add(l_calling_fn,
2165: 'After do_mass_property, asset_type',
2166: p_asset_type_tbl(i),
2167: p_log_level_rec => p_log_level_rec);
2168: end if;

Line 2184: fa_debug_pkg.add(l_calling_fn,

2180: px_description_tbl(i) := G_new_mp_asset_tbl(l_mp_asset_indicator).description;
2181: px_date_placed_in_service_tbl(i) := G_new_mp_asset_tbl(l_mp_asset_indicator).date_placed_in_service;
2182:
2183: if (p_log_level_rec.statement_level) then
2184: fa_debug_pkg.add(l_calling_fn,
2185: 'After mass_property, amort_start_date',
2186: px_amortization_start_date_tbl(i),
2187: p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.add(l_calling_fn,

Line 2188: fa_debug_pkg.add(l_calling_fn,

2184: fa_debug_pkg.add(l_calling_fn,
2185: 'After mass_property, amort_start_date',
2186: px_amortization_start_date_tbl(i),
2187: p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.add(l_calling_fn,
2189: 'After mass_property, dpis',
2190: px_date_placed_in_service_tbl(i),
2191: p_log_level_rec => p_log_level_rec);
2192: end if;

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

2341: end if;
2342: end if;
2343:
2344: if(g_log_level_rec.statement_level) then
2345: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation',
2346: p_log_level_rec => g_log_level_rec);
2347: end if;
2348:
2349: x_return_status := 0;

Line 2381: fa_debug_pkg.add(l_calling_fn,

2377:
2378:
2379:
2380: if (g_log_level_rec.statement_level) then
2381: fa_debug_pkg.add(l_calling_fn,
2382: 'Calling do_mass_property',
2383: '',
2384: p_log_level_rec => g_log_level_rec);
2385: end if;

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

2560:
2561: end if;
2562:
2563: if (g_log_level_rec.statement_level) then
2564: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_mass_addition_trxs', sql%rowcount,
2565: p_log_level_rec => g_log_level_rec);
2566: end if;
2567:
2568: commit;