[Home] [Help]
1: PACKAGE BODY FA_ADDITION_PVT AS
2: /* $Header: FAVADDB.pls 120.64.12020000.5 2013/04/08 09:40:01 gigupta ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
130: elsif ((px_trans_rec.amortization_start_date is null) AND
131: (px_trans_rec.transaction_subtype is not null)) then
132:
133: fa_srvr_msg.add_message(
134: calling_fn => 'fa_addition_pvt.initialize',
135: name => 'FA_INVALID_PARAMETER',
136: token1 => 'VALUE',
137: value1 => px_trans_rec.transaction_subtype,
138: token2 => 'PARAM',
138: token2 => 'PARAM',
139: value2 => 'TRANSACTION_SUBTYPE', p_log_level_rec => p_log_level_rec);
140:
141: fa_srvr_msg.add_message(
142: calling_fn => 'fa_addition_pvt.initialize',
143: name => 'FA_INVALID_PARAMETER',
144: token1 => 'VALUE',
145: value1 => 'NULL',
146: token2 => 'PARAM',
403: if px_asset_desc_rec.global_desc_flex.attribute_category_code is not null and
404: px_trans_rec.calling_interface = 'FAMAPT'then
405: l_return_status := JG_GLOBE_FLEX_VAL.reassign_context_code(px_asset_desc_rec.global_desc_flex.attribute_category_code);
406: if not (l_return_status) then
407: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize'
408: ,name => 'FA_NOT_VALID_GDF'
409: ,token1 => 'ASSET_NUMBER',
410: value1 => px_asset_hdr_rec.asset_id
411: ,p_log_level_rec => p_log_level_rec);
666: --Call validate disabled_flag to confirm default group is not disabled
667: if NOT FA_ASSET_VAL_PVT.validate_group_info
668: (p_group_asset_id => fa_cache_pkg.fazccbd_record.group_asset_id,
669: p_book_type_code => px_asset_hdr_rec.book_type_code,
670: p_calling_fn => 'fa_addition_pvt.initialize', p_log_level_rec => p_log_level_rec) then
671: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
672: name => 'FA_DISABLED_DEFAULT_GROUP', p_log_level_rec => p_log_level_rec);
673: raise init_err;
674: end if;
667: if NOT FA_ASSET_VAL_PVT.validate_group_info
668: (p_group_asset_id => fa_cache_pkg.fazccbd_record.group_asset_id,
669: p_book_type_code => px_asset_hdr_rec.book_type_code,
670: p_calling_fn => 'fa_addition_pvt.initialize', p_log_level_rec => p_log_level_rec) then
671: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
672: name => 'FA_DISABLED_DEFAULT_GROUP', p_log_level_rec => p_log_level_rec);
673: raise init_err;
674: end if;
675: --HH do this check for conditional group defaulting
678: (fa_cache_pkg.fazcbc_record.allow_cip_member_flag = 'Y')) then
679: px_asset_fin_rec.group_asset_id := fa_cache_pkg.fazccbd_record.group_asset_id;
680: else
681: px_asset_fin_rec.group_asset_id := NULL;
682: /* fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
683: name => 'FA_CIP_MEMBER_NOT_ALLOWED', p_log_level_rec => p_log_level_rec);
684: raise init_err; */
685: end if; --end HH -- conditional group defaulting
686: elsif (px_asset_fin_rec.group_asset_id = FND_API.G_MISS_NUM) then
740: elsif (px_asset_fin_rec.salvage_type <> 'PCT' and
741: px_asset_fin_rec.salvage_type <> 'AMT' and
742: px_asset_fin_rec.salvage_type <> 'SUM') then
743: fa_srvr_msg.add_message(
744: calling_fn => 'fa_addition_pvt.initialize',
745: name => 'FA_INVALID_PARAMETER',
746: token1 => 'VALUE',
747: value1 => px_asset_fin_rec.salvage_type,
748: token2 => 'PARAM',
777: px_asset_fin_rec.allowed_deprn_limit:=
778: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;
779: if (px_asset_fin_rec.allowed_deprn_limit is null) then
780: fa_srvr_msg.add_message(
781: calling_fn => 'fa_addition_pvt.initialize',
782: name => '***FA_MUST_SPECIFY_LIMIT***',
783: p_log_level_rec => p_log_level_rec);
784: raise init_err;
785: end if;
788: px_asset_fin_rec.allowed_deprn_limit_amount:=
789: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;
790: if (px_asset_fin_rec.allowed_deprn_limit_amount is null) then
791: fa_srvr_msg.add_message(
792: calling_fn => 'fa_addition_pvt.initialize',
793: name => '***FA_MUST_SPECIFY_LIMIT***',
794: p_log_level_rec => p_log_level_rec);
795: raise init_err;
796: end if;
801: px_asset_fin_rec.deprn_limit_type <> 'AMT' and
802: px_asset_fin_rec.deprn_limit_type <> 'SUM' and
803: px_asset_fin_rec.deprn_limit_type <> 'NONE') then
804: fa_srvr_msg.add_message(
805: calling_fn => 'fa_addition_pvt.initialize',
806: name => 'FA_INVALID_PARAMETER',
807: token1 => 'VALUE',
808: value1 => px_asset_fin_rec.deprn_limit_type,
809: token2 => 'PARAM',
953: ((px_asset_fin_rec.member_rollup_flag = 'Y' and
954: nvl(fa_cache_pkg.fazcdrd_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')
955: ) then
956: fa_srvr_msg.add_message(
957: calling_fn => 'fa_addition_pvt.initialize',
958: name => 'FA_INVALID_PARAMETER',
959: token1 => 'VALUE',
960: value1 => px_asset_fin_rec.recognize_gain_loss,
961: token2 => 'PARAM',
960: value1 => px_asset_fin_rec.recognize_gain_loss,
961: token2 => 'PARAM',
962: value2 => 'RECOGNIZE_GAIN_LOSS', p_log_level_rec => p_log_level_rec);
963: fa_srvr_msg.add_message(
964: calling_fn => 'fa_addition_pvt.initialize',
965: name => 'FA_INVALID_PARAMETER',
966: token1 => 'VALUE',
967: value1 => px_asset_fin_rec.terminal_gain_loss,
968: token2 => 'PARAM',
967: value1 => px_asset_fin_rec.terminal_gain_loss,
968: token2 => 'PARAM',
969: value2 => 'TERMINAL_GAIN_LOSS', p_log_level_rec => p_log_level_rec);
970: fa_srvr_msg.add_message(
971: calling_fn => 'fa_addition_pvt.initialize',
972: name => 'FA_INVALID_PARAMETER',
973: token1 => 'VALUE',
974: value1 => px_asset_fin_rec.member_rollup_flag,
975: token2 => 'PARAM',
1024:
1025: exception
1026: when init_err then
1027: fa_srvr_msg.add_message(
1028: calling_fn => 'fa_addition_pvt.initialize', p_log_level_rec => p_log_level_rec);
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030: return FALSE;
1031:
1032: when others then
1030: return FALSE;
1031:
1032: when others then
1033: fa_srvr_msg.add_sql_error(
1034: calling_fn => 'fa_addition_pvt.initialize', p_log_level_rec => p_log_level_rec);
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: return FALSE;
1037:
1038: end initialize;
1316: X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
1317: X_Created_By => p_trans_rec.who_info.created_by,
1318: X_Creation_Date => p_trans_rec.who_info.creation_date,
1319: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1320: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1321: , p_log_level_rec => p_log_level_rec);
1322:
1323: -- Should only update the lease desc flex if modified.
1324: -- Probably need to change later to use table handler.
1384: (p_asset_hdr_rec => p_asset_hdr_rec,
1385: p_asset_type_rec => p_asset_type_rec,
1386: px_trans_rec => p_trans_rec,
1387: p_event_status => NULL,
1388: p_calling_fn => 'fa_addition_pvt.insert_asset',
1389: p_log_level_rec => p_log_level_rec) then
1390: raise general_error;
1391: end if;
1392: /*=================================================================
1403: (p_asset_hdr_rec => l_secondary_asset_hdr_rec,
1404: p_asset_type_rec=> p_asset_type_rec,
1405: px_trans_rec => l_secondary_trans_rec,
1406: p_event_status => NULL,
1407: p_calling_fn => 'fa_addition_pvt.insert_asset'
1408: ,p_log_level_rec => p_log_level_rec) then
1409: raise general_error;
1410: end if;
1411: end if;
1454: X_Mass_Transaction_ID => p_trans_rec.mass_transaction_id,
1455: X_Trx_Reference_Id => p_trans_rec.trx_reference_id,
1456: X_Event_Id => p_trans_rec.event_id,
1457: X_Return_Status => l_return_status,
1458: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1459: , p_log_level_rec => p_log_level_rec);
1460:
1461: if not (l_return_status) then
1462: raise general_error;
1513: X_Mass_Transaction_ID => p_trans_rec.mass_transaction_id,
1514: X_Trx_Reference_Id => p_trans_rec.trx_reference_id,
1515: X_Event_Id => p_dist_trans_rec.event_id, --9413081
1516: X_Return_Status => l_return_status,
1517: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1518: , p_log_level_rec => p_log_level_rec);
1519:
1520: if not (l_return_status) then
1521: raise general_error;
1646: X_cash_generating_unit_id => p_asset_fin_rec.cash_generating_unit_id,
1647: X_mrc_sob_type_code => p_mrc_sob_type_code,
1648: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
1649: X_Return_Status => l_return_status,
1650: X_Calling_Fn => 'fa_addition_pvt.insert_asset' ,
1651: X_nbv_at_switch => p_asset_fin_rec.nbv_at_switch , -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
1652: X_prior_deprn_limit_type => p_asset_fin_rec.prior_deprn_limit_type ,
1653: X_prior_deprn_limit_amount => p_asset_fin_rec.prior_deprn_limit_amount,
1654: X_prior_deprn_limit => p_asset_fin_rec.prior_deprn_limit ,
1686: X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
1687: X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
1688: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1689: X_Return_Status => l_return_status,
1690: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1691: , p_log_level_rec => p_log_level_rec);
1692:
1693: if not (l_return_status) then
1694: raise general_error;
1723: X_Transaction_Units => NULL,
1724: X_Retirement_Id => p_asset_fin_rec.retirement_id,
1725: X_Last_Update_Login =>
1726: p_dist_trans_rec.who_info.last_update_login,
1727: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1728: , p_log_level_rec => p_log_level_rec);
1729:
1730: px_asset_dist_tbl(i).distribution_id := l_distribution_id;
1731:
1766: X_Ytd_Impairment => p_asset_deprn_rec.ytd_impairment,
1767: X_impairment_reserve => p_asset_deprn_rec.impairment_reserve,
1768: X_mrc_sob_type_code => p_mrc_sob_type_code,
1769: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
1770: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
1771: , p_log_level_rec => p_log_level_rec);
1772:
1773: -- Insert into fa_deprn_detail
1774: -- br: changed to use faxindd which automatically handles multi-dist
1946: X_Switch_Code => NULL, -- derived at depreciation
1947: X_mrc_sob_type_code => p_mrc_sob_type_code,
1948: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
1949: X_Return_Status => l_return_status,
1950: X_Calling_Fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
1951:
1952: if not (l_return_status) then
1953: raise general_error;
1954: end if;
1961: -- books are processed
1962:
1963: -- SLA Uptake, do catchup if applicable...
1964: if (p_log_level_rec.statement_level) then
1965: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'trx_subtype',
1966: p_trans_rec.transaction_subtype
1967: ,p_log_level_rec => p_log_level_rec);
1968: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'asset_type',
1969: p_asset_type_rec.asset_type
1964: if (p_log_level_rec.statement_level) then
1965: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'trx_subtype',
1966: p_trans_rec.transaction_subtype
1967: ,p_log_level_rec => p_log_level_rec);
1968: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'asset_type',
1969: p_asset_type_rec.asset_type
1970: ,p_log_level_rec => p_log_level_rec);
1971: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'group asset id',
1972: p_asset_fin_rec.group_asset_id
1967: ,p_log_level_rec => p_log_level_rec);
1968: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'asset_type',
1969: p_asset_type_rec.asset_type
1970: ,p_log_level_rec => p_log_level_rec);
1971: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'group asset id',
1972: p_asset_fin_rec.group_asset_id
1973: ,p_log_level_rec => p_log_level_rec);
1974: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'annaul round flag',
1975: p_asset_fin_rec.annual_deprn_rounding_flag
1970: ,p_log_level_rec => p_log_level_rec);
1971: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'group asset id',
1972: p_asset_fin_rec.group_asset_id
1973: ,p_log_level_rec => p_log_level_rec);
1974: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'annaul round flag',
1975: p_asset_fin_rec.annual_deprn_rounding_flag
1976: ,p_log_level_rec => p_log_level_rec);
1977: fa_debug_pkg.add('fa_addition_pvt.insert_asset',
1978: 'p_trans_rec.transaction_date_entered', p_trans_rec.transaction_date_entered
1973: ,p_log_level_rec => p_log_level_rec);
1974: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'annaul round flag',
1975: p_asset_fin_rec.annual_deprn_rounding_flag
1976: ,p_log_level_rec => p_log_level_rec);
1977: fa_debug_pkg.add('fa_addition_pvt.insert_asset',
1978: 'p_trans_rec.transaction_date_entered', p_trans_rec.transaction_date_entered
1979: ,p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add('fa_addition_pvt.insert_asset',
1981: 'p_period_rec.calendar_period_open_date', p_period_rec.calendar_period_open_date
1976: ,p_log_level_rec => p_log_level_rec);
1977: fa_debug_pkg.add('fa_addition_pvt.insert_asset',
1978: 'p_trans_rec.transaction_date_entered', p_trans_rec.transaction_date_entered
1979: ,p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add('fa_addition_pvt.insert_asset',
1981: 'p_period_rec.calendar_period_open_date', p_period_rec.calendar_period_open_date
1982: ,p_log_level_rec => p_log_level_rec);
1983:
1984: end if;
2026: raise general_error;
2027: end if;
2028:
2029: if (p_log_level_rec.statement_level) then
2030: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_deprn_exp after faxexp',
2031: l_deprn_exp, p_log_level_rec => p_log_level_rec);
2032: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
2033: l_bonus_deprn_exp, p_log_level_rec =>
2034: p_log_level_rec);
2028:
2029: if (p_log_level_rec.statement_level) then
2030: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_deprn_exp after faxexp',
2031: l_deprn_exp, p_log_level_rec => p_log_level_rec);
2032: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
2033: l_bonus_deprn_exp, p_log_level_rec =>
2034: p_log_level_rec);
2035: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',
2036: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
2031: l_deprn_exp, p_log_level_rec => p_log_level_rec);
2032: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
2033: l_bonus_deprn_exp, p_log_level_rec =>
2034: p_log_level_rec);
2035: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',
2036: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
2037: end if;
2038:
2039: --
2049: X_formula_factor => p_asset_fin_rec.formula_factor,
2050: X_eofy_reserve => p_asset_fin_rec.eofy_reserve,
2051: X_mrc_sob_type_code => p_mrc_sob_type_code,
2052: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
2053: X_calling_fn => 'fa_addition_pvt.insert_asset',
2054: p_log_level_rec => p_log_level_rec);
2055:
2056: -- Bug:5701095
2057: FA_DEPRN_SUMMARY_PKG.Update_Row (
2075: X_Ytd_Production => NULL,
2076: X_Ytd_Reval_Deprn_Expense => p_asset_deprn_rec.reval_ytd_deprn,
2077: X_mrc_sob_type_code => p_mrc_sob_type_code,
2078: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
2079: X_Calling_Fn => 'fa_addition_pvt.insert_asset',
2080: p_log_level_rec => p_log_level_rec);
2081:
2082: elsif ((p_trans_rec.transaction_subtype = 'AMORTIZED') and
2083: (p_asset_type_rec.asset_type = 'CAPITALIZED') and
2129: p_bonus_expense => l_bonus_deprn_exp,
2130: p_impair_expense => l_impairment_exp,
2131: p_ann_adj_amt => 0,
2132: p_mrc_sob_type_code => p_mrc_sob_type_code,
2133: p_calling_fn => 'fa_addition_pvt.insert_asset'
2134: , p_log_level_rec => p_log_level_rec) then raise general_error;
2135: end if;
2136:
2137: end if;
2146: X_formula_factor => p_asset_fin_rec.formula_factor,
2147: X_eofy_reserve => p_asset_fin_rec.eofy_reserve,
2148: X_mrc_sob_type_code => p_mrc_sob_type_code,
2149: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
2150: X_calling_fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
2151:
2152: -- now update the primary or reporting amounts accordingly
2153: if (p_mrc_sob_type_code <> 'R') then
2154:
2188: X_Ytd_Production => NULL,
2189: X_Ytd_Reval_Deprn_Expense => p_asset_deprn_rec.reval_ytd_deprn,
2190: X_mrc_sob_type_code => p_mrc_sob_type_code,
2191: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
2192: X_Calling_Fn => 'fa_addition_pvt.insert_asset'
2193: , p_log_level_rec => p_log_level_rec);
2194: end if; -- end amort nbv
2195:
2196: -- R12 conditonal handling
2354: p_deprn_expense => l_deprn_exp,
2355: p_bonus_expense => l_bonus_deprn_exp,
2356: p_ann_adj_amt => l_ann_adj_deprn_exp, --0,
2357: p_mrc_sob_type_code => p_mrc_sob_type_code,
2358: p_calling_fn => 'fa_addition_pvt.insert_asset',
2359: p_log_level_rec => p_log_level_rec) then raise general_error;
2360: end if;
2361:
2362: end if;
2368: p_asset_fin_rec.nbv_at_switch := nvl(p_asset_fin_rec.nbv_at_switch,0); -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
2369:
2370: -- deprn reserve not entered and nbv_at_switch entered
2371: if (p_asset_deprn_rec.deprn_reserve = 0 and p_asset_fin_rec.nbv_at_switch <> 0) then
2372: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
2373: name => 'FA_ADD_SWITCH_NBV_WITHOUT_RSV', p_log_level_rec => p_log_level_rec); -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
2374: raise general_error;
2375: end if;
2376:
2392: X_Method_Type => l_method_type,
2393: X_Success => l_success, p_log_level_rec => p_log_level_rec);
2394:
2395: if (l_success <= 0) then
2396: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
2397: raise general_error;
2398: end if;
2399:
2400:
2413:
2414: -- Fix for Bug #7109596 . The NBV_AT_SWITCH can be ZERO ( = 0) for Zero value Assets. Hence Commenting the below Piece of Code
2415:
2416: /* if (l_revised_count > 0) and (p_asset_fin_rec.nbv_at_switch = 0) then
2417: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
2418: name => 'FA_ADD_REVISED_WITHOUT_SWITCH', p_log_level_rec => p_log_level_rec);
2419: raise general_error;
2420:
2421: els*/
2421: els*/
2422: ----End of the Comment for the Bug 7109596
2423: -- original rate with nbv_at_switch entered
2424: if (l_revised_count = 0) and (p_asset_fin_rec.nbv_at_switch <> 0) then
2425: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
2426: name => 'FA_ADD_SWITCH_NBV_ORIGINAL_RAT', p_log_level_rec => p_log_level_rec);
2427: raise general_error;
2428: end if; -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
2429:
2441: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2442: AND asset_id = p_asset_hdr_rec.asset_id
2443: AND DEPRN_SOURCE_CODE = 'BOOKS';
2444:
2445: /*fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
2446: name => 'FA_ADDITION_REVISED_RATE', p_log_level_rec => p_log_level_rec);
2447: raise general_error; */
2448: end if; -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
2449:
2498: p_last_updated_by => p_trans_rec.who_info.last_updated_by,
2499: p_last_update_date => p_trans_rec.who_info.last_update_date,
2500: p_last_update_login => p_trans_rec.who_info.last_update_login,
2501: p_complete => 'Y',
2502: p_trigger => 'fa_addition_pvt.insert_asset',
2503: p_currency_code => to_char(p_asset_hdr_rec.set_of_books_id),
2504: p_log_level_rec => p_log_level_rec
2505: );
2506: end if;
2510:
2511: EXCEPTION
2512: when mrc_check_error then
2513: fa_srvr_msg.add_message(
2514: calling_fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: return FALSE;
2517:
2518: when general_error then
2516: return FALSE;
2517:
2518: when general_error then
2519: fa_srvr_msg.add_message(
2520: calling_fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
2521: x_return_status := FND_API.G_RET_STS_ERROR;
2522: return FALSE;
2523:
2524: when others then
2522: return FALSE;
2523:
2524: when others then
2525: fa_srvr_msg.add_sql_error(
2526: calling_fn => 'fa_addition_pvt.insert_asset', p_log_level_rec => p_log_level_rec);
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: return FALSE;
2529:
2530: end insert_asset;
2688: -- Bug#7698326 End
2689: exception
2690: when others then
2691: fa_srvr_msg.add_sql_error(
2692: calling_fn => 'fa_addition_pvt.initialize_jp', p_log_level_rec => p_log_level_rec);
2693: return FALSE;
2694:
2695: end initialize_jp;
2696:
2693: return FALSE;
2694:
2695: end initialize_jp;
2696:
2697: END FA_ADDITION_PVT;