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 2498: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

2494: x_return_status := fnd_api.g_ret_sts_success;
2495:
2496: l_txn_rec.transaction_id := p_csi_txn_id;
2497: l_txn_rec.source_group_ref := fnd_api.g_miss_char;
2498: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2499: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2500:
2501: SELECT object_version_number
2502: INTO l_txn_rec.object_version_number

Line 4414: last_updated_by = fnd_global.user_id,

4410: AND rownum < 2;
4411:
4412: UPDATE csi_txn_errors
4413: SET error_text = l_error_rec.error_text,
4414: last_updated_by = fnd_global.user_id,
4415: last_update_login = fnd_global.login_id,
4416: last_update_date = sysdate
4417: WHERE transaction_error_id = l_error_id;
4418:

Line 4415: last_update_login = fnd_global.login_id,

4411:
4412: UPDATE csi_txn_errors
4413: SET error_text = l_error_rec.error_text,
4414: last_updated_by = fnd_global.user_id,
4415: last_update_login = fnd_global.login_id,
4416: last_update_date = sysdate
4417: WHERE transaction_error_id = l_error_id;
4418:
4419: debug(' error updated. transaction_error_id : '||l_error_id);

Line 4643: p_conc_request_id => fnd_global.conc_request_id,

4639: IF l_txn_action = 'MOVE' THEN
4640:
4641: process_a_move_txn (
4642: p_transaction_id => pending_rec.transaction_id,
4643: p_conc_request_id => fnd_global.conc_request_id,
4644: x_src_move_trans_tbl => l_src_move_trans_tbl,
4645: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
4646: x_move_processed_flag => l_move_processed_flag,
4647: x_return_status => l_return_status,

Line 4657: p_conc_request_id => fnd_global.conc_request_id,

4653: process_misc_moves(
4654: x_return_status => l_return_status,
4655: x_error_msg => l_error_message,
4656: p_inventory_item_id => p_inventory_item_id,
4657: p_conc_request_id => fnd_global.conc_request_id,
4658: p_transaction_id => pending_rec.transaction_id) ;
4659: END IF;
4660:
4661: IF l_txn_action = 'ADJUST' THEN

Line 4665: p_conc_request_id => fnd_global.conc_request_id,

4661: IF l_txn_action = 'ADJUST' THEN
4662:
4663: process_adjustment_trans(
4664: p_transaction_id => pending_rec.transaction_id,
4665: p_conc_request_id => fnd_global.conc_request_id,
4666: x_return_status => l_return_status,
4667: x_error_msg => l_error_message ) ;
4668:
4669: END IF;

Line 4685: p_conc_request_id => fnd_global.conc_request_id,

4681: process_srl_nosrl_xorg_txn(
4682: p_transaction_id => pending_rec.transaction_id,
4683: p_transaction_type_id => pending_rec.transaction_type_id,
4684: p_material_transaction_id => pending_rec.inv_material_transaction_id,
4685: p_conc_request_id => fnd_global.conc_request_id,
4686: x_return_status => l_return_status,
4687: x_error_msg => l_error_message) ;
4688: ELSE
4689:

Line 4692: p_conc_request_id => fnd_global.conc_request_id,

4688: ELSE
4689:
4690: process_a_move_txn (
4691: p_transaction_id => pending_rec.transaction_id,
4692: p_conc_request_id => fnd_global.conc_request_id,
4693: x_src_move_trans_tbl => l_src_move_trans_tbl,
4694: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
4695: x_move_processed_flag => l_move_processed_flag,
4696: x_return_status => l_return_status,