DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FND_GLOBAL

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

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

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

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

Line 208: last_updated_by = fnd_global.user_id,

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

Line 209: last_update_login = fnd_global.login_id,

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

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

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

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

1608: l_p_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
1609: l_p_mass_add_rec.queue_name := 'POST';
1610: l_p_mass_add_rec.asset_type := 'CAPITALIZED';
1611: l_p_mass_add_rec.depreciate_flag := 'YES';
1612: l_p_mass_add_rec.created_by := fnd_global.user_id;
1613: l_p_mass_add_rec.creation_date := sysdate;
1614: l_p_mass_add_rec.last_update_date := sysdate;
1615: l_p_mass_add_rec.last_update_login := fnd_global.login_id;
1616:

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

1611: l_p_mass_add_rec.depreciate_flag := 'YES';
1612: l_p_mass_add_rec.created_by := fnd_global.user_id;
1613: l_p_mass_add_rec.creation_date := sysdate;
1614: l_p_mass_add_rec.last_update_date := sysdate;
1615: l_p_mass_add_rec.last_update_login := fnd_global.login_id;
1616:
1617: SELECT default_group_asset_id
1618: INTO l_p_mass_add_rec.group_asset_id
1619: FROM fa_category_books

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

1718: l_c_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
1719: l_c_mass_add_rec.queue_name := 'POST';
1720: l_c_mass_add_rec.asset_type := 'CAPITALIZED';
1721: l_c_mass_add_rec.depreciate_flag := 'YES';
1722: l_c_mass_add_rec.created_by := fnd_global.user_id;
1723: l_c_mass_add_rec.creation_date := sysdate;
1724: l_c_mass_add_rec.last_update_date := sysdate;
1725: l_c_mass_add_rec.last_update_login := fnd_global.login_id;
1726:

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

1721: l_c_mass_add_rec.depreciate_flag := 'YES';
1722: l_c_mass_add_rec.created_by := fnd_global.user_id;
1723: l_c_mass_add_rec.creation_date := sysdate;
1724: l_c_mass_add_rec.last_update_date := sysdate;
1725: l_c_mass_add_rec.last_update_login := fnd_global.login_id;
1726:
1727: IF p_instance_rec.fa_group_by = 'ITEM' THEN
1728: l_c_mass_add_rec.payables_units := p_instance_rec.mtl_txn_qty;
1729: l_c_mass_add_rec.fixed_assets_units := p_instance_rec.mtl_txn_qty;

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

1913: l_mass_add_rec.expense_code_combination_id := p_instance_rec.deprn_expense_ccid;
1914: l_mass_add_rec.feeder_system_name := 'ORACLE ENTERPRISE INSTALL BASE';
1915: l_mass_add_rec.asset_type := 'CAPITALIZED';
1916: l_mass_add_rec.depreciate_flag := 'YES';
1917: l_mass_add_rec.created_by := fnd_global.user_id;
1918: l_mass_add_rec.creation_date := sysdate;
1919: l_mass_add_rec.last_update_date := sysdate;
1920: l_mass_add_rec.last_update_login := fnd_global.login_id;
1921:

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

1916: l_mass_add_rec.depreciate_flag := 'YES';
1917: l_mass_add_rec.created_by := fnd_global.user_id;
1918: l_mass_add_rec.creation_date := sysdate;
1919: l_mass_add_rec.last_update_date := sysdate;
1920: l_mass_add_rec.last_update_login := fnd_global.login_id;
1921:
1922: l_mass_add_rec.po_number := p_instance_rec.po_number;
1923: l_mass_add_rec.po_vendor_id := p_instance_rec.po_vendor_id;
1924: l_mass_add_rec.po_distribution_id := p_instance_rec.po_distribution_id;

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

2125: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
2126:
2127: l_csi_txn_rec.transaction_type_id := 123; -- instance_asset_tieback
2128: l_csi_txn_rec.source_transaction_date := sysdate;
2129: l_csi_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2130: l_csi_txn_rec.transaction_status_code := 'COMPLETE';
2131:
2132: FOR csi_txn_rec IN csi_pending_txn_cur
2133: LOOP

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

3356: l_ext_ret_rec.units := ABS(p_mass_add_rec.payables_units );
3357: l_ext_ret_rec.cost_of_removal := 0;
3358: l_ext_ret_rec.proceeds_of_sale := 0;
3359: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
3360: l_ext_ret_rec.created_by := fnd_global.user_id;
3361: l_ext_ret_rec.creation_date := l_sysdate;
3362: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3363: l_ext_ret_rec.last_update_date := l_sysdate;
3364: l_ext_ret_rec.last_update_login := fnd_global.login_id;

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

3358: l_ext_ret_rec.proceeds_of_sale := 0;
3359: l_ext_ret_rec.calc_gain_loss_flag := 'N' ;
3360: l_ext_ret_rec.created_by := fnd_global.user_id;
3361: l_ext_ret_rec.creation_date := l_sysdate;
3362: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3363: l_ext_ret_rec.last_update_date := l_sysdate;
3364: l_ext_ret_rec.last_update_login := fnd_global.login_id;
3365: l_ext_ret_rec.retirement_prorate_convention := l_prorate_convention ;
3366:

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

3360: l_ext_ret_rec.created_by := fnd_global.user_id;
3361: l_ext_ret_rec.creation_date := l_sysdate;
3362: l_ext_ret_rec.last_updated_by := fnd_global.user_id;
3363: l_ext_ret_rec.last_update_date := l_sysdate;
3364: l_ext_ret_rec.last_update_login := fnd_global.login_id;
3365: l_ext_ret_rec.retirement_prorate_convention := l_prorate_convention ;
3366:
3367: cse_asset_adjust_pkg.insert_retirement(
3368: l_ext_ret_rec,