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