181: IF p_location_id IS NULL
182: OR
183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
182: OR
183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
329: IF p_location_id IS NULL
330: OR
331: p_location_id = FND_API.G_MISS_NUM
332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
330: OR
331: p_location_id = FND_API.G_MISS_NUM
332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338:
342: FROM HZ_LOCATIONS
343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;
352:
356: IF(l_allow_update_std = 'N' AND
357: l_date_validated IS NOT NULL AND
358: l_validation_status_code IS NOT NULL)
359: THEN
360: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
361: FND_MSG_PUB.ADD;
362: RAISE fnd_api.g_exc_error;
363: END IF;
364:
562:
563: WHEN APP_EXCEPTION THEN
564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
563: WHEN APP_EXCEPTION THEN
564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,
749:
750: WHEN APP_EXCEPTION THEN
751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
750: WHEN APP_EXCEPTION THEN
751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
760:
761: WHEN OTHERS THEN
762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
761: WHEN OTHERS THEN
762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
870:
871: WHEN APP_EXCEPTION THEN
872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
871: WHEN APP_EXCEPTION THEN
872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
881:
882: WHEN OTHERS THEN
883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
882: WHEN OTHERS THEN
883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,