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:
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
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;
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
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;
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:
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;
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:
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;
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:
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;