DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on FND_MESSAGE

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

1331: END IF ;
1332:
1333: END LOOP ; -- l_src_fa_inst_dtls_tbl
1334: ELSE
1335: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
1336: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
1337: fnd_msg_pub.add;
1338: RAISE fnd_api.g_exc_error ;
1339: END IF;

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

1332:
1333: END LOOP ; -- l_src_fa_inst_dtls_tbl
1334: ELSE
1335: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
1336: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
1337: fnd_msg_pub.add;
1338: RAISE fnd_api.g_exc_error ;
1339: END IF;
1340:

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

1392: x_error_msg := l_error_msg ;
1393: WHEN OTHERS THEN
1394: l_error_msg := l_error_msg || SQLERRM ;
1395: x_return_status := fnd_api.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME','process_adjustment_trans');
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:

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

1393: WHEN OTHERS THEN
1394: l_error_msg := l_error_msg || SQLERRM ;
1395: x_return_status := fnd_api.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME','process_adjustment_trans');
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: l_trx_error_rec.transaction_id := l_src_transaction_id ;

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

1394: l_error_msg := l_error_msg || SQLERRM ;
1395: x_return_status := fnd_api.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME','process_adjustment_trans');
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1402: l_trx_error_rec.error_text := l_error_msg;

Line 1399: x_error_msg := fnd_message.get;

1395: x_return_status := fnd_api.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME','process_adjustment_trans');
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1402: l_trx_error_rec.error_text := l_error_msg;
1403: l_trx_error_rec.source_type := 'ASSET_CREATION';

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

2162: RAISE fnd_api.g_exc_error ;
2163: END IF ;
2164:
2165: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2166: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2167: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2168: fnd_msg_pub.add;
2169: RAISE fnd_api.g_exc_error ;
2170: END IF ;

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

2163: END IF ;
2164:
2165: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2166: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2167: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2168: fnd_msg_pub.add;
2169: RAISE fnd_api.g_exc_error ;
2170: END IF ;
2171:

Line 2258: /* fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');

2254: IF l_total_asset_qty < abs(l_txn_qty) THEN
2255: debug('Total asset qty is less than transaction qty');
2256: debug('l_total_asset_qty' || l_total_asset_qty);
2257: debug('abs(l_txn_qty)' || abs(l_txn_qty));
2258: /* fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2259: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2260: fnd_msg_pub.add;*/
2261: RAISE fnd_api.g_exc_error ;
2262: END IF;

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

2255: debug('Total asset qty is less than transaction qty');
2256: debug('l_total_asset_qty' || l_total_asset_qty);
2257: debug('abs(l_txn_qty)' || abs(l_txn_qty));
2258: /* fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2259: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2260: fnd_msg_pub.add;*/
2261: RAISE fnd_api.g_exc_error ;
2262: END IF;
2263: END IF;

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

2788: ---There may not be enough asset units at the source
2789: --asset or source asset may not be available at inst_asset.
2790: debug('Either Source Asset does not found
2791: or enough asset units does not exists ..');
2792: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2793: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2794: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2795: l_error_msg := fnd_message.get;
2796: RAISE e_goto_next_trans ;

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

2789: --asset or source asset may not be available at inst_asset.
2790: debug('Either Source Asset does not found
2791: or enough asset units does not exists ..');
2792: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2793: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2794: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2795: l_error_msg := fnd_message.get;
2796: RAISE e_goto_next_trans ;
2797: END IF ;

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

2790: debug('Either Source Asset does not found
2791: or enough asset units does not exists ..');
2792: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2793: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2794: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2795: l_error_msg := fnd_message.get;
2796: RAISE e_goto_next_trans ;
2797: END IF ;
2798:

Line 2795: l_error_msg := fnd_message.get;

2791: or enough asset units does not exists ..');
2792: fnd_message.set_name('CSE','CSE_SRC_INST_ASSETS_NOTENOUGH');
2793: fnd_message.set_token('TXN_ID',l_src_transaction_id);
2794: fnd_message.set_token('INSTANCE_ID',src_misc_move_trans_rec.instance_id);
2795: l_error_msg := fnd_message.get;
2796: RAISE e_goto_next_trans ;
2797: END IF ;
2798:
2799: ---First Update Source Instance Asset

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

2875: IF dest_misc_move_trans_cur%NOTFOUND
2876: THEN
2877: ---This is fatal exceptionn....
2878: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2879: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2880: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2881: l_error_msg := fnd_message.get;
2882: RAISE e_goto_next_trans ;
2883: END IF ;

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

2876: THEN
2877: ---This is fatal exceptionn....
2878: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2879: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2880: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2881: l_error_msg := fnd_message.get;
2882: RAISE e_goto_next_trans ;
2883: END IF ;
2884: CLOSE dest_misc_move_trans_cur ;

Line 2881: l_error_msg := fnd_message.get;

2877: ---This is fatal exceptionn....
2878: debug('No Dest transaction found for : '||src_misc_move_trans_rec.transaction_id);
2879: fnd_message.set_name('CSE','CSE_DEST_TXN_NOTFOUND');
2880: fnd_message.set_token('CSI_TRANSACTION',src_misc_move_trans_rec.transaction_id);
2881: l_error_msg := fnd_message.get;
2882: RAISE e_goto_next_trans ;
2883: END IF ;
2884: CLOSE dest_misc_move_trans_cur ;
2885:

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

3129: END IF ;
3130:
3131: ROLLBACK TO src_trx ;
3132:
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:

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

3130:
3131: ROLLBACK TO src_trx ;
3132:
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:
3138: l_trx_error_rec.transaction_id := l_src_transaction_id ;

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

3131: ROLLBACK TO src_trx ;
3132:
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:
3138: l_trx_error_rec.transaction_id := l_src_transaction_id ;
3139: l_trx_error_rec.error_text := x_error_msg;

Line 3136: x_error_msg := fnd_message.get;

3132:
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:
3138: l_trx_error_rec.transaction_id := l_src_transaction_id ;
3139: l_trx_error_rec.error_text := x_error_msg;
3140: l_trx_error_rec.source_type := 'ASSET_MOVE';

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

3689: WHEN OTHERS
3690: THEN
3691: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3692: ||SQLERRM) ;
3693: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3694: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3695: fnd_message.set_token('SQL_ERROR',SQLERRM);
3696: x_error_msg := fnd_message.get;
3697:

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

3690: THEN
3691: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3692: ||SQLERRM) ;
3693: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3694: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3695: fnd_message.set_token('SQL_ERROR',SQLERRM);
3696: x_error_msg := fnd_message.get;
3697:
3698: l_trx_error_rec.transaction_id := p_transaction_id ;

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

3691: debug ('IN Others Exception process_srl_nosrl_xorg_txn :'
3692: ||SQLERRM) ;
3693: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3694: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3695: fnd_message.set_token('SQL_ERROR',SQLERRM);
3696: x_error_msg := fnd_message.get;
3697:
3698: l_trx_error_rec.transaction_id := p_transaction_id ;
3699: l_trx_error_rec.error_text := l_error_msg;

Line 3696: x_error_msg := fnd_message.get;

3692: ||SQLERRM) ;
3693: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3694: fnd_message.set_token('API_NAME','process_srl_nosrl_xorg_txn');
3695: fnd_message.set_token('SQL_ERROR',SQLERRM);
3696: x_error_msg := fnd_message.get;
3697:
3698: l_trx_error_rec.transaction_id := p_transaction_id ;
3699: l_trx_error_rec.error_text := l_error_msg;
3700: l_trx_error_rec.source_type := 'ASSET_MOVE';