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