DBA Data[Home] [Help]

APPS.POS_SUPPLIER_BO_PKG dependencies on FND_API

Line 455: x_return_status := fnd_api.g_ret_sts_unexp_error;

451: IF p_party_id IS NULL THEN
452: l_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_orig_system,
453: p_orig_system_reference);
454: IF l_party_id IS NULL OR l_party_id = 0 THEN
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: x_msg_data := 'Unable to retrieve Party ID';
457: RETURN;
458: END IF;
459:

Line 703: WHEN fnd_api.g_exc_error THEN

699: x_pos_supplier_bo.p_hz_locations_bo := x_hz_locations_bo_tbl;
700: x_pos_supplier_bo.party_id := l_party_id;
701:
702: EXCEPTION
703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: x_msg_count := 1;
706: x_msg_data := SQLCODE || SQLERRM;
707: WHEN fnd_api.g_exc_unexpected_error THEN

Line 704: x_return_status := fnd_api.g_ret_sts_error;

700: x_pos_supplier_bo.party_id := l_party_id;
701:
702: EXCEPTION
703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: x_msg_count := 1;
706: x_msg_data := SQLCODE || SQLERRM;
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 707: WHEN fnd_api.g_exc_unexpected_error THEN

703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: x_msg_count := 1;
706: x_msg_data := SQLCODE || SQLERRM;
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: x_msg_count := 1;
710: x_msg_data := SQLCODE || SQLERRM;
711: WHEN OTHERS THEN

Line 708: x_return_status := fnd_api.g_ret_sts_unexp_error;

704: x_return_status := fnd_api.g_ret_sts_error;
705: x_msg_count := 1;
706: x_msg_data := SQLCODE || SQLERRM;
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: x_msg_count := 1;
710: x_msg_data := SQLCODE || SQLERRM;
711: WHEN OTHERS THEN
712: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 712: x_return_status := fnd_api.g_ret_sts_unexp_error;

708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: x_msg_count := 1;
710: x_msg_data := SQLCODE || SQLERRM;
711: WHEN OTHERS THEN
712: x_return_status := fnd_api.g_ret_sts_unexp_error;
713: x_msg_count := 1;
714: x_msg_data := SQLCODE || SQLERRM;
715: END pos_get_supplier_bo;
716:

Line 873: WHEN fnd_api.g_exc_error THEN

869: x_msg_count,
870: x_msg_data);*/
871:
872: EXCEPTION
873: WHEN fnd_api.g_exc_error THEN
874:
875: x_return_status := fnd_api.g_ret_sts_error;
876: x_msg_count := 1;
877: x_msg_data := SQLCODE || SQLERRM;

Line 875: x_return_status := fnd_api.g_ret_sts_error;

871:
872: EXCEPTION
873: WHEN fnd_api.g_exc_error THEN
874:
875: x_return_status := fnd_api.g_ret_sts_error;
876: x_msg_count := 1;
877: x_msg_data := SQLCODE || SQLERRM;
878: WHEN fnd_api.g_exc_unexpected_error THEN
879:

Line 878: WHEN fnd_api.g_exc_unexpected_error THEN

874:
875: x_return_status := fnd_api.g_ret_sts_error;
876: x_msg_count := 1;
877: x_msg_data := SQLCODE || SQLERRM;
878: WHEN fnd_api.g_exc_unexpected_error THEN
879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881: x_msg_count := 1;
882: x_msg_data := SQLCODE || SQLERRM;

Line 880: x_return_status := fnd_api.g_ret_sts_unexp_error;

876: x_msg_count := 1;
877: x_msg_data := SQLCODE || SQLERRM;
878: WHEN fnd_api.g_exc_unexpected_error THEN
879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881: x_msg_count := 1;
882: x_msg_data := SQLCODE || SQLERRM;
883: WHEN OTHERS THEN
884:

Line 885: x_return_status := fnd_api.g_ret_sts_unexp_error;

881: x_msg_count := 1;
882: x_msg_data := SQLCODE || SQLERRM;
883: WHEN OTHERS THEN
884:
885: x_return_status := fnd_api.g_ret_sts_unexp_error;
886:
887: x_msg_count := 1;
888: x_msg_data := SQLCODE || SQLERRM;
889: END pos_create_update_supplier_bo;