DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on FND_API

Line 155: x_return_status := fnd_api.g_ret_sts_success;

151: l_rcv_ei_tbl rcv_ei_tbl;
152:
153: BEGIN
154:
155: x_return_status := fnd_api.g_ret_sts_success;
156:
157: debug('Inside API cse_ap_pa_pkg.get_prorated_ei');
158:
159: IF px_ap_pa_tbl.COUNT > 0 THEN

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

292:
293: l_ind binary_integer := 0;
294: l_nl_pa_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type;
295:
296: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
297: l_error_message varchar2(2000);
298:
299: BEGIN
300:

Line 301: x_return_status := fnd_api.g_ret_sts_success;

297: l_error_message varchar2(2000);
298:
299: BEGIN
300:
301: x_return_status := fnd_api.g_ret_sts_success;
302:
303: debug('Inside API cse_ap_pa_pkg.populate_pa_txn_intf');
304:
305: IF p_ap_pa_tbl.count > 0 THEN

Line 383: IF l_return_status <> fnd_api.g_ret_sts_success THEN

379: p_nl_pa_interface_tbl => l_nl_pa_tbl,
380: x_return_status => l_return_status,
381: x_error_message => l_error_message);
382:
383: IF l_return_status <> fnd_api.g_ret_sts_success THEN
384: RAISE fnd_api.g_exc_error;
385: END IF;
386:
387: END IF;

Line 384: RAISE fnd_api.g_exc_error;

380: x_return_status => l_return_status,
381: x_error_message => l_error_message);
382:
383: IF l_return_status <> fnd_api.g_ret_sts_success THEN
384: RAISE fnd_api.g_exc_error;
385: END IF;
386:
387: END IF;
388:

Line 391: x_return_status := fnd_api.g_ret_sts_error;

387: END IF;
388:
389: EXCEPTION
390: WHEN others THEN
391: x_return_status := fnd_api.g_ret_sts_error;
392: x_error_message := l_error_message;
393: END populate_pa_txn_intf;
394:
395:

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

444: AND aila.invoice_id = aida.invoice_id
445: AND aila.line_number = aida.invoice_line_number
446: AND aia.invoice_id = aida.invoice_id;
447:
448: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
449: l_error_message varchar2(2000);
450: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
451: l_msg_data varchar2(2000);
452: l_msg_count number;

Line 679: RAISE fnd_api.g_exc_error;

675: p_invoice_id => ap_inv_rec.invoice_id,
676: p_invoice_dist_type => 'IPV');
677: debug(' ipv_ccid : '||l_ap_pa_tbl(1).inv_dist_ccid);
678: IF l_ap_pa_tbl(1).inv_dist_ccid = -99 THEN
679: RAISE fnd_api.g_exc_error;
680: END IF;
681:
682: get_prorated_ei(
683: px_ap_pa_tbl => l_ap_pa_tbl,

Line 686: IF l_return_status <> fnd_api.g_ret_sts_success THEN

682: get_prorated_ei(
683: px_ap_pa_tbl => l_ap_pa_tbl,
684: x_return_status => l_return_status);
685:
686: IF l_return_status <> fnd_api.g_ret_sts_success THEN
687: RAISE fnd_api.g_exc_error;
688: END IF;
689:
690: populate_pa_txn_intf(

Line 687: RAISE fnd_api.g_exc_error;

683: px_ap_pa_tbl => l_ap_pa_tbl,
684: x_return_status => l_return_status);
685:
686: IF l_return_status <> fnd_api.g_ret_sts_success THEN
687: RAISE fnd_api.g_exc_error;
688: END IF;
689:
690: populate_pa_txn_intf(
691: p_ap_pa_tbl => l_ap_pa_tbl,

Line 695: IF l_return_status <> fnd_api.g_ret_sts_success THEN

691: p_ap_pa_tbl => l_ap_pa_tbl,
692: x_return_status => l_return_status,
693: x_error_message => l_error_message);
694:
695: IF l_return_status <> fnd_api.g_ret_sts_success THEN
696: RAISE fnd_api.g_exc_error;
697: END IF;
698:
699: END IF;

Line 696: RAISE fnd_api.g_exc_error;

692: x_return_status => l_return_status,
693: x_error_message => l_error_message);
694:
695: IF l_return_status <> fnd_api.g_ret_sts_success THEN
696: RAISE fnd_api.g_exc_error;
697: END IF;
698:
699: END IF;
700:

Line 723: WHEN fnd_api.g_exc_error THEN

719:
720: END LOOP;
721:
722: EXCEPTION
723: WHEN fnd_api.g_exc_error THEN
724:
725: l_txn_error_rec := CSE_UTIL_PKG.init_txn_error_Rec;
726: l_txn_error_rec.error_text := nvl(l_error_message,cse_util_pkg.dump_error_stack);
727: l_txn_error_rec.source_group_ref_id := fnd_global.conc_request_id;

Line 734: p_init_msg_list => fnd_api.g_true,

730: l_txn_error_rec.processed_flag := 'N';
731:
732: csi_transactions_pvt.create_txn_error(
733: p_api_version => 1.0 ,
734: p_init_msg_list => fnd_api.g_true,
735: p_commit => fnd_api.g_true,
736: p_validation_level => fnd_api.g_valid_level_full,
737: p_txn_error_rec => l_txn_error_rec,
738: x_return_status => l_return_status,

Line 735: p_commit => fnd_api.g_true,

731:
732: csi_transactions_pvt.create_txn_error(
733: p_api_version => 1.0 ,
734: p_init_msg_list => fnd_api.g_true,
735: p_commit => fnd_api.g_true,
736: p_validation_level => fnd_api.g_valid_level_full,
737: p_txn_error_rec => l_txn_error_rec,
738: x_return_status => l_return_status,
739: x_msg_count => l_msg_count,

Line 736: p_validation_level => fnd_api.g_valid_level_full,

732: csi_transactions_pvt.create_txn_error(
733: p_api_version => 1.0 ,
734: p_init_msg_list => fnd_api.g_true,
735: p_commit => fnd_api.g_true,
736: p_validation_level => fnd_api.g_valid_level_full,
737: p_txn_error_rec => l_txn_error_rec,
738: x_return_status => l_return_status,
739: x_msg_count => l_msg_count,
740: x_msg_data => l_msg_data,