DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on FND_API

Line 274: x_return_status := fnd_api.g_ret_sts_success;

270: debug('inside interface_to_fa');
271: IF fnd_global.conc_request_id is not null THEN
272: l_conc_request_id := fnd_global.conc_request_id ;
273: END IF;
274: x_return_status := fnd_api.g_ret_sts_success;
275:
276: FOR csi_txn_rec IN csi_txn_cur(p_invoice_rec.po_dist_id)
277: LOOP
278:

Line 290: IF l_return_status <> fnd_api.g_ret_sts_success THEN

286: p_asset_attrib_rec => l_asset_attrib_rec,
287: x_error_msg => l_error_message,
288: x_return_status => l_return_status);
289:
290: IF l_return_status <> fnd_api.g_ret_sts_success THEN
291: RAISE fnd_api.g_exc_error;
292: END IF;
293:
294: debug(' deprn_expense_ccid : '||l_expense_ccid);

Line 291: RAISE fnd_api.g_exc_error;

287: x_error_msg => l_error_message,
288: x_return_status => l_return_status);
289:
290: IF l_return_status <> fnd_api.g_ret_sts_success THEN
291: RAISE fnd_api.g_exc_error;
292: END IF;
293:
294: debug(' deprn_expense_ccid : '||l_expense_ccid);
295:

Line 453: p_commit => fnd_api.g_false,

449: l_mass_add_rec.last_update_login := fnd_global.login_id;
450:
451: cse_asset_util_pkg.insert_mass_add(
452: p_api_version => 1.0,
453: p_commit => fnd_api.g_false,
454: p_init_msg_list => fnd_api.g_true,
455: p_mass_add_rec => l_mass_add_rec,
456: x_return_status => l_return_status,
457: x_msg_count => l_msg_count,

Line 454: p_init_msg_list => fnd_api.g_true,

450:
451: cse_asset_util_pkg.insert_mass_add(
452: p_api_version => 1.0,
453: p_commit => fnd_api.g_false,
454: p_init_msg_list => fnd_api.g_true,
455: p_mass_add_rec => l_mass_add_rec,
456: x_return_status => l_return_status,
457: x_msg_count => l_msg_count,
458: x_msg_data => l_msg_data);

Line 460: IF l_return_status <> fnd_api.g_ret_sts_success THEN

456: x_return_status => l_return_status,
457: x_msg_count => l_msg_count,
458: x_msg_data => l_msg_data);
459:
460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
461: RAISE fnd_api.g_exc_error;
462: END IF;
463:
464: x_processed_flag := 'Y';

Line 461: RAISE fnd_api.g_exc_error;

457: x_msg_count => l_msg_count,
458: x_msg_data => l_msg_data);
459:
460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
461: RAISE fnd_api.g_exc_error;
462: END IF;
463:
464: x_processed_flag := 'Y';
465:

Line 473: WHEN fnd_api.g_exc_error THEN

469: END LOOP; -- csi_txn_loop;
470:
471:
472: EXCEPTION
473: WHEN fnd_api.g_exc_error THEN
474: l_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
475: debug('Error : '||l_error_message);
476: x_return_status := fnd_api.g_ret_sts_error;
477: x_processed_flag := 'N';

Line 476: x_return_status := fnd_api.g_ret_sts_error;

472: EXCEPTION
473: WHEN fnd_api.g_exc_error THEN
474: l_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
475: debug('Error : '||l_error_message);
476: x_return_status := fnd_api.g_ret_sts_error;
477: x_processed_flag := 'N';
478: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
479: l_txn_error_rec.error_text := l_error_message;
480: l_txn_error_rec.source_group_ref_id := l_conc_request_id;

Line 486: p_init_msg_list => fnd_api.g_true,

482: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
483: l_txn_error_rec.processed_flag := 'N';
484: csi_transactions_pvt.create_txn_error(
485: p_api_version => 1.0,
486: p_init_msg_list => fnd_api.g_true,
487: p_commit => fnd_api.g_false,
488: p_validation_level => fnd_api.g_valid_level_full,
489: p_txn_error_rec => l_txn_error_rec,
490: x_return_status => l_return_status,

Line 487: p_commit => fnd_api.g_false,

483: l_txn_error_rec.processed_flag := 'N';
484: csi_transactions_pvt.create_txn_error(
485: p_api_version => 1.0,
486: p_init_msg_list => fnd_api.g_true,
487: p_commit => fnd_api.g_false,
488: p_validation_level => fnd_api.g_valid_level_full,
489: p_txn_error_rec => l_txn_error_rec,
490: x_return_status => l_return_status,
491: x_msg_count => l_msg_count,

Line 488: p_validation_level => fnd_api.g_valid_level_full,

484: csi_transactions_pvt.create_txn_error(
485: p_api_version => 1.0,
486: p_init_msg_list => fnd_api.g_true,
487: p_commit => fnd_api.g_false,
488: p_validation_level => fnd_api.g_valid_level_full,
489: p_txn_error_rec => l_txn_error_rec,
490: x_return_status => l_return_status,
491: x_msg_count => l_msg_count,
492: x_msg_data => l_msg_data,

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

508: l_processed_flag varchar2(1);
509: l_invoice_rec invoice_rec;
510: l_payables_ccid number;
511:
512: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
513:
514: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
515: l_msg_count NUMBER;
516: l_msg_data VARCHAR2(2000);

Line 725: IF l_return_status <> fnd_api.g_ret_sts_success THEN

721: p_invoice_rec => l_invoice_rec,
722: x_processed_flag => l_processed_flag,
723: x_return_status => l_return_status);
724:
725: IF l_return_status <> fnd_api.g_ret_sts_success THEN
726: RAISE fnd_api.g_exc_error;
727: END IF;
728:
729: END IF; -- item based, ib tracked and depreciable

Line 726: RAISE fnd_api.g_exc_error;

722: x_processed_flag => l_processed_flag,
723: x_return_status => l_return_status);
724:
725: IF l_return_status <> fnd_api.g_ret_sts_success THEN
726: RAISE fnd_api.g_exc_error;
727: END IF;
728:
729: END IF; -- item based, ib tracked and depreciable
730:

Line 745: WHEN fnd_api.g_exc_error THEN

741: debug('processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');
742: END IF;
743:
744: EXCEPTION
745: WHEN fnd_api.g_exc_error THEN
746: --null;
747: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
748: l_txn_error_rec.error_text := SQLERRM;
749: l_txn_error_rec.source_group_ref_id := l_conc_request_id;

Line 755: p_init_msg_list => fnd_api.g_true,

751: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
752: l_txn_error_rec.processed_flag := 'N';
753: csi_transactions_pvt.create_txn_error(
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_true,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: p_txn_error_rec => l_txn_error_rec,
759: x_return_status => l_return_status,

Line 756: p_commit => fnd_api.g_false,

752: l_txn_error_rec.processed_flag := 'N';
753: csi_transactions_pvt.create_txn_error(
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_true,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: p_txn_error_rec => l_txn_error_rec,
759: x_return_status => l_return_status,
760: x_msg_count => l_msg_count,

Line 757: p_validation_level => fnd_api.g_valid_level_full,

753: csi_transactions_pvt.create_txn_error(
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_true,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: p_txn_error_rec => l_txn_error_rec,
759: x_return_status => l_return_status,
760: x_msg_count => l_msg_count,
761: x_msg_data => l_msg_data,

Line 781: p_init_msg_list => fnd_api.g_true,

777: l_txn_error_rec.source_id := l_invoice_distribution_id;
778: l_txn_error_rec.processed_flag := 'N';
779: csi_transactions_pvt.create_txn_error(
780: p_api_version => 1.0,
781: p_init_msg_list => fnd_api.g_true,
782: p_commit => fnd_api.g_false,
783: p_validation_level => fnd_api.g_valid_level_full,
784: p_txn_error_rec => l_txn_error_rec,
785: x_return_status => l_return_status,

Line 782: p_commit => fnd_api.g_false,

778: l_txn_error_rec.processed_flag := 'N';
779: csi_transactions_pvt.create_txn_error(
780: p_api_version => 1.0,
781: p_init_msg_list => fnd_api.g_true,
782: p_commit => fnd_api.g_false,
783: p_validation_level => fnd_api.g_valid_level_full,
784: p_txn_error_rec => l_txn_error_rec,
785: x_return_status => l_return_status,
786: x_msg_count => l_msg_count,

Line 783: p_validation_level => fnd_api.g_valid_level_full,

779: csi_transactions_pvt.create_txn_error(
780: p_api_version => 1.0,
781: p_init_msg_list => fnd_api.g_true,
782: p_commit => fnd_api.g_false,
783: p_validation_level => fnd_api.g_valid_level_full,
784: p_txn_error_rec => l_txn_error_rec,
785: x_return_status => l_return_status,
786: x_msg_count => l_msg_count,
787: x_msg_data => l_msg_data,