[Home] [Help]
171: ATTRIBUTE7,
172: ATTRIBUTE8,
173: ATTRIBUTE9,
174: ATTRIBUTE10
175: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
176:
177:
178: BEGIN
179:
269: * o Passed address1 to address4 to update_profile_pvt
270: * o Moved the call to update_location_pvt to outside
271: * the loop.
272: * o Updated the db_* variables to prevent unnecessary
273: * additional updates to HZ_LOCATIONS.
274: *
275: +===========================================================================**/
276: -- Removed following parameters since it id not used in the procedure
277: -- x_loc_id, p_created_by_module, p_application_id, x_org_id
318: ATTRIBUTE7,
319: ATTRIBUTE8,
320: ATTRIBUTE9,
321: ATTRIBUTE10
322: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
323:
324: BEGIN
325:
326: -- check the required fields:
336:
337: BEGIN
338: SELECT DATE_VALIDATED, VALIDATION_STATUS_CODE
339: INTO l_date_validated, l_validation_status_code
340: FROM HZ_LOCATIONS
341: WHERE LOCATION_ID = p_location_id;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN
344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
341: WHERE LOCATION_ID = p_location_id;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN
344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
345: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
346: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
347: FND_MSG_PUB.ADD;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: END;
392: IF l_loc_assg_exists = 'Y' OR p_do_addr_val = 'Y' THEN
393:
394: HZ_GNR_PKG.delete_gnr(
395: p_locId => p_location_id,
396: p_locTbl => 'HZ_LOCATIONS',
397: x_status => x_return_status);
398:
399: HZ_GNR_PKG.validateLoc(
400: P_LOCATION_ID => l_c_loc.LOCATION_ID,
427: -- Below code will execute only if there is no record in hz_loc_assignments table
428: -- process_gnr will process the GNR and return success even if there is an error
429: -- in the validation.
430: HZ_GNR_PUB.process_gnr (
431: p_location_table_name => 'HZ_LOCATIONS',
432: p_location_id => p_location_id,
433: p_call_type => 'U',
434: p_init_msg_list => 'F',
435: x_return_status => x_return_status,