[Home] [Help]
1: PACKAGE BODY FA_ADDITION_PUB AS
2: /* $Header: FAPADDB.pls 120.37.12020000.5 2013/03/02 19:15:16 dvjoshi ship $ */
3:
4: --*********************** Global constants *******************************--
5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_ADDITION_PUB';
1: PACKAGE BODY FA_ADDITION_PUB AS
2: /* $Header: FAPADDB.pls 120.37.12020000.5 2013/03/02 19:15:16 dvjoshi ship $ */
3:
4: --*********************** Global constants *******************************--
5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_ADDITION_PUB';
6: G_API_NAME CONSTANT varchar2(30) := 'Addition API';
7: G_API_VERSION CONSTANT number := 1.0;
8:
9: g_log_level_rec fa_api_types.log_level_rec_type;
104:
105: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
106:
107: l_cip_cost number := 0;
108: l_calling_fn varchar2(30) := 'fa_addition_pub.do_addition';
109: l_japan_tax_reform varchar2(1) := fnd_profile.value('FA_JAPAN_TAX_REFORMS'); --bug 13022905
110:
111: l_trx_stack boolean := FALSE; /*bug#16426081 */
112:
219: px_asset_deprn_rec => px_asset_deprn_rec,
220: px_asset_dist_tbl => px_asset_dist_tbl,
221: px_inv_tbl => px_inv_tbl,
222: x_return_status => x_return_status,
223: p_calling_fn => 'fa_addition_pub.do_addition',
224: p_log_level_rec => g_log_level_rec)) then
225: raise add_err2;
226: end if;
227:
243: px_asset_hierarchy_rec => px_asset_hierarchy_rec,
244: px_asset_fin_rec => px_asset_fin_rec,
245: px_asset_dist_tbl => px_asset_dist_tbl,
246: p_derivation_type => 'ALL',
247: p_calling_function => 'fa_addition_pub.do_addition' ,
248: p_log_level_rec => g_log_level_rec) then
249: raise add_err1;
250: end if;
251: end if;
369: px_asset_deprn_rec => l_asset_deprn_rec_new,
370: px_asset_dist_tbl => px_asset_dist_tbl,
371: px_inv_tbl => px_inv_tbl,
372: x_return_status => x_return_status,
373: p_calling_fn => 'fa_addition_pub.do_addition',
374: p_log_level_rec => g_log_level_rec)) then
375: raise add_err2;
376: end if;
377:
438: px_inv_trans_rec => l_inv_trans_rec,
439: px_inv_tbl => px_inv_tbl,
440: x_asset_deprn_rec_new => l_asset_deprn_rec_new,
441: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl,
442: p_calling_fn => 'fa_addition_pub.do_addition',
443: p_log_level_rec => g_log_level_rec)) then
444: raise add_err1;
445: end if;
446:
469: px_trans_rec => px_trans_rec,
470: px_asset_hdr_rec => px_asset_hdr_rec,
471: px_asset_fin_rec => l_asset_fin_rec_new,
472: px_asset_deprn_rec => px_asset_deprn_rec,
473: p_calling_fn => 'fa_addition_pub.do_addition',
474: p_log_level_rec => g_log_level_rec)) then
475: raise add_err2;
476: end if;
477: end if;
519: p_asset_fin_rec => l_asset_fin_rec_new,
520: p_asset_deprn_rec => l_asset_deprn_rec_new,
521: p_asset_dist_tbl => px_asset_dist_tbl,
522: p_inv_tbl => px_inv_tbl,
523: p_calling_fn => 'fa_addition_pub.do_addition'
524: , p_log_level_rec => g_log_level_rec)) then
525: raise add_err1;
526: end if;
527: end if;
618: p_asset_deprn_mrc_tbl => l_asset_deprn_mrc_tbl,
619: p_inv_tbl => px_inv_tbl,
620: x_exchange_rate => l_exchange_rate,
621: x_return_status => x_return_status,
622: p_calling_fn => 'fa_addition_pub.do_addition',
623: p_asset_type_rec => px_asset_type_rec,
624: p_log_level_rec => g_log_level_rec)) then
625: raise add_err1;
626: end if;
673: px_asset_deprn_rec_new => l_mrc_asset_deprn_rec_new,
674: p_period_rec => l_period_rec,
675: p_mrc_sob_type_code => l_reporting_flag,
676: p_group_reclass_options_rec => l_group_reclass_options_rec,
677: p_calling_fn => 'fa_addition_pub.do_addition',
678: p_log_level_rec => g_log_level_rec)) then
679: raise add_err1;
680: end if;
681:
740: p_exchange_rate => l_exchange_rate,
741: x_return_status => x_return_status,
742: p_mrc_sob_type_code => l_reporting_flag,
743: p_period_rec => l_period_rec,
744: p_calling_fn => 'fa_addition_pub.do_addition',
745: p_log_level_rec => g_log_level_rec)) then
746: raise add_err2;
747: end if;
748:
891: x_asset_deprn_rec_new => l_group_asset_deprn_rec_new,
892: p_period_rec => l_period_rec,
893: p_mrc_sob_type_code => l_reporting_flag,
894: p_group_reclass_options_rec => l_group_reclass_options_rec,
895: p_calling_fn => 'fa_addition_pub.do_addition',
896: p_log_level_rec => g_log_level_rec)then
897: raise add_err1;
898: end if; -- do_adjustment
899: end if; -- group asset id not null
905: if px_asset_hierarchy_rec.parent_hierarchy_id is not null then
906: if not fa_asset_hierarchy_pvt.add_asset(
907: p_asset_hdr_rec => l_mrc_asset_hdr_rec,
908: p_asset_hierarchy_rec => px_asset_hierarchy_rec , p_log_level_rec => g_log_level_rec) then
909: -- p_calling_fn => 'fa_addition_pub.do_addition' ) then
910:
911: raise add_err1;
912: end if;
913: end if;
972: when add_err1 then
973:
974: ROLLBACK TO do_addition;
975:
976: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pub.do_addition',
977: p_log_level_rec => g_log_level_rec);
978:
979: FND_MSG_PUB.count_and_get (
980: p_count => x_msg_count,
987: when add_err2 then
988:
989: ROLLBACK TO do_addition;
990:
991: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pub.do_addition',
992: p_log_level_rec => g_log_level_rec);
993:
994: FND_MSG_PUB.count_and_get (
995: p_count => x_msg_count,
999: when others then
1000:
1001: ROLLBACK TO do_addition;
1002:
1003: fa_srvr_msg.add_sql_error(calling_fn => 'fa_addition_pub.do_addition',
1004: p_log_level_rec => g_log_level_rec);
1005:
1006: FND_MSG_PUB.count_and_get (
1007: p_count => x_msg_count,
1287: return TRUE;
1288:
1289: exception
1290: when all_books_err then
1291: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pub.do_all_books',
1292: p_log_level_rec => p_log_level_rec);
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: return FALSE;
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: return FALSE;
1296: when others then
1297: fa_srvr_msg.add_sql_error(calling_fn => 'fa_addition_pub.do_all_books',
1298: p_log_level_rec => p_log_level_rec);
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300:
1301: return FALSE;
1300:
1301: return FALSE;
1302: end do_all_books;
1303:
1304: END FA_ADDITION_PUB;