1: PACKAGE BODY FA_TRANS_API_PUB AS
2: /* $Header: FAPTAPIB.pls 120.26 2005/06/24 17:04:19 bridgway noship $ */
3:
4: PROCEDURE do_addition (
5: -- Standard Parameters --
742: x_dist_transaction_header_id := l_dist_trans_rec.transaction_header_id;
743:
744: EXCEPTION
745: when others then
746: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_addition');
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
749: END do_addition;
750:
1324: x_transaction_header_id := l_trans_rec.transaction_header_id;
1325:
1326: EXCEPTION
1327: when adj_err then
1328: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_adjustment');
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330:
1331: when others then
1332: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_adjustment');
1328: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_adjustment');
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330:
1331: when others then
1332: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_adjustment');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334:
1335: END do_adjustment;
1336:
1489: x_transaction_header_id := l_trans_rec.transaction_header_id;
1490:
1491: EXCEPTION
1492: when others then
1493: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_unit_adj');
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495:
1496: END do_unit_adjustment;
1497:
1650: x_transaction_header_id := l_trans_rec.transaction_header_id;
1651:
1652: EXCEPTION
1653: when others then
1654: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_transfer');
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656:
1657: END do_transfer;
1658:
1903: x_dest_transaction_header_id := l_dest_trans_rec.transaction_header_id;
1904:
1905: EXCEPTION
1906: when others then
1907: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_xfr');
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909:
1910: END do_invoice_transfer;
1911:
2124: x_transaction_header_id := l_trans_rec.transaction_header_id;
2125:
2126: EXCEPTION
2127: when others then
2128: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_reclass');
2129: x_return_status := FND_API.G_RET_STS_ERROR;
2130:
2131: END do_reclass;
2132:
2507: x_dist_transaction_header_id := l_dist_trans_rec.transaction_header_id;
2508:
2509: EXCEPTION
2510: when others then
2511: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_retirement');
2512: x_return_status := FND_API.G_RET_STS_ERROR;
2513:
2514: END do_retirement;
2515:
2656: end if;
2657:
2658: EXCEPTION
2659: when others then
2660: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.undo_ret');
2661: x_return_status := FND_API.G_RET_STS_ERROR;
2662:
2663: END undo_retirement;
2664:
2966: x_transaction_header_id := l_trans_rec.transaction_header_id;
2967:
2968: EXCEPTION
2969: when others then
2970: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_reinst');
2971: x_return_status := FND_API.G_RET_STS_ERROR;
2972:
2973: END do_reinstatement;
2974:
3116: end if;
3117:
3118: EXCEPTION
3119: when others then
3120: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.undo_reinst');
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122:
3123: END undo_reinstatement;
3124:
3263: x_transaction_header_id := l_trans_rec.transaction_header_id;
3264:
3265: EXCEPTION
3266: when others then
3267: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_cap');
3268: x_return_status := FND_API.G_RET_STS_ERROR;
3269: END do_capitalization;
3270:
3271: PROCEDURE do_reverse (
3409: x_transaction_header_id := l_trans_rec.transaction_header_id;
3410:
3411: EXCEPTION
3412: when others then
3413: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_rev');
3414: x_return_status := FND_API.G_RET_STS_ERROR;
3415: END do_reverse;
3416:
3417: PROCEDURE do_asset_desc_update (
3744: end if;
3745:
3746: EXCEPTION
3747: when desc_err then
3748: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_desc_update');
3749: x_return_status := FND_API.G_RET_STS_ERROR;
3750: when others then
3751: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_desc_update');
3752: x_return_status := FND_API.G_RET_STS_ERROR;
3747: when desc_err then
3748: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_desc_update');
3749: x_return_status := FND_API.G_RET_STS_ERROR;
3750: when others then
3751: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_desc_update');
3752: x_return_status := FND_API.G_RET_STS_ERROR;
3753: END do_asset_desc_update;
3754:
3755: PROCEDURE do_invoice_desc_update (
3950: end if;
3951:
3952: EXCEPTION
3953: when desc_err then
3954: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd');
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956:
3957: when others then
3958: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd');
3954: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd');
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956:
3957: when others then
3958: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd');
3959: x_return_status := FND_API.G_RET_STS_ERROR;
3960:
3961: END do_invoice_desc_update;
3962:
4140: end if;
4141:
4142: EXCEPTION
4143: when desc_err then
4144: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd');
4145: x_return_status := FND_API.G_RET_STS_ERROR;
4146:
4147: when others then
4148: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd');
4144: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd');
4145: x_return_status := FND_API.G_RET_STS_ERROR;
4146:
4147: when others then
4148: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd');
4149: x_return_status := FND_API.G_RET_STS_ERROR;
4150:
4151: END do_retirement_desc_update;
4152:
4302: x_transaction_header_id := l_trans_rec.transaction_header_id;
4303:
4304: EXCEPTION
4305: when others then
4306: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_unplanned');
4307: x_return_status := FND_API.G_RET_STS_ERROR;
4308:
4309: END do_unplanned;
4310:
4423: end if;
4424:
4425: EXCEPTION
4426: when others then
4427: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_rsv_xfr');
4428: x_return_status := FND_API.G_RET_STS_ERROR;
4429:
4430: END do_reserve_transfer;
4431:
4517: end if;
4518:
4519: EXCEPTION
4520: when others then
4521: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_adj');
4522: x_return_status := FND_API.G_RET_STS_ERROR;
4523: END do_retirement_adjustment;
4524:
4525: PROCEDURE do_tax_reserve_adjustment(
4655: end if;
4656:
4657: EXCEPTION
4658: when others then
4659: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_tax_rsv_adj');
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661: END do_tax_reserve_adjustment;
4662:
4663: END FA_TRANS_API_PUB;
4659: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_tax_rsv_adj');
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661: END do_tax_reserve_adjustment;
4662:
4663: END FA_TRANS_API_PUB;