DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on FND_GLOBAL

Line 57: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN

53: IS
54: BEGIN
55: IF l_debug = 'Y' THEN
56: cse_debug_pub.add(p_message);
57: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
58: fnd_file.put_line(fnd_file.log, p_message);
59: END IF;
60: END IF;
61: EXCEPTION

Line 488: l_ext_ret_rec.created_by := fnd_global.user_id ;

484: l_ext_ret_rec.units := p_units_to_retire ;
485: l_ext_ret_rec.cost_of_removal := 0 ;
486: l_ext_ret_rec.proceeds_of_sale := 0 ;
487: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
488: l_ext_ret_rec.created_by := fnd_global.user_id ;
489: l_ext_ret_rec.creation_date := l_sysdate ;
490: l_ext_ret_rec.last_updated_by := fnd_global.user_id ;
491: l_ext_ret_rec.last_update_date := l_sysdate ;
492: l_ext_ret_rec.last_update_login := fnd_global.login_id ;

Line 490: l_ext_ret_rec.last_updated_by := fnd_global.user_id ;

486: l_ext_ret_rec.proceeds_of_sale := 0 ;
487: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
488: l_ext_ret_rec.created_by := fnd_global.user_id ;
489: l_ext_ret_rec.creation_date := l_sysdate ;
490: l_ext_ret_rec.last_updated_by := fnd_global.user_id ;
491: l_ext_ret_rec.last_update_date := l_sysdate ;
492: l_ext_ret_rec.last_update_login := fnd_global.login_id ;
493: l_ext_ret_rec.distribution_id := p_fa_inst_dtls_rec.fa_distribution_id ;
494:

Line 492: l_ext_ret_rec.last_update_login := fnd_global.login_id ;

488: l_ext_ret_rec.created_by := fnd_global.user_id ;
489: l_ext_ret_rec.creation_date := l_sysdate ;
490: l_ext_ret_rec.last_updated_by := fnd_global.user_id ;
491: l_ext_ret_rec.last_update_date := l_sysdate ;
492: l_ext_ret_rec.last_update_login := fnd_global.login_id ;
493: l_ext_ret_rec.distribution_id := p_fa_inst_dtls_rec.fa_distribution_id ;
494:
495: cse_asset_adjust_pkg.insert_retirement(
496: p_ext_ret_rec => l_ext_ret_rec,

Line 511: p_trans_by => fnd_global.user_id,

507: p_book_type_code => p_fa_inst_dtls_rec.fa_book_type_code,
508: p_asset_id => p_fa_inst_dtls_rec.fa_asset_id,
509: p_units => p_units_to_retire,
510: p_trans_date => l_sysdate,
511: p_trans_by => fnd_global.user_id,
512: px_txn_rec => l_txn_rec,
513: x_return_status => l_return_status,
514: x_error_message => l_error_msg);
515:

Line 942: l_trans_rec.who_info.last_updated_by := fnd_global.user_id ;

938: l_asset_dist_tbl(i).assigned_to := p_dest_fa_dist_rec.employee_id ;
939: l_asset_dist_tbl(i).expense_ccid := p_dest_fa_dist_rec.deprn_expense_ccid ;
940:
941: ---Set the FA Transaction Rec
942: l_trans_rec.who_info.last_updated_by := fnd_global.user_id ;
943: l_trans_rec.who_info.last_update_login := fnd_global.login_id ;
944:
945: debug('FA Asset ID : '|| l_asset_hdr_rec.asset_id );
946:

Line 943: l_trans_rec.who_info.last_update_login := fnd_global.login_id ;

939: l_asset_dist_tbl(i).expense_ccid := p_dest_fa_dist_rec.deprn_expense_ccid ;
940:
941: ---Set the FA Transaction Rec
942: l_trans_rec.who_info.last_updated_by := fnd_global.user_id ;
943: l_trans_rec.who_info.last_update_login := fnd_global.login_id ;
944:
945: debug('FA Asset ID : '|| l_asset_hdr_rec.asset_id );
946:
947: debug('FA Book : '|| l_asset_hdr_rec.book_type_code );

Line 2419: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

2415:
2416: x_return_status := fnd_api.g_ret_sts_success;
2417:
2418: l_txn_rec.transaction_id := p_csi_txn_id;
2419: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2420: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2421:
2422: SELECT object_version_number
2423: INTO l_txn_rec.object_version_number

Line 4190: last_updated_by = fnd_global.user_id,

4186: AND rownum < 2;
4187:
4188: UPDATE csi_txn_errors
4189: SET error_text = l_error_rec.error_text,
4190: last_updated_by = fnd_global.user_id,
4191: last_update_login = fnd_global.login_id,
4192: last_update_date = sysdate
4193: WHERE transaction_error_id = l_error_id;
4194:

Line 4191: last_update_login = fnd_global.login_id,

4187:
4188: UPDATE csi_txn_errors
4189: SET error_text = l_error_rec.error_text,
4190: last_updated_by = fnd_global.user_id,
4191: last_update_login = fnd_global.login_id,
4192: last_update_date = sysdate
4193: WHERE transaction_error_id = l_error_id;
4194:
4195: debug(' error updated. transaction_error_id : '||l_error_id);

Line 4419: p_conc_request_id => fnd_global.conc_request_id,

4415: IF l_txn_action = 'MOVE' THEN
4416:
4417: process_a_move_txn (
4418: p_transaction_id => pending_rec.transaction_id,
4419: p_conc_request_id => fnd_global.conc_request_id,
4420: x_src_move_trans_tbl => l_src_move_trans_tbl,
4421: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
4422: x_move_processed_flag => l_move_processed_flag,
4423: x_return_status => l_return_status,

Line 4433: p_conc_request_id => fnd_global.conc_request_id,

4429: process_misc_moves(
4430: x_return_status => l_return_status,
4431: x_error_msg => l_error_message,
4432: p_inventory_item_id => p_inventory_item_id,
4433: p_conc_request_id => fnd_global.conc_request_id,
4434: p_transaction_id => pending_rec.transaction_id) ;
4435: END IF;
4436:
4437: IF l_txn_action = 'ADJUST' THEN

Line 4441: p_conc_request_id => fnd_global.conc_request_id,

4437: IF l_txn_action = 'ADJUST' THEN
4438:
4439: process_adjustment_trans(
4440: p_transaction_id => pending_rec.transaction_id,
4441: p_conc_request_id => fnd_global.conc_request_id,
4442: x_return_status => l_return_status,
4443: x_error_msg => l_error_message ) ;
4444:
4445: END IF;

Line 4461: p_conc_request_id => fnd_global.conc_request_id,

4457: process_srl_nosrl_xorg_txn(
4458: p_transaction_id => pending_rec.transaction_id,
4459: p_transaction_type_id => pending_rec.transaction_type_id,
4460: p_material_transaction_id => pending_rec.inv_material_transaction_id,
4461: p_conc_request_id => fnd_global.conc_request_id,
4462: x_return_status => l_return_status,
4463: x_error_msg => l_error_message) ;
4464: ELSE
4465:

Line 4468: p_conc_request_id => fnd_global.conc_request_id,

4464: ELSE
4465:
4466: process_a_move_txn (
4467: p_transaction_id => pending_rec.transaction_id,
4468: p_conc_request_id => fnd_global.conc_request_id,
4469: x_src_move_trans_tbl => l_src_move_trans_tbl,
4470: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
4471: x_move_processed_flag => l_move_processed_flag,
4472: x_return_status => l_return_status,