DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FND_GLOBAL

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

10: IS
11: BEGIN
12: IF l_debug = 'Y' THEN
13: cse_debug_pub.add(p_message);
14: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
15: fnd_file.put_line(fnd_file.log, p_message);
16: END IF;
17: END IF;
18: EXCEPTION

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

38: PROCEDURE out(
39: p_message in varchar2)
40: IS
41: BEGIN
42: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
43: fnd_file.put_line(fnd_file.output, p_message);
44: END IF;
45: EXCEPTION
46: WHEN others THEN

Line 210: last_updated_by = fnd_global.user_id,

206: AND rownum < 2;
207:
208: UPDATE csi_txn_errors
209: SET error_text = l_error_rec.error_text,
210: last_updated_by = fnd_global.user_id,
211: last_update_login = fnd_global.login_id,
212: last_update_date = sysdate
213: WHERE transaction_error_id = l_error_id;
214:

Line 211: last_update_login = fnd_global.login_id,

207:
208: UPDATE csi_txn_errors
209: SET error_text = l_error_rec.error_text,
210: last_updated_by = fnd_global.user_id,
211: last_update_login = fnd_global.login_id,
212: last_update_date = sysdate
213: WHERE transaction_error_id = l_error_id;
214:
215: debug(' error updated. transaction_error_id : '||l_error_id);

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

256:
257: x_return_status := fnd_api.g_ret_sts_success;
258:
259: l_txn_rec.transaction_id := p_csi_txn_id;
260: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
261: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
262:
263: SELECT object_version_number
264: INTO l_txn_rec.object_version_number

Line 1677: l_p_mass_add_rec.created_by := fnd_global.user_id;

1673: l_p_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
1674: l_p_mass_add_rec.queue_name := 'POST';
1675: l_p_mass_add_rec.asset_type := 'CAPITALIZED';
1676: l_p_mass_add_rec.depreciate_flag := 'YES';
1677: l_p_mass_add_rec.created_by := fnd_global.user_id;
1678: l_p_mass_add_rec.creation_date := sysdate;
1679: l_p_mass_add_rec.last_update_date := sysdate;
1680: l_p_mass_add_rec.last_update_login := fnd_global.login_id;
1681:

Line 1680: l_p_mass_add_rec.last_update_login := fnd_global.login_id;

1676: l_p_mass_add_rec.depreciate_flag := 'YES';
1677: l_p_mass_add_rec.created_by := fnd_global.user_id;
1678: l_p_mass_add_rec.creation_date := sysdate;
1679: l_p_mass_add_rec.last_update_date := sysdate;
1680: l_p_mass_add_rec.last_update_login := fnd_global.login_id;
1681:
1682: -- ER 13083427
1683: -- Checking if asset type and date placed in service hook is used
1684: -- If x_asset_type_hook_used is 1, then override l_p_mass_add_rec.date_placed_in_service

Line 1821: l_c_mass_add_rec.created_by := fnd_global.user_id;

1817: l_c_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
1818: l_c_mass_add_rec.queue_name := 'POST';
1819: l_c_mass_add_rec.asset_type := 'CAPITALIZED';
1820: l_c_mass_add_rec.depreciate_flag := 'YES';
1821: l_c_mass_add_rec.created_by := fnd_global.user_id;
1822: l_c_mass_add_rec.creation_date := sysdate;
1823: l_c_mass_add_rec.last_update_date := sysdate;
1824: l_c_mass_add_rec.last_update_login := fnd_global.login_id;
1825: l_c_mass_add_rec.assigned_to := p_instance_rec.employee_id; --Added for bug 9433941

Line 1824: l_c_mass_add_rec.last_update_login := fnd_global.login_id;

1820: l_c_mass_add_rec.depreciate_flag := 'YES';
1821: l_c_mass_add_rec.created_by := fnd_global.user_id;
1822: l_c_mass_add_rec.creation_date := sysdate;
1823: l_c_mass_add_rec.last_update_date := sysdate;
1824: l_c_mass_add_rec.last_update_login := fnd_global.login_id;
1825: l_c_mass_add_rec.assigned_to := p_instance_rec.employee_id; --Added for bug 9433941
1826:
1827: IF p_instance_rec.fa_group_by = 'ITEM' THEN
1828: l_c_mass_add_rec.payables_units := p_instance_rec.mtl_txn_qty;

Line 2051: l_mass_add_rec.created_by := fnd_global.user_id;

2047: l_mass_add_rec.expense_code_combination_id := p_instance_rec.deprn_expense_ccid;
2048: l_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
2049: l_mass_add_rec.asset_type := 'CAPITALIZED';
2050: l_mass_add_rec.depreciate_flag := 'YES';
2051: l_mass_add_rec.created_by := fnd_global.user_id;
2052: l_mass_add_rec.creation_date := sysdate;
2053: l_mass_add_rec.last_update_date := sysdate;
2054: l_mass_add_rec.last_update_login := fnd_global.login_id;
2055: l_mass_add_rec.assigned_to := p_instance_rec.employee_id; --Added for bug 7456755

Line 2054: l_mass_add_rec.last_update_login := fnd_global.login_id;

2050: l_mass_add_rec.depreciate_flag := 'YES';
2051: l_mass_add_rec.created_by := fnd_global.user_id;
2052: l_mass_add_rec.creation_date := sysdate;
2053: l_mass_add_rec.last_update_date := sysdate;
2054: l_mass_add_rec.last_update_login := fnd_global.login_id;
2055: l_mass_add_rec.assigned_to := p_instance_rec.employee_id; --Added for bug 7456755
2056:
2057: l_mass_add_rec.po_number := p_instance_rec.po_number;
2058: l_mass_add_rec.po_vendor_id := p_instance_rec.po_vendor_id;

Line 2297: l_csi_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

2293: --l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
2294:
2295: l_csi_txn_rec.transaction_type_id := 123; -- instance_asset_tieback
2296: l_csi_txn_rec.source_transaction_date := sysdate;
2297: l_csi_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2298: l_csi_txn_rec.transaction_status_code := 'COMPLETE';
2299:
2300: FOR csi_txn_rec IN csi_pending_txn_cur
2301: LOOP

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

3692: l_ext_ret_rec.units := ABS(p_mass_add_rec.payables_units );
3693: l_ext_ret_rec.cost_of_removal := 0;
3694: l_ext_ret_rec.proceeds_of_sale := 0;
3695: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
3696: l_ext_ret_rec.created_by := fnd_global.user_id;
3697: l_ext_ret_rec.creation_date := l_sysdate;
3698: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3699: l_ext_ret_rec.last_update_date := l_sysdate;
3700: l_ext_ret_rec.last_update_login := fnd_global.login_id;

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

3694: l_ext_ret_rec.proceeds_of_sale := 0;
3695: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
3696: l_ext_ret_rec.created_by := fnd_global.user_id;
3697: l_ext_ret_rec.creation_date := l_sysdate;
3698: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3699: l_ext_ret_rec.last_update_date := l_sysdate;
3700: l_ext_ret_rec.last_update_login := fnd_global.login_id;
3701: l_ext_ret_rec.retirement_prorate_convention := l_prorate_convention ;
3702:

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

3696: l_ext_ret_rec.created_by := fnd_global.user_id;
3697: l_ext_ret_rec.creation_date := l_sysdate;
3698: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3699: l_ext_ret_rec.last_update_date := l_sysdate;
3700: l_ext_ret_rec.last_update_login := fnd_global.login_id;
3701: l_ext_ret_rec.retirement_prorate_convention := l_prorate_convention ;
3702:
3703: cse_asset_adjust_pkg.insert_retirement(
3704: l_ext_ret_rec,