946: return true;
947:
948: EXCEPTION
949: when error_found then
950: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_fin_rec', p_log_level_rec => p_log_level_rec);
951: return false;
952:
953: when others then
954: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_fin_rec', p_log_level_rec => p_log_level_rec);
950: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_fin_rec', p_log_level_rec => p_log_level_rec);
951: return false;
952:
953: when others then
954: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_fin_rec', p_log_level_rec => p_log_level_rec);
955: return false;
956:
957: END get_asset_fin_rec;
958:
1014: return true;
1015:
1016: EXCEPTION
1017: when error_found then
1018: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_deprn_rec', p_log_level_rec => p_log_level_rec);
1019: return false;
1020:
1021: when others then
1022: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_deprn_rec', p_log_level_rec => p_log_level_rec);
1018: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_deprn_rec', p_log_level_rec => p_log_level_rec);
1019: return false;
1020:
1021: when others then
1022: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_deprn_rec', p_log_level_rec => p_log_level_rec);
1023: return false;
1024:
1025: END get_asset_deprn_rec;
1026:
1126: return true;
1127:
1128: EXCEPTION
1129: when others then
1130: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_cat_rec', p_log_level_rec => p_log_level_rec);
1131: return false;
1132:
1133: END get_asset_cat_rec;
1134:
1156: return true;
1157:
1158: EXCEPTION
1159: when others then
1160: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_type_rec', p_log_level_rec => p_log_level_rec);
1161: return false;
1162:
1163: END get_asset_type_rec;
1164:
1332:
1333: exception
1334: when no_data_found then null;
1335: when others then
1336: fa_srvr_msg.add_sql_error (
1337: calling_fn => 'fa_util_pvt.get_asset_desc_rec', p_log_level_rec => p_log_level_rec);
1338: return false;
1339: end;
1340:
1348: exception
1349: when no_data_found then
1350: px_asset_desc_rec.warranty_id := NULL;
1351: when others then
1352: fa_srvr_msg.add_sql_error (
1353: calling_fn => 'fa_util_pvt.get_asset_desc_rec', p_log_level_rec => p_log_level_rec);
1354: return false;
1355: end;
1356:
1356:
1357: return true;
1358: EXCEPTION
1359: when others then
1360: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_desc_rec', p_log_level_rec => p_log_level_rec);
1361: return false;
1362:
1363: END get_asset_desc_rec;
1364:
1815: return true;
1816:
1817: EXCEPTION
1818: when error_found then
1819: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1820: return false;
1821:
1822: when no_data_found then
1823: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec',p_log_level_rec => p_log_level_rec);
1819: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1820: return false;
1821:
1822: when no_data_found then
1823: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec',p_log_level_rec => p_log_level_rec);
1824: fa_srvr_msg.add_message(name => 'FA_MASSADD_INVOICE',
1825: token1 => 'SOURCE_LINE_ID',
1826: value1 => px_inv_rec.source_line_id,
1827: calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1820: return false;
1821:
1822: when no_data_found then
1823: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec',p_log_level_rec => p_log_level_rec);
1824: fa_srvr_msg.add_message(name => 'FA_MASSADD_INVOICE',
1825: token1 => 'SOURCE_LINE_ID',
1826: value1 => px_inv_rec.source_line_id,
1827: calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1828: return false;
1827: calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1828: return false;
1829:
1830: when others then
1831: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec', p_log_level_rec => p_log_level_rec);
1832: return false;
1833:
1834: END get_inv_rec;
1835:
1884:
1885: EXCEPTION
1886:
1887: when others then
1888: fa_srvr_msg.add_sql_error(
1889: calling_fn => 'fa_util_pvt.check_asset_key_req', p_log_level_rec => p_log_level_rec);
1890: return FALSE;
1891:
1892: END check_asset_key_req;
1911: EXCEPTION
1912:
1913: when others then
1914:
1915: fa_srvr_msg.add_message(
1916: calling_fn => 'fa_util_pvt.get_current_units',
1917: name => 'FA_SHARED_ACTION_TABLE',
1918: token1 => 'ACTION',
1919: value1 => 'SELECT',
1954: return TRUE;
1955:
1956: EXCEPTION
1957: when others then
1958: fa_srvr_msg.add_message(
1959: calling_fn => 'fa_util_pvt.get_latest_trans_date',
1960: name => 'FA_SHARED_ACTION_TABLE',
1961: token1 => 'ACTION',
1962: value1 => 'SELECT',
2007: return TRUE;
2008:
2009: EXCEPTION
2010: when error_found then
2011: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_period_rec', p_log_level_rec => p_log_level_rec);
2012: return false;
2013:
2014: when others then
2015: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_period_rec', p_log_level_rec => p_log_level_rec);
2011: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_period_rec', p_log_level_rec => p_log_level_rec);
2012: return false;
2013:
2014: when others then
2015: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_period_rec', p_log_level_rec => p_log_level_rec);
2016: return false;
2017:
2018: END get_period_rec;
2019:
2255:
2256:
2257: EXCEPTION
2258: when error_found then
2259: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_retire_rec', p_log_level_rec => p_log_level_rec);
2260: return false;
2261:
2262: when others then
2263: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_retire_rec', p_log_level_rec => p_log_level_rec);
2259: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_retire_rec', p_log_level_rec => p_log_level_rec);
2260: return false;
2261:
2262: when others then
2263: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_retire_rec', p_log_level_rec => p_log_level_rec);
2264: return false;
2265:
2266: END get_asset_retire_rec;
2267:
2284: return TRUE;
2285:
2286: EXCEPTION
2287: when others then
2288: fa_srvr_msg.add_message(
2289: calling_fn => 'fa_util_pvt.get_corp_book',
2290: name => 'FA_SHARED_ACTION_TABLE',
2291: token1 => 'ACTION',
2292: value1 => 'SELECT',
2379: if not fa_cache_pkg.fazcsob
2380: (X_set_of_books_id => h_set_of_books_id,
2381: X_mrc_sob_type_code => h_mrc_sob_type_code,
2382: p_log_level_rec => p_log_level_rec) then
2383: fa_srvr_msg.add_sql_error
2384: (calling_fn => 'fa_util_pvt.check_deprn_run', p_log_level_rec => p_log_level_rec);
2385: return(FALSE);
2386: end if;
2387: