DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FND_MESSAGE

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

691: WHERE category_id = l_asset_category_id
692: AND book_type_code = l_book_type_code;
693: EXCEPTION
694: WHEN no_data_found THEN
695: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
696: fnd_message.set_token('ASSET_CAT', l_asset_category);
697: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
698: l_error_message := fnd_message.get;
699: RAISE fnd_api.g_exc_error;

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

692: AND book_type_code = l_book_type_code;
693: EXCEPTION
694: WHEN no_data_found THEN
695: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
696: fnd_message.set_token('ASSET_CAT', l_asset_category);
697: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
698: l_error_message := fnd_message.get;
699: RAISE fnd_api.g_exc_error;
700: END;

Line 697: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);

693: EXCEPTION
694: WHEN no_data_found THEN
695: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
696: fnd_message.set_token('ASSET_CAT', l_asset_category);
697: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
698: l_error_message := fnd_message.get;
699: RAISE fnd_api.g_exc_error;
700: END;
701: ELSE

Line 698: l_error_message := fnd_message.get;

694: WHEN no_data_found THEN
695: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
696: fnd_message.set_token('ASSET_CAT', l_asset_category);
697: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
698: l_error_message := fnd_message.get;
699: RAISE fnd_api.g_exc_error;
700: END;
701: ELSE
702: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');

Line 702: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');

698: l_error_message := fnd_message.get;
699: RAISE fnd_api.g_exc_error;
700: END;
701: ELSE
702: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
703: l_error_message := fnd_message.get;
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:

Line 703: l_error_message := fnd_message.get;

699: RAISE fnd_api.g_exc_error;
700: END;
701: ELSE
702: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
703: l_error_message := fnd_message.get;
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: -- date placed in service

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

734:
735: IF l_return_status <> fnd_api.g_ret_sts_success THEN
736: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
737: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
738: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
739: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
740: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
741: l_error_message := fnd_message.get;
742: RAISE fnd_api.g_exc_error;

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

735: IF l_return_status <> fnd_api.g_ret_sts_success THEN
736: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
737: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
738: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
739: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
740: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
741: l_error_message := fnd_message.get;
742: RAISE fnd_api.g_exc_error;
743: END IF;

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

736: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
737: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
738: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
739: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
740: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
741: l_error_message := fnd_message.get;
742: RAISE fnd_api.g_exc_error;
743: END IF;
744:

Line 741: l_error_message := fnd_message.get;

737: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
738: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
739: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
740: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
741: l_error_message := fnd_message.get;
742: RAISE fnd_api.g_exc_error;
743: END IF;
744:
745: -- get deprn expense ccid

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

2282: p_transaction_date => csi_txn_rec.transaction_date,
2283: x_redeploy_flag => l_redeploy_flag);
2284:
2285: IF transaction_pending(csi_txn_rec.transaction_id, l_instance_id) THEN
2286: fnd_message.set_name('CSE', 'CSE_PRIOR_TXN_PENDING');
2287: fnd_msg_pub.add;
2288: l_error_message := cse_util_pkg.dump_error_stack;
2289: RAISE fnd_api.g_exc_error;
2290: END IF;

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

2698: EXCEPTION
2699: WHEN OTHERS
2700: THEN
2701: x_return_status := FND_API.G_RET_STS_ERROR ;
2702: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2703: fnd_message.set_token('API_NAME',l_api_name);
2704: fnd_message.set_token('SQL_ERROR',SQLERRM);
2705: x_error_msg := fnd_message.get;
2706: END find_distribution ;

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

2699: WHEN OTHERS
2700: THEN
2701: x_return_status := FND_API.G_RET_STS_ERROR ;
2702: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2703: fnd_message.set_token('API_NAME',l_api_name);
2704: fnd_message.set_token('SQL_ERROR',SQLERRM);
2705: x_error_msg := fnd_message.get;
2706: END find_distribution ;
2707:

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

2700: THEN
2701: x_return_status := FND_API.G_RET_STS_ERROR ;
2702: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2703: fnd_message.set_token('API_NAME',l_api_name);
2704: fnd_message.set_token('SQL_ERROR',SQLERRM);
2705: x_error_msg := fnd_message.get;
2706: END find_distribution ;
2707:
2708: PROCEDURE create_fa_distribution(

Line 2705: x_error_msg := fnd_message.get;

2701: x_return_status := FND_API.G_RET_STS_ERROR ;
2702: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2703: fnd_message.set_token('API_NAME',l_api_name);
2704: fnd_message.set_token('SQL_ERROR',SQLERRM);
2705: x_error_msg := fnd_message.get;
2706: END find_distribution ;
2707:
2708: PROCEDURE create_fa_distribution(
2709: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec

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

2793: x_error_msg := x_error_msg ;
2794: WHEN OTHERS
2795: THEN
2796: x_return_status := FND_API.G_RET_STS_ERROR ;
2797: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2798: fnd_message.set_token('API_NAME',l_api_name);
2799: fnd_message.set_token('SQL_ERROR',SQLERRM);
2800: x_error_msg := fnd_message.get;
2801: END create_fa_distribution;

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

2794: WHEN OTHERS
2795: THEN
2796: x_return_status := FND_API.G_RET_STS_ERROR ;
2797: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2798: fnd_message.set_token('API_NAME',l_api_name);
2799: fnd_message.set_token('SQL_ERROR',SQLERRM);
2800: x_error_msg := fnd_message.get;
2801: END create_fa_distribution;
2802:

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

2795: THEN
2796: x_return_status := FND_API.G_RET_STS_ERROR ;
2797: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2798: fnd_message.set_token('API_NAME',l_api_name);
2799: fnd_message.set_token('SQL_ERROR',SQLERRM);
2800: x_error_msg := fnd_message.get;
2801: END create_fa_distribution;
2802:
2803: PROCEDURE find_asset(

Line 2800: x_error_msg := fnd_message.get;

2796: x_return_status := FND_API.G_RET_STS_ERROR ;
2797: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2798: fnd_message.set_token('API_NAME',l_api_name);
2799: fnd_message.set_token('SQL_ERROR',SQLERRM);
2800: x_error_msg := fnd_message.get;
2801: END create_fa_distribution;
2802:
2803: PROCEDURE find_asset(
2804: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

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

3167: debug('IN e_error:'||x_error_msg);
3168: WHEN OTHERS
3169: THEN
3170: x_return_status := fnd_api.G_RET_STS_ERROR ;
3171: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3172: fnd_message.set_token('API_NAME',l_api_name);
3173: fnd_message.set_token('SQL_ERROR',SQLERRM);
3174: x_error_msg := fnd_message.get;
3175:

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

3168: WHEN OTHERS
3169: THEN
3170: x_return_status := fnd_api.G_RET_STS_ERROR ;
3171: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3172: fnd_message.set_token('API_NAME',l_api_name);
3173: fnd_message.set_token('SQL_ERROR',SQLERRM);
3174: x_error_msg := fnd_message.get;
3175:
3176: debug(x_error_msg);

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

3169: THEN
3170: x_return_status := fnd_api.G_RET_STS_ERROR ;
3171: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3172: fnd_message.set_token('API_NAME',l_api_name);
3173: fnd_message.set_token('SQL_ERROR',SQLERRM);
3174: x_error_msg := fnd_message.get;
3175:
3176: debug(x_error_msg);
3177: END find_asset;

Line 3174: x_error_msg := fnd_message.get;

3170: x_return_status := fnd_api.G_RET_STS_ERROR ;
3171: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3172: fnd_message.set_token('API_NAME',l_api_name);
3173: fnd_message.set_token('SQL_ERROR',SQLERRM);
3174: x_error_msg := fnd_message.get;
3175:
3176: debug(x_error_msg);
3177: END find_asset;
3178:

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

3381: x_return_status := FND_API.G_RET_STS_ERROR ;
3382: x_error_msg := x_error_msg ;
3383: WHEN OTHERS THEN
3384: x_return_status := fnd_api.G_RET_STS_ERROR ;
3385: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3386: fnd_message.set_token('API_NAME',l_api_name);
3387: fnd_message.set_token('SQL_ERROR',SQLERRM);
3388: x_error_msg := fnd_message.get;
3389: END adjust_asset;

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

3382: x_error_msg := x_error_msg ;
3383: WHEN OTHERS THEN
3384: x_return_status := fnd_api.G_RET_STS_ERROR ;
3385: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3386: fnd_message.set_token('API_NAME',l_api_name);
3387: fnd_message.set_token('SQL_ERROR',SQLERRM);
3388: x_error_msg := fnd_message.get;
3389: END adjust_asset;
3390:

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

3383: WHEN OTHERS THEN
3384: x_return_status := fnd_api.G_RET_STS_ERROR ;
3385: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3386: fnd_message.set_token('API_NAME',l_api_name);
3387: fnd_message.set_token('SQL_ERROR',SQLERRM);
3388: x_error_msg := fnd_message.get;
3389: END adjust_asset;
3390:
3391:

Line 3388: x_error_msg := fnd_message.get;

3384: x_return_status := fnd_api.G_RET_STS_ERROR ;
3385: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3386: fnd_message.set_token('API_NAME',l_api_name);
3387: fnd_message.set_token('SQL_ERROR',SQLERRM);
3388: x_error_msg := fnd_message.get;
3389: END adjust_asset;
3390:
3391:
3392: PROCEDURE create_asset(