DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on FND_API

Line 156: x_return_status := fnd_api.g_ret_sts_success;

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

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

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:

Line 303: x_return_status := fnd_api.g_ret_sts_success;

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

Line 385: IF l_return_status <> fnd_api.g_ret_sts_success 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;

Line 386: RAISE fnd_api.g_exc_error;

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:

Line 393: x_return_status := fnd_api.g_ret_sts_error;

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:

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

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;

Line 737: RAISE fnd_api.g_exc_error;

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,

Line 745: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 746: RAISE fnd_api.g_exc_error;

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(

Line 756: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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;

Line 757: RAISE fnd_api.g_exc_error;

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:

Line 797: WHEN fnd_api.g_exc_error THEN

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;

Line 808: p_init_msg_list => fnd_api.g_true,

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,

Line 809: p_commit => fnd_api.g_true,

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,

Line 810: p_validation_level => fnd_api.g_valid_level_full,

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,