DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FND_MESSAGE

Line 715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');

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;

Line 716: fnd_message.set_token('ASSET_CAT', l_asset_category);

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;

Line 717: fnd_message.set_token('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;
721: ELSE

Line 718: l_error_message := fnd_message.get;

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');

Line 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:

Line 723: 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:
727: -- date placed in service

Line 758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

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;

Line 759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');

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;

Line 760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);

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:

Line 761: l_error_message := fnd_message.get;

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

Line 2605: fnd_message.set_name('CSE', 'CSE_PRIOR_TXN_PENDING');

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;

Line 3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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 ;

Line 3039: fnd_message.set_token('API_NAME',l_api_name);

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:

Line 3040: fnd_message.set_token('SQL_ERROR',SQLERRM);

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(

Line 3041: x_error_msg := fnd_message.get;

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

Line 3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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;

Line 3134: fnd_message.set_token('API_NAME',l_api_name);

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:

Line 3135: fnd_message.set_token('SQL_ERROR',SQLERRM);

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(

Line 3136: x_error_msg := fnd_message.get;

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,

Line 3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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:

Line 3508: fnd_message.set_token('API_NAME',l_api_name);

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);

Line 3509: fnd_message.set_token('SQL_ERROR',SQLERRM);

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;

Line 3510: x_error_msg := fnd_message.get;

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:

Line 3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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;

Line 3722: fnd_message.set_token('API_NAME',l_api_name);

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:

Line 3723: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 3724: x_error_msg := fnd_message.get;

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(