711: WHERE category_id = l_asset_category_id
712: AND book_type_code = l_book_type_code;
713: EXCEPTION
714: WHEN no_data_found THEN
715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
716: fnd_message.set_token('ASSET_CAT', l_asset_category);
717: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
712: AND book_type_code = l_book_type_code;
713: EXCEPTION
714: WHEN no_data_found THEN
715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
716: fnd_message.set_token('ASSET_CAT', l_asset_category);
717: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
720: END;
713: EXCEPTION
714: WHEN no_data_found THEN
715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
716: fnd_message.set_token('ASSET_CAT', l_asset_category);
717: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
720: END;
721: ELSE
714: WHEN no_data_found THEN
715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
716: fnd_message.set_token('ASSET_CAT', l_asset_category);
717: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
720: END;
721: ELSE
722: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
720: END;
721: ELSE
722: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
723: l_error_message := fnd_message.get;
724: RAISE fnd_api.g_exc_error;
725: END IF;
726:
719: RAISE fnd_api.g_exc_error;
720: END;
721: ELSE
722: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
723: l_error_message := fnd_message.get;
724: RAISE fnd_api.g_exc_error;
725: END IF;
726:
727: -- date placed in service
754:
755: IF l_return_status <> fnd_api.g_ret_sts_success THEN
756: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
757: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
761: l_error_message := fnd_message.get;
762: RAISE fnd_api.g_exc_error;
755: IF l_return_status <> fnd_api.g_ret_sts_success THEN
756: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
757: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
761: l_error_message := fnd_message.get;
762: RAISE fnd_api.g_exc_error;
763: END IF;
756: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
757: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
761: l_error_message := fnd_message.get;
762: RAISE fnd_api.g_exc_error;
763: END IF;
764:
757: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
761: l_error_message := fnd_message.get;
762: RAISE fnd_api.g_exc_error;
763: END IF;
764:
765: -- get deprn expense ccid
2601: p_transaction_date => csi_txn_rec.transaction_date,
2602: x_redeploy_flag => l_redeploy_flag);
2603:
2604: IF transaction_pending(csi_txn_rec.transaction_id, l_instance_id) THEN
2605: fnd_message.set_name('CSE', 'CSE_PRIOR_TXN_PENDING');
2606: fnd_msg_pub.add;
2607: l_error_message := cse_util_pkg.dump_error_stack;
2608: RAISE fnd_api.g_exc_error;
2609: END IF;
3034: EXCEPTION
3035: WHEN OTHERS
3036: THEN
3037: x_return_status := FND_API.G_RET_STS_ERROR ;
3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3039: fnd_message.set_token('API_NAME',l_api_name);
3040: fnd_message.set_token('SQL_ERROR',SQLERRM);
3041: x_error_msg := fnd_message.get;
3042: END find_distribution ;
3035: WHEN OTHERS
3036: THEN
3037: x_return_status := FND_API.G_RET_STS_ERROR ;
3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3039: fnd_message.set_token('API_NAME',l_api_name);
3040: fnd_message.set_token('SQL_ERROR',SQLERRM);
3041: x_error_msg := fnd_message.get;
3042: END find_distribution ;
3043:
3036: THEN
3037: x_return_status := FND_API.G_RET_STS_ERROR ;
3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3039: fnd_message.set_token('API_NAME',l_api_name);
3040: fnd_message.set_token('SQL_ERROR',SQLERRM);
3041: x_error_msg := fnd_message.get;
3042: END find_distribution ;
3043:
3044: PROCEDURE create_fa_distribution(
3037: x_return_status := FND_API.G_RET_STS_ERROR ;
3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3039: fnd_message.set_token('API_NAME',l_api_name);
3040: fnd_message.set_token('SQL_ERROR',SQLERRM);
3041: x_error_msg := fnd_message.get;
3042: END find_distribution ;
3043:
3044: PROCEDURE create_fa_distribution(
3045: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec
3129: x_error_msg := x_error_msg ;
3130: WHEN OTHERS
3131: THEN
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3134: fnd_message.set_token('API_NAME',l_api_name);
3135: fnd_message.set_token('SQL_ERROR',SQLERRM);
3136: x_error_msg := fnd_message.get;
3137: END create_fa_distribution;
3130: WHEN OTHERS
3131: THEN
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3134: fnd_message.set_token('API_NAME',l_api_name);
3135: fnd_message.set_token('SQL_ERROR',SQLERRM);
3136: x_error_msg := fnd_message.get;
3137: END create_fa_distribution;
3138:
3131: THEN
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3134: fnd_message.set_token('API_NAME',l_api_name);
3135: fnd_message.set_token('SQL_ERROR',SQLERRM);
3136: x_error_msg := fnd_message.get;
3137: END create_fa_distribution;
3138:
3139: PROCEDURE find_asset(
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3134: fnd_message.set_token('API_NAME',l_api_name);
3135: fnd_message.set_token('SQL_ERROR',SQLERRM);
3136: x_error_msg := fnd_message.get;
3137: END create_fa_distribution;
3138:
3139: PROCEDURE find_asset(
3140: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3503: debug('IN e_error:'||x_error_msg);
3504: WHEN OTHERS
3505: THEN
3506: x_return_status := fnd_api.G_RET_STS_ERROR ;
3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3508: fnd_message.set_token('API_NAME',l_api_name);
3509: fnd_message.set_token('SQL_ERROR',SQLERRM);
3510: x_error_msg := fnd_message.get;
3511:
3504: WHEN OTHERS
3505: THEN
3506: x_return_status := fnd_api.G_RET_STS_ERROR ;
3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3508: fnd_message.set_token('API_NAME',l_api_name);
3509: fnd_message.set_token('SQL_ERROR',SQLERRM);
3510: x_error_msg := fnd_message.get;
3511:
3512: debug(x_error_msg);
3505: THEN
3506: x_return_status := fnd_api.G_RET_STS_ERROR ;
3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3508: fnd_message.set_token('API_NAME',l_api_name);
3509: fnd_message.set_token('SQL_ERROR',SQLERRM);
3510: x_error_msg := fnd_message.get;
3511:
3512: debug(x_error_msg);
3513: END find_asset;
3506: x_return_status := fnd_api.G_RET_STS_ERROR ;
3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3508: fnd_message.set_token('API_NAME',l_api_name);
3509: fnd_message.set_token('SQL_ERROR',SQLERRM);
3510: x_error_msg := fnd_message.get;
3511:
3512: debug(x_error_msg);
3513: END find_asset;
3514:
3717: x_return_status := FND_API.G_RET_STS_ERROR ;
3718: x_error_msg := x_error_msg ;
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3722: fnd_message.set_token('API_NAME',l_api_name);
3723: fnd_message.set_token('SQL_ERROR',SQLERRM);
3724: x_error_msg := fnd_message.get;
3725: END adjust_asset;
3718: x_error_msg := x_error_msg ;
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3722: fnd_message.set_token('API_NAME',l_api_name);
3723: fnd_message.set_token('SQL_ERROR',SQLERRM);
3724: x_error_msg := fnd_message.get;
3725: END adjust_asset;
3726:
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3722: fnd_message.set_token('API_NAME',l_api_name);
3723: fnd_message.set_token('SQL_ERROR',SQLERRM);
3724: x_error_msg := fnd_message.get;
3725: END adjust_asset;
3726:
3727:
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3722: fnd_message.set_token('API_NAME',l_api_name);
3723: fnd_message.set_token('SQL_ERROR',SQLERRM);
3724: x_error_msg := fnd_message.get;
3725: END adjust_asset;
3726:
3727:
3728: PROCEDURE create_asset(