19: IS
20: BEGIN
21: IF l_debug = 'Y' THEN
22: cse_debug_pub.add(p_message);
23: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
24: fnd_file.put_line(fnd_file.log, p_message);
25: END IF;
26: END IF;
27: EXCEPTION
31:
32: PROCEDURE write_report( p_message IN VARCHAR2)
33: IS
34: BEGIN
35: IF fnd_global.conc_request_id is not null THEN
36: fnd_file.put_line(fnd_file.output,p_message);
37: END IF;
38: END write_report;
39:
76: l_Exceptions c_Exceptions%ROWTYPE;
77: l_conc_request_id NUMBER;
78:
79: BEGIN
80: IF fnd_global.conc_request_id is not null THEN
81: l_conc_request_id := fnd_global.conc_request_id ;
82:
83: OPEN c_success_count(l_conc_request_id) ;
84: FETCH c_success_count INTO l_success_count;
77: l_conc_request_id NUMBER;
78:
79: BEGIN
80: IF fnd_global.conc_request_id is not null THEN
81: l_conc_request_id := fnd_global.conc_request_id ;
82:
83: OPEN c_success_count(l_conc_request_id) ;
84: FETCH c_success_count INTO l_success_count;
85: CLOSE c_success_count ;
271:
272: BEGIN
273:
274: debug('inside interface_to_fa');
275: IF fnd_global.conc_request_id is not null THEN
276: l_conc_request_id := fnd_global.conc_request_id ;
277: END IF;
278: x_return_status := fnd_api.g_ret_sts_success;
279:
272: BEGIN
273:
274: debug('inside interface_to_fa');
275: IF fnd_global.conc_request_id is not null THEN
276: l_conc_request_id := fnd_global.conc_request_id ;
277: END IF;
278: x_return_status := fnd_api.g_ret_sts_success;
279:
280: FOR csi_txn_rec IN csi_txn_cur(p_invoice_rec.po_dist_id)
489: l_mass_add_rec.asset_type := 'CAPITALIZED';
490: l_mass_add_rec.depreciate_flag := 'YES' ;
491: l_mass_add_rec.creation_date := sysdate;
492: l_mass_add_rec.last_update_date := sysdate;
493: l_mass_add_rec.created_by := fnd_global.user_id;
494: l_mass_add_rec.last_updated_by := fnd_global.user_id;
495: l_mass_add_rec.last_update_login := fnd_global.login_id;
496:
497: cse_asset_util_pkg.insert_mass_add(
490: l_mass_add_rec.depreciate_flag := 'YES' ;
491: l_mass_add_rec.creation_date := sysdate;
492: l_mass_add_rec.last_update_date := sysdate;
493: l_mass_add_rec.created_by := fnd_global.user_id;
494: l_mass_add_rec.last_updated_by := fnd_global.user_id;
495: l_mass_add_rec.last_update_login := fnd_global.login_id;
496:
497: cse_asset_util_pkg.insert_mass_add(
498: p_api_version => 1.0,
491: l_mass_add_rec.creation_date := sysdate;
492: l_mass_add_rec.last_update_date := sysdate;
493: l_mass_add_rec.created_by := fnd_global.user_id;
494: l_mass_add_rec.last_updated_by := fnd_global.user_id;
495: l_mass_add_rec.last_update_login := fnd_global.login_id;
496:
497: cse_asset_util_pkg.insert_mass_add(
498: p_api_version => 1.0,
499: p_commit => fnd_api.g_false,
549: IS
550:
551: l_ib_trackable_flag varchar2(1);
552: l_asset_creation_code varchar2(1);
553: l_conc_request_id number := fnd_global.conc_request_id;
554: l_processed_flag varchar2(1);
555: l_invoice_rec invoice_rec;
556: l_payables_ccid number;
557: