95:
96: IF p_csi_instance_geoloc_tbl(i).instance_id IS NULL
97: OR p_csi_instance_geoloc_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
98: IF p_asset_context = 'EAM' THEN
99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
100: ELSE
101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');
102: END IF;
103: FND_MSG_PUB.ADD;
97: OR p_csi_instance_geoloc_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
98: IF p_asset_context = 'EAM' THEN
99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
100: ELSE
101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');
102: END IF;
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: l_error_count:=l_error_count+1;
159: END IF;
160:
161: IF (l_instance_tbl.EXISTS(p_csi_instance_geoloc_tbl(i).instance_id)) THEN
162: IF p_asset_context = 'EAM' THEN
163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
161: IF (l_instance_tbl.EXISTS(p_csi_instance_geoloc_tbl(i).instance_id)) THEN
162: IF p_asset_context = 'EAM' THEN
163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
168: FND_MSG_PUB.ADD;
169: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
168: FND_MSG_PUB.ADD;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: l_error_count:=l_error_count+1;
171: RAISE FND_API.G_EXC_ERROR;
567: l_error_count := l_error_count + 1;
568: l_record_status:='E';
569: UPDATE csi_ii_geoloc_interface
570: SET process_flag = 'E',
571: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_GIS_DUP_INST_ASSET'),
572: process_date=sysdate
573: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
574: AND PROCESS_FLAG = 'R';
575: RAISE FND_API.G_EXC_ERROR;
586: l_error_count := l_error_count + 1;
587: l_record_status:='E';
588: UPDATE csi_ii_geoloc_interface
589: SET process_flag = 'E',
590: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INSTANCE_NOT_FOUND'),
591: process_date=sysdate
592: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
593: AND PROCESS_FLAG = 'R';
594: RAISE FND_API.G_EXC_ERROR;
608: l_error_count := l_error_count + 1;
609: l_record_status:='E';
610: UPDATE csi_ii_geoloc_interface
611: SET process_flag = 'E',
612: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INVALID_GEOCODE_FORMAT'),
613: process_date=sysdate
614: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
615: AND PROCESS_FLAG = 'R';
616: RAISE FND_API.G_EXC_ERROR;