APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on HZ_LOCATION_V2PUB

Line 252: l_location_rec hz_location_v2pub.location_rec_type;

248: l_update_geo BOOLEAN;
249: l_call_lf BOOLEAN;
250: l_roadname hz_locations.address1%TYPE;
251: l_location_ovn NUMBER;
252: l_location_rec hz_location_v2pub.location_rec_type;
253: l_road VARCHAR2(200);
254:
255: CURSOR c_location_locking_info IS
256: SELECT object_version_number

Line 424: hz_location_v2pub.update_location(

420: CLOSE c_location_locking_info;
421:
422: -- Updating the location record (it updates both hz_parties and
423: -- hz_locations)
424: hz_location_v2pub.update_location(
425: p_location_rec => l_location_rec
426: , p_object_version_number => l_location_ovn
427: , x_return_status => x_return_status
428: , x_msg_count => x_msg_count

Line 705: l_location_rec hz_location_v2pub.location_rec_type;

701: l_api_version CONSTANT NUMBER := 1.0;
702: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_RESOURCE_PARTY_LINK';
703: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
704:
705: l_location_rec hz_location_v2pub.location_rec_type;
706: l_person_rec hz_party_v2pub.person_rec_type;
707: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
708:
709: l_profile_id NUMBER;

Line 765: hz_location_v2pub.create_location(

761: END IF;
762:
763: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
764:
765: hz_location_v2pub.create_location(
766: p_init_msg_list => fnd_api.g_false
767: , p_location_rec => l_location_rec
768: , x_return_status => x_return_status
769: , x_msg_count => x_msg_count

Line 776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

772: );
773: IF x_return_status <> fnd_api.g_ret_sts_success THEN
774: IF l_debug THEN
775: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
777: END IF;
778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;

Line 784: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);

780: END IF;
781: RAISE fnd_api.g_exc_error;
782: ELSE
783: IF l_debug THEN
784: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
785: END IF;
786: END IF;
787:
788: IF p_address.party_id IS NULL THEN