eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_FA_INTEGRATION_GRP dependencies on FND_API

Line 61: l_csi_txn_id number := fnd_api.g_miss_num;

57: WHERE transaction_type_id = 123
58: AND source_line_ref = 'MASS_ADD_ID'
59: AND source_line_ref_id = p_mass_addition_id
60: ORDER by source_transaction_date desc;
61: l_csi_txn_id number := fnd_api.g_miss_num;
62: BEGIN
63: IF p_mass_addition_id is not null THEN
64: FOR ma_txn_rec IN ma_txn_cur
65: LOOP

Line 83: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

79: l_asset_count_rec csi_asset_pvt.asset_count_rec;
80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
82:
83: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
84: l_msg_count number;
85: l_msg_data varchar2(2000);
86: BEGIN
87:

Line 88: x_return_status := fnd_api.g_ret_sts_success;

84: l_msg_count number;
85: l_msg_data varchar2(2000);
86: BEGIN
87:
88: x_return_status := fnd_api.g_ret_sts_success;
89:
90: px_inst_asset_rec.fa_sync_flag := 'Y';
91:
92: csi_asset_pvt.create_instance_asset(

Line 94: p_commit => fnd_api.g_false,

90: px_inst_asset_rec.fa_sync_flag := 'Y';
91:
92: csi_asset_pvt.create_instance_asset(
93: p_api_version => 1.0 ,
94: p_commit => fnd_api.g_false,
95: p_init_msg_list => fnd_api.g_true,
96: p_validation_level => fnd_api.g_valid_level_full,
97: p_instance_asset_rec => px_inst_asset_rec,
98: p_txn_rec => px_csi_txn_rec,

Line 95: p_init_msg_list => fnd_api.g_true,

91:
92: csi_asset_pvt.create_instance_asset(
93: p_api_version => 1.0 ,
94: p_commit => fnd_api.g_false,
95: p_init_msg_list => fnd_api.g_true,
96: p_validation_level => fnd_api.g_valid_level_full,
97: p_instance_asset_rec => px_inst_asset_rec,
98: p_txn_rec => px_csi_txn_rec,
99: x_return_status => l_return_status,

Line 96: p_validation_level => fnd_api.g_valid_level_full,

92: csi_asset_pvt.create_instance_asset(
93: p_api_version => 1.0 ,
94: p_commit => fnd_api.g_false,
95: p_init_msg_list => fnd_api.g_true,
96: p_validation_level => fnd_api.g_valid_level_full,
97: p_instance_asset_rec => px_inst_asset_rec,
98: p_txn_rec => px_csi_txn_rec,
99: x_return_status => l_return_status,
100: x_msg_count => l_msg_count,

Line 107: IF l_return_status <> fnd_api.g_ret_sts_success THEN

103: p_asset_count_rec => l_asset_count_rec,
104: p_asset_id_tbl => l_asset_id_tbl,
105: p_asset_loc_tbl => l_asset_loc_tbl);
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN
108: RAISE fnd_api.g_exc_error;
109: END IF;
110:
111: EXCEPTION

Line 108: RAISE fnd_api.g_exc_error;

104: p_asset_id_tbl => l_asset_id_tbl,
105: p_asset_loc_tbl => l_asset_loc_tbl);
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN
108: RAISE fnd_api.g_exc_error;
109: END IF;
110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN

Line 112: WHEN fnd_api.g_exc_error THEN

108: RAISE fnd_api.g_exc_error;
109: END IF;
110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: x_return_status := fnd_api.g_ret_sts_error;
114: END create_inst_asset;
115:
116:

Line 113: x_return_status := fnd_api.g_ret_sts_error;

109: END IF;
110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: x_return_status := fnd_api.g_ret_sts_error;
114: END create_inst_asset;
115:
116:
117: PROCEDURE update_inst_asset(

Line 128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

124: l_asset_count_rec csi_asset_pvt.asset_count_rec;
125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
127:
128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
129: l_msg_count number;
130: l_msg_data varchar2(2000);
131: BEGIN
132:

Line 133: x_return_status := fnd_api.g_ret_sts_success;

129: l_msg_count number;
130: l_msg_data varchar2(2000);
131: BEGIN
132:
133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: px_inst_asset_rec.fa_sync_flag := 'Y';
136: px_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
137:

Line 136: px_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;

132:
133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: px_inst_asset_rec.fa_sync_flag := 'Y';
136: px_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
137:
138: csi_asset_pvt.update_instance_asset (
139: p_api_version => 1.0,
140: p_commit => fnd_api.g_false,

Line 140: p_commit => fnd_api.g_false,

136: px_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
137:
138: csi_asset_pvt.update_instance_asset (
139: p_api_version => 1.0,
140: p_commit => fnd_api.g_false,
141: p_init_msg_list => fnd_api.g_true,
142: p_validation_level => fnd_api.g_valid_level_full,
143: p_instance_asset_rec => px_inst_asset_rec,
144: p_txn_rec => px_csi_txn_rec,

Line 141: p_init_msg_list => fnd_api.g_true,

137:
138: csi_asset_pvt.update_instance_asset (
139: p_api_version => 1.0,
140: p_commit => fnd_api.g_false,
141: p_init_msg_list => fnd_api.g_true,
142: p_validation_level => fnd_api.g_valid_level_full,
143: p_instance_asset_rec => px_inst_asset_rec,
144: p_txn_rec => px_csi_txn_rec,
145: x_return_status => l_return_status,

Line 142: p_validation_level => fnd_api.g_valid_level_full,

138: csi_asset_pvt.update_instance_asset (
139: p_api_version => 1.0,
140: p_commit => fnd_api.g_false,
141: p_init_msg_list => fnd_api.g_true,
142: p_validation_level => fnd_api.g_valid_level_full,
143: p_instance_asset_rec => px_inst_asset_rec,
144: p_txn_rec => px_csi_txn_rec,
145: x_return_status => l_return_status,
146: x_msg_count => l_msg_count,

Line 153: IF l_return_status <> fnd_api.g_ret_sts_success THEN

149: p_asset_count_rec => l_asset_count_rec,
150: p_asset_id_tbl => l_asset_id_tbl,
151: p_asset_loc_tbl => l_asset_loc_tbl);
152:
153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
154: RAISE fnd_api.g_exc_error;
155: END IF;
156:
157: EXCEPTION

Line 154: RAISE fnd_api.g_exc_error;

150: p_asset_id_tbl => l_asset_id_tbl,
151: p_asset_loc_tbl => l_asset_loc_tbl);
152:
153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
154: RAISE fnd_api.g_exc_error;
155: END IF;
156:
157: EXCEPTION
158: WHEN fnd_api.g_exc_error THEN

Line 158: WHEN fnd_api.g_exc_error THEN

154: RAISE fnd_api.g_exc_error;
155: END IF;
156:
157: EXCEPTION
158: WHEN fnd_api.g_exc_error THEN
159: x_return_status := fnd_api.g_ret_sts_error;
160: END update_inst_asset;
161:
162: FUNCTION addition(

Line 159: x_return_status := fnd_api.g_ret_sts_error;

155: END IF;
156:
157: EXCEPTION
158: WHEN fnd_api.g_exc_error THEN
159: x_return_status := fnd_api.g_ret_sts_error;
160: END update_inst_asset;
161:
162: FUNCTION addition(
163: p_trans_rec IN fa_api_types.trans_rec_type,

Line 180: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

176: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
177: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
178: l_time_stamp date := null;
179:
180: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
181: l_msg_count number;
182: l_msg_data varchar2(2000);
183:
184: CURSOR cia_cur(p_mass_addition_id IN number) IS

Line 261: IF l_return_status <> fnd_api.g_ret_sts_success THEN

257: px_csi_txn_rec => l_csi_txn_rec,
258: px_inst_asset_rec => l_inst_asset_rec,
259: x_return_status => l_return_status);
260:
261: IF l_return_status <> fnd_api.g_ret_sts_success THEN
262: RAISE fnd_api.g_exc_error;
263: END IF;
264:
265: END LOOP;

Line 262: RAISE fnd_api.g_exc_error;

258: px_inst_asset_rec => l_inst_asset_rec,
259: x_return_status => l_return_status);
260:
261: IF l_return_status <> fnd_api.g_ret_sts_success THEN
262: RAISE fnd_api.g_exc_error;
263: END IF;
264:
265: END LOOP;
266:

Line 291: p_commit => fnd_api.g_false,

287: l_inst_asset_query_rec.instance_id := l_instance_id;
288:
289: csi_asset_pvt.get_instance_assets(
290: p_api_version => 1.0,
291: p_commit => fnd_api.g_false,
292: p_init_msg_list => fnd_api.g_true,
293: p_validation_level => fnd_api.g_valid_level_full,
294: p_instance_asset_query_rec => l_inst_asset_query_rec,
295: p_resolve_id_columns => fnd_api.g_false,

Line 292: p_init_msg_list => fnd_api.g_true,

288:
289: csi_asset_pvt.get_instance_assets(
290: p_api_version => 1.0,
291: p_commit => fnd_api.g_false,
292: p_init_msg_list => fnd_api.g_true,
293: p_validation_level => fnd_api.g_valid_level_full,
294: p_instance_asset_query_rec => l_inst_asset_query_rec,
295: p_resolve_id_columns => fnd_api.g_false,
296: p_time_stamp => l_time_stamp,

Line 293: p_validation_level => fnd_api.g_valid_level_full,

289: csi_asset_pvt.get_instance_assets(
290: p_api_version => 1.0,
291: p_commit => fnd_api.g_false,
292: p_init_msg_list => fnd_api.g_true,
293: p_validation_level => fnd_api.g_valid_level_full,
294: p_instance_asset_query_rec => l_inst_asset_query_rec,
295: p_resolve_id_columns => fnd_api.g_false,
296: p_time_stamp => l_time_stamp,
297: x_instance_asset_tbl => l_inst_asset_tbl,

Line 295: p_resolve_id_columns => fnd_api.g_false,

291: p_commit => fnd_api.g_false,
292: p_init_msg_list => fnd_api.g_true,
293: p_validation_level => fnd_api.g_valid_level_full,
294: p_instance_asset_query_rec => l_inst_asset_query_rec,
295: p_resolve_id_columns => fnd_api.g_false,
296: p_time_stamp => l_time_stamp,
297: x_instance_asset_tbl => l_inst_asset_tbl,
298: x_return_status => l_return_status,
299: x_msg_count => l_msg_count,

Line 302: IF l_return_status <> fnd_api.g_ret_sts_success THEN

298: x_return_status => l_return_status,
299: x_msg_count => l_msg_count,
300: x_msg_data => l_msg_data);
301:
302: IF l_return_status <> fnd_api.g_ret_sts_success THEN
303: RAISE fnd_api.g_exc_error;
304: END IF;
305:
306: IF l_inst_asset_tbl.COUNT = 0 THEN

Line 303: RAISE fnd_api.g_exc_error;

299: x_msg_count => l_msg_count,
300: x_msg_data => l_msg_data);
301:
302: IF l_return_status <> fnd_api.g_ret_sts_success THEN
303: RAISE fnd_api.g_exc_error;
304: END IF;
305:
306: IF l_inst_asset_tbl.COUNT = 0 THEN
307:

Line 314: l_inst_asset_rec.check_for_instance_expiry:= fnd_api.g_false;

310: l_inst_asset_rec.asset_quantity := p_asset_dist_tbl(1).units_assigned;
311: l_inst_asset_rec.fa_location_id := p_asset_dist_tbl(1).location_ccid;
312: l_inst_asset_rec.instance_id := l_instance_Id;
313: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;
314: l_inst_asset_rec.check_for_instance_expiry:= fnd_api.g_false;
315:
316: create_inst_asset(
317: px_csi_txn_rec => l_csi_txn_rec,
318: px_inst_asset_rec => l_inst_asset_rec,

Line 321: IF l_return_status <> fnd_api.g_ret_sts_success THEN

317: px_csi_txn_rec => l_csi_txn_rec,
318: px_inst_asset_rec => l_inst_asset_rec,
319: x_return_status => l_return_status);
320:
321: IF l_return_status <> fnd_api.g_ret_sts_success THEN
322: RAISE fnd_api.g_exc_error;
323: END IF;
324:
325: ELSE

Line 322: RAISE fnd_api.g_exc_error;

318: px_inst_asset_rec => l_inst_asset_rec,
319: x_return_status => l_return_status);
320:
321: IF l_return_status <> fnd_api.g_ret_sts_success THEN
322: RAISE fnd_api.g_exc_error;
323: END IF;
324:
325: ELSE
326:

Line 341: IF l_return_status <> fnd_api.g_ret_sts_success THEN

337: px_csi_txn_rec => l_csi_txn_rec,
338: px_inst_asset_rec => l_inst_asset_rec,
339: x_return_status => l_return_status);
340:
341: IF l_return_status <> fnd_api.g_ret_sts_success THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;
344: ELSE
345: null;

Line 342: RAISE fnd_api.g_exc_error;

338: px_inst_asset_rec => l_inst_asset_rec,
339: x_return_status => l_return_status);
340:
341: IF l_return_status <> fnd_api.g_ret_sts_success THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;
344: ELSE
345: null;
346: END IF;

Line 405: WHEN fnd_api.g_exc_error THEN

401:
402: END IF;
403: RETURN TRUE;
404: EXCEPTION
405: WHEN fnd_api.g_exc_error THEN
406: rollback to cse_addition;
407: RETURN FALSE;
408: WHEN others THEN
409: rollback to cse_addition;

Line 430: WHEN fnd_api.g_exc_error THEN

426: null;
427: END IF;
428: RETURN TRUE;
429: EXCEPTION
430: WHEN fnd_api.g_exc_error THEN
431: RETURN FALSE;
432: WHEN others THEN
433: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
434: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');

Line 465: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

461: l_xml_string varchar2(2000);
462: l_error_message varchar2(4000);
463: l_msg_count number;
464: l_msg_data varchar2(4000);
465: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
466:
467: CURSOR exp_inst_cur(p_project_asset_line_id IN number) IS
468: SELECT pei.expenditure_item_id,
469: pei.orig_transaction_reference txn_ref,

Line 581: p_init_msg_list => fnd_api.g_true,

577: debug('calling csi_transactions_pvt.create_txn_error to create unit adjustment entry');
578:
579: csi_transactions_pvt.create_txn_error(
580: p_api_version => 1.0,
581: p_init_msg_list => fnd_api.g_true,
582: p_commit => fnd_api.g_false,
583: p_validation_level => fnd_api.g_valid_level_full,
584: p_txn_error_rec => l_txn_error_rec,
585: x_return_status => l_return_status,

Line 582: p_commit => fnd_api.g_false,

578:
579: csi_transactions_pvt.create_txn_error(
580: p_api_version => 1.0,
581: p_init_msg_list => fnd_api.g_true,
582: p_commit => fnd_api.g_false,
583: p_validation_level => fnd_api.g_valid_level_full,
584: p_txn_error_rec => l_txn_error_rec,
585: x_return_status => l_return_status,
586: x_msg_count => l_msg_count,

Line 583: p_validation_level => fnd_api.g_valid_level_full,

579: csi_transactions_pvt.create_txn_error(
580: p_api_version => 1.0,
581: p_init_msg_list => fnd_api.g_true,
582: p_commit => fnd_api.g_false,
583: p_validation_level => fnd_api.g_valid_level_full,
584: p_txn_error_rec => l_txn_error_rec,
585: x_return_status => l_return_status,
586: x_msg_count => l_msg_count,
587: x_msg_data => l_msg_data,

Line 601: WHEN fnd_api.g_exc_error THEN

597:
598: RETURN TRUE;
599:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: RETURN FALSE;
603: WHEN others THEN
604: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
605: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');

Line 624: WHEN fnd_api.g_exc_error THEN

620: null;
621: END IF;
622: RETURN TRUE;
623: EXCEPTION
624: WHEN fnd_api.g_exc_error THEN
625: RETURN FALSE;
626: WHEN others THEN
627: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
628: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');

Line 642: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

638: p_retirement_date IN date,
639: p_retirement_units IN number)
640: RETURN boolean
641: IS
642: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
643: l_error_message varchar2(2000);
644: BEGIN
645: IF is_oat_enabled THEN
646: null;

Line 650: WHEN fnd_api.g_exc_error THEN

646: null;
647: END IF;
648: RETURN TRUE;
649: EXCEPTION
650: WHEN fnd_api.g_exc_error THEN
651: RETURN FALSE;
652: WHEN others THEN
653: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
654: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');

Line 668: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

664: p_reinstatement_date IN date,
665: p_reinstatement_units IN number)
666: RETURN boolean
667: IS
668: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
669: l_error_message varchar2(2000);
670: BEGIN
671: IF is_oat_enabled THEN
672: -- invoke oat routines

Line 683: IF l_return_status <> fnd_api.g_ret_sts_success THEN

679: p_trans_by => fnd_global.user_id,
680: x_return_status => l_return_status,
681: x_error_message => l_error_message);
682:
683: IF l_return_status <> fnd_api.g_ret_sts_success THEN
684: RAISE fnd_api.g_exc_error;
685: END IF;
686:
687: END IF;

Line 684: RAISE fnd_api.g_exc_error;

680: x_return_status => l_return_status,
681: x_error_message => l_error_message);
682:
683: IF l_return_status <> fnd_api.g_ret_sts_success THEN
684: RAISE fnd_api.g_exc_error;
685: END IF;
686:
687: END IF;
688: RETURN TRUE;

Line 690: WHEN fnd_api.g_exc_error THEN

686:
687: END IF;
688: RETURN TRUE;
689: EXCEPTION
690: WHEN fnd_api.g_exc_error THEN
691: RETURN FALSE;
692: WHEN others THEN
693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
694: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');