DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_UTIL_PVT

Line 1: PACKAGE BODY FA_UTIL_PVT as

1: PACKAGE BODY FA_UTIL_PVT as
2: /* $Header: FAVUTILB.pls 120.20.12010000.2 2008/12/19 08:34:14 rjayaraj ship $ */
3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

Line 897: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_fin_rec'

893: return true;
894:
895: EXCEPTION
896: when error_found then
897: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_fin_rec'
898: ,p_log_level_rec => p_log_level_rec);
899: return false;
900:
901: when others then

Line 902: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_fin_rec'

898: ,p_log_level_rec => p_log_level_rec);
899: return false;
900:
901: when others then
902: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_fin_rec'
903: ,p_log_level_rec => p_log_level_rec);
904: return false;
905:
906: END get_asset_fin_rec;

Line 933: X_CALLING_FN => 'FA_UTIL_PVT.get_asset_deprn_rec',

929: X_DPR_ROW => l_dpr,
930: X_RUN_MODE => 'STANDARD',
931: X_DEBUG => FALSE,
932: X_SUCCESS => l_status,
933: X_CALLING_FN => 'FA_UTIL_PVT.get_asset_deprn_rec',
934: X_TRANSACTION_HEADER_ID => -1,
935: p_log_level_rec => p_log_level_rec);
936:
937: if (NOT l_status) then

Line 962: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_deprn_rec'

958: return true;
959:
960: EXCEPTION
961: when error_found then
962: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_deprn_rec'
963: ,p_log_level_rec => p_log_level_rec);
964: return false;
965:
966: when others then

Line 967: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_deprn_rec'

963: ,p_log_level_rec => p_log_level_rec);
964: return false;
965:
966: when others then
967: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_deprn_rec'
968: ,p_log_level_rec => p_log_level_rec);
969: return false;
970:
971: END get_asset_deprn_rec;

Line 1075: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_cat_rec'

1071: return true;
1072:
1073: EXCEPTION
1074: when others then
1075: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_cat_rec'
1076: ,p_log_level_rec => p_log_level_rec);
1077: return false;
1078:
1079: END get_asset_cat_rec;

Line 1105: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_type_rec'

1101: return true;
1102:
1103: EXCEPTION
1104: when others then
1105: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_type_rec'
1106: ,p_log_level_rec => p_log_level_rec);
1107: return false;
1108:
1109: END get_asset_type_rec;

Line 1283: calling_fn => 'fa_util_pvt.get_asset_desc_rec'

1279: exception
1280: when no_data_found then null;
1281: when others then
1282: fa_srvr_msg.add_sql_error (
1283: calling_fn => 'fa_util_pvt.get_asset_desc_rec'
1284: ,p_log_level_rec => p_log_level_rec);
1285: return false;
1286: end;
1287:

Line 1300: calling_fn => 'fa_util_pvt.get_asset_desc_rec'

1296: when no_data_found then
1297: px_asset_desc_rec.warranty_id := NULL;
1298: when others then
1299: fa_srvr_msg.add_sql_error (
1300: calling_fn => 'fa_util_pvt.get_asset_desc_rec'
1301: ,p_log_level_rec => p_log_level_rec);
1302: return false;
1303: end;
1304:

Line 1308: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_desc_rec'

1304:
1305: return true;
1306: EXCEPTION
1307: when others then
1308: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_desc_rec'
1309: ,p_log_level_rec => p_log_level_rec);
1310: return false;
1311:
1312: END get_asset_desc_rec;

Line 1742: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_inv_rec'

1738: return true;
1739:
1740: EXCEPTION
1741: when error_found then
1742: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_inv_rec'
1743: ,p_log_level_rec => p_log_level_rec);
1744: return false;
1745:
1746: when no_data_found then

Line 1747: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec'

1743: ,p_log_level_rec => p_log_level_rec);
1744: return false;
1745:
1746: when no_data_found then
1747: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec'
1748: ,p_log_level_rec => p_log_level_rec);
1749: fa_srvr_msg.add_message(name => 'FA_MASSADD_INVOICE',
1750: token1 => 'SOURCE_LINE_ID',
1751: value1 => px_inv_rec.source_line_id,

Line 1752: calling_fn => 'fa_util_pvt.get_inv_rec'

1748: ,p_log_level_rec => p_log_level_rec);
1749: fa_srvr_msg.add_message(name => 'FA_MASSADD_INVOICE',
1750: token1 => 'SOURCE_LINE_ID',
1751: value1 => px_inv_rec.source_line_id,
1752: calling_fn => 'fa_util_pvt.get_inv_rec'
1753: ,p_log_level_rec => p_log_level_rec);
1754: return false;
1755:
1756: when others then

Line 1757: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec'

1753: ,p_log_level_rec => p_log_level_rec);
1754: return false;
1755:
1756: when others then
1757: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_inv_rec'
1758: ,p_log_level_rec => p_log_level_rec);
1759: return false;
1760:
1761: END get_inv_rec;

Line 1816: calling_fn => 'fa_util_pvt.check_asset_key_req'

1812: EXCEPTION
1813:
1814: when others then
1815: fa_srvr_msg.add_sql_error(
1816: calling_fn => 'fa_util_pvt.check_asset_key_req'
1817: ,p_log_level_rec => p_log_level_rec);
1818: return FALSE;
1819:
1820: END check_asset_key_req;

Line 1844: calling_fn => 'fa_util_pvt.get_current_units',

1840:
1841: when others then
1842:
1843: fa_srvr_msg.add_message(
1844: calling_fn => 'fa_util_pvt.get_current_units',
1845: name => 'FA_SHARED_ACTION_TABLE',
1846: token1 => 'ACTION',
1847: value1 => 'SELECT',
1848: token2 => 'TABLE',

Line 1888: calling_fn => 'fa_util_pvt.get_latest_trans_date',

1884:
1885: EXCEPTION
1886: when others then
1887: fa_srvr_msg.add_message(
1888: calling_fn => 'fa_util_pvt.get_latest_trans_date',
1889: name => 'FA_SHARED_ACTION_TABLE',
1890: token1 => 'ACTION',
1891: value1 => 'SELECT',
1892: token2 => 'TABLE',

Line 1951: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_period_rec'

1947: return TRUE;
1948:
1949: EXCEPTION
1950: when error_found then
1951: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_period_rec'
1952: ,p_log_level_rec => p_log_level_rec);
1953: return false;
1954:
1955: when others then

Line 1956: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_period_rec'

1952: ,p_log_level_rec => p_log_level_rec);
1953: return false;
1954:
1955: when others then
1956: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_period_rec'
1957: ,p_log_level_rec => p_log_level_rec);
1958: return false;
1959:
1960: END get_period_rec;

Line 2199: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_retire_rec'

2195:
2196:
2197: EXCEPTION
2198: when error_found then
2199: fa_srvr_msg.add_message(calling_fn => 'fa_util_pvt.get_asset_retire_rec'
2200: ,p_log_level_rec => p_log_level_rec);
2201: return false;
2202:
2203: when others then

Line 2204: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_retire_rec'

2200: ,p_log_level_rec => p_log_level_rec);
2201: return false;
2202:
2203: when others then
2204: fa_srvr_msg.add_sql_error(calling_fn => 'fa_util_pvt.get_asset_retire_rec'
2205: ,p_log_level_rec => p_log_level_rec);
2206: return false;
2207:
2208: END get_asset_retire_rec;

Line 2231: calling_fn => 'fa_util_pvt.get_corp_book',

2227:
2228: EXCEPTION
2229: when others then
2230: fa_srvr_msg.add_message(
2231: calling_fn => 'fa_util_pvt.get_corp_book',
2232: name => 'FA_SHARED_ACTION_TABLE',
2233: token1 => 'ACTION',
2234: value1 => 'SELECT',
2235: token2 => 'TABLE',

Line 2322: (calling_fn => 'fa_util_pvt.check_deprn_run', p_log_level_rec => p_log_level_rec);

2318: BEGIN
2319:
2320: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
2321: fa_srvr_msg.add_sql_error
2322: (calling_fn => 'fa_util_pvt.check_deprn_run', p_log_level_rec => p_log_level_rec);
2323: return (FALSE);
2324: end if;
2325:
2326: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;

Line 2334: (calling_fn => 'fa_util_pvt.check_deprn_run', p_log_level_rec => p_log_level_rec);

2330: (X_set_of_books_id => h_set_of_books_id,
2331: X_mrc_sob_type_code => h_mrc_sob_type_code,
2332: p_log_level_rec => p_log_level_rec) then
2333: fa_srvr_msg.add_sql_error
2334: (calling_fn => 'fa_util_pvt.check_deprn_run', p_log_level_rec => p_log_level_rec);
2335: return(FALSE);
2336: end if;
2337:
2338: if (X_asset_id = 0) then

Line 2404: END FA_UTIL_PVT;

2400: Exception
2401: When NO_DATA_FOUND then
2402: return FALSE;
2403: END check_deprn_run;
2404: END FA_UTIL_PVT;