[Home] [Help]
963: l_location_id NUMBER;
964: l_ven_rec ap_vendors_v%ROWTYPE;
965: l_api_name VARCHAR2(50);
966: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
967: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
968: p_object_version_number NUMBER;
969: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
970: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;
971: l_ship_via_lookup_code financials_system_params_all.ship_via_lookup_code%TYPE;
1298: p_location_rec.province := NVL(p_state, l_vendorsite_rec.state);
1299: p_location_rec.county := NVL(p_county, l_vendorsite_rec.county);
1300:
1301: IF (l_Debug_Level <= 1) THEN
1302: itg_debug_pub.add('Calling hz_location_v2pub.update_location ');
1303:
1304: END IF;
1305: l_api_name := 'hz_location_v2pub.update_location';
1306: hz_location_v2pub.update_location
1301: IF (l_Debug_Level <= 1) THEN
1302: itg_debug_pub.add('Calling hz_location_v2pub.update_location ');
1303:
1304: END IF;
1305: l_api_name := 'hz_location_v2pub.update_location';
1306: hz_location_v2pub.update_location
1307: (
1308: p_init_msg_list => FND_API.G_FALSE,
1309: p_location_rec => p_location_rec,
1302: itg_debug_pub.add('Calling hz_location_v2pub.update_location ');
1303:
1304: END IF;
1305: l_api_name := 'hz_location_v2pub.update_location';
1306: hz_location_v2pub.update_location
1307: (
1308: p_init_msg_list => FND_API.G_FALSE,
1309: p_location_rec => p_location_rec,
1310: p_object_version_number => p_object_version_number,
1313: x_msg_data => l_ret_msg
1314:
1315: );
1316: IF (l_Debug_Level <= 1) THEN
1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');
1318: itg_debug_pub.add('l_return_status ' || l_return_status);
1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;