DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on FND_MESSAGE

Line 1320: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');

1316: END IF ;
1317:
1318: END LOOP ; -- l_src_fa_inst_dtls_tbl
1319: ELSE
1320: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
1321: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
1322: fnd_msg_pub.add;
1323: RAISE fnd_api.g_exc_error ;
1324: END IF;

Line 1321: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);

1317:
1318: END LOOP ; -- l_src_fa_inst_dtls_tbl
1319: ELSE
1320: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
1321: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
1322: fnd_msg_pub.add;
1323: RAISE fnd_api.g_exc_error ;
1324: END IF;
1325:

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

1377: x_error_msg := l_error_msg ;
1378: WHEN OTHERS THEN
1379: l_error_msg := l_error_msg || SQLERRM ;
1380: x_return_status := fnd_api.G_RET_STS_ERROR ;
1381: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1382: fnd_message.set_token('API_NAME','process_adjustment_trans');
1383: fnd_message.set_token('SQL_ERROR',SQLERRM);
1384: x_error_msg := fnd_message.get;
1385:

Line 1382: fnd_message.set_token('API_NAME','process_adjustment_trans');

1378: WHEN OTHERS THEN
1379: l_error_msg := l_error_msg || SQLERRM ;
1380: x_return_status := fnd_api.G_RET_STS_ERROR ;
1381: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1382: fnd_message.set_token('API_NAME','process_adjustment_trans');
1383: fnd_message.set_token('SQL_ERROR',SQLERRM);
1384: x_error_msg := fnd_message.get;
1385:
1386: l_trx_error_rec.transaction_id := l_src_transaction_id ;

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

1379: l_error_msg := l_error_msg || SQLERRM ;
1380: x_return_status := fnd_api.G_RET_STS_ERROR ;
1381: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1382: fnd_message.set_token('API_NAME','process_adjustment_trans');
1383: fnd_message.set_token('SQL_ERROR',SQLERRM);
1384: x_error_msg := fnd_message.get;
1385:
1386: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1387: l_trx_error_rec.error_text := l_error_msg;

Line 1384: x_error_msg := fnd_message.get;

1380: x_return_status := fnd_api.G_RET_STS_ERROR ;
1381: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1382: fnd_message.set_token('API_NAME','process_adjustment_trans');
1383: fnd_message.set_token('SQL_ERROR',SQLERRM);
1384: x_error_msg := fnd_message.get;
1385:
1386: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1387: l_trx_error_rec.error_text := l_error_msg;
1388: l_trx_error_rec.source_type := 'ASSET_CREATION';

Line 2103: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');

2099: RAISE fnd_api.g_exc_error ;
2100: END IF ;
2101:
2102: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2103: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2104: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2105: fnd_msg_pub.add;
2106: RAISE fnd_api.g_exc_error ;
2107: END IF ;

Line 2104: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);

2100: END IF ;
2101:
2102: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2103: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2104: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2105: fnd_msg_pub.add;
2106: RAISE fnd_api.g_exc_error ;
2107: END IF ;
2108:

Line 2713: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');

2709: ---There may not be enough asset units at the source
2710: --asset or source asset may not be available at inst_asset.
2711: debug('Either Source Asset does not found
2712: or enough asset units does not exists ..');
2713: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2714: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2715: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2716: l_error_msg := fnd_message.get;
2717: RAISE e_goto_next_trans ;

Line 2714: fnd_message.set_token('TXN_ID',l_src_transaction_id);

2710: --asset or source asset may not be available at inst_asset.
2711: debug('Either Source Asset does not found
2712: or enough asset units does not exists ..');
2713: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2714: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2715: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2716: l_error_msg := fnd_message.get;
2717: RAISE e_goto_next_trans ;
2718: END IF ;

Line 2715: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);

2711: debug('Either Source Asset does not found
2712: or enough asset units does not exists ..');
2713: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2714: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2715: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2716: l_error_msg := fnd_message.get;
2717: RAISE e_goto_next_trans ;
2718: END IF ;
2719:

Line 2716: l_error_msg := fnd_message.get;

2712: or enough asset units does not exists ..');
2713: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2714: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2715: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2716: l_error_msg := fnd_message.get;
2717: RAISE e_goto_next_trans ;
2718: END IF ;
2719:
2720: ---First Update Source Instance Asset

Line 2800: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');

2796: IF dest_misc_move_trans_cur%NOTFOUND
2797: THEN
2798: ---This is fatal exceptionn....
2799: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2800: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2801: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2802: l_error_msg := fnd_message.get;
2803: RAISE e_goto_next_trans ;
2804: END IF ;

Line 2801: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);

2797: THEN
2798: ---This is fatal exceptionn....
2799: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2800: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2801: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2802: l_error_msg := fnd_message.get;
2803: RAISE e_goto_next_trans ;
2804: END IF ;
2805: CLOSE dest_misc_move_trans_cur ;

Line 2802: l_error_msg := fnd_message.get;

2798: ---This is fatal exceptionn....
2799: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2800: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2801: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2802: l_error_msg := fnd_message.get;
2803: RAISE e_goto_next_trans ;
2804: END IF ;
2805: CLOSE dest_misc_move_trans_cur ;
2806:

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

3050: END IF ;
3051:
3052: ROLLBACK TO src_trx ;
3053:
3054: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3055: fnd_message.set_token('API_NAME',l_api_name);
3056: fnd_message.set_token('SQL_ERROR',SQLERRM);
3057: x_error_msg := fnd_message.get;
3058:

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

3051:
3052: ROLLBACK TO src_trx ;
3053:
3054: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3055: fnd_message.set_token('API_NAME',l_api_name);
3056: fnd_message.set_token('SQL_ERROR',SQLERRM);
3057: x_error_msg := fnd_message.get;
3058:
3059: l_trx_error_rec.transaction_id := l_src_transaction_id ;

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

3052: ROLLBACK TO src_trx ;
3053:
3054: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3055: fnd_message.set_token('API_NAME',l_api_name);
3056: fnd_message.set_token('SQL_ERROR',SQLERRM);
3057: x_error_msg := fnd_message.get;
3058:
3059: l_trx_error_rec.transaction_id := l_src_transaction_id ;
3060: l_trx_error_rec.error_text := x_error_msg;

Line 3057: x_error_msg := fnd_message.get;

3053:
3054: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3055: fnd_message.set_token('API_NAME',l_api_name);
3056: fnd_message.set_token('SQL_ERROR',SQLERRM);
3057: x_error_msg := fnd_message.get;
3058:
3059: l_trx_error_rec.transaction_id := l_src_transaction_id ;
3060: l_trx_error_rec.error_text := x_error_msg;
3061: l_trx_error_rec.source_type := 'ASSET_MOVE';

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

3610: WHEN OTHERS
3611: THEN
3612: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3613: ||SQLERRM) ;
3614: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3615: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3616: fnd_message.set_token('SQL_ERROR',SQLERRM);
3617: x_error_msg := fnd_message.get;
3618:

Line 3615: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');

3611: THEN
3612: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3613: ||SQLERRM) ;
3614: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3615: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3616: fnd_message.set_token('SQL_ERROR',SQLERRM);
3617: x_error_msg := fnd_message.get;
3618:
3619: l_trx_error_rec.transaction_id := p_transaction_id ;

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

3612: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3613: ||SQLERRM) ;
3614: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3615: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3616: fnd_message.set_token('SQL_ERROR',SQLERRM);
3617: x_error_msg := fnd_message.get;
3618:
3619: l_trx_error_rec.transaction_id := p_transaction_id ;
3620: l_trx_error_rec.error_text := l_error_msg;

Line 3617: x_error_msg := fnd_message.get;

3613: ||SQLERRM) ;
3614: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3615: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3616: fnd_message.set_token('SQL_ERROR',SQLERRM);
3617: x_error_msg := fnd_message.get;
3618:
3619: l_trx_error_rec.transaction_id := p_transaction_id ;
3620: l_trx_error_rec.error_text := l_error_msg;
3621: l_trx_error_rec.source_type := 'ASSET_MOVE';