152: l_rcv_ei_tbl rcv_ei_tbl;
153:
154: BEGIN
155: x_in_service_flag := 'Y'; -- Bug 8565319
156: x_return_status := fnd_api.g_ret_sts_success;
157:
158: debug('Inside API cse_ap_pa_pkg.get_prorated_ei');
159:
160: IF px_ap_pa_tbl.COUNT > 0 THEN
294:
295: l_ind binary_integer := 0;
296: l_nl_pa_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type;
297:
298: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
299: l_error_message varchar2(2000);
300:
301: BEGIN
302:
299: l_error_message varchar2(2000);
300:
301: BEGIN
302:
303: x_return_status := fnd_api.g_ret_sts_success;
304:
305: debug('Inside API cse_ap_pa_pkg.populate_pa_txn_intf');
306:
307: IF p_ap_pa_tbl.count > 0 THEN
381: p_nl_pa_interface_tbl => l_nl_pa_tbl,
382: x_return_status => l_return_status,
383: x_error_message => l_error_message);
384:
385: IF l_return_status <> fnd_api.g_ret_sts_success THEN
386: RAISE fnd_api.g_exc_error;
387: END IF;
388:
389: END IF;
382: x_return_status => l_return_status,
383: x_error_message => l_error_message);
384:
385: IF l_return_status <> fnd_api.g_ret_sts_success THEN
386: RAISE fnd_api.g_exc_error;
387: END IF;
388:
389: END IF;
390:
389: END IF;
390:
391: EXCEPTION
392: WHEN others THEN
393: x_return_status := fnd_api.g_ret_sts_error;
394: x_error_message := l_error_message;
395: END populate_pa_txn_intf;
396:
397:
457: AND aila.invoice_id = aida.invoice_id
458: AND aila.line_number = aida.invoice_line_number
459: AND aia.invoice_id = aida.invoice_id;
460:
461: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
462: l_error_message varchar2(2000);
463: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
464: l_msg_data varchar2(2000);
465: l_msg_count number;
733: END IF; -- need to put TIPV for TIPV case --Modified for bug 8927385
734:
735: debug(' ipv_ccid : '||l_ap_pa_tbl(1).inv_dist_ccid);
736: IF l_ap_pa_tbl(1).inv_dist_ccid = -99 THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: get_prorated_ei(
741: px_ap_pa_tbl => l_ap_pa_tbl,
741: px_ap_pa_tbl => l_ap_pa_tbl,
742: x_in_service_flag => l_in_service_flag, -- Bug 8565319
743: x_return_status => l_return_status);
744:
745: IF l_return_status <> fnd_api.g_ret_sts_success THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: IF l_in_service_flag <> 'N' THEN -- Bug 8565319
742: x_in_service_flag => l_in_service_flag, -- Bug 8565319
743: x_return_status => l_return_status);
744:
745: IF l_return_status <> fnd_api.g_ret_sts_success THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: IF l_in_service_flag <> 'N' THEN -- Bug 8565319
750: populate_pa_txn_intf(
752: x_return_status => l_return_status,
753: x_error_message => l_error_message);
754: END IF; -- Bug 8565319
755:
756: IF l_return_status <> fnd_api.g_ret_sts_success THEN
757: RAISE fnd_api.g_exc_error;
758: END IF;
759:
760: END IF;
753: x_error_message => l_error_message);
754: END IF; -- Bug 8565319
755:
756: IF l_return_status <> fnd_api.g_ret_sts_success THEN
757: RAISE fnd_api.g_exc_error;
758: END IF;
759:
760: END IF;
761:
793:
794: END LOOP;
795:
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798:
799: l_txn_error_rec := CSE_UTIL_PKG.init_txn_error_Rec;
800: l_txn_error_rec.error_text := nvl(l_error_message,cse_util_pkg.dump_error_stack);
801: l_txn_error_rec.source_group_ref_id := fnd_global.conc_request_id;
804: l_txn_error_rec.processed_flag := 'N';
805:
806: csi_transactions_pvt.create_txn_error(
807: p_api_version => 1.0 ,
808: p_init_msg_list => fnd_api.g_true,
809: p_commit => fnd_api.g_true,
810: p_validation_level => fnd_api.g_valid_level_full,
811: p_txn_error_rec => l_txn_error_rec,
812: x_return_status => l_return_status,
805:
806: csi_transactions_pvt.create_txn_error(
807: p_api_version => 1.0 ,
808: p_init_msg_list => fnd_api.g_true,
809: p_commit => fnd_api.g_true,
810: p_validation_level => fnd_api.g_valid_level_full,
811: p_txn_error_rec => l_txn_error_rec,
812: x_return_status => l_return_status,
813: x_msg_count => l_msg_count,
806: csi_transactions_pvt.create_txn_error(
807: p_api_version => 1.0 ,
808: p_init_msg_list => fnd_api.g_true,
809: p_commit => fnd_api.g_true,
810: p_validation_level => fnd_api.g_valid_level_full,
811: p_txn_error_rec => l_txn_error_rec,
812: x_return_status => l_return_status,
813: x_msg_count => l_msg_count,
814: x_msg_data => l_msg_data,