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)
281: LOOP
282:
290: p_asset_attrib_rec => l_asset_attrib_rec,
291: x_error_msg => l_error_message,
292: x_return_status => l_return_status);
293:
294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
295: RAISE fnd_api.g_exc_error;
296: END IF;
297:
298: debug(' deprn_expense_ccid : '||l_expense_ccid);
291: x_error_msg => l_error_message,
292: x_return_status => l_return_status);
293:
294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
295: RAISE fnd_api.g_exc_error;
296: END IF;
297:
298: debug(' deprn_expense_ccid : '||l_expense_ccid);
299:
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,
500: p_init_msg_list => fnd_api.g_true,
501: p_mass_add_rec => l_mass_add_rec,
502: x_return_status => l_return_status,
503: x_msg_count => l_msg_count,
496:
497: cse_asset_util_pkg.insert_mass_add(
498: p_api_version => 1.0,
499: p_commit => fnd_api.g_false,
500: p_init_msg_list => fnd_api.g_true,
501: p_mass_add_rec => l_mass_add_rec,
502: x_return_status => l_return_status,
503: x_msg_count => l_msg_count,
504: x_msg_data => l_msg_data);
502: x_return_status => l_return_status,
503: x_msg_count => l_msg_count,
504: x_msg_data => l_msg_data);
505:
506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
507: RAISE fnd_api.g_exc_error;
508: END IF;
509:
510: x_processed_flag := 'Y';
503: x_msg_count => l_msg_count,
504: x_msg_data => l_msg_data);
505:
506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
507: RAISE fnd_api.g_exc_error;
508: END IF;
509:
510: x_processed_flag := 'Y';
511:
515: --END LOOP; -- csi_txn_loop;--commented for bug 13688378- facebook
516:
517:
518: EXCEPTION
519: WHEN fnd_api.g_exc_error THEN
520: l_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
521: debug('Error : '||l_error_message);
522: x_return_status := fnd_api.g_ret_sts_error;
523: x_processed_flag := 'N';
518: EXCEPTION
519: WHEN fnd_api.g_exc_error THEN
520: l_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
521: debug('Error : '||l_error_message);
522: x_return_status := fnd_api.g_ret_sts_error;
523: x_processed_flag := 'N';
524: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
525: l_txn_error_rec.error_text := l_error_message;
526: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
528: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
529: l_txn_error_rec.processed_flag := 'N';
530: csi_transactions_pvt.create_txn_error(
531: p_api_version => 1.0,
532: p_init_msg_list => fnd_api.g_true,
533: p_commit => fnd_api.g_false,
534: p_validation_level => fnd_api.g_valid_level_full,
535: p_txn_error_rec => l_txn_error_rec,
536: x_return_status => l_return_status,
529: l_txn_error_rec.processed_flag := 'N';
530: csi_transactions_pvt.create_txn_error(
531: p_api_version => 1.0,
532: p_init_msg_list => fnd_api.g_true,
533: p_commit => fnd_api.g_false,
534: p_validation_level => fnd_api.g_valid_level_full,
535: p_txn_error_rec => l_txn_error_rec,
536: x_return_status => l_return_status,
537: x_msg_count => l_msg_count,
530: csi_transactions_pvt.create_txn_error(
531: p_api_version => 1.0,
532: p_init_msg_list => fnd_api.g_true,
533: p_commit => fnd_api.g_false,
534: p_validation_level => fnd_api.g_valid_level_full,
535: p_txn_error_rec => l_txn_error_rec,
536: x_return_status => l_return_status,
537: x_msg_count => l_msg_count,
538: x_msg_data => l_msg_data,
554: l_processed_flag varchar2(1);
555: l_invoice_rec invoice_rec;
556: l_payables_ccid number;
557:
558: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
559:
560: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
561: l_msg_count NUMBER;
562: l_msg_data VARCHAR2(2000);
849:
850: BEGIN
851:
852: -- If the po_distribution_id is NULL call hook to dervice po_distribution_id -- Added for bug 13770784
853: IF NVL(invoice_rec.po_distribution_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
854:
855: debug('po_distribution_id is NULL. Calling cse_asset_client_ext_stub.derive_po_distribution_id');
856:
857: cse_asset_client_ext_stub.derive_po_distribution_id(
869:
870: END IF;
871:
872: -- If po_distribution_id is not null proceed with processing
873: IF NVL(invoice_rec.po_distribution_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
874:
875: debug(' invoice_dist_id : '||invoice_rec.invoice_distribution_id);
876: debug(' invoice_dist_line_num : '||invoice_rec.distribution_line_number);
877: debug(' invoice_id : '||invoice_rec.invoice_id);
988: p_invoice_rec => l_invoice_rec,
989: x_processed_flag => l_processed_flag,
990: x_return_status => l_return_status);
991:
992: IF l_return_status <> fnd_api.g_ret_sts_success THEN
993: RAISE fnd_api.g_exc_error;
994: END IF;
995:
996: END IF; -- item based, ib tracked and depreciable
989: x_processed_flag => l_processed_flag,
990: x_return_status => l_return_status);
991:
992: IF l_return_status <> fnd_api.g_ret_sts_success THEN
993: RAISE fnd_api.g_exc_error;
994: END IF;
995:
996: END IF; -- item based, ib tracked and depreciable
997:
1030: debug('Processed successfully. updating ap_self_assessed_tax_dist_all.assets_addition_flag = Y');
1031: END IF;
1032:
1033:
1034: END IF; --IF NVL(invoice_rec.po_distribution_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN -- Added for bug 13770784
1035:
1036: EXCEPTION
1037: WHEN fnd_api.g_exc_error THEN
1038: --null;
1033:
1034: END IF; --IF NVL(invoice_rec.po_distribution_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN -- Added for bug 13770784
1035:
1036: EXCEPTION
1037: WHEN fnd_api.g_exc_error THEN
1038: --null;
1039: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
1040: l_txn_error_rec.error_text := SQLERRM;
1041: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
1043: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
1044: l_txn_error_rec.processed_flag := 'N';
1045: csi_transactions_pvt.create_txn_error(
1046: p_api_version => 1.0,
1047: p_init_msg_list => fnd_api.g_true,
1048: p_commit => fnd_api.g_false,
1049: p_validation_level => fnd_api.g_valid_level_full,
1050: p_txn_error_rec => l_txn_error_rec,
1051: x_return_status => l_return_status,
1044: l_txn_error_rec.processed_flag := 'N';
1045: csi_transactions_pvt.create_txn_error(
1046: p_api_version => 1.0,
1047: p_init_msg_list => fnd_api.g_true,
1048: p_commit => fnd_api.g_false,
1049: p_validation_level => fnd_api.g_valid_level_full,
1050: p_txn_error_rec => l_txn_error_rec,
1051: x_return_status => l_return_status,
1052: x_msg_count => l_msg_count,
1045: csi_transactions_pvt.create_txn_error(
1046: p_api_version => 1.0,
1047: p_init_msg_list => fnd_api.g_true,
1048: p_commit => fnd_api.g_false,
1049: p_validation_level => fnd_api.g_valid_level_full,
1050: p_txn_error_rec => l_txn_error_rec,
1051: x_return_status => l_return_status,
1052: x_msg_count => l_msg_count,
1053: x_msg_data => l_msg_data,
1069: l_txn_error_rec.source_id := l_invoice_distribution_id;
1070: l_txn_error_rec.processed_flag := 'N';
1071: csi_transactions_pvt.create_txn_error(
1072: p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_true,
1074: p_commit => fnd_api.g_false,
1075: p_validation_level => fnd_api.g_valid_level_full,
1076: p_txn_error_rec => l_txn_error_rec,
1077: x_return_status => l_return_status,
1070: l_txn_error_rec.processed_flag := 'N';
1071: csi_transactions_pvt.create_txn_error(
1072: p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_true,
1074: p_commit => fnd_api.g_false,
1075: p_validation_level => fnd_api.g_valid_level_full,
1076: p_txn_error_rec => l_txn_error_rec,
1077: x_return_status => l_return_status,
1078: x_msg_count => l_msg_count,
1071: csi_transactions_pvt.create_txn_error(
1072: p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_true,
1074: p_commit => fnd_api.g_false,
1075: p_validation_level => fnd_api.g_valid_level_full,
1076: p_txn_error_rec => l_txn_error_rec,
1077: x_return_status => l_return_status,
1078: x_msg_count => l_msg_count,
1079: x_msg_data => l_msg_data,